Olivier - Business Analyst PL SQL

BI Analyst

Context: Optional Insurances - ERP Integration – Agile Scrum
Achievements:
Managing change requests and defects follow-up
Cross-checking data sources for Solvency II reporting and ensuring data quality
Designing a new data-warehouse to provide the business with self-service solutions

Performance Manager

Context: E2E Operations Estates (legacy) - Reverse-engineering Assets under Management KPIs
Achievements:
Analysed the data produced since 2012, investigated to understand trends and accidental data
Analysed the whole process and changes since the system was set up in 2006: gathered information
available in business requirements, the business managers assumptions and findings, the source data
owners, the data flows, and the calculations (code and operations)
Presented the findings from different views, defects, strengths and opportunities of the system
Defined and assessed the use cases against the available source databases
Designed a future BI system (pre-project), its functional architecture and new possible measures

Data Quality Analyst

Context: DG Europaid (DEVCO), Business Analysis & Management Control - Specialized in Invoicing & Payments
Achievements:
Analysed the strengths & weaknesses of the reports/tools available as well as the processes involved
Established statistics and reports on payment delays and the link to late payment interests
Tested and validated new reports and KPI dashboards
Ensured improvements in data quality through identification of issues, structural solutions and reconciliation
of invoice discrepancies between Devco's system and the EC's Accounting ERP (ABAC)
Coordinated data correction campaigns (HQ services, delegations, data owners, accountants)
Defined the business requirements & Project charter for an automated monitoring tool for invoices paid/to
pay in compliance with the EDF and EU General Budget financial and accounting processes
Produced quarterly analysis of KPIs for DEVCO Management meetings

Consultant

Context: IT Europe, Functional Support and production monitoring for CIB European territories Datawarehouses
Achievements:
Responsible for the European infocenters and DWH daily loadings and production
Managed the requested changes for standard components: non regression testing for releases and patches,
coordination of the testing phases with the PMO, the sites, and the infrastructure services
Provided 2nd level production support (process and code analysis for issues, user access management)
Carried out analysis, build, maintenance and support on specific components for the European Branches
Trained a team in Mumbai and ensured the handover on the recurrent tasks

International BI project leader

Context: Product Process Quality Datawarehouses (Vehicle in Warranty quality data)

Achievements:
Analysed the business needs in order to interface the Joint-Ventures in China with the corporate Systems
Produced and documented the functional and technical analysis of the existing systems and data flows
Designed the business and functional process models of two alternative solutions

Achievements: BI Reporting

Developed and tested statistics reports with Business Objects Webi
Improved the dedicated datamarts, and documented the BO universes

Achievements: Customer Data Analyst

3rd level production support on the clients Master Data: functional analysis and resolution of the issues
Analysed and produced technical analysis for new developments
Started to build a new configuration management system

Functional & Data Analyst IBM

Achievements: Functional Analyst / Technical leader

Analysed the business requirements for new data flows and produced contractual functional specifications
Designed and developed data models, interfaces and flows, or depending on the project size, led a small
development team as a PL/SQL expert, managed the integration tests and validated the deliveries
Software configuration management and delivery leader (10000 components)

Retail IT Project Leader

Achievements:
Carried out the integration of the standard ERP throughout the Group subsidiaries, especially in Germany
Designed and controlled the Daily data-flows between stores, headquarters and data warehouses
Managed the functional analysis, development and tests for country specific interfaces
Organized the team activities, as well as the relationship with the suppliers (requirements follow-up)