Austin Roush

Background

About Austin Roush

As a Financial Benefits Analyst at OneDigital, I use data to identify patterns and trends that lead to innovative solutions and strategic business decisions for our clients in the healthcare industry. Skills summary: • Advanced Microsoft Excel skills: Data importing, cleaning (filtering, formatting, converting, validating, transforming, etc.), formulas and functions (SUMIFS, XLOOKUP, INDEX MATCH, CONCATENATE, nesting, etc.), analyzing trends with PivotTables & PivotCharts • Tableau: Solid understanding - completed "Visualizing Citibike Trips with Tableau" project on Coursera • SQL: Working knowledge of querying relational databases - completed Coursera projects below • R & RStudio: Basic knowledge • Advanced knowledge of sales techniques: upselling and cross-selling, persuasion, negotiation, etc. • Strong presentation skills: Able to effectively communicate a company’s mission and vision • Advanced Microsoft PowerPoint skills: able to create high-quality slide-decks • Thorough knowledge of CRM software Completed SQL projects on Coursera: • Creating Database Tables with SQL • Adding Advanced Features to a Relational Database Table Using SQLiteStudio • Build a Database from a Relational Model • Retrieve Data with Multiple-Table SQL Queries • Complex Retrieval Queries in MySQL Workbench • Advanced SQL Retrieval Queries in SQLiteStudio • Sort and Filter Data in SQL using MySQL Workbench • Aggregate Data in SQL using MySQL Workbench • Combine Multiple Pieces of Data in SQL • Manipulating Data with SQL • Advanced Relational Database and SQL • Intermediate Relational Database and SQL • Introduction to Relational Database and SQL • Concepts in SQL • SQL Functions • SQL Joins