SUMMARY:

• Focused PLSQL Developer , offering close to 5 years of full life - cycle implementation experience as an Oracle PL/SQL Developer in from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery against aggressive deadlines in Oracle Relational Database Management System (RDBMS) and hands-on skills in information technology.
• Flexible developer with extensive knowledge in providing hands-on guidance to DW Integration/Migration of DW projects with Star, Snowflake schemas. Strong understanding of Fact tables, Dimension tables, Logical and Physical Data Modeling, Normalized/De-normalized tables, Data marts, and Data mappings.
• Self-motivated, excellent analytical and programming skills, ability to go to the core of the problem having good work ethics with excellent communication & interpersonal skills. Good team player and ability to master new technologies quickly.
• Technically proficient; thrive in environments that constantly embrace new technology.
• Expertise in application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
• Created Tables, Views, Constraints, Indexes, Synonyms, Sequences, and materialized views for data replication in distributed environments. Loaded Data into Oracle Tables using SQL Loader. Experience in Oracle supplied packages, Records and PL/SQL Tables.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Effectively made use of Indexes, Hints, Table Functions, Table Partitioning, Collections, Analytical functions, Materialized Views, Index, Synonyms and Views.
• Expertise in Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO) related features such as Explain Plan, HINTS, Query Optimizer, Execution Plans and Indexes.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab scheduling.

TECHNICAL ACUMEN:

Oracle: 11g/10g/9i/8i | PL/SQL | SQL *PLUS | TOAD | SQL*LOADER | CBO | Explain Plan | Hints | Query Optimizer | Execution Plans | Table Functions | Crontab Scheduling | Logical and Physical Data Modeling |

Agile Methodology: Daily Scrums

SQL Developer: 4.0, PL/SQL Developer 7.1.5 | SQL Server 2000 | TOAD 8.5/9.6, AIX/Linux Shell

Scripts: Netezza - NZSql, NZLoad, External Tables, Stored Procedures, M-Views, Window Analytical Functions, Zone Maps/CBT, Query Performance, Data/Processing Skews, Encrypting Data, Temp Tables

Tortoise: SVN | WinCVS 2.0 | Subversion 1.6

Appworx: Scheduler | Autosys | Tidal Enterprise Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle PLSQL Developer

Responsibilities:

• Worked on SQL*Loader to load data from flat SAT files obtained from various facilities every day.
• Written Sql processes to transform OD into metrics data and load into aggregated tables.
• Created and modified UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Script to create Daily, Weekly and Monthly reports that is shared with the business team.
• Involved in the continuous enhancements and fixing of production problems.
• Performed detailed Impact analysis on existing batch failures that downloads data to the stores.
• Modified PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Modified existing indexes to change/add columns on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Confidential, Chicago, IL

Oracle PLSQL Developer

Responsibilities:

• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Script to process the incoming files on daily basis in loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types.
• U t ili ze d va rio u s ut ili t i e s s u c h a s E x p l a i n P l a n, T K - P rofil e, a n d DB M S S T A T S i n tu nin g t h e SQL interfaces .
• Strategized the design, code, and system/unit test plan reviews to enhance project quality.

Confidential

PLSQL Developer

Responsibilities:

• Created Confidential, Confidential, and Unit Testing, SIT, UAT and Implementation plan documents.
• Demons tra ted p ro f iciency i n p la nning a nd es tab lis hin g s tor ed p ro cedures, f u nction s, a nd p a cka ges to extract, loa d, a nd f or ma t the d a ta f ro m d iv ers e mod u les to crea te va rio u s ex tra ct f iles .
• Modified existing SQL, PL/SQL common scripts to enhance and handle error messages.
• Written complex SQL queries for data mining, data analysis and data profiling.
• Strategized the design, code, and system/unit test plan reviews to enhance project quality.

Confidential, Greensboro, NC

PLSQL Developer

Responsibilities:

• Analyze Mappings and Developed Pl/SQl scripts and triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Work with Data Modelers to set up a DDL change implementation process.
• Developing code for the reports and workflow using Oracle PL/SQL and designing the report layout using Crystal Report XI tool.
• Work with project team to design application/database connectivity.
• Create Database layout and schema for the .NET application in scope.
• Work with customer to load data from back end applications.
• Work with project team to design queries for substitution algorithms.
• Work with project team during development and testing.
• Work with project team during deployment of the application to production.

Confidential, Atlanta, GA

PLSQL Developer

Responsibilities:

• Created schema and report objects like Transformations, templates, prompts and metrics.
• Created Confidential, Confidential, and Unit Testing, SIT, UAT and Implementation plan documents.
• Design, development, unit testing of SQL processes used to transform, scrub the daily supply chain operation starting from forecasting and planning.
• Converted existing PL/SQL processes to process data within Staging DB and load into reporting Data Mart.
• Written Sql processes to transform OD into metrics data and load into aggregated tables.
• Written complex SQL queries for data mining, data analysis and data profiling.
• Test and Implement the process and the table with help from QA and Operations group.

Confidential, Milford, CT

PLSQL Developer

Responsibilities:

• Design, development, unit testing of SQL processes used to transform, scrub the daily and monthly processes.
• Created Confidential, Confidential, and Unit Testing, SIT, UAT and Implementation plan documents.
• Converted existing PL/SQL processes to process data within Staging DB and load into reporting Data Mart.
• Written Sql processes to transform OD into metrics data and load into aggregated tables.
• Written complex SQL queries for data mining, data analysis and data profiling.
• Test and Implement the process and the table with help from QA and Operations group.