Preetham Kumar (Informatica MDM Professional)

E-Mail: admev9@r.postjobfree.com Current Location: Minneapolis, MN Mobile: +1-210-***-**** Resume Summary

IT Professional having 6 Years of experience in analysis, design, development in Enterprise Data Integration Platform (Informatica MDM / Informatica IDQ / Informatica Powercenter ) along with RDBMS Oracle PL/SQL development

Technology/Skills Details Experience

Skill-1:

MDM- Informatica Master Data Management Development and Support

Senior MDM Developer with Experience in Informatica MDM along with all the MDM components, including MDM Hub / IDD / E360 / Provisioning / SIF Api / BES Api / External Calls / Hub User exit / IDD user Exit / Installation and configuration 6 Years

Skill-2:

ETL – Informatica IDQ / Informatica PowerCenter

Worked on the Developer and Analyst tool

Skill-3:

Oracle PL/SQL Development

Worked as Programmer Analyst on Oracle Pl/SQL 9i/10g/11g for Product development

Tools/Product Used Details

Tools

MDM 10.4 /MDM 10.2, IDD / Provisioning / E360 / Business Entity / SQL Loader, Data Modeler- ER- Win, SQL Server, SVN, JIRA

Project 1 Shell International

Client Shell, Minneapolis, MN, United States

Role Informatica MDM Senior Developer

Team Size 4

Domain Retail – Petrol Pumps

Skills

Informatica MDM 10.4 Hub / IDD / Provisioning / Entity 360 / Active VOS / Hierarchy / SIF API, BES API / Java External Calls / Informatica IDQ

Duration of project

May 2020 - Till Date

Project Description:

This project involved migrating the Shell existing Retail Domain data related to the petrol pumps from Sap MDM to Informatica MDM. Shell Retail is the world’s number one mobility retailer. It is one of the oil and gas "supermajors" and the fifth-largest company in the world Key Responsibility:

Understand the business functionality of all the systems and understand the integration requirements.

Load the data using IDQ into the MDM landing layer.

Worked on basic transformation including Aggregator, Expression, Filter, Joiner, Lookup,Normalizer,Rank,Router transformation.

Involving in discussions with business people and technical Architect to build requirements for the project.

Worked under the architect’s supervision to provide MDM technical services using Informatica technology.

Worked on mapping spec to point out the data flow and relationships for the MDM schema.

Creating lading tables, Staging tables and base objects. Involved in Independent Client Calls and presenting Daily Status report to client.

Configuration of business rules configurations like trust settings, match and merge rules.

Creating queries, packages and working with data manager to create display packages and custom packages.

Created mappings to move the data from landing tables to staging tables. Load the base objects and used Trust and Validation rules.

Promoting the MDM changes from once environment to another Environments.

Configuring the Provisioning tool to configure the E360 Business Entities and the E360 UI

Worked on Elastic Search

Worked on MDM Java External calls

Creating reusable Mapplet’s for current and future business requirements to deal with the source data while loading.

Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD.

Using DNB Adaptor for Address data correction

Project 2 Customer MDM

Client Name Medtronic, Minneapolis, MN, United States Role Informatica MDM Senior Developer

Team Size 6

Domain HealthCare

Skills

Informatica IDQ 9.6, Informatica PowerCenter 9.6, Informatica MDM 10.2, Informatica Address doctor / E360 / Provisioning

Nov 2019– Jun 2020

Project Description:

Mastering the Customer Data, By extracting the customer data from different source systems and store unique data from different sources in centralized repository and then load this data into Informatica MDM and prepare single version of truth (Golden data) and Pass this data to downstream system and different source so that data can be used effectively for multiple requirement and make life easy. Key Responsibility:

Understand the business functionality of all the systems and understand the integration requirements.

Involving in discussions with business people and technical Architect to build requirements for the project.

Worked under the architect’s supervision to provide MDM technical services using Informatica technology.

Building the party hierarchy data model and defining the relationships between entities in HM.

Involved in match merging process by using exact match and fuzzy match logic types.

Creating lading tables, Staging tables and base objects. Involved in Independent Client Calls and presenting Daily Status report to client.

Configuration of business rules configurations like trust settings, match and merge rules.

Creating queries, packages and working with data manager to create display packages and custom packages.

Created mappings to move the data from landing tables to staging tables. Load the base objects and used Trust and Validation rules.

Creating reusable Mapplet’s using IDQ for current and future business requirements to deal with the source data while loading.

Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD. Project 3 Informatica MDM - Upgrade/Enhancement Project Client BBH, Chicago, Illinois, United States

Role Senior MDM Developer

Team Size 6

Domain Finance

Skills Informatica MDM 10.4 Upgrade Experience

Duration of project July 2019– Oct 2019

Project Description:

This project involved upgrading their existing Organization Master from MDM 971 version to MDM10.2 version. It also involved development and enhancement of their existing application, adding a new source system, data cleansing for new source, match, and merge process and the IDD 2 level approval process. Key Responsibility:

Understand the business functionality and integration requirements of all the source systems.

Analysing the impact of adding the new source system to the current MDM implementation

Data profiling using IDQ to identify source system data issues

Designing a web service layer for search and create in MDM

Preparing Migration documents and checklist

Configuration of business rules configurations like trust settings, validation rules, match and merge rules based on addition of existing source system

Custom IDD merge task creations configuring the 2 level

Creating queries, packages and working with data manager to create display packages and custom packages.

Involved in match merging process by using exact match and fuzzy match logic types.

Configuration of Informatica Data Director (IDD) with various functionalities like Validations using cleanse functions, ActiveVOS Task flow management.

Used Address Doctor for the address standardization.

Informatica (ETL tool) was used to extract the data from multiple source systems and load it into the Landing tables.

Unit testing and System Integration Testing.

Used Metadata manager for validating, promoting, importing and exporting the code from development to higher environments.

Creating roles, groups and giving access privilege as required.

Designing, Implemented the Inbound & Outbound interfaces to send data from MDM System to the downstream sources

Executing jobs in Batch Viewer and Batch Group.

Developed Packages for both Hierarchy Manager and IDD Application. Project 4 Informatica MDM - Organization Master

Client Name InfoBlox, Santa Clara, CA, United States Role Senior Informatica MDM Developer

Team Size 5

Domain Security Product Domain

Skills Informatica MDM 10.0/ 10.1, Jboss, Oracle

Duration of project

Sep 2018 – July 2019

Project Description:

Infoblox delivers critical network services that protect Domain Name System (DNS) infrastructure, automate cloud deployments, and increase the reliability of enterprise and service provider networks around the world. As an MDM solution they wanted to create a master data for the Company and Address data across ERP and Salesforce systems.

Key Responsibility:

Understand the business functionality and integration requirements of all the source systems.

Informatica MDM Hub Console development

Design and create BO, staging/landing tables, mappings, transformations

Setting Trust configuration and Validation Rules

Create Match Rules and Merge Settings

Configuring data flow [ Land, Stage, Load, Tokenize, Match, Consolidate ]

Configure IDD and HM

Writing hub and idd user exit code using java

Preparing Unit testing document and Unit Testing the scenarios

Updating the Idd and Hub design documents

Coordinating with different deployment teams

Project 5 DELL EMC MDM iMap Upgrade Project

Client Name Medtronic, Minneapolis, MN, United States Role MDM Developer

Team Size 6

Domain Health Care

Skills

Informatica MDM 9.5 / 10.1, Oracle, Jboss

Duration of project Mar-2016 to Aug-2018

Project Description:

Dell EMC brings together Dell’s and EMC’s respective strong capabilities and complementary portfolios, sales teams and R&D. It seeks to become the technology industry’s most trusted advisor, providing capabilities spanning strategy development, consultative services and solution deployment and support customers and partners drive the digital transformation of their businesses. This project involved upgrading their existing Organization MDM fr.om MDM951 version to MDM10.1 version

Key Responsibility

Involved in initial analysis of Migration process

Preparation of Migration Approach Document

Running the Readiness Script to ensure there are no errors

Running upgrade script to upgrade the cmx_system and ors environment from MDM 9.5.1 to MDM 10.1

Installing MDM 10.1 hub/cleanse and resource kit

Configuring the Jboss Application Server

Analyze the existing pl/sql code functionality and rewrite the code in Java

Running post migration steps

Coordinating with different deployment teams

Project 6 Given Tech SAP to Salesforce Integration Client Name Medtronic, Minneapolis, MN,United States Role Senior Developer

Team Size 4

Domain Health Care

Skills

Informatica MDM 9.6,Informatica PowerCenter 9.6, Oracle 11g, PL/SQL Developer, Windows Duration of project Aug-2015 to Feb-2016

Project Description:

Data Integration project, In which we publish ERP sales history Incremental data based on certain parameter to the Oracle Public Schema for specific regions, then subscribe the data for GIVEN TECH based on the Business requirement from Oracle Public Schema based on acknowledgement received. Transfer information between Given SAP instance and Barrx SFDC instance for the Accounts, Invoices, Install Base/Assets, Territory Management and Material Management/ Item Master objects Key Responsibility:

Requirement gathering by Consult with business analyst and architects to understand, anticipate, and meet Current and future business needs.

Analyse existing applications and systems and formulates logic for new systems, devises logic procedures, logical Database designs perform coding and tests/debugs programs.

Assist in the definition, development, and documentation of deliverables, and specifications defined in the IT Methodology, in collaboration with business analyst and other project team members.

Develop different synchronization services for Transformation and Loading and develop Oracle PL/SQL Objects like procedures, functions, pl/sql block, Sql scripts as per requirements for Critical Modules to Support the team & meet the project deadlines.

Worked with Salesforce and project team to gather ETL requirements.

Prepare high level design for Replication, Synchronization, Transformation, loading and Task flow

Management to Transfer information between Given SAP instance and Barrx SFDC instance objects as per Business requirements for ETL- Informatica development

Design, develop, modify, configure, debugs and evaluates application programs for functional business areas, Programs include interfaces, conversions, and enhancements.

Trouble Shooting of data which is partially send to cloud system salesforce dot com (SFDC),

Understand the business functionality and integration requirements of all the source systems.

Informatica MDM Hub Console development

Design and create BO, staging/landing tables, mappings, transformations Project 7 LATAM SFDC SOURCE FEED

Client Name Covidien Minneapolis, MN,United States Role Software Developer

Team Size 4

Domain Health Care

Skills

Informatica IDQ, Oracle 11g, PL/SQL Developer, SQL Server 2008, Windows Duration of project Jan-2015 to July-2015

Description:

Prepare the source feed of SFDC for different objects like ERP Account, Territory, Product SKU's, Sales History and Sales transaction for different regions like Mexico, Brazil, Panama etc. Data extracted from different sources like Flat files, Oracle Database and SQL Server Database then transformation done based on business logics then load the data to Target system SFDC by maintaining integrity of Target system. Key Responsibility:

Involve in requirement gathering, Design, development, SFDC testing, UAT and Go live Support

Interaction with client to discuss functional requirements and updates, Team handling & Preparing TDN

Maintainability of huge data by scheduled Activity, Maintain Task flow as per different time zones.

Code review and Day-to-day tasks to insure systems are up and running.

Contact this candidate