The Programmers.ai team built a single sign-on web portal for a leading HVAC parts and supplies distributor
About the Client
The client is an industry leading distributor of HVAC equipment parts and heating/air conditioning supplies. They deal in commercial as well as residential parts and supplies. Spread over 40 locations in 8 states (Ohio, Indiana, Kentucky, Illinois, Iowa, Pennsylvania, West Virginia, and Tennessee), the client is the 10th largest HVAC distributor in the U.S. and the largest independent Bryant distributor in North America. This client will be the Midwest preeminent HVAC distributor. Its customers trust and rely on it because of its outstanding customer service, high ethical standards, industry-leading products, and business partnerships. The company was named as the Tri-State Family Business of the Year by the University of Cincinnati Growing Center for Family Business. The client proudly employs over 500 people with over 10,000 cumulative years of HVAC expertise. It is an award winning company, receiving consistent recognition, awards and accolades from its manufacturing partners throughout the years. Programmers.ai has successfully facilitated the client’s adoption of modernized cross-technology solutions while providing the state-of-the-art security solutions.
- Industry: Logistics and Transportation
- Headquartered: U.S.
- Platforms: AS400, COBOL, RPG
- Team Size: 4 Developers
The Challenge
The client was facing a major challenge working on the old AS400 screens and needed to adopt modernized cross-technology solutions with robust security.
The application’s security was the biggest concern for the client as its existing application was based on a legacy system.
The client also wanted a platform that would manage all its users and would have a separate database (PostgreSQL) created by leveraging the existing DB2 tables and RPG code from the AS400 box.
Our Solution
We addressed the challenges by implementing a comprehensive solution:
Modern Web Portal for Invoice Management
Our team designed a portal where a user could sign in and could see all their invoice details present in AS400 DB2. They could also change the date range to view their old invoices.
Enhanced Invoice Management Features
User could choose multiple invoices to download at the same time. User could also search/sort/ filter invoices and open the list of invoices for the selected date range.
Flexible Invoice Generation and Export Options
In the invoice generation application the customer could select the file format (PDF/CSV/QuickBooks) in which he/she needed to download the invoice. They could also open any invoice in PDF format on the browser.
API Integration with AS400 DB2
All the data to generate the invoices resides on As400 DB2. So our APIs communicate with the DB2 to fetch the invoice information and then generate the invoice based on that information.
Technologies Used
Our software architects and engineers are experts in using the latest technologies.
-
HTML
-
CSS
-
SSO portal
-
OAuth 2.0
-
JWT Token
-
JS/Jquery
-
Java Spring MVC
-
RESTful API
Business Impact
The PAI team implemented an innovative solution to modernize legacy systems and enhance operational workflows.
Here’s how we did it
-
Modern Web Portal with Secure User Authentication
Programmers.ai enabled the client to easily manage the users and applications by building a modern web portal. Our team suggested the use of SSO (Single Sign On) for signing in and OAuth 2.0, which ensured the security of the web application.
-
PayPal Integration for Efficient Payment Processing
PayPal integration through our approach decreased the development time to a fraction, hence saving our client a lot of time and money.
-
Centralized Web Catalogue Management
Programmers.ai enabled the client to look at and maintain all their items through the application of a web catalogue in an easy and convenient way. Previously they had to maintain details (in DB2) and images (in image server) separately. Now they can maintain both from a single point.
-
Customer Self-Service for Invoices
Programmers.ai invoice app helped the client’s customers to download their invoice from the application anytime. It has saved the time of both our client’s sales people and their customers.
-
Real-Time Sales Reporting and Analytics
Programmers.ai enabled the client to easily view and generate sales reports using a modern and user-friendly web portal. This helped the client’s management team to see the report anytime and anywhere hassle free.
Other Case Studies
Modernized Employee Management System Reduces Costs and Boosts Scalability for Legacy I...
Programmers.ai automates data collection and updates legacy website for major healthca...
I wanted to take a moment to highlight and commemorate the efforts from our dedicated PIO team. To preface, the projects we work on here are complex, with rigid objectives, budgets, and timelines. Expectations are always high and are ever-changing. From the start of our relationship, the IO team was able to exceed expectations and make our business wishes a reality.
Over the past year I have worked with them, they have worked very hard to understand our highly customized system and troubleshoot things with little or no documentation while managing to keep the business up and running normally. Without the hard work and dedication they have shown, I know we would have had some issues causing downtime or lost production. I am looking forward to continuing working them in the next year as well.
I have been working with Programmers IO for more than 5 years now and I have been pleased with all projects and developers that I have worked with. We have had a few issues here and there but they have always fixed and made it right. They have been an excellent addition to our business.
Let’s Build Your AI-Readiness Roadmap Together
Contact us for a free strategy session with our experts.
Talk to an AI Expert
