Lionel Sarpong-Thouvenin

Lionel sarpong-thouvenin

bookmark on deepenrich
Followers of Lionel Sarpong-Thouvenin283 followers
  • Timeline

  • About me

    Senior BI Consultant at Cubewise - Author

  • Education

    • Lycée saint francois d'assise

      2002 - 2006
      Bachelor's degree mathematics speciality a level in sciences

      High School

    • Ecole internationale des sciences du traitement de l'information

      2011 - 2013
      Mastère spécialisé (bac + 6) business intelligence - informatique décisionnelle

      International School of Science and Information Processing (EISTI) specialized master degree (BAC + 6 years) in Business IntelligenceMaster thesis : Business Intelligence & Offshore, a possible future

    • Ecole internationale des sciences du traitement de l'information

      2008 - 2011
      Ingénieur management des systèmes d'information. option : business intelligence - informatique décisionnelle

      Activities and Societies: La Zoom (association Photo) Engineer school in Computer and management : International School of Science and Information Processing (EISTI), Business Intelligence Specialty (Master Degree)

    • Université de cergy-pontoise

      2006 - 2009
      Licence ufr sciences et techniques licence de mathématiques et licence d'informatique

      University of Cergy-PontoiseDegree, UFR Sciences and TechnicalMathematics degree and Computer degree

    • Ecole internationale des sciences du traitement de l'information

      2006 - 2008
      Classes préparatoires mathématiques supérieures et spéciales, physique, informatique

      International School of Science and Information Processing (EISTI), Preparatory School (two years degree) - Mathematics, Physics, Computer

  • Experience

    • Psa peugeot citroën

      Jun 2010 - Oct 2010
      Intern

      Internship - 5 months, 2010PSA Peugeot CitroënInvolved in a MOA team project (Project ownership) Missions: Standardization of information system & Reporting on purchase flow KPI : Dashboard, Feeding data management.Using SAP, SAP-BI and Excel (VBA)

    • Lobellia (ssii)

      Nov 2010 - Apr 2011
      Bi company project (student)

      BI company project - 5 months2010-2011Lobellia (SSII)Team leader in a whole BI project for firefighters: Design a Data warehouse for Fireman Watch management and fitted with the other existing applications: Project Management, ETL, Data warehouse, Reporting.Using MSBI (SSIS, SSAS, SSRS)

    • Ibm

      Apr 2011 - Dec 2014

      IBM France - GBS - BAO (BI practice)BI TM1 Consultant on a Budget planning and Simulation project : support a Medium-Term Plan by inputting simulation hypothesis of some key indicators (at different levels for different users population) within a top major international luxury group (CAC 40) Take part in all phases of the project :- Business Requirement- Prototype development- Data modeling & Design- Technical detailed specifications- Development (dimensions, cubes, TI process, management rules, reports,...) & Unitary tests- Integration tests- UAT with key users (travel in Australia, San Francisco,...)- TMA- Functional and Technical Administration TrainingsUsing Cognos TM1 - Environment : Citrix Show less IBM France - GBS - BAO (BI practice)BI TM1 Consultant on a Budget planning and financial consolidation project : multi countries project organized around a Core Model linked to specific countries TM1 instances and manage Actual, Budget, Long Term Plan,... within one of the top French international Transport CompaniesTake part in all phases of the project :- Business Requirement- Prototype development- Data modeling & Design- Technical detailed specifications- Development (dimensions, cubes, TI process, management rules, reports,...) & Unitary tests- Integration tests- UAT - TMA- Functional Administration Trainings- Intern supervisory (training, check, delegation of tasks,...)Using Cognos TM1 - Environment : Citrix Show less Final year Internship - 6 months, 2011IBM France - GBS - BAO (BI practice)Junior BI TM1 consultant on Budget planning projects within top of French international Transport CompaniesTake part in all phases of the project :- Business Requirement- Prototype development- Technical detailed specifications- Development (dimensions, cubes, TI process, management rules, reports,...) & Unitary tests- Integration tests- UAT Using Cognos TM1 - Environment : Citrix Show less

      • Consultant BI

        Sept 2014 - Dec 2014
      • BI Consultant

        Aug 2012 - Aug 2014
      • BI Consultant

        Oct 2011 - Aug 2012
      • Junior BI Consultant

        Apr 2011 - Oct 2011
    • Cubewise

      Feb 2015 - now

      Project manager - Internal SystemsWorld wide projects for the Cubewise group.Implementation of new platforms, development of new features, improvements and administration.Management and automation of the different flows between the different applications.Management of the flow Engage to Cash process * Opportunity management* Contract management* Project management * Resources management* Invoice management Plateforms : * CRM : Salesforce * ERP : Financialforce * Resources/Projects management : Mavenlink/Kantata * FPM solutions : Planning Analytics / Tm1 Regions : * Europe * Australia * North America Show less CubewiseBI Senior TM1 Consultant on a Budget planning and Simulation project with the development of a new Finance module in Apliqo C3 (pre-built Unified Performance Management Solution based on Cognos TM1)Revenue, Expenses, Balance Sheet, KPIComplex simulations rules and generic module about dataflows between multiple sources and mulitple targets- Prototype development- Data modeling & Design- Development- DocumentationTools : Cognos TM1 - Pulse - SQL - Apliqode - Apliqo C3 Show less CubewiseBI Senior TM1 Consultant on a Budget planning and Simulation project : Underwriting, Expenses and Reporting modules within a top major international reinsurance groupTop Down and Bottom-up approaches with complex simulations rules at different level of granularity.Links between multiple business modules and multiple Dataflows In/Out with the SQL database- Business Requirement- Prototype development- Technical detailled specifications/Documentations- Data modeling & Design- Development (dimensions, cubes, TI process, management rules, reports,...) & Unitary tests- UAT with key users- Functional and Technical administrationTools : Cognos TM1 - Pulse - SQL Show less

      • Project manager Internal systems

        Apr 2019 - now
      • Senior Consultant

        Oct 2016 - Apr 2019
      • Senior Consultant

        Jul 2016 - Sept 2016
      • Senior Consultant

        Feb 2015 - Jun 2016
    • Les maîtres de l'esprit

      Nov 2016 - now
      Author

      Literary author :Books* L'Obstacle (Heroic-Fantasy) - Les Maîtres de l'Esprit (Vol 1)Short stories* Siry (Science-fiction)Format : ebookLanguage : FrenchWebsite : http://thouveninlionel.wixsite.com/lesmaitresdelesprit

    • World fusion interior design

      Jun 2018 - now
      Co-founder and manager director

      Website : https://worldfusion-interiordesign.ch/

  • Licenses & Certifications

    • Ibm certified specialist - cognos tm1 10.1 data analysis

      Feb 2015
    • Ibm certified developer - cognos tm1 10.1

      Nov 2014
  • Volunteer Experience

    • Rover Team

      Issued by Scouts and Guides of France on Jul 2007
      Scouts and Guides of FranceAssociated with Lionel Sarpong-Thouvenin
    • Volunteer

      Issued by Deep Griha (ONG) on Jul 2008
      Deep Griha (ONG)Associated with Lionel Sarpong-Thouvenin