Ryan Blanchette Email & Phone Number

Knoxville, Tn, Us

Memphis, Tn, Us

• Performed complex joins and aggregations with HR data in BigQuery to producehighly detailed adhoc people analytics for various parts of the business includingsupply chain, compensation, and DEI.• Collaborated with data engineering and architecture to design employee historytables that allowed the HRIS team to give valuable insights to HR at a much fasterpace than legacy systems would allow.• Developed dashboards using BigQuery and Looker to replace legacy reports thatprovided superior insights at a greater speed.• Performed statistical testing on a supply chain initiative by collecting thenecessary data and applying Fisher’s test to show that the test locations had asignificant improvement in new hire retention.• Replaced an existing 3rd party pay equity regression model using scikit-learn andother Python libraries with an R2 over 90% that helped ensure that employees werebeing paid fairly regardless of gender of ethnicity.

Nashville, Tennessee, Us

• Developed and deployed new tables and stored procedures into production that enhanced the supply chain data model • Furthered the effort to convert the supply chain data model entities from on-premises data storage to cloud-based storage• Served the needs of customers across the finance/supply chain organization by creating and updating various tables, stored procedures, and reports

Us

• Collected and cleaned data from various sources to submit to critical surveys for the continuing success of the engineering college• Designed and implemented Power BI dashboards for the engineering college leadership• Collaborated with other data owners across the university to answer ongoing and ad hoc data needs

Knoxville, Tn, Us

• Standardized the methodology used to identify potential churn customers with machine learning in R to analyze customer purchase history and produce risk scores with nearly 90% model accuracy• Maintained reports on the effectiveness of various marketing campaigns with various tools in R which helped guide future campaigns• Forecasted the amount of promotional shipping box inserts needed with ARIMA modeling in R which produced forecasts that were 150% more accurate than historical methods

Us

Us

• Developed analytics using SAS that identified medical claims as either fraud, waste, or abuse, which resulted in thousands of dollars in savings• Evaluated other analysts’ programs through a QA process which was an integral component of the analytic development process• Aided in the development of a commercial healthcare provider exploration tool by writing SQL queries and displaying the results in Tableau dashboards• Explored external vendor claims data using SAS, R, and Excel in order to aid in the creation of new analytics

Cincinnati, Ohio, Us

For our Business Analytics Capstone, three other students and I, with the help of a faculty adviser, created time series models to aid in the prediction of bath tissue and paper towel total market size.

Us

• Analyzed file loading errors through modeling in R and visualization in Tableau which identified highly problematic clients and loading steps• Improved the department SharePoint site by redesigning the layout and appearance, creating an organizational chart, and adding plots with R to describe department performance• Maintained project and client databases in SQL resulting in saved research time for other analysts

Knoxville, Tn, Us

• Guided senior undergraduate students in business analytics in their course work through emails, office hours, and individual meetings, which led to a stronger student understanding of the materials• Collaborated with Dr. Seaver on ways to improve how the classes were taught, and how the duties of the graduate teaching assistants could be optimized which created a better method of grading assignments• Graded homework, projects, and exams in collaboration with Dr. Seaver and another graduate teaching assistant

Us

• Coached mathematics students via different methods such as examples and homework help which led to a stronger student understanding of the materials• Communicated with supervisor about ways to improve tutorial center; a new and improved tutor schedule was created• Collaborated with other tutors in order to solve challenging problems by combining strengths, resulting in an increased understanding and confidence in both the students and tutors

Framingham, Ma, Us

• Managed front of store customer service and recommended products accordingly• Responsible for maintaining Staple’s strong reputation and keeping store up to standards in cleanliness, friendliness, positive customer experience, and E.A.S.Y. service• Utilized strong people, communication and time management skills

Master’S Degree, Business Analytics

Bachelor’S Degree, Statistics

Education record