SUMMARY:

• Over 8 years of experience in Master Data Management with technical expertise on Informatica MDM v9.x and 10.x and played different roles of Developer, Team Lead, Project Lead and Application Architect etc.
• About 8+ years of IT experience in the field of Master Data Management providing solutions using MDM, ETL with SDLC processes.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Have experience as Informatica MDM Admin, Development and providing solutions using Informatica MDM 10.1/9.x
• Experience in Informatica MDM version upgrades
• Experience Admin activity like installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter
• Informatica Admin experience like setting up environments in UNIX, User & Groups creations, LDAP configuration.
• Being around 8 years in Life Science domain, experienced on implementing different business requirement with Informatica MDM.
• Involve in Level - 3 production support issues specific to Informatica product.
• Experience in Informatica code migration between environments using Deployment Groups as well as export/Import XMLs.
• Good experience in integrating third party applications like Trillium with Informatica MDM for Address Standardization
• Experience in working in Data Stage server edition, Informatica Power center
• Independent on troubleshooting & root cause analysis. Platform issue resolution.
• Experienced in working with Release Management team on change control and releases, and proceed with code migrations accordingly.
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Highly motivated, willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

MDM Tool: Informatica MDM 10.1/9.x

ETL Tool: Informatica Power center, Data Stage Server job

RDBMS: Oracle 12c/11g/10g/9i/8i

Tools: Toad, PLSQL Developer, Control-M

Language: SQL, PL/SQL, Unix Shell Scripting

Operating Systems: Sun Solaris, Windows 2007,2003/2000/XP/98

Scheduling Tools: Ctrl M

Applications: MS Office, Outlook

Business/Domain profile: Having 8+ years of experience on the Life Science domain

PROFESSIONAL EXPERIENCE:

Confidential, East Hanover, NJ

MDM SME and Operation Lead

Environment: Informatica MDM 10.1 HF2, Data Stage 8.5, Oracle 12c, Sun Solaris, Trillium 15.x.

Responsibilities:

• Played role as MDM Subject Matter Expert
• Led MDM Operation
• Conduct and participate in multiple sessions with business stakeholders addressing critical issues, delivering status and shaping roadmap for future
• Participate in several techno-functional demo with customer showcasing the Customer Master implementation
• Analyze and propose solution to various business critical requirements
• Coordinate with data vendors and downstream for functional or technical issues
• Oversee delivery of Operational activities including Reporting, Change requests, Service Requests etc.

Confidential, East Hanover, NJ

Onsite project Lead

Environment: Informatica MDM 10.1 HF2, Informatica MDM 9.1 HF4, Data Stage 8.5, Oracle 12c, Sun Solaris, Trillium 15.x, Trillium 13.5

Responsibilities:

• Shaping the Upgrade strategy that involved Pre-Upgrade, Upgrade and post Upgrade activities
• Identify the potential areas to be impacted by the Upgrade in current implementation in lieu to the difference between Old and New version of the software
• Involve in discussion with vendor support team to decide on required Hardware infrastructure
• Coordinate with different backend support team to setup the upgrade environment
• Install Informatica MDM on new environment - Hub Server, Process Server, Master Database and ORS
• Assist vendor team in installing Trillium 15.2 version in new environment
• Perform upgrade on new ORS with or without data
• Guide and assist in design and build the code to make existing functionalities work in new version
• Integrate Trillium with Informatica after upgrade
• Guide Testing team in preparing test strategy based on existing business functionalities
• Assist testing team in testing automation
• Address the differences in the test results with acceptable deviations that is expected due to upgrade
• Coordinate with various downstream teams and business user to perform the UAT and address acceptable differences between old and new outcome
• Assist downstream to change exact modification required to make at their end based on the changed behavior because of the new version
• Coordinate and follow up with vendor support to resolve various issues including installation, setup, configuration during different phases
• Plan and involve in Go Live activities including environment setup, perform upgrade, code migration, data catchup to have seamless transition to the new version
• Provide hyper care and assist in resolving production issue coordinating with vendor support team
• Coordinate with various stakeholders from customer to appraise about the status, highlighting probable risks and address any concern

Confidential, East Hanover, NJ

MDM Tech Lead

Environment: Informatica MDM 9.1 HF4, Data Stage 8.5, Oracle 11g, Sun Solaris, Trillium 13.5

Responsibilities:

• Involve in Business Requirement gathering with multiple business users
• Perform data quality analysis of the new source data and furnish report
• Involve in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data
• Guide developers to build the ETL and Unix script to extract the source data
• Assist QA team to identify the test areas and scope
• Assist downstream system to perform the UAT
• Work with Release Management team on change control and releases

Confidential, East Hanover, NJ

MDM Lead

Environment: Informatica MDM 9.1 HF4, Data Stage 8.5, Oracle 11g, Sun Solaris, Trillium 13.5

Responsibilities:

• Involve in Business Requirement gathering with multiple business users
• Perform a complete data analysis on current Account data and identify the pain points on current match rules
• Design new match rules for account aligning on user requirements
• Design data remediation for the large Account dataset which involves unmerge and remerge with new rules
• Involve in Designing, document the changes required to apply the necessary business rules
• Alter configuration in the Informatica MDM Hub by changing the Trust score, validation rules, cleanse rules, mapping etc.
• Guide developers to build the ETL mapping in Data Stage and Unix script to change the cleansing rules
• Assist QA team to identify the test areas and scope
• Assist downstream system to perform the UAT
• Work with Release Management team on change control and releases

Confidential, East Hanover, NJ

MDM Operation Lead

Environment: Informatica MDM 9.1 HF4, Data Stage 8.5, Oracle 11g, Sun Solaris, Trillium 13.5.

Responsibilities:

• Led MDM Operation
• Conduct and participate in multiple sessions with business stakeholders addressing critical issues, delivering status and shaping roadmap for future
• Involve in several key project releases and change requests
• Analyze and propose solution to various business critical requirements
• Coordinate with data vendors and downstream for functional or technical issues
• Oversee delivery of Operational activities including Lights On, Change requests, Service Requests etc.

Confidential, Philadelphia, PA ffshore Team Lead

Environment: Informatica MDM 9.1, Informatica Power center, Oracle 11g, AIX, Trillium 13.5

Responsibilities:

• Coordinate with Onsite coordinator to understand the requirements and analyze the same
• Lead to design the solution to cater the user requirements
• Coordinate with various other teams during the integration
• Oversee the tasks assigned to the team members and involve in status calls with customer
• Build critical transformation logic in Informatica Power center to derive the business rules
• Involve in configuration in MDM hub to separate Canada dataset separate from US dataset in same ORS
• Configure Trillium with Informatica MDM so that respective country’s data will hit corresponding trillium standardization function
• Assist team in addressing issues during QA and maintain the log in test tracker
• Maintain project plan and face internal audit to comply quality standards

Confidential, East Hanover, NJ

MDM Team member

Environment: Informatica MDM 9.1 HF4, Data Stage 8.5, Oracle 11g, Sun Solaris, Trillium 13.5.

Responsibilities:

• Involve in requirement analysis and development of technical specification document
• Analyze customer data from source and document the same
• Create jobs in Informatica MDM and modify the Match Rule
• Involve in building Siperian process and writing PL/SQL procedures to achieve the requirements
• Make planning and estimations for the MDM job cycles for various stages of data migration and testing.
• Defects Analysis, distribution, review and fix.
• Discuss with the Team for the design, and implementation of the business requirements.
• Make arrangements for Knowledge transfer sessions for the new team members, and during production rollout.

Confidential, Groton, CT

MDM Team Member

Environment: Informatica 8.1.1, Siperian XU, Oracle 9i, Toad, PL/SQL

Responsibilities:

• Analyze customer data for different demography
• Create jobs in Informatica and Siperian
• Bug Fix in Siperian and Informatica
• Write Test Script and executed test cases for various releases
• Review deliverables
• Interact with user

Confidential, Groton, CT

Offshore ETL Team member

Environment: Data Stage server edition, Oracle 8i/9i, SQL, PL/SQL, Toad

Responsibilities:

• Monitor production jobs
• Bug fix data stage jobs
• Write Test Script and execute the same for any change request
• Participate in user calls