Ravi Ayyar

  • Sr. Program Manager
  • Houston, TX
  • Member Since Feb 10, 2023

Candidates About

Ravi Ayyar

 

Professional Objective

 

Over 20 years of progressive experience in information technology and management, of that time, 10 years in SAP large implementation projects focused on master data.

Since 2006 focus has been in implementing Enterprise data management, master data management solutions, enhancing Enterprise data quality initiatives through introducing effective data governance programs for large clients.

 

Deliver value, focused on customer initiatives and goals in the Enterprise data management & Centralized master data solutions. Realize value through implementing overall Data Governance practices resulting in improved business processes, data standards, data quality, data ownerships and required organizational capabilities.

 

Overview

·         Enterprise master data life cycle management strategy, clearly identifying need for Global master data Governance through effective implementation of data governance framework improving corporate master data quality and ownerships at all stewardship levels

·         Master data management solutions architect with strong experience in centralized master data scenarios of Master Data Management. Implementation of SAP enterprise data management solution combined with delivering an effective MDM solution.

·         Established Master data management best practice roadmap, enterprise governance processes and data management strategies focused on the architecture, data standards and quality driven by business Initiatives.

·         Strong Project management and coordination skills focused on the master data management, procurement, manufacturing and finance projects.

·         Supply Chain management expertise in integrating and synchronizing Order to fulfill cycle including forecasting and inventory management.

·         Collaborate with project/program managers/sponsors to develop risk mitigation plans and measure progress against eliminating and/or minimizing risk.

·         Highly motivated professional team player, have led and been a member of diverse implementation teams with Fortune 100 companies like Mobil, Exxon, Shell, BP and Chevron in project management through collaborative approach.

·         Strong Analytical, communications and customer service skills.

 

Functional & Technical skills

 

·         Provide quality assurance, feedback, and value-added input to project/program teams to help them meet their project/program objectives.

·         Measure accountability and continually validate projects/programs are aligned with the strategic direction of the organization.

·         SAP data migration stream lead provide overall leadership and influence client organization on data conversion strategies, data quality improvements and overall data governance needs.

·         Senior functional Consultant with over ten years of SAP project implementation experience adopting SAP best practice methodology and road map from project preparation though final delivery in oils and gas, high tech manufacturing, distribution process and service Industries.

 

Experience/Project Work

Company:   Microsoft

Project description:  Master data management and data Governance

Role: Sr. Program Manager                                                            Seattle, 05/2016 – 11/15/2017

·         Global Customer master data governance from multiple lines of business, process, data standards, usage, ownership and accountability

·         Continuously establish master data cross functional business data governance approach for customer master. Drive sustainability of core data quality, reliablity, consistency working with business policies and rules.

·         Establish systems of records for core master data attributes, working on change management principles and maintenance of master data, reference data through MDG tool

·         Integral part of data migration projects to customer master from multiple legacy and SAP systems

 

Experience/Project Work

Company:   Capgemini  

Project description:  Business Information management, insights & data

Role: Global Master Data Governance                                              Houston, 08/2015 – 11/2015

·         Mater data model architecture approach and relationship, Publish definition of new terms and categories used in data model.

·         Data governance prospective, worked on entity relationships, business use cases and required agile methodology to address and complete data sourcing strategy.

·         Integral part of multiple assessment program focused on data quality, data governance and data management continued sustainable growth for clients.

 

Company:   Independent Consultant, Molex

Project description:   Global Enterprise Master Data Governance

Role: Global Master Data Governance Lead                                      Chicago, 08/2014 - 03/2015

 

·         Global Mater Data maturity assessment - Global senior management and operational level interviews, gathered pain points, known issues - business and IT, conducted detailed master data maturity assessment, presented findings to senior management and stakeholders.

·         Identified key Global business critical attributes with defined business rules, owners with clear accountability to improve GS&OP process down to inventory optimization and data effecting distribution channels

·         Established Global master data roadmap and presented Global data governance strategy to stakeholders and senior business leads focused on Global sales and operation business units

·         Defined organizational model and clear responsibility,  accountability of master data business sensitive data to new Global data governance organizational business model and roles

·         Aligned Global Master data strategy with clients vision, strategy and communicate strategy to Global sales and operation senior executive team

·         Master data governance tool implementation -Blue print and get business to sign off on GS&OP master data organizational end to end processes with ownerships clearly defined, Global RACI charts for all key business sensitive attributes, master data specific policies and procedures, risk assessment documents and up to date stakeholder analysis on their levels of involvement and improvements

Company:   IBM

Role: Sr. Managing Consultant                                                         Houston, 08/2013 – 05/2014

Senior Managing Consultant within IBM's Global Business Services Analytics Group

 

·         Master data full life cycle feasabilty assessment, time & cost estimate with clear recommendations and roadmap.

·         Master data strategy options with big data analytics and visualization of full life cycle customer and vendor master data.

·         Defined business levers and data strategy capabilities and clearly mapped capabilities to each business levers to achieve strategic business outcomes.

·         Integral part of multiple proposal projects assignments on master data strategy and recommendations

 

Company: Estee Lauder                                                              Long Island, 05/2013 – 08/2013

Role: Master data Governance

Responsibilities/Deliverables:

·         Brand triage issue documentation- consolidate issues from all brand and prioritize master data issues, what’s needed in terms of Governance, communication, quick reference guide, troubleshooting guide and training.

·         Completed recommendation on all brand triage approach across all brand cluster. Reviewed and updated new brand end to end creation process and introduced ownerships as appropriate.

·         Completed mapping and creating visual graphical representation of sales orgs with all the manufacturing plants and global distribution channels.

·         Reviewed Launch documentation for Master Data Accuracy and Troubleshoot Planning Challenges/Discrepancies to identify opportunities for additional data integrity checks, additional education and documentation and process  improvements.

·         Handedover quick reference guide for new product master data creation and extension checklist to end users.

 

Company:   Independent Consultant, Sparta Consultant

Project description:   Enterprise Master Data conversion for Brazil

Role: Master data stream lead                                                   Washington, 04/2012 - 02/2013

Client: PACCAR Inc.

Financials, Materials, Customers and Vendors mater data converison project

·         Master data conversion stream lead to ensure successful migration of financial, materials, vendors and customer master data to SAP system.

·         Collaborate and perform as the primary liaison for the data conversion team in working with client legacy team members to map business specific SAP master data attributes.

·         Created conversion strategy document with data governance rules and master data industry  specification document.

·         Generate and submit metrics and scorecards to PMO weekly to effectively track all master data activities of the work stream.

·         Provided overall leadership and influence client organization on data conversion strategies, data quality improvements and overall data governance needs.

·         Coordinated with client data extract team and work with offshore technical team on data transformations and load technologies to meet critical timelines.

·         Conducted workshops on master data governance to prepare client master data teams to ensure smooth transition to a better sustainable master data and improved organizational capabilities. 

 

Company:  Deloitte Consulting Area: Enterprise data management

Project description :   Enterprise data management Financial transformation

Role: Specialist Senior EDM                                                      Houston, TX   02/2011 - 01/2012

Client: AIG Chartis NY/NJ

Financial Transformation project for Chartis. Assist with defining and implementing processes, procedures, organization roles and responsibilities as they relate to data governance.

Role:

·         Provided advisory service relating to the establishment of master data management solution to include defining processes, procedures organization role and responsibilities as they relate to data governance of all Financial master data.

·         Primary deliverables inlcuded business reuqirement and detailed design documents for financial master data Profit center, Cost center, Chart of accounts, Business and Trading partners, Customers, Bank and other finacial master data like internal orders.

·         Coordianted with security, control and with change management team to deliver end to end processes required governance roles at each steps for all above financial master. data.

Client: Molson Coors – Master data merge,harmonization assessment project

·         Developed and reviewed initial hypothesis on business merge approach and impacts.

·         Reviewed and confirmed effort estimates, dependencies and constrains.

·         Conducted master data integration workshop to reconcile assumptions and integration points.

·         Conducted final validation session with key stakeholders.

·         Detailed functional data and design element scope with supporting timing/sequencing recommendations.

·         Delivered merge execution roadmap with quick wins detailed and complete resource plan.

 

 

Company: Chevron Oronite enterprise Applications

Project description / Scope:   Master data quality improvement and sustainability

Role: Global Data quality and Governance Lead                 California, CA   10/2009 – 01/2011

Client: Independent Consultant, Chevron Orinite CA

Project: Material master and supply chain data quality improvements and overall global master data governance.

Role:

·         Demonstrated continuous improvements in data quality through root cause analysis, improving data governance efforts and in creating and monitoring data quality metrics. 

·         Aligned data governance work efforts with overall business objectives and educated regional teams in the importance of data governace, data quality improvements and value realization for the organization.

·         Designed end to end SAP material master data maintenance processs for manufacturing environment with workflow step for automation and with appropriate roles, responsibilities.

·         Evaluated data tools for automation of master data maintenance process work steps.

·         Coordinated efforts globally with master data team, regional local master data team and the global process owners to increase organizational capabilities in terms of improving quality data for better master data and supply chain operations.

·         Identified root cause of data quality problems in master, transactional and interfaced systems and resolved issues in data quality through training, improved processes, procedures and effective automation of workflow maintenance process.

·         Leveraged industry best practices for SAP and interfaced systems to improve overall data governance for the organization.

 

Company:  SAP Americas, Inc.                                            Houston, TX   09/2006 – 03/2009

Project Description / Scope:  Master data strategy, architect and project management

Role:  EDM MDM solutions architect / PM

Responsibilities/Deliverables:

 

·         Managed several  MDM projects as an architect and was responsible for enterprise master data strategy, project planning and resourcing, designing and buiding right architecture, blue printing through realization and golive.

·         MDM solutions included clients from Phamaceutical, Media, Service and manufacturing industries and I was responsible for delivering appropriate master data strategy, best practice implementaion methodology, architecting solutions and managing projects to deliver customer initiatives and expectations.     

·         Created Enterprise master data strategy around master data governance process for global manufacturing environment clearly defining required roles and responsibilities for master data ongoing maintenance.

·         Developed and managed detailed project plan and managed resources associated with the CMDM projects.

·         Organized and conducted necessary workshops around vendor master as is master data maintenance process and created a single global governance process.

·         Responsible for understanding client expectations and scenarios, training the customer on appropriate usage of SAP MDM and developing the data model in MDM.

·         Analyzed Master data quality issues established Vendor Master Data standards. Established Vendor Master Governance process and clearly defined roles and responsibilities for global master data initiative.

·         Maintained issue and risk logs and conducted weekly project progress meetings with core MDM team. Integral part of project preparation, blueprinting phase of project and created detailed project plan for implementation, cutover activities through go live.

·         Delivered PMO Gate review documents and managed project advance through Gate deliverable activities  

·         Worked closely with technical team in the design and development of RICEFW objects. .

·         Worked on enterprise SOA architecture design framework involving platform, software and data as services

·         Ensured project deliverables are completed and communicated to the program / project managers.

·         Lead functional and technical design teams and facilitated MDM development activities.

·         Lead data activities which includes data gathering, mapping, design specifications, configuration and mapping of legacy data to SAP fields.

 

 

 

Company: Anadarko Petroleum Corporation                    Houston, TX     01/2006 – 07/2006        

Project Description/Scope: SAP Project RICEFW management and PRA management

Role: Independent Consultant, Project Coordinator                                                                                       

Responsibilities/Deliverables:

 

·         Responsible for coordinating and managing project plan which included plans for functional test, integration test and proceeding through production load for implementing PRA module within SAP.

·         Project plan tasks spanned from the initial environmental setups through the entire master and transactional data conversion load process for total integrated implementation.

·         Managed daily conversion load metrics, interfaces required from legacy systems, documenting and escalating issues as they arise in the load process, keeping project plan and share point updated to reflect daily status, as well as meeting all necessary documents required for SOX compliance.

 

 

 

 

 

 

 

Company:  Amiasoft, Inc.                                                  California, CA 02/2004 – 10/2005

Project Description/Scope:  Implementation consists of design and development and integration to SAP

Role: Product development manager

                                                 

Responsibilities/Deliverables:  Enterprise link product development for bridging the gap between engineering design and manufacturing world

·         Designed and involved in the development of suite of products –BOMLink, EntraLink and standard purchase parts libraries to facilitate manufactured-to-order and engineered-to-order manufactures integrate design and manufacturing processes.

·         Managed change control and bidirectional AutoCAD engineering bill of materials integration to tie with SAP and other systems

·         Define proper controls in multi-level product structure to generate accurate material requirement plans

 

Company: Shell Corporation                                                Houston, TX 10/2002 – 10/2003

Project Description/Scope: Material master and Vendor master conversion and sourcing project for major Oil Corporation

Role: Project Lead for vendor master conversion    

                         

Responsibilities/Deliverables:  Managed and provided leadership for supplier sourcing conversion and interfaces from six refineries legacy systems to one centralized SAP system

·         Vendor master, Materials master, Supplier sourcing, info records data conversion and migration project for all refineries of Shell Oil

·         Convert all vendors required for sourcing, contracts, materials and services.

·         Enforce supply chain standards and cross-functional teams (ten plus team) to enforce internal standards and procedures and work with the service and material contract teams to insure proper selection of vendors. 

·         Coordinate with Cleansing, technical and site teams to provide timelines and processes for delivery of cleansed vendors, sourced materials and service contracts.

 

 

Company: Software e-commerce                                         California, CA 10/2001 – 09/2002

Project Description/Scope: Role:  Shipping automation

               

Responsibilities/Deliverables:  Order management and logistics optimization

·         Managed multiple project teams in development through customer relationship management.

·         Implemented workflow driven business integration engine to capture, route and process orders automatically from multiple systems 

·         Multiple carrier backend integration to inventory controls and shipping method optimization

 

 

 

 

 

 

 

 

Company:   Accenture Inc. / Anderson consulting                 Houston, TX 02/1999 – 09/2001

Supply chain manager

Project Description/Scope: Team lead for SAP financial interface project for BP

Role:   Financial interface project lead / SAP SD, MM Project Lead      

                       

Responsibilities/Deliverables:

·         Involved in designing e-market place methodology - project implementation tool, research work on current Methodology tools, rapid implementation methodology, e-market place assets, MDM marketplaces deliverables including GAP analysis. Develop Capability matrix that identified marketplace capabilities, analysis against technology platforms, to industry. Resource planning and estimating time line for the internal project. Point of view types of exchange documentation. Develop tools for supply chain initial estimation plan.

·         One core financial interface project to SAP from current ERP packages. Core financial team lead involved in identifying needs for the interface team, identifying and eliminating redundant, not applicable interfaces to SAP. Building functional designs for accounts payables and core journal interfaces to SAP.

·         Process and sub process breakdown of core financial interfaces and reviewing with the interface architects. Work with SME's on consolidation and on identifying detailed interface requirements - invoice distributions, journals, labor transactions, inventory adjustments, received but not invoiced (RBNI)accruals, vender master data, tool charges, labor accruals, cost center and account code structures.

Anderson Consulting                          

·         SAP/EDI vendor, supplier partner function setup. Set up Port definitions, Outbound/Inbound file parameters, partner profile configuration, Message types and variant configuration, EDI testing and monitoring.

·         Configured customer/vendor relationships in SAP.

·         Implemented workflow driven purchasing process from quotations to purchase order approval

·         Design new functions, test and implement programs to monitor IDOCs to maintain integrity within the system.

·         Customizing of parameters for all purchase documents like RFQ, Quotations, Purchase Requisitions and Purchase orders, Contracts, Scheduling Agreements, Service master and service entry sheets

·         Customizing and setting up Release Procedures with and without classification for all purchasing documents viz. PR’s, PO’s, and Contracts.

 

 

Company: Dover Elevator                                                   Memphis, TN 04/1998 – 12/1998     

Project Description/Scope: SAP conversion project lead (SD, PP, Variant configuration)

Role:   Project lead for conversion project           

                               

Responsibilities/Deliverables: 

 

·         Integral team member for SAP/ R3 implementation for a made-to-order manufacturing environment.

·         Maintaining VC structure for multi-level sales order processing.

·         ALE processes to move entire VC configuration across clients and maintain integrity between clients.

·         Maintain and test classes, profiles and object dependencies for proper sales, planned and production order processing.

·         Create functional specifications for ABAP/4 programmers to generate new reports in SAP/ R3 environment from legacy systems.

·         Variant configuration course SAP/R3 and ASAP methodology.

 

Company: Compaq Computers Inc.                                   Houston, TX   01/1996 – 02/1998

Project Description/Scope:  EDI/IDOC mapping and integration team

Role: Project lead                              

Responsibilities/Deliverables: 

·         Distribution Outsourcing projects for Compaq to hand over entire distribution to 3rd party.

·         Designed implementation guide and Electronic data interchange (EDI) transactions mappings to accommodate sales order processing, materials movements, materials transfers, inventory adjustments, receipts, shipping, planning, scheduling, order inquiry and reconciliation processes.

·         Coordinated with team members to test and document above EDI transactions.

·         Prepared internal and external specifications to implement distribution of finished goods from Compaq to the third party distributor.

 

Other Professional experience

Master data management training MDM 5.5 SAP

Master data Governance training (TZMDG1) 

SAP Solutions manager Implementation certified

SAP Test data migration tool and implementation

SAP / R3 Partner Academy training "Materials Management" functional module

Advanced business consulting for technology

Training in Variant configuration for made to order manufacturing SAP/ R3 environment.

 

EDUCATION & Certification:

Bachelor of Mathematics (honors) with statistics major from Delhi University

Master data management training MDM 5.5 SAP

SAP Test data migration tool and implementation

SAP Solutions manager Implementation certified