SUMMARY

• Around 14 years of IT experience as Data Management/Integration Architect and in Analysis, Design, developing solutions for Master Data Management (MDM), Data Quality, Product Information Management (PIM), Enterprise data warehouse (EDW).
• Informatica certified professional with extensive experience in Informatica Power Center, Informatica Data Quality, Informatica MDM, MM, Power Exchange and Informatica B2B.
• Experience with Data governance Informatica EDC and Collibra. Establish a standardized approach to capture and catalog metadata.
• Manage day - to-day work of professional/technical staff as project manager for MDM and Data integration projects with broad impact to business and enterprise performance
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Experience in Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Leads highly complex, strategic projects involving high level of coordination among multiple departments and business areas, which utilize data to support new business for MDM and data analytics.
• Thorough knowledge of Master Data Management concepts & Methodologies and ability to apply this knowledge in building MDM solutions.
• Leading the data quality efforts to ensure the accuracy of data across the enterprise.
• Experienced and Implemented a Data Quality Solutions, which includes Standardization and Matching of Source data using Workbench and Informatica Developer Tool.
• Developing a high level road map for the data quality improvement initiative, aligning data governance deliverables with strategic objectives.
• Actively involved in business development activities to help identify and research opportunities on new/existing clients.
• Experience in Request for Proposal for MDM projects.
• Mentors and assists lower level architects, business analysts and developers.
• Expert in designing ETL Architecture and star schema and snowflake dimensional models.
• Partners with business line managers and Center of Excellence leaders, providing technical and system expertise, to synergize IT strategic direction and product concepts.

TECHNICAL SKILLS

Tools: Informatica,Inforamtica Data Quality(IDQ),Informatica Enterprise data catalog

MDM Tools: Informatica MDM,PIM,Stibo

Data Governance: Informatica EDC,Axon,Collibra

Database: Oracle,Teredata, Netezza,SQL Server,GreenPlum,DB2 MS-Access

Dev. Tools: PL/SQL Developer,Toad, Peregrine Change Management Tool,, WINSCP for Unix.

Operating Systems: UNIX, Windows, Linux.

Data Modeling Tool: ERWIN

OLAP Tools: SSAS,Essbase

PROFESSIONAL EXPERIENCE

Confidential

Sr MDM Architect

Responsibilities:

• Provided Architectural solution and assessments to clients for the Master Data Management on customer Master
• Installation of data integration products, data quality, MDM
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
• Performance tuning of Load, Match and Merge Processing.
• Designed/architected and implemented minimum end-to-end Informatica (Informatica Data Director (IDD), Informatica IDQ, Informatica MDM Hub, Informatica Power Center
• Developed the ETL/IDQ process to load the data into the Stage tables during the Stage process.
• Experience in loading the data in staging Process and Loading Process in to the Hub.
• Knowledge in writing and customizing user exits, customizing/configuring Data Director.
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Developed the Match paths, Match Columns and Match rules in the Match and Merge Process
• Experience in Match Rule Creation and Performance Tuning of Match rules, Trust Score optimization.
• Work closely with the Business Intelligence and Advanced Analytics functions to ensure master data is being leveraged and synchronized with analytical data stores.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Actively involved in business development activities to help identify and research opportunities on new/existing clients
• Assist in the management and delivering of large projects
• Train, coach, and supervise staff

Confidential

Sr MDM/ETL/IDQ Architect.

Responsibilities:

• Managed and Advised onsite and offshore team on multiple MDM project engagements (customer, Product)
• Provided Architectural solution and assessments to clients for the Master Data Management
• Installation and upgrade of data integration products, data quality, MDM
• Implemented MDM, Meta-data Management and IDQ solutions.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
• Designed/architected and implemented minimum end-to-end Informatica (Informatica Data Director (IDD), Informatica IDQ, Informatica MDM Hub, Informatica PowerCenter
• Populate Metadata content and associate terms in the Business Glossary to develop the Informatica Enterprise Data Catalog
• Provide support for master data management (MDM) system development, implementation and maintenance
• Participate in establishing governance for metadata management
• Implement solutions and processes for master data and hierarchy synchronizations
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Developed the Match paths, Match Columns and Match rules in the Match and Merge Process
• Experience in Match Rule Creation and Performance Tuning of Match rules, Trust Score optimization.
• Work closely with the Business Intelligence and Advanced Analytics functions to ensure master data is being leveraged and synchronized with analytical data stores.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.

Confidential

MDM Architect.

Responsibilities:

• Gathering the functional and technical requirements for MDM work stream.
• Coordinated and lead MDM and ETL both onsite and offshore teams
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Worked on upgrading the Power center from 9.1.0 to 9.6.
• Developed the ETL process to load the data into the landing tables during the land process.
• Experience in loading the data in staging Process and Loading Process in to the Hub.
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Developed the Match paths, Match Columns and Match rules in the Match and Merge Process
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and redeploying the applications
• Experience in Match Rule Creation and Performance Tuning of Match rules, Trust Score optimization.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Experience with Informatica (Siperian) MDM batch processing.
• Release Management - Exports using Siperian Metadata manager to keep environments in synch
• Testing - System Testing and Bug fixing

Confidential

Informatica MDM Consultant.

Responsibilities:

• Experience in Installing Informatica MDM HUB server/Cleanse Server.
• Experience in upgrading to 9.7.1 and testing the functionality.
• Gathering the functional and technical requirements for MDM work stream.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
• Developed Cleanse functions for various assignments.
• Worked on data director to show the output information to end users.
• Experience in loading the data in staging Process and Loading Process in to the Hub.
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Built services for custom data management GUI (for example, Data Manager, Merger Manager.
• Experience in Match Rule Creation and Performance Tuning of Match rules, Trust Score optimization.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Experience with Informatica (Siperian) MDM batch processing.
• Release Management - Exports using Siperian Metadata manager to keep environments in synch
• Testing - System Testing and Bug fixing

Confidential

Informatica Lead/Administrator/Architect.

Responsibilities:

• Installed Informatica Power Center/IDQ/MM 9X.
• Working on POC for MDM.
• Experience in Installing Informatica MDM HUB server/Cleanse Server.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Prepared Technical Specification documents (TSD).
• Developing a high level road map for the data quality improvement initiative, aligning data governance deliverables with strategic objectives.
• Leading a proof-of-concept data profiling/root cause analysis project on data sets.
• Mentoring staff in the power of integrating a data quality framework with DW/BI development methodology.
• Established best practice and standard for ETL process documents.
• Performance tuning and optimizing the existing mappings.
• Developed Logical and Physical data models, created the (ER) Entity Relationship diagrams.
• Designed and developed ETL mappings using Informatica Power Center, designed to extract data from Flat files, Excel and transforming it according to the business transformation rule.
• Mentors and assists business analysts and developers.
• Coordinated with the DBA Team, Source systems and offshore for Different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and in identified the bugs, new requirement changes and Data Quality Issue.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.

Environment: Informatica 9x, Teradata, SQL Server.