SUMMARY

• Over 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Developing, Testing, and Implementation (SDLC) phases.
• Expertise using Online Analytical Processing (OLAP), Online Transaction Processing (OLTP) projects.
• Experienced in interacting with Business Users, Business Analyst, Project Managers, and Developers to gather requirements and translating requirements to technical design specifications and source to target mappings.
• Extensive experience in designing and developing applications in oracle. Implemented oracle objects like Tables, Views, Sequence, Synonym, index, partitions and materialized views.
• Good experience in core pl/sql development. Implemented pl/sql objects like Stored Procedures, functions, packages, Triggers, Exceptions, Cursors, Ref Cursors, Collections and bulk procedures.
• Very good experience in improve performance of queries. Using Explain Plan, Indexing, Applying Hints, Bulk Collect, For All, Analyzing Tables, Creation of global temporary tables (GTT) and partitioning.
• Implemented bulk programming and for all technics to improve the performance of the procedure executions.
• Extensive experience in developing Data Extraction, Data Transformations, Data Loading (ETL) projects.
• Good experience in developing Data warehouse projects using Source, Pre - Stage, Stage, and Target tables.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model for star schema dimension tables.
• Experience in creating SQL*Loader control files to load data from flat files into the Pre-Stage tables.
• Extreme Use of Exception Handling methods along with PRAGMA EXCEPTION INIT in order to associate user defined exception names.
• Experience in using several built-in database packages such as DBMS OUTPUT, UTL FILE, and DBMS SQL.
• Extensively worked with third party database tools like Sql Developer, Toadand Pl/Sql Developer.
• Good experience with UNIX and created UNIX scripts to automate oracle stored procedures and packages.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i

Languages & Tools: SQL, PL/SQL, C, SQL*Loader, Unix

Operating Systems: Windows 7/XP/NT, UNIX

Version Control Tools: SVN, Clear Case, Visual Source Safe (VSS)

Data Analysis Tools: Toad, Pl/Sql Developer, Sql Developer

Concepts: OLAP, OLTP

Applications: MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Buffalo NY

Pl/SQL Developer

Responsibilities:

• Experienced in interacting with Business Users, Business Analyst, Project Managers, and Developers to gather requirements and translating requirements to technical design specifications and source to target mappings.
• Designed and Developed database objects like tables, views, indexes, procedure, functions and packages.
• Involved in Performance Tuning, which included creating Indexes, Providing Hints, Modifying Tables, Analyze Tables and Estimate Stats using Explain plan utility.
• Extensive experience in developing Data Extraction, Data Transformations, Data Loading (ETL) projects.
• Good experience in developing Data warehouse projects using Source, Pre-Stage, Stage, and Target tables.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model for star schema dimension tables.
• Involved in changing the existing static report generating Procedures and Packages to Dynamic Procedures to support from multiple schemas.
• Created/modified oracle procedures, packages and functions to move the change data across multiple environments using Database links.
• Interacted with front end developers and worked accordingly to facilitate report requirements.
• Developed automated scripts to execute pl/sql packages and procedures.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, MS Access, Toad, Windows 7/2003

Confidential, Chicago

Sr. Oracle Pl/Sql Developer

Responsibilities:

• Experience in SDLC development life cycle. Working with business users to understand their reporting needs.
• Experience with providing support to existing reports and implementing performance solutions to existing reports.
• Created queries, procedures, functions for new reports based on the analysis documents provided by business analysts.
• Loaded the data into database tables using SQL*loader from TXT and CSV files.
• Wrote SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Developing Oracle objects such as Tables, Views, Indexes, Synonyms, Materialized views, Sequences, Cursors, Partitions, and Dynamic SQL.
• Worked for supporting existing report fixes in creating Packages, Functions, Procedures, views, exceptions etc.
• Extensive experience in developing Data Extraction, Data Transformations, Data Loading (ETL) projects.
• Good experience in developing Data warehouse projects using Source, Pre-Stage, Stage, and Target tables.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model for star schema dimension tables.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Performing source system analysis, Designing and developing reports using Pl/Sql.
• Solutions satisfy Clients business requirements and delivered in a timely manner and providing ongoing support for the reporting environment.

Environment: PL/SQL, ORACLE 10g, SQL*Loader, SQL*Plus, UNIX Shell scripting, Data warehouse

Confidential - Bismarck, ND

Sr. Oracle Developer

Responsibilities:

• Worked with the Business analysts and Business users for requirements gathering, metrics and project coordination.
• Experience in preparing source to target mappings and design documents using Data Warehouse Dimensional modeling.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Good experience in developing ETL procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Involved in design, developing Logical Modeling and Physical Modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from txt and CSV files.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed Shell Wrapper Scripts to automate execution of SQL Scripts.
• Worked with other developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning using various technics like analyzing, indexing, providing hints, executing statsand explain Plan.
• Developed UNIX Shell scripts to automate Table Creation, Execute procedures and Created oracle objects for OLAP.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, Korn Shell script, SQL Developer.

Confidential, Grand Rapids, MI

Oracle developer

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Implemented Complex business Logic as per the client requirement in procedures, functions, packages.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Creation of database objects like Tables, Views, Indexes, Synonyms, Materialized views, stored procedures, and Packages.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Wrote SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and EXPLAIN PLAN.
• Involved in Data migration from Production to test and created test data for analyzing problems, providing solution.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Managed problems, enhancement, and new functionality requests to meet changes in the business needs.

Environment: Oracle 11g, SQL, PL/SQL, Toad, ERWIN, ETL, SQL*Loader, SQL*Plus, UNIX, Windows XP, Clear Case.