SUMMARY:

• Certified Informatica MDM Multidomain 10: Developer, Specialist
• Over 6 years of hands on experience as a MDM Hub Developer specialized in design, development, testing and maintaining MDM systems using Informatica MDM product suite (MDM hub, IDD, Hierarchy Manager tool and SIF) and Power Center 9.5/8.6.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Masters graduate in MIS with hands - on experience design, build and implementation of MDM applications
• Deep product knowledge on Informatica MDM Hub, Informatica Data Director (IDD), Business Entities, Business Entity Services, Hierarchy Management(HM), Match/Merge process, ETL, SIF, IDD Java User Exits
• Certified Java developer
• Team player with strong problem-solving skills, analytical skills and excellent communication skills

SKILL:

Technical Skills: Informatica Master Data Management(MDM), SIF APIs, IDD, Business Entity

GUI Tools: Informatica MDM Hub, IDD, Eclipse Indigo, TOAD for Oracle 11g, SQL Developer, SQL Server Management Studio, Visual Studio, MS Office Tools, Power Center, SOAPUI

Programming: Java, C#, C, C++, SQL, PL/SQL, T-SQL, ASP.NET, JavaScript, HTML, CSS, JQuery

Web Services: REST, SOAP

WORK EXPERIENCE:

Informatica MDM Consultant

Confidential, Cincinnati, OH

Responsibilities:

• Developed a web application to insert data real-time into MDM Base Objects using SIF APIs, Java Spring and Business Entity Services
• Deployed applications on Pivotal Cloud Foundry(PCF) and bound messaging services for sending real-time payloads
• Configured build using Jenkins to get the source code from GitHub and deployed the built application to cloud services
• Analyzed the existing MDM jobs like staging, loading and match rule sets and changed them to improve the performance of the system
• Automated the process to find errors during real-time transactions by using SQL queries and IDQ mappings

Informatica MDM Engineer

Confidential, Houston, TX

Responsibilities:

• Configured IDD and Entity 360 application for the Business users to create/update/read the Wells, Boreholes and Fields
• Developed MDM WebServices application to publish the Wells from MDM to SAP and then update the wells back in MDM using SIF APIs in Java Spring Boot application
• Created Business Entity Services External calls using Java and configured the WSDL and SOAP Calls to add validations for business users in Entity 360
• Solved production bug for IDD Match and Merge in MDM 10.2 HF2 version by proposing workaround to the client in minimal time
• Automated the MDM Nightly process by scheduling jobs in Rundeck scheduler
• Developed IDD User Exits to cleanse the addresses entered by the users in IDD
• Developed external links to Bing Maps in the Business Entity View so that users can get the exact location details of the business entities based on latitude and longitude values present in the business views
• Configured Smart Search for the business users to search and update the records in Entity 360
• Applied Hotfix to MDM 10.2 HF2 to solve production issues related to MDM Match and Merge and IDD
• Created Match and Merge rules by adding match paths, match columns and match rule sets to find potential duplicate Boreholes, Wells and Fields
• Solved production issue related to MDM trust rules by identifying the root cause related to trust decay
• Created MDM Validation rules to degrade the trust scores for faulty Address fields
• Created MDM cleanse functions in MDM Hub to validate the IDD user entered fields by importing IDQ Web Services
• Developed AVOS Business Entity tasks and displayed the tasks assigned to each logged in user in Entity 360 start page

Informatica MDM Hub & SIF Developer

Confidential, Folsom, CA

Responsibilities:

• Configured IDD application by developing cleanse functions, custom cleanse functions and Java user exits well versed in implementing SIF
• Worked as an Informatica MDM Developer/ Consultant using Informatica MDM 10.2
• Designed data model along with the hierarchies, relationships and entities for product and customer domains
• Developed Business Entities, Business Entity Views and transformations using provisioning tool to generate a business entity schema that can be utilized by Entity 360 and Business Entity services
• Configured AVOS workflows and integrated them with MDM so that the tasks can be monitored using ActiveVOS console
• Developed transformations, mappings, mapplets, Java transformations in Informatica Power Center to consume the SQL server data and expose the mapplet as a web service
• Integrated MDM with Informatica Address Doctor Cloud for Address cleansing.
• Created IDD reports using Jasper Report Tool and modify/deploy BDD configuration to add reports
• Writing Unix Scripts to call MDM jobs (Stage and Load) using Crontab time based job scheduler
• Worked with Informatica support team to resolve existing MDM and Data Analyst product bugs
• Performed Admin Tasks using Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment
• Applied Data Governance processes and best practices

Informatica MDM Developer

Confidential

Responsibilities:

• Actively participated in discussions, via telephone, email and in person with the onsite as well as offshore team, where requirements, design, build, testing defects and implementations were discussed
• Developing mappings using in-built cleanse functions, custom Java cleanse functions and Address Trillium functions for staging process as well as for IDD
• Developed Match paths, Match Columns, Match rule sets and Match rules (Exact and Fuzzy) for Match and Merge Process in Informatica Hub.
• Configured staging, loading, cleansing, matching, merging of MDM data to get single of golden data
• Created and Developed Informatica Data Director (IDD) application to allow Data Stewards to search, view and edit and delete the master records
• Analyzed the data and defined Trust scores and Trust score validation rules to get golden record BVT for Party and Customer data
• Used SIF APIs (GET, SearchMatch, PUT, CleansePut) to search, update, cleanse, insert and delete data
• Created Subject Area Group, Subject Areas, Subject Area Child and Subject Area Grandchild to organize data in IDD
• Developed IDD user exits using JAVA, Object oriented programming concepts, SQL, RDBMS concepts on Address, Relationships and Party data for MDM IDD application development
• Created very complex SQL queries on Oracle 11g/12g database to check record count and data integrity issues
• Configured data security in IDD to restrict unauthorized users from accessing and enriching IDD data
• Created search queries for each subject area in IDD to allow the Business users to search for the required data
• Configured schema, landing tables, staging tables, base objects, lookup tables, batch jobs, queries and packages
• Created Tasks in IDD and added actions to the tasks as part of the IDD workflow configuration
• Created custom Java cleanse functions and bound those cleanse functions to the columns in the IDD to cleanse the data and report validation errors
• Created PL/SQL Stored Procedures, Packages, Indexes, Views and Triggers to validate data on Informatica Hub
• Worked independently during UAT and Go-Live activities and fixed critical issues to ensure successful release
• Conducted Knowledge Transfer(KT) sessions on Informatica Data Director (IDD), Informatica MDM Hub and User Exits