Optimization of network procurement workflows and automated sourcing reporting at Digi Telecommunications

This technical report details an operational and data management study conducted within the Procurement & Logistics department at Digi Telecommunications Sdn Bhd. Specifically attached to the Network and Business Solutions unit, the study focused on optimizing the sourcing workflows for the Operation and Maintenance (O&M) category and automating weekly Purchase Requests/Purchase Orders (PRPO) reporting. For the O&M category, the workflow involved rigorously verifying non-standard items (NSI) requested by stakeholders against official vendor pricebooks and evaluating multiple quotations for price benchmarking. Concurrently, the generation of the PRPO report was overhauled using data extracted from the Coupa database management system. Microsoft Excel was utilized to clean the data, apply logical formulas (such as DATEDIF() and SUMIFS()), and construct Pivot Tables to summarize pending approvals, active contract spending, and direct purchase frequencies. To enhance efficiency, Visual Basic for Applications (VBA) Macros were implemented and dynamically adjusted to automate the generation of these reports. The results demonstrated that the deployment of VBA Macros drastically reduced the report generation time from two hours to under thirty minutes. Ultimately, the integration of data analytics and workflow automation empowers the procurement team to strategically monitor active contracts, prioritize pending requests, and continuously optimize corporate sourcing activities.