Menu

Mickael SAMY

PONCELLE

En résumé

Mes compétences :
Business Objects
Reconciliations
Oracle 11g
XML
Sybase Power Designer
Microsoft SQL Server
Impact analysis
Financial Report Writing
DB2
BusinessObjects Web Intelligence
XSL
XPath
XML Schema
User support and training
User support
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
Profit and Loss Accounts
Olympic
MySQL
Mantis
Linux
Life Insurance
Gap Analysis
Fund Accounting
Functional analysis
Firebird
ETL
Design and development of flows and reports
Change request management
Business Analysis
Adobe Indesign
Adobe

Entreprises

  • OKTOPUS consulting S.A. - Business Development Manager

    2015 - maintenant Role played:
    * Strengthening of the current network of the company ;
    * Creation of new business line linked to Business Analysis activities ;
    * Recruitment and staffing ;
    * Review of the corporate identity and communication of the company (corporate presentation, public website)
  • OKTOPUS consulting S.A. - Business Development Manager

    2015 - maintenant Role played:
    * Strengthening of the current network of the company ;
    * Creation of new business line linked to Business Analysis activities ;
    * Recruitment and staffing ;
    * Review of the corporate identity and communication of the company (corporate presentation, public website)
  • Raiffeisen Bank - Consultant - Business Intelligence

    2014 - 2015 ``Finance Internal Control'' project:

    Aim of the project: Enhance and automatize the daily and monthly reconciliation of the accounting system

    Role played:
    * Impact analysis. ;
    * Automatization of the reconciliation process. ;
    * Design and development of flows and reports.

    Tools used: Pentaho Data Integrator V5, Oracle 11g, Zeb profit, T24.
  • Raiffeisen Bank - Consultant - Business Intelligence

    2014 - 2015 ``Finance Internal Control'' project:

    Aim of the project: Enhance and automatize the daily and monthly reconciliation of the accounting system

    Role played:
    * Impact analysis. ;
    * Automatization of the reconciliation process. ;
    * Design and development of flows and reports.

    Tools used: Pentaho Data Integrator V5, Oracle 11g, Zeb profit, T24.
  • Nomura Bank - Consultant - Business Intelligence

    2014 - 2014 ``Renaitre'' project:

    Aim of the project: Desynchronization of the reporting, through a custodian and fund accounting view.

    Role played:
    * Impact analysis. ;
    * Automatization of the reconciliation process, from PDF to database. ;
    * Integration of reports on SharePoint.

    Tools used: Helpsystem Showcase 9, SSRS 2008, DB2, XML, SharePoint 2010, Olympic.
  • Nomura Bank - Consultant - Business Intelligence

    2014 - 2014 ``Renaitre'' project:

    Aim of the project: Desynchronization of the reporting, through a custodian and fund accounting view.

    Role played:
    * Impact analysis. ;
    * Automatization of the reconciliation process, from PDF to database. ;
    * Integration of reports on SharePoint.

    Tools used: Helpsystem Showcase 9, SSRS 2008, DB2, XML, SharePoint 2010, Olympic.
  • NPG Wealth Management (Luxembourg) - Consultant - Business Intelligence

    2012 - 2014 ``Firebird'' project:

    Aim of the project: Migration of all NPG companies' policy management systems onto a unique system.

    Role played:
    * Definition of the financial reporting scope. ;
    * Establishment of the financial reporting requirements. ;
    * Choice of the technical solution to produce and publish reports. ;
    * Advice on the current data warehouse architecture. ;
    * Specification, development, and testing of actuarial reports Moses ;
    * Creation of datamarts to cover mailing needs. ;
    * User support. ;
    * Training and coaching on the use of reporting platform. ;
    * Automation of external NAV file import. ;
    * Definition of workflow of management of tickets through Mantis bug reporter. ;
    * P.O.C. on Qlikview.
    * P.O.C. on S.S.I.S..

    Tools used: BO XI r2, Data exchanger, SSIS 2010, Oracle 11g, Mantis, Custy PA/UA FLC, Agresso.
  • NPG Wealth Management (Luxembourg) - Consultant - Business Intelligence

    2012 - 2014 ``Firebird'' project:

    Aim of the project: Migration of all NPG companies' policy management systems onto a unique system.

    Role played:
    * Definition of the financial reporting scope. ;
    * Establishment of the financial reporting requirements. ;
    * Choice of the technical solution to produce and publish reports. ;
    * Advice on the current data warehouse architecture. ;
    * Specification, development, and testing of actuarial reports Moses ;
    * Creation of datamarts to cover mailing needs. ;
    * User support. ;
    * Training and coaching on the use of reporting platform. ;
    * Automation of external NAV file import. ;
    * Definition of workflow of management of tickets through Mantis bug reporter. ;
    * P.O.C. on Qlikview.
    * P.O.C. on S.S.I.S..

    Tools used: BO XI r2, Data exchanger, SSIS 2010, Oracle 11g, Mantis, Custy PA/UA FLC, Agresso.
  • Lombard International Assurance - Business Intelligence Specialist

    2010 - 2012 ``B.I. Information Management'' project:

    Aim of the project: Redesign of the entire capacity of reporting with a new platform, a new reporting catalogue and set up of a new organisation.

    Role played:
    * Definition of analytics, indicators and set of reports with the different department. Creation and testing of flows, universes and reports. Training of end user to build ad hoc reports. Validation of the output with the business.
    * Build-up of Datamart to support specific market needs (fiscal attestation scope).
    * B.I. Leader on Client Services and Private wealth solution department, designation of the organization and processes with the users, follow up and support of the end-user needs.
    * Development of flows using BODS

    Tools used: BO XI 3.x, SAP Data Services, PowerDesigner 15, Jira, BSB Solife.
  • Lombard International Assurance - Business Intelligence Specialist

    2010 - 2012 ``B.I. Information Management'' project:

    Aim of the project: Redesign of the entire capacity of reporting with a new platform, a new reporting catalogue and set up of a new organisation.

    Role played:
    * Definition of analytics, indicators and set of reports with the different department. Creation and testing of flows, universes and reports. Training of end user to build ad hoc reports. Validation of the output with the business.
    * Build-up of Datamart to support specific market needs (fiscal attestation scope).
    * B.I. Leader on Client Services and Private wealth solution department, designation of the organization and processes with the users, follow up and support of the end-user needs.
    * Development of flows using BODS

    Tools used: BO XI 3.x, SAP Data Services, PowerDesigner 15, Jira, BSB Solife.
  • Lombard International Assurance - Senior Analyst Developer

    2009 - 2010 Business Support:

    Aim of the team: Hotline for support of level 1 to 2 on all the business topics.

    Roles played:
    * Ad hoc, Hotfixes, and pre-analysis of the issues reported.
    * Explanation of the different analytics shown in the report to user.
    * User coaching.
    * Change request management.

    Tools used: BO XI 3.x, Jira, BSB Solife.
  • Lombard International Assurance - Senior Analyst Developer

    2009 - 2010 Business Support:

    Aim of the team: Hotline for support of level 1 to 2 on all the business topics.

    Roles played:
    * Ad hoc, Hotfixes, and pre-analysis of the issues reported.
    * Explanation of the different analytics shown in the report to user.
    * User coaching.
    * Change request management.

    Tools used: BO XI 3.x, Jira, BSB Solife.
  • Lombard International Assurance - Report Analyst & Developer

    2007 - 2009 ``Class Letters'' project:

    Aim of the project: Quality check of the output of the policy management tool.

    Roles played:
    * Analysis and creation of rules of standardisation of the output of the core system (naming convention-layout standard-methodology).
    * Development and maintenance of the quality of the output of the policy management tools (170 letters and operational reports). User Acceptance Testing.

    ``Lord'' project:

    Aim of the project: Completion of a reporting system based on the corporate DWH.

    Roles played:
    * Installation, administration and deployment of B.O. platform, creation and maintenance of universes, Web Intelligence - Desktop intelligence (Development of reports). Ensure the UAT.
    * Development of the corporate Embedded Value file (to feed Prophet) based on the actuary needs.

    Tools used: BO XI 2, SAP Data Services, PowerDesigner 15, Scriptura V4.0, BSB Solife
  • Lombard International Assurance - Report Analyst & Developer

    2007 - 2009 ``Class Letters'' project:

    Aim of the project: Quality check of the output of the policy management tool.

    Roles played:
    * Analysis and creation of rules of standardisation of the output of the core system (naming convention-layout standard-methodology).
    * Development and maintenance of the quality of the output of the policy management tools (170 letters and operational reports). User Acceptance Testing.

    ``Lord'' project:

    Aim of the project: Completion of a reporting system based on the corporate DWH.

    Roles played:
    * Installation, administration and deployment of B.O. platform, creation and maintenance of universes, Web Intelligence - Desktop intelligence (Development of reports). Ensure the UAT.
    * Development of the corporate Embedded Value file (to feed Prophet) based on the actuary needs.

    Tools used: BO XI 2, SAP Data Services, PowerDesigner 15, Scriptura V4.0, BSB Solife
  • Lombard International Assurance - Developer

    2005 - 2007 ``Class'' project:

    Aim of the project: Set-up of a new policy management system.

    Roles played:
    * Creation and maintenance of test scripts for non-regression, and new features deployed on the policy Management system. ;
    * User coaching on the use of the application. ;
    * Development and maintenance of the outputs ( letters and operational reports) of the core system.

    Tools used: XML/XSL FO - Scriptura designer - QF Test.

    ``Reporting'' project:

    Roles played:
    * Migration of Business Objects 6.5 to Business Objects XI, development. ;
    * User support and training.

    Tools used: BO XI 2, Scriptura V4.0, BSB Solife
  • Lombard International Assurance - Developer

    2005 - 2007 ``Class'' project:

    Aim of the project: Set-up of a new policy management system.

    Roles played:
    * Creation and maintenance of test scripts for non-regression, and new features deployed on the policy Management system. ;
    * User coaching on the use of the application. ;
    * Development and maintenance of the outputs ( letters and operational reports) of the core system.

    Tools used: XML/XSL FO - Scriptura designer - QF Test.

    ``Reporting'' project:

    Roles played:
    * Migration of Business Objects 6.5 to Business Objects XI, development. ;
    * User support and training.

    Tools used: BO XI 2, Scriptura V4.0, BSB Solife
  • Goodyear - Trainee

    Rueil-Malmaison 2004 - 2004 Internship

    Degree Thesis - ``Improvement of a network monitoring platform'',

    Roles played:
    * Measure of router's response time using multithreading.
    * Upgrade of the network monitoring platform, integration of the disruption time in the frame relay line reports.

    Tools used: PHP- MySql-C-Linux.
  • Goodyear - Trainee

    Rueil-Malmaison 2004 - 2004 Internship

    Degree Thesis - ``Improvement of a network monitoring platform'',

    Roles played:
    * Measure of router's response time using multithreading.
    * Upgrade of the network monitoring platform, integration of the disruption time in the frame relay line reports.

    Tools used: PHP- MySql-C-Linux.

Formations

  • Haute Ecole D'Etude Supérieur De Namur (Namur)

    Namur 2002 - 2004 Bachelors Degree
  • Haute Ecole D'Etude Supérieur De Namur (Namur)

    Namur 2002 - 2004 Bachelors Degree

Réseau

Annuaire des membres :