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
• Have 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 the 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 the addition ofMDMData Governance and Data Quality compliance
• Interacted wif the client’s senior management to keep them updated regarding the 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 the MDM solution for customer and dealer portals to enhance the customer interaction wif the dealers and business owners.
• Managed the governance related policies by implementing the business process solution by IBM BPM and IBM ODM. Which enabled users to have a complete control on the 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 the overall scope of conversion project related to Informatica Integration and data quality.
• Designed the error handling processes in Powercenter to overcome the 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 the 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 the existing mappings in the 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 the 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 the 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 the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica PowerCenter Workflow manager to create sessions, workflows and batches to run wif the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the 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 the reporting and planning initiatives.
• Managing programs spanning different technologies and business domains in accordance wif the 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 the group.
• Responsible for development of communication to the 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 the 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 the 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 the Transformation Developer, and Mapplet Designer, respectively.
• Extensively worked wif the data conversions, standardizing, correcting, error tracking and enhancing the data.
• Implemented the process for capturing incremental data from source systems and move the data warehouse area.
• Involved in performance tuning wif Informatica and database.
• Writing Stored Procedures and Functions for processing business logic in the 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 the 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 the procedures work wifin the 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 the project team and data owner to gather requirements.
• Creating Test plan document containing the 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 the distributors
• Created data structure design for the 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 the Data Exceptions to end users through User Interface
• Created materialized views from the source
• View report capability whenever stewards want to visualize the data
• Export to excel functionality; wif the halp of this functionality steward(s) will be allowed to export the 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 the results (data anomalies) of these data quality business rules to the business for completeness and accuracy.
• Worked to auto-notify individuals who enter data into each source system of data quality issues traced back to the 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 the data.
• Provide the business wif the ability to exclude data items from data quality business rules for a period of time or for a specific study.
• Training and support for the individuals entering data into each source system to use the solution to perform the 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 the 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 the functional specs provided by thedata architectand created technical specs documents for all the 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 that capture current state/future state data elements and data flows using Erwin.
• Extensively worked over the 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 the requirements
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the 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 the 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 the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the 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 the functional specs provided by thedata architectand created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively worked over the 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 the requirements
• Designed and built Data marts by using Star Schema
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the 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 the Data Mart defining Entities, Attributes and relationships between them.
• Performance tuning of the 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 the 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 the 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 the 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 the 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