Paperless workflow created to optimize HR Operations with Power Apps

See how we helped a large electric services provider improve efficiency, user experience, and auditability by replacing Excel and PDF forms with Power Apps integrated with an existing Human Resource Application.

Paperless workflow created to optimize HR Operations with Power Apps

See how we helped a large electric services provider improve efficiency, user experience, and auditability by replacing Excel and PDF forms with Power Apps integrated with an existing Human Resource Application.

Keeping the #FocusOnInsights to predict problems in a time-sensitive industry

Reliable electric service has always remained in high demand. With power consumption constantly increasing, experienced and skilled electrical contracting companies are the need of the hour. Like many contemporary industries, the electric service sector relies on technology-driven solutions to meet the rising demand. The client is a leading electric service provider who has been in the industry for decades, providing high-quality electric energy and related services to users. They partnered with Korcomptenz to replace the existing manual process with an automated solution using Power Apps. This enabled the client to achieve timely project completion, positive user experience, and ease of use.

About the Client

The customer is a large electric services provider in the United States. They support installing electrical systems in commercial and mixed-use buildings. Founded in 1946, the company has made its mark in the construction industry by providing the highest quality electrical contracting services for projects of all sizes. Today, the organization has more than 2,900 employees, operating coast-to-coast.

The client holds a successful track record of constructing world-class commercial, biotech, healthcare, educational, entertainment, government, hospitality, industrial, renewable energy, and retail facilities across the country.

Challenge

The company had been using paper or binary file forms to process common human resources requests for staff in their field such as cell-phone and vehicle allowance and pay raises. All human resources data was stored in an existing Oracle HR implementation, but few associates had direct access to the system. Field employees would complete paper or PDF forms for common requests and email them to the appropriate supervisor for approval. The supervisor would then continue the email chain to Human Resources for ultimate entry into Oracle.

The process had no tracking or notifications, and a lot of potential for manual error. For example, the field employee submitting the form might not have the latest salary or benefit information. If they listed that information incorrectly, the supervisor could approve an inaccurate request and the error would only be identified when the human resources department entered the data into Oracle. In many cases, the process would then need to restart again.

Paper or binary forms were received via email and processed manually with no approval chains.

Forms were hard to maintain and didn’t automatically contain the correct employee information.

Human resources or other team members needed to validate and process the data manually, including routing for approval.

No audit trails or reporting to display current status and disposition of requests.

Solution

Korcomptenz was selected as the partner of choice to replace the paper and binary file form process with an automated solution using Microsoft Power Apps. We collaborated with the customer to identify their short- and long-term needs for their usage of Power Apps. This included an analysis of the current forms, future forms, workflow, reporting needs, and integration with Oracle Human Resources Software.

The project began with a discovery phase to finalize the process, user types and approval chains, and identify the best means to integrate Power App data with Oracle. The goal was to ensure the forms were easy to complete, were automatically routed based on the corporate org chart, and presented the correct data for each employee. In addition, special attention was paid to ensuring the data ultimately entered back into Oracle was well-formed and followed the appropriate business rules. Ultimately, the project included:

  • Deployment and configuration of Power Apps.
  • Audit trails and reporting for all transactions in the system with status and disposition prominently displayed.
  • Implementation of Power Apps Canvas Design Model to support a custom interface.
  • Custom workflows to approve requests based on region and seniority in the organization.
  • Development of applicable Human Resources forms.
  • Bi-directional integration with Oracle Human Resources software to display relevant employee information and integrate outputs.

Results

The project was completed in an agile manner focused on two primary forms while ensuring the architecture supported additional functionality in the future. Korcomptenz collaborated with key stakeholders throughout the company to ensure a positive user experience, ease of use, data integrity, and scalability.

Connect with us at [email protected] to know more. The completed project delivered the following real-world benefits to the customer.

Forms and integrated workflow improved the speed and accuracy to process common Human Resources requests.

Forms were maintained centrally, eliminating the need to distribute updates, and constant communication with the field.

Data was automatically integrated with Oracle Human Resources, increasing accuracy, and reducing the need for manual work.

Complete audit trail and reporting on every request and the disposition of every request.

Achieve paperless workflow with Power Apps using Tech-driven solutions

Our experience in Dynamics 365 and Power Apps will enable you to provide the highest quality services for projects of all types and sizes. Find out more about how we use our expertise as a Microsoft Gold Certified Partner to #FocusOnYou. Visit www.korcomptenz.com/services or mail us at [email protected] to learn more.

Tell us how we can #FocusOnYou