PROFESSIONAL SUMMARY:

6 years of extensive hands-on experience in the field of Data Warehousing, ETL Integration, Database development and Business Intelligence with industry exposure in Finance, Advertising, Retail Merchandising and Insurance5+ years of experience in designing and developing ETL applications using Informatica Power Center 8.6/7.1/6.25+ years of professional experience with complete SDLC involving Business Analysis, Design, Development, QA, Documentation, Knowledge Transfer and Production Support.Strong knowledge in ER Data Modeling ,Dimensional Data Modeling (Star Schema, Snowflake Schema) and Data Warehousing methodologies (Kimball and Inmon methodologies)Experience in integration of various data sources like SalesForce.com, SQL Server, Oracle, Teradata, Sybase, DB2, MS Access, Flat files, XML and COBOL files.Successfully completed training on Talend Open Studio 3.x, conducted by Talend Corporation.Expertise in PL/SQL in creating database Stored Procedures, Functions, Packages, Triggers, Cursors and IndexesExpertise in Shell Scripting and XML.Expertise in migrating and integrating legacy system data to relational database systems.An efficient Team Leader and a Team Player. Efficient in Task assignment and mentoring the team members.

TECHNICAL SKILLS:

Operating Systems: UNIX,IBM-AIX, LINUX, IBM Mainframe, Windows Vista/XP/NT

ETL/BI/CRM Tools: Informatica PowerCenter 8.6/7.1.3/6x/5x (Power Center Designer, Warehouse Designer, Repository Manager, Workflow Manager, Workflow Monitor), SalesForce.com, CPWerx 6.0 Databases: Oracle 11g/10g/9i/8x, Teradata, SQL Server 2008/2005, Sybase, DB2 8.5/7.2/7.1, MYSQL, MS Access

Modeling tools: Erwin r7.2

Query Tools: SQL*Plus, SQL Loader, TOAD, WinSQL, RapidSQL, Advanced Query Tool, APEX,SQL Server Management Studio 2008

Scheduling Tools: AUTOSYS, TIDAL

XML: XML,DTD,XML Schema

Problem Management: Mercury Test Director

Messaging tools: MQ Series, TIBCO

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY Nov '10 - Current
Title: ETL/Informatica Lead

Description: The Customer Reporting Project is part of a broader effort at Moody's Analytics to improve the quality and accessibility of customer data to support better business decision-making and drive increased revenue.

Responsibilities:

• Coordinated with business users and business analysts, on a regular basis to discuss the business requirement documents and transformed them into technical specification documents.
• Coordinated with source system and data owners over resolution of source data issues and better understanding of source data systems.
• Performed data profiling and analysis of various objects in SalesForce.com (SFDC) and MS Access database tables for an in-depth understanding of the source entities, attributes, relationships, domains, source data quality, hidden and potential data issues, etc.
• Developed Source-Target Map documents to describe the relationship between source and target data.
• Developed ETL Specification Design document containing detailed information on ETL processing, mapping/workflow specifications, exception handling process, staging and data warehouse schemas, etc.
• Designed and developed Informatica ETL Interfaces to load data incrementally from SFDC, MS Access databases and Flat files into Staging schema.
• Designed and developed Informatica ETL/SCD Interfaces to loaddata from Staging schema into the Customer Reporting DW dimension tables.
• Designed and developed Informatica ETL Interfaces to loaddata from Staging schema into the Customer Reporting DW Fact tables.
• Scheduled ETL jobs for the entire DW load process using Informatica scheduler
• Coordinated with Testing Team to develop unit, system and integration test cases to detect and resolve development defects.

Environment: Informatica Power Center 8.6, Salesforce.com, SQL Server 2008, Power Exchange 8.1, ER Studio 8.0, RapidSQL7.6.1, PL/SQL, Ataccama Data Profiler, Apex Loader

Confidential, Dallas, TX Mar '10 - Oct '10
Title: Sr. Informatica Consultant

Description:Confidential, is a large advertising and marketing firm whose advertising products and services include Verizon SuperYellowPages, FairPoint, SuperYellowPages, Confidential, SuperpagesDirect direct mail products, etc. As a Sr.Informatica Developer for the large marketing institution, I was involved in the design and development of Data warehouse

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs load the target DW.
• Analyzed the business requirement document and created functional requirement document mapping all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Experience in using Oracle Application Express via APEX rapid development tool for data centric (web applications).
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Application Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Automated the load process using UNIX shell scripts.
• Extracted various data from SalesForce.com using Informatica 8.6 with Sales Force Adapter.
• Worked on updating Sales Force using external ID.
• Modified SOQL (Sales force object Query Language) for Sales Force target at session level.
• Implemented Change Data Capture (CDC) on Source data from Salesforce.com
• Created various objects in SalesForce.
• Used APEX explorer to query the SalesForce.
• Worked on SQL optimization and identified bottlenecks and performance tuned the Informatica mappings/sessions.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Responsible for regression testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then from QA to production.

Environment: Informatica Power Center 8.6, DB2, Power Exchange 8.1, Erwin, TOAD, PL/SQL, Flat files, XML, Oracle 11i/10g/9i, Unix Maestro, Apex, Salesforce.com

Confidential, Winston Salem, NC Jun '08 - Feb '10
Title: ETL Informatica Consultant

Description: Confidential, is the second-largest tobacco company in USA, primarily engaged in the manufacturing of smoking and smoke-less tobacco products. Voyager CONNECT (VC) is a CRM application implemented at RJ Reynolds that automated the Consumer and Trade Marketing Process.

Responsibilities:

• Discussed business requirements with business user group and business analysts and transformed them into technical requirements.
• Developed Detailed Technical Specification and Logical Data mapping documents for all the Informatica Interfaces developed.
• Developed ETL interfaces to integrate master data from Oracle, SQL Server, and Flat file source systems into Oracle database.
• Developed change detection interfaces to implement Change Data Capture (CDC) on master data.
• Designed and implemented ETL interfaces to generate Order transaction reports for allRJRT product-selling outlets in USA.
• Developed UNIX scripts to create file lists, transfer and archive source data files for backup and audit purposes.
• Used TIDAL to schedule the execution of ETL workflows, Data validation scripts and File transfer and archival scripts.
• Developed and Documented Unit Test cases as part of the testing deliverables.
• Used TIDAL to schedule Informatica workflow and UNIX scripts.
• Assisted the Production Support Team to ensure smooth execution of the interfaces.
• Developed Knowledge Management contracts to help knowledge transition of the development activity and documentation to the client.

Environment: Power Center 8.6/7.1.2,Oracle 10g,Teradata,SQL Server, PL/SQL, AIX, DB2, TIDAL,TIBCO, Rapid SQL, AQT, SERENA, CPWerx6.0, Mercury Test Director, Reflection X

Confidential, Wilkesboro, NC Jan '07 - May '08
Title: Informatica Developer

Description: Confidential, is a leading home improvement retailer with a total of approximately 1600 stores in U.S and Canada, ranking #48 on the FORTUNE 500.

LDW is an Enterprise Data warehouse used to maintain a centralized repository of store related data across the nation to support strategic reporting and analytics to drive business decisions.

Responsibilities:

• Interacted with Business Analysts and Data Modelers to understand the data model and clarify transformation rules to propagate data movement.
• Developed Informatica Mappings to translate the Business Requirement to ETL Logic to facilitate extraction of data from disparate sources and propagate into the staging area.
• Developed Interfaces to extract, clean, conform and stageSales promotion master data from Trade Marketing System.
• Modified the existing Surrogate Key pipeline mappings to accommodate for the Promotion related data.
• Developed and Unit Tested mappings involving complex transformations to migrate valid and consistent data using Informatica as ETL tool.
• Developed Logical Data Map documents to describe the relationship between source and target data.
• Developed and Documented Unit Test cases as part of the interface development deliverable.
• Involved in System and Integration Testing in order to detect and resolve development defects.
• Provided Production Support to ensure smooth execution of the interfaces.
• Executed Cron jobs to initiate Informatica work flows.
• Enhanced existing Shell Scripts to enable audit checks and control movement of data at various steps of data propagation.
• Improved the performance of long running batch jobs with the help of SQL tuning, indexes and partitioning.
• Participated in mentoring and knowledge transition of the development activity with the client.

Environment: Power Center 7.1, SYBASE, Oracle 9i, PL/SQL, UNIX/AIX, DB2, TeraData, Cron, PuTTY, Test Director, Talisma

Confidential, Columbus, OH Oct '05 - Dec '06
Title: ETL Developer

Description: Confidential, is one of the largest insurance and financial services companies in the world.
The FOCUS Project was a key Nationwide initiative that integrated disparate financial systems into a single suite of applications that provide company-wide visibility to financial information. Project involved creating process for loading data into a data warehouse giving the users to access, analyze and share information in the data warehouse.

Responsibilities:

• Interacted with Business users in development and documentation of complex business concepts into technical specifications applicable to various data movement and transformation processes.
• Played a significant role in the CONVERSIONS project - Historical data conversion from the current systems and Nationwide enterprise companies to the FOCUS financial platform.
• Implemented Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter, Sequence generator and Router Transformations, and Mapplets in Mappings.
• Designed, Developed and maintained SQL Loader scripts, PL/SQL procedures, functions, triggers to populate Oracle Tables.
• Used TOAD, SQL Tools to work with databases.
• Extensively worked on tuning the mappings and workflows.
• Used Maestro Job Scheduler to schedule Informatica and other jobs.
• Prepared Unit test documentation and cases/scenarios for the entire team.
• Responsible for migrating mappings/workflows from Development to Test and Test to Integration environments.
• Collaborating with development and QA teams to resolve defects.

Environment: Informatica Power Center 6.2, Oracle 9i, Teradata, PL/SQL, UNIX