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

TECHNICAL SKILLS

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

ETL: Informatica IDQ / Informatica PowerCenter Worked on the Developer and Analyst tool

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

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

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Informatica MDM Senior Developer

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

Responsibilities:

• 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

Confidential, Minneapolis, MN

Informatica MDM Senior Developer

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

Responsibilities:

• 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.

Confidential, Chicago, Illinois

Senior MDM Developer

Environment: Informatica MDM 10.4 Upgrade Experience

Environment:

• 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.

Confidential, Santa Clara, CA

Senior Informatica MDM Developer

Environment: Informatica MDM 10.0/ 10.1, Jboss, Oracle

Responsibilities:

• 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

Confidential, Minneapolis, MN

MDM Developer

Environment: Informatica MDM 9.5 / 10.1, Oracle, Jboss

Responsibilities:

• 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

Confidential, Minneapolis, MN

Senior Developer

Environment: Informatica MDM 9.6, Informatica PowerCenter 9.6, Oracle 11g, PL/SQL Developer, Windows

Responsibilities:

• 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

Confidential, Minneapolis, MN

Software Developer

Environment: Informatica IDQ, Oracle 11g, PL/SQL Developer, SQL Server 2008, Windows

Responsibilities:

• 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.