MATTHIEU DERLIQUE

• Ownership over US branch P&L and BS (Sales, stocks, margin, payroll, OPEX, CAPEX).
• Led multiple projects related to Sales Tax and Income Tax compliance.
• Built and automated group reporting (daily dashboard, means of payments, etc).
• Collaborated on the improvement and implementation of global retail cash management processes (EOD store closing, cash payments, etc.).
• Shortened the US branch monthly closing deadline by 5 business days.
• Automated the US branch monthly closing documents.
• Animated the budget for the US branch (Sales, COGS, OPEX, CAPEX).

• Collaborated on the design of the budgeting tools (OPEX, payroll, and CAPEX).
• Maintained the budgeting and P&L tools (MS Excel and SQL).
• Improved and automated the P&L tools (MS Excel).
• Valued multiple internal flows using various techniques (finished goods, semi-finished goods, and internal logistics).
• Analyzed the internal P&L for multiple business units (10M€ in OPEX).
• Performed ad hoc analysis on internal transfer prices for business units.

• Collaborated on the design of the budgeting tools (OPEX, payroll, and CAPEX).
• Maintained the budgeting and P&L tools (MS Excel and SQL).
• Improved and automated the P&L tools (MS Excel).
• Valued multiple internal flows using various techniques (finished goods, semi-finished goods, and internal logistics).
• Analyzed the internal P&L for multiple business units (10M€ in OPEX).
• Performed ad hoc analysis on internal transfer prices for business units.

• Remodeled and automated reportings (MS Excel, MS Query and Power BI)
• Linked the reportings to the ERP databases (MS Query and Power BI)
• Developed a sales forecasting tool (MS Excel)
• Audited specific production issues (defect finished products, overuse of raw materials)
• Participated in the annual budgeting process (Sales)
• Managed AR (reduced past-due invoices by 60% in 5 months)

• Remodeled and automated sales reporting (MS Excel, SQL and Power BI).
• Linked the sales reporting to the ERP databases (SQL and Power BI).
• Audited specific production issues (defect finished products, raw material waste).
• Developed a sales forecasting tool (MS Excel).
• Participated in the annual budgeting process (Sales).
• Managed AR (reduced past-due invoices by 60% in 5 months).