SUMMARY:

• Overall 10+ years of IT know - how along with hands on experience in analyzing, designing and developing Enterprise Data Management solutions using tools -Informatica MDM versions 9.1/9.7/10.x, Hub configuration, Match-Merge setup, Service Integration Framework (SIF) APIs, Data Profiling, data migration, validation, reject processing and Batch and Real time integration.
• Skilled in designing, Installing& Configuring coreInformatica MDM Hubcomponents - Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and Informatica Data Director (IDD).
• High exposure onMDM Hub configurations(Version 10.2) - Data modeling for Sources and Systems, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, and Hierarchy Manager.
• Implementation of Informatica MDM on AWS cloud.
• Configuring Load Balancer on AWS cloud EC2 instance.
• Expertise in upgrading MDM application from older version of application to latest version (MDM 10.2). Prepared upgrade plan and handled end to end execution.
• Expertise in creatingLanding, StagingandBase Object Tablesand defining Foreign Key relationships,Lookupsin the Hub and developingMappingsto load Data from Landing to Staging and the usage of cleanse functions.
• Rendering experience in Designing & developing multiple cleansing and standardization scenarios usingAddress Doctor.
• Offering expertise in creatingIDDapplication as per the business needs by creating the subject area and subject area groups.
• Exceptional acquaintance in configuring theMatchandMerge Rulesin the MDM Hub by definingproperties for Fuzzy and Exact match, creating path components, columns and Match Rule Set. Far-reaching experience in Identification of User requirements, Feasibility study, Effort Estimation, System Designing, Implementation and Testing with respect to Informatica MDM solution.
• Created JAVAUser Exitsto customize the Hub functionality. Hands on experience on Installation and configuration of ActiveVOS.
• Knowledge in Informatica products likeInformatica Data Quality(IDQ) and Address Doctor.
• Experienced in Running theStage Jobs, Load Jobs, MatchandMerge Jobsusing the Batch Viewer and Automating processes usingshell scripting.
• Requirements gathering and preparation ofHigh levelandLow Level Designsthroughout the Software Development Life Cycle. Very good in understanding the MDM requirements from the business inachieving the BVT (Best Version of Truth) Record and publish to the downstream applications. Tuning the MDM Environment for better performance.
• Strong knowledge on SQL scripts and stored procedures in SQL Serverand Oracle Databases.

TECHNICAL SKILLS:

MDM Tools: Informatica MDM 9.x & 10.1 & 10.2

ETL Tools: Informatica 9.x

Cloud Instance: EC2, AWS Cloud

Databases: Oracle 11g/10g/9i, SQL Server

Application Servers: JBoss, WebLogic, IBM Websphere

OS platforms: Linux, UNIX (IBM-AIX, HP-UX), Windows

Core Programming Languages: UNIX Shell Scripting, Java

ERP / CRM: Salesforce, Finacle CRM

CASE Tools: Erwin 4.5/4.0

Source Code Control: VSS, Team Foundation Server

Change Management Tools: Remedy, ServiceNow, JIRA

Scheduling Tools: AutoSys, Control-M, Tidal

Domain Knowledge: Banking & Insurance, Pharmaceuticals, Payments

PROFESSIONAL EXPERIENCE

Confidential

Lead MDM consultant

Responsibilities:

• Implementation of Informatica MDM application on AWS cloud infrastructure.
• Exposing MDM services to third party application for real time integration.
• Configuring business entity services and REST full services for third party integration.
• Implementing Elastic Load Balancer on EC2 instance of AWS Cloud infrastructure.
• Automating batch jobs for match and merge operations.
• Regression testing of MDM 10.2 for the core functionalities.
• Implementation of MDM application on Development, QA and Production Environments.
• Downstream system testing with MDM application during integration testing phase.
• Work closely with Informatica Support to resolve the issues identified in Informatica MDM tool.
• Suggesting client to go for best possible technological solution based on technical expertise and knowledge.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• POC on ORS specific SIF API, Composite Objects and Composite Services.

Tools Used: AWS Cloud, Informatica Developer 9.6.1HF2, Informatica MDM version-10.2, Informatica IDQ, IDD, SQL Server, Eclipse, Soap UI, UNIX and Putty.

Confidential

Lead Informatica MDM consultant

Responsibilities:

• Extensive Client interaction and business interaction to understand Technical and functional aspect of requirements.
• Design the plan for MDM Upgrade considering the existing architecture and Impact Analysis to the existing Systems.
• Data Readiness Report Generation and resolving Hub Store issues for Upgrade.
• Upgrade Master Database and ORS Databases.
• Upgrade new Version of Hub and Cleanse Server on WebLogic.
• Regression testing of MDM 10.2 for the core functionalities.
• Upgraded MDM on Development, QA and Production Environment.
• Downstream system testing with MDM application during integration testing phase.
• Generated Step by Step Procedure Document, on how the upgrade was done on each Environment.
• Involved on Configuration, Installation and Integration of Informatica MDM 10.2/IDQ 9.6.1.
• Work closely with Informatica Support to resolve the issues identified in Informatica MDM tool.
• Suggesting client to go for best possible technological solution based on technical expertise and knowledge.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• POC on ORS specific SIF API and Composite Services.

Tools Used: Informatica Developer 9.6.1HF2, Informatica MDM 9.1.0 and MDM version-10.2, Informatica IDQ, IDD, TOAD, Oracle 11g, Tidal Job Scheduler, Eclipse, Soap UI, UNIX and Putty.

Confidential, Dorchester, MA

Lead Informatica MDM consultant

Responsibilities:

• Client interaction and business interaction to understand environment and functional aspect of requirements.
• Design the plan for MDM Upgrade considering the existing architecture and Impact Analysis to the existing Systems.
• Data Readiness Report Generation and resolving Hub Store issues for Upgrade.
• Upgrade Master Database and ORS Databases.
• Upgrade new Version of Hub and Cleanse Server on JBoss.
• Regression testing of MDM 10.1 for the core functionalities.
• Upgraded MDM on Development, UAT and Production Environment.
• Coordinate with other application areas during integration testing.
• Generated Step by Step Procedure Document, on how the upgrade was done on each Environment.
• Involved on Configuration, Installation and Integration of Informatica MDM 10.1/IDQ 9.6.1.
• Work closely with Informatica Support to resolve the issues identified in Informatica MDM tool.
• Suggesting client to go for best possible technological solution based on technical expertise and knowledge.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• POC on MDM version 10.2 as it was the newly released version from Informatica.

Tools Used: Informatica Developer 9.6, Informatica MDM 9.7.1, 10.1(HUB/Cleanse) and 10.2(HUB/Cleanse) Informatica IDQ, IDD, TOAD, Oracle 11g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential, Chicago, IL

Lead Informatica MDM consultant

Responsibilities:

• Architecture Design for Data Flow, Environment, IDD and Publishing Data from MDM.
• Data profiling, fuzzy search, fuzzy match and merge sizing and performance tuning on millions of records from various data sources, for trusted golden Data.
• Configured Source Systems for customer data, Configured MDM tables in the following sequence: Base Objects, Relationships Base Objects, Defined the ETL process to load the data into the landing tables during the land process.
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Configured Address Doctor by doing the changes in the Configuration files on the hub server.
• Worked closely with the Business in gathering the Match rules and created the Match rule document.
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Executed Data landing, staging and loading process using the batch viewer.
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase
• Worked on Security Access Manager (SAM) for creating roles and assigning users.
• Worked on IDD UI configuring subject areas for Customer Domain that assisted to search and edit master records that enabled client with their sales process transformation
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications
• Worked closely with Business Users to understand their requirements and incorporated cleanse functions and User Exits for Validation, Back End Processing of Data and Error Handling.

Tools Used: Informatica Developer 9.6, Informatica MDM 10.0(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 11g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

Sr. Informatica MDM consultant

Responsibilities:

• Client interaction and business interaction to understand environment and functional aspect of requirements.
• Architecture and Design for MDM Upgrade.
• Impact Analysis to the existing Systems.
• Data Readiness Report Generation and resolving Hub Store issues for Upgrade.
• Upgrade Master Database and ORS Database.
• Upgrade new Version of Hub and Cleanse Server on JBoss.
• Regression testing of MDM 9.7.1 for the core functionalities.
• Upgraded MDM on Sandbox, Integrated Dev, UAT and Production Environment.
• Coordinate with other application areas during integration testing.
• Generated Step by Step Procedure Document, on how the upgrade was done on each Environment.
• Performed MDM Hub configuration and Match /Merge rules for Product and Customer Domain data.
• Ensure all information is passed to offshore and resolve their queries by clarifying with the client.
• Work closely with Informatica Support to resolve the issues identified in Informatica MDM tool.
• Suggesting client to go for best possible technological solution based on technical expertise and knowledge.
• Register the MQ setup for message triggers.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.

Tools Used: Informatica MDM 9.1 and 9.7(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 11g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

Sr. Informatica MDM Consultant

Responsibilities:

• Consolidated customer data from different sources to generate the golden record of Customer Master Data. Evaluated the various source systems in which the customer data resides and specified them in MDM Hub.
• Involved in the complete phase of project from Hub configuration to deployment.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities
• Defined the landing tables, base objects, staging tables as per the requirement.
• Defined foreign-key relationships, lookups, queries and packages.
• Proposed and developed multiple cleansing functions in MDM hub and IDQ to get the required cleansed/standardized output. Defined exact and fuzzy match rules including exact and fuzzy/exact match columns, match paths, and appropriate key widths that would aid in efficient matching.
• Defined Trust and validation rules to downgrade trust when applicable.
• Used Metadata manager to Import and Export Metadata / create Change lists and promote Incremental changes between environments from development to QA.
• Developed Configuration documentation, Design documentation and analyzed functional specifications and user requirement documents
• Set up Subject areas and child subject areas in IDD to enable the data stewards to query and rectify data. Created apt queries and packages that would be used in IDD to aid the work of data stewards.
• Experienced in Security Access Manager (SAM) for creating roles and assigning users
• Created reusable transformations and Mapplets and used them in complex mappings to maintain the reference data from different sources.

Tools Used: Informatica MDM 9.7.1(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 11g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

MDM consultant, ETL support

Responsibilities:

• Involved in complete life cycle of MDM implementations on Informatica MDM Version 9.6
• Performed MDM Hub configuration and Match /Merge rules for Customer Domain data.
• Created Address validation rules using IDQ and performed Match process for address duplication.
• Created MDM IDD configuration to perform Match/merge for Business users.
• MDM Hub configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing/ configuring Informatica data director (IDD) applications.
• Involved in developing, testing, implementing, troubleshooting and resolving issues related to system performance, MDM applications, and data integrity.
• Impact analysis of change requests and incidents, and identification of solutions, including creation of appropriate documentation Planning and monitoring defect prevention activities.
• Developed the mappings and used the necessary cleanse functions by analyzing the data using the data quality tool.

Tools Used: Informatica MDM 9.6(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 10g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

Lead Informatica MDM

Responsibilities:

• Lead Informatica MDM HUB and Informatica IDD Offshore Technical team for HUB development, IDD development, Data Quality and Data Migration. Designed and created BO, staging tables, mappings, transformations. Configured Trust configuration and Validation Rules.
• Created Match Rules and Merge Settings. Configured data flow Land, Stage, Load, Tokenize, Match, Consolidate . Created IDD application and Conducted UATs.

Tools Used: Informatica MDM 9.1(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 10g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

Informatica MDM

Responsibilities:

• Informatica MDM 9.0.1 Hub Installation and environment setup. MDM Hub configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing/ configuring Informatica data director (IDD) applications.
• Involved in developing, testing, implementing, troubleshooting and resolving issues related to system performance, MDM applications, and data integrity.
• Impact analysis of change requests and incidents, and identification of solutions, including creation of appropriate documentation Planning and monitoring defect prevention activities.
• Oracle 10g PL/SQL Development - Data-types, Control Structures, Collections and Records, Packages, Exception Handling, stored procedure.
• Configured Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.

Environment: Informatica MDM 9.1(HUB/Cleanse), Informatica IDQ, IDD, TOAD, Oracle 10g, AutoSys, Eclipse, Soap UI, UNIX, Putty.

Confidential

Software Engineer

Responsibilities:

• Batch jobs configuration & Optimization.
• Finacle version migration strategy.
• Installation of different Finacle instances
• Implementation Finacle Deposits and Lending Module.
• Finacle data migration activities.
• Gathering functional and technical requirements and feasibility analysis.
• Analysis of the list of gaps identified in requirement phase.
• Assisting the client in exploring the various functionalities of Finacle.
• UAT and post Go-Live support to bank till stabilization.
• Implementation of NEFT and RTGS payment systems and successful end to end testing.

Tools Used: Finacle suite of products, TOAD, IBM Websphere, Oracle 10g, AutoSys, Eclipse, UNIX, Putty.