CLIENT PROFILE
International group headquartered in Belgium with over 200 subsidiaries, serving numerous industries worldwide (incl. automotive, aerospace, electronics, and healthcare) with an annual turnover of approximately EUR 10.3 billion.
Client Profile
Major French bank with over 192,000 employees across 62 countries and an annual turnover of approximately EUR 26.6 billions. They manage assets for a value of EUR 1.48 trillion.
Client Challenges
Realisation of a 360° vision of business for the management.
Key Achievements
- Advised the customer on how to improve the process by implementing a data collection pipeline, storing quarterly data in a new Datawarehouse,data coming from Excel files and accounting software (SageX3).
- Implemented a Business Intelligence solution in order to generate a quarterly dashboard, automating as many tasks as possible, reducing publication time from 4 months to 2 weeks.
Key Achievements
Helped in designing the new reporting framework to generate private banking reporting to customers. Designed data pipelines to feed the dedicated data warehouse,including bank data, external data from API sources like Bloomberg, Database performance tuning (Oracle) and report design using MicroStrategy.
Required strong security implementation as private banking customers require highest level of confidentiality.