SUMMARY

• Over 11+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in SQL and PL/SQL programming, developing complex code units.
• Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on External Tables.
• Expertise in Dynamic SQL and Exception handling.
• Experience in SQLperformance tuning.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience with Scrum and Agile methodologies.
• Extensive Experience with Production deployment and extensive support activities .
• Understanding of AWS features EC2, S3 and RDS

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c (SQL, PL/SQL, Stored Procedures, And Triggers), Postgres

ETL Tools: SQL*Loader, External Table, SSIS

Reporting Tools: MSBI

Operating Systems: SSIS, Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL, TOAD,PGSQL

PROFESSIONAL EXPERIENCE

Confidential

Lead PL/SQL Developer

Responsibilities:

• Technical analysis of the feature and documentation.
• Communicating with client and teams for gathering requirements.
• Coordinating with team and assigning tasks.
• Developed packages, functions, and stored procedures for various functionalities.
• Code review with team.
• Involved in testing, debugging and production support.
• Worked on Performance enhancements used hints, with clause and partition pruning.
• Created run books for the Ctrl-M jobs.

Confidential, Louisville, KY

PL/SQL Developer

Responsibilities:

• Created mapping documentation.
• Developed and modified triggers, packages, functions and stored procedures for data conversions
• PL/SQL procedures to create database objects dynamically based on user inputs.
• Created Materialized Views and Mviews logs .
• Created and scheduled chain jobs .
• Worked on External table to load data from flat files obtained from various facilities and send the raw data to customer as per their requirement.
• Troubleshoot and tune complex database query performance issues.
• Worked in SSIS and SQL Server Agents to call the packages in oracle and schedule the run.
• Involved in pre & postproduction support to resolve the issues.

Confidential, San Diego, CA

PL/SQL Developer

Responsibilities:

• Research on Oracle to Postgres Migration Considerations, Hurdles, and possible Solutions.
• Created and migrated oracle objects to Postgres
• Created new tables, procedures, functions on Postgres
• Created python script to migrate data from Oracle to Postgres DB.
• Researched on the features not available in Postgres and created work abounds.
• Created EC2 instance and DB in AWS Aurora .

Confidential, San Diego, CA

PL/SQL Developer

Responsibilities:

• Responsible for designing, developing, and maintaining data warehouse.
• Design and implement ETL procedures for intake of data from both internal and outside sources.
• Carry out monitoring, tuning, and database performance analysis.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW).
• Developed mapping document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Exclusively worked with Views, Synonyms, procedures/Functions and Packages in Oracle PL/SQL to build business rules.
• Responsible for ETL Code walkthrough and Knowledge Transfer at all stages.
• Created scheduler Chain Job to run the ETL Process as per the dependency.
• Involved in pre & postproduction support to resolve the issues.

Confidential, San Diego, CA

PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on UTL FILE to load data from Oracle tables to flat files
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for logging audit detail on configuration tables.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle.
• Extensively used the features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Added Emailing feature in case of any failures in Datafeed process.
• Involved in pre & postproduction support to resolve the issues.

Confidential

PL/SQL Developer

Responsibilities:

• Created mapping documentation.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Worked on External table to load data from flat files obtained from various facilities and send the raw data to customer as per their requirement.
• Troubleshoot and tune complex database query performance issues, interfaced with ERP systems like SAP,PKMS,and Vision.
• One of the key of this project was we were able to complete and deliver the project without any production issues, way before the deadline.