$20

Hourly Consulting Rate

Lloyd DMello

Independent Consultant

Industry Experience

Apparel/Fashion

Food/Beverages

Retail Industry

Location Supported

Worldwide

France

Germany

Italy

United Arab Emirates

United Kingdom

Languages Supported

English

Hindi

Kannada

Skills

  • Functional consultant
  • Analytics
  • ERP

Product Specialization

  • SAP S/4HANA
  • SAP ECC

About

9.2 years of work experience in SAP CAR POSDTA / POSDM with expertise in integration, release, interfacing, reporting, testing, support, training and resolution . Have worked on 2 end to end implementation projects and 1 support project in SAP CAR and SAP CAR . Currently involved in 2 SAP CAR implementation projects in my current organisation. Expertise in SAP CAR POSDTA functionality, UDF/DDF modules and reconciling the POS , SAP CAR and Subledger for any variance and also media reconciliation. Experience in integration using BAPI and Idoc to SAP CAR . Experience in SAP S/4 HANA integration .

Top Project Highlights

Marks & Spencer

  1. Experience on POSDM Integration with Legacy system and POS
  2. Experience on POSDM Integration with other SAP systems like SAP PI , SAP ECC & SAP BI
  3. This client has its own M&S outlets worldwide, UK Franchise stores , Hospitality(Child Store) stores, Ireland stores , France stores for GM and Food products
  4. Have been part of R2 & R3 release in this project
  5. Interfacing for M&S non stock items to create direct sales orders in SAP Order placed via Internet, Telesales, In Store. Any updation for order also gets captured based on design.
  6. POS Sales/Returns & Payments/Refunds
  7. Reporting master data issues found in POSDM due to missing or incorrect maintenance of articles and sites
  8. POSDM configuration issues
  9. Data consistency issues (for example, store sending transactions where the payments value does not equal the sales value, duplicate transaction postings).
  10. Data completeness issues (for example, transaction sequence number gaps, imbalance of total value of sales and payments against end of day data provided by the POS).
  11. Manually processing & scheduling PDIS,ODIS,TSCH job from POSDM to downstream system
  12. Processing any failure or unprocessed idocs & transactions from POSDM to SAP
  13. Identifying any issues related to incoming data from non-SAP & SAP systems (Eg: Mapping issues, incorrect data etc.)
  14. Reconciling the data received from source to POSDM for specific payment types and sales postings.
  15. Experience in analysing failed idocs in SAP ECC.

Philips

This client has many business sectors like Lighting, Consumer Lifestyle, Health Care, and Corporate Functions/Corporate Technologies and every sector has many services.

Worked as an AMS support resource in Wave 2 phase for the client.

The lighting BW service includes functional areas like Marketing and Sales, Finance and Accounting, Supplier Relationship Management, Advanced Planning Optimization.

Worked in mainly lighting business sector for the Client in Marketing & Sales service.

Experience in testing and cutover activities.

Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains for Asia Pacific, Europe & US regions for the client.

Involved in escalating prioritized tickets regarding extractions, performance issues and also loads failures

  1. Involved in solving Customer Issues with in SLAs & Developing the SLA reports at the end of every month.
  2. Involved in submitting the Ticket Status (Open/Close) Process Compliance report.
  3. Involved in the Activities Monitoring, Error Handling, Reconciliation and Production support activities like Ticket Analysis Report, Resource Utilization Report, Time sheet maintenance of the support team.
  4. Maintain Work History for all the tickets until it is closed down.
  5. Involved in validating data consistency in reporting with Data Target against PSA after loading them to data targets.
  6. Monitoring of Info packages and analysing the reasons for frequent failures of Info packages and fixing it.
  7. Maintaining the queue - related to the system generated tickets and customer generated tickets
  8. Maintaining the logs for each manual load. & maintaining the status report for regular automated loads.
  9. Sending critical chain status, daily system health check status.
  10. Involved in submitting BIA Detailed Analysis Report and Storage Reduction Reports for the Info cubes involved.
  11. Involved in housekeeping activities.
  12. Worked on pre and post checks as a part of support pack upgrade and system refresh activities.
  13. Worked on SAP BI components like Infocube, DSO, Data Source, Transformations, Error Stack and Data Transfer Process.
  14. Experience in Modeling, Extraction and Reporting in BI.
  15. Performed LO Cockpit and Generic Data Extractions.
  16. Worked with BEx Query Designer , BEx Analyzer .
  17. Worked on performance tuning includes Compression, Aggregates and Partitioning.
  18. Solving tickets regarding extractions and load failures.
  19. Worked on rescheduling , creating of copy jobs for critical and non critical chains during system outage / upgrade activities.
  20. Analysing and debugging the ABAP code including Start Routine,Field Routine & End Routine.
  21. Worked with BEx Analyzer to generate Queries and Broadcasting to users.
  22. Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Formulas, Exceptions, Conditions and Variables.
  23. Worked on Attribute Change Run if any failures occurred.
  24. Worked on Information Life Cycle Management including Data Archiving Process.
  25. Installation of Business Content.
  26. Version comparison of BI objects in Production system with development, quality and validation systems

Gulf Marketing Group

  • This client has many business divisions like sports and fitness, health, lifestyle, healthcare, food processing and logistics.
  • Experience in SAP POSDM Integration with 3rd party POS (Retail Pro) and SAP PI/PO using Idoc BAPI and also with SAP BI and SAP ERP system.
  • Experience in preparing the Blueprint document with all the functionalities based on the requirements.
  • Experience in performing SAP POSDM configuration and design according to Blueprint document.
  • Experience in integrating SAP POSDM with SAP PO using Idoc BAPI and RFC BAPI.
  • Experience in SAP POSDM testing using SAP provided standard BAPI’s such as Idoc BAPI , RFC BAPI , RFC test BAPI.
  • Experience in creating test transactions in POSDM workbench using Idoc testing tool.
  • Experience in creating transactions in POSDM workbench and also edit the transaction segments and data.
  • Experience in creating test transactions using RFC and test BAPI’s in POSDM.
  • Experience in modifying the error inbound idoc data before getting posted to POSDM Inbound Queue / POSDM TLOGS.
  • Experience in validating both inbound and outbound idoc data in POSDM.
  • Experience in analysing the defect idocs from SAP and to trace back to POSDM.
  • Experience in reversing the transactions and aggregates in POSDM.
  • Experience in deleting the transaction data , idoc data and aggregated data from POSDM.
  • Experience in Infocube selective deletion in SAP BW.
  • Experience in reconciliating the SAP report data with POSDM and SAP BW report data.
  • Experience in scheduling daily jobs like QDIS,PDIS,ODIS,TSCH to automate the SAP POSDM system.
  • Experience to schedule daily POSDM error report and rectify the error messages in POSDM.
  • Hands on experience to validate both synchronous and asynchronous data from 3rd Party POS through various standard BAPI’s.
  • Experience in both 1-step processing and 2-step processing.
  • Experience in performing aggregation and dispatching Idocs to SAP system.
  • Experience in preparing functional specification document based on source idoc segment structure and fields.
  • Experience in inbound and outbound partner profile customization for logical system and store.
  • Experience in scheduling LSMW job to create partner profiles for multiple stores.
  • Experience in validating the Idoc data received from source system with POSDM
  • transaction data.
  • Creating rules to stop the processing of duplicate transactions in POSDM.
  • Reconciliation of article document and billing document in SAP system with SAP POSDM sales idocs.
  • Experience in performing listing for the error articles and sites in SAP system. 28- Experience in assigning merchandise category for the sites.
  • Experience in processing the SAP  idocs.
  • Experience to validate the POSDM sales and payment report using BEx report and analyser.
  • Experience to extract transaction data and master data in SAP BW from SAP POSDM datasources and also from SAP system respectively.
  • Experience to provide the POSDM requirements to develop BW reports related to POSDM.

S Group

  1. Knowledge in Procurement process and organizational   levels.
  2. Experience in identifying, resolving issues and carrying out testing related to various Purchase order and returns, Sales Order, Material master, Invoice and billing document types.
  3. Experience in Flow through Advance, Flow through Replenishment, Direct Deliveries, Terminal processes.
  4. Experience in Assortment and Listing.
  5. Carrying out stock reconciliation for the articles and performing manual movements.
  6. Rejecting sales orders.
  7. Experience in Picking process and Delivery creation.
  8. Experience in Invoice workflow monitoring.
  9. Posting Goods Receipt for the Purchase Order articles.
  10. Inbound and Outbound Idoc monitoring (Delivery, Picking, Handling Unit) and correcting error idocs.
  11. File Interface monitoring and rectifying issues with the files to various partners.
  12. Experience in carrying out manual testing using SAP ALM testing tool.
  13. Experience in Charm process.
  14. Knowledge on SAP  CAR

Virginia Alcoholic Beverage Control Authority

  • Virginia ABC offers a wide selection of merchandise—including mixers, vermouth and Virginia-made wines in addition to liquor—with more than 2,800 items available in the product catalog with more than 370 stores.
  • Good level of understanding on POS transactions inbound to SAP CAR POSDTA – Sales , Financials , Inventory , Tender , End Of Day Totals .
  • Experience in SAP CAR Integration with POS using POSLog file upload and also with Online Payment, SAP Fiori and SAP ERP system.
  • Experience in preparing the Functional Specifications document with all the functionalities based on the requirements.
  • Experience in performing SAP CAR POSDTA configuration and design according to Functional Specification document.
  • Experience in SAP CAR POSDTA testing using SAP provided standard BAPI’s such as Idoc BAPI , RFC BAPI , RFC test BAPI.
  • Experience in creating different business transactions in POS  workbench using XML file upload and RFC BAPI.
  • Experience in creating different business transactions in POS workbench and also edit the transaction segments and data for testing purpose.
  • Experience in validating both inbound and outbound idoc data in SAP CAR.
  • Experience in analyzing the defect idocs from SAP and to trace back to SAP CAR.
  • Experience in reversing the transactions , aggregates and idocs in SAP CAR POSDTA.
  • Experience in deleting the transaction data , idoc data and aggregated data from SAP CAR POSDTA.
  • Experience in performing Bank credit card reconciliation, media reconciliation, Store credit card & cash reconciliation
  • Experience in scheduling daily jobs like QDIS,PDIS,ODIS,TSCH to automate the SAP CAR POSDTA system.
  • Experience to schedule daily POSDM error report and rectify the error messages in POSDM.
  • Experience in both 1-step processing and 2-step processing.
  • Experience in performing aggregation and dispatching Idocs to SAP ERP system.
  • Experience in inbound and outbound partner profile customization for logical system and store.
  • Experience in processing the Inbound and Outbound idocs.
  • Knowledge on SLT Replication from S4HANA/SAP ECC to SAP CAR.
  • Knowledge on enabling DDF and UDF functionality in SAP CAR for forecasting

Ingles Markets, Inc.

1-      Is a American Regional Supermarket chain .It operates 197 Supermarkets in Southeastern United States. Ingles also owns and operates shopping centers, gas stations and a milk processing plant.

2-      SAP CAR POSDTA Configurations and its integration with SAP PI, SAP S/4HANA

Employment

Associate

2011 - 2015
    • Scheduling POS Inbound Dispatcher
    • POS Inbound Queue Monitoring and processing
    • Scheduling POS Inbound Processing Engine(PIPE)
    • Scheduling POS Outbound Dispatcher(ODIS)
    • SAP POSDM TLOGS
    • IDOC check and monitoring
    • Manual processing of error and unprocessed sales and payment Idocs from POSDM to downstream systems
    • Manual processing of error & unprocessed sales data from POSDM to downstream systems
    • Validating incoming data from Non-SAP(POS ,Data hub) and SAP systems(PI)
    • Root Cause identification of received xml data in POSDM from source system.
    • Testing scenarios related to mapping
    • Exporting and importing of xml data for testing purpose
    • SAP POSDM configurations for Profile Types in SAP POSDM
    • Manual correction of received error UPC transaction with department code
    • Master data issues related to sales & stock affected interfaces
    • Correcting error data in POSDM corresponding to master data
    • Partner Profile store creation based on model store identification in POSDM
    • Maintaining master data in BW for a store which does not have partner profile
    • General Ledger check in SAP for different accounts
    • Reconciliation in POSDM with SAP and non-SAP systems for sales and payment data
    • Returns/Payments/Discounts/Tax amount validation
    • Index Refresh in POSDM
    • Task Status Change in POSDM
    • POSDM Aggregate Table Check
    • Job performance check in POSDM related to data processing , aggregated data and Idoc creation
    • Data Integrity Report reconciliation for the batches received in POSDM from source
    • POSDM standard daily Exception Report
    • Reporting error UPC’s received in POSDM to Master Data

App. Software Dev. Senior Consultant

2015 - 2016
    1. Experience in SAP POSDM Integration with 3rd party POS (Retail Pro) and SAP PI/PO using Idoc BAPI and also with SAP BI and SAP ERP system.
    2. Experience in preparing the Blueprint document with all the functionalities based on the requirements.
    3. Experience in performing SAP POSDM configuration and design according to Blueprint document.
    4. Experience in integrating SAP POSDM with SAP PO using Idoc BAPI and RFC BAPI.
    5. Experience in SAP POSDM testing using SAP provided standard BAPI’s such as Idoc BAPI , RFC BAPI , RFC test BAPI.
    6. Experience in creating test transactions in POSDM workbench using Idoc testing tool.
    7. Experience in creating transactions in POSDM workbench and also edit the transaction segments and data.
    8. Experience in creating test transactions using RFC and test BAPI’s in POSDM.
    9. Experience in modifying the error inbound idoc data before getting posted to POSDM Inbound Queue / POSDM TLOGS.
    10. Experience in validating both inbound and outbound idoc data in POSDM.
    11. Experience in analysing the defect idocs from SAP and to trace back to POSDM.
    12. Experience in reversing the transactions and aggregates in POSDM.
    13. Experience in deleting the transaction data , idoc data and aggregated data from POSDM.
    14. Experience in Infocube selective deletion in SAP BW.
    15. Experience in reconciliating the SAP report data with POSDM and SAP BW report data.
    16. Experience in scheduling daily jobs like QDIS,PDIS,ODIS,TSCH to automate the SAP POSDM system.
    17. Experience to schedule daily POSDM error report and rectify the error messages in POSDM.
    18. Hands on experience to validate both synchronous and asynchronous data from 3rd Party POS through various standard BAPI’s.
    19. Experience in both 1-step processing and 2-step processing.
    20. Experience in performing aggregation and dispatching Idocs to SAP system.
    21. Experience in preparing functional specification document based on source idoc segment structure and fields.
    22. Experience in inbound and outbound partner profile customization for logical system and store.
    23. Experience in scheduling LSMW job to create partner profiles for multiple stores.
    24. Experience in validating the Idoc data received from source system with POSDM
    25. transaction data.
    26. Creating rules to stop the processing of duplicate transactions in POSDM.
    27. Reconciliation of article document and billing document in SAP system with SAP POSDM sales idocs.
    28. Experience in performing listing for the error articles and sites in SAP system. 28- Experience in assigning merchandise category for the sites.
    29. Experience in processing the SAP  idocs.
    30. Experience to validate the POSDM sales and payment report using BEx report and analyser.
    31. Experience to extract transaction data and master data in SAP BW from SAP POSDM datasources and also from SAP system respectively.
    32. Experience to provide the POSDM requirements to develop BW reports related to POSDM.

Functional Consultant

2016 - 2019
    1. Knowledge in Procurement process and organizational   levels.
    2. Experience in identifying, resolving issues and carrying out testing related to various Purchase order and returns, Sales Order, Material master, Invoice and billing document types.
    3. Experience in Flow through Advance, Flow through Replenishment, Direct Deliveries, Terminal processes.
    4. Experience in Assortment and Listing.
    5. Carrying out stock reconciliation for the articles and performing manual movements.
    6. Rejecting sales orders.
    7. Experience in Picking process and Delivery creation.
    8. Experience in Invoice workflow monitoring.
    9. Posting Goods Receipt for the Purchase Order articles.
    10. Inbound and Outbound Idoc monitoring (Delivery, Picking, Handling Unit) and correcting error idocs.
    11. File Interface monitoring and rectifying issues with the files to various partners.
    12. Experience in carrying out manual testing using SAP ALM testing tool.
    13. Experience in Charm process.
    14. Knowledge on SAP  CAR

Consultant

2019 - Present
    • Good level of understanding on POS transactions inbound to SAP CAR POSDTA – Sales , Financials , Inventory , Tender , End Of Day Totals .
    • Experience in SAP CAR Integration with POS using POSLog file upload and also with Online Payment, SAP Fiori and SAP ERP system.
    • Experience in preparing the Functional Specifications document with all the functionalities based on the requirements.
    • Experience in performing SAP CAR POSDTA configuration and design according to Functional Specification document.
    • Experience in SAP CAR POSDTA testing using SAP provided standard BAPI’s such as Idoc BAPI , RFC BAPI , RFC test BAPI.
    • Experience in creating different business transactions in POS  workbench using XML file upload and RFC BAPI.
    • Experience in creating different business transactions in POS workbench and also edit the transaction segments and data for testing purpose.
    • Experience in validating both inbound and outbound idoc data in SAP CAR.
    • Experience in analyzing the defect idocs from SAP and to trace back to SAP CAR.
    • Experience in reversing the transactions , aggregates and idocs in SAP CAR POSDTA.
    • Experience in deleting the transaction data , idoc data and aggregated data from SAP CAR POSDTA.
    • Experience in performing Bank credit card reconciliation, media reconciliation, Store credit card & cash reconciliation
    • Experience in scheduling daily jobs like QDIS,PDIS,ODIS,TSCH to automate the SAP CAR POSDTA system.
    • Experience to schedule daily POSDM error report and rectify the error messages in POSDM.
    • Experience in both 1-step processing and 2-step processing.
    • Experience in performing aggregation and dispatching Idocs to SAP ERP system.
    • Experience in inbound and outbound partner profile customization for logical system and store.
    • Experience in processing the Inbound and Outbound idocs.
    • Use of Webservice API's for integrating 3rd Party POS.
    • Knowledge on SLT Replication from S4HANA/SAP ECC to SAP CAR.
    • Knowledge on enabling DDF and UDF functionality in SAP CAR for forecasting
    • SAP OSS ticketing tool and handling JIRA tickets.
    • Experience in resolving AMS Support issues and perform new Store rollouts

Education

B.E (Information Science & Engineering)
2006-2010

Bachelor’s Degree in Information Science and Engineering in 2010

Certification

ITIL® Foundation Certificate in IT Service Management
2018-Present

ITIL® Foundation Certificate in IT Service Management

Certificate Number : GR750385558LD

Candidate Number : 9980005235099050

Ooops!

Maximum of Three products are allowed for comparision