Business Operations Director
2014 - 2017Alteryx- 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, ElasticSenior Customer Analytics Manager
2013 - 2014Harmonic- 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 2012Senior Marketing Manager
2007 - 2013Microsoft- 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 2012Business Intelligence Manager
2001 - 2005Business & 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
Frederic Pinchon
Marketing Analytics Developer in Sacramento, CA, United States
Member since February 25, 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
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
Experience
- 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 APIhttp://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, SalesforceOther
Data Queries, Fivetran, APIs, Google BigQuery, Marketing Analytics, Strategy, Data Analysis, SAP BW, SAP, TradeLanguages
Snowflake, SQLTools
Tableau, Stitch Data, Google Analytics, Elastic, Microsoft Power BIStorage
SQL Server 2012Industry Expertise
Accounting
Education
- Master's Degree in Business Administration (MBA)2005 - 2007Kellogg School of Management at Northwestern University - Evanston, IL
- Bachelor's Degree in International Business Administration1991 - 1995ESSEC Business School - Paris, France
Certifications
- Tableau Desktop Certified ProfessionalSEPTEMBER 2019 - PRESENTTableau Software
