Functional Skills
Business Analysis
Business Analytics
Business Intelligence
Communications
Data Engineering
Data Mining
Data Modeling
Data Science
Data Visualization / Reports
Project Management
SQL Analysis
Data Analysis
Data Architecture
Data Transformation
Database Administration
Software Skills
Alteryx
AWS
Azure
Domo
Google Cloud Platform
Jupyter notebook
Machine Learning
Microsoft Excel
PowerBI
Python
R
Snowflake
SQL
Tableau
Looker
Sector Experience
Automotive
Business Services
Healthcare
Technology
Transportation & Logistics
Languages
English
Notable Clients
Humana
Experience
Moody Bible Institute
Marketing
Marketing Data Manager
2/2024 - Present
● One of two data managers reporting to the Director of BI & Market Research and responsible for supporting MBI with quality business data including marketing and admissions data as they seek to increase enrollments between 5-10% year-over-year.
● Analyze prospective lead lists with over 275,000 contact details to remove low-quality lists and generate qualified lead sources for a campus recruitment team of 4 people.
● Drove a data cleanup of prospective lead records, identifying over 10K duplicate entries using Salesforce and Power BI in the first 60 days.
● Provide stakeholders with quality data for reports and metrics from 3 campuses and online, 44 programs, and international marketing campaigns to foster interest and grow enrollment.
● Partner with multiple business stakeholders (digital marketing, education, publishing, radio &
podcasts) to improve existing data models using Oracle PL/SQL, Power BI, DAX, and M code producing more reporting in Power BI.
● Analyze prospective lead lists with over 275,000 contact details to remove low-quality lists and generate qualified lead sources for a campus recruitment team of 4 people.
● Drove a data cleanup of prospective lead records, identifying over 10K duplicate entries using Salesforce and Power BI in the first 60 days.
● Provide stakeholders with quality data for reports and metrics from 3 campuses and online, 44 programs, and international marketing campaigns to foster interest and grow enrollment.
● Partner with multiple business stakeholders (digital marketing, education, publishing, radio &
podcasts) to improve existing data models using Oracle PL/SQL, Power BI, DAX, and M code producing more reporting in Power BI.
Digital&
Marketing
Digital Marketing Data Analyst
10/2023 - 6/2024
● One of the two analysts who reports directly to the owner and lead analyst, and is responsible for maintaining the BigQuery data warehouse and Power BI reports and dashboards.
● Adjust, monitor, and create new ad bids and campaigns utilizing Google Ads, Bing Ads, Facebook Ads, and LinkedIn Ads while managing 3-6 figure budgets.
● Oversee a variety of client data ranging from 2-500 employees, website tracking, ad spend, and ad campaigns to deliver a 10:1 return on ad spend (ROAS) within Google Ads and Google Analytics.
● Manage ad campaigns for clients across consulting, data management and synchronization, and
technology industries within the midwestern region.
● Develop standard operating procedures for utilizing BigQuery, Power BI, and Google Analytics
reducing onboarding time by 20%.
● Generated $400K in revenue over 6 months by maximizing a multi-location senior living community
client campaign performance in Google Ads.
● Maintain an account-wide optimization score of 94%.
● Adjust, monitor, and create new ad bids and campaigns utilizing Google Ads, Bing Ads, Facebook Ads, and LinkedIn Ads while managing 3-6 figure budgets.
● Oversee a variety of client data ranging from 2-500 employees, website tracking, ad spend, and ad campaigns to deliver a 10:1 return on ad spend (ROAS) within Google Ads and Google Analytics.
● Manage ad campaigns for clients across consulting, data management and synchronization, and
technology industries within the midwestern region.
● Develop standard operating procedures for utilizing BigQuery, Power BI, and Google Analytics
reducing onboarding time by 20%.
● Generated $400K in revenue over 6 months by maximizing a multi-location senior living community
client campaign performance in Google Ads.
● Maintain an account-wide optimization score of 94%.
OPENLANE
Data Science / Analytics
BI Engineer
5/2022 - 2/2024
● On a team of 6 BI Engineers, was solely responsible for maintaining pipelines powering the entirety of the operations department (500+ employees) reports making data-driven business decisions as the company grew 8% year-over-year.
● Monitored the performance of 400+ inspectors and 100+ regional operations managers covering the contiguous US to align with the complete rollout of a Salesforce Lightning app for streamlining appointment scheduling for 25,000+ dealerships and supplemental pay for all contract inspectors.
● Created a custom pipeline to monitor company-wide adoption for inspectors app with an adoption rate of 46% in 2023.
● Continually monitor arbitration claims data to reduce expenses by 500K in 2023
● Discover hidden reporting requirements, streamline reporting procedures, and establish and maintain
dependable ETL pipelines and dataflows within DOMO resulting in $100M in revenue growth.
● Developed statistical and predictive models in Python to identify a dollar value tha
● Monitored the performance of 400+ inspectors and 100+ regional operations managers covering the contiguous US to align with the complete rollout of a Salesforce Lightning app for streamlining appointment scheduling for 25,000+ dealerships and supplemental pay for all contract inspectors.
● Created a custom pipeline to monitor company-wide adoption for inspectors app with an adoption rate of 46% in 2023.
● Continually monitor arbitration claims data to reduce expenses by 500K in 2023
● Discover hidden reporting requirements, streamline reporting procedures, and establish and maintain
dependable ETL pipelines and dataflows within DOMO resulting in $100M in revenue growth.
● Developed statistical and predictive models in Python to identify a dollar value tha
CIEK Solutions
Data Science / Analytics
Data Manager
8/2022 - 12/2022
● Developed data pipeline using Python to deliver data during the year-end medicare insurance open enrollment campaign that reached 1.3M+ people.
● Engineered BigQuery data warehouse to store client data, power KPI metrics, and provide business insights, leading to company growth of 10% year-over-year.
● Presented code and findings to leadership, replacing outdated Excel files and leading to 100% adoption in 2 months.
● Developed Google Analytics dashboard for small rental property management (100+ properties) clients to track monthly guest payments and decrease service appointment response to 24-hour response time.
● Engineered BigQuery data warehouse to store client data, power KPI metrics, and provide business insights, leading to company growth of 10% year-over-year.
● Presented code and findings to leadership, replacing outdated Excel files and leading to 100% adoption in 2 months.
● Developed Google Analytics dashboard for small rental property management (100+ properties) clients to track monthly guest payments and decrease service appointment response to 24-hour response time.
enVista
Data Science / Analytics
Data Analyst
7/2021 - 4/2022
● Reduced monthly report delivery time by 50% by automating data gathering and ETL pipeline.
● Helped the sales team negotiate ~10% savings on contracts by leveraging Python to scrape fuel
surcharges and carrier charges from UPS and FedEx.
● Provided contract add-ons by utilizing MySQL and Power BI to templatize reports to send to parcel
(B2C) shipping clients (5.11 Tactical, Peets Coffee, Vera Bradley) increasing visibility into their business.
● Helped the sales team negotiate ~10% savings on contracts by leveraging Python to scrape fuel
surcharges and carrier charges from UPS and FedEx.
● Provided contract add-ons by utilizing MySQL and Power BI to templatize reports to send to parcel
(B2C) shipping clients (5.11 Tactical, Peets Coffee, Vera Bradley) increasing visibility into their business.
Solutions Plus Consulting
Data Science / Analytics
BI Developer
1/2020 - 4/2021
● Leveraged custom SQL scripts to flatten nested (10+ layers) GTM legal review workflows for television commercials to reduce bottlenecks by 10%.
● Utilized Tableau to provide a major client (220,000+ employees) with 8 dashboards distilling complex data into an easy-to-understand format.
● Developed entity-relationship diagrams and data models for developing client's (500-1000+ employees) relational database with 150+ tables and 100M+ data points.
● Utilized Tableau to provide a major client (220,000+ employees) with 8 dashboards distilling complex data into an easy-to-understand format.
● Developed entity-relationship diagrams and data models for developing client's (500-1000+ employees) relational database with 150+ tables and 100M+ data points.