Frederic Pinchon, Marketing Analytics Developer in Sacramento, CA, United States
Frederic Pinchon

Marketing Analytics Developer in Sacramento, CA, United States

Member since January 31, 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.
Frederic is now available for hire

Portfolio

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

Experience

Location

Sacramento, CA, United States

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.

Employment

  • 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 BW, SAP

Experience

  • Visualize Customer Cohorts
    http://insightsthroughdata.com/customer-cohorts-and-product-sequence-with-orders-data/

    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.

Skills

  • Platforms

    Alteryx, Marketo, Salesforce
  • Other

    Data Queries, Fivetran, APIs, Google BigQuery, Marketing Analytics, Strategy, Data Analysis, SAP BW, SAP, Trade
  • Languages

    Snowflake, SQL
  • Tools

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

    SQL Server 2012
  • Industry Expertise

    Accounting

Education

  • Master's Degree in Business Administration (MBA)
    2005 - 2007
    Kellogg School of Management at Northwestern University - Evanston, IL
  • Bachelor's Degree in International Business Administration
    1991 - 1995
    ESSEC Business School - Paris, France

Certifications

  • Tableau Desktop Certified Professional
    SEPTEMBER 2019 - PRESENT
    Tableau Software

To view more profiles

Join Toptal
Share it with others