Cameron Shields

© 2024 Cameron Shields. All rights reserved.

About this website: built with React & Next.js (App Router & Server Actions), TypeScript, Tailwind CSS, Framer Motion. With Vercel Hosting.

Power BI Reporting and Power Platform Development

Project Lead and Business Analyst

DXC Technology

Description

Enhanced visibility into inventory, shipment, repair, and disposal operations through development of real-time Power BI reports and implementing a custom PowerApp to capture and feed data into a SQL database. The project improved operational efficiency, streamline data entry, and provided key stakeholders with data-driven insights.

Scope

750,000+ Devices, Multiple Warehouse Locations, 6-7 Public and Private Sector Organisations | Internal Stakeholder and External Public Sector Stakeholders.

Responsibilities

  1. 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.

  2. 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.

  3. ETL & Data Integration: Designed an ETL process to automate data flow from the SQL database into Power BI, ensuring real-time, accurate reporting.

  4. Power BI Reporting: Created 10+ Power BI reports for inventory management, shipment tracking, and repair/disposal monitoring, providing stakeholders with actionable insights.

  5. 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.

  6. 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.

Technologies

  1. Microsoft Planner
  2. Microsoft PowerPoint
  3. Microsoft Visio
  4. LucidChart
  5. Microsoft Power Automate
  6. Microsoft Power Apps
  7. Microsoft PowerBI

Images

    No images available

Resources, Documents and More

    No resources available