Customer Background

Our customer is a leading national retailer and the largest independent bottling company in the United States. It produces markets and distributes non-alcoholic beverages. With a focus on developing servant leaders, building personal and trusting relationships and giving long-term value for customer, this organization is truly a customer driven one.

Technologies Involved

The products and technologies used in this effort by our team and the customer were,

• IBM WebSphere CastIron
• Microsoft C# .Net
• Microsoft Azure Cloud
• Microsoft SQL Server
• Mainframes
• Microsoft SharePoint
• Oracle
• SAP
• IBM B2B Sterling Integrator
• Microsoft Visual Studio
• Tivoli Workload Scheduler
• JDA Cloud
• Solar Winds

The Business Challenges

With a complex integration system and the need for agility, the following were the challenges that the customer faced,

• Multiple Point-to-Point Integrations for new territories to existing territories
• No proper data format for processing
• Heavy File Transfer use cases with need for high end-to-end monitoring capabilities
• Challenges in monitoring the JDA Cloud Applications and Data Servers
• Exposing businesses services to internal and external partners
• Difficult to consistently apply non-functional requirements
• Lack of service naming standards, standard operating procedures and best practices on service implementations

Our Solution and Support

The customer partnered with us to achieve and create,

• An architectural overview for purchase orders, sales orders and inventories for new territories
• Designed and deployed CastIron orchestrations for end-to-end integrations
• Picking up data load from ADR from enterprise network and posting it to Planograms API (ASP .NET MVC) in Azure Network
• Extracting data from legacy applications to Customer's Integration layer to build REST services
• C# posting data to SAP from Customer's Integration Layer
• Designed services in CastIron and SQL to process high volume of data on weekly and monthly basis
• Handling complex mainframe file formats in CastIron and loaded into the Customer's Integration Layer
• Helped in integrating developed APIs in their Integration Framework
• Implemented services to connect Legacy SAP to customer's new Integration Layer territories
• Maintaining payroll data securely and providing APIs to their financial partners
• Integrating Microsoft SharePoint and Azure with JDA Cloud
• Sending data to merchandiser activity planner through secure web service

• Customer Benefits
• Through our innovative solution and strong delivery team, we were able to assist customer in creating,
• Reusable assets that improved the quality and reduce time to market for integrations which gave the business the agility required
• Following all the existing pattern/process which is used in code to develop/test/deploy code in various environments using DevOps principles
• Re-using the code wherever and whenever possible that gives an opportunity to satisfy the business need in little time
• Building templates to ensure uniformity of code there by simplifying the development, reducing support costs and improving quality
• Implemented secure connector framework to securely integrate on premise and off premise applications
• Documenting recurring issues and deploying a permanent fix which can improve business performance
• Predicting future risks in earlier stage to reduce re-work