Process Mapping & Requirements Gathering: Led the mapping of 50+ business processes and gathered 100+ user stories from warehouse workers, Break/Fix engineers, and stakeholders. Identified key requirements for PowerApps and Power BI, aligning them with operational needs.
PowerApp Development: Built 5+ PowerApps to enable real-time data entry into a SQL database, streamlining updates on 750,000+ devices related to stock, shipment, repair, and disposal. Reducing manual errors and providing almost 100% accuracy on data.
ETL & Data Integration: Designed an ETL process to automate data flow from the SQL database into Power BI, ensuring real-time, accurate reporting.
Power BI Reporting: Created 10+ Power BI reports for inventory management, shipment tracking, and repair/disposal monitoring, providing stakeholders with actionable insights.
Power Automate Flows: Created 20+ flows for Power Automate for managing the approval processes of devices through repair and shipment. Reducing time to shipment by 70%, and reducing missed information by 100%. By centralising the approval process and information passing to on ground workers. Working with Stakeholders and the Business to gather requirements.
Innovation & Change Management: Introduced automation and real-time data capture, replacing manual processes, improving accuracy, and reducing errors. Drove user adoption through training and stakeholder engagement.