Trevor French

Data Scientist October 2023 - Present

Data Science Consultant October 2023 - Present

Supporting data science efforts such as taxpayer behavior classification for Treasury Department. IRS MBI/Staff-like access
Used Python (Boto3/Pandas) and SQL (Athena/Redshift/Postgres/NoSQL) to access and clean data stored in AWS

Analytics Manager April 2022 - October 2023

Successfully executed data science work on dataset with ~300MM records as required by a ~$1MM government contract
Implemented Agile concepts such as cross-functional stand-ups, planned sprints, Kanban boards, backlogs, etc. on analytics team to help us deliver iterative value to the business
Used trigonometry, R, ggplot, and open-source cryptocurrency data to help stakeholders visually identify non-compliance.
Worked with Sales Engineers/Solutions Architects/Customers/Partners to develop new data science revenue streams
Utilized Python, Pandas, and NumPy to develop a pricing API along with an analysis methodology which is being sold to fortune 500 fintech companies such as PayPal
Used SciPy to test hypotheses and identify relationships to inform major product decisions as well as federal policy
Developed k-Means clustering model with Scikit Learn and NumPy to help IRS identify users with certain characteristics
Trained two data analysts on Git and migrated our entire analytics codebase from Bitbucket to GitHub

Data Analyst September 2021 – March 2022

Created a suite of self-service data analysis tools using R Shiny which saved the business unit hundreds of hours of labor
Placed 2nd in annual hackathon by integrating with an ERP platform which laid the foundation for future product offerings
Mapped out data model and API specs for every mainstream crypto exchange to help engineering team quickly integrate
Used JavaScript to develop the OAuth flow and landing pages for a key customer integration
Used Python packages such as Beautiful Soup to scrape open-source data and create a model to estimate the number of tax forms that would be generated because of crypto trading. This influenced a ~$500MM system upgrade at the IRS
Utilized R to automatically assemble markdown reports which saved our SMEs hundreds of hours of manual effort.
Created an audit sampling methodology and a statistical proof that is used across all TaxBit’s business units and also used to support our SOC process
Created visualizations with business intelligence tools such as Domo, PowerBI, R Shiny, Mode, and Retool to help stakeholders quickly access and digest the information they needed to see

Data Analyst December 2020 – September 2021

Used forecasting techniques such as linear regression and ARIMA at Swire Coca-Cola to predict revenue, evaluate deals, and develop pricing strategy for an entire sales channel
Developed a pricing optimization model to reduce attrition and maximize margin during unprecedented COGS increases
Developed Python program to extract contract elements from photos to identify which customers were eligible for price increases
Created JavaScript app to track tasks in support of larger departmental campaigns. Used GitHub for versioning
Tested the hypothesis that enrollment in an online customer service program would lead to reduced churn
Used PowerBI to develop visualizations which tracked various go-to-market strategies

Territory Manager August 2019 – December 2020

Developed PowerBI reports and Excel spreadsheets to track territory performance and identify opportunities for growth
Optimized routing with a Node.JS app integrated with Google Maps which allowed me to see more customers per day

Analytics Manager April 2019 – July 2019

Held weekly standups and planned work in weekly sprints to coordinate progress across seven team members working on projects ranging from application development to labor and budget forecasting
Developed an application which was used to send texts and emails to thousands of students reminding them to register for classes

Data Analyst May 2018 – March 2019

Developed PowerBI dashboards to monitor key metrics and identify new opportunities for automation and/or training. Used R to create custom visualization cards
Used Node.js/Express/Postgres to develop an app which identified students that had not registered for classes, sent out text messages reminding them to register, and stored conversation history
Used RPA program named UiPath to automate interactions with our CRM program; however, we later made it more robust by directly integrating with the C#/JavaScript APIs resulting in the elimination of an entire “processing” sub-department
Leveraged Bayesian statistics to develop heuristics which informed an automatic email routing tool our team created
Used GitHub in conjunction with Heroku to support CI/CD pipelines as our team developed various web applications

Data Analyst Mar 2018 - Jul 2018

Scraped home price data using Google Apps Script and developed insights around demographic data and customer behavior