Client:
A major bank.

Challenge for client:

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

Issues involved:

1. The present transaction processing system was recording ‘pay to’ details in a ‘text’ field

2. Large volume of data of about 1 million transactions per day.

3. 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.

4. The core banking system was not to be touched even for ‘read only’ queries.

5. Solution was needed within tight time frames and budget restrictions.

Aspect Ratio Approach:

1. IT department dumped daily transaction in text files to a staging area.

2. Our solution imported daily transactions into a database – annotating the text as per a keyword dictionary.

3. Analysis reports fired on database daily, weekly and monthly.

 

Client:
An FMCG company.

Challenge for client:

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

Issues involved:

1. Actual sales were logged into an ERP system. Forecasts were in spreadsheet files.

2. IT department was not keen on allowing an outside database to interact with the ERP database.

3. Forecast files were in different sizes and multiple file formats and these came in from different business units.

4. The comparison between actual and forecasts was required to be made at very small intervals of two weeks.

Aspect Ratio Approach:

1. Imported Transaction Data from ERP dumps to a database.

2. Imported Forecast files – after parsing data across multiple formats to database.

3. 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.

4. Measured impact and effect of different trade incentives and consumer offers.