Sky Solutions

Transforming Intranet Efficiency: One Unified Portal at a Time

Right Arrow IconBack to Success Stories

Overview

A large metropolitan utility provider required a suite of intranet portals to manage internal service requests across multiple departments, including Human Resources, Finance, Electric Operations, Gas Operations, and Storm Response. These portals support workflows such as work orders, refunds, transfer corrections, vehicle home requests, and vacation approvals, simplifying request submission and managerial review. Built to handle high transaction volumes, the applications streamline eligibility determinations and service authorizations while providing real-time visibility into compliance and service delivery.

Goal

The project focused on modernizing intranet portals across multiple departments, delivering a robust solution that enhances the user experience. A custom Angular framework was developed to streamline the approval process and enable seamless script embedding. Azure APIs were integrated to provide secure authentication, while a SharePoint Online site enabled remote access without compromising functionality. The goal was to deliver responsive websites rapidly, backed by thoughtful design and reliable user support.

Challenge

During the modernization of multiple intranet portals using the new framework, the team encountered several complexities, especially while migrating from the legacy platform to the new environment. The effort required not only data migration but also the transfer of associated attachments. To address this, the team developed multiple C# console applications to read .xsn files from the legacy system, extract the data into Excel, and load it into the target database. This approach added technical complexity and required close collaboration, iterative testing, and validation to ensure accurate and efficient data flow across systems. Despite these challenges, the team remained focused on delivering a robust solution that improved overall service delivery.

Solution

Sky Solutions developed a solution that:

  • Utilized the Angular framework to build dynamic, responsive websites that adapt seamlessly to user interactions.
  • Leveraged the .NET Framework for powerful back-end services, boosting website performance and scalability.
  • Incorporated HTML and Bootstrap to create a modern, intuitive front-end design that enhances user experience.
  • Employed SQL and Oracle EBS for efficient database management and streamlined data storage.
  • Implemented web services to enable seamless communication across different components of the application.
  • Provided ongoing support and maintenance, ensuring smooth website operation and swift resolution of any issues.
  • Developed custom case types based on data complexity and volume, optimizing workflows and process efficiency.
  • Generated detailed reports covering usage statistics and operational insights for better decision-making.
  • Migrated content and attachments from legacy systems to modern web applications, improving accessibility and usability.
  • Integrated with tools such as Power Automate and Nintex Workflow to automate processes and increase efficiency.
  • Facilitated data migration from legacy formats, such as Excel, to secure SQL databases for more efficient data management.

Technologies/Methodologies

  • .Net
  • Angular
  • Azure
  • SQL
  • Oracle EBS
  • Power Automate
  • Nintex Workflow

Outcome

Sky Solutions has streamlined the request submission process, approval workflows, and notifications, significantly enhancing user experience. Users can now generate reports effortlessly by applying filters on the webpage, driving greater efficiency and empowering users to make data-driven decisions.