Assessment, planning and customer deployment of a multi-environment data warehouse and business analytics solution

Background
The client is a leading financial services organization with focus credit card lending.

The Challenge
Executives wanted to attract a new retail base while retaining and improving profitability for its current clients by providing value added services. CBIG was able to design and build key functionality to provide sales, marketing and business teams with timely customer information to make better-informed, innovative decisions.

Methodology and Solution
The company has utilized an innovative blend of technologies to provide their internal customers a variety of business intelligence services and to offer external customers a value added market analysis service.

The principal business impact and return of the Business Intelligence environment is the combination and integration of existing applications that make this system a strategically critical application that optimizes the four keys of business: Sales, Marketing, Finance and Operations. All pricing, sales, and marketing decisions of the retail business are made via information directly from this BI environment. Extending the capabilities of the system to their retail customers was paramount to the loyalty programs to reduce the cost of repeated new customer acquisition activities.

For external retailers who use the service, the firm has developed an extranet application that gives retailers the ability to analyze the demographics, geographics and house holding information of shoppers who use the credit facility at their stores. For internal customers, the application addresses the following business needs:

  • Marketing: Campaign management to acquire, activate and retain customers. Market Basket and Shopper Profile analysis from both Merchant and Card Member perspectives to better target campaigns.
  • Sales: Sales Force Facilitation (portfolio and commission) and CRM strategy to better serve existing customers and assist the sales force with more focused and effective campaigns.
  • Operations: Enhanced Customer Service capabilities to improve the overall effectiveness of daily customer requests.
  • Finance: Revenue, Discount Fee and P&L applications to manage, plan and analyze prospective, current and future customers and products. Market Share Impact Analysis to determine the overall effect that the acquisition or defection of a customer or profile of customers would have on the business.

Customer Profile
The client is a Chicago-based credit card lender. Their client base includes some four million retailers and sixty million cardholders.

Business Situation
The client needed to create a competitive edge by using advanced analytical capabilities to understand, track, anticipate, and find new insights about their cardholders and make information work more effectively for them. They also needed to provide the same analytical capabilities to retailers through an extranet as a value added market analysis service.

Technology

  • Oracle 9i
  • Microstrategy
  • SAS 6.0
  • Ab Initio

  • Big Data Consulting 1
  • Big Data Consulting 2
  • Top Big Data Analytics Firm
  • 50 top big data firms
  • Best Management Consulting Firms
  • Big Data Analytics Consulting
  • Big Data Analytics Consulting 2
  • Marketing Analytics Consulting
  • Healthcare Analyitcs Consulting
  • Top Big Data Analytics Company
  • Top BI and Big Data Consulting Firms
  • 100 Top Big Companies in 2016
  • Top Management Consultants
  • Top Big Data Services Firm
  • Top IT Consultants
  • Top 20 Big Data Company
  • Data Analytics Consulting
  • top data analytics companies 2016
  • Top Hadoop Consulting Firm


Switch to Desktop Version