SUMMARY

• Confidential is an IT professional with around 10 years of experience in developing, testing and managing enterprise applications in technologies like Java/J2EE based web applications, web services, master data management(MDM), data analysis & data relationship management in retail, healthcare and life sciences domain.
• Worked extensively in MDM technologies like Addition, Extension, Business proxy, handler modification and customization in IBM MDM, SIF & Web services creation and implementation in IBM & Informatica MDM. Also worked in initial requirement gathering, source system identification and adding, algorithm configuration for MDM engagement.
• Involved in MDM match and merge logic, ETL to MDM mapping, complex SQL queries, business logic validation and implantation, customer 360 degree view generation and source of truth identification for customer and location hub implementation project in financial, healthcare and retail assignments.
• For last 7 years he worked in MDM Hub configurations, Data modeling & Data Mappings, Data validation, MDM architecture solution, building and customizing services. Data integration, Data Quality, Data Architecture and MDM best practices and processes in several implementation (IBM MDM & Informatica MDM) in several onsite & offshore assignments.
• Attended JAD session for requirements analysis, functional specifications and gap analysis in analytics and information management solutions.
• Worked MDM (Master Data Management) customer hub and location hub implementation & enhancement architecture definition.
• Experience in member master or Enterprise Master Confidential t Index (EMPI) development & support.
• Worked both in physical and virtual MDM implementation & data integration project.
• Worked in Data analysis/ Data profiling & data stewardship role.

TECHNICAL SKILLS

Languages: Java, SQL, JavaScript, HTML, XML.

MDM Tool: IBM Infosphere MDM Server, Oracle MDM, Reltio, IBM Initiate MDS server

Databases: Oracle, DB2.

Operating systems: UNIX, Windows (3.x, 95, NT, 2000, XP).

Application Server: IBM WAS, BEA WebLogic, Apache Tomcat.

Testing Tools: QC, Soap UI

Automation: Selenium & Junit

Development Tools: Eclipse, Toad, SQL Developer, IBM RAD, RSA.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

MDM Lead

Responsibilities:

• Worked for location master & hierarchy maintenance for MDM & DRM (Data relationship management) architecture.
• Implementation of Oracle MDM while supporting existing system in SEI.
• Worked in different version creation in DRM for Site Hub and Oracle General Ledger (GL).
• Worked in understanding existing MDM system and how it can be collaborate with new source systems.
• Worked in defining input file structure & XML structure for Site hub to ESL flow.
• Prepared technical document for any change request in the design.
• Worked in complex SQL, Oracle ITG creation, deployment for the same and business validation logic implementation in Java.

Confidential, Batesville IN

Sr. MDM Analyst

Responsibilities:

• Involved in initial engagement including requirement gather and project planning phase.
• Attended JAD session with different source system POC to identify the important attributes for MDM implementation.
• Created mapping document and mappings inMDMHUB ODS using various cleanse list and cleanse functions.
• Defined Trust and validation rules for base table defined by End users and BA team.
• Performed Match and Merge Rules as per business requirement on source data.
• Created queries, procedures and packages inMDMHub for displaying and updating the data.
• Created Roles and privileges for Read Only and Data Entry for Data Entry Team users.
• Involved in Data Steward Activities like manual Merge/Unmerge and updating data.
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
• Improved the data quality by Match analysis, analysis of theMDMsystem performance and tuning the performance by changing the existing cleanse function and match rules.
• Worked with BA’s to prepare the initial BRD version.
• Worked in preparing data model sheet for source system columns and its corresponding mapping.

Confidential, Dallas area, TX

Sr. MDM Analyst

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of InformaticaMDMHub.
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of bothMDMand Data Integration Projects.
• Creating landing tables Staging tables Base Tables as per the data model and data sources.
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables.
• Defining Trust Score Validation rules Match rules and Merge settings.
• Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for allMDMand data governance related activities.Supporting role towards Business Analyst and Team lead in requirement phase, peer review and preparing high level design.
• Developed the code based on Low level design - includes more detail information tables, database and data flow.
• MDMdevelopment includes creating Base object tables, staging tables and landing tables as per requirement in LLD.
• Created individual mappings (i.e. Stage jobs) for moving data from landing table to staging tables.
• Configuring the trust and validation in base object columns as per business requirement.
• Ran the load jobs for moving data from staging tables to base object tables like Bo tables, Xref tables’ history tables.
• Configured Trust and created Queries & package to integrate the Trust score.
• Involved in creating various Match rules. Two match rules, Fuzzy match will be set based on token known as tokenization and Exact match will give exact record information.

Confidential, San Francisco, CA

MDM Analyst with Java/J2EE (EMPI Support & enhancement)

Responsibilities:

• Run every day batch file for inbound load and outbound process.
• Worked on the mapping document for MDM data loading from new source.
• Worked with build team for any new deployment.
• Identified false positive scenario and its resolution.
• Worked as a data analyst for the module with data steward & BAs.
• Worked with source system and pharmacy support analyst to resolve potential overlay issue.
• Monitor regularly the production environment through engine and EM logs.
• Worked in Initiate Inspector for searching and expiring records as per BA’s recommendation.
• Create daily extract file for Potential Overlay process.
• Worked in MDM enhancement and customization using java/j2ee.

Confidential, Deerfield, IL

IBM MDM Analyst (support & build)

Responsibilities:

• Interact with Client project managers’ daily basis for production update.
• Worked in creating MDM mapping document for ETL extract.
• Run SQL to separate the bad linkage data with single PEID without any LEID.
• Worked with build team for any new deployment.
• Worked in new handler logic and its customization.
• Worked with IBM product team for PMR creation to improve MPH performance.
• Re-Publish and Re-Process the bad linkage records daily and worked with data stewards.
• Works for purge process due to bulk data change in internal source systems.
• Monitor regularly the production environment through engine and EM logs.

Confidential, Michigan

IBM MDM & Java Consultant (IBM Initiate support & enhancement)

Responsibilities:

• Interact with client directly and look after the delivery on time.
• Attending the multi-vendor meetings at client side.
• Worked in Multithreaded application development.
• Worked with IBM MDM SME.
• Data analysis from MDM side for the ticket raised by other team.
• Design document preparation and modification depending on project requirement.
• Worked with business for potential overlay data creation. Created Potential overlay detection utility using java/j2ee and UNIX.
• Worked in algorithm configuration and dry run for the same.
• Involved in working with handlers for different Initiate API call.
• Gave training to testing guys about the tool for SIT/UAT.

Confidential, Monroeville PA

Onsite web services developer

Responsibilities:

• Create mapping for Inbound and Outbound web services.
• Involved with developer and architect to work in framework creation.
• Creating the low level design document from SAD.
• Writing SQL query for the same.
• WSDL implementation document for java coding.
• Worked in onshore offshore model in agile methodology.
• Unit test case preparation in SOAP-UI.
• Worked with QA team.

Confidential

MDM Analyst

Responsibilities:

• Involved in Java coding in top-down approaches for SOAP based web services implementation. Worked with message driven beans.
• Packaging and deploying services in WebLogic server.
• Developing custom validations and the java coding for the same.
• Running SQL query to validate MDM logic.
• Testing the services using SOAPUI.
• Worked in SIF (Service Integration Framework).
• Unit test case preparation with different XMLs.

Confidential

IBM MDM Consultant with Java

Responsibilities:

• Understanding the Master Data Management concept and implement the same with IBM Infosphere MDM Server.
• Creating new additions, extensions, business proxy, and custom transactions for Party domain.
• Involved in code merging activities for Confidential t and prescriber track.
• Developing custom validations for prescriber track.
• Worked in XML comparison utility development.
• Developing custom transactions & SQL query for prescriber track.
• Preparing unit test cases through different XMLs.

Confidential

Java developer

Responsibilities:

• Developing Java/J2ee application & automation test script in Junit3.0.
• Coordinate with onshore and deliver individual module.
• Automation testing of application and APIs.
• Worked with Selenium-RC and Cruise Control.
• Writing script in Java and UNIX.
• Worked in SQL query required for development.

Confidential

Software Engineer (Java/j2ee)

Responsibilities:

• Worked in Core java development.
• Writing automation test case in java.
• Development and support activities as per design document.
• Write the SQL for the development work.
• Worked with Selenium-RC framework and Cruise control.