SUMMARY

• Around 12 years experienced SAP IS Retail Functional Consultant currently working for Confidential - Confidential and previously worked for Accenture, IBM with deep hands on experience in IS Retail, SD,MM,WM,PP,QM and ABAP.
• Well Experienced in Retail Pricing, Promotions and Bonus Buys, Retail Master Data.
• 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
• Recently working at Confidential Retail's FMS project for global markdown project and coupons and Bonus Buys
• Worked with Accenture on large retail project of Confidential 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 (As-Is and To-Be Analysis and Freezing), Preparing Business Blue Print and Requirement Document
• Experience in design, configuration and conversions of the article master in FMS environment.
• Experienced in Configuring SAP Best Practices for Retail on ECC 6.0 to create a preconfigured SAP IS Retail Server to enable faster implementation timelines and also provide a collection of prototypes for effective client engagements during sales as well as Blue Printing Phase
• Have a thorough Knowledge and experience in Design, Configuration, Creation and Assignment of various Master Data like Vendor, Customer, Site, Merchandise Hierarchy and Article Master Data
• Experienced in creating Articles - Single Articles, Generic Articles, Structured - Prepack, Sales Set, Reference 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 reference table, vendor cross reference 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
• Expertise in both BDC programming and conversions using LSMW and win shuttle scripts
• 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 (well 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 - WP PLU, 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.
• Experience in working with Data Source Extractors.
• 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.
• Working experience using SAP Business object Data service (BODS), SLT in past.
• 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 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 training 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

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.
• Created an interface program to Create and Maintain BOM using function module CSAP MAT BOM READ, CSAP MAT BOM CREATE and CSAP MAT BOM MAINTAIN. This program creates the Change number using CC01.
• Created a custom Module pool program to perform the customized sequence picking of LM07 standard system guided picking in ware house management based on the specific storage types and Bin locations
• Created an conversion program for creating Mass Transfer Orders based on the stock availability at IM and WM stocks.
• Created a comparison report to find the discrepancies in BOM structure of the material between SAP and the Legacy systems BOM structure using CS BOM EXPL MAT V2 for BOM explosion.
• Created an Enhancement program for Sourcing Cockpit. This cockpit program provides multiple functionalities to the Procurement team to track down the Open Parts and Closed parts, assign a new Parts, reassign to the specific purchasing group for facilitating further procurement activities. This will trigger email to the respective commodity manager and the procurement team about sourcing of New Parts.
• Developed an interface program to create the Transfer Orders in Mass for the Kanban Transfer orders using the BAPI-

Confidential

SAP Retail Functional Consultant

Responsibilities:

• Involved extensively in technical designing, preparing technical specifications and developing programs and debugging codes
• 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 Functional Consultant

Environment: SAP ECC/ IS Retail/HANA

Responsibilities:

• Involved extensively in Requirements gathering from both Confidential Business and Boots Business, functional specs, technical specifications, writing ABAP codes, unit testing.
• Responsible for analyzing the gapping between legacy process of Confidential 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 reference table, vendor cross reference 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 code for various user exists, BADIs and BDCs.
• 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 Functional Consultant

Environment: SAP FMS

Responsibilities:

• Involved extensively in Blueprinting planning & scheduling, functional specs including and FMD documents
• 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 Functional Master Data

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 Techno-Functional Master Data

Environment: SAP FMS

Responsibilities:

• Involved extensively in setting up the Brazil Duty Free shops and Brazil Franchisee stores.
• Creation of various reference 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:

• Involved extensively in Blueprinting planning & scheduling, conducted workshops, process flow graphs, landscape presentations, functional specs including high level technical flows in some cases including pseudo codes for critical objects.
• 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 Reference 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 Reference 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
• Reviewed several LSMWs that were created to load Purchasing Info Rec and Article Master Data
• Provided the user with the ability to maintain different Planned Delivery Time by vendor / site for an article
• Prepared a list of Cut Over Activities for transporting the configuration of master data
• Performed Integration Test and Regression Test after releasing the transporting the changes to QAS along with team members
• Additional Articles, Generic Articles, Value Only Articles and pre pack articles were created
• Tested the Material Management Process and Sales Order Process to make sure that the same UPC articles worked for both the companies / Organizations
• 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

Responsibilities:

• Involved extensively in Blueprinting planning & scheduling, conducted workshops, process flow graphs, landscape presentations, functional specs including high level technical flows in some cases including pseudo codes for critical objects.
• Responsible for master data support and ongoing changes/enhancement
• Was responsible for Master Data Conversion - Site, Vendor, Customer, Merchandise Hierarchy, Merchandise Categories, Article Master, Source List, Purchasing Info Records.
• Had a good understanding of the Client’ Business Process, studied and analyzed their work flow to design solutions while preparing Business Blue Print and Requirement Documents
• 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
• Loaded General, Company Code and Purchasing Data to Vendor Master Data and General, Company Code and Sales Area Data to Customer Master Data with its various partner functions from the legacy system to SAP using LSMW using Batch Input Recording Method and Standard Batch Input performed unit test, regression test and integration test
• Configured the Site Profile to the client’s requirement using Account Groups from Vendor and Customer Master Data, created Reference Site and assigned these reference sites to Site Profiles
• Using Legacy System Migration Workbench loaded Site Master Data from the legacy system into SAP. Also loaded Site Data into Customer master and Vendor Master
• 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, reference 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
• Experienced in trouble shooting failed IDocs with various error messages like ‘V2/001:Enter a reference’, ‘VP/199:No customer master record exists for sold-to party’, ‘VL/187:Delivery is already confirmed’, ‘WP/655:Transfer Order is not available for the SO and delivery ’ - analyzed and fixed the errors in the respective IDoc level or at document level
• 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 Reference Sites for DC Site and Site using the new site profiles
• Assigned the created Reference 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

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
• Involved in taking requirements from Business Process Owners, Blue Print of the Business Process, Mapping of Business Process to SAP through Configuration and Customization
• Mapped Organization Structures, Article Hierarchy Levels and Merchandise Category Hierarchy Levels
• Responsible for detailed mapping of all functional work around Single Articles, Generic Articles and Variants (using single-level BOM’S variant configuration), Display Articles, Labels across multiple sites, Site Groups, Merchandise Categories, Characteristics & Characteristics Profiles, Article Hierarchies including linked Articles, Assortments and Listings
• Liaison with Technical team and business process teams for the preparation and successful running of LSMW, using I-Docs, BAPIs and Custom Programs
• Upload data using appropriate load program and load file corrections, the relevant data objects to appropriate client systems as required
• Prepare test scripts, recording results and complete test cycles as assigned
• Worked on the Price mark downs for the Shanghai Region, Well versed with the Article creation exclusively for Shaghai articles.
• 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

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
• Involved in taking requirements from Business Process Owners, Blue Print of the Business Process, Mapping of Business Process to SAP
• 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.
• Worked on several queries for user reports and data extraction
• Worked together with SAP BI team for data extraction, testing for various cycles, data cubes and modeling.