Sap Mdm Consultant Resume
IllinoiS
SUMMARY
- 8+ years of professional work in SAP with expertise in SAP MDG, Data Migration, Master Data Migration, Master data management (MDM), WRICEF Development, FPM, Webdynpro, Interfaces & Workflow.
- Experience in analysis, design and develop Software solutions for Business application in SAP R/3 ABAP/4 (5.0 to 6.0) with developmental skills in SD, MM, FI/CO, QM, CRM, WM, PP and APO modules.
- Expertise in all areas of ABAP, BDT, Dialog Programming (Module pool), WEB DYNPRO in ABAP, SAP Scripts and ABAP/4 Reports (Classical & Interactive), design and development of advanced interactive reports using ABAP LIST VIEWER (ALV).
- Experiences in developing the Interfaces using ALE/EDI/IDOCs & Object oriented ABAP.
- Good experience in BDC, Enhancements, Data Extracts, Data Mapping, Data conversions, interfacing with Legacy System (LSMW).
- Extension of existing IDOC types to create new IDOC types, User Exits and Enhancements to customize the ALE/EDI process.
- Experience in custom Workflow development, Business objects project framework, Events, Business Transaction Events (BTE).
- Good programming knowledge in Enhancements using Business ADD - In (BADI) and User Exits.
- Extensively worked on customizing data dictionary objects (tables, structures, match code objects, view, lock objects, table maintenance generator, data elements and domains) and ABAP/4 tools (Menu painter, Screen painter, debugging tools and Function modules), User exits and Performance tuning.
- Fix the bugs and applying OSS/SAP notes to solve SAP issues in the standard programs for different sectors.
- Expertise in ABAP OBJECTS (OOPs) such as Inheritance, polymorphism and encapsulation.
- Expertise in performance tuning/analysis, Trouble shooting and debugging using ABAP Debugger.
- Developed and modified Forms using Smart forms, SAP SCRIPTS and also have good knowledge in Adobe forms.
- Experience in Application Interfacing Framework, Decision service management, business rule framework and floor plan management.
- Experienced well in Performance Tuning, Testing, Optimization of reports in system integration and user acceptance testing, SQL and short Dump Analysis.
- Strong analytical and problem solving skills with excellent interpersonal and communication skills.
TECHNICAL SKILLS
Operating System: MS-DOS, Windows XP, Vista.
ERP: SAP R/3 ECC 5.0, ECC 6.0.
Databases: MySQL, MS Access, SQL Server, Oracle 9i.
Programming Skills: ABAP/4, C, C++, Java, J2EE and Visual Basic
Web Technologies: HTML, VBScript, JavaScript, XML.
Graphic Tools: Adobe Fireworks, Adobe Photoshop.
Software Tools: Adobe Dreamweaver CS3, Adobe Flash.
PROFESSIONAL EXPERIENCE
Confidential, Illinois
Responsibilities:
- Master Data Governance of Confidential Lifecycle Management Consulting Services in SAP MDG system with implementation partner SAP AMERICA.
- Demonstrated excellent functional and technical skills in implementation MDG with focus on Central master data creation, maintenance, and governance using Workflow, BRF+.
- Worked proactively on Data Modeling, Data replication framework, Business Object Process Framework Process Modeling, Workflows and UI modeling.
- Responsible for various technical-functional settings, customization of standard data model for Material, Customer and supplier domains.
- Initial data loads and data migrations from legacy to SAP MDG systems.
- Worked on configuration of DRF (Data Replication Framework).
- Worked on SAP Net weaver MDG version 7.1.10 defining MDG workflow for Business as per requirements and aligning them to SAP MDG capabilities.
- E2E service delivery model including functional application management and technical support for business users.
- Good experiences in MDM implementation, which includes requirement gathering, planning and scoping, application design, configuration, testing, and deployment along with post go-live support
- Working on SAP SRM MDM Catalog, creating Web Service, working on OCI mapping
- Good experiences on creating SAP MDM validation, assignments, creating strategies
- Good experiences in Enterprise Portal implementation, Integrating SAP EP with SAP MDM, SAP SRM and SAP BI. Customizing Portal Theme, Landing Page, Worked on Knowledge Management
- Worked on User Administration task like user mapping, assigning roles and groups to users
- Hands on experiences in SAP MDG and SAP BODS
- Experience in integrating Business Objects with SAP BI, Building Universes on top of BI Queries
- Proficient in Business Objects components; Universe Designer, Web Intelligence, X Celsius
- Hands on experiences in BW (working on info cubes, ODS,Process, Chain,BEx Queries)
- Involved in writing Technical Design Specifications as per the Functional Design Specifications
- Real time knowledge of configuring Remote system/Ports, Import and syndication Maps, Workflows, Validations and Assignments.
- Worked on importing manager Data Loads using various file formats Like Excel, Delimited test, XML.
- Worked on Implementing classes by creating ABAP objects class that implements the BOPF interface.
- Worked on MDG testing, create system test plans, defect management, system integration testing and Unser acceptance testing.
- Resolved Locking issues on Business Workflows while approving CR in Mdg 6.0
- Worked on MDG 7.1 in equipment to resolve issues on error messages that were appearing in the process step of CR.
- Worked on MDG 7.0 for USMD OVP GEN Webdynpro Application to synchronize values of MDG6.1 to MDG7.0.
- Created customized Feeder Classes IF FPM GUIBB FORM ~GET DEFINITION to modify and solve the issue on EAM objects related to search helps.
- The functional module BAPI MATERIAL BOM GROUP CREATE was used to work for access class save and read development to fit to the data model by verifying all the fields of UI that can be mapped to FM.
- Worked on development of derivation and validation on MROBOM. BAdi USMD RULE SERIVE was implemented. For derivation DERIVE METHOD was used and CHECK ENTITY method was used for Validation. Several rules were implemented with different logics.
Environment: SAP MDG 6.0, 7.1, MDM.
Confidential
SAP MDM Consultant
Responsibilities:
- Creating and maintaining Material and Customer Master Data to ensure accuracy and consistency.
- Designed Repository's for Pearson's Materials and Customer Master Data
- Team member for data cleansing
- Gathered Product and Customer Data information for data modeling and repository design from business users
- Performed look ups for validation
- Master Data (Materials, Customers, Vendors) and transactional data collection, extraction, cleansing, harmonization and transformation to load into SAP
- Reviewed entered data for quality control.
- Created Tables and fields for Pearson Products in MDM data Manager
- Matching and Merging of data in Data Manager
- Maintained Production schedule profile
- Creating, modifying, deleting data in MDM data Manager
- Involved in the data migration processes to enable efficient data conversion
- Created and Maintained flat tables, Hierarchy tables, Taxonomy tables, Tuples and qualified tables for the Pearson products
- Analyzed data to ensure customers that products are correctly mapped and linked in the database.
- Maintaining the Hierarchies in Material Master Data
- Responsible for creation, release and confirmation of Production Orders
- Created and maintained BOM, Shipping and Routing
- Importing data from excel, flat file and text fie into MDM server using MDM Import Manager
- Worked with MDM Syndicator in transferring product data to other systems R/3 systems
- Matching and Merging of D- Duplication of records
- Add new validations and assignments based on clients specific requirements
- Configure Remote systems, ports part of repository administration
- Direct Integration between MDM and Sales force for create/update customer accounts
- Created master data strategies, process design patterns and data architecture.
- Responsible for coordinating with various teams and resolving any incidents, requests and issues related to master data
- Developed rules and regulations to handle enterprise master data concerns.
- Evaluated existing data management processes and recommended changes to enhance effectiveness.
- Maintain and repair applications in order to keep them performing according to technical and functional specifications.
- Ensure the timely delivery of solution and closure of issues.
- Data check for completeness, accuracy
Environment: SAP MDM, ECC 6.0
Confidential, Kansas City, MO
ABAP Consultant
Responsibilities:
- Designed an interface program to update the sales order changes coming from legacy system (COD) using the BAPI BAPI SALESORDER CHANGE.
- Used BADI to change the vendor number to personal number while creating the vendor master record from the HR master record using the transaction code PRAA. The BADI used was BADI EXITS RPRAPA00.
- Designed and developed a module pool program Data Template Management where users will create templates which will define the characteristics or fields and the corresponding sequence which are used to prepare files data files for all batched being shipped to customer.
- Created an extension from Standard IDOC type WBBDLD03 to provide Outbound Interface, to send Material Master Data, from the source system SAP retail ECC 5.0 to target system.
- Used BAPI name BAPI VENDOR EDIT to modify some of the suppliers in the Vendor Master Data.
- Worked on enhancement for Billing Document Number Based on Location and created customer table with Sales Organization, SD doc category and Number range.
- Created a SAP business Workflow using Business Objects for sending work items to different processing groups, upon creation of a Material Management Group on the Plant, Movement type and Storage Location.
- Worked extensively on Variant conditions in pricing for a trading contract. For the purchasing configuration, employing the MM variant conditions and for the sales configuration employing the SD variant conditions
- Configured the system for Make-to-Order situation using Variant Configuration to provide dynamic configuration and variant pricing to encompass variant surcharges and discounts.
- Developed logics for creation of Auto PO from ECC Purchase Requisition.
- Developed conversion program including vendor master, purchase info records and customer material info using LSMW, a data migration tool by SAP.
- Debugged various programs for enhancements and resolved issues in the developed reports before transporting to production system.
- Created & Extended IDOCs, Message types with additional segments supplementing the requirements of the documents to be transferred.
- Developed Web DYNPRO applications for search and administration of existing requests using POWL Framework.
- Converted existing SAP Scripts to Smart Forms for Sales Order, Invoice and Delivery Note.
- Created Adobe Print Forms using Adobe Designer form Layout tool for creating Order Confirmation form, Master pages in different styles, body and sub forms in the process.
Environment: SAP ECC 6.0
Confidential, San Antonio, TX
SAP Consultant
Responsibilities:
- Developed FI AR aging report which lists out due amounts of customers which exceeds the permissible due date by customer group, business area and region wise.
- Developed a RFC to take in the user input through Web and update the transactions MB1B, VB01, VA02, VL01N and VT01N using BDC for Consignment process.
- Used LSMW data loads program to get the mapping fields from Legacy system and created routines for Data upload for Fixed Assets, General Ledger, Converted AR Customers, and AP Vendors etc.
- Developed User Exit to reset the arrival time when a schedule line is created for sales order processing program (SAPMV45A).
- Worked on repairs/enhancements of a project ‘Demo Inventory Scheduler’ which used ALV reporting, call transaction etc.
- Worked with the BAPI, BAPI DELIVERY GETLIST to get the list deliveries based on the customer number and sales order number to show up in the form of report.
- Written inbound interface using BAPI function call BAPI MATERIAL SAVEDATA to update the capacity usage field.
- Designed an outbound interface to send the order information from SAP to legacy system using ORDERS05 IDOC’s type.
- Extended INVOICE02 IDOC in order to populate the shipping information in the invoice.
- Designed an inbound interface to get the purchase orders information into SAP using the IDOCs.
- Developed an application for Commodity SWAP in Treasury.
- Worked on the interactive PDF forms and Workflow scenario for the Hedge Request forms.
- Configured master data required for Variant configuration of Materials. Maintained super BOM and Routing for reference materials.
- Developed a BDC program for changing the purchase order, sales order creation, and material creation, changing the material type in the material master transaction.
- Generated a report to display the consignment cut process, open sales orders, change orders and change batches for the materials.
- Designed a SAP script for check form printing for Account Payable (FI-AP).
Environment: SAP ECC 6.0
Confidential, Houston, TX
SAP ABAP Consultant
Responsibilities:
- Involved in ALE configuration, worked with change pointers to distribute Purchase Order Master Data (ORDERS) across the Logical Systems.
- Used Message controls to distribute Purchase order data across Logical Systems.
- Worked on the EDI 850 interfaces, which changes Sales Order data based on the incoming transactions from the B2B hub.
- Worked on Front End Tool to upload the shipment information received from various third-party distributors into SAP staging table.
- Developed a complex enhancement for Mass copy Master Data i.e. BOM data and creation of Master Recipes and Production Versions.
- Developed a custom SAP transaction (Module Pool Program) to facilitate goods receipts into inventory in SAP for turkey parts at Newberry.
- Created BADI implementation for interfacing new fields from MDM to ECC for Demand Tec extract and Update Custom table in SAP.
- Worked on appending custom structures to the Standard table VBAK. New fields were added to VBAK that stores legacy Sales Order Number and Screen Changes to VA03 have been implemented.
- Developed Cost Estimate Comparison Report to compare two cost estimates in SAP in a single report in order to provide detailed variance reporting.
- Developed an interactive report to create Inbound Deliveries and Post Good Receipt for STO’s and PO’S.
- Developed Inbound Interfaces to update custom tables in SAP with the data sent indirect customers for SAP BI reporting environment.
- Processing Sales Volume Data via IDOC’s received from EDI.
- Processing Inbound EDI 867 Indirect customer information to ECC.
- Worked on BADI’s in Purchase Orders to have custom logic in BADI ‘ME PROCESS PO CUST’.
- Modifies the existing Layout sets of Smart forms to include Company Logo and additional data as per requirement in Sales Order- RVORDER01, Invoice- RVINVOICE01, Delivery Note- RVDELNOTE, and Packing List- SD PACKINGLIST.
- Worked extensively in Sales order User Exits in MV45AFZZ.
- Created implicit Enhancement Implementation points while posting GR.
- Developed Interfaces, which transfer data from ECC to legacy systems using Proxy.
- Worked on SAP Script Modification for Sales Order along with the Driver program.
- Modified an existing ABAP Query Report to add the valuated stock for materials in different plants.
Environment: SAP ECC 6.0
Confidential, McLean, VA
SAP ABAP Consultant
Responsibilities:
- Enhanced the process of releasing blocked invoices using MRBR to update goods receipts matching quantity and amount with reference to SRM purchase order. Used Enhancement Spot to export values and implemented BADI (MRM BLOCKREASON DELETE) to unblock the invoices with respect to its matching good receipts.
- Designed and Developed Swiss Invoice Payment Slip Smart form to match the preprinted layout design along with all material its serial numbers quantity VAT % to account subtotal and total amount with multi-page setups.
- Worked on modifying the enhancement portion of FSCM BADI (UKM CHECK ST) that does credit check rule. Checks for customer’s sales order say 25% of open invoices past due then our functionality should block invoices.
- Worked on an interfacing material classification and characteristic details via IDOC between MM and PLM were Web Methods is used to as mapping tool. Used BAPI (BAPI OBJCL GETCLASSES) to obtain object classes to replace classification and characteristic values on SAP.
- Processed the IDOC of Message Type MBGMCR to update the status with its failure custom message with relate to its Material and Quantity information using WE19 and so on no good receipts is done if the IDOC quantity is different from the delivery quantity. Once the IDOC quantity changed to match delivery quantity good receipt is posted.
- Modified the Reconciliationbalance reportbetweenLexmarkanditsSMIsuppliers for various movement types 101,561,565,411 with specified manipulation as per requirement.
- Worked on Balance Sheet Report to send all General Ledger details from SAP to ARIBA using custom RFC call. To send GL total details along with Profit center, cost center and foreign currency checks.
- Worked on a User Exit to Change Payer value for invoice list instead Sold to party value of Invoice when creating invoice List using VF23.
- Created SAP Standard BADI and Enhancement Spots according to OSS Notes for correction notes to resolve production issues with the help of BASIS Team.
- Worked on Travel Management issue using transaction TRIP to debug and analyze the cause applied OSS notes to solve the issue.
- Worked on an interfacing object to replace the blank incoming details of Unit of Measure from GTS with secondary UOM on SAP side, which needs to be populated/ updated properly in table T604.
- Worked on bug fixing on global, export and Swiss payment invoice Smart forms on most of the client forms.
- Worked Offshore Co-coordinating lead and Production support break fix and War room, fixed issues with High Severity Ticket handling objects.
Environment: SAP ECC 6.0
Confidential, Rumford, RI
SAP ABAP Consultant
Responsibilities:
- Developed BADI to raise an error message when material pricing group of sales item from close out to open items during sales order creation.
- Created an ABAP report for showing the open purchase order details.
- Configured Message types, RFC Destination, Port, and Partner profile for IDOC, ALE communication with Hand Held Devices through PI.
- Developed Outbound IDOC for Customer Master, Material Master, Material Pricing, Credit Control Limit, Customer Open Items, and Van- Load.
- Developed IDOC Inbound program for Sales Order, Accounting document, Load Request by calling proxy class and IDOC INBOUND SINGLE function module.
- Developed a custom program to obtain Outbound Interface to create and upload output file into legacy system on quarterly basis.
- Worked with BAPI PO GETDETAIL to get details of delivered quantity of each items in purchase order used BAPI PO CHANGE to close long pending open PO.
- Create excel file E-mail using CL BCS class to send Critical Stock Materials to Warehouse Manager.
- Activated BADI in Good Receipt to Store Vendor Specific Number and SAP GR Document Number in Custom.
- Master data loads of Material Master, General ledger, Profit Centers and Cost centers using Batch Input Method.
- Developed OOPS ALV report to display Open Contract and Sales orders for Sales Org according to the Order date and document.
Environment: SAP ECC 6.0
Confidential
SAP APAB Associate
Responsibilities:
- Developed ALV report to accurately calculate the “Total Replenishment Lead Time” for the material by exploding the BOM components of material and calculate the TRLT of each component to get main assembly component TRLT.
- Created ALV report to show the no of units/equipment is in services on daily basis based on location. Internet Transaction Service for this ALV report to integrate in Enterprise portal was created for SMART Project.
- Developed Hierarchical Report for Cost Comparison for materials against two fiscal years and drill down to the CKMPCD transaction.
- Developed a custom workbench for SAP Role review process as a part of SOX Audit. The workbench consisted programs to maintain Role Owners and Role Owner managers and review the role assignment and remove the role automatically and send the necessary emails to concerned users.
- Executing standard RFC/BAPI to create Material Document, Transfer Order creation by using BAPI GOODMSVT CREATE, L TO CREATE TR, L TO CREATE DN, and L TO CREATE SINGLE RESPECTIVELY FROM SAP XMII GUI.
- Enhanced IDOC (ORDERS05) to accommodate Custom text and sub contract components to EDI 850.
- Developed custom IDOC (EDI 824) to send /receive rejection reason against INVOICE (810).
- Developed smart forms to print Excise Tax Invoice, Quotation, Order Confirmation and WTC (Work Test Certificate).
- Developed email functionality to trigger different emails based on the process like when the notification is created or released with specific user status.
Environment: SAP ECC 5.0
Confidential
ABAP Associate
Responsibilities:
- Developed the ALV report to include the number of pages (Page number yyy of zzz). The statistics also can be seen when printed.
- Developed a Classical report for Material Management (MM). The report shows the Material name, Material Description and the available Quantity.
- Developed a custom Classical report that prints Sales Materials for a specified range.
- Developed an Interactive report, which displays all the sales orders for one particular customer. Details like goods issue date, the materials ordered for that particular order, quantity ordered, and contact information about that particular customer is also displayed.
- Worked on Interfaces using a BAPI by name BAPI ACC DOCUMENT POST. This was done to get the information’s like Company code, Pricing, Period, Currency, Posting date, Posting key, Cost center and Profit center from a flat file to post the same into G/L account for payroll in the FI/CO integration.
- Created BDC programs for Customer, Vendor, Material master & BOM uploading from excel to R/3 systems.
Environment: SAP 5.0