SucCesS Stories

MIS: Success story

Client & Challenge:

Client: A major bank.

Challenge: Analyse movement of funds in and out of Current and Savings Accounts to induce customer investments with the bank.

Issues Involved:

  • The present transaction processing system was recording ‘pay to’ details in a ‘text’ field
  • Large volume of data of about 1 million transactions per day.
  • Need of the client bank to analyse the nature of transaction based on pay-in and identify these as salary credits, MF investments and utilities payments.
  • The core banking system was not to be touched even for ‘read only’ queries.
  • Solution was needed within tight time frames and budget restrictions.

Aspect Ratio Approach:

  • IT department dumped daily transactions in text files to a staging area.
  • Our solution imported daily transactions into a database – annotating the text as per a keyword dictionary.
  • Analysis reports fired on database daily, weekly and monthly.

MIS: Success story

Client & Challenge:

Client: An FMCG company.

Challenge: Compare actual sales with forecast sales whilst the two were in separate databases.

Issues Involved:

  • Actual sales were logged into an ERP system. Forecasts were in spreadsheet files.
  • IT department was not keen on allowing an outside database to interact with the ERP database.
  • Forecast files were in different sizes and multiple file formats and these came in from different business units.
  • The comparison between actual and forecasts was required to be made at very small intervals of two weeks.

Aspect Ratio Approach:

  • Imported Transaction Data from ERP dumps to a database.
  • Imported Forecast files – after parsing data across multiple formats to database.
  • Generated weekly reports broken down by
    1. Region, Territory, Sales Area, Person
    2. Business Unit, Product Cluster, SKU
    3. Regular Sales v/s Consumer Offers or Trade Offers.
  • Measured impact and effect of different trade incentives and consumer offers.

 

success stories


Contact Us

Tel.: 020-66226001 / 66226002
Email: info@aspectratiodata.com

Client Speak...