SUMMARY

• Over 11 years of extensive experience in ETL, MDM, Data Governance, Data Integration and Data Quality.
• Developing ETL mappings and scripts using Informatica Powercenter 9.1/8.6/7.1/6.2/5.1 and PowerMart 9.1/8.6/7.1/6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Informatica Developer 8.6/9.1/9.5.1, Informatica Analyst, Repository Manager, and Workflow Manager & Workflow Monitor.
• Extensive experience in Data Governance implementation, Data Quality, Master Data Management (MDM), Data Integration/Migration, Data Quality, Profiling & Cleansing, Data Design and Modeling
• Extensive experience in implementation of Data Warehousing, Data Marts, Star and Snowflake Schema, Dimensional Modeling on OLTP and OLAP concepts
• Has strong analytical knowledge of ESB and API concepts in diverse business domains specially around MDM implementations.
• Worked on Informatica Power Center 8.6.1 - source analyzer, warehouse designer, mapping designer, workflow manager, Mapplets, and Reusable Transformations.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in integration of various data sources like Oracle, DB2 and SQL server into staging area.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Excellent analytical and logical programming skills wif a good understanding at teh conceptual level and possess excellent presentation, interpersonal skills wif a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Experience in source systems data analysis and data extraction from various sources like Oracle 10g/9i/8i, DB2 UDB 7.2, Flat File sources, SQL Server 2008.
• Experience in writing Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Experience in UNIX shell scripting, PERL scripting and automation of ETL processes.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x/8.x/7.x/6.x, Informatica Developer 9.x/9.x

BI Tools: Cognos 8 BI Suite, SAP Business Objects

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g/11g, DB2

DG Tools: IBM BPM, IBM ODM

Data Quality: Informatica IDQ, IBM QualityStage, Acxiom

Client Side Skills: SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, CSS, JavaScript, C, C++, VB 6.0

OS: UNIX/Solaris, Red Hat Linux

Version Control: Visual Source Safe 6.0, CVS

Tools: Toad, Erwin 4.1, MS Word, MS Excel, MS Visio, BPI Revenue RecognitionHyperion Planning, Microsoft Visual SourceSafe, Tivoli Work Scheduler, BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential

MDM/Data Governance Lead

Responsibilities:

• Led Enterprise Master Data Management (MDM) strategy; implemented teh addition ofMDMData Governance and Data Quality compliance
• Interacted wif teh client’s senior management to keep them updated regarding teh project details.
• Completed thorough analysis of currentIBMMDMimplementation and reviewed other vendorMDM products, resulting in both a strategic management recommendation and a tactical simplifiedMDM solution met immediate reporting needs.
• Partnered wif Data Governancemanagerto in corporate governance and quality in new initiatives insuring data was profiled and valid values documented.
• Led a 10 memberMDMteam & managed a 3 member ad-hoc reporting team for mid/senior management reporting; generated financial reporting for new initiatives and analysis.
• Worked in agile development methodology for tacticalMDMwork utilizing 2 week sprints allowing management visibility and reprioritization of work.
• Implemented teh MDM solution for customer and dealer portals to enhance teh customer interaction wif teh dealers and business owners.
• Managed teh governance related policies by implementing teh business process solution by IBM BPM and IBM ODM. Which enabled users to has a complete control on teh business processes in a systematic way as well as better ownership on data.

Environment: IBMMDM11.3, IBMBPM, MDMStewardship Center, IBM ODM, IBM Datastage, IBM Qualitystage, Acxiom, MS Word, MS Excel, MS Visio, DB2, Oracle

Confidential

Informatica Data Quality Lead

Responsibilities:

• Defined and designed teh overall scope of conversion project related to Informatica Integration and data quality.
• Designed teh error handling processes in Powercenter to overcome teh issues which are generally encountered during a conversion project.
• Extensively used Informatica Power Center, and Informatica Developer.
• Designed ETL processes using Informatica Power Center and Informatica Developer to load data from Oracle, Flat Files, and Excel files to Oracle staging area.
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce teh redundant work.
• Extensively used Match, Merge, Association, Key generator, Consolidation, Parser, Standardizer and Address Validator Transformations to standardize and de-duplication of data in IDQ 9.5.1.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner in Power Center.
• Created profiles for files & Tables using Informatica Developer & Informatica Analyst.
• Worked on Informatica Metadata Manager for Database & ETL load process.
• Created Implementation plans for UAT & PROD migration.
• Redesigned some of teh existing mappings in teh system to meet new functionality.
• Performed error handling and performance tuning in Informatica Power Center and IDQ mappings.
• Migration of ETL code from Dev to QA environment.
• Worked on Unit testing & Regression testing for ETL.
• Created documentation for ETL code.

Environment: Informatica Powercenter 9.5.1, Informatica Developer9.5.1, Informatica Analyst, Oracle 11g, Oracle SQL developer, HP Quality Center 9.2, IMS prescriber data.

Confidential

Project Manager/ETL Lead

Responsibilities:

• Analyzed teh business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in teh central oracle database.
• Used Informatica Power Center 8.x for extraction, transformation and load (ETL) of data.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load teh data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized teh mappings and increased teh re-usability.
• Used Informatica PowerCenter Workflow manager to create sessions, workflows and batches to run wif teh logic embedded in teh mappings.
• Created procedures to truncate data in teh target before teh session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing teh performance of teh conversion mapping.
• Used teh PL/SQL procedures for Informatica mappings for truncating teh data in target tables at run time.
• Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of teh inconsistencies in teh data load on teh client side so as to review and correct teh issues on their side.
• Created teh ETL exception reports and validation reports after teh data is loaded into teh warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for teh mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Powercenter 9.5.1, Informatica Developer9.5.1, Informatica Analyst, Oracle 11g, Oracle SQL developer, HP Quality Center 9.2, IMS prescriber data.

Confidential

Senior Consultant/Solution Architect/Integration Specialist

Responsibilities:

• Responsible for enhancing business requirement planning process improvement
• Gatheird business and technical requirements from multiple business units
• Completed end to end data warehousing development life cycle
• Completed workflow enhancement Projects for business units
• Responsible for aligning business and technology resources to implement projects critical to teh reporting and planning initiatives.
• Managing programs spanning different technologies and business domains in accordance wif teh overall reporting transformation objectives.
• Responsible for building communication plans and strategy for continuous process improvements.
• Working on projects like analysis of data models supporting business requirements for reporting and other strategic projects wifin teh group.
• Responsible for development of communication to teh senior management of vendor and client
• Managed Complete Financial Reporting Transformation including Data Modeling, Data Governance, Architecture, as well as Change Management
• Designed and implemented complete Data governance, Data Quality and Data integration framework wifin an MDM solution for product data
• Managed daily issues on multiple projects
• Managed incoming project requests and prioritized them accordingly to initiate new projects
• Worked wif teh Corporate IT and OBIEE Team to manage projects
• Performed day to day project management functions such as development of project plan, status reports, communication and Risk plans as well as stakeholder management
• Change Management

Environment: MS Project, Visio, Outlook, HP Quality Center, Power Point, Oracle MDMOBIEE, Informatica Powercenter, Informatica Developer, Informatica Analyst, Ervin

Confidential

Assistant Project Manager/ETL Lead

Responsibilities:

• Involved in Design Part of teh Project by Creating FSD & Business mapping documents.
• Involved in gathering Business Requirements.
• Prepared low level Source to Target mapping documents.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica PowerCenter.
• Extracting data from several source systems and loading data into target database and also feeding data into some external systems.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in teh Transformation Developer, and Mapplet Designer, respectively.
• Extensively worked wif teh data conversions, standardizing, correcting, error tracking and enhancing teh data.
• Implemented teh process for capturing incremental data from source systems and move teh data warehouse area.
• Involved in performance tuning wif Informatica and database.
• Writing Stored Procedures and Functions for processing business logic in teh database.
• Involved in writing UNIX shell Scripting.
• Created updated and maintained ETL technical documentation.
• Versioning for ETL Code & DB scripts are maintained in CVS & Clear Case.
• Workflows scheduled by using Autosys Scheduler Tool.
• Involved in Design, Development &Testing Phases.

Environment: MS Project, Visio, Outlook, Power Point, Informatica MDM, Cognos, Informatica Powercenter, Informatica Developer, Informatica Analyst, Ervin

Confidential

Informatica/IDQ Consulant

Responsibilities:

• Creating Design Instruction document containing teh ETL and Data Quality solution to meet performance requirements.
• Worked on variousInformaticaPower Center components like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Documented at a functional level how teh procedures work wifin teh data quality applications
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files and Mainframe files.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Consumer Transformation, Normalizer Transformation
• Worked wifInformaticatoolsIDQ(Data Analyst, Developer) wif various data profiling techniques to cleanse, match/remove duplicate data.
• Work wif teh project team and data owner to gather requirements.
• Creating Test plan document containing teh positive and negative test cases.
• Creating Understanding documents for existing applications.
• Work closely wif business people to create abstract layer
• Provide on - going support for data questions from teh distributors
• Created data structure design for teh sources
• Enabling Business users to create/modify Data Quality Rules against source data from Ingest layer of source
• Capturing Data Quality Exceptions against Source data from Ingest layer of source
• Sending Notifications to assigned recipients
• Extensively used Explain Plans to identify SQL query performance and created Indexes to optimize execution time.
• Configuring system to schedule and execute Data Quality Rules
• Reporting teh Data Exceptions to end users through User Interface
• Created materialized views from teh source
• View report capability whenever stewards want to visualize teh data
• Export to excel functionality; wif teh help of dis functionality steward(s) will be allowed to export teh generate report data in excel format
• User defined filter conditions will be provided to visualize specific set of data in a report
• Worked to conduct data profiling against data elements to identify potential rules and data issues.
• Worked to generate data quality scorecards containing metrics.
• Worked to expose teh results (data anomalies) of these data quality business rules to teh business for completeness and accuracy.
• Worked to auto-notify individuals who enter data into each source system of data quality issues traced back to teh source systems
• Provide an ability to perform data profiling on a specific data domain to identify data issues and work wif source data stewards to correct teh data.
• Provide teh business wif teh ability to exclude data items from data quality business rules for a period of time or for a specific study.
• Training and support for teh individuals entering data into each source system to use teh solution to perform teh profiling and data quality business rules creation and management functions will be available.

Environment: Informatica Power Center 9.5.1, Informatica Developer 9.5.1 (IDQ), Workflow Manager, Workflow Monitor, Oracle 11g, SQL Developer, HP Quality center, Cognos

Confidential

Senior Consultant/Informatica Data Quality Developer

Responsibilities:

• Extensively used Informatica Power Center, and Informatica Developer.
• Designed ETL processes using Informatica Power Center and
• Informatica Developer to load data from Oracle, Flat Files, and Excel files to Oracle staging area.
• Created Reusable Transformations and Mapplets and used them in various Mappings to reduce teh redundant work.
• Extensively used Match, Merge, Association, Key generator, Consolidation, Parser, Standardizer and Address Validator Transformations to standardize and de-duplication of data in Informatica Developer 9.5.1.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner in Power Center.
• Created Mapplets and used them in different Mappings in Power Center.
• Created profiles for files & Tables using Informatica Developer & Informatica Analyst.
• Worked on Informatica Metadata Manager for Database & ETL load process.
• Created Implementation plans for UAT & PROD migration.
• Worked on onsite-offshore model to coordinate offshore teams.

Environment: Informatica Powercenter 9.5.1, Informatica Developer9.5.1, Informatica Analyst, Oracle 11g, Oracle SQL developer, HP Quality Center 9.2

Confidential

Information Architect/Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed teh functional specs provided by thedata architectand created technical specs documents for all teh mappings.
• Plan, design, and implement application database code objects, such as tables, stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Developed logical and physical data models dat capture current state/future state data elements and data flows using Erwin.
• Extensively worked over teh online tracking system for work-requests, database change request issues, automated Unix scripts modification issues and various scheduler jobs issues
• Collection of requirements from business users and analyzed based on teh requirements
• Converted teh data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in teh Database, created Automated scripts, defined storage parameters for teh objects in teh Database.
• Defined various facts and Dimensions in teh data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Dealt wif various information/data source systems like IMS Health, CARSMA/GPS, CARS, JDE/GL Balances systems.
• Designed teh Data Mart defining Entities, Attributes and relationships between them.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.

Environment: Informatica Power Center 8.6, Workflow Manager, Workflow Monitor, SQL Server 2008

Confidential

Lead Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed teh functional specs provided by thedata architectand created technical specs documents for all teh mappings.
• Develop logical and physical data models dat capture current state/future state data elements and data flows using Erwin.
• Extensively worked over teh online tracking system for work-requests, database change request issues, automated Unix scripts modification issues and various scheduler jobs issues
• Designed and created logical Data warehouse models to support strategic decisions using Erwin
• Collection of requirements from business users and analyzed based on teh requirements
• Designed and built Data marts by using Star Schema
• Converted teh data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in teh Database, created Automated scripts, defined storage parameters for teh objects in teh Database.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed teh Data Mart defining Entities, Attributes and relationships between them.
• Performance tuning of teh Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Performance tuning using round robin, hash auto key, Key range partitioning.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved wif requirement gathering and analysis for teh data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Assisted in developing logical & physical modeling as per business requirements using ERWIN.
• Analyzed teh source data coming from Oracle, Flat Files, and MS Excel coordinated wif data warehouse team in developing Dimensional Model.
• Created data warehouse objects - Fact tables, dimension tables, and association tables.
• Extensively used all teh features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented various mappings to transform data from source to target files in Source Analyzer, Warehouse, Designer and Mapping Designer in Informatica Designer.
• Created various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested teh mappings for data verification in Designer.

Environment: Informatica Power Center 8.6, Oracle 10g, Erwin 4.0, PMCMD scripting, Shell Scripting, TOAD, PL/SQL, UNIX, Cognos 8.4 Report Studio, Query Studio