BUSINESS INTELLIGENCE | FORECASTING | AUTOMATION
I'M
Ryan Wheelwright.
01 PROFESSIONAL
PROGRAMMING
DATABASES
DATA WAREHOUSING
STATISTICAL MODELING
TOOLS
85%
80%
85%
skills
PROGRAMMING
.R, Python, SQL, NoSQL, MongoDB/JSON
BUSINESS INTELLIGENCE
Tableau, Power BI, Excel. RapidMiner, Qualtrics, Data Studio, Orange
DATABASES
Microsoft Access, MS SQL Server, MySQL, PostgreSQL, NoSQL, GCP, BQ, Spark
DATA WAREHOUSING
Star and Snowflake schema, Procedural SQL, Microsoft Azur
Chi-Square, T-Test, Two-Way ANOVA, Multinomial Logistic Regression
TOOLS
JIRA, SQL Server Management Studio, MySQL Workbench, PhpMyAdmin, SPS.
STATISTICAL MODELING
Recomendations
“Ryan was the primary analyst that supported me and our department of more than 700 employees data needs. He worked with multiple business stakeholders to ensure the accuracy and effectiveness of the products he created. The best quality about Ryan is his posture of gratitude and eagerness to partner with others. No matter the situation he approaches people with respect, honor, gratitude, and an eager to collaboratively solve problems.”
— Jess F. Senior Manager, Sunrun
pORTFOLIO
Experience
2022-2023
WHISTIC
Business Analyst
-
Developed 5 executive Tableau dashboards (39 visuals), providing a single source of truth and giving leadership real-time visibility into customer health metrics
-
Optimized 5 workbooks, 19 dashboards, and 173 charts, improving data accuracy and reducing dashboard load time for the CS leadership
-
Drove analytics adoption by delivering weekly Tableau training to CS and Implementation teams, enabling churn-risk identification earlier in the customer lifecycle
-
Improved reliability of forecasting by rebuilding 18+ complex SQL queries (100+ lines each) in DataGrip and reducing query run-time.
-
Informed executive and board decisions by producing quarterly analysis for the VP of Customer Success on renewals and engagement trends.
-
Partnered with RevOps to redesign Salesforce reporting, improving revenue pipeline accuracy and increasing visibility into KPI trends across departments
2021-2022
SUNRUN
Business Intelligence Developer
-
Designed and maintained 11 Data Studio dashboards (29 pages, 79 charts), giving 700+ employees across a nationwide department real-time visibility into performance metrics
-
Automated reporting by developing & optimizing 30+ BigQuery SQL queries (75+ lines each), eliminating 15+ hours/month of manual reporting
-
Created KPI logic and calculations in Data Studio, enabling directors to monitor SLA performance and intervene sooner.
-
Partnered with directors to translate BI insights into operational changes that improved service delivery for 600K+ customers
-
Collaborated cross-functionally to restructure investor reporting, strengthening transparency and trust with stakeholders.
2021-2021
BEEHIVE VENTURE PARTNERS
Business Operations Analyst Intern
-
Created Internship program that included onboarding process.
-
Increased awareness of upcoming Beehive Venture Forums by promoting on LinkedIn.
2021-2021
CARDAGRAPH
Business Intelligence Intern
-
Built a customer success survey for customer success team to allow us to capture the data from the current customer calls so we can ensure we are solving their problems.
-
Reviewed platform to determine potential business use cases for our customers.
-
Developed a questionnaire for the sales team to complete during sales demos to gather and compile information about what the customers business goals are.
-
Introduced sales as a science methodology with a data model to track conversion rates.
-
Worked with the product team to make recommendations on new product features.
2016-2018
THE BABY CUBBY
Digital Marketing Director
-
Managed 1,203 major influencer partnerships that resulted in 806 blog posts and 694 Instagram posts that cost $91,214 that resulted in a total reach on Instagram of 5.4 Million.
-
Built a database of 2,165 social influencers through detailed comprehensive research.
2015-2016
THE BABY CUBBY
Digital Marketing Manager
-
Crafted seven customer surveys, coded, and analyzed 45,678 answers, and based on this insight they now offer free shipping which increased the number of orders by 20%.
-
Performed backlink analysis on both client and competitor sites.
Education
UTAH STATE UNIVERSITY
Executive Master of Business Administration
2024
​
​
Bachelor of Science
Business Intelligence Systems Emphasis, 2020
​
Associate in Science
University Studies, 2020
​
CERTIFICATIONS
Data Science with SQL and Tableau
Cornell University, 2022
​
Database Administration and Data Warehousing
Utah Valley University, 2020
​
Data Analytics:
Utah Valley University, 2020
​
Microsoft Office Specialist (MOS):
Acclaim, 2018
