This successful fashion design company creates apparel and accessories for women and children in 23 locations, independently owned shops, and major department stores, such as Belk, Lord and Taylor, Nordstrom, Saks Fifth Avenue, and Neiman Marcus. The client designs and creates a unique, signature collection of dresses, tops, lounge & active ware, shoes, and jewelry that reflects the sunny, bright colors and floral prints of the west coast.
The client essentially had a two-part problem they needed solved. The first challenge involved bringing real-time data from cloud applications into a data warehouse to better understand company performance and the effectiveness of their marketing strategies. A second challenge was to determine how to extract the data from APIs that had no built-in API connection. For this we needed to develop dynamic customized APIs.
Programmers.io started by solving their data/API integration and process automation, outlined in the following modules:
Since there was not built-in API profiling available, we started with understanding how Facebook, Google Ads 360, and Google DV 360 APIs could be analysed to work for the client. We analysed how we can have a smaller number of API hits to get the most out of the data in real time. We created our own API connection as a plugin to our ELT Process.
Parsing Semi-Structure Data And Loading It Into The DWH
We built the process to parse the semi-structure data to multiple level nodes. Parsed data will get loaded to different layers inside the DWH with different load strategies in a single pipeline framework. We set up the process between each data transaction to audit and handle up to 50% failure rates without manual intervention and to notify the responsible person through various modes.
Created a shared cloud-based warehouse (DWH) using data from multiple social media platforms and search engines that anyone in the company could access.
Could focus on specific demographics and other necessary information for marketing campaigns and sales reports using multiple targeted searches in the data warehouse.
Increased sales over 33% due, in part, to the ability to identify interest for specific fashion designs through targeted searches of the DWH and tracking website link clicks using the dynamic API integration and ELT processes.
Read More Case Studies
"We find your team to be true business partners. Exceptionally responsive, strong domain knowledge, and outstanding at execution."
Chief Integration Officer
"Happy with the performance. The team is self-driving, which is something I’ve had struggles with in the past. Very knowledgeable on the IBMi and requires minimal guidance."
Director of Information Technology
"Every developer we have worked with has been great! They are great at analyzing and making great suggestions, in addition to coding all that we ask for. Even with the time difference, they are always willing to work on "our hours" when needed for deadlines and projects as needed. Thanks for everything!"
Chief Information Security Officer
"The programmers I have worked with have all been great! They think out of the box and make suggestions, and they research and figure things out on their own, which is a tremendous help to me. I would recommend them to any prospective clients you have."
"Great team and still one of the best I’ve worked with on the IBMi/RPG environment"
VP, Commercial Excellence & Digitization
Ken Stewart, PMP, CSM
Vice president of operations & Engineering
PSigen Software Inc.
Onboarding The Programmers.io Team
Software Development Manager
Western National Insurance
Director, Technical Business Systems