PROFILE

• 10 years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Designing, Coding, Development, Testing and Implementation of Business applications with RDBMS, Data Warehouse/Datamarts, ETL, OLAP, Client/Server environment applications
• 10 years of Database experience using Oracle 11gR2/10g, Oracle 9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2005/2000/7.0/6.5, Sybase 12.x/11.x, MS Access 7.0/2000, XML, XSL, PL/SQL, SQL Plus, SQL Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x. Strong Experience to databases SQL, PL/SQL, SQL PLUS, SQL Loader, DBMS Packages, TOAD ODBC interfaces to Oracle
• 9 years of strong experience in Data Warehousing and ETL using Oracle Warehouse Builder 11gR2, Informatica 9.1/8.6, Oracle warehouse builder 10gR1/R2, Oracle 9i Warehouse Builder, OMB Plus, Oracle Work Flow Manager, Oracle Enterprise Manager 9.2, Oracle Data Integrator, ETL, ETI, Datamart, OLAP, OLTP.
• 9 years of experience working on End-To-End implementation of Data warehouse and Strong understanding of Data warehouse concepts, ETL, Star Schema, Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT Dimensions tables, Physical logical data modeling, Erwin 7.x/4.5/4.x/3.0.
• Profound experience in performing all functions of System Development Life Cycle including writing Design documents and Test plans and conduct Unit and System testing.

TECHNICAL SKILLS

PROFESSIONAL SUMMARY:

Confidential

SR. OWB/ ETL DEVELOPER

Responsibilities:

• Involved in building Reporting Datamart for Consolidated Assistance Support System CASS project that delivers a single integrated application on healthcare eligibility system utilizing Curam Software.
• Created data mapping documents to map target data elements with the source
• Created technical Specification documents to define ETL transformations based on business logic
• Used Dimensional modelling to load data into datamart in the form of dimensions and facts
• Design and setup of ETL environment for development, Systemtest, UAT and production
• Installed and configured Oracle Warehouse Builder Client Server architecture for Development, UAT and Production environments
• Created OWB mappings load source data into reporting environment
• Developed PL/SQL packages, procedures and functions based on reporting requirements
• Created OWB process flows to execute mappings, PLSQL procedure and Shell Scripts in desired order
• Designed and created ETL process to load the incremental data on a daily basis
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated nightly load window.
• Developed Slowly Changing Dimensions to capture new changes while maintaining historical data
• Developed Views and Materialized Views to create accumulated data based on the detail facts
• Performed migration activities to migrate ETL code between different environments
• Created jobs in Autosys to schedule OWB process flows with process dependencies.
• Supported and fixed several defects related to reports and ETL for different UAT releases.
• Tuned ETL code and PLSQL package to load huge volume of data from legacy systems
• Used Explain Plan and Tkprof utility to trace and tune the slow moving processes
• Created OMBPlus script to deploy and execute OWB mappings and process flows from unix
• Extensively performed unit testing for PLSQL code and OWB mappings documenting testing results.
• Identified and deployed critical updates to ETL mappings with minimal turnaround time.
• Provided production support to monitor production runs and nightly ETL loads through job logs.
• Created Production Go Live tasks document and recovery plan to support deployment activities
• Developed reconciliation process to validate completeness of data between data mart and sources
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Extensively used the Oracle Analytic functions to develop and enhance existing procedures to meet the custom requirements of the client.
• Created error trapping mechanism for all the PLSQL code and OWB mappings in case of failure.
• Extensively used OWB Runtime Audit Tables to analyze the statistics generated by executing the mappings and process flows.
• Developed reports in Business Objects based on user requirements
• Analyzed reports in Business Objects to resolve data issues raised by users

Evironment: Oracle Warehouse Builder 11gR2, Oracle Database 11GR2, SQL Server 2005, Sybase Database, Autosys, OMB Plus, PL/SQL, SQL Loader, TOAD, SQL Developer, Business Objects, Oracle Warehouse Audit Browser, Unix Shell Scripting, Sun Solaris 10, Windows NT

Confidential

SR. DW INFORMATICA/OWB LEAD

Responsibilities:

• Developed ETL mapping in Informatica based on the existing Oracle Warehouse Builder code as the client was moving from OWB to Informatica for ETL platform.
• Involved in building Fiduciary Datamart to consolidate fiduciary data into a common data warehouse
• Integrated AS400 Premiums and Claims legacy data into an existing Premium and Claim data mart
• Involved in loading Oracle Claim System Legacy data to global Enterprise Repository
• Worked with Business Analysts for business analysis and requirement gathering
• Created and ETL Technical Specification documents , Source to Target Mapping documents and Unit Test plans for the project ETL logic
• Designed and developed mappings, transformations, sessions and workflows in Informatica Power Center to extract data from heterogeneous data sources such as AS400, SQL Server, Oracle, Sybase, Excel sheets, Flat files
• Created Unix Shell Script to FTP the source files into the target locations and used SQL Loader and Oracle External Tables to load into the database.
• Created PL/SQL procedures, functions and packages as per the design document
• Used Dimensional Model to load data into Oracle 10G Database in the form of dimensions facts
• Implemented incremental loading process while loading huge amount of data into facts
• Developed Slowly Changing Dimensions to capture new changes while maintaining historical information
• Tuned Informatica mappings and PL/SQL procedures by defining hints, degree of parallelism, tweaking loading parameters and executing them in parallel threads.
• Prepared Audit scripts to check the validity of dimensional keys in Facts after each load
• Managed and Lead offshore development team for enhancements and issues related to data marts
• Assisted in test phase application support as required for QA activities
• Developed Views and Materialized Views to create accumulated data based on the detail facts
• Extensively performed Unit testing for PLSQL code and OWB mappings documenting all the testing results.
• Involved in Performance Tuning process to tune and optimize ETL code to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Worked with DBA's in utilizing Explain Plan and Tkprof utility to trace and tune the slow moving processes
• Involved in Production trouble shooting, program debugging and testing, and monitoring nightly ETL production mappings through audit and runtime log tables
• Involved in creating different workbooks and reports in Cognos

Evironment: Informatica 9.0 , Oracle Warehouse Builder 11g, Database 11G/10g, SQL Server 2005, Sybase Database, OMB Plus, PL/SQL, SQL Loader, SQL Developer, Cognos 8.1 BI, Unix Shell Scripting, IBM AS/400, IBM DB2, Sun Solaris 10, Windows NT

Confidential

SR. DW OWB/ODI DEVELOPER

Responsibilities:

• Involved in building Medicaid Data Warehouse which contains eight Terabytes of data
• Created several documentation and involved in gathering of mapping specifications based on interactions with data architect and reporting team
• Created Source to Target Mapping documents and ETL Specification documents.
• Created different environments to support development activities across different data marts
• Developed various Oracle Stored Procedures, Functions, and Packages using PL/SQL as per the design Documents
• Created shell scripts that were built to call custom procedures and report errors
• Created complex scheduling and control mechanism to detect, track and audit the sources
• Developed ETL staging area that provided platform on which data can be audited and validated before loading it to the target database.
• Developed ETL process to extract the data from different types of sources - flat files, database, Enterprise Service Bus ESB and message queues.
• Developed many OWB mappings to populated the dimensions from various subject areas
• Developed OWB mapping to populated larger fact tables 200 million rows
• Created process flows to execute all the mappings, PL/SQL procedures and shell scripts together and in desired order.
• Used Oracle Data Integrator to schedule OWB mappings and process flows.
• Extensively performed unit testing for PLSQL code and OWB mappings documenting all testing results.
• Created error trapping mechanism for all the PLSQL code and OWB mappings in case of failure.
• Involved in the process of migrating code and OWB MDL objects from development to test and to production using OMB Plus
• Tuned and optimized mappings and PLSQL code to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Used Explain Plan and Tkprof utility to trace and tune the slow moving processes
• Identified and deployed critical updates to ETL mappings with minimal turnaround time.
• Monitor production runs and nightly ETL loads through job logs.
• Developed Slowly Changing Dimensions to capture new changes while maintaining historical information
• Used Control Center Manager to deploy and execute all mappings and process flows
• Assisted in test phase application support as required for QA activities
• Involved in Production trouble shooting, program debugging and testing, post -implementation review of new/changed applications.
• Tuned OWB mappings and PL/SQL procedures by defining hints, degree of parallelism, tweaking loading parameters and executing them in parallel threads
• Extensively used Runtime Audit Browser to analyze the statistics generated by executing the mappings and process flows.

Environment: Oracle Warehouse Builder 11g, Oracle Data Integrator 11g, Oracle Database 11g, Sybase Database, Oracle MetaBase Plus OMB Plus , PL/SQL, SQL Loader, TOAD, SQL Developer, Tool Command Language TCL , OBIEE, Oracle Warehouse Audit Browser, Oracle Workflow Manager, Unix Shell Scripting, IBM DB2, Sun Solaris 10, Windows NT

Confidential

SR. DW OWB ETL LEAD/PRODUCTION SUPPORT

Responsibilities:

• Involved in building Revenue Data mart, Premiums Data mart and Claims Data mart
• Installed and configured Oracle Warehouse Builder Client Server architecture for Development, UAT and Production environments
• Created Technical Specification documents and Unit Test plans for the project ETL logic
• Involved in the documentation and gathering of mapping specifications based on interactions with data architect and reporting team
• Wrote PL/SQL procedures, Unix Shell scripts and created mappings and process flows in Oracle Warehouse Builder OWB to extract data from heterogeneous data sources such as AS400, SQL Server, Oracle, Sybase, Excel sheets, Flat files
• Prepared Audit scripts to check the validity of dimensional keys in Facts after each load
• Developed reconciliation process to validate completeness of data between data mart and sources
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated 6 hour nightly load window.
• Lead offshore development team for enhancements and issues related to data marts
• Implemented incremental loading process while loading huge amount of data into facts
• Monitored nightly ETL production mappings through audit and runtime log tables.
• Presented a proof of concept on OWB split repository architecture environment to the client and provided recommendations while implementing the design
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Implemented an inherent OWB version control mechanism to track mapping changes and used OWB Snapshot capability and Change Manager to address client's needs.
• Developed Views and Materialized Views to create accumulated data based on the detail facts
• Assisted in test phase application support as required for QA activities
• Involved in Production Troubleshooting and environments refresh activities
• Developed and implemented Unix Shell scripts and OMB Plus scripts to migrate PL/SQL packages and OWB metadata between different environments Development, QA and Production

Environment: Oracle Warehouse Builder 10g R2, SQL Server 2005, Sybase Database, OMB Plus, PL/SQL, SQL Loader, SQL Developer, Cognos 8.1 BI, Oracle Warehouse Audit Browser, Unix Shell Scripting, IBM AS/400, IBM DB2, Sun Solaris 10, Windows NT

Confidential

INFORMATICA DEVELOPER/PRODUCTION SUPPORT

Responsibilities:

• Responsible for detailed analysis and design of business application systems and programs which includes data analysis, documenting processing flow, defining inputs outputs and assisting in projects task planning.
• Development of standard definition. This includes programming, testing, documentations standards as well as naming conventions and reporting standards.
• Created Unix Shell Script to FTP the source files into the target locations and used SQL Loader and Oracle External Tables to load into the database.
• Created PL/SQL functions, procedure, and packages to transform the source data into staging tables and load into target tables. Handled the errors in functions and procedure by logging it into the runtime repository.
• Developed complex mappings in Informatica to load the data from the various staging areas into dimensions and facts
• Created sessions and workflows to execute all the mappings, PL/SQL procedures and shell scripts together and in desired order.
• Used DBMS JOB package and Unix Crontab utility to schedule jobs.
• Used Explain Plan and Tkprof utility to trace and tune the slow moving processes and to review the overall processing for efficient and closed loop processing.
• Involved in Production trouble shooting, program debugging and testing, post -implementation review of new/changed applications.
• Created reports using Oracle Discoverer.
• Extensively used TOAD for performing different operations on the Oracle database.

Environment: Informatica 8.6, PL/SQL, SQL Loader, TOAD, SQL Plus, Oracle Discoverer 10.1.2, Unix Shell Scripting, IBM AS/400, IBM DB2, AIX 5.3 Operating System, Windows NT

Confidential

ORACLE / PLSQL DEVELOPER

Responsibilities:

• Creating PLSQL packages to create the input feed according to the standard format work file to process for accounting engine.
• Create various oracle database procedures and functions to validate the fields and derive the fields based on the input and converting raw input data into standard accounting data format.
• Creating the journals and loading the data into the production tables.
• Wrote several stored procedures for recycling and other extraction purposes.
• Developed Date entry, query and reports request screens.
• Developed data conversion, integration, and loading and verification specifications.
• Create record groups for manipulation of data. Perform unit and system integrated testing.
• Co-Ordination with users and SQL tuning on existing reports.
• Moved data from one database to other database, Used SQL Loader for data migration.

Environment: Oracle 8i database, PL/SQL, UNIX Shell Scripting, Erwin 3.5.2, XML, DB2, Windows NT 4.0, MS SQL Server 2000, Cognos 5.0,Forms 4.5, Reports 2.5, Windows 98, UNIX.