Marie Julien

• In charge of P&L + closing – Calculated monthly income statement and three-month forecasts – Analyzed profitability vs. budget and forecast by platform and segment (bridges)

• Saved department time by redesigning financial reporting tools (inventory, revenues) – Improved reliability of information in a non-SAP environment

• Partnered with logistics department to improve stock valuation and rotating inventory deployment

• Audited operational cycles according to LSF requirements (Sarbanes-Oxley French equivalent: Loi de Sécurité Financière) – Monitored action plans to render the subsidiary more compliant

(VIE one year)

Sector: Automobile

• Created the reporting package for Office with focus on client type, revenue type, version mix

• Partnered with the Windows marketing director to implement a monthly scorecard with key metrics

• Drafted the Excel template for Office budget

• Consolidated reporting for monthly closings, Mid Year Review and Budget

• Compiled statistical data to reveal past forecasting tendency of agency directors and challenge their forecast accuracy

(6 months internship)

Sector: High Tech

• Provided input for business engineers quarterly compensation by line of business and by sales territory – Documented special cases and defended them in front of the quota payment commission

• Compiled quarterly studies about top product sellers and best salespersons

• Initiated migration of monthly consolidation reporting tools from Lotus 123 to Excel – Sought support from Lotus 123 users – Provided formation on MS Excel

• Translated complex and dispersed information into an easily understandable forecasting tool using data analysis software (Brio) – Interviewed the owners of information – Translated their qualitative input into technical conditions – Tested coherence of results

(one year internship)

Sector: High Tech

• Analyzed balance sheet, P&L, cash-flow statement and financial ratio of Nantes corporations

• Evaluated risk and accordingly rated these corporations

(2.5 months internship)

Sector: Banking