SUMMARY

• Experience in Informatica Master Data Management practices and concepts. Experience working with business functions to gather requirements, design/implement solutions and development.
• Good knowledge of Master Data domains, such as Customer, Vendor and Item Master Data.
• Experience in Mastering data for Retail, Insurance and Health Care industries.
• Hands on Knowledge of Informatica MDM including IDD, HM, Match / Merge Process, various models of MDM implementation.
• Experience in MDM configuration, business rules, batch jobs, real time data loads, security management SAM, hierarchy management.
• Development skills having IDD configuration and customizations as per business needs - Experience with troubleshooting the Informatica MDM technology.
• Good Knowledge of Core Java Development experience, working with JMS queues/topics for publishing/subscribing data.
• Good knowledge on message queues, Services Integration Framework SIF, Active VOS.
• Experience in understanding End to End Architecture and working with other teams to fix the issues.
• Experience in multiple MDM tools such as SASMDM, DATAFLUX, ORACLE MDM (CDH) and Informatica MDM.
• Good knowledge on data quality tools like Data flux, Oracle EDQ and IDQ.
• Designed and developed complicated jobs and packages for Delta loading, customer creation and update in DATAFLUX DFPower studio, ORACLE CDH and Informatica MDM.
• Experience in pulling data from multiple source system and loading into MDM HUB.
• Experience in defining the business rules, validation and cluster condition on the data assets to achieve master data management “single version of truth”
• Experience in Defining Concurrent Programs, Request Sets, and Executables.
• Experience in creation of PL\SQL Packages, Procedures and Functions.
• In depth knowledge in MDM concepts, Data Profiling, Data Staging, Cleansing, Clustering, Data Migration, Data Match and Merge.
• Experience in Oracle EBusiness suite 12i integrated environment
• UndergoneConfidential for Data Warehousing Concepts, INFORMATICA Power center, SAS DI, ODI, Hadoop, Hive, Pig and MapReduce.
• Exposure and working experience in all phases of SDLC like Requirements definition, Analysis & Design, Development, Testing and Deployment.
• Experience in Client end users in the testing methodology, procedures and tools used to perform testing.
• Assists in enforcement of project deadlines and schedules.
• Analyze the data migrations/Conversions, Mappings and collaborate with Business Users and developers to analyze Business and functional requirements
• Verify and Validate the Upstream Systems to allow for creating and entering different new transactions in Systems.

TECHNICAL SKILLS

Operating Systems: AIX 5.0, Windows, MAC

Languages: Java, SQL, PL/SQL, Shell Scripts and XML

Databases: Oracle, SQL Server.

Web Applications/Servers: WebLogic, JBOSS

Tools: SAS MDM, Oracle MDM (CDH or Customer Data Hub), Informatica MDM

Others: Informatica ETL, SAS DI, ODI, Hadoop, IDD

PROFESSIONAL EXPERIENCE

Project Lead

Confidential

Responsibilities:

• Define roadmap and architect Informatica MDM solutions for MDM engagements;
• Provide effort estimation and solution definition for MDM users and Customers ·
• Need to perform Data Modelling and Data Profiling, especially in Healthcare and Life science Domain
• Work extensively on the Customer Data Model.
• Guide through the MDM strategy formulation · Responsible for defining the overall solution architecture ·
• Derive physical data model for the MDM Hub · Data Profiling and Data Assessment for Customer Data Sources. Create Data De Duplication, Trust and Validation Rules.
• Capable of doing deep dive analysis in MDM core problematic areas like Match & Merge, User Exits, Cleansing and Standardizations.
• Liaison with Business to identify Business Priority Items and provide articulation in MDM Space including Enhancements and Upgrade
• Deep dive analysis in MDM core problematic areas like Match & Merge, User Exits, Cleansing and Standardizations
• Derive physical data model for the MDM Hub · Data Profiling and Data Assessment for Customer Data Sources.
• Real time integration with various sources using SIF (Service Integration Framework).

Software Used: Informatica MDM 10.1, Informatica Data Director (IDD), Service Integration Framework (SIF), Java

Confidential

Responsibilities:

• Experience in Installing Informatica MDM 10.1 and ActiveVOS in server and local.
• Experience in exploring new features in Informatica MDM 10.1.
• Experience in Working on mock projects to get projects.
• Participation in requirement analysis and preparing case studies.• associates to configure MDM and IDD.

Software Used: Informatica MDM 10.1, IDD

Confidential

Responsibilities:

• Understanding the requirements and designing.
• Understanding the Client Application and data Model.
• Understanding the end-to-end process of the project
• Identifying the gaps in existing model.

Software Used: Oracle MDM, Oracle EDQ

Senior Developer

Confidential

Responsibilities:

• Experience working with business functions to gather requirements, design/implement solutions and development.
• Experience in creating Base Objects, Landing and Staging Tables.
• Experience in configuring Cleanse Functions, mappings for stage process.
• Experience in configuring Match rule sets, Match Columns for Match and Merge Process and Hierarchy.
• Experience in defining System Trust and Validation rules for base object column
• Experience in Creating and deploying applications in Informatica Data Director and binding application to a specific ORS
• Good knowledge on SAM configuration & Both MDM & IDD User Exits.
• Experience in Creating Queries, Query Groups and packages in MDM Hub Console.
• Identifying the gaps in requirement and being part of preparing HLD & LLD documents.
• Travelled onsite to interact with bussiness.
• Experience in working closely with ActiveVOS and ETL team to implement solution.
• Knowledge on Address doctor, Message Queues, SIF and ActiveVOS.

Software Used: Informatica MDM 9.7.1, IDD, User Exists, ActiveVOS

Senior Developer

Responsibilities:

• Understanding the requirements and designing accordingly.
• Understanding the Client Application and data Model
• Understanding the end-to-end process of the project and designing as per downstream requirements.
• Identifying the gaps in requirement
• Development of PL/SQL Packages for CRUD (Create, Update and Get) operations.
• Coordinating with Other Tracks for Integration.
• Development of De-dupe and diff Match scenarios.
• Worked on Bulk Load.
• Experience in defining Concurrent Programs, Request Sets, and SQLLoader.

Software Used: Oracle MDM (CDH or Customer Data Management)

Developer

Confidential

Responsibilities:

• Understanding the requirements and designing accordingly.
• Creation of the Meta data file and data model designs.
• Involved in developing various DataFlux jobs for implementing the various services provided by MDM for SBIGI like Creating, Updating, searching a Party
• Involved in developing SQL scripts to create Tables, Views, Triggers, Functions and Procedures.
• Involved in developing Standardization jobs, generating match codes, Initial Data Load from staging table to target tables
• Standardization of Data using QKB (Quality Knowledge Base)
• Preparing SQL scripts to collect data from legacy systems of NIC
• Preparing jobs using Data Flux for Data profiling, Clustering and Data quality analysis.
• Responsible for creating repositories, Developed business rules for Party Master using DataFlux Business Rules Manager
• Involved in bug fixing and enhancements. As part of this, actively worked from offshore with the onsite developers providing solutions to the tasks assigned
• Communicating with testers, giving clarifications and resolving the problems
• Involved in developing jobs, PL/SQL Triggers for Data Steward Functionality from Scratch. Given /presentation on Data Steward to SBIG.
• Involved in developing PL/SQL Scripts for House Hold Functionality and House Hold Publisher Program using JAVA and delivered and integrated with CRM.
• Development and enhancement of MDM Web Service and LOV Application ( Data).
• Involved in peer discussions with client and other tracks.

Software Used: SAS MDM, Oracle 10g, Data Flux.

Confidential

Responsibilities:

• Implementing User screen using Java.
• Creation of Tables to maintain the Employee data and Attendance.
• PLSQL scripts to store and perform logic on data.
• Internship program.