case studies

Increased accuracy and provided real time data for a famous fashion retail chain

About The 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. 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 a variety of independent specialty stores. Programmers.io is supporting this fashion retail client in the field of Data analysis using business intelligence, EDI transactions and IBM i projects.

  • Industry: Retail and Consumer Goods
  • Headquartered: US
  • Platforms: IBMi DB2, SQL, Snowflake, Matillion, AWS, Looker BI, SAP, Salesforce
  • Team Size: 6–8 Members
the_client
 

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

 

Our Solution

Programmers.io team handled the project immediately and optimized the turn-around time to just 1 week! We adopted integrating Matillion (as an engine) with our MetaData driven approach – which improved our time value.

The Solution

Building a Unified Data Lake for Seamless Analytics

Data experts at Programmers.io suggested to build a Data Lake first. The team performed end to end integration of the data sources such as Salesforce, IBM i DB2, Oracle, Flat files, and SAP with the data lake

The Solution

Efficient ETL with Metadata-Driven Matillion Jobs

Our team used the Metadata driven approach/configuration to run Matillion in loading 200+ SFDC tables into Snowflake using single job

The Solution

Staging, Validating, and Centralizing Data for Analytics

The Data was exported from the source (Salesforce, IBM i DB2, Oracle and SAP) and staged in AWS S3. This data was ingested into Snowflake (Landing layer) where it was validated by the automated QA suite and transferred to Data Lake for comparison and history analysis

The Solution

Faster Onboarding and Streamlined Data Table Management

Using a metadata-driven approach this robust solution made the onboarding changes faster, streamlined development cycle and supported quick maintenance of data tables

The Solution

Comprehensive Audit and Process Health Monitoring

Audit framework captured the error logs, data lineage etc. For each table with solution and helped in generating the health report of the entire process.

The Solution

Transforming Real-Time Data into Actionable Insights

Cleaned and real time collected data was then transformed into visual reports for in-depth business insights and proper decision making for the client

Technologies Used

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

  • SQL
    SQL
  • Snowflake
    Snowflake
  • Matillion
    Matillion
  • AWS Services
    AWS Services
  • Metadata Driven
    Metadata Driven
  • Looker BI Report Tool
    Looker BI Report Tool
 

Business Impact

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

Here’s how we did it

  • Rapid Delivery of a Comprehensive Data Integration Solution

    Programmers.io team delivered the project from expected time frame of 6 months to 1 week with end-to-end development, integration, audit log mechanism, data validation, QA validation (generic Test case) etc.

  • Enabling Strategic Decisions Through Accurate Real-Time Data

    The meta data driven approach ensured accuracy, flexibility and hold on optimized real time data. This saved a lot of time of the client and helped it focus on designing the right business strategy

  • Minimizing Maintenance Costs Through Simplified Processes

    The process involved just one job hence leading to low maintenance cost

  • Driving Revenue Growth Through Clear Data Visualization

    The visual representation made the right information accessible and easy to understand, empowering the client to generate more leads and revenue.

we-did-it

Other Case Studies

Default thumbnail

Reduced the IBM i dependency of a national manufacturer

Our RPG and Java experts helped create a modified, faster, and robust system by re-engineering, optimized, and enhanced the RPG code's reusability. The client experienced reduced redundancy, easy communication, and minimal development time....
View Full Success Story
Default thumbnail

Development and modernization of a manufacturer and retailer's EDI and ERP system

Programmers.io resolved the client's problems by creating a secure modern web portal with a web catalogue and an invoice app that automated processes and saved a lot of time for the sales team and its customers....
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