SUMMARY:

• 7+ years of experience in software development, maintenance, testing and troubleshooting on Informatica Master Data Management (MDM), ETL/DWH applications, data quality, data integration and Oracle databaseExperienced in:
• Gathering requirements from the Business and preparing the functional documents.
• Review the high level documents to ensure the requirements are addressed accordingly andDiscuss the possibilities of the requirements.
• Review on Low level documents review the documents wif Client’s IT team to make sure code isBug free and make sure times are falling under project timelines.
• Installing and Configuring of Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications
• All facets of MDM implementations including Data Profiling, metadata acquisition, data migration, validation, reject processing and pre - landing processing.
• Performing requirement gathering, analysis, design, development, testing, implementation, support and maintenance phases of both MDM and Data Integration Projects
• Master Data Management (MDM) & Data Integration concepts in large-scale implementation environments.
• Creating landing tables, Staging tables, Base Tables as per the data model and data sources
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
• Defining Trust Score, Validation rules, Match rules and Merge settings
• Closely worked wif other IT team members, business partners, data stewards, stakeholders, steering committee members and executive sponsors for all MDM and data governance related activities
• Developing the IDD application, building Hierarchies as per the business needs
• Working wif PowerCenter Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS
• Created complex transformations and mappings, processing tasks, scheduling sessions, importing/exporting repositories in power center
• Good experience in Data Warehousing methodologies/Dimensional Data modeling techniques such as Star/Snowflake schema using ERWIN
• Extensively implemented Slowly Changing Dimensions: Type1, Type2, Type3.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center, Power Mart (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Working wif tools like TOAD, SQL Developer and SQL plus for development and customization.
• Worked extensively on creating new CUSTOMER ONBOARDING process wif new configuration on External matching Rules and processing the customer data before loading into MDM.
• Experienced in creating workshops wif data stewards and business owners on match rules tuning, IDD configurations and Trust scores and validations.
• Team player and self-starter wif good communication skills and ability to work independently and as part of a team

TECHNICAL SKILL SET:

EIM Tools: Informatica MDM Multi-domain Edition, Siperian Master Reference Management XU, IDD, SIF

Cleanse Adapters: Address Doctor, Trillium

Databases: Oracle 8.x/9.x/10g/11g, Editors (SQL Navigator, Toad), Teradata

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader SQL Navigator Export/Import

ETL Tools: Informatica 8.x/9.x, Informatica Power Exchange 7.x/8.x

Data Modeling: ERWIN 4.0, MS Visio 2000

Data Reporting: Business Objects, QlickView

Programming Skills: SQL, PL/SQL, C, Unix Script, Java .

Application Servers: Web Logic 10.x/9.x, JBoss 5.1 GA

Package: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio 6.0.

Environment: Windows 2000/ NT/XP, Unix, Windows SERVER 2003

PROFESSIONAL EXPERIENCE:

Confidential

Informatica MDM Developer

Responsibilities:

• Installed Informatica MDM 9.5 In UNIX (Red Hat) wif the middleware JBOSS 5.1 GA .
• Configured cleanse server and address doctor.
• Implement Informatica MDM workflow, including data profiling, configuration specification and coding, match rules tuning, migration
• Build out best practices regarding data staging, data cleansing, and data transformation routines wifin the Informatica MDM solution
• Define and build best practices regarding creating business rules wifin the Informatica MDM solution
• Created Base Tables, Stages tables based on the data model and number of source systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked wif Business users in understanding Match & Merge setup and incorporated their requirements and ideas
• Collaborated wif users in defining Match Rules and conducted workshops to discuss over and under matching
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Defined Roles and privileges for each environments according to the platform requirements
• Defined the security such that schema will be secured wif access only granted for specific downstream integration uses, using users created for those specific integrations
• Develop and maintain the master and translation entities in the MDM Hub and published the data into SFDC’s and ERP’s for supporting the ongoing business support
• Created “Customer onboarding” process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging, loading, match and merge.
• Configured, designed and delivered MDM hubs across multiple data domains (Party, Service/Product & Prospect).
• Used hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Created and Developed IDD application by creating Subject Area Groups, Subjects Areas and Entity Relation ships
• Performed analysis, design, development and maintenance activities associated wif the database and data in support of multiple applications(including following standards/procedures to achieve integration of systems through database design).
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document,Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM 9.5.1, Informatica 9.5, IDQ, Oracle 11g MS Excel, Unix

Confidential, Indianapolis, IN

Informatica MDM Developer

Responsibilities:

• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product.
• Developed comprehensive models for managing and communicating the relationships between Base Objects and Performed the ETL process for loading the data into hub.
• Contributed to Data Migration and the Implementation of Roadmap defined by the business case.
• Implemented batch process using automation and real-time integration wif Power Center for JMS interfacing wif MDM HUB .
• Analyzed the Business data and defined the Match and Merge rules and Trust Scores for INFA MDM Hub.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Designed and defined best implementation and deployment practices for Informatica Data director implementation wifin services organization.
• Develop workflows to data domains for performing extraction, validation, cleansing, matching, loading, exception handling and other data related activities to support Customer’s MDM requirements.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Deployed new MDM Hub for portals in conjunction wif user interface on IDD application.
• Develop standards, guidelines, processes, and expertise to consistently address strategic data issues such as data quality, cleansing, standards, and integration by using Address Doctor cleanse adapter.
• Used metadata manager for importing, exporting, validating the data for transforming the schema from development environment to testing environment.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Involved wif Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Worked extensively on Informatica client tools like Designer, workflow Manger, Workflow Monitor during different phase of project.
• Created Sessions/Batches in Informatica server manager to execute mappings.

Environment: Informatica MDM 9.1.0, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor, IDD, Trillium, Windows server 2003, Unix

Confidential

Informatica MDM Consultant

Responsibilities:

• Installed Informatica MDM 9.5 In UNIX (Red Hat) and windows (server 2008) wif the middleware JBOSS 5.1 GA and Web logic 11 g.
• Configured cleanse server and address doctor.
• Implement Informatica MDM including data profiling, configuration specification and coding, match rules tuning, migration
• Build out best practices regarding data staging, data cleansing, and data transformation routines wifin the Informatica MDM solution
• Define and build best practices regarding creating business rules wifin the Informatica MDM solution
• Created Base Tables, Stages tables based on the data model and number of source systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Worked wif Business users in understanding Match & Merge setup and incorporated their requirements and ideas
• Collaborated wif users in defining Match Rules and conducted workshops to discuss over and under matching
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Defined Roles and privileges for each environments according to the platform requirements
• Defined the security such that schema will be secured wif access only granted for specific downstream integration uses, using users created for those specific integrations
• Develop and maintain the master and translation entities in the MDM Hub and published the data to downstreams
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store and define automation process for staging, loading, match and merge.
• Configured, designed and delivered MDM hubs across multiple data domains (Party, Service/Product & Prospect).
• Used hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Created and Developed IDD application by creating Subject Area Groups, Subjects Areas and Entity Relation ships
• Performed analysis, design, development and maintenance activities associated wif the database and data in support of multiple applications(including following standards/procedures to achieve integration of systems through database design).
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document,Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM 9.5.1, Informatica 9.5, IDQ, IDS, Oracle 11g, SQL Server 2005/2008, MS Access, MS Excel, Unix

Confidential, Simsburry, CT

Sr ETL / Informatica Consultant

Responsibilities:

• Implementing the standards of creating Informatica Workflows/Mappings.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, Migration form
• Extensive experience wif End Users for understanding/analyzing the requirements.
• Analysis of the End user requirements and involved in Modeling the ETL Schema.
• Detailed Analysis of the Data provided by the respective source systems and filling in the gaps in the mapping specs.
• Experience in designing the complete End to End Data Flow and designing the ETL jobs
• Created Users/Permissions/Folders/Shared Folders/Deployment Groups in 7.1/8.6
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer-
• Used ETL to extract and load data from different data bases and flat files to Oracle.
• Creating Complex Mappings/Workflows as per the Business Logic.
• Involved in writing lot of Functions, Stored Procedures.
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, DB2, SAP, SQL Server, flat files, and Loading to Oracle usingInformaticaPower Center.
• Involved in designing ofInformaticaMappings by translating the business requirements.
• Involved in Performance Tuning and optimization ofInformaticamappings and session.
• Implemented ABAC (Automated Balance and Audit Controlling) process to resolve errors.
• Created the Error handling Mechanisms and reconciliation procedures
• Deploying the code across different environments
• Performed Code Review wif the team members
• Supporting and maintaining the existing applications in Production. Resolving the Tickets
• Created UTPs/UTRs for the mappings.
• Performance Tuning of Informatica /Data Base Code.
• Analysis of the CPU, Resources, Used on the Application and DB servers for Performance testing
• Creating Stored procedures, Functions, Views for loading the staging tables
• Created Unix Scripts for End to End process flow.
• Created Autosys jil scripts for Automation of jobs
• Created Technical Design Documents/Low Level Design Documents/Run Book for Basel II Project
• Used Rational Clear Quest For Raising Migration Requests
• Used HP Quality Center for Defect Tracking

Environment: Oracle 9i/10g, Informatica 8.6.1/9.0, SQL Server, Sybase, Solaris, HP Quality Center, UNIX, Shell Programming.