Consultant - Mdm Architect Resume
Parsippany New, JerseY
PROFESSIONAL SUMMARY:
- 11+ years of experience in IT
- Confidential Certified as MDM Multi Domain 10.1 Developer, Specialist
- 7+ years of experience in Implementing Confidential MDM across various domains like Pharma, banking, Insurance, Retail etc.
- Provided End to End Solution Architecture for MDM Solutions.
- Involved in very complex MDM implementations.
- Experience in using other Confidential tools like Power Center(ETL), Data Quality (IDQ), Power Exchange(PWX) & Confidential Identity Resolution (IIR)
- Expertise in using Six Sigma Yellow Belt Methods
- Trained and Certified in ITIL V3 Foundation
TECHNICAL EXPERTISE:
Languages: PL/SQL, Java
Databases: Oracle
Tools: UC4, TOAD, HP Service Center, PVCS, Microsoft Office Visio
Business Intelligence: Confidential MDM, Confidential PIM, IIRInformatica Power Centre, Confidential Power Exchange
Operating Systems: Windows, Linux
Job Functions: Module Leading, Requirement Analysis, DesignCoding, Testing, Documentation, Maintenance/Support
EXPERIENCE:
Consultant - MDM Architect
Confidential, Parsippany, New Jersey
Responsibilities:
- Co-ordinate with business analyst to deeply analyze the business requirements from E2E perspective.
- Installed MDM on AWS Oracle Database by Automation script.
- Designed and configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, queries/custom queries and packages in MDM.
- Created and configured Mappings, Trust and Validation rules, configured Match Path, Match Column, Match rules, Merge properties and Batch Groups.
- Design and customizing IDD application for various Subject Areas and enabling the task creation and notification for the Data Stewards and the Business Users.
- Executed the project with onshore/offshore model.
- Data load into and out of MDM using Confidential Power Center.
- Integrated Address Doctor in MDM.
Confidential
IPS Senior Consultant
Responsibilities:
- Confidential MDM Design, Configuration & Review
- IDD Design, Configuration & Review
- IDD User Exits Customization
Confidential, Rockville
Team LeadResponsibilities:
- Confidential MDM & IDD configuration Review
- Customization of IDD Task Management Process
Confidential
Team LeadResponsibilities:
- Confidential MDM Configuration Review
- MDM Match Analysis and Tuning
- MDM Batch Performance Tuning
- IDD configuration Review
Confidential
Team LeadResponsibilities:
- Customer Master Development
- MDM Match Analysis and Tuning
- IDD Development and configuration
- MDM Integration with different applications like Pega Systems BPM Tool
- IIR Matching & Tuning by modifying the population files.
- Analysis of IIR & MDM Match Results.
Confidential
Team LeadResponsibilities:
- Data Quality Profiling & Data Integration
- Confidential MDM Installation, Requirements, Data Model Design & Configuration
- MDM Match Configuration and Analysis
- IDD Development and configuration
Confidential
Team LeadResponsibilities:
- MDM Requirements and Data Model Design
- Configured Confidential MDM
- MDM Match Analysis
- IDD development and configuration
- IDD Java User Exits
- Data Quality Profiling & Data Integration
Confidential
Team LeadResponsibilities:
- MDM Requirements and Data Model Design
- Configured Confidential MDM
- MDM Match Analysis
- IDD development and configuration
- SIF Real Time Integration
Confidential
Responsibilities:
- Data Quality Profiling & Power Center Mappings Development
- Configured Confidential MDM
- MDM Match Analysis
- IDD development and configuration
Confidential
Team LeadResponsibilities:
- Power Center Mapping Development
- Power Center Administration
- Data Analyzer Reports
- Power Exchange CDC Administration
Confidential
Team LeadResponsibilities:
- Design of the MDM Data model
- MDM Tool Configuration
- Design of Match and Merge Rules.
- Configured IDD Tool as per the client requirements
- Designed Java User Exits to implement the business requirements.
- Resolved all the open issues of the Testing Defects.
Confidential
Team LeadResponsibilities:
- Configuration of Confidential MDM Tool as per client requirements
- Defined Match and Survivorship Rules.
- Prepared Test cases document with all expected scenarios.
- End to End Testing of MDM implementation
Confidential
Team LeadResponsibilities:
- Designed the Data Flow from Source to DW.
- Configuration of Confidential Power Exchange Tool
- Development of Power center mappings.
- End to End testing of the overall data flow in DW.
Confidential
Team Lead
Responsibilities:
- Requirement Analysis to understand client’s business requirements
- Preparation of Landing, Staging and Target Data models.
- Developed the Landing, Staging Tables and Base Objects using Confidential MDM Tool.
- Configured Match & Merge process by using Exact & Fuzzy match.
- Developed the applications and configured Match settings in IDD BDD Tool.
- Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
- Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems Oracle and Flat files.
- Done end to end ETL development which includes analysis of the design doc, impact analysis, development, testing and performance tuning.
- Performed thorough testing of high quality levels leading to quality deliverables.
- Developed Workflows, reusable and non-reusable session tasks.
Confidential, New York
Team LeadResponsibilities:
- Interact with client and perform Business & Requirement Analysis, Design and Development for minor/major enhancements.
- Developed Stored Procedures, Triggers, Cursors and packages.
- Design and ensure SOP is in place for all the critical process.
- Part of the core team to perform extensive Code Reviews, Unit and System Testing
- Implemented ITIL Practices in incident/Change/Knowledge Management.
- Implemented Six Sigma Methods to reduce frequent issues.
- Recognized as People Developer for managing the team and being a motivator to the team with sound technical and Support knowledge and consistently producing quality deliverables.