3 years of strong professional experience in Data Base Design, Data ware house, Application Development using oracle 12c/11g, SQL, PL/SQL, Oracle Data Integration Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
Excellent proficiency in Data Extraction, Transformation and Loading, Database modeling and data ware housing tools and technologies.
Strong technical expertise in create and maintaining database objects – Tables, Views, Materialized Views, indexes, Sequences, Synonyms, Database triggers.
Proficient in Oracle utilities and tools – SQL*loader, Export/Import, SQL*plus, SQL Developer, Toad, DataGrip.
Expertise in Performance tuning and query optimization using various types of hints, partitioning, bulking techniques and indexes Profound experience in tuning SQL queries using utilities like EXPLAIN PLAN, SQL trace and TKPROF to improve the performance.
Strong experience in ETL data loading techniques like UTL_FILE, SQL loader, copy
command and external tables from various business source environments.
Creating test cases for System Testing (Development Environment), Integration Testing
(UAT) and Production (Post Implementation Review).
Review of the performance testing results and providing input to the testers or Production
support team.
Impact Analysis for change requests from client.
Attaining daily status meeting and other meetings with end client to take proper clarifications.
Supported the testing team with Defect Management, Requirement Analysis and SQL
development for back-end and regression testing.
Optimized the Oracle PL/SQL queries by Performance Tuning.
Worked on enhancement of existing pipelined functions and packages.
Testing codes developed by self and team.
Bug Fixing while in Production with top priority.
Exposure in Oracle Application in 12.2.4(AP, AR, GL, PO, INV, OM)