SUMMARY:

• Database developer with 8+ years of experience in application design, development, testing, implementation and maintenance.
• Extensive knowledge of Oracle 7i/8i/9i/10g/11g, RDBMS concepts, including ETL process and ETL tools like Oracle Warehouse Builder, Informatica, Data Stage, as well as experience in extraction, transformation and loading from multiple sources into data warehouses.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
• Developed Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Extensively worked on Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints.
• Well experienced in creating detailed design and technical design documents and worked with project management teams and business stakeholders to make modifications.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:

Methodologies: Star Schema, Snowflake Schema

Programming: Visual Studio 6.0, C, C++, Visual Basic 3.5/6.0,PL/SQL

Internet Technologies: HTML, XML & VBScript

Database: Oracle 7i/8i/9i/10g/11g

Operating Systems: MS-DOS, Windows NT/2000/ XP Pro, UNIX

Other Tools: Toad, SQL Loader, PL/SQL Developer, Tortoise SVN, Informatica Power Center 8.6.X/6.1, Datastage

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Data Modelling Tools: Erwin 4.5/4.0/3.5, Microsoft Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, MI

Consultant

Responsibilities:

• Gathered requirements from client and translated business details into Technical design document.
• Designed and developed Star Schema model for data warehouse.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Experience in performance and tuning (PL/SQL) using Cursor Variable, Bulk Collect/Bind, Apply Index and Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF
• Implemented Partition and sub partition concepts to fine tune Data Load and Data retrieving from Fact table with 2.5 Billion records.
• Involved in project planning, coordination and implementation of QA methodology.
• Designed and Developed Water fall ETL approach in PL/SQL to load incoming files efficiently into warehouse.
• Created pl/sql stored procedures, functions and packages for moving the data from Files to ETL staging area and then to Star Schema.
• Extensively used the advanced features of PL/SQL like records, tables, object types and dynamic sql.
• Developed and Implemented Encrypting Process for Secure data.
• Performed sql and pl/sql tuning and application tuning using various tools like explain plan, sql trace, tkprof.
• 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.
• Coordinated with different teams to smoothly migrate the code to QC or Production environments.
• Supported between developers and end users, functional managers and Oracle regarding issues with the database software,

Confidential, KY

Consultant

Responsibilities:

• Developed, presented and implemented several Proof of Concepts to save load timings during ETL process; designed, developed and implemented several PL/SQL packages to load more than 1B records from multiple files.
• Confidential heavily used Oracle Warehouse Builder for ETL but because of performance issues I had an opportunity to re-write entire ETL process using PL/SQL.
• Created Oracle database objects including tables, views, synonyms, materialized views, partitions and PL/SQL objects such as procedures, functions and packages to implement ETL Data flow.
• Redesigned several sequential jobs to run in parallel; Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Design and implement Oracle Database indexing and partitioning strategy to process and query large volumes of data.
• Developed and implemented common utility package to avoid recoding for auditing, error handling, gathering statistics and index maintenance.
• Prepare detailed design and technical design documents and work with project management teams and business stakeholders to make modifications.
• Resolve production data load problems, support daily/weekly/monthly data loads and track and resolve performance issues.

Confidential, NY

Consultant

Responsibilities:

• Interacted with Subject Matter Experts (SME) to gather Business Requirements for the application, through one-on-one interviews as well as JAD sessions with development teams.
• Involved in gathering requirements through reverse engineering process.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Tuned multiple long running monthly loads to minimize the load time, including a warehouse redesign which reduced load time from 2 Days to 7 hours.
• Developed process to load flat files coming from Up-stream systems into Oracle using External Tables.
• Designed competent PL/SQL programs using PL/SQL collections, record types, and Object types.
• Supported data migration from different tables to data warehouse; designed and developed partition concepts for ETL data loads; maintained legacy, legacy incremental and monthly load processes; created procedures to implement ETL functionality with Oracle for Dimension and fact loads.
• Helped QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.

Confidential, NY

Consultant

Responsibilities:

• Gathered the requirement from the client and translated the business details into Technical design document.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Involved in project planning, coordination and implementation of QA methodology.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Analyzed manual systems and developed process flows for activities.
• Performed business process mapping/Data mapping for change requests and new requirements.
• Expert in utilizing Sub query, Co-related Query, Derive table, Join, Merge, Union, Union All, Except, Pivot, Un Pivot, Temp Table, Table Variable, CTEs, and Cursor in SQL queries.
• Generated PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Worked with Informatica team to fine tune mappings, Transformations and also supplied several complex PL/SQL API’s to support Informatica workflow.
• Created database triggers for data security.

Confidential

Programmer

Responsibilities:

• Wrote Procedures for conversion of data from one schema to another schema.
• Created database objects like tables, views, synonyms, indexes, rules and defaults.
• Development of Stored Procedures/Functions to meet the business requirements.
• Supported Data stage projects with PL/SQL API’s.
• Well versed with Oracle RDBMS, PL/SQL programming.
• Responsible for developing PL/SQL packages, procedures and functions whenever necessary.
• Handled calls with offsite DB team for discussions and understanding requirements.
• Created change documents for record and tracking.
• Data loading into tables.
• Unit testing of the procedures.