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.

Device Lifecycle Management System

Business Analyst and Project Analyst,Lead Developer & Solution Architect

DXC Technology

Description

The Device Lifecycle Management System tracked the lifecycle of 750,000+ devices from inventory to shipment and disposal. PowerApps enabled real-time data input from warehouse workers and engineers, while Power BI dashboards provided insights into inventory, repairs, and shipments. Power Automate handled workflow automation, reducing manual processing.

Scope

Managed the lifecycle of 750,000+ devices, improving process efficiency by 50%.

Responsibilities

  1. Developed PowerApps to enable real-time data entry for 750,000+ devices, reducing manual data entry errors by 25% and improving data accuracy by 30%.

  2. Led the automation of workflows for managing device shipments, repairs, and disposals using Power Automate, increasing process efficiency by 50% and reducing approval processing times by 40%.

  3. Created and maintained Power BI dashboards to track key device lifecycle metrics such as inventory levels, repair statuses, and shipment timelines, providing senior management with real-time insights and reducing reporting times by 30%.

  4. Integrated SQL databases to securely store and manage device lifecycle data, ensuring seamless data flow between PowerApps and Power BI dashboards, improving data retrieval speed by 20%.

  5. Led a team of 5 engineers, overseeing the end-to-end project delivery, managing timelines, and mitigating risks to ensure all project milestones were achieved on schedule.

  6. Conducted comprehensive business analysis, gathering requirements from cross-functional teams including warehouse operations, engineering, and logistics. Mapped over 15+ business processes to align the system with operational needs, resulting in a 35% reduction in process inefficiencies.

  7. Performed data analysis using Power BI to identify bottlenecks in device processing times, enabling the logistics team to make data-driven decisions, improving shipment turnaround times by 25%.

  8. Collaborated with senior management and stakeholders to ensure the system met business requirements and provided accurate, actionable insights, leading to a 20% improvement in decision-making efficiency.

Technologies

  1. Microsoft Power Automate
  2. Microsoft PowerBI
  3. SQL
  4. Microsoft Power Apps
  5. Microsoft Dataverse

Images

    No images available

Resources, Documents and More

    No resources available