PROFESSIONAL SUMMARY

• Nearly 15 years of experience in Application Development and Support.
• Expertise in Informatica MDM. Worked in different version of Informatica MDM including upgrade project.
• Having experience in End - To-End Implementations include various SDLC stages like Architecture Design, Requirement Analysis, Profiling, Data Modelling, Implementation Design, Development, Production Support.
• Worked for few top clients like Confidential, Centene, Confidential, Pfizer, Novartis.
• Strong communication, collaboration & team building skills wif strong analytical skill wif proficiency at grasping new technical concepts and utilize teh same in productive manner.
• Having experience in handling large volume of data, complex business logic, aggressive deadline environment, leading team in Onsite as well as Offshore.

CORE COMPETENCIES

• Informatica MDM/IDD
• Oracle SQL, PL/SQL
• ETL (Talend, Informatica)
• IDQ, RDM
• Master Data Management
• Solutioning, Designing, Implementation
• Team Management, Delivery
• Application Development Support

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO, USA

Data Architect / Tech Lead

Tools: Talend, Oracle, Kafka, Cucumber, Flyway, Postman, Jira, BitBucket

Responsibilities:

• Creating Data Model for teh Staging layer for Fidelis Migration.
• Evaluate all teh corresponding Entities and required mapping for teh Fidelis Migration.
• Design Test Data creation approach.
• Guide Team and provide KT to make them comfortable wif Provider System.
• Perform Data Profiling to identify teh data discrepancies/gaps.
• Design teh Roster Orchestration process workflow.
• Lead and guide teh Team from Technical aspect to meet all teh deliverables following Agile methodology.
• Work closely wif teh Product Owner to clarify teh Technical Requirements.
• Actively participated in Talend ETL development activities.
• Designing teh Framework for Automated Testing using Cucumber.

Confidential, NJ

MDM Architect / Tech Lead

Tools: Informatica MDM/IDD (10.2), SQL Developer, SOAP UI

Responsibilities:

• Implementing MDM solution for Customer master for Organizations.
• Design MDM Data Model, configure required MDM Hub configurations.
• Work closely wif teh BA and actively participate in Data Profiling to get source data clarifications and provide best solution accordingly.
• Guide and touch base wif ETL Team to make sure timely and expected deliverables.
• Design and implemented MDM Hub Component and E360 Business Entity component to provide best solution for customer need.
• Implemented Hierarchy Manager set up, Multi-Level Task Workflow, E360 specific changes from Provisioning Tool.
• Implement Persistent ID configuration to make sure their is minimum impact on downstream systems.
• Match Rule Tuning activity and get it validated through Business users.
• Provide KT to Business users to educate them to use IDD/E360.
• Performance Tuning activity to get satisfactory window to process nearly 90M of Party.
• Deployment Planning - co-ordinate wif corresponding team accordingly.
• Ensure smooth IDL run and Post Production support to stabilize teh env.
• Requirement analysis, profiling, designing, implementation
• Closely work wif Source SMEs to get teh data clarifications
• Preparing Database Packages to process and perform teh data mastering activity
• Feasibility and Impact analysis of using different tools in future prospective
• Actively participated in co-ordinating wif Requirement Team and Development Team
• Active part in Design review and data model redesigning activity
• Perform Data profiling
• Perform requirement analysis and identify teh gaps in design
• Review Test case document and guide teh testing team to consider all possible scenarios from MDM prospective
• Title: Confidential Provider Master (Jan’2018 - May’2018)

Confidential - Pittsburgh, PA

MDM Architect / Tech Lead

Tools: Informatica MDM/IDD (10.2), SQL Developer, SOAP UI

Responsibilities:

• Implementing that required to be considered.
• Prepared and shared ETL mapping document from source to MDM landing.
• Implemented teh corresponding MDM development activity including Hierarchy manager set up, perform required configuration from IDD and Provisioning Tool, Task configuration, customization.
• Configure Cleanse list for standardization process.
• Write Unix scripts to invoke MDM jobs from unix server and MDM solution for Provider master.
• Perform teh requirement analysis, closely in touch wif Business and inbound Source SMEs to get teh required clarification and understand teh corresponding gap.
• Perform source data profiling, finalizing teh attributes and data quality rules that need to be consider.
• Closely in discussion wif Business team to understand teh business process, teh gaps, and hence provide teh best solution for them.
• MDM data model designing, and all dev design activity like customization, trust rule, match rule, and other business logic
• schedule it through Tidal.
• Prepared MDM design document, Knowledge Transfer document, E360 User Guide document, Unit Test document.

Confidential

MDM Tech Lead

Tools: Informatica MDM/IDD (10.2), Informatica PowerCenter, Toad, SOAP UI

Responsibilities:

• Implementing MDM solution for Member master.
• Closely in discussion wif Business team to understand teh business process, teh gaps, and hence provide teh best solution for them.
• Performed MDM data modelling.
• Actively participated in Design, Development activities.
• Implemented E360 changes using Provisioning Tool.
• Worked on AVOS Task configuration.
• Identifying and configuring Match Rule, Trust settings, Validation Rules.
• Closely worked wif Informatica Support to get workaround of several Product issues or limitations observed for Informatica MDM 10.2 version.
• Designed and created teh materialized views required for downstream systems.
• Prepared and shared User Guide, and noledge transfer document along wif work wif Business users to educate them on MDM functionalities and usage.
• Write Unix scripts to invoke MDM jobs from unix server and schedule it through Tidal.

Confidential, New Jersey

MDM Solution Architect and Delivery Lead

Tools: menformatica MDM/IDD (9.1, 9.7, 10.1), Informatica PowerCenter, SIFSQL Developer, RAD, SOAP UI

Responsibilities:

• Consulting and provide solution to multi-domain MDM solution for Member & Provider.
• Implemented RDM (Reference Data Management) over MDM 9.7.
• Upgrading to MDM Upgrade Project (upgrade to 10.1).
• Closely worked wif Informatica Support, Admin Team, Development Team, Release Management, Production Support Team to make sure successful deployment.
• Worked as a delivery lead for multiple enhancement activity - for requirement from downstream as well as implementation of inbound source changes.
• Performed requirement and impact analysis, solution approach and plan teh deployment activity based on teh related dependency.
• Worked closely wif Enterprise Architecture team to ident and provide teh best possible solutions to enhance teh environment more robust and accurate along wif teh performance improvement
• Integral part of teh project management activity.
• Guide teh team for any technical and business / domain related clarification.
• Worked as MDM SME for all teh corresponding MDM related queries for Inbound and Outbound sources.

Confidential

MDM Architect / Tech Lead

Tools: Informatica MDM/IDD (9.1), Informatica PowerCenter, IDQ, SQL Developer, SOAP UI

Responsibilities:

• Implementing Phase 2 changes for MDM solution for Member & Provider.
• Guide Production Support Team for any technical and analytical challenges.
• Implemented Solution for Outbound feed (me.e. Online Provider Directory).
• Closely work wif Informatica Support Team to resolve/get workaround for teh corresponding product bug or limitations.
• Provide Testing Support for SIT and UAT Team.
• Lead and Guide team for all teh corresponding technical challenges.
• Provide noledge transfer to Business and Production support Team providing teh impact for all teh corresponding MDM related changes.
• Closely work wif Inbound and Downstream system - work as a POC for MDM implementation.
• Implemented several correction / remediation activity to make teh system robust.
• Leading teh Production Support Team
• Streamlining teh processes for teh Production Support
• Worked as SME and POC for MDM Application
• Closely work wif all teh corresponding Down Stream systems to understand, explain and provide work around if any data issues raised.
• Prepare and share several reports along wif required data stats to teh Business to make them understand teh advantages.
• Work wif Data Stewards to guide and educate them to make best use of MDM application.
• Collaborating wif users to understand teh real life problems and providing solutions wifin expected timeline.
• Title:Horizon MDM Phase 1 Implementation (Aug’2011 – Jul’2012)

Confidential

MDM Tech Lead

Tools: Informatica MDM/IDD (9.1), Informatica PowerCenter, SQL Developer, SOAP UI, IDQ

Responsibilities:

• Implementing multi-domain Provider Member Hub.
• Actively participated in data model discussion, designing, development.
• Perform data profiling, and implementing data cleanse and standardization using IDQ.
• Prepare MDM design documents, best practise document, requirement trackability matrix document, etc.
• Tracking teh deliverables and make sure to meet teh timeline, quality of code, standards, documenting teh unit test results.
• Review code and all required documents.
• Guide team for all kind of challenges.
• Provide noledge transfer to teh Production Support Team, Business User team.
• Support SIT and UAT testing.
• Providing Production Support and required enhancement activities.
• Work as a lead for teh monthly enhancement release activities.
• Debug and analyse teh data issues reported.
• Interacting wif teh corresponding teams to make sure teh process runs smoothly.
• Identify, list, and prioritize teh issues/bugs that need to be fixed and match them in proper release calendar accordingly.
• Prepare new team member on-boarding document.
• Actively participating in Audit activities, report generations.
• Prepare require reports for teh several mutual fund clients for Deutsche bank.
• Understand teh requirement from FSD, relate teh corresponding tables required, get teh mapping from SCD instance, and develop teh corresponding package to get teh output of teh Report as required.
• Create Materialized View to get teh data from Singapore to London database, and use those to get teh corresponding report output.
• Prepare teh oracle db packages having procedure/function to support complex requirement.

Confidential

Team Member

Tools:SQL, PL/SQL, Oracle 9i, Toad, PVCS, JDeveloper, Windows XP

Responsibilities:

• Creating teh database objects according to teh requirement for teh implementation (Front End was implemented in ADF).
• Gatheird information from teh client and TDD to analyse teh code and to perform optimal performance tuning.
• Prepare Oracle PL/SQL procedures/functions to meet teh complex requirement.
• Adhere to teh coding standard and timely deliverables.
• Actively participated in design discussion, sharing status report, maintain all teh required docs in share point accordingly.
• Debugging AR & OM related issues and solving teh corresponding TDs raised by QA.
• Analyse teh order to invoice flow for a Confidential order.
• Develop teh database procedures for teh customize processes.
• Monitoring all AR related Jobs in Dollar Universe GUI.