We provide IT Staff Augmentation Services!

Is Retail Master Data Consultant Resume

SUMMARY:

  • Around 13 years experienced SAP IS Retail Master Data Consultant currently working for T - Mobile and previously worked for Various Retail Clients like Walgreens, Luxottica and MARS through Accenture, IBM, NTT Data with deep hands on experience in SAP IS Retail, SD, MM, WM, PP, QM and ABAP.
  • Have a thorough Knowledge and experience in Design, Configuration, Creation of various Master Data like Article Master, Site Master, Merchandise Hierarchy, Merchandise Category, Pricing conditions, Bonus Buys and Promotions.
  • Well versed with SAP Procure to Pay and SAP order to Cash cycle.
  • Having worked with IBM as a SAP Functional Consultant with core expertise in SAP Retail/ECC Master Data Conversion
  • Worked with Accenture on large retail project of Walgreens for IS Retail/SD/MM areas as a functional consultant handing from configuration to preparing functional specifications, technical specifications, RICEF object development,
  • Worked on four end-to-end implementations including having worked with IBM for 3 years.
  • Rich experience of designing and developing reports, interfaces, enhancements and forms (all RICEFs).
  • Worked on retail data conversion and creating test scripts for various IS Retail processes and involved in integration test cycles and regression cycles.
  • Keen and enthusiast to learn new areas very quickly and can prove success
  • Experienced in Understanding Business Processes, Study and Analyze Workflow to design solutions
  • Experienced in creating Articles - Single Articles, Generic Articles, Structured - Prepack, Sales Set, Articles, Merchandise Category Articles and Value Only Articles
  • Experienced in migrating the Article Data from the Legacy System to SAP IS RETAIL using LSMW - Standard Batch Input Recording Method and Batch Recording Method
  • Responsible for writing the functional specs for enhancements and interfaces and conversion program, relevant mapping documents and data definition documents for Article master custom fields, Vendor master custom fields, Article cross table, vendor cross table
  • Experienced in Design, Configuration and Creation of Time Based Transaction Master Data like Purchasing Info Record, Source List, Assortment and Listing Conditions
  • Involved extensively in the data conversions for integrating Insurance codes to Articles including Frames, Lens packages, Accessories etc
  • Worked on the mass maintenance of characteristic values of frames, lenses, accessories, lens packages using MASS CHARVAL in FMS environment.
  • Worked extensively in ORDERS05 and DELVRY05 idocs for global Mark downs
  • Well acquainted in mapping and loading Transaction Data from the Legacy System to the SAP IS RETAIL and ECC 5.0 - like Purchase Order Data, Sales Order Data, Transfer Orders and Delivery Data
  • Extensively worked on conversion activities as a conversion lead handling conversion strategy, conversion approach, designing conversion objects based on approaches such as IDOCs, LSMW, BDC, Batch input etc, developing objects, testing and uploading the master data.
  • Expert in handling master data related issues such as Gapping, Mapping based issues, troubleshooting conversion object related issues, testing, data profiling etc.
  • Strong Expertise in various functional areas like SD, MM, FI, IS - Retail and HANA (Trained on HANA from modeling and implementation perspective).
  • Worked extensively with POS interface for all master data outbound and inbound integration.
  • Rich experience around Bonus Buy, Promotions.
  • Have rich experience in working with Retail and Non Retail IDocs - ARTMAS, WP PLU,WBUPON, WPUWBW, WPUTAB, WPUFIB, WPDWGR, ORDERS, DEBMAS and CREMAS
  • Involved in writing the Test scripts for testing all Standard, Exceptional, Negative and Performance scenarios
  • Well acquainted with Unit Testing, System Testing and Integration Testing across various Modules
  • Have experience in transporting changes from Development to Quality to Production
  • Professional expertise in independently configuring and customizing SAP R/3 (IS - Retail).
  • Experienced in using the tools SQL Trace and Runtime Analysis for performance Tuning.
  • Experience in creating the bonus buys, promotions in FMS environment
  • Expertise in using ABAP/4 Workbench Tools, reporting, customization, conversion and data extraction.
  • Versatile in Programming, Implementing, and Conversions using LSMW, BDCs (Call Transaction & Session Methods), and BAPIs.
  • Experience in programming with User Exits, BADIs
  • Prepared Functional and Technical specifications.
  • Experience in ABAP RICEF (Reports, Interfaces, Conversions, Enhancements and Forms) and ADOBE Forms.
  • Excellent expertise in ALE/IDOCS for both Inbound and Outbound.
  • Experienced in using the tools SQL Trace and Runtime Analysis for performance Tuning.
  • Expertise in using ABAP/4 Workbench Tools, reporting, customization, conversion and data extraction.
  • Skills around SAP HANA modeling and Reports & Proficiency in developing information models Attribute views, Analytical Views and Calculation Views using SAP HANA Columnar tables, knowledge on the functionalities of SAP HANA data base.
  • Interaction with domain/team, client in process of resolving the issues.
  • Prepared Technical specifications and Unit Test Results
  • Well experience in performance tuning and fine tuning of the programs.
  • Analyze functional specification document and prepare Technical approach to meet the requirement and to prepare code review documents, quality documents, Unit test results and technical design documents

TECHNICAL SKILLS:

SAP IS Retail: Prime skills are in SAP IS Retail Master Data, SAP MM Retail, SD Retail, Retail idocs, Promotion & Pricing.

Trained in SAP IS Retail module: Principles of Integrated Retail Management, Overview of Functions in SAP for Retail, Purchasing and Warehouse Distribution, Headquarters to Store Connections: POS Interface and SAP Retail Store

Obtained in SAP: ABAP/4, ABAP Objects and acquired hands on experience in the development of classical, interactive and drill down reports, gained knowledge of BDC, LSMW, BAPI, ALE, EDI, IDOC and functional modules

PROFESSIONAL EXPERIENCE:

Confidential

IS Retail Master Data Consultant

Responsibilities:

  • Involved extensively in creating custom program for SKU Master creation tool using BAPI -BAPI MATERIAL MAINTAINDATA RT utilizing the BAPI to create characteristics, Plant Data, Material Description, Storage Location data etc.
  • This tool would even perform the extension of article master to different sales organization.
  • Created LSMW template for Article Master creation for new SPRINT and Confidential related Characteristics for the Basic Data view and creating the rest of the views like Listing, Purchase, Sales, Logistics DC, Logistics Store and POS views.
  • Created a Mass Maintenance Work Bench tool to maintain the Existing Characteristics and New characteristics for the Article Master.
  • Worked extensively performance testing on Listing process using WSM3 for huge volume of Article master and Assortment user-Site customer.
  • Enhancing the existing Article POS download programs to achieve the better performance.

Confidential

SAP ABAP Technical Consultant

Responsibilities:

  • Created Inbound ABAP Proxies for interacting with Visual Control Board to interact with SAP and provide them BOM explosion data for the provided work unit and another proxy for sending the open purchase orders, sales orders, open stock details in all the storage location, Inspection Plan data, Vendor data to VCB interface.
  • Developed an interface program to create the Transfer Orders in Mass for the Kanban Transfer orders using the BAPI- BAPI GOODSMVT CREATE.
  • It creates goods movement between storage types with the movement type 311- Transfer Posting. It creates material documents and Transfer orders. This facilitates the business users to perform mass ordering form stores.
  • Developed an enhancement program to send the negative costs with KF status to the Third party system GIL along overall cost estimate including material costs - standard and Planned, Fixed Overhead cost, Variable Overhead.the cost estimates are sent via outbound proxy to GIL using BAPI COSTESTIMATE GETDETAIL
  • Enhancement of Kanban PO create program to calculate PO quantity with Maximum Order quantity based on the Shortage quantity using BAPI PO CREATE1
  • Automate creation of production order and purchase orders for the Subcontract operations using BAPI PRODORD CREATE and BAPI PO CREATE1

Confidential

SAP Retail Functional Consultant

Environment: SAP FMS

Responsibilities:

  • Involved extensively in Functional designing, preparing specifications for the global Markdown programs
  • Extensive work around interfaces for master data and pricing
  • Creating the enhancement programs for populating the WAS price and NOW price in the custom segments for ORDERS05 idoc. The markdowns will be created through promotions and the respective idocs segments should carry the prices before and after markdowns.
  • Creating the interface programs for populating the WAS price and NOW price in the custom segments for DELVRY05 idoc. and to trigger the output through Shipping notification.
  • Created a conversion program to create the promotions using BAPI technique BAPI PROMO CREATE extensively for uploading the promotions.
  • Worked on the tag printing program for printing the WAS price and NOW price
  • Responsible to troubleshoot all design related issues or scenarios

Confidential

SAP Retail Master Data Consultant

Environment: SAP ECC/ IS Retail

Responsibilities:

  • Involved extensively in Requirements gathering from both Walgreens Business and Boots Business, functional specs, technical specifications, writing ABAP codes, unit testing.
  • Responsible for analyzing the gapping between legacy process of Walgreens and providing solutions to map them in SAP.
  • Responsible for coordinating with the offshore technical team for the successful build of the conversion, interfaces and enhancement programs
  • Responsible for writing the functional specs for enhancements and interfaces and conversion program, relevant mapping documents and data definition documents for Article master custom fields, Vendor master custom fields, Article cross table, vendor cross table.
  • Responsible for writing the Enhancements functional specs for defining all the Data elements, Domains, check tables, custom tables, F1 Help texts, Screen layout for article and vendor master custom fields.
  • Responsible for writing the interface functional specs for sending the Article XREF table extract and vendor XREF table extract to middleware and Software AG
  • Responsible for the writing functional specs and relevant FDM for Article Hierarchy interface to PCMS
  • Involved in writing the Test scripts for testing all Standard, Exceptional, Negative and Performance scenarios

Confidential

SAP Retail Master Data Consultant

Environment: SAP FMS

Responsibilities:

  • Responsible for creating a new Interface for mapping them with all the Lens Crafters Assortment so the new Receiver will have all the Lens Crafters commodities of Frames, Sunglasses, Contact Lenses, Readers and Lens Packages and Doctor Services
  • Experience in creating the representative site for the new interface
  • Involved extensively in the data conversions for integrating Insurance codes.
  • Experience in the conversions of insurance codes of Frames and sun frames in FMS
  • The New characteristics is added as the Insurance codes to all the articles and as a result the articles are tied to the Insurance Claim
  • Responsible to troubleshoot all design related issues or scenarios
  • Worked on outbound idocs, exclusively WBBDLD idocs, scheduling and synching up with POS systems.
  • Experience in using WDBM HPR,WDBI HPR and WDBU HPR Transaction codes

Confidential

SAP Retail Master

Environment: SAP FMS

Responsibilities:

  • Creation of various single use coupon condition types for the customer related deals and Associate/Employee related deals
  • Creation of various deals for Percentage off and Dollar off deals
  • Testing and validation of single use coupons and the Miniapp which creates the serialized codes for single use coupons, generate deals and validate deals.
  • Creation of WPDBBY idocs for Bonus Buys and triggering them as individual store levels or at the whole distribution chain level deals
  • Experience in creating the global transaction level deals, and single article levels Bonus Buys.
  • Creation of single use coupons for exclusion of all accessories by creating the article grouping in VBG1 for exclusion

Confidential

SAP Retail Master

Environment: SAP FMS

Responsibilities:

  • Involved extensively in setting up the Brazil Duty Free shops and Brazil Franchisee stores.
  • Creation of various sites for Brazil Dufry Stores and the Brazil Franchise sites
  • Creation of the SQ00 query Reports for Loading of Articles in the own POS systems
  • Experience in mapping the CNPJ numbers and setting up the CFOP categories for all the Brazilian sites
  • Worked on the conversions of Brazilian articles in FMS environment
  • Experience in setting up the Brazilian fields for the articles and the CFOP values
  • Experience in creating and validating the Boleto and Commodato Forms which are legally required in the Brazilian Business

Confidential

SAP Retail Support Consultant

Environment: SAP ECC/IS Retail

Responsibilities:

  • Responsible for master data support and ongoing changes/enhancement
  • Worked on merchandise hierarchies, categories, characteristics, article types, EANs, base unit of measures, etc
  • Regular support to other IT team for various master data issues along with supporting entire business leadership and middle level management folks.
  • Create/change article master on regular basis for various article categories such as single articles, generic vs variants, sales sets, service articles etc
  • Responsible to troubleshoot all design related issues or scenarios
  • Work on outbound idocs, scheduling and synching up with POS systems.
  • Responsible for creating and maintaining bonus buys etc
  • Was responsible for configuring Site, Vendor and Customer Master Data for US/UK/China Sites and Vendors
  • Experience in creating New Merchandise articles type ZMCH such as Keychains, Magnets, Iphone cases, Plush Toys with various characters, Caps for Adults and Youths,, Personalized items in various Material groups for various Regions in UK,US and China.
  • Experience in creating various Apparel articles of the Article type ZAPL with different sizes and different colors under Fleece material group and have extended the individual variants to the specific stores
  • Experience in creating various Finished Goods of the article category Sales Set like various components in the BOM components
  • Experience in creating various coupon articles and Bonus Buys for various offers like 15 % OFF for purchase of 50$ Plus etc for various stores like New York, Orlando, Las Vegas, London Shanghai
  • Created various Merchandise of the category single article and Sales set involving the manufacturer UPC codes, BOM definition, Handling the Retail Prices, various cost condition types, Defining the source lists etc.
  • Creating various cost condition types ZP00 Gross Price, duty Charges, Ocean freight charges, Air Fright charges etc in MEK1
  • Created various Assortment and Listed them to individual Stores and Distribution Centers
  • Creating Retail Pricing for new articles and Price changes for existing articles
  • Created many LSMW objects to fix various issues like Planned Delivery Lead time, Inconsistencies across all the Distributon Centers and Stores.
  • Quarterly Price Mark downs for Shanghai and London Stores
  • Created a Report for Pick Fill rate and SKU fill rate in the Various Warehouses.
  • Had a good understanding of the Client’ Business Requirement
  • Acquired experience in Configuration of Enterprise Structuring - assigned Shipping Points to Canadian Sites under Logistics Execution
  • Set up Merchandise Category Articles to have Purchasing Organizations information for both U.S.A. and Canada
  • Tested merchandise category articles, pre pack and value only article functionality to ensure no changes necessary for multiple organizations
  • Tested current LSMW loads to ensure all relevant data were populated as expected for the new organizations additions
  • Changed Purchasing Info Rec to allow Clients to have different Confirmation Controls for different Vendor / Site / Articles
  • Was involved in the discussion of POS (Custom POS) consideration for Canada Rollout

Confidential

SAP Retail Master Data consultant

Environment: SAP ECC/ IS Retail

Responsibilities:

  • Was responsible for Master Data Conversion - Site, Vendor, Customer, Merchandise Hierarchy, Merchandise Categories, Article Master, Source List, Purchasing Info Records.
  • Defined Field Mapping, Conversion Rules and Value Conversion for the Data Models
  • Acquired experience in Configuration of Enterprise Structuring
  • Defined Account Groups for Vendor Master and Customer Master and modified the field status for different field groups using Field Selection
  • Integrated with other Modules like SD / FI during the time of creation of new Sites
  • Created Merchandise Category Hierarchy, Assigned the hierarchy levels, configured the article master to have the standard screen sequence and loaded single articles, generic articles, articles, value only articles and merchandise category articles into SAP - article being single and generic articles
  • Created Characteristics Profile and assigned it to Merchandise Categories in order to create various generic articles and their corresponding variants
  • Created Assortments and assigned Merchandise Categories and Sites to it
  • Configured the system to get default data into article master to ease the task of the user
  • During Go Live, worked on POS Initialization to push required master data records using TCODE WPMA
  • Change pointers were used to send master data changes to POS System using WPMU
  • Prepared Functional Specification for new Development
  • Worked with Basis team in the process of archiving POS IDocs
  • Rich experience of working with retail IDocs such as WP PLU, WPUWBM, WPUTAB, WPUFIB, WPDWGR and non retail IDocs such as ORDERS, DEBMAS, CREMAS
  • Experience of working with POS Inbound and Outbound interface transactions such as idoc monitoring transactions WE02, WPER
  • Prepared various test cases in order to test the end to end processes for Sales Return, Price Adjustments and Cancellation from the Point of Sale to the SAP Retail System
  • Compared the articles, Price and Tax information that were sent from SAP to POS, to complete data validation
  • Experience in full life cycle starting from Kickoff through Go Live in conversion from the legacy system to SAP IS RETAIL
  • Configured the settings for the lot size and RP type for requirement planning for a distribution center
  • Familiar with Sales Price Calculation - One Step and Two Step Calculation using Pricing Table containing List Groups, List fields and List Variant
  • Defined Document Types and Screen Layouts at Document Level, Maintained Info Records, Source List Determination, Outline Agreement, Account Assignment and Account Determination
  • Defined Account Groups for Vendor Master and Customer Master and modified the field status for different field groups using Field Selection - for new Distribution Centers
  • Assigned different Number Ranges for the Vendor Master Account Groups and Customer Master Account Groups
  • Configured the Site Profiles using Account Groups from Vendor and Customer Master Data
  • Created Sites for DC Site and Site using the new site profiles
  • Assigned the created Sites to the Site Profiles created
  • Configured the Site Profiles to display default Organization Data in Site Master Data - This is like a warning or hard stops from updating or adding data in wrong company code / organizations
  • Assigned various partnership functions to the Customer Account Groups created
  • Changed Article Master Data and Purchasing Info Rec to allow Clients to create Purchase Orders using variable order units (Each / Dozen / Boxes) for the same article (Snickers Bars) - which was a major requirement for the Client.

Confidential

SAP Retail Master Data consultant

Environment: SAP ECC/ IS Retail

Responsibilities:

  • Responsible for the Roll Outs of SAP Retail master data such as Article Master, Site Master, Vendor Master, Customer Master, Info Records, Pricing Records, Source List, Bonus Buy, Promotions, Assortments, Merchandise Hierarchies, Merchandise Categories etc to Shanghai region
  • Created various Merchandise of the category single article and Sales set involving the manufacturer UPC codes, BOM definition, Handling the Retail Prices, various cost condition types, Defining the source lists etc.
  • Uploading the customer master data into ECC through IDOC method of LSMW using custom message type and customized idoc type.
  • Created the LSMW objects for changing the stores Lead times as 1 day for Replenishment to the stores
  • Was responsible to manage inventory supply chain process across distribution networks using SAP IS-Retail functions
  • Was involved in Pricing - two step and single step pricing, Retail Pricing, Retail Promotions Configuration - Set up of retail promotions and bonus buys, understanding the requirement for setting up of wholesale operations, Sales Price Calculation, Allocation Table, Allocation Rule for Creation of Sales Order and Article Listing Process - working on SAP ECC 6.0
  • Synchronized all processes from inbound, internal warehouse and outbound processes. Applied (JIT) Just In Time methodology provided by SAP IS-Retail functions to increase service level to the customers and at the same time reduce inventory level
  • Set up purchasing organization group, distribution center, Merchandise Category creation and variant configuration
  • Worked on Vendor evaluation, Purchase requisition, RFQ, Purchase Order, Pricing, Contract, Schedule agreement, Inventory Management: Goods Receipt, Goods Issue, Stock Transfer and Transfer Posting
  • Participated while testing the following functions in SAP IS-Retail Implementation - Category Management (articles and classification), Assortment Management, Season Management, Promotion Activities, Merchandise Logistics etc

Confidential

SAP Retail Master Data consultant

Environment: SAP ECC/IS Retail

Responsibilities:

  • Responsible for the Roll Outs of SAP Retail master data such as Article Master, Site Master, Vendor Master, Customer Master, Info Records, Pricing Records, Source List, Bonus Buy, Promotions, Assortments, Merchandise Hierarchies, Merchandise Categories etc to Shanghai region
  • Created various Merchandise Hierarchies and Merchandise Categories. Harmonized between different divisions and company codes.
  • Worked on single article, generic vs variants and sales set
  • Worked on manufacturer UPC codes, BOM definition, inhouse EANs
  • Handled the Retail Prices, various cost condition types, defining the info records and source lists etc.
  • Uploading the customer master data into ECC through IDOC method of LSMW using custom message type and customized idoc type.
  • Created the LSMW objects for changing the stores lead times for Replenishment to the stores
  • Regular production support to business based on custom ticketing system
  • Worked on article master support, sales prices, info records on regular basis including mass upload or mass maintenance.
  • Responsible for all master data related updates, enhancements, issues.
  • Worked regularly with custom development team for new enhancements such as goods receipts and enhancing vendor batch field to 18 digits.
  • Prepared functional specification documents and helped technical team to prepare technical design documents.

Hire Now