Summary
Overview
Accomplishments
Work History
Education
Skills
Timeline
Generic

Franck Rafiou

Data Analyst
Zofingen

Summary

Passionate financial controller with over 5 years of professional experience in a dynamic mid-sized enterprise managing BI tools, financial modeling and analysis, ensuring accurate inventory reconciliation worth over $50 million and general ledger maintenance within the ERP system. Interpret, analyze and deliver actionable performance reports on a month-end basis to department seniors and upper-management stakeholders to support strategic business decisions and help boost financial performance.

Overview

7
7
years of professional experience
7
7
years of post-secondary education
3
3
Languages

Accomplishments

  • Optimized COGS financial analysis tool to process calculations 50% quicker despite having 3 times more projects during deadline-driven tasks filled month-end closing.
  • Initiated sales cost activation & ERP recording of multiple infrastructure in the production department after taking over a longstanding incomplete recording set aside by the financial team.
  • As a result, the company saved $48/hr in billable hours for a dozen projects with over 200 hours each. Facilitated infrastructure budgeting accuracy.
  • Supplied Head of Sales with accurate & coordinated data package about project performances and top/worst performing clients, which led sales team to negotiate better PO terms and decreasing overbudget development projects by nearly 80% after less than 3 months.

Work History

Financial Analyst Controlling

Carbogen Amcis AG
Basel
01.2020 - Current
  • Performing costing analysis and reviewing monthly & quarterly budget performance reports of over 360 projects per year, ensuring departments and teams operated within allocated budgets and investigating excessive expenses to recognize discrepancies and promptly addressing key stakeholders for resolutions.
  • Completing ERP journal entries, reconciliations and general ledger analysis on COGS & inventory to prepare periodical financial packages within a deadline-driven environment to assist Head of Finance.
  • Streamlining complex analytics-derived data with business intelligence software to generate easy-to-understand insights & interactive visualizations for upper management

Part-Time Technician Supply Chain

Carbogen Amcis AG
Basel
01.2018 - 10.2020


  • Warehouse stock management in compliance with security & dangerous goods concept under GMP guidelines.
  • Verified clerical computations against physical count of stock to adjust errors.
  • Prepared variety of different written communications, reports and documents as interface between supply chain & other departments.

Assistant QS Administrator

Carbogen Amcis AG
Basel
09.2013 - 01.2015
  • Improved data accessibility for Quality Systems department by digitalizing & archiving over 1000 Quality Assurance/Quality Control folders systematically, establishing an improved file management and system integration within the current Good Manufacturing Practice (cGMP) guidelines.
  • GMP Compliant recording of more than 400 employee training certificates in the ERP database which was critical for internal and external quality audit success.


Education

Professional Certificate - Data Analytics

Google Career Certificates
Coursera.com
10.2022 - 01.2023

Bachelor of Arts - Applied Economics

Corvinus University of Budapest
Budapest, Hungary
08.2018 - 01.2021

No Degree - International Economics

BGE - University of Applied Sciences Budapest
Budapest, Hungary
05.2017 - 04.2021

Skills

    Financial planning - Financial reporting - Fp&a

undefined

Timeline

Professional Certificate - Data Analytics

Google Career Certificates
10.2022 - 01.2023

Financial Analyst Controlling

Carbogen Amcis AG
01.2020 - Current

Bachelor of Arts - Applied Economics

Corvinus University of Budapest
08.2018 - 01.2021

Part-Time Technician Supply Chain

Carbogen Amcis AG
01.2018 - 10.2020

No Degree - International Economics

BGE - University of Applied Sciences Budapest
05.2017 - 04.2021

Assistant QS Administrator

Carbogen Amcis AG
09.2013 - 01.2015
Franck RafiouData Analyst