Olivier - Business Analyst PL SQL
Ref : 110218L001-
1000 BRUXELLES (Belgique)
-
Consultant technique, Consultant fonctionnel, Business Analyst, Data Analyst (54 ans)
-
Freelance
2016 – 2017 BI Analyst - Reporting Mutualités Chrétiennes (LCM), Brussels
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
Technologies: BaNCS, Oracle, Orafin, PL/SQL, SAP BoDi, JIRA
2015 – 2016 Performance Manager BNP Paribas Fortis, Brussels
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
Technologies: Business Objects XI, MS-Access, MS-Excel, MS-Visio, Sybase, Oracle, Mainframe DB2
2014 – 2015 Data Quality Analyst European Commission, Brussels
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
Technologies: Business Objects WebI, Qlikview, MS-Office, JIRA, CRIS, ABAC, PM2
OLDER ACHIEVEMENTS
2012 – 2013 IT Europe BI Consultant BNP Paribas Fortis, Brussels
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
Technologies: BO 6.5 (Admin, Design, User), Oracle, PL/SQL, Unix, Shell, Unicenter TNG, JIRA, ITIL, Prince2
2011 International BI project leader PSA Peugeot-Citroën, Sochaux
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
Technologies: Enterprise Architect, UML, Oracle, PL/SQL
2007 – 2010 Functional & Data Analyst IBM Application Services, Belfort
2009 - 2010 Client: CNAMTS (Health Insurance)
Achievements: BI Reporting
Developed and tested statistics reports with Business Objects Webi
Improved the dedicated datamarts, and documented the BO universes
Technologies: Oracle, PL/SQL, Business Objects XI/Webi
2009 - 2009 Client: BNP Paribas BDDF (Retail Banking)
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
Technologies: IBM MVS, DB2, COBOL
2007 - 2009 Client: RSI (Social Contribution & Health Insurance for freelance workers)
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)
Technologies: Oracle, PL/SQL, SQL*Loader, UNIX, Shell, Tortoise CVS
2006 – 2007 Retail IT Project Leader Devanlay-LACOSTE, Troyes/Paris
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)
Technologies: Cegid Mode Business Suite and Orli, SAP FI, Oracle, PL/SQL, ETL SSIS (Microsoft SQL Server)
2005 – 2005 Business Intelligence Project Leader Arcelor S.S.C., Paris
Achievements:
Inventoried the existing BI tools in order to communicate and provide the teams throughout Europe with all
useful material to make these tools become a standard
Gathered the corporate executives and branch managers reporting needs
Participated in drawing the existing business processes
Started the design and planning for a future corporate Datawarehouse
Technologies: Informix, Business Objects, SAP/BW
1997 – 2003 Functional Analyst / Software engineer Ariane II Group, Brussels
2001 - 2003 Client: SPF Finances (Ministry of Finance, Belgium)
Achievements: Functional analyst / Project leader
Functional analyst in charge of the KBO/BCE project (a national project directed by the Ministry of
Economics) for the part of the Companies Income Taxes Information system : defined the requirements in
collaboration with other public services (meetings in Dutch), produced the specifications (in French), and
managed the development, the acceptance tests, and the implementation planning
Technical project leader responsible for a Euro Transition project within the VAT department: analyzed the
software, the data-flows, and the transition requirements; managed a small team of programmers;
coordinated the integration and a simulation on two regional sites; zero "bug" during the Euro transition
Technologies: BULL GCOS8, WANG VS, SIEMENS BS2000, COBOL, Microsoft Visio
2001 - 2001 Client: European Commission, DG Research, Ampere Project (European Research Funding)
Achievements:
Rewrote the software user’s manuals in English and French
Took part in the maintenance of the software
Technologies: UNIX, Oracle, Designer 2000, Developer 2000, Microsoft VSS
2001 - 2001 Client: Boulanger SA (Retail), Datawarehouse project
Achievements:
Designed and developed components aimed to load the stocks data from SAP into a new datamart
Technologies: SAP, UNIX, Oracle, Designer 2000, SQL*Loader
2000 - 2001 Client: Eurocontrol (European Air Traffic Management), HR Applications
Achievements:
Re engineered and rewrote the calculations and currencies conversions of the sickness fund system
Carried out improvements on the Effort Accounting System (activity management and reporting)
Developed data interfaces between the existing HR databases and PeopleSoft
Technologies: UNIX, Oracle, Developer 2000, Forms 3.0, Report 1.0, PL/SQL, PRO*C, PeopleSoft, BO
1999 - 1999 Client: Groupe S (Payrolls)
Achievements:
Optimized an Oracle data interface and participated in the Year 2000 transition of the payroll application
Technologies: VAX/VMS, COBOL, ORACLE, SQL, PRO*COBOL
1997 - 1999 Client: ING Belgium, Clients and Accounts Services
Achievements:
Rewrote all the batch programs updating the clients and contract masters: 80% of the nightly processing
time was saved; was also in charge of a monthly statistical analysis and optimization of data servers
Developed a package aimed to help recover lost clients, including automatic banking facilities (Self-Bank)
Technologies: Mainframe UNISYS A-series, COBOL, Merise
1991 – 1997 Software Engineer, Data specialist France / Switzerland / UK
Various assignments for which I have covered the whole project life-cycle and specialized in databases, data
quality management and optimization, and reporting
Clients: mostly financial and public services, for GFI (IT), UNISYS (IT), CIIRMA (Insurance), Crédit Agricole
(Banking), Gendarmerie Nationale (Army), CVC (Champagne Industry)
Technologies: UNIX, Oracle, SQL*Forms and Report, PL/SQL, PRO*C, Cobol (Mainframes), AS/400, RPG, BULL
Questar / Unisys B-20, C-tos ADS / Hexalis (L4G)
Example in the banking industry:
Geneva, with Unisys Switzerland: I participated in the development of the Private Banking package
Newbanking (Assets/Wealth Management). In particular:
developed and integrated client-specific functions (Bearbull, Pictet)
modularized the data accesses prior to migrate the system to Oracle/SQL
EDUCATION
2007-2012 Continuing education for working adults: Management, Accounting, HR Erp's, UML & Java
2004-2005 Master’s degree in Business Intelligence “IIDEE” at LYON II University
Datawarehouse modeling – Data Management – Data mining – Machine Learning – UML, XML
1995-1996 Degree in Computer Science with specialization in UNIX at PARIS-X University
1988-1990 D.U.T. Informatique at REIMS University (Bachelor in Computer Science)