We provide IT Staff Augmentation Services!

Sap Mdm Consultant Resume

Morton, IL

SUMMARY

  • 10 years of IT experience in SAP and business technology solutions - design, analysis, development, documentation, coding and implementation.
  • Experience on modules Master Data Management (MDM), SAP Master Data Workflows, SAP MM - Procurement and SAP APO-DRP.
  • Extensive noledge on SAP EDI & Idoc integration, SAP CRM Middleware, SAP APO Core Interface, LSMW nolwedge.
  • Served in a Master Data team role focused on configuration, interfaces, and conversions for Material Masters, Business Partners, Vendors and Customers.
  • Master Data team functional analyst with great in depth noledge of Master Data within teh SPM solution.
  • Strong project management, problem solving, presentation and interpersonal communication skills
  • Served as a functional consultant on a Procurement or Master Data team.
  • Proactively identify opportunities for cost reduction by data standardization and challenging data requests which are inconsistent with content strategies or cause unnecessary costs to be occurred.
  • Coordinated teh integration efforts of FI/CO with MM, based on functional requirements, automatic account assignment. Maintained required settings in Accounts Payable

TECHNICAL SKILLS

SAP: SAP ECC 6.0, APO(SPP) / CRM / EWM - SCM 7.0

OLAP/DSS Tools: COGNOS Series 10/ 8/8.2/8.3/8.4 , Go-Office, Series 7, Report Net 1.0/1.1 MR2, Query Studio, Report Studio, Analysis Studio, Metric Studio, Event Studio, Impromptu6.0/7.3, PowerPlay 8.x/7.3/7.4, Transformer 8.x/7.3/7.4, Upfront, Access Manager, Cognos Scheduler

Development Tools: TOAD, SQL Query Analyzer, ABAP Debugging

BI Tools: ERwin 3.5/4.0, Designer 2000, Decision Stream 7.1, Data Manager 10/8.3/8.2, Informatica 8.1/7.1, Data Stage 11/8/7.5/6.x, Business Objects

Operating Systems: Windows 95/98/NT/2000/XP/7/8, UNIX (Sun Solaris), AIX

Languages: C, C++, SQL, PL/SQL

Databases: Oracle8i/9i/10.2/11/12 MS SQL server, DB2, Teradata v2r6/V2r5

Web Technologies: HTML, XML, JavaScript, VB Script, Microsoft FrontPage

Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS Power Point, MS Access

Methodologies: Ralph Kimball’s Data Modeling, Star and Snowflake Schema Modeling

PROFESSIONAL EXPERIENCE

Confidential, Morton, IL

SAP MDM Consultant

Responsibilities:

  • Involved in blueprint sessions with process teams to gather master data requirements to support new and changing business processes.
  • Involved in workplan creating & management, design, Workshop execution, String & Integration testing, conversion, cut-over & system refresh activities.
  • Responsible for Functional Specification authoring of data interface and conversion objects including detailed base line configuration. Led teh design efforts for data interfaces with legacy environments, and data conversion programs.
  • Defined plants, purchase organization and storage locations, assigned purchasing organization to company codes and plants, assigned plants to company code.
  • Maintained Customer, Vendor, Product/material master data by Mass load (MassD) programs.
  • Extensively involved in four Implementation phases.
  • Configured workflow role resolution functions and enhanced existing workflows for IDOC objects to notify customer service representatives upon failure of an outbound and inbound IDOC's.
  • Debug and analyze teh IBM Data Stage ETL Tool. Able to perform elementary ABAP debugging to locate/narrow down code errors.
  • Wrote functional specification documents for interfaces, conversions and enhancements, conducted review sessions with teh Software Development team, and wrote test scripts in HP Quality Center test tool, conducted unit, string, integration and UAT testing. Provided master data support to process teams during test cycles.
  • Monitoring and Execution of related CIF job, Monitor and support queue error resolution, Execution of LSMW & Mass Load Programs, Understanding teh current data model and data transfer model, Variant configuration and determining CIF jobs execution flow
  • Involved in evaluating teh integration of MM with SD and FI/CO modules.
  • Worked with an ABAP/4 programmer to help defining custom IDOC requirements and set Remote Function Calls (RFC).
  • Trouble shooting I/b and O/b Queues and idoc failures in all SPM components.
  • Maintained Quarterly updates/refresh on Material master data by using Excel. Involved with DATA Management team in developing teh DATA rules to be followed regarding MDM requirements and designing teh rules for global data requirement for SPM business requirements.
  • Trained off shore and on site team members and coordinated with teh team on regular basis. Mentor and provide direction to new team members regarding MDM platform development, processes, and product architecture.
  • Monitoring and scheduling teh Jobs in SAP and in teh Tidal and solving teh issues occurred.
  • BMC Remedyfor creating tickets when on support with migration issues

Environment: SAP ECC, SAP CRM, SAP APO, SAP EWM, IBM DataStage 8.0/11.0 Cognos 10/8.4/8.3 (Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio) Power play Transformer 8.4/8.3, Access Manager, UNIX, Windows XP, DB2, Oracle 10g/11

Confidential, MI

SAP MDM Functional Consultant/Developer

Responsibilities:

  • Analyzed and documented all client requirements and business processes.
  • Served in a Master Data team role focused on configuration, interfaces, and conversions for Material Masters, Business Partners, Vendors and Customers.
  • System Design: Knowledge of system design procedures and teh ability to translate functional business requirements into an application system or process to meet teh client’s needs dat also meets all relevant Company standards.
  • Implemented master functionality and analysis for existing business.
  • Maintained detailed documentation of process flow diagrams and operational support.
  • Formulated standard operating processes and resolved sales field inquiries.
  • Prepared and updated presentations for Vendor, Customer and Material Master support.
  • Perform mass updates and upload in vendor master using Legacy System Migration Workbench (LSMW).
  • Provided master data support to process teams during test cycles.
  • Extensively involved in material master conversion process to update teh data in SAP.
  • Interacted with Onsite and off shore team members
  • Inform any errors to data providers and proactively follow up to ensure resolution is achieved.
  • Investigate and resolve system data issues and respond to inquiries related to master data and its functionality.
  • Running and monitoring of Jobs using Datastage Director and checking logs.
  • Involved with Datstage data cleansing team in validating data, removing data duplication, blacklisted vendors and customers from database as per business requirements.

Confidential, Tampa, FL

SAP MDM Consultant/Developer

Responsibilities:

  • Analyzed and documented all client requirements and business processes.
  • Involved in workplan creating & management, design, Workshop execution, String & Integration testing, conversion, cut-over & system refrresh activities
  • Monitoring and Execution of related CIF jobs to maintain data in SPPE/EWM
  • Monitor and support queue error resolution, Execution of LSMW & Mass Load Programs, Understanding teh current data model and data transfer model, Variant configuration and determining CIF jobs execution flow
  • Extensively involved in all stages of Material, Customer, and Vendor creation process.
  • Worked with Stakeholders to define teh specific Master Data attributes and authoritative systems.
  • Participated in initial MDM implementations and future rollouts.
  • Developed prototype solutions to verify capabilities for new systems development.
  • Involved with Data stage data cleansing team in validating data, removing data duplication, blacklisted vendors and customers from database as per business requirements.
  • Perform system and integration testing including teh functionality, performance and fit to ensure dat it meets teh original requirements and works within teh defined constraints.

Confidential, Kalamazoo, Michigan

MDM Consultant/Developer

Responsibilities:

  • Involved in a Master Data team role focused on configuration, interfaces, and conversions for Material Masters, Business Partners, Vendors and Customers
  • Wrote functional specification documents for interfaces, conversions and enhancements, conducted review sessions with teh Software Development team, and wrote test scripts in HP Quality Center test tool, conducted unit, string, integration and UAT testing. Provided master data support to process teams during test cycles.
  • Monitoring and Execution of related CIF job, Monitor and support queue error resolution, Execution of LSMW & Mass Load Programs, Understanding teh current data model and data transfer model, Variant configuration and determining CIF jobs execution flow.
  • Implemented master functionality and analysis for existing business.
  • Maintained detailed documentation of process flow diagrams and operational support.

Confidential, Wayne, PA

BI consultant

Responsibilities:

  • Installed and configured Cognos software including Report Net 1.1MR2 and 8 BI on Clients machine
  • Interacted with different business teams to collect teh requirements for reporting analysis. Analyzed current business processes, assess opportunities for redesigning these processes.
  • Involved in User administration and Portal Administration
  • Involved in migration of framework models and financial reports from ReportNet 1.1 to Cognos 8.
  • Built models, packages and published them using Framework Manager
  • Created Complex Dashboard reports based on teh requirements
  • Drill-through is done from Cognos cubes to ReportNet reports and Cognos Report Studio Reports to Report Studio Reports
  • Used Cognos Connection as Web Portal for managing reports
  • Involved in Security in Frame work manager and Report net Portal
  • Used Query Studio for creating adhoc reports
  • Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio. Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users. Worked on bursting reports for teh web users or email users or to directories.
  • Created Query Prompts, Cascading Prompts, Calculations, Conditions & Filters
  • Developed Prompt pages, used Conditional Variables for Conditional Formatting
  • Used Cognos Connection as Web Portal for managing reports
  • Created complex reports using Report Studio including conditional blocks, conditional formatting, stored procedures, and materialized views
  • Used Analysis Studio for multidimensional analysis and exploration of large data sources.
  • Used Event Studio window to interactively create and manage agents
  • Involved in Technical support and performance tuning.

Hire Now