SUMMARY

• 9+ years of IT experience in Analysis, Design, Development and Implementation of Master Data Management projects using Informatica MDM working in various roles as Lead, Analyst and Developer.
• Experience in Master Data Management Technical Architecture and implementation styles providing data modeling solutions and recommendations Analyzing cleansing, various source systems data and building master data for an enterprise.
• Experience in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica /Business Data Director.
• Experience in carrying out Informatica MDM upgrades along with Database clustering implementations(SQL Server).
• Experience with Informatica MDM concepts including, but not limited to match rule configuration and tuning, workflow, job configuration and scheduling, and custom rule development and configuration.
• Extensive experience Topology design and definition along with detailed knowledge and experience in Informatica MDM installations.
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub.
• Developing the Mappings to load the Data from Landing to Staging by using various cleanse functions.
• Expertise in Informatica MDM Hub Match and Merge process, Batch Jobs, Batch Groups, Validation Rules, Trust settings for source systems.
• Demonstrated history of working in different domains like retail, health care, pharma, oil and gas, HR systems etc.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules and helped business to develop Trust Scores for MDM Hub.
• Exposure in Informatica MDM Hub Installation, Configuration and integrating external business application with informatica MDM hub using batch process.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Experience in analysis of source systems to uncover erroneous, duplicate data and integrity issues related to the data.
• Have working experience in Development, Testing and Maintenance/Support for Informatica MDM implementation projects.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Data Validation and Data cleaning using User Exits.
• Experience in Optimization and Performance Tuning of match rules as per the business requirements.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects
• Data Quality and Data integration in real-time using SIF API's
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data
• Experience in creation of subject area groups, subject areas, subject area child and search queries for managing the MDM Hub data through IDD.
• Expertise in implementing the approval process for subject areas in IDD, according to business rules and requirements.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Identified Golden Record (BVT) for Customer Data by analyzing the data cleansing and merging duplicate records coming from different source systems.
• Expertise in creating Test Plans and writing Test Cases.
• An effective communicator with excellent relationship building & possessing excellent presentation skills. Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.

TECHNICAL SKILLS

MDM tools: Informatica MDM 9.0.1, 9.1.0, 9.7.1, 10.2, 10.3

Application server: Weblogic, Websphere, Jboss

Databases: Oracle 11g/10g/9i, SQL Server 2008/2012, Oracle 12c

Languages: C, SQL, PL/SQL, Java

Database Tools: Toad, SQL Developer, SQL *plus, Oracle SQL Developer

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

Other Tools: HP Quality Center, Control M, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

MDM Consultant and Software Developer

Responsibilities:

• Drive solutions for large and complex data acquisition from internal and 3rd party sources in partnership with IT and other business units
• Work closely with business stakeholders, data architects and IT stakeholders to capture the data characteristics, metadata of the data, business rules etc.
• Review the 3rd party data, profile/scorecard data to determine data quality metrics such as data accuracy, data completeness, data consistency, data validity etc. Present the findings to stakeholders, project team and data governance team members to assess data quality.
• Determine and analyze how data fits into existing Master Data Management platform - including changes to data model (logical and physical), data cleansing rules, data standardization rules, Reference data identification
• Create detailed data mapping, data transformation document for tech lead, QA lead to validate design, data load, data transformation and data validation.

Environment: Informatica MDM 10.3, Weblogic, SQL Server 2016, Informatica Powercenter, SecureFX 8.3, Secure CRT 8.3, SQL Server Management Studio, Spring Tool Suite, Autosys.

Confidential, Smyrna, GA

MDM Consultant

Responsibilities:

• Architect Informatica MDM solutions and provide technical recommendations.
• Review business and technical requirements and ensure the data integration platform meets requirements.
• Apply industry best practices for MDM design and development.
• Perform design, development and implementation of end-to-end complex MDM system using Informatica tools.
• Plan and contribute to MDM development efforts for team utilizing Informatica tools.
• Create automated processes using SIF integration framework.
• Implementing standard jobs in java using SIF API’s and create executable files like cmd/sh etc to schedule the same in powercenter.
• Produce written deliverables for technical design, system testing and implementation activities.
• Design Data Model and build the relationships among the tables.
• Analyze the Source Data and define Match Columns, Match rules, Match rule sets and finetune them.
• Create Landing, Base, staging tables and mappings to move the data from landing to staging tales.
• Used IDQ for profiling and standardizing the data.
• Used address validation for cleansing the addresses, created score cards, human tasks, generated reports on the data as a part of Data Analysis effort.
• Created IDD application and customize as per the business requirements.
• Involve in the ETL process in getting the data loaded from the source systems to the landing tables.

Environment: Informatica MDM 10.3, Jboss, Oracle 12c, Informatica IDQ, Informatica Powercenter, Windows 10 Enterprise, Oracle SQL Developer Data Modeler, Winscp, Cygwin, eclipse.

Confidential

Informatica MDM Technical Lead and Developer

Responsibilities:

• Involved in analysis and design of MDM application, topology and integration with different application modules.
• Involved in installation of hub console, hub store, hub server and cleanse match server for the MDM implementation.
• Worked as on onsite coordinator by interacting with clients to understand the requirements and closely working with team to develop and deliver these requirements.
• Defined the Entity objects, entity types, relationship objects, relationship types and hierarchies in the hierarchy manager tool among various entities using the hierarchy manager.
• Development of Informatica Data Director(IDD) application with various Subject area and Hierarchy configurations.
• Integrating the external systems using SIF API's to consume the data into MDM.
• Upgrade from Informatica MDM 9.7.1 to 10.2
• Define and configure Match and Merge rules to standardize and refine the data in MDM.
• Configuring notification service to capture the data changes and notify downstream systems.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Carried out various data correction activities within MDM with scripts.
• Worked with ETL and IDQ developers to develop the cleanse rules and the mappings and workflows to develop ETL jobs for loading data into MDM.
• Developed IDQ mappings using various transformation like Labler,Standarization,Case Converter, Match and Address validation Transformation

Environment: Informatica MDM 9.7.1/ 10.2, Websphere, SQL Server 2008/2012, Informatica IDQ 9.6, Windows 7

Confidential, Chicago, IL

Informatica MDM Lead and developer

Responsibilities:

• Involved in Development of Hub components like Creation of BASE OBJECTS, landing table, staging table and mappings.
• Developed IDD applications which involved task workflows involving integration with OBPM to enhance the capabilities of workflows and various validations.
• Involved in defining queries, packages and query groups in the hub console.
• Involved in automatic and manual match and merge rules configuration.
• Defining trust for the various sources which contribute data.
• Loading data into staging table from landing table by running the stage jobs from batch viewer and verifying the mapping, cleanse functions provided between the two tables and checking for the records rejected while loading.
• Loading the Data into Base object from the staging table by running the load jobs and verifying the data in the trust enabled columns of the Base object.
• Fixed defects during various stages in testing such as System Testing, User Acceptance Testing.

Environment: Informatica 9.0.1, Weblogic, Oracle 10g, SQL, PL/SQL, Excel, Windows XP

Confidential, Newark, NJ

Informatica MDM Analyst and Tester

Responsibilities:

• Identification of the test scenarios, providing the test estimates.
• Loaded data into the landing tables of MDM using Power center.
• Prepared test cases for Hub configuration, designed IDD application and also carried out test case execution.
• Prepared test cases for the various match and merge rules implemented in the project to check the reliability of the final cell value after the consolidation process.
• Executed the test cases to test the accessibility of data to various users in the developed MDM implementation.
• Prepared and executed test cases to check different task workflows and manual merge process in the developed IDD application.
• To check the Data Security based on their Users and Roles and their accessibility to the various Business Processes.
• Executed test cases to check the hierarchy created in the MDM model.
• Maintaining a defect log, reporting the defects and tracking the defect status.
• Working with the end users to identify the test scenarios and preparing test cases for user acceptance testing.

Environment: Informatica 9.0.1, Oracle 11g, SQL, PL/SQL, Excel, Windows XP

Confidential, Seattle, Washington

Informatica MDM Developer

Responsibilities:

• Involved in installation of hub console, hub store, hub server and cleanse match server for the MDM implementation.
• Involved in Design and Development of Hub Configuration, Schema, Creation of BASE OBJECTS, landing table, staging table, mappings, Match rule and Merge configuration, trust settings, cleanse functions, Hierarchies and query groups.
• To keep a check on the data manipulations by users through the “DATA STEWARDSHIP” implemented via IDD previously known as BDD (Business Data Director).
• Development of IDD application with various functionalities like Validations using cleanse functions, Task flow management.
• To design workflow customizations for Data Stewards using IDD application.
• Loading data into staging table from landing table by running the stage jobs from batch viewer and verifying the mapping, cleanse functions provided between the two tables and checking for the records rejected while loading.
• Involved in the Load process of data from stage tables to base object table using load job in the schema of hub console.
• Defined Entity objects, entity types, relationship objects, relationship types and hierarchies in the hierarchy manager tool.
• Defined the relationships and hierarchies among various entities using the hierarchy manager.
• Configuring trust setting for various sources in the Hub console and testing them on the data contributed from various sources for trust enabled columns of Base object tables.
• To verify the data standardization process by testing the cleanse functions implemented in the hub console.
• Fixed defects during various stages in testing such as System Testing, User Acceptance Testing.
• Conducted trainings on Hub configuration and IDD Design.

Environment: Informatica 9.0.1, Oracle 10g, SQL, PL/SQL, HP quality center, Control M, Weblogic, Excel, Windows XP