Ryan Towle Email & Phone Number

Grand Rapids, Mi, Us

• Design data models & dictionaries for new, large-scale products, then execute by building out the databases, tables & queries needed to support all requisite processes.• Develop & maintain Power BI dashboards & ad hoc reports using SQL & complex DAX expressions to facilitate internal operational changes.• Present & pull all data for weekly data updates to external Fortune 50 customers regarding Bloom's performance completing Health Risk Assessments for Medicare Advantage members, from both a raw & CMS Stars perspective• Automate tasks for Project Management team using Power Automate • Shepherded the Quality department, including many junior colleagues, through a transition to SQL-based reporting amid a complex corporate integration process due to multiple acquisitions

Detroit, Michigan, United States

• Developed automated dashboards & reports in MicroStrategy & Power BI using SQL to summarize HEDIS rates and other Quality-adjacent information and distribute data on a recurring basis • Fulfilled various ad hoc data requests for key stakeholders, department-wide and market-wide • Taught multiple SQL, Excel & data workflow seminars, in addition to regular presentations of dashboards, to market leaders & staff, often across regions & up to corporate level • Shepherded the Quality department, including many junior colleagues, through a transition to SQL-based reporting amid a complex corporate integration process due to multiple acquisitions

Tigard, Or

• Manage the Inpatient Validation process for the OR Market, pricing all Medicare, Medicaid & Commercial Inpatient stays for the prior 6 month period• Forecast Inpatient costs for AOP & each quarterly update• Develop dashboards & other reports using SQL, Tableau, Microstrategy, PowerPivot & more for Inpatient & Pharmacy expenditures & employee productivity• Use data diving capabilities to identify potential cost savings (including $250k+ in 2020)

Greater Nashville Area, Tn

• Manage rebate process for CHC vendors, which involves over $80M in annual payments and over 1,000 queries & tables• Add, edit & Cross-validate GL string segments in Oracle system for use by Billing team• Write VBA script to automate recurring weekly tasks & reporting• Field ad hoc requests to provide A/R & rebate data & analysis to corporate stakeholders• Reverse-engineer rebate processes to better understand table hierarchy, fix exceptions and add new products & vendors

Nashville, Tn

• Solved computer-related problems for clients, specializing in virus removal, network issues, e-mail system compatibility and general tune-ups to speed up computers and smartphones• Collaborated with small business owners on website design, marketing strategy, accounting software setup and process improvement• Expanded service offerings and doubled client base with improved marketing strategy• Designed templates and process for easy HCFA health insurance form (CMS 1500) billing on behalf of a local healthcare provider

Nashville, Tn

• Primary digital form designer, creating templates and coding business logic in Visual Basic for data collection in medical evaluations, field inspections and other business applications• Presented demonstrations to prospective clients on location as part of sales team• Coded client-facing websites using HTML and Javascript, enabling seamless integration with FileBound, an industry-leading workflow automation software• Developed process to track A/R and A/P for clients’ software maintenance renewals, significantly increasing collections and renewal rate• Analyzed data from OCR output of HCFA health insurance claims forms (CMS 1500), resolving errors before submission to healthcare clients• Acted as backup to CIO, responsible for ensuring the operational platform was consistently functional and optimized. This led to reduced downtime during critical events

Nashville, Tn

• Assisted in the formulation of the department’s $2 billion annual budget, including deep dives into the State’s ERP Accounting system (Edison) for helping the Finance Division resolve discrepancies. Budget planning consisted of meetings with each director in the department to discuss rationales for increased spending, forecasting federal funding amounts and targeting items for reduced funding• Wrote SQL queries to access and modify departmental databases, primarily in MS Access, and generated financial reports in web-based state accounting system• Performed due diligence on financial impact of prospective state legislative efforts• Prepared financial summaries, reports and models for the department Commissioner and Assistant Commissioners. Sample projects included pro forma expense forecast for a SNAP (Food Stamps) initiative and sensitivity analysis of federal funding scenarios• Proactively designed and wrote an extensive series of formulas and VBA macros for a group of Excel worksheets that linked together departmental budgets and projections using pivot tables, enabling easily updateable summations and preventing a significant number of costly budget errors• Designed a dynamic worksheet for a federal weatherization program that collected data from department databases. This involved extensive data scrubbing and translation of technical data for decision makers. Calculations from this data resulted in efficiency gains and policy changes, including a new bidding system, which saved 8 hours of data collection per week

Master Of Business Administration (Mba), Finance, Real Estate, Investment Management, Operations

Activities and Societies: Tech Club, Japan Business Club- Selected as Teaching Assistant for Managerial Statistics course - 3.64 GPA.

Bachelor Of Arts, Global Studies

Activities and Societies: Global Studies Society-3.72 GPA -Honors Program -Additional concentration in Spanish and Political Science -3.