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.

Absence Management Automation

Lead Developer & Project Manager

J.&J. Denholm Group

Description

This project aimed to streamline the absence management process by developing a PowerApp that allowed employees to submit leave requests, and managers to approve them in real time. The app integrated with SQL and Dataverse for real-time data management, while Power Automate automated the approval workflows, ensuring faster response times. Power BI dashboards provided HR teams with actionable insights into employee leave balances, trends, and resource planning, improving overall HR efficiency.

Scope

Organisation-wide, serving over 1,000 employees, reducing HR workload by 40%.

Responsibilities

  1. Business Analysis: Worked with HR teams across 5 departments to map out existing processes and define key requirements, identifying bottlenecks and reducing manual HR tasks by 40%.

  2. Process Mapping: Documented over 10 key processes for holiday approvals and absence tracking, leading to optimized workflow automation.

  3. Power Platform Development: Built the PowerApp for leave request submissions and manager approvals, integrated with SQL and Dataverse for real-time data management, and automated workflows with Power Automate, improving leave approval response times by 30%.

  4. Power BI Reporting: Developed 2 real-time dashboards to track leave balances, approval statuses, and absentee trends, providing HR leaders with key insights for resource planning and decision-making.

  5. Project Management: Led a cross-functional team of 5 in designing, testing, and deploying the solution within established timelines, while ensuring alignment with HR policies.

  6. Documentation & Training: Created user manuals and delivered 3 training sessions for HR staff and managers, resulting in 100% adoption of the system across departments.

Technologies

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

Images

    No images available

Resources, Documents and More

    No resources available