diego bugarin

RMA Report Automation

Optimized Return Merchandise Authorization reporting and follow-up processes for Security Products at Johnson Controls. Developed Python scripts to automate data cleaning and built a Power BI dashboard that integrated Salesforce and SAP data, streamlining the identification of RMAs needing follow-up and credit note issuance. Managed over 200 weekly RMA cases with a total value exceeding $1M USD.

Problem

  • SAP was recently implemented for managing RMAs in Security Products.
  • Previously, Excel was used to generate the RMA report, taking up to 2 hours due to its complexity.
  • RMA reports were created weekly, leading to delays in responding to customer inquiries.
  • Lack of integration between SAP and Salesforce limited visibility into RMA status, delaying responses to customer inquiries.
  • Limited understanding of RMA status and actions in both SAP and Salesforce, creating inefficiencies in follow-up processes.

Solution

  • Collaborated with other business units already using SAP to define the RMA process, aligning actions based on RMA status in both SAP and Salesforce.
  • Automated data cleaning using Python, integrating Salesforce and SAP data into a single report, reducing processing time.
  • Added specific actions to be performed in both Salesforce and SAP, based on the RMA status in the report.
  • Increased reporting frequency from weekly to daily.
  • Developed a Power BI dashboard that streamlined the integration of SAP and Salesforce, reducing manual intervention and enhancing report visibility.
  • Improved RMA follow-up by ensuring timely actions, adhering to defined process deadlines.

View next project

diego bugarin

linkedingithubwhatsappemail