SUMMARY

• 9+ years of experience in Application Analysis, Design, Development, Integration, deployment and maintenance/support for Web, Standalone and Server side/backend development application in Manufacturing and Logistics, Telecommunication and Transportation domains using Informatica MDM 9.5/9.7/10.x, Services Integration Framework (SIF) APIs, Java/J2EE, EJB and Web Services technologies.
• 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.
• Excellent hands on experience in developing application using JAVA, J2EE (JSP, Servlets, EJB), Web Service, XML, XSLT, XSD and Jakarta Struts Framework (Struts 1.2)
• 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

EIM Tools: Informatica MDM Hub 9.5/9.7/10.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, Struts

GUI 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

Framework: Model View Controller (MVC) using Struts 1.2, Service Oriented Architecture (SOA using Web Services)

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior MDM Architect

Environment: Inormatica MDM 10.1, IDD, SIF, Soap UI Tool, Oracle, Weblogic

Responsibilities:

• Analyze source elements and target landing table elements and provide mapping document
• Finalize source system and trust configuration with help of business team
• Propose various solution approaches for EIP ID value survivorship
• Design and implement cleanse functions (Graph functions, cleanse list etc, regular expression for Phone, Email, Zipcode)
• Create Landing, Staging and Base object table
• Define relationship and referential integrity for Party and it’s child tables
• Configure exact and fuzzy match rules
• Configure Hierarchy
• Fine tune the match rules
• Develop custom code to delete specific number of records from base objects, also for deriving EIP ID in Post Merge User Exit
• Run SOAP UI tool to clean tables
• Issue noticed - Load job failure due to Smart search enabled in server config and not in cleanse properties file. Maximum open cursor issue during merge job - to fix it increased db cursor size.
• Configure IDD application with Hierarchy enabled
• Active VOS configuration and creation of merge task for data stewards
• Active VOS task approval process configuration

Confidential, CA

MDM Senior Developer

Environment: Informatica MDM 10.x, ETL, Services Integration Framework (SIF) APIs, IDD, Log4j, JDBC, WSDL, SOAPUI Tool, Oracle, Windows 7, Weblogic

Responsibilities:

• Gather business requirement to enhance IDD application for customizing 3 level hierarchy using IDD User Exists
• Develop ETL mapping, workflows to enhance Partner master functionality
• Update and add new column, mapping, stage and load job related configuration in MDM Hub
• Write SQL loader script for data load activities
• Work of Informatica support team to fix special character reject issue, null period start date and end date issue
• Work with Data Stewards to enhance and optimize IDD application

Confidential, Metlife, NJ

MDM Architect

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

Responsibilities:

• Involved in gathering business requirements from the business users in understanding the new enhancement changes such Populating Confidential ID for each record
• Design and implementation of Post Landing User Exit for updating landing table with Confidential IDs, Post Stage User Exits for achieving online unmerge and deferred unmerges
• Confidential MDM is populated from sources such as ML, AXM, AXMP
• 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 sequencially.
• 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.

Confidential, Quincy, MA

MDM Integration Specialist

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 Multidomain MDM 9.7, Oracle 11g, SQL Developer, Eclipse, XML Spy

Responsibilities:

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

Confidential, Atlanta, GA

MDM Developer

Environment: Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, Oracle 11g, Windows 7, Weblogic

Responsibilities:

• Involved in gathering business requirements from the business users in understanding the new enhancement changes such Use of Google API for Geocoding calculation
• Design and implementation of Post Landing User Exit for providing sleep functionality after each record processing due business limitation on number records per second processing.
• Configured the new BO, Staging and Landing Table as per business requirement
• Configure Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Worked closely with PowerCenter team in order to implement sleep functionality for processing records.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Provide solution approach for Hard Delete Detection (HDD) process
• Develop prototype MDM SIF web services for real time out bound operations from internal and the external applications such as Netezza.
• 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 for Geocoding calculation issues

Confidential, NJ

MDM Developer

Environment: Informatica MDM 9.5, Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, Oracle 10g, Windows 7, JavaScrip, Weblogic

Responsibilities:

• Involved in gathering business requirements from the business users in understanding and fixing IE11 redemption.
• Configure new Landing, Staging and BO Tables as per schema design changes
• Define and Configure Relationships and Lookups
• Configure Match Path, Match Columns and Create Match Rules and other match process related properties as per business requirement
• Run the Stage, Load, Tokenization, Match and Merge job for consolidation of records
• Create new and update existing Batch Groups for new enhancements
• Design and implementation of SOAP Web Service to provide data from Informatica MDM to calling application such as APIGEE.
• Provided detailed view about Informatica Data Director
• Updated existing Packages and Queries as per changes request for Custom application enhancement such adding new search functionality to HCP Search application
• Prepare Requirement, Interface Design and Detailed Design document, also provided Test Case documents
• Deploy and Test application in Development, QA and Production Environment
• Knowledge sharing for Technical things such as Java, JavaScript, Weblogic Administration, PowerCenter Tasks etc.
• Fix the match rule changes related issues with Informatica Support team

Confidential, NY

Technical Lead

Environment: Java 1.5, EJB 3.0, JAX-WS Web Services, Log4j, SOAP 1.1, WSDL, SOAPUI Tool, CVS, XML 1.0, XSLT, XSD, ANT Script, Message Driven Beans (MDB ),Oracle 11g, DB Objects such as Stored Procedures, Triggers, Views, Log4j, Unix Box, Find Bug, Windows 7

Responsibilities:

• Designing new enhancement request. This includes use of OOAD Design Pattern to come up with the optimal system architecture.
• Developing new Web Services using JAX-WS technology along with use of SOAP 1.1, WSDL, XML 1.0, XSLT and XSD
• Developing business component using EJB 3.0, Log4j and developing parser for soap request using SAX parser.
• Maintaining the code repository such CVS, SVN
• Testing new enhancement using SOAP UI tool, Unix Box
• Involved in Knowledge Transition, Application documentation and Development Environment setup configuration for Rational Application Developer RAD8.0
• Preparing Test Case document, executing the Test cases in Local/Development/Integration Test Environment/ Production environment.
• Onshore/offshore communication for Design Document review, Code review, Test case review etc. whenever required
• Using Oracle SQL Developer for fetching data from database and inserting data into database whenever is needed.
• Active participation in Defect Prevention (DP) meeting for maintenance quality of application
• Understand the training requirement and participate for the it (e.g. Web Services and Agile methodology training)
• Carrying out activities such as Configuration Management (CVS tool), Code Reviews, troubleshooting & Defect prevention, creating JIRA defects etc.

Confidential

Associate

Responsibilities:

• Involved in Knowledge Transition with T- Systems and Daimler Confidential Germany
• Application documentation and Development Environment setup configuration
• Communication with the Client and Onsite team whenever required
• Involves in defect analysis and providing the solution within time limit
• Project Planning and Tracking, Configuration Management (SVN tool), Code Reviews, troubleshooting & Defect prevention,
• Monitoring development activities, delivering & implementing the project as per scheduled milestones,