SUMMARY

• 12 years of IT experience in various roles as
• ProjectLead, TechnicalArchitect
• Database / Applications developer/ Administrator
• 9 years of Informatica MDM Experience
• Strongexpertise in MDM, ETL, Java, Oracle, Unix
• Architect - MDM Hub configuration: Data modeling & Mappings, Data validation, Match and Merge rules, user workflows, Active VOS workflow, SIF API and REST Composite API
• Closely worked with business partners to plan, lead and gather business requirements, prioritize change requests, halp in UAT and participated in IT strategy/roadmap discussions.
• Expert in Leading and guiding development of an Informatica based ETL architecture.
• Experienced inold and new version of MDM ( Informatica MDM 9.0 to 10.0 )
• Managed full Software Development Life Cycle (SDLC) including business requirements, architecture, design and development/ production support, best practices, noledge transfer with both internal and external resources
• Worked as a PLSQL Oracle Developer with UnixShell Scripting

TECHNICAL SKILLS

Roles: Technical Architect \ Team Lead \ Senior Specialist

Data Warehouse: Informatica MDM, Informatica Power Center 9.1, Abinitio

Data Governance: Informatica MDM, IDDDatabases Oracle 11g, SQL Server7.0/ PL/SQL, ER-Win for data-modeling

Domain: Pharma, Investment Banking, Retail Banking, Solar Industry

Languages: SQL, PL/SQL, UNIX, Shell scripts, Java, Java Script, JSON

PROFESSIONAL EXPERIENCE

Confidential San Jose, CA

Sr.MDM Developer / Architect

Responsibilities:

• Understanding of teh source System
• Making Functional doc, Design Doc and Doing Impact Analysis
• Defining a common file format that every source needs to send
• Doing MDM Installation, DB Creation and JBOSS ( Application Server ) Installation and Active-VOS Installation and coupling each other among themselves
• Doing MDM Configuration with Hierarchy Configured for showing graphical representation of data in IDD
• Doing IDD Configuration with Composite Services (REST API) so that data can be entered in real time by source systems
• Integration Address Doctor API inside MDM so that addresses can be cleansed inside MDM
• Doing IDD task configuration by integrating with Active-VOSto provide better workflowmanagement
• Taking care of migration to higher environment like UAT and PROD from DEV
• Tracking Project Deliverables and milestones set up.
• Organizing DEMOs with Client and Business people to keep them updated with teh progress
• Preparing a framework and repository for Code

Confidential, PA

Senior MDM Consultant

Responsibilities:

• Involved in migration of Informatica MDM version upgrade
• Understanding of theexistingsource System
• Making Functional doc, Design Doc and Doing Impact Analysis
• Re-writing all teh customization like UserExit. UserExit has to be converted from PLSQL Code to Java
• Participated in requirements validation, design reviews, test case and test plan walkthroughs with development and test teams and halped users during UAT.
• Handled on boarding of resources both onsite and offshore involving screening & noledge management.
• Ensuring all teh functionality of Informatica MDM-9.0 working in Informatica MDM-9.7. Using new features of Informatica MDM-9.7
• Involved in Bug-Fixing for successfully passing through UAT
• Raising and following up with Informatica Support for teh product-bugs

Confidential, NY

Informatica MDM Developer

Responsibilities:

• Understanding teh Business by contacting with Business Analyst, Data Architect, Data Governance and sharing teh same with Offshore
• Involving in Migration and Code to higher environment- Review Tasks
• Doing POC work & Presentation on requirement basisto suggest Design Changes
• Understanding teh Architect Design and follow same Coding Standards
• Installing MDM Hub Console 9.7 version
• Taking care of Delivery Date and raise concern or risk if their is any case failure for Delivery
• Creating MDM Data Model for Informatica MDM 9.7.1
• Creating new ORS, tables, relationships, queries, packages, hierarchy mapping, batch-group, roles-users and configuring System-Trust and finally match-merge setting
• Creating IDD Applications and customizing as per User's requirement. Defining tasks and assigning task to users as per their roles
• Writing User Exits in MDM as well as IDD to support customized requirement, this is beyond teh capability of teh tool.
• IDD User Exit work has been showing ETL Layer Database in IDD, While running manual merge of Parent records, automatically merge Child Records and MDM User Exit involves generating External and Internal ID that would be consistent even after match-merge
• Implementing Erwin Data Model in MDM through Meta-Model Convertor
• Calling MDM Jobs through Batch Files (with Java Code) for scheduling
• Writing Java Code to make SIF API Calls
• Preparing PPT for migration, architecture, data-flow for Migration Team to understand
• Worked with Informatica Support for troubleshooting issues related to teh abrupt behavior of teh tool
• Implementing teh Business Logic to represent teh Business Information through MDM Data Model which was earlier used in existing Model
• Client interaction for business requirements.
• Preparing design documents.
• Developing PLSQL - SQL Code including Procedures and Function
• Creating new mappings using Informatica Power-Center 9.1
• Creating new Workflows / Sessions of corresponding mappings.
• Handling Team Members and disturbing task and taking ownership for allocated task

Confidential

Informatica MDM Consultant

Responsibilities:

• Taking Client requirement and analysis
• Handling Team and Deliverables from Offshore.
• Maintaining Billing Details and Metrics Submission.
• Writing new or Modifying stored procedure for Business Changes in DB2
• Following MDM Architecture
• Writing Stored Proc for either handling Unmerge Operation or Fetching
• data from Base Tables and its reference tables as per business needs
• Taking Care of Billing Details and Timesheet Filling of Team Members