
Kames Capital plc
Provided business analysis services.
The Brief
Responsible for the design of a Customer and Product Data Warehouse for reporting customer sales and related business intelligence reporting. Designed ETL for transfer of same data to Salesforce. Designed and implemented processes to check quality of data being transferred.
The Result
Following the introduction of Fishtank to consolidate data from Trading Agencies and other platforms into Salesforce, responsible for the design and implementation of Data Quality checking and other analysis exercises, using variety of software including Apex Data Loader, Field Trip, Etherios.