Resume

Sign in

Sr FP&A Analyst

Location:
Oakland, CA
Posted:
March 26, 2018

Contact this candidate

Resume:

Gilles Masselot

*** ******** ******, ***** *******

510-***-****

ac4xp9@r.postjobfree.com

Solid Excel user comfortable with manipulating large data sets from multiple sources, analytical thinker and very open minded with 10+ years as high performing team player in challenging cross-functional positions and multicultural environments. Functional experience in SaaS companies includes FP&A, Financial Modeling, Data Intelligence, Sales Compensation, CRM and Business Development. Strengths: solid competencies in building complex reports, passion to automate and streamline processes for scalability, consistent and effective with a can-do-attitude and high attention to detail. KEY ACCOMPLISHMENTS

Reduced $900K+ of labor cost by optimizing reporting process

Decreased the failure rate from 15% to 3% by streamlining the compensation plan production process

Converted 30% of key clients to E-commerce/Paperless solutions, resulting in high cost saving

Increased €400K of annual net profit by initiating & managing the development of a new sale area PROFESSIONAL HISTORY

ESSENCE GLOBAL, San Francisco March 2017 - Today

World’s largest digital marketing agency

Sr FP&A & Data Analyst (Consultant)

• Design and build robust Business Measurement and Data Dashboards, from scratch to final product, including heavy financial modeling: actual vs budget reconciliation, variance analysis, resource utilization, and large variety of reports for Executive, Operations, HR and Marketing projects.

• Develop BI dashboards, data models and reports using Looker. Control and validate integrity of the data following the migration of database from multiple systems to BI tool.

• Gather and combine data from multiple systems to prepare complex models and ad-hoc variance reports, support for special projects and initiatives at the request of the executive leaderships.

• Run periodic reports and assist regional finance groups with the follow up on actions taken for the reconciliation between Actuals and Budget.

DOCUSIGN, San Francisco Jan 2016 – Dec 2016

Sales Compensation & Data Analyst

• Responsible to produce all the compensation plans, set-up and managed the calculations in the Macro file used as source of truth.

• Process Management including data gathering and analysis, best practice research, process mapping, developing and recommending alternatives for improvement.

• Streamlined and improved the process for scalability, reduced the failure rate from 15% to 3% only.

• Created audit tools and performed data analysis to guarantee the data integrity along the process and the reconciliation between systems and Payroll.

• Set up metrics to control and track the distribution flow providing full transparency to the stakeholders. 3D - ORANGE BUSINESS SERVICES, Marseille, France Oct 2008 – May 2015 Industry leader in France and worldwide operator & integrator of communication services Business Developer

• Prospected and sold Fleet Management and Geolocation software solutions to company leaders.

• Responsible of the full sales cycle from prospection to closing deals. Developed account portfolio, responsible for the management of sales and the relationship with customers.

• Initiated and managed the development of a new sale area, resulting in €400K of annual net profit.

• Demonstrated success in exceeding goals, top 3 in national sales challenge in the last consecutive. years, and numerous awards for excellence.

Gilles Masselot

Resume, Page Two

MAERSK, Paris, France 2000 – 2008

World leader in sea transport and logistics

Sales & Marketing Reporting Manager

• Leaded the development and preparation of comprehensive reports to support decision making, analyzed operating performance and sale forecasts, weekly monthly/quarterly analysis and reporting.

• Proposed and prioritized changes to reporting and creating additional metrics / processes based on evolving requirements.

• Key-role by analyzing and reconciling data from large dataset to calculate sales revenue used for the calculation of individual sales bonus, ROI analysis, extensive use of Excel, Hyperion and SAP- Business Object.

• Leveraged multiple sales data sources to exploit data for the analysis of marketing campaigns, strategic events and sales pipeline. Actively contributed to the FP&A, budget and forecast preparation.

• E-commerce/Paperless: country project manager, managed the promotion of digital solutions and the conversion of the national key clients.

• CRM administrator: coordinated the national implementation of a new CRM system, guaranteed the data integrity, owned day-to-day monitoring and long-term administration of the application, trained the new users.

EDUCATION, AWARDS and COMPLEMENTARY BUSINESS SKILLS

• European Bachelor’s degree in Finance & Economics, International School of Economics, HES – Rotterdam, The Netherlands

• National Diploma in Business studies, all areas of economics, University of Lille II, France

• Extensive Foreign Work and Travel Experience in Europe, Asia and the US

• Passion in converting standard bicycles into electric bicycles

• IT: expert in Excel, VBA, proficient with MS Access, PowerPoint, SAP-BusinessObject, Hyperion, SQL, SFDC, Looker.

LinkedIn profile:

https://www.linkedin.com/in/gilles-masselot-2549661/



Contact this candidate