case studies

Data Update Automation Fortifies Bi-weekly Releases and Shopping Security

About The Client

is a well-known women's apparel company with 60+ years of experience in the retail industry. Their products can be found online for global purchase. Additionally, they have their products at 65 retail outlets, 70 signature shops, and several departmental stores in the USA. They offer products exclusively for the summer season that range from vibrant casual clothing to elegant accessories.

  • Industry: Retail and Consumer Goods
  • Headquartered: Pennsylvania, USA
  • Platforms: IBM i/AS400, Aldon, EZView, Robot (Scheduler)
  • Team Size: 6 (4 RPG developers, 1 database developer, and 1 QA expert)
the_client
 

The Challenge

The client has an e-commerce website based on a legacy IBM i/AS400 backend. It required data to be manually updated on the IPS files of the website, which slowed down the information flow to the users.

This manual update created a problem to provide customers with real-time updates. This delay created a negative impact on the user experience, which is crucial in this immensely competitive market.

The website lacked a password policy to educate users on the importance and best practices of creating and implementing strong passwords, leaving critical information vulnerable to cybercriminal activities.

 

Our Solution

Our developers and QAs crafted the solution to resolve the client’s challenges.

The Solution

Implementing Testing Strategies

Programmers.io took responsibility for each functional area of the information flow to create and implement a decision table using Microsoft Excel. This decision table ensured correct data updates in all fields based on color, style, and UPC.

The Solution

Identifying Improvement Areas

The team thoroughly analyzed each IT request and its corresponding functional domain to detect bottlenecks, inefficiencies, and opportunities for improvement. They also collaborated with the clients to validate those changes before implementing them.

The Solution

Incorporating the Changes

Upon approval, the team implemented the revised testing methodologies and a new password policy within the given timeframe. These implementations automated data updates on the website, enhanced workflows, improved security, and upgraded shopping experience.

Technologies Used

Our software architects and engineers are experts in using the latest technologies.

  • IBM i/AS400
    IBM i/AS400
  • Aldon
    Aldon
  • EZView
    EZView
  • Robot (Scheduler)
    Robot (Scheduler)
 

Business Impact

Our solution added value with surprising results because we were able to deliver a high-quality product on time.

Impact 1

83.33% Data Update Time Reduction

Impact 2

Bi-weekly Website Release

Here’s how we did it

  • Delivered real-time product information

    by automating the data update process.

  • Improved operational efficiency

    by addressing existing bottlenecks and inefficiencies.

  • Reinforced shopping experiences

    by implementing a robust password policy.

  • Ensured marketing goal accomplishment

    by delivering the modernized solution on time.

we-did-it

Other Case Studies

Default thumbnail

Mobile Application Enhancement and Upgradation Drove Pharmaceutical Operational Excellence

Programmers.io ensured Flutter version modification, improved build run, testing, and sharing time, lowered build size, and optimized app performance by enhancing and upgrading a pharmaceutical purchase and inventory management mobile application for...
View Full Success Story
Default thumbnail

Programmers.io Modernizes and Digitizes Data Backlog for Global Consultancy Group

A global consultancy enterprise hired Programmers.io to digitize a backlog of scattered, unformatted data in the form of reports. We used a sophisticated array of cloud, AI, and data tools to transform their reports into an all-in-one interface for d...
View Full Success Story

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.

Project Manager

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.

Information Technology Supervisor

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.

Director Of Development

Let’s Build Your Modernization Roadmap Together

Contact us for a free strategy session with IBM i experts.

Talk to an IBM i Expert