Agile Product Innovation through feedback from 25 Million Customer Interactions per day

Case Studies

Corporate Sales Forecast: 700 Property North America Hotel Chain

Background
Our client had over 3000 corporate customers who contributed to more than a third of their revenues and profit.  Historically, the annual planning for these accounts was around application of a top-down target uniformly for all accounts (and hence the sales managers that managed them). The client sought an outcome that was more reflective of the account’s potential and did not require a huge amount of analysis by their sales operations team. In addition, the annual planning process for sales target and rate communication to clients was marred by a manually intensive spreadsheet driven process that would not get completed in time and required significant additional effort from the sales operations teams.

Assignment
CoreCompete developed an account level revenue forecast that was rolled up and converted into sales targets for individual sales managers. Corporate and Regional Vice Presidents got the roll-up of their respective teams’ numbers through an intuitive dashboard. Sales managers had the ability to review their targets, understand the basis for the forecast, and recommend adjustments to their numbers in an online tool. This led to a consistent analytically driven system that was being used by all the team and completion of annual planning processes in a timely manner.

Value Delivered
The Revenue Forecast and Rate renewal tool resulted in precise, actionable goals that reflect the overall intent of growing their revenue by 9%. It decreased project completion time by an estimated 4 months compared to last year and was on schedule for first time in at least 2 years. Integrated disparate data sources throughout the client organization to improve visibility and enhanced decision-making by management. This project was delivered in a phased manner over a period of 16 weeks, with the first part of the application in production in 4 weeks.

Business Intelligence & Analytics Solutions Case Studies

Anti-Money Laundering Solution Customization for Japanese Bank

Background
Client was one of the biggest banks in Japan. Its correspondent banking division required a functionality to track and detect money-laundering/terrorist financing in their transactions using profiling method that could compare transactional patterns and check anomalous behavior. The anomalous behavior could then be fed into the money laundering risk calculations for the customer.

Assignment
CoreCompete had to deploy an extendable framework architecture to create various levels of transaction pattern comparison to the Peer groups. The bank had to be provided with a highly efficient computational mechanism for customization using minimal compute resources. The solution had to be enabled to work at different combinations of entities and attributes.

Value Delivered
CoreCompete developed a customized solution to meet the client’s requirement in terms of identifying the money laundering risk in correspondent banking. Our experience in financial services and out technical skills in the underlying platform allowed us to build these capabilities in 12 weeks, while delivering a flexible solution.

Business Intelligence & Analytics Solutions

Market Risk Reporting and Analysis Solution

Background
Our client was a global banking and financial services operating in more than 50 countries. The existing system for risk reporting and analysis was severely hindered due to lack of performance, scalability and flexibility, thus, subjecting the banking behemoth to increased exposure to market and counter-party credit risks and regulatory pressures. The bank’s objective was to re-engineer their fragmented and disparate reporting infrastructure to a more robust, scalable and cost effective using SAS’s High Performance Risk Solutions.

Assignment
CoreCompete was asked to develop a logical data model that aligns with front-office market risk management processes, ETL that manages the data flow from the different risk data sources and a phased deployment of SAS in-Memory and Hadoop based visualization and analytics solution to provide dynamic Reporting and Analysis capabilities.

Value Delivered
CoreCompete delivered an end-to-end Risk reporting SAS environment with Visual Analytics and High Performance Grid that reduced data latency, risk aggregation, reporting and visualization challenges and provided high availability and load balancing of SAS services. We created report layouts and provided visualization and interactive reports with high information density. We also educated and trained client’s team for a smooth transition and adoption of the system by close to 200 risk analysts.

Business Intelligence & Analytics Solutions Case Studies

Data Management: Mobile Data Foundation to Enable Hyper Local Marketing

Background
Our client was a mobile advertising network, seeking to deliver hyper-local mobile advertising in the Western European market. A key part of their infrastructure is a mobile data foundation that secures mobile usage data from mobile operators and organizes the data to support ad/ offer analyses and messaging.

Assignment
CoreCompete was responsible for the overall design and delivery of the data foundation. This required us to design the staging area for data from 4 different mobile operators (CSPs), develop the ETL from these
to the marketing platform using SAS Data Integration, setting up the infrastructure across multiple environments and automating the end-to-end process, including the data validation processes.

Value Delivered
CoreCompete worked with the client’s team and several other projects that were simultaneously getting executed in an agile development model. We delivered the mobile foundation, capable of scaling to large data volumes (call detail records for millions of customers). Given the context of the project, we demonstrated our ability to deliver on performance engineering and large scale automation of data management processes.

Business Intelligence & Analytics Solutions Case Studies

Production and Distribution Planning: Large Cement Manufacturer Supplying to 10,000+ Demand Locations

Background
The client was one of the largest cement manufacturing companies catering to the demand from more than 10,000 retail outlets and institutional customers. Inefficient production and distribution planning decisions resulted in escalated costs, uneven plant utilization and poor profit margins. The client planned to introduce the use of sophisticated optimization models for their monthly production allocation and distribution planning process to best utilize the production capacity and available distribution network.

Assignment
CoreCompete was asked to develop an application to optimize monthly production quantities and distribution routing to fulfil the customer demand. The customer asked for a monthly report of revenue and cost incurred to allow senior executives to develop effective sales plans.

Value Delivered
CoreCompete delivered the system in 2 phases over a 12-Week engagement. In phase 1 (proof-of-concept), optimization model was developed for solving relatively simpler business problems with reasonable assumptions to prove the value of the application of optimization models (using SAS/OR). In phase 2, CoreCompete delivered the application to optimize monthly production planning and distribution routing considering complex business and operational constraints making the model closer to reality. The application also produced a list of top distribution routes for each location ranked in the order of net contribution margin to help with manual decisions during the month.

Case Studies Merchandising & Supply Chain Analytics

Integrated Marketing: End-to-End Design and Deployment for a Leading Telecom

Background
Our client was one of the largest telecoms in the middle-east region. The company provides broadband, fixed and mobile, business and wholesale services in the region. Due to increasing competition, client was facing various challenges in customer retention, acquisition and revenue growth.

Assignment
Define an end to end automated marketing solution that will enable the client to respond to market changes immediately and in accordance with its overall strategies to become the leader in next generation of services. This was to be done for a 40 million subscriber base across 3 lines of business.

Value Delivered
We provided business consulting and delivered complete solution design and architecture. The architecture also included real time event based marketing for improved customer experience. This involved a full treatment flow based upon events like call failure, recharge failure and customer demography based events etc.

Case Studies Customer Analytics & Marketing

Integrated Marketing: Medium Sized Retailer

Background
Our client was a medium sized retailer based in the US. They wanted to make their circular and price reduction planning process more agile and localized.

Assignment
Define a process and software requirements for the end-to-end circular creation and merchandise promotion process. The process and technology investments should: reduce lead times for producing weekly/ monthly circulars, improve promotional item selection and simplify post-promotion ROI analysis.

Value Delivered
CoreCompete created an End-to-End Marketing Process Definition and identified the technology requirements for the marketing process. We addressed retail Industry specific issues related to item selection, promotional cadence, store-based execution lead times, merchandising-marketing relationships etc.

Case Studies Merchandising & Supply Chain Analytics

Retail Offer Optimization : End-to-End Solution Design and Deployment

Background
Our client wanted to enable merchants to provide promotional offers to consumers through mobile and web devices.  Optimal offers were desired to be selected based on customer’s propensity to shop categories and their promotion sensitivity.

Assignment
Deployment of SAS Customer Intelligence solutions for achieving the vision. The solution allows merchants to enter available offers, select the right type of customers and campaigns, optimally select a set of offers for a given card holder and communicate them through web and mobile channels.

Value Delivered
We enabled a system that allows a large number of merchants to target millions of customers. The solution design was done in a manner to scale to this large volume of combinations (merchant offers * card holders) in an intelligent manner.

Case Studies Customer Analytics & Marketing
Our site uses cookies to improve your experience. You can control cookies by adjusting your browser or device settings. By using our site and closing this box, you consent to our use of cookies.