SUMMARY

• Over 8 yrs of strong IT experience and technical proficiency.
• About 6 yrs of expertise in end - to-end implementation of DataWarehouse systems from requirement gathering, data analysis, Dimensional modeling, ETL design & Reporting application.
• Strong understanding of DataWarehouse concepts and experience in Physical & Logical Data Modeling, Star/Snow Flake Schema, Data Profiling, Data Cleansing.
• Extensive experience in design, development and implementation of complete ETL process using Informatica PowerCenter 8.x/7.x/6.x ETL tool.
• Proficient skills in Relational Databases such as Oracle 8i/9i/10g, IBM-DB2, Teradata V2R4, SQL server 2000/2005.
• Strong development experience in SQL, PL/SQL using SQL*PLUS, TOAD, SQL Navigator and external loaders such as the SQL Loader.
• Experience in Unix Shell scripting, Scheduling and file management in various Unix environment like Sun-Solaris, IBM-AIX, and HP-UX.
• Sound knowledge in working with Data Analyzer, MicroStrategy, Business Objects, Cognos BI Suite and CRN Reports.
• Well experienced in translating business users needs (FSD, BRD) into ETL design documents, mapping specifications, unit test plans and supporting UAT.

TECHNICAL SKILLS

Etl: Informatica PowerCenter 8.x/7.x/6.x (Admin Console, Repository Manager, Workflow Manager, Workflow Monitor, Mapping Designer)

Dimensional Data Modeling: Erwin 7.1/4.5/4.0, Embarcadero ERStudio 6.x (Ralph Kimball/Bill Inmon Methodologies, Dimensional Data Modelling using Star & Snow Flake schema, Fact and Dimension Tables, Physical/Logical/Conceptual Modeling)

Reporting Tools: Data Analyzer, MicroStrategy-8, Cognos Suite8.0, CRN, Business Objects 6

Scheduling Tools: UC4, Informatica Scheduler

Rdbms: Oracle 8i/9i/10g, Teradata V2R4, IBM DB2 (AS/400 Series), Microsoft SQL Server 2005

Programming: Unix Shell scripting (Ksh), SQL, PL-SQL, VB 6.0/5.0/4.0, HTML, C, C++, Assembly Language

Db Utilities: SQL*Plus, SQL Loader, Quest TOAD, SQL Navigator

Environment: Sun-Solaris, IBM-AIX, HP-UX, MS Windows NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Lead ETL & informatica Developer

Responsibilities:

• Worked with Business Analysts, Users to analyze various source systems- CCBS (Customer care billing system), MRS (Mediation-Rating-Settlement).
• Designed and developed the Subscriber Model & ETL process for Executive Dashboard which gives detailed information about subscribers, region, sales channel, brands, service plans & status.
• Worked with reporting team in order to support Executive Dashboard and transition of reporting model from Data Analyzer to Micro-strategy 8.
• Developed & tested complex mappings for Data Extract of major Music Label download (Sony BMG, UMG, WMG and EMI).
• Designed and coded the Activations data feed using Informatica for various Helio sales channels like Celluphone, Bestbuy.
• Developed complete ETL process of Contents Data Extracts for Media Research & Measurement Company like Nielsen, Big Champagne.
• Performed various admin tasks like folder/object level migration of mappings/sessions/workflows, Informatica upgrades, installing patches, user groups, repository backup and log cleanups.
• Effectively used Informatica Version Control and Partitioning options.
• Identified performance bottlenecks to help optimize the existing ETL jobs at the mapping level, session level and database level to effectively reduce the total load time.
• Efficiently implemented Stored Procedure, Lookup, Joiner, Union, Normalizer, Update Strategy, Aggregator, XML transformations to simplify the mapping logic.
• Worked on relational and flat file sources and targets.
• Implemented SCD methodology to keep track of historical data.
• Coded database triggers, stored procedures, functions, views and materialized views.
• Developed mapping parameter files to capture daily incremental load.
• Coded Unix shell scripts for file merge, ftp, compress and archiving etc.
• Provided 24x7 production support for all applications on a daily basis in order to meet SLA.
• Documented System Architecture Design (SAD) document, mapping specs, unit test plans and conforming UAT.
• Implementation of Informatica Standards and best practices throughout the project to ensure consistency and minimal troubleshooting time.

Environment: Informatica PowerCenter 8.6/8.1, MicroStrategy 8, Data Analyzer, Oracle 10g/9i (RAC), Erwin 7.1, Informatica scheduler, Sun Solaris-10, Windows XP, FileZilla, SQL, TOAD, Visio

Confidential, El Segundo, CA

Sr. Informatica ETL Developer

Responsibilities:

• Identify and analyze source systems along with Business Analysts and System Architects.
• Involved in requirement gathering, reporting requirements, data modeling and designing the documents for the ETL process according to the business requirements.
• Developed and tested the ETL processes to extract data from various sources like relational Oracle/DB2, Flat Files and XML.
• Implemented ETL Balancing Process to compare and balance data directly from source and warehouse tables for reconciliation of data.
• Designed and developed Staging Tables and Bad Tables to identify and isolate duplicates and unusable data from source systems reading only De-Duped data.
• Designed ETL control process to ensure load completion and job inter-dependencies.
• Coded CDC logic for Type 1, Type 2, Type 3 mappings to keep track of historical data.
• Preformed complete re-engineering of Stored Procedures code and translated into Informatica mappings.
• Simplified the development and maintenance of ETL by creating mapplets, re-usable transformation and shortcut objects to prevent redundancy.
• Analyzed the session logs to identify performance bottlenecks in reader, writer, and transformation threads and tuned objects accordingly for better performance.
• Implemented Pre SQL / Post SQL at session level to enhance mapping re-usability.
• Effectively configured the sessions for multiple partitions to improve performance.
• Wrote, tested and implemented Unix/FTP Scripts to perform archiving operations for data files acquired daily.
• Wrote, tested and implemented Copy, Build & Publish shell scripts for Cognos Transformation server from ETL server to publish the Daily and Weekly Cubes.
• Performed validation tasks with BA on Cognos Cubes, CRN reports.
• Assisted in a comprehensive Gap/Overlap Analysis of all DataWarehouse objects of Fisher-Price and Confidential in order to integrate them into single DataWarehouse.
• Effectively maintained daily status updates with entire team using Scrum methodology of SDLC.
• Performed On-Call Production support on rotation basis.
• Actively participated as CoE (Center of Excellence) team member along with DBA, Tech Leads, and System Administrators.

Environment: Informatica PowerCenter 7.1.x, Oracle 9i, DB2, Cognos 8.0, Erwin 4.5, UC4 scheduler, HP-UX, IBM-AIX, Windows XP, WS FTP Pro, Hummingbird 10.x, SQL, TOAD

Confidential, Northbrook, IL

Informatica Developer

Responsibilities:

• Collaborated with business users in defining the scope and boundaries of the EDW.
• Analyzed multiple source system applications and matched against EDW requirements.
• Designed Logical/Physical dimensional model for Datamart based on requirements.
• Prepared technical specifications to develop Informatica ETL mappings confirming business rules.
• Implemented an ETL design process to load shipping, booking, backlog and product related data into the target database from the staging area.
• Devised an ETL strategy for delta load by querying metadata and creating parameters file.
• Worked with front end reporting teams to customize solutions for business reporting problems.
• Extensively used different transformations like Joiner, Update Strategy, Lookup, Expressions, Aggregator, and Sequence Generator etc.
• Developed Pl-Sql procedures, functions, triggers, views, partitions etc.
• Implemented logic to control job dependencies between ETL tasks through the use of indicator files, file-list, event-raise and event-wait tasks.
• Optimized query performance using utilities like explain plan, tkprof, table analyze and partitions.
• Effectively used Informatica partitioning option to improve session performance.
• Coded Unix scripts for scheduling the jobs.

Environment: Informatica PowerCenter 6.2/5.1, Business Objects 6.0, Oracle 9i/8i, SQL, PL/SQL, MS SQL Server 2000, Erwin 4.0, Unix, SQL Navigator.

Confidential, Iselin, NJ

Informatica ETL Developer

Responsibilities:

• Analyzed specifications and identified the source data that needed to be moved to data warehouse.
• Implemented SCD methodology to capture Type 1, Type 2 changes for dimensional attributes.
• Effectively used Teradata utilities FastLoad, MultiLoad, FastExport to stage the data.
• Wrote and modified BTEQ scripts for dumping data extracts into database.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure and Sequence Generator.
• Extensively worked on variables and parameters at mapping/session level.
• Extracted source data from Oracle, Flat files, XML files using Informatica and loaded into target database Teradata.
• Involved in performance tuning of mappings and sessions.
• Effectively used debugger to test and fix the mapping.
• Documented the entire process including the mapping document, unit testing document and system testing documents.

Environment: Informatica Power Center 6.2, Teradata V2R4, Oracle 8i, SQL Developer, Sun-Solaris, Windows NT.

Confidential

Oracle Programmer

Responsibilities:

• System study, Analysis and Project Planning
• Database Design and Application programming
• Writing Database Stored Procedures and Triggers
• Unit Testing and Tuning of SQL Statements
• Support and maintenance of the Application Database.

Environment: VB 4.0, Oracle 7.3, Reports 1.5, PL/SQL, Developer 2000, C, C++, Windows NT.