Invoice & Report Generation
About the Client
Our team delivered a comprehensive IBM i integration and modernization solution for a premier provider of medical cost management services. Operating in the highly regulated medical case management space, the client needed a partner with deep IBM i expertise who could not only clear a backlog of high-priority projects but also architect a unified integration platform connecting their IBM i systems to external applications while keeping their in-house team free to focus on other critical initiatives.
- Industry: Medical Case Management
- Platforms: IBM i (AS/400, iSeries), MuleSoft Anypoint Platform, infoConnect for MuleSoft
The Challenge
A premier provider of medical cost management services ran the vast majority of its business processes on an IBM i (AS/400) system, with core applications developed in-house over more than two decades.
The IT support staff, though experienced, was small—running a lean department meant that taking on projects beyond day-to-day operations was consistently a struggle.
Over time, the project pipeline grew beyond the capacity of the in-house team. Compounding the pressure, mandated time-sensitive legislative changes introduced a greater sense of urgency, leaving the IT team in a critical crunch.
It became clear that the organization needed an experienced external partner with a proven background in IBM i development, integration platform implementations, and a track record of successfully connecting IBM i environments to external applications.
Our Solution
Programmers.io allocated a dedicated team of cross-platform specialists with deep expertise in both
IBM i and MuleSoft to work alongside the client's internal IT department. Rather than simply filling gaps, the team took ownership of the client's IBM i development backlog and led the full implementation of a MuleSoft Anypoint Platform-based integration layer—building a foundation designed not only to address immediate project priorities but to enable reusable, accelerated delivery for all future integration requirements.
Central to the solution was the deployment of infoConnect for MuleSoft—a purpose-built plugin that enables bi-directional, real-time connectivity between the IBM i and MuleSoft. This allowed the client's IBM i-resident data to flow seamlessly to external applications, partners, vendors, and customers without requiring changes to core IBM i code.
Dedicated Cross-Platform Team
To eliminate usability challenges faced by business users and reduce maintenance efforts, the client’s application was migrated from its physical, on-site server to SharePoint aA specialist team with IBM i and MuleSoft expertise was embedded alongside the client's IT department, taking full ownership of the project backlog and integration platform build. Online.
MuleSoft Anypoint Platform Implementation
A solid integration foundation was established on MuleSoft, enabling reusable, accelerated delivery for both current and future integration requirements.
infoConnect for MuleSoft
purpose-built connector enabled bi-directional, real-time data flow between the IBM i and external applications—without modifying core IBM i code.
Automated Invoice & Report Generation
IBM i data is automatically extracted and transformed into formatted Excel spreadsheets, delivered directly to end customers—eliminating manual reporting effort entirely.
Reusable Integration Architecture
All integration assets were built for re-use, leaving the client with a scalable framework that accelerates onboarding of new external systems and future integrations.
Technologies Used
Our software architects and engineers are experts in using the latest technologies.
-
Integration Platform: MuleSoft Anypoint Platform
-
IBM i Connector: infoConnect for MuleSoft
-
Core System: IBM i
(AS/400, iSeries) -
Reporting Output: Microsoft Excel
(automated generation via
IBM i data extraction)
Business Impact
Our solution added value with surprising results because we were able to deliver a high-quality product on time.
99% reduction in manual data entry errors.
Reporting time reduced from days to minutes.
Here’s how we did it
-
Time-Sensitive Projects Delivered On Schedule
All high-priority IBM i development and compliance-driven projects were completed on time, meeting mandated regulatory deadlines.
-
Automated Invoice & Report Generation
IBM i data is now automatically extracted and transformed into Excel spreadsheets delivered directly to end customers—eliminating manual effort.
-
Unified, Flexible Integration Platform
A MuleSoft-based integration layer now enables IBM i data to stream bi-directionally to external applications, with a reusable framework for future integrations.
-
Regulatory Compliance Supported
The new platform directly supported the client's alignment with the latest mandated regulatory compliance requirements, reducing legal and operational risk.
-
In-House Team Freed for Strategic Work
With our team owning defined integration tasks, the client's internal IT team could refocus on other time-sensitive internal initiatives.
-
Foundation for Future Growth
Reusable integration assets and the infoConnect toolset leave the client positioned to onboard new external systems and expand capabilities rapidly.
Other Case Studies
TMS Migration and Middleware Implementation
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 Modernization Roadmap Together
Contact us for a free strategy session with IBM i experts.
View Our Offerings Talk to an IBM i Expert