SUMMARY:

• 11 + 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 10/9.7/9.5, Services Integration Framework (SIF) APIs, Java/J2EE, EJ B 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 12c/ 11 g/10 g, DB2, with good programming skill in SQL and PL/SQL Technologies.
• Extensive experience on Weblogic with MDM Hub 10/ 9.7/9.5, 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 10/9.7/9.5

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, AWS

GUI Tools: MDM Hub 10/9.7/9.5, 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)

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, Charlotte

Senior MDM Architect

Environment: Inormatica MDM 10.1, IDD, SIF, Soap UI Tool, Oracle, JBoss 6.2, Unix

Tools: SQLDeveloper, Soap UI Tool, Eclipse

Responsibilities:

• Design database model based on business defined elements
• 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, 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, AWS

Tools: Used: Informatica Multidomain MDM 9.7, DB2, SQL Developer, Eclipse

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, Unique constraint issue during tokenization process
• Get, SearchQuery, Put, CleansePut, SearchMatch etc SIF APIs to develop complex application to communicate with Hub Server and process the data from Base Object.
• Worked with Informatica Team to do initial MDM AWS setup

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

Tools: Used: 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

Tools: Used: Informatica Multidomain MDM 9.7, Oracle 11g, SQL Developer, Eclipse

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, 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

Tools: Used: Rational Application Developer (RAD 8.0), CVS, SVN, Oracle SQL Developer

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

Technologies: JAVA, Srtuts1.2, XUL, Swing, DB2, J2EE (JSP and Servlets), Java ScriptOther: Client supplied Tools, Archiva repository, Artifactory repositoryOperating System: WINDOWS XP

Database: DB2

Responsibilities:

• Involved in Knowledge Transition with Confidential - 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,

Confidential

Programmer Analyst

Technologies: RCP, JAVA, PAI, DB2

Other: Design pattern, Plug-in development

Operating System: WINDOWS XP

Responsibilities:

• Appeared for monthly audits
• Communication with the Client and Onsite team whenever required
• Interacting with the client for system study, requirements gathering, estimation, analysis and scoping,
• Worked as Defect Prevention coordinator.
• Project Planning and Tracking, Configuration Management (CVS tool), Code Reviews, troubleshooting & Defect prevention,
• Preparing Weekly and monthly status reports
• Involved in all the activities from estimation to unit testing for work packages and issues