Nicolas - Consultant EXCEL

Ref : 100224L006

Domicile

59540 CAUDRY
Profil

Consultant (44 ans)
Statut

Freelance

Compétences

SQL

EXCEL

ESSBASE

Expériences professionnelles

Business and Process Analyst

AXA INSURANCE - Bruxelles
Jan 2016 - Jan 2017
*Finance Process Support in the Finance department
I'm leading several projects
- Analysis and implementation of a solution to requests for access to Finance tools.
- Harmonization of accounting data in systems (Mainframe/ BO webi & accounting tools)
- Testing and reporting new functionalities in ARIBA & SAP (invoices / reception)
- Implementation Process & Analysis of BCP (Business Continuity Plan)

*P&C Retail Non-Life (Team IT)
I’m leading several projects
- Requirement & evolution on the products (Fire, Non-Life)
- Testing End to End / Business Testing process
- Service Desk: Incident in production on the application Non-Life
Technical Environment: SAP (FI/CO) / ARIBA) / BO WEBI / SQL Developer / Mainframe Methodology: Testing / Quality Center / Clear Quest / Office 365
Business and Process Analyst

DELTALLOYD LIFE - Bruxelles
Jan 2014 - Jan 2015
Under the Solvency II project, in charge of preparing and setting up reports in accordance with the direction EIOPA.
- I described the process and narrative reports for the part Assets
- Testing and report QRT (Quantitative report template) for the group and the BNB
- Review of the implementation of the Gap analysis on the Assets
Technical Environment: SAP (Magnitude / RDS) / Excel (Macro) Methodology: Testing / Quality Center / Jira / Visio (Process)
Consultant fonctionnel

BNP PARIBAS FORTIS – Bruxelles
Jan 2010 - Jan 2014
Accounting control in the Finance department
As part of a migration project accounting, I was in charge of monitoring and controlling the daily accounting systems and participate to the closing office. I implemented process control and set up KPI progress of migration.

- I described the process of accounting flows and identify critical ways
- I identified the abend in the flow accounting and with the help of l’IT, we assisted the users of finance.
- I worked with project teams in the migration of the Belgium accounting in the new accounting tools, and participate in non-regression testing.
- Deliver documentation on process accounting and setting up check list of control in ‘Day to Day’
- Preparer the review accounting with the request BO XI
Technical Environment: Cognos BO XI / Access / Excel (Macro) / ERP (Oracle) Methodology: Testing / Quality Center / Helpdesk
Business Analyst / Team Leader project

MINISTERE DE L’ECONOMIE – Paris
Jan 2009 - Jan 2010
Accounting control in the Tax department.
Under the project Copernic, I was responsible for testing the tax and accounting developments impacting the professional. (Analyse and preparation of test execution, reporting daily test results, using the tool Quality Center for the bugs). I supervised two persons in the test fees.
Technical Environment: TOAD / Access / Excel (Macro) / ERP (Oracle) Methodology: Testing / Quality Center / Venezia (Bug) / Cycle V (Agile) / BPMN
Business Analyst

BNP PARIBAS – Paris
Jan 2008 - Jan 2008
Audit in the Finance department. As part of the harmonization of procedures for applications finance, I was in charge of making an inventory of the existing and establish a single procedure requests. (Automation / establish user profil)
Technical Environment: Access / Excel (Macro) Methodology: Testing (Quality Center)
Consultant fonctionnel

LVMH – Paris
Jan 2007 - Jan 2009
Accounting control in the Finance Department.
As part of the implementation of SAP FI / CO module for accounting reporting, I was responsible for checking integration of French GAAP / IAS accounting data into the SAP module and check refunds in output SAP
Technical Environment: TOAD / Access / Excel (Macro) / ERP (SAP) Methodology: Testing / Quality Center
Management of Control

ALLIANZ – Paris
Jan 2007 - Jan 2008
In the department finance, I was in charge of controlling the costs agencies in France and report information to the Management. I participated to the closing office to the present the financial results.
Technical Environment: Access / Excel (Macro)

Études et formations

School of management (Skema Lille (ESC LILLE))

2005

Autres compétences

PhD in Project Management
Technical & Methodology: PMI / Agile
Qualitative and Quantitative Research methods (Management Control)
Data analysis and Interpretation

2004 / 2005School of management (Skema Lille (ESC LILLE))

- Master 2 « Audit and Management Control » Cost Accounting
Evaluation and Control (Method ABC)

Technical & Methodology Skills
Excellent command of Pack office (Access / Excel / Power Point)
Business object XI
SAP FI / CO
ARIBA (Invoices) / Mainframe
Tools (Cristal / KDE (Ambre), Bo Reports)
SQL Developer
Incident & problem tracking system (Jira, Venezia, ALM)

Process : Visio & BPMN

Project : Agile and Waterfall methodology

Management Skills
Team spirit
Good Analytical and synthesis skills
Autonomy and ability in a dynamic and multi-cultural environment

Languages Skills
French and English