Transforming Intranet Efficiency: One Unified Portal at a Time

Left Arrow IconBack to Success Stories

Overview

Con Edison, a utility company in New York, needed intranet portals to manage requests from departments such as HR, Finance, Electric, Gas, and Storm Damage Maintenance. These portals handle work orders, refunds, transfer corrections, vehicle home requests, and vacation requests, simplifying the process for employees to submit requests and obtain manager approvals. Designed to manage high traffic, the applications aim to streamline eligibility determinations and service authorizations while ensuring real-time visibility into compliance and service delivery.

Goal

The project aimed to modernize intranet portals across various departments, resulting in 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 for secure authentication, and a SharePoint Online site was set up to provide remote access without compromising functionality. The goal was to deliver responsive websites quickly, backed by strategic design and dependable user support.

Challenge

During the modernization of all intranet portals using the new framework, we faced several challenges, particularly the migration from the legacy system to the new platform. This process involved not only transferring data but also migrating attachments. We had to develop numerous C# console applications to read the .xsn files (from the old platform), extract the data into Excel, and then upload it to the database. This added complexity to the task of obtaining the necessary information, requiring extensive collaboration and testing to ensure accurate and efficient data flow across the various systems. Despite these challenges, our team remained dedicated to delivering a robust solution that enhanced 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.

Our technologies are designed to seamlessly integrate with your existing systems, minimizing disruption and maximizing productivity.

Follow Us on

Facebook Icon Twitter Icon LinkedIn Icon Youtube Icon

Quick Links

Other Links

Legal

Contact Us

Copyright © 2024 Sky Solutions. All rights reserved.