SUMMARY

• Around 14 Years of IT Experience in Business Intelligence, Master Data Management (MDM), ETL, Data Quality, Data warehousing, Project Management, Resource Planning and management.
• Strong domain expertise in Pharma, Insurance and Retail Industry.
• Roll out an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools and data architecture
• Serve as a liaison between Business, Functional areas and technology to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning
• Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements across the enterprise.
• Strong implementation experience in MDM Hub configuration, IDD configurations and customizations, Data quality (IDQ) solutions along with Data Integration using ETL tools.
• Hub data customization using SIF API requests through SOAP tool.
• Define indicators of performance (KPI) and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
• Assist the team, comprising resources from the Business and Functional areas and IT business and operations functions, to achieve their objectives; resolve issues escalated from Business and Functional areas data governance representatives
• Coordinate with external data sources to eliminate redundancy and streamline the data quality services

TECHNICAL SKILLS

• Hadoop - (HDFS, Hive & Pig) - Trained, AWS
• SQL, PL/SQL, Core Shell ScriptingToad, Putty, SQL data loader, SOAP UI
• Oracle, SQL server, TERADATA
• Informatica MDM 9.7.3,10.1,10.3, Informatica Data Quality 10.2, Informatica Power Center 10.1,10.4
• Tidal, Autosys, Control-M
• Service Now, Remedy
• Linux, UNIX & Windows

PROFESSIONAL EXPERIENCE

Confidential

MDM Architect

Responsibilities:

• Involved in requirements collection from Business and preparation of functional and technical documents for Informatica MDM migration from EXADATA to SQL Server for Partner, HR and Reference data.
• Migrate MDM schemas and data store’s from EXADATA to sql server using SSMA tool.
• Conversion of Subject area based IDD in to E360 based IDD.
• Design and build Business entity services.
• Design and implementation of re-conciliation framework to support upgrade and migration projects for MDM.
• IDD user exit implementation.
• Design and implement custom tasks using JAVA code as well ActiveVOS.
• Design and build of fuzzy match rule and deterministic match rules in Identity match engine.
• Design and build of De-duplication, Delta detection, Address standardization using Address validator processes as part of Stage process setup.
• Design and build of data consolidation process along with Manual match and unmerge processes.
• Defined roles and responsibilities for technical team in Data Governance setup along with business team.

Confidential

Commercial MDM Architect

Responsibilities:

• Involved in requirements collection from Business and preparation of functional and technical documents for Custom MDM solution for P&C business.
• Data profiling to identify the quality, compatibility and completeness of each line of business data.
• Design and build of fuzzy match rule and deterministic match rules in Identity match engine.
• Design and build of De-duplication, Delta detection, Address standardization using Address validator processes as part of Stage process setup.
• Design and build of data consolidation process along with Manual match and unmerge processes.
• Expertise in Exception Management studio for Duplicate and bad data management using Human task configurations in Informatica data quality (IDQ) tool.
• Defined roles and responsibilities for technical team in Data Governance setup along with business team.

Confidential

Commercial MDM & warehouse Lead

Responsibilities:

• Strong implementation skill in multiple MDM, Data Quality and Integration projects.
• Experienced in software development, maintenance, testing and troubleshooting on Informatica Master Data Management (MDM), ETL/DWH applications, data quality and data integration.
• Gathering requirements from the Business and preparing the functional documents.
• Review the high-level documents to ensure the requirements documented correctly and discuss the possibilities of the new requirements.
• Review on Low level documents review the documents with Client’s IT team to make sure code is Bug free and make sure development in controlled under project timelines.
• Participate in business user meetings along with client IT leads to understand the ongoing business challenges and propose them right solution in the existing application Integration model.
• 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, 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 with 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.
• Multiple customizations using MDM user exits, Java, SIF and Oracle.
• Perform impact analysis on data issues and data integration due to new project deployments and collaboration with third party vendors for successful project go live.
• Contribution to platform upgrades and application software upgrades by doing end-to-end testing validation along with project team.
• Participate in review meetings to validate support deliverable metrics and KPI s for various parameters such as Incidents, change requests, Problem tickets, service requests, configuration management etc.

Confidential

MDM Integration /Data Migration Lead

Responsibilities:

• Has designed, developed & tested the technical architecture and Data Quality, batch framework to adopt data migration to SAP using INFORMATICA.
• Played Lead role and managed the team from offshore.
• This is a global implementation to be used for 46 countries across the globe.
• Preparation of data migration templates with client team key users
• Has designed, developed & tested the technical architecture and batch framework to adopt data migration to SAP using Informatica Powercenter and Data Quality tool.
• Configuring & Customizing MDM Hub console & IDD application
• Configuring match and merge setup and optimizing the match rules in MDM
• Address standardization using Address Doctor and Informatica Data Quality tools.
• Configuring match and merge setup and optimizing the match rules in MDM
• Data quality solution using IDQ tool.
• Responsible for custom specific data migration from legacy SAP system to GSI SAP system using INFORMATICA power Center tool
• Requirements fitment Analysis and Gap Analysis
• Effort Estimation Calculations