Frederic Pinchon, Developer in Sacramento, CA, United States
Frederic is available for hire
Hire Frederic

Frederic Pinchon

Verified Expert  in Engineering

Marketing Analytics Developer

Location
Sacramento, CA, United States
Toptal Member Since
March 11, 2021

Frederic has 10+ years of business analytics experience in enterprise BI deployment in the SAP ecosystem and marketing strategy at Microsoft. He now runs a consulting business, providing turnkey solutions such as funnel optimization, customer usage, and conversions to Agile self-service analytics for sales and marketing teams. He can ignite and sustain actionable growth strategies, use data insight, bridge technical and business roles, and develop custom API extractions for marketing platforms.

Data QueriesTableauSQLSnowflakeMarketoGoogle AnalyticsData AnalysisMicrosoft Power BISQL Server 2012Alteryx

Portfolio

Alteryx
SQL, Tableau, Alteryx, Google Analytics, Elastic
Harmonic
Tableau, SQL Server 2012
Microsoft
Microsoft Power BI, SQL Server 2012

Experience

Marketing Analytics - 10 yearsTableau - 8 yearsSQL - 6 yearsSalesforce - 6 yearsAlteryx - 4 yearsSnowflake - 4 yearsAPIs - 4 yearsFivetran - 3 years

Availability

Part-time

Preferred Environment

Snowflake, Tableau, Alteryx, Fivetran, APIs, Marketo, Salesforce, Stitch Data, Google Analytics, Google BigQuery

The most amazing...

...analysis I've developed is an email performance dashboard that shows how much pipeline value each email generates, using custom developments on Marketo's API.

Work Experience

Business Operations Director

2014 - 2017
Alteryx
  • Built the first marketing analytics stack for the CMO from scratch. Used Redshift, Alteryx, and Tableau Server.
  • Expanded analytics in the second year to cover products and sales and built a team of analysts. Reported to the VP of strategy.
  • Grew the team and analytics to cover the whole organization. Reported to the CFO in my third year, the IPO year for Alteryx.
Technologies: SQL, Tableau, Alteryx, Google Analytics, Elastic

Senior Customer Analytics Manager

2013 - 2014
Harmonic
  • Designed and built an accounts analytics data warehouse platform (Customer360) to identify growth opportunities across the global customer base and product divisions.
  • Led an RFP and deployed Tableau Server for enterprise analytics and Informatica Cloud for enterprise master data management (MDM) platform and operations automation.
  • Led global sales teams through the annual account planning and forecasting exercise, with the design and distribution of sales planning tools to lock down annual goals.
Technologies: Tableau, SQL Server 2012

Senior Marketing Manager

2007 - 2013
Microsoft
  • Enabled field sellers and marketers to identify account-level revenue growth opportunities among all US accounts by designing and landing quantitative whitespace models based on license installed base for the US subsidiary's VP of marketing.
  • Led marketing and program management of the influencer program for security service partners. Grew the first worldwide incentive program from 400 to 1,800 active SI partners, amounting to an influence on 30% of the standalone security revenue.
  • Pioneered the integration of licensing compliance model tools to provide aggregated views of licensing installed base, expanded worldwide.
Technologies: Microsoft Power BI, SQL Server 2012

Business Intelligence Manager

2001 - 2005
Business & Decision
  • Collaborated with a team of five SAP experts and the VP of tax to design a cutting-edge solution for a large consumer product company's tax decision support system to mitigate tax spend while adhering to tax code compliance, saving $400 million.
  • Managed a six-person team to design and implement a reseller profitability solution for another large CPG company in the US, followed by its European subsidiary, enabling senior management to implement strategic channeling decisions.
  • Organized post-launch operations and performance tuning and led the HR maintenance team reporting on the 45,000 employees of a European oil and gas account, ultimately saving 20% in processing costs.
Technologies: SAP Business Warehouse (BW), SAP

Visualize Customer Cohorts

Whether you work in B2B or B2C, getting a better understanding of customer or account transactions in the sequence is core. Customer cohorts show you how well you are acquiring new customers and are they conducting repeat business with you. Product sequence will help you identify which products are getting traction with your customers. Are the sales for one product or a category just first-time trials, or do customers return for repeat purchases of the same product? Working with many references/SKUs, orders, and customers will bring Excel down to its knees before you know it. You need a solution that can scale!

Custom GL Analytics with QuickBooks API

http://insightsthroughdata.com/use-api-with-alteryx-to-import-quickbooks-gl-reports-to-tableau/
QuickBooks Online delivers a variety of great reports online, and the tools offered to developers are top-notch. The reports themselves could use a more visual take. It is possible to make the accounting data available to a database to serve as a BI tool and take the data set to the next stage, with scenarios such as time series, forecasts, or various predictive models. Extracting that data and normalize it is still quite a challenge. This project shows the steps to import a GL report from a sandbox all the way to Tableau, using QuickBooks API, Alteryx, Snowflake, and Tableau. The logic still applies to alternative tools.

Platforms

Alteryx, Marketo, Salesforce

Other

Data Queries, Fivetran, APIs, Google BigQuery, Marketing Analytics, Strategy, Data Analysis, SAP Business Warehouse (BW), SAP, Trade

Languages

Snowflake, SQL

Tools

Tableau, Stitch Data, Google Analytics, Elastic, Microsoft Power BI

Storage

SQL Server 2012

Industry Expertise

Accounting

2005 - 2007

Master's Degree in Business Administration (MBA)

Kellogg School of Management at Northwestern University - Evanston, IL

1991 - 1995

Bachelor's Degree in International Business Administration

ESSEC Business School - Paris, France

SEPTEMBER 2019 - PRESENT

Tableau Desktop Certified Professional

Tableau Software

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring