Development: .NET Web API Cost Analysis App with Angular

Project Overview

Keyhole Consultants worked with a team of client business managers and developers to develop an internal client application that focused on bi-reporting, cost analysis, and price forecasting for connecting wind, solar, and fossil fuel projects to the United States power grid.

The goal of the project was to take data that was strewn around the company and create one system of record that the company could use to forecast if current and future projects were going to be profitable. This custom application synchronized 150 employees across five different departments.

Technology Overview

The applications utilized Angular to interface with .NET backend that integrated with Azure Active Directory and Sharepoint. Most consultants worked with MSSQL Server database, NET 4.5 backend, and Angular to develop the single-page application.

Consulting Areas Of Note

Keyhole Consultants created and maintained an ASP.NET Web API application, including system design and stored procedures for the SQL Server database. They were responsible for setting up a CI/CD system with Bitbucket, Jenkins, and Octopus Deploy. Azure Active Directory was integrated into the entire architecture.

On the back-end, Consultants worked with a team of developers to focus on cleaning and migrating away from a stored procedure-based data access layer. They chose to move toward a modern implementation of an object-relational mapping framework using Entity Framework.

Consultants created a unit test coverage framework with the goal of having 100% of the applications API tested. These tests were driven in part by utilizing business rules written using Cucumber and implemented with the Nunit test framework.

Consultants worked on the Angular framework and added additional functionality throughout a multitude of pages. The application supported ECMAScript 6 syntax and was highly modular in design.

Key Consulting Contributions

Developed and maintained an ASP.NET Web API, including system design and stored procedures.
Set up a CI/CD system with Bitbucket, Jenkins, and Octopus Deploy for efficient deployment pipelines.
Integrated Azure Active Directory for secure user management.
Migrated data access from stored procedures to Entity Framework for scalability.
Established a unit test coverage framework, ensuring 100% API test coverage using Cucumber and NUnit.
Enhanced the AngularJS front-end, adding features across multiple pages to improve user experience.

Project Results

The new system streamlined data analysis, improved reporting accuracy, and enabled the client to make more informed decisions about the profitability of energy projects. The solution was deployed successfully with full testing and seamless integration.

The consultants’ contracts on this project were extended multiple times due to their exceptional contributions and consistent high-quality work. This ongoing success led the company to continue collaborating with Keyhole Software on additional initiatives, further proving the lasting value and impact of Keyhole’s expertise.