On-Shelf Availability (OSA) Automation
Duration: April 2023 – August 2024
- Automated Excel file generation for OSA initiatives using Python, SQL, Pandas, and Azure Function Apps, streamlining the process of Root Cause Analysis (RCA).
- Enabled accurate business loss forecasting and potential risk identification through integrated data analytics and automation.
- Improved supply chain efficiency by ensuring precise RCA calculations, facilitating robust decision-making and risk mitigation.
- Technologies Used: Python, Pandas, SQL, Azure Data Factory, Function Apps, Power BI, Advanced Excel.
MOC E2E Transformation
Duration: October 2022 – April 2023
- Developed a unified platform for 71 countries, enabling employees to submit requests and communicate effectively with HR Shared Services (HRSS).
- Enhanced HRSS responsiveness and resolution by streamlining employee queries and requirements through the platform.
- Focused on improving global HRSS communication efficiency and employee satisfaction.
PCODE Automation
Duration: January 2023 – April 2023
- Designed and deployed a dashboard to replace manual Excel-based workflows, automating the approval process for integrating new products into the company's offerings.
- Facilitated easy updates to product attributes (e.g., name, price, weight, category) while maintaining data integrity through an approval-based workflow.
- Significantly enhanced operational efficiency by digitizing and streamlining product modification processes.
Auto TECO
Duration: May 2022 – September 2022
- Automated maintenance processes, including job ticket management, labor confirmation, and maintenance order completion, reducing manpower and paperwork.
- Ensured compliance with record retention policies by storing task records directly in SAP through integration with RPA, Power Apps, SharePoint, and Power Automate.
- Streamlined maintenance workflows to enhance operational efficiency and minimize manual intervention.
Key Technologies and Tools:
Python, SQL, Pandas, Azure Function Apps, Azure Data Factory, Power BI, SAP, RPA, Power Apps, SharePoint, Power Automate, Advanced Excel.