We provide IT Staff Augmentation Services!

Master Data Management Solution Architect, Developer Resume

Moines, IA

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

MDM Solution Architect/Tech Lead

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

MDM Solution Architect/Tech Lead

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

MDM Solution Architect/Tech Lead

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.

Hire Now