SUMMARY

• 14+ years of total experience in Information Technology Industry and 3.2 years experience with Informatica MDM tool and 5.3 years with Informatica ETL tool.
• Extensive experience in Installation and Configuration of Informatica MDM Hub, Cleanse and Match Server
• High exposure on MDM Hub configurations - Data modeling for System Sources, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, Hierarchy Manager.
• Expert in Creating Landing, Staging and Base Object Tables and defining Foreign Key relationships, Lookups in the Hub.
• High developing experience in Mappings Data from Landing to Staging and use cleanse functions.
• Good work exposure on Hierarchy Manager to develop to Hierarchies as per the business needs.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Developed Put and Display packages for both Hierarchy Manager and IDD Application.
• Excellent knowledge in configuring the Match and Merge Rules in the MDM Hub by defining properties for Fuzzy and Exact match, creating Path components, Columns and Match Rule Sets.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Good hands on experience on publishing Data by configuring 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
• Skillful in developing Web Service by using SIF APIs to get registered Operational Reference Store (ORS).
• Practical experience in using SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge and Unmerge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Good knowledge in Transaction Management in SIF Environment.
• Data Validation and Data cleaning using User Exits.
• Participated in requirement gathering and preparation of High level and Low level Designs throughout the Software Development Life Cycle. Very good in understanding the MDM requirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications.
• Expertise in implementing Service Oriented Architectures (SOA) with JAX-WS - Web Service.
• Strong database experience in Oracle 10g/11g, DB2, with good programming skill in SQL and PL/SQL Technologies.
• Extensive experience on Weblogic with MDM Hub 9.7, WebSphere 6.0+ and RAD8.0, Eclipse, XML Spy, SOAPUI Tool.
• Worked extensively version control using RTC (Rational tool), SVN, CVS, VSS (Visual Source Safe), MKS Integrity client, Archiva along with defect tracking tool such as Polarion, CISM, JIRA
• Excellent knowledge on J2EE design patterns such as Singleton Design Pattern, Factory Design Pattern, Front Controller Design Pattern, N-Tier Architecture, MVC Architecture

TECHNICAL SKILLS

Tools: Informatica MDM Hub 9.5/9.7/10.1 , Informatica power center 8.x/9.x.

Programming Methodologies: Agile Methodology, Water fall Software development methodology, Object Oriented Analysis and Design (OOAD), Unified Modeling Language (UML).

Product Platforms: Informatica MDM, WebSphere 6.0+, JBoss, Tomcat, Weblogic

Language/Technologies: Services Integration Framework (SIF) APIs, Web Services, WSDL, XML, XSD, Core Java, JSP, Servlets, J2EE, EJB, SOAP, StrutsGUI Tools: MDM Hub 9.5/9.7, RAD 7.0/7.5/8.0, Eclipse, SoapUI Tool

Configuration Tools: RTC, CVS, SVN, MKS Integrity client

Defect Tracking Tools: Polarion, CISM, JIRA, RTC (Rational Team Concert)

Database: Toad, Oracle10g/11g, DB2, MS-Access

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE

Confidential

MDM Developer

Responsibilities:

• As a MDM Developer, key activities performed include:
• Involved in gathering business requirements from the business users in understanding the new enhancement changes such Populating GPM ID for each record
• Design and implementation of Post Landing User Exit for updating landing table with GPM IDs, Post Stage User Exits for achieving online unmerge and deferred unmerges
• Configure Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Configure Informatica Data Services to populated data in IDD using MDM and ODS database. IDS Services also available for custom applications
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes. Batch groups are created and parallelism is achieved by configured table execution sequentially.
• Provide solution approach for fixing online unmerge and deferred unmerge.
• Knowledge transition to business team about new functionality in Informatica MDM 10 such as smart search, composite services and composite object, MDM migration from MDM 9.7 to MDM 10
• Fix issue of child unmerge using MDM9.7.1 HF4
• Get, SearchQuery, Put, CleansePut, SearchMatch etc SIF APIs to develop complex application to communicate with Hub Server and process the data from Base Object.

Environment: Informatica MDM 9.7, Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, DB2, Windows 7, Weblogic, Informatica Multidomain MDM 9.7, DB2, SQL Developer, Eclipse

Confidential, Columbus, IN

MDM Developer

Responsibilities:

• As a MDM Developer, key activities performed include:
• Involved in gathering business requirements from the business users in understanding the MDM SIF Web Services needs and user exits
• Configured different Source Systems such as ALARS, LKP, CITA of RMVM System in MDM Hub, Configured MDM tables in the following sequence: Landing Tables, Staging Tables, Base Objects .
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Worked closely with RMVM Business team in identifying match columns and setting Match Rules (Party Org and Party Person)
• Involved in process of identifying and configuring the Match paths, Match Columns and Match rules for Exact and Fuzzy the Match and Merge Process.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Develop MDM SIF web services for real time out bound operations from internal and the external applications
• Designed and implemented User Exits for Validation such CITA date and active indicator validation etc, Back End Processing of Data and Error Handling.
• Used SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Worked closely with Informatica support to solve various defects and got it resolved. Proxy error during communication with MDM hub, 9.7.1 HF3 issues, consolidation indicator 1 issues.
• Worked with other supporting teams such as Legacy systems to verify a record created or updated in database is reflected in all downstream systems (Update Address case)
• Custom implementation of Address doctor in SIF Web Services using MDM Hub Address doctor.

Environment: Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JNDI, JDBC, SOAP1.1, WSDL, SOAPUI Tool, CVS, XML 1.0, XSD, Oracle 11g, Windows 7, Weblogic. Informatica Multi-domain MDM 9.7, Oracle 11g, SQL Developer, Eclipse, XML Spy.