Analyzed customer specifications and Involved in Design, Construction, Testing and deployment of Project.Actively involved in Database design to support the new and existing applicationWorked in finding manageable strategies to handle massive amounts of data (millions of records per day) in a production environment. The company and the nature of the environment impose strict use of best software designing principles and quality assurance practices.Sound Knowledge of data model, materialized views ,SQL Queries, SQL Query tuning process. Worked with bulk collect and collections to implement the performance of multi row queries.Developed parallel data processing procedures, functions, triggers, packages using PL/SQL modules and analytical SQL queries for reports.Design and develop ETL scripts/packages using Oracle PL/SQL (Procedure, Views, Packages, materialized views) to load the data into the warehouse.Created/updated ETL procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts with Business Intelligence reporting layers. Prepared/updated shell scripts for ETL to run in batch.Schedule Parallel PL/SQL programs using oracle Apps Concurrent Programs scheduler and Oracle Job scheduler .Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.Good experience in indexing, performance tuning and database triggers.Worked on creation and processing of XML using the XML Developer’s Kit (XDK) to read and generate XMLs. Experiencing in working with Oracle supplied APIs (DBMS_LOB, DBMS_XMLGEN, DBMS_UITILITY).Experience of working in Retails Banking and Manufacturing domains. Experience in Agile/Scrum/Waterfall.Experience in Project/Release Management, Vendor and People Management.Experience in tools like Rally, TOAD, KINTANA, PVCS, SVN, & HP Quality Center.Excellent working knowledge of Agile, SDLC process, client management, and client interfacing skills.

Analyzed customer specifications and Involved in Design, Construction, Testing and deployment of Project.Actively involved in Database design to support the new and existing applicationWorked in finding manageable strategies to handle massive amounts of data (millions of records per day) in a production environment. The company and the nature of the environment impose strict use of best software designing principles and quality assurance practices.Sound Knowledge of data model, materialized views ,SQL Queries, SQL Query tuning process. Worked with bulk collect and collections to implement the performance of multi row queries.Developed parallel data processing procedures, functions, triggers, packages using PL/SQL modules and analytical SQL queries for reports.Design and develop ETL scripts/packages using Oracle PL/SQL (Procedure, Views, Packages, materialized views) to load the data into the warehouse.Created/updated ETL procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts with Business Intelligence reporting layers. Prepared/updated shell scripts for ETL to run in batch.Schedule Parallel PL/SQL programs using oracle Apps Concurrent Programs scheduler and Oracle Job scheduler .Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.Good experience in indexing, performance tuning and database triggers.Worked on creation and processing of XML using the XML Developer’s Kit (XDK) to read and generate XMLs. Experiencing in working with Oracle supplied APIs (DBMS_LOB, DBMS_XMLGEN, DBMS_UITILITY).Experience of working in Retails Banking and Manufacturing domains. Experience in Agile/Scrum/Waterfall.Experience in Project/Release Management, Vendor and People Management.Experience in tools like Rally, TOAD, KINTANA, PVCS, SVN, & HP Quality Center.Excellent working knowledge of Agile, SDLC process, client management, and client interfacing skills.