About Client
The client is one of the largest sporting goods stores in America with over 100+ years of retail experience. The client mostly provides sports apparel, footwear, hunting accessories, fishing gear, golf, and other equipment related to sports of all kinds.
This sports retail store chain is has 27 locations in 13 states, including North Dakota, Illinois, Iowa, Minnesota, South Dakota, Montana, Wisconsin, Nebraska, Nevada, Utah, Kansas, Colorado, and Texas. The client will soon expand its reach to other states too. It is an employee-owned, privately held business and actively contributes to national and local charities.
The Challenge
The client’s retail stores are rapidly expanding. The accelerated growth demanded robust online systems to accommodate large amounts of customer data. The client was facing the following challenges in its old system:
- The client’s old system was designed many years ago and did not have any of the advanced features users expect today.
- The current ‘Purchase order’ field on the AS400 system was reaching its maximum limit because new stores were being added regularly.
- The client wanted the ‘Purchase order’ field length to be increased because it is an important field for any retail chain.
- To modify one field size it required changes to and recreation of 600 tables and 1400 other programs.
- The biggest challenge was to compile all the components during production hours without the help of an auto compilation tool to speed up the process.
Technology Stack
The Solution
Programmers.io handled the project using a step by step approach. The developers expanded the field length of the ‘Purchase Order’ field.
Our team extracted all the impacted tables and programs using the Impact Analysis tools and made the required changes in all the tables and programs.
RPG developers at Programmers.io created an auto compilation tool customized to the existing architecture of the client’s system and used it to compile all the components in the test environment first.
The client checked all the changes in the test environment, once testing was completed our team used the auto compilation tool for live deployment that was done within minutes instead of days.
Business Impact
Auto compilation tool by Programmers.io made sure that client’s system was down for the least amount of time and did not have a negative business impact on daily business.
Automation of deployment reduced the time frame from days to just 45 min.
In-house automation by Programmers.io was cost-effective because purchasing a tool like this in the market would be quite expensive. They even reduce the feasibility of complex project implementation providing just 70% accuracy after a huge investment.
Expanding the PO field length helped the client to add new stores and allow for input of the maximum amount customer data without issue.
The client praised the Programmers.io team for exceeding the expectations and delivering world class solutions on time.
The client went on to build a long-term partnership with Programmers.io and working with our team on projects of all sizes.
Check out our
success stories
Video Testimonials
Effectively Extending
Your Team
Ken Stewart, PMP, CSM
Vice president of operations & Engineering
PSigen Software Inc.
Play Video
Video Testimonials
Onboarding The Programmers.io Team
Brandy Churchill
Software Development Manager
Western National Insurance
Play Video
Video Testimonials
Effectively Extending
Your Team
Jackie Flummer
Director, Technical Business Systems
AmerCareRoyal
Play Video
Video Testimonials
Effectively Extending
Your Team
Luis Gonzalez
President
SalesScoreKeeper