PROFESSIONAL SUMMARY:

• Total of 19 years of IT experience
• 4 Years’ experience in Master Data Management Solution Architect, developer
• 8 Years’ experience in Informatica Data Quality V9.0
• 5 Years of experience in Data Director, Business Data Director at the capacity of Tech Lead.
• 2 Years of experience in Service Integration Framework
• 8 Years’ experience in BI, Enterprise wide Data Warehouse (Dimensional Data Modeling).
• Technical / functional background and experience with MDM tools and ERP applications.
• Experienced in implementing the Data standards and Data Governance Process
• Experience in integrating Active VOS with IDD and MDM hub tool.
• Worked on Active VOS Designer and executed BPEL process.
• A subject matter expert with business processes and was instrumental in establishing the best practices with Vendor, Customer, item master and Employee domains in Master data management.
• Experienced in Waterfall methodology, Agile and Six Sigma.
• Experienced in base data, reference data, hierarchy data.
• Excellent data analysis skills to analyze data coming from various sources and Data profiling.
• Coordinating with key member of data source teams and data subscriber teams for data flows, inbound and outbound. 6. Integration testing as and when required by the upstream/downstream systems 7. Customer Profiling.
• Worked on developing the Data Quality Business rules, Validation rules.
• Worked on configuration of Hierarchies and configuring the workflow integration.
• Experienced in defining and developing the Workflow process.
• Hands on experience with MDM Hub configuration.
• Experienced in design the Data Modeling.
• Worked on Workflow configuration.
• Well experienced in establishing the validation rules, Match rules and Merge rules and procedures.
• Have experience in Informatica Data Quality and Data Director.
• Experienced in Metadata Repository Management.
• Experienced in Relational Database Management Systems (RDBMS), designed the Data warehousing schemas STAR, Snow Flake, Hybrid.
• Worked on developing MDM Domains for various applications and domains including Banking, Manufacturing and Pharma.
• Worked on Production Support and had been instrumental in stabilizing the Systems and provided L1 Support for onsite offshore projects Model.
• Proven ability to work in both independent and team environment and having ability to meet tight deadlines and work under pressure.
• Instrumental in developing the Services Integration Framework(SIF) using Java EE7 programming.
• Experienced in SOAP, Restful web services.
• Designed and developed the MDM Hub Security and Administration.
• Designed and developed the Match and Merge rules. Trust framework settings.
• Design and develop the Data Model, Data Flow and worked on developing the Informatica MDM Hub Execution Processes.

TECHNICAL EXPERIENCE:

Enterprise Architecture: TOGAF

Data Modeling: ERWIN, Power Designer.

ERP Applications: SAP R/3 4.6 C.

CRM Application: Sales Force (SFDC)

Master Data Management (MDM): Informatica 9.x,10.2 HF1(Hosted MDM)Enterprise Data Catalog(EDC) 10.x

BPM Workflow: ActiveVOSETL Informatica Power center.

Data Quality: Informatica Data QualityBI Report Tools Cognos (Impromptu, Report Studio).

BI Modelling Tool: Framework Manager.

OLAP Report Tools: Power play (Enterprise Server).

OLAP Modelling: Power Play Transformer.

Databases: SQL server 2008 R2, Oracle, DB2 UDB

Operating Systems: MS Windows, AIX, Linux.

Quality Control: QC, HP - ALM, Clear Quest.

Versioning S/W: TFS, MS VSS.

PROFESSIONAL EXPERIENCE:

Confidential, Moines, IA

Master Data Management Solution Architect, Developer

Responsibilities:

• Create a detailed Project Plan.
• Run a kick off meeting,
• Identify stake holders,
• Review Confidential application environment related to Master Data Management including
• The high-level context of Confidential Major Systems.
• Various existing Data stores containing Client Data.
• A current direction of providing one data store for all parties.
• Worked on Data analysis.
• Identified the issues associated with the Data Management.
• Reviewed the Data Management Tools that currently in Confidential .
• Worked on requirements gathering.
• Defined the current state analysis.
• Developed the gap analysis.
• Performed high-level Tool assessment up to 4 Vendors.
• Recommended the MDM Tool for Confidential
• Worked on MDM High level strategy.
• Worked on developing the MDM Maturity Model.
• Defined the roles and responsibilities across the functional areas.
• Identified the Software to purchase and install.
• Identified the high level Business process to be created.
• Defined the Roadmap.
• MDM resource with experience in
• Tool installation and configuration
• Planned and executed the installation, configuration and administration of Informatica MDM 10.3,
• Active VOS 9.7 in Red Hat Linux, JBoss and Oracle environment.
• Instrumental in Standing up new MDM platform.
• Configuration of MDM, IDD, E360
• Backup and Restore of MDM and Active VOS
• Code migration across different MDM Environments using Change list creation
• Experienced in designing the MDM Security Framework, creating users, roles, configuring LDAP adapter
• A dedicated contributor with high level of commitment to team goals and ability to complete work with minimal supervision
• Process-oriented and experience with SDLC methodologies and phases
• Implementing the Informatica MDM Tool suite for Client Domain.
• Configured the Hosted MDM version 10.3.
• Instrumental in defining the Master data attributes from the several Source Systems.
• Worked with Business stakeholders in requirements gathering, business rules gathering.
• Designed and developed the Party Data Model, Material Master Data Model.
• Designed and developed the Match rules, Match tuning.
• Designed the match rules (Exact and Fuzzy).
• Designed the MDM HUB Trust Frame work settings.
• Designed and developed the MDM HUB Security framework, roles developments and user configuration.

Confidential, Glenn Mills PA

MDM Solution Architect/Tech Lead

Responsibilities:

• Review the Current state Analysis
• Review the Axalta application environment related to Master Data Management including
• The high-level context of Axalta Major Systems.
• Various existing Data stores containing Client, Vendor and Material Data.
• A current direction of providing one data store for all parties.
• Identify stake holders,
• Worked on Source System Data analysis.
• Identified the issues associated with the Data Management.
• Reviewed the Data Management Tools that currently in Axalta Coating Systems.
• Worked on requirements gathering.
• Defined the current state analysis.
• Developed the gap analysis.
• Worked on MDM Tool evaluation and Recommended.
• Performed high-level Tool assessment up to 4 Vendors.
• Recommended the MDM Tool for Axalta Coating Systems i.e Informatica MDM Hosted environment on AWS.
• Worked on developing an MDM High level Strategy.
• Worked on MDM High level strategy.
• Worked on developing the MDM Maturity Model.
• Defined the roles and responsibilities across the functional areas.
• Develop the Roadmap for the Client Domain, Vendor domain and Material Master
• Identified the Software to purchase and install.
• Identified the high level Business process to be created.
• Defined the Roadmap.
• Designed and developed the Client, Vendor, FTB and Material Master Domains
• Configured the Hosted MDM version 10.2 on AWS.
• Worked on the Data Quality using DI(IDQ)
• Instrumental in defining the Master data attributes from the several Source Systems.
• Designed and developed the Party Data Model, Material Master Data Model.
• Worked on Data Quality analysis, Data Profiling and Data cleanse rules.
• Designed and developed the Match rules, Match tuning and Validation rules.
• Designed the match rules (Exact and Fuzzy).Designed the MDM HUB Trust Frame work settings.
• Designed and developed the MDM HUB Security framework, roles developments and user configuration.
• Worked at the capacity of MDM HUB Admin including code migration between the Environments, Performance tuning.
• Designed the BPM Workflow using Informatica Active VOS Designer Tool.
• Worked on IDD Configuration, Cleanse functions.
• Co-ordinated and worked with Informatica B2B(DX) in interface development with SAP R/3.
• Defined the IDD Queries and Active VOS integration.

Confidential, Columbus, GA

EMDM Solution Architect/Data Modeler

Responsibilities:

• Worked on the Aflac MDM Solution Architecture for Producer/Broker, Accounts and Named Insured Domains as part of transitioning the Policy Centric Platform to Client Centric Platform.
• Worked with key business stakeholders to interpret business needs and issues and translate them into actionable requirements.
• Developed the MDM validation rules, Merge rules.
• Designed and developed the Match and Merge rules. Trust framework settings.
• Experience in defining the product taxonomies and categorizations.
• Worked with Reference Data modeling and Data Mappings. (Landing, staging and Base Objects).
• Worked on the Data Quality methods and procedures using IDQ.
• Designed the BPM Workflow using Informatica Active VOS Designer Tool.
• Designed the match rules (Exact and Fuzzy) for the Accounts and Named Insured domains.
• Defined the IDD Queries and ActiveVOS integration.

Confidential, Philadelphia, PA

MDM Solution Architect/Tech Lead

Responsibilities:

• Worked on MDM Tool evaluation and RFP Process for Confidential ’s Enterprise Data Management Group
• Worked on Vendor demos and Tool capabilities.
• Worked with Procurement Team on Tool evaluation and cost estimation.
• Worked on Data Quality, data profiling using IDQ.
• Worked on Informatica Data Director and Business Data Director.

Confidential, Pittsburg, PA

Responsibilities:

• Designed the Data Governance Framework and Data Standards.
• Defined the MDM Day to day process.
• Designed the workflows for Customer Onboarding System.
• Worked on Source System analysis.
• Experience in defining the product taxonomies and categorizations.
• Worked with Reference Data modeling and Data Mappings. (Landing, staging and Base Objects).
• Worked on the Data Quality methods and procedures using IDQ.
• Designed the match rules (Exact and Fuzzy) .
• Have defined the data lineage, change impact, and relationships.
• Defined and configured the composite data domains to search for entities across schemas in a data source.
• Worked on transformation logic for assets.
• Identify the frequency of values in data sources.
• Have organized the metadata based on business concepts, and view data lineage and relationships for each object.

Confidential, Hopewell, NJ

Responsibilities:

• Worked on Client Contact Conversation Analysis.
• Designed and developed the Client Attrition reports.
• Heavily involved in Direct Marketing Analytics.
• Designed and developed the E-Newsletter Analysis.
• Worked on Campaign Marketing Dash Boards and Campaign Rules Hierarchy.
• Developed the Client Household Segmentation based on IVR and Client Asset Analysis.
• Developed the Client on boarding process and deepening Analysis.
• Worked on Consumer Referral Process and Analytics.
• Developed the Client Exit Survey Data Analytics.
• Developed the Client Product Enrollment Analysis.
• Instrumental in Design and developing the FAC Data warehouse DataMart.
• Worked on multiple projects and was able to perform multi-tasking.
• Analyzed the business requirements and functional specifications.
• Extracted data from Oracle database and applied business logic to load them into Salesforce application.
• Designed and developed Client attrition analysis.
• Worked on E-Newsletter Analysis.
• Designed and developed the ML EDGE Client EXIT Survey Analysis.
• Designed and developed Client Attrition Metrics and Analysis.
• Worked on UMA Enrollment and MESP Analysis.
• Designed and Developed MFA.

Confidential, Hopewell, NJ

Responsibilities:

• Worked on ETL requirements for Client & Account Data.
• Designed and developed the Source to Target Mappings.
• Worked on gap Analysis.
• Designed and developed the Operational Reports.
• Worked on Cognos report Studio reports.