Senior Data Analyst

• Jun 2022 - Present

Data Analyst

• Jun 2021 - Jun 2022

Data Scientist

• Oct 2019 - Jun 2021

I inform pressing business questions with data. My preferred tools are modeling data with SQL and dbt, analyzing with R, and creating a curated dashboard available on Shiny Server. If appropriate, set up self service tools like PowerBI. A few projects include: * Rapidly iterated on the influence of the pandemic on business using flexdashboard in Shiny * Ported a legacy invoicing process in Access to a Shiny app, increasing visibility and flexibility into the process * Forecasting claim volume time series with seasonality using fable in an RMarkdown doc * Automating an accounting data pipeline with a scheduled R job * Creating a filterable revenue dashboard with dc.js, crossfilter.js, and a little D3.js, housed on a Shiny Server In addition to technical work, I also helped hire and train new data team hires. Show less

Business Data Analyst

• Apr 2014 - Oct 2019

Data reporting and analysis involving data sets across multiple business units. My favorite projects are those that are complex enough to warrant using R. I prefer RStudio and use the built in project management, Git source control, and Shiny apps capabilities. I use SQL, SSRS, and SSMS on a daily basis. Excel, Access, VBA, and Quest Analytics are great for specific projects. I also enjoy text cleanup with regex in Sublime Text. Data reporting and analysis involving data sets across multiple business units. My favorite projects are those that are complex enough to warrant using R. I prefer RStudio and use the built in project management, Git source control, and Shiny apps capabilities. I use SQL, SSRS, and SSMS on a daily basis. Excel, Access, VBA, and Quest Analytics are great for specific projects. I also enjoy text cleanup with regex in Sublime Text.

Planning and Reporting Analyst

• Jan 2011 - Mar 2014

Improving profitability through the operations and financial departments. I do data analysis, create Excel applications, and develop Access databases.

Data Specialist Intern

• Jul 2010 - Dec 2010

• Led pharmaceutical market forecasting engagement for multinational Fortune 500 client• Applied analytical procedures and Microsoft Excel formula expertise to use historical data to model impact of product launches and external factors to worldwide unit sales and revenue• Saved 600+ hours annually by creating Excel VBA macros to automate data processing• Performed quantitative data analysis with SPSS statistics software

Accounting and Consulting

• Apr 2009 - Jul 2010

I perform daily or weekly accounting functions, usually with QuickBooks. I enjoy fixing financial statements and managerial reporting. Often, I give advice on risk, efficiency, and technology issues. Specific accomplishments include: • Started business by studying online to become an Intuit QuickBooks Certified User • Created Excel tool to track medical bills and match them to insurance EOB documents • Converted Quicken 2004 file into QuickBooks Pro 2009 and fixed conversion issues • Designed inventory database in MS Access to calculate investors’ imputed interest • Completed year-to-date company files in QuickBooks by analyzing records • Implemented the QuickBooks credit card online banking system mid-year Show less

Tax Associate

• Dec 2008 - Apr 2009

Exceeded 50 return goal. Ninety-three individual returns completed. Processed $14,600 in revenues. I was fast with the software, completing most tax returns effortlessly and accurately in under 10 minutes from the customer walking in the door. Exceeded 50 return goal. Ninety-three individual returns completed. Processed $14,600 in revenues. I was fast with the software, completing most tax returns effortlessly and accurately in under 10 minutes from the customer walking in the door.

Guitar Instructor (Contractor)

• Jan 2007 - Jun 2008

Taught individual guitar lessons as well as group lessons to children and teenagers Taught individual guitar lessons as well as group lessons to children and teenagers