Case Study Flipbook
TMS Migration and Middleware Implementation
About Client
A premier provider of trucking based logistic services for customers across the United States in divisions including standard flatbed, tankers, and refrigeration transport. For the customer team, their IBM i based TMS system was the source of truth, but posed challenges as the business pursued a new cloud based TMS system and needed to migrate data from the old TMS to the new cloud-based system.
Programmers.io Experts Automate Bill Entry on IBM i Platform for Wholesale Grocery Distributor
About Client
Data Update Automation Fortifies Bi-weekly Releases and Shopping Security
About Client
Programmers.io Transforms Order Management System for Fast-Growing Food Processing Enterprise
About Client
The client is a food system company that specializes in the production and processing of pork in the United States. They are the 3rd largest pork producers in the U.S. and process more than 6 million hogs each year.
Middleware Migration for Global Energy Network
About Client
A leading global energy provider with integrated brands and operations across the oil and gas value chain. They have over 110 years of experience in the energy industry and have distinctive experience in worldwide technology, trading, and enterprise partnerships.
IBM i Core Banking Data Replication Pipeline
About Client
A leading full-service banking operation with a network of over 80 branches across 18 provinces, providing a wide range of financial services to customers. The bank relies on its IBM i core banking platform and sought a modern solution to unlock real-time data for analytics, fraud detection, and AI initiatives.
Global Order Integration
About Client
Our team streamlined a global health and hygiene company’s order management by replacing complex point-to-point integrations with a unified MuleSoft-based architecture. The solution decouples sales channels from backend ERPs, accelerates onboarding of new markets, and enables near real-time, reusable integrations across regions.
Programmers.io oversees production functions and IT requests for a trucking industry leader to streamline and enhance processes
About Client
Our client is a well-known leader in transportation and logistics with a rich history spanning eight decades. Since its founding in 1934, the company has consistently delivered reliable freight services, making it a trusted partner for businesses of all sizes. They have a vast network of service centers and modern equipment, which helps them specialize in less-than-truckload (LTL) shipping. This allows them to provide cost-effective, efficient...
The Challenge
The client encountered significant challenges within their Development (DEV) process due to a high volume of incident test requests (application modification, enhancement, bug fixes, research, and sometimes production issues) that required rapid action taken by the development team (DEV).
- High volume of tasks: There was a high volume of development tasks across the departments (e.g., Linehaul, Rating and Billing, SAP). The high volume of tasks caused bottlenecks and slowed down processes in all the departments when they interacted.
- Research and analysis: No existing documentation was present for some programs. The operational landscape involved multiple systems interconnected through an ERP framework. This intricate framework introduced complexities, as changes or issues in one system could potentially impact others within the network. Therefore, research needed to be done for the implementation of new functionality.
- Production issues: Frequent production issues need to be addressed on time. The application’s demand for compatibility across various platforms introduced another layer of complexity. Ensuring the application functioned seamlessly across different operating systems, browsers, and devices required rigorous testing.
Modernizing IBM i Green Screen Application Unlocks Cost Savings and Growth Opportunities
- ACS Console
- Adobe XD
- Angular
- BIRT Reporting Engine
- Bitbucket
- CSS
- DB2i
- DBeaver
- Eclipse BIRT
- EhCache
About Client
MuleSoft Success Story
About Client
The client is a rapidly growing U.S.-based specialty retailer with over 100 stores nationwide. Alongside its retail operations, it operates a robust consumer loan division, offering financial solutions to its customers. The company relies on an in-house developed ERP system built on IBM i (AS/400), which supports its core business processes. As the business expanded, the client faced challenges with system integration, scalability, and modernizing legacy IT infrastructure to support future growth.
Unlocking Data and Processes
About Client
The client is a specialty retailer operating on a legacy IBM i (AS/400) ERP system. They faced challenges with maintaining and extending their tightly coupled applications, sharing data across systems, and modernizing their IT landscape. With growing technical debt and limited flexibility, the client sought a solution to unlock their legacy data and processes to enable faster integrations, improved system efficiency, and support for modern enterprise applications..
Seamless COBOL to SQL Migration Improves Performance and Reduces Costs for ERP Client
About Client
With over three decades of experience, the client operates a network of large cash-and-carry warehouse stores, serving a wide range of customers in the food service industry.
The Challenge
- The client’s legacy Mainframe COBOL system was inefficient, with batch jobs taking over 30 minutes to complete. This delay caused bottlenecks in operations, hampering productivity and responsiveness to business needs.
- Maintaining the system was expensive due to high licensing fees for Mainframe servers. The lack of scalability further increased costs and limited the ability to handle growing workloads.
- Job failures were difficult to troubleshoot because of insufficient logging and tracking mechanisms. Restarting jobs required manual backup and restore steps, consuming excessive time and storage, and delaying high-priority tasks.
- Data stored in Mainframe files was inaccessible, making it challenging for teams to retrieve and analyze critical information needed for decision-making.
- As the client expanded operations, the outdated system struggled to scale, creating a pressing need for modernization to stay competitive in a fast-paced industry.
Collaborative IBMZ/OS Server testing results in transformative changes, including continuous regression testing and more frequent releases
About Client
After more than four decades, our customer is a trusted name in the insurance industry. They specialize in providing flood insurance solutions to homeowners, businesses, and communities across the United States. Focusing on innovation, customer service, and risk management, they prove their dedication to helping clients safeguard their properties and investments from flood-related risks.
...The Challenge
The customer had an application that used a web-based interface to allow agents, customers, and lenders to access their policy information. It was linked to the customer’s data residing on a mainframe computer. The application had to be released on time, and it was critically important that test coverage was known to eliminate defects in all stages of the end-to-end operation.
There were challenges during the initial period of the project. One involved understanding the complex functionalities of the integrated products in the suite. A second challenge was that 85% of the project was on a company mainframe and testing was done manually. Fast, comprehensive testing was imperative to meet their schedule and avoid surprise errors at the later delivery stages. This was especially true for the mainframe code interaction with the graphical user interface (GUI) application.
Built a modern real-time freight tracking API for a global shipping company
About Client
The client is a full-service customs broker and freight forwarder with over 50 years of personal service. It is committed to providing remarkable service by combining the knowledge and experience of its professional staff with advanced information technology and systems. The client works seamlessly to coordinate the flow of goods and information through today’s complex trade environment. The company operates nationwide in the US covering all...
The Challenge
Being a major customs broker and freight forwarder, the clients’ ERP system runs on IBM i, looking at the criticality of data and services. The system works on IBM i as the client has to maintain ample of records of the containers across the year.The challenge faced by the client:
- The client’s operators have to maintain these records manually. They have to check the data of the containers from various delivery agents’ sites and enter the details in the provided IBM i system.
- This process is time-consuming and prone to error as there is a lot of human interference, resulting in huge costs to the business.
- The client wanted a centralized real-time container/freight tracking system for all the delivery agents, such that tracking the containers and maintaining the details is easy and automated.
The IBM i based companies are also looking forward to making the best use of API integration given productivity benefits. Integrating updated shipping data from transportation providers with core IBM i applications is one of the most popular API use cases today. The client wanted a similar API implementation for its application.
Enhancement of ERP System Saves Manufacturer From Hefty Penalty Charges
About Client
Provided new apps within the first month that reduced manual work and increased report accuracy for a large shipping company
About Client
Since their founding almost 100 years ago, our client has become a leader in the shipping and transportation industry. The client has a vast network of 166 terminals that allows them to provide transportation and logistics solutions throughout the U.S. and Canada. The company has over 10,500 employees and generates almost a billion dollars in annual gross revenue.
...The Challenge
The client needed to improve current running applications and create a set of system applications that would reduce user work and increase reporting accuracy. The client’s need was urgent, and they lacked the in-house expertise and resources to build and implement the new systems. At this point, the client called on Programmers.io to help meet their goal.
Successful Migration to a Modern P2P Suite Enhances Operational Efficiency and Transforms Synon Tables Across a Global Corporation
- IBMi DB2
- Synon CA:2E
- Implementer
About Client
The client is a diversified multinational corporation with primary operations in agribusiness and transportation. Key segments include Foods (premium pork products), and Marine (containerized shipping services). The client engages in international grain processing and trading through its Commodity Trading and Milling division and operates in sugar production, power generation, and turkey processing. The client markets products under several re...
The Challenge
The client faced challenges migrating from an IBMi-based application to a React JS and Node JS-based P2P suite while retaining their IBMi DB2 database. The application’s reliance on IBMi-generated physical and logical files created inefficiencies, as these files were only compatible with the IBMi environment. All physical and logical files were converted to tables and index views To address this issue. This conversion enabled the new application to function effectively with the existing database structure.
Programmers.io increases stability and rate after implementing UiPath automation for IBM i/AS400 green screens
About Client
The client is a prominent flood insurance provider that has served homeowners for over four decades. Through a partnership with the Federal Emergency Management Agency (FEMA), they offer federal flood policies aimed at safeguarding homes, businesses, and their valuable contents from the devastating impact of flood disasters. Over the years, our client has expanded its presence and capabilities, establishing itself as the largest flood insuranc...
The Challenge
The client faced a significant challenge related to their core business applications, which were hosted on an IBMi mainframe. While they aimed to enhance the quality and efficiency of their testing processes, they encountered difficulties in identifying a suitable test automation solution that could seamlessly integrate with their mainframe environment.
Key Challenges:
- Mainframe Environment: The client’s core business applications were hosted on an IBMi mainframe. Mainframe environments often have unique characteristics and technical complexities that require specialized solutions for effective test automation.
- Quality and Efficiency Improvement: Seeking to improve the quality and efficiency of their testing practices, the client recognized the potential benefits of test automation. However, they struggled to identify a solution to meet their requirements within their mainframe environment.
- Compatibility and Integration: The main challenge lay in finding a test automation solution that could effectively interface with the IBMi mainframe. Compatibility and integration were key concerns, as the chosen solution needed to interact with the mainframe applications and processes seamlessly.
Programmers.io modernizes applications and processes for a timely resolution
About Client
They specialize in providing flood insurance solutions to homeowners, businesses, and communities across the United States.
The Challenge
- The US administration, NFIP, and FEMA changed the requirements for evaluating the risk of flooding for insurance purposes nationwide. This meant a complete overhaul in how premiums, rates, and coverages were calculated per zip code.
- Risk ratings that agents used needed a dynamic updating process. This initially involved an intense batch file modification to ensure correct handling of new risk requirements associated with zip code locations.
- We were tasked with delivering a high-paced data integration and program restructuring with a hard deadline of three months.
Resolution of 1000+ Incidents and Service Requests Enhances Critical Business System Stability
About Client
Data Loading into Snowflake using Matillion with a Meta data driven approach
About Client
The client discussed in the case is one of the famous fashion retail chains of Women and girls’ attire. It is widely known for its shift dresses, active-wear, shoes, accessories and print dresses. Being in the business for 60 years, the client has been a designer, marketer, and distributor of upscale collections for women. It has emerged as an affluent brand with a heritage and aesthetic based on the Palm Beach resort lifestyle.
T...
The Challenge
The client being into fashion retail needs real-time data of the customers to analyze and create its business strategy.
Following challenges were faced by the client:
- As the customer data was stored on various data sources such as IBM i DB2, Oracle, SAP and Salesforce (SFDC, SFMC, SFSC), the history of the data could not be stored
- The data had to be loaded in a centralised data warehouse for accessing and analysing real time data using generated visual reports, along with maintenance of data history
- Data overload needed immediate integration with the Data Lake along with proper QA and validation of the data
- The client expected the data loading and validation task duration to be around 6 months with a separate team of QA engineers and a greater number of resources that increased the overall cost of the project
Envisioned and built a product customization portal for furniture manufacturer used by customers and sales reps
About Client
The client is a 70 year old furniture manufacturer based out of Wadena, Minnesota, USA. It mainly deals into affordable luxury outdoor patio furniture offered in 30 collections. These include tables, chairs, chaises, loveseats, sofas, ottomans bar and balcony stools/chairs stools made up of durable aluminum, steel, and cast frame. The client is serving various industries such as restaurants, hotels, resorts, hospitals etc.
It offers out...
The Challenge
The client has multiple Windows applications for internal purposes such as for various categories of the furniture and fabrics. These applications are designed for offering customized products to the customers. The challenges faced by the client are:
- The applications are desktop based and cannot be accessed from anywhere, therefore creating a delay in attending to the requirements and customization of the products
- As these are multiple applications for various functions, there is no single platform to access all of them at one place. The employees have to login separately on all of them to fetch the details.
- Windows applications do not look appealing or user friendly.
- The client wanted only the authorized users to access the new web based applications
- The products were to be better categorized with the addition of Zebra printer that would print the tickets with barcode correctly and attach those with the products for identification.
ERP Customization and enhancement for an Education Solutions Provider
About Client
Founded in 1926, the client provides high-quality, innovative curriculum solutions to K-12 schools across the United States and internationally. For over 90 years, the client has been a leader in literature and language arts programs for grades 6-12. It is also one of the leading providers of trade books to classrooms across the United States and delivers an unsurpassed selection of novels, nonfiction books, classroom collections, and literatu...
The Challenge
The client is a large provider of educational material, solutions, and online programs for customers across the US. Because of their large customer demand, the client had a need for an extended workforce and system advancements. The challenges faced by the client were:
- The existing ERP system was old and did not have the latest functionality that were needed to serve the growing business
- The ever-changing demands of customers could no longer be catered to through manual processes
- The accounts payable system also needed modifications
Programmers.io. partnered with the client to overcome all their IT challenges. Our team of jumped in and extended the client’s current It capabilities while working closely with its in-house team.
Smooth Migration from Synon-based IBM i to Modern Technologies by Addressing Expertise Gaps and Ensuring System Continuity
- IBMi DB2
- Synon CA:2E
- RPGLE
- SQLRPGLE
- Java
- ReactJS
- NodeJS
About Client
The client is a diversified multinational corporation with primary operations in agribusiness and transportation. Key segments include Foods (premium pork products), and Marine (containerized shipping services). The client engages in international grain processing and trading through its Commodity Trading and Milling division and operates in sugar production, power generation, and turkey processing. The client markets products under several re...
Achieving Cost-Effective Migration from IBMi to Modern Applications Ensuring Seamless Integration and Data Consistency
- IBMi DB2
- Synon CA:2E
- Implementer
About Client
The client is a diversified multinational corporation with primary operations in agribusiness and transportation. Key segments include Foods (premium pork products), and Marine (containerized shipping services). The client engages in international grain processing and trading through its Commodity Trading and Milling division and has operations in sugar production, power generation, and turkey processing. The client markets products under seve...
The Challenge
The client faced challenges during their migration from an IBMi-based application to a React JS and Node JS-based P2P suite application while maintaining their database on IBMi DB2. They used ER/Studio to create data models; however, they were unable to incorporate these new tables into their existing Synon-based application due to advanced database definitions that conflicted with the legacy system.
They also faced difficulties managing ‘change history’ and ‘release history’, along with other constraints imposed by ER/Studio, which created obstacles in aligning the new application with their operational needs and slowed down the migration process.
Created a web based application that allows giant chemical manufacturer to log, assign, and address client complaints
About Client
The client is an established manufacturing giant based out of Baltimore in the US. With over 100 years in the business, the client has manufactured various chemical solutions/products majorly used in industries such as Furniture, Automotive, Medical, Packaging, Acoustic and other Consumer Products. The company is a large manufacturer and one of the first producers of flexible polyurethane foam, synthetic fiber, continuous filament fiber, low m...
The Challenge
The Client was using a legacy application that was developed to register complaints from the customers or retailers related to the products sold by the client. The operator used to log the complaint and assign it to the concerned department. The authorised person from the department would verify the complaint and take further actions or resolve the complaint. The challenge faced by the client was that this was a desktop application built using VB that could not be accessed by people in the company from anywhere. This led to a lot of delays in problem resolution.
- The client wanted a web-based application on the IBM i system using the logic written in RPG only. The client also wanted to use IBM i credentials to log in the new Web-based application.
- The client asked to define the roles and access authority for the users. Such that the employees have limited access to the application features based on their roles/designation.
- Another requirement was to add a feature to send a mail with an attachment or PDF to the assigned person once the operator logs or submits the complaint.
- The database of the desktop application was built using MS Access, it had to be migrated to IBM i DB2/400.
Provided IT support team staff augmentation for large US based insurance company
About Client
The client is a major mutual insurance firm for more than 110 years. Besides fulfilling policyholders’ property-and-casualty insurance needs, this company is also serving as a super-regional insurance provider for individuals, families and businesses all over the Midwestern, Northwestern and Southwestern United States.
The Challenge
As mutual and P&C insurance firms have to cater to the ever increasing customers’ queries, issues and complaints without any delay, the companies are witnessing extreme challenges related to timely support ticket resolution. Same was the case with our client. The client lacked in-house expertise and resources to handle support tickets round the clock, daily monitoring, implementation and modification of code whenever required. To avoid a huge customer DSAT and churn, it was looking for an immediate extended staff that could work on mission critical deadlines, provide 24X7 support for ticket resolution and implement a modernized operations system.
IBM i/AS400 modernization to Java for National manufacturer
Technology Stack
About Client
The client is one of the largest privately owned manufacturers of vinyl products, thermoplastic elastomers, colorants, engineering thermoplastics, esters, and other specialty compounds. With over a century of global manufacturing expertise, the company has a huge clientele across industries such as building and construction, consumer, electrical and electronics, transportation, medical, and more. The client specializes in providing engineering...
The Challenge
Because it is a manufacturer, the client must be able to respond quickly to the daily demands of many customers. To help address customer issues, the client wanted a faster, robust and modified system.
Below are the major challenges faced by the client:
- The client had recently updated its ERP system, but the new updates were not supported by RPG. Therefore, the client wanted to migrate from RPG to Java.
- The existing RPG programs were dependent on an IBM iSeries operating system that created an obstacle to easy modernization and the client wanted a modified platform based on a modern technology such as Java.
- There is no automated tool that simply migrates the code from RPG to Java and finding a developer(s) who is/are skilled in both these languages is a tedious task. The client was looking for a third party service provider who had experienced developers with knowledge of both RPG and Java.
Development and Modernization of a Manufacturer and Retailer’s EDI and ERP System
About Client
The client is a manufacturer and retailer of about 6000 types of disposable products used in the foodservice, janitorial, sanitation, industrial, hospitality, and medical industries. The company deals in both B2B and B2C space and is a quality leader for trusted quality disposables. This premier manufacturing client has various shipping points across the United States. The multiple distribution points include Pennsylvania, South Carolina, and ...
Modernization of COBOL Application Automates and Future-proofs Digital Operations
About Client
is a 110-year-old, independent department store chain in the United States that meets customers' end-to-end daily requirements. Headquartered in Reading, Pennsylvania, they have over 50 department stores nationwide. From fashion to home furnishing, they offer a wide range of brand-name merchandise and services that have earned them unmatched customer loyalty in the retail industry.
Modernized a popular IBM i/AS400 insurance financial service platform increasing connectivity and data exchange
About Client
The client provides financially stable insurance products to its customers. Being in business for over 60 years, it has enhanced the process of buying insurance and annuity products. It delivers outstanding performance and believes in service beyond expectation. In September 2018 the client announced its partnership with FAST, a leading digital platform, making itself the first insurance company to be entirely cloud-based. By introducing new t...
The Challenge
Our client’s ERP runs on IBM i and it is using Amazon Web Services (AWS) cloud service to store its data. AWS Cloud was used for this process because:
- It offers a complete range of services to store, access, govern and analyze data
- It provides reduced costs, increased agility and simplified storage management
- It makes it simple and fast to move large amounts of data online between on-premises storage
The data stored by the client on AWS included files related to banking such as Commission statement files, EFT (Electronic Funds Transfer) Premium files, GL (General Ledger) etc. The client used to extract these files and created dynamic folders on AWS for its daily processes. As these daily processes of the client ran on the IBM i platform, the major concern of the client was to access the data on AWS cloud from IBM i/AS400 IBM i.
Programmers.io Improves QA Procedures For Top LTL Carrier
About Client
Our client is a prominent less-than-truckload (LTL), union-free motor carrier service provider that has been in the freight industry for over 90 years. With headquarters in Thomasville, North Carolina, they offer their services via 250+ service centers across the United States and North America. They specialize in delivering air and ground expedited transportation, container drayage, supply chain consulting, truckload brokerage, and warehousin...
The Challenge
The client faced significant challenges with their quality assurance (QA) process and enterprise resource planning (ERP) framework, which required immediate attention. While they wanted to streamline their testing processes, the following created substantial barriers:
- High ITR Volume: A high volume of Incident Test Requests (ITRs) created significant issues for the client’s QA process. These ITRs required immediate attention and approval from the in-house QA team, which was beyond their capacity to review and validate effectively.
- ERP Framework: The client’s operational workflow depended on an ERP framework connected with multiple systems. Due to its complicated nature, testing the framework became challenging as any changes or issues in one system could impact other systems across the network.
- Platform Compatibility: Ensuring all interconnected systems work efficiently on various browsers, devices, and operation systems introduced a new set of challenges requiring rigorous testing.
Programmers.io eliminated hours of manual tasks and data entry for an upscale fashion designer and distributor
About Client
The client is a designer, marketer, and distributor of upscale collections of women’s attire, sportswear, and other products. Originally established in the year 1950, it has emerged as an affluent brand with a heritage and aesthetic based on the Palm Beach resort lifestyle. The brand has demonstrated multi-generational appeal. Its products can be found in the company’s owned signature stores, e-commerce site, certain department stores, and...
The Challenge
The client was looking for a partner to implement EDI and Drop Shipment processes aiding the daily processes like invoices, purchase orders, shipment notices, etc. as it did not transfer data electronically until that time. This situation was leading to delays and customer DSAT. The client wanted to connect its e-commerce platform on IBM i/AS400 to a DSCO Portal, which is a middle layer between the client and the trading partner. The client wanted IBM i e-commerce store integration with the DSCO portal to connect the business with new partners as well as enhance the quality of the existing IBM i processes.
Modernized old applications for a Technology company allowing them to reduce manual work and increase client happiness
About Client
For 20+ years, the client has been working on innovating the modern technology and helping its customers. The company is focused and passionate about modernizing enterprise applications, software development and digital transformation.
...The Challenge
The customers of the client rely on its products and solutions for various business specific requirements. But as the old applications were no longer intuitive and scalable, customers’ expectations evolved to modernize them. The client was having a hard time in keeping up to them and was looking for a trusted IT partner, expert in both legacy and web technologies to provide on time assistance on modernization.
Optimizing SKU Assortment and Inventory Management Through Advanced Data-Driven Reporting Solutions
- IBM i
About Client
The client, a privately held and majority employee-owned supermarket chain, is headquartered in Boise, Idaho, with a strong presence across ten U.S. states, including Arizona, California, Idaho, Montana, Nevada, Oklahoma, Oregon, Texas, Utah, and Washington. Established in 1967, the company initially operated as a no-frills, warehouse-style retailer focused on delivering low prices. Today, it continues to uphold its legacy of value-driven reta...
The Challenge
The client sought to enhance their SKU assortment initiatives by developing a more reliable report. Management expressed interest in leveraging data-driven insights to support these efforts and required technical expertise to refine the report.
To achieve this, they identified the need for a programmer to work with the data, ensuring the accuracy and reliability of the report for informed decision-making and optimizing their assortment strategies.
Programmers.io circumvents a program’s limitations, allowing larger orders with up to 100 detail lines.
About Client
The Challenge
- The client’s automated tax report using third-party API-integrated software resulted in users frequently experiencing accidental order placements and billing discrepancies, particularly with larger orders.
- The third-party software could process only 50 item specifications for an order. This limited revision call capacity prevented efficient, error-free mass order processing.
- The system automatically paused larger orders when it detected an error in tax calculations. To proceed with the fulfillment of the order, the client manually intervened to resolve these issues.
Provided regular QA testing and maintenance on a well-known, cloud based B2B and B2C ecommerce platform
About Client
The client is a renowned provider of industry-leading cloud-based business management software for multiple industries for over 40 years. The company’s products and solutions are focused on empowering the SMBs that are spread across industries like manufacturing, building and supply, developing office products, business applications etc. The company helps its customers to plan, manage, analyze and control their businesses by providing innova...
The Challenge
The client created a solution for e-commerce offering B2B and B2C clients with order management. This product is a mix of technical competence and industry knowledge. The challenges faced by our client in this solution was that the customers were asking for changes in designs frequently. The client wanted integration and implementation of new advanced front end technologies with existing IBMi/iSeries architecture. It was looking for an IT partner that could maintain and test application security, data integrity with respect to payments and with customer confidential data. The client also wanted tested and verified numerous interfaces to 3rd party modules for complete payment and catalog updates.
