Extensively work experience in Oracle 11g SQL, PLSQL programming, Data Warehousing Development
Writing SQL, PLSQL procedures, Functions, Triggers, REF Cursor and Packages as per business requirements.
Good understanding of ETL process dimensions (Star and Snow-flake Schemas), OLAP and Data modeling hierarchy data.
Writing Unix Shell Scripting firing – more... SQL/PLSQL, ETL for flat files uploads(SQL*loader) from various source system
Certify all queries written by software developers(Java team) to ensure optimal execution of the queries
Packaging up codes for release into production and maintains DB version controlling
Diagnosis and resolution of defects found during QA and UAT test phases
Direct Interactions with Clients and Handling ad hoc Issues on the implemented Modules.
Gathering and documentation of customer’s requirements
Drafting various technical specification documents like operation manuals.
Involved in the design, documentation, and development, testing, cleansing data and loading it at client locations.
Performed DBA activities like (Restore/Backup of databases (Import/Export), Granting privileges roles to the concerned users. Database Performance issue on the server and enhancing the same).
Understanding Functional requirements and ability to translate the same into workable solution.
Co-ordination with product management / development for product enhancements and bug fixes. – less