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
-
Performed weekly 1-1 training with Customer Success and Implementation teams on advanced Tableau tactics to identify trends and patterns and uncover insights
-
Created 5 dashboards and 39 visuals using Tableau Desktop and Tableau Online
-
Maintained and enhanced 5 workbooks, 19 dashboards and 173 charts in Tableau
-
Updated 18 complex queries in DataGrip with over 100 lines of code per query
-
Performed in depth analysis for VP of Customer Success for quarterly Board Meeting
-
Developed complex Entity Relationship Diagram (ERD) with over 100 tables
-
Partnered cross functionally with RevOps to update Salesforce dashboard and reports
-
Reported directly to the Chief Technology Officer (CTO) on strategic data initiatives
2021-2022
SUNRUN
Business Intelligence Developer
-
Created, maintained and enhanced 11 dashboards with 29 pages and 79 charts in Data Studio
-
Coded 30 intricate SQL queries using Big Query with an average of 75 lines per query
-
Created complex functions in Data Studio to provide key metrics to stakeholders
-
Primary analyst that supported a nation-wide department of more than 700 employee’s
-
Partnered with directors and senior management to support making data driven decisions utilizing analytics to provide vital insight to meet the service needs of 600k customers
-
Worked cross functionally on an advancement of data reporting and structuring for investors
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.
2016-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