• Designed a fully automated Python process for updating and reporting all LTC Re-Rate data utilizing multiple source files; Python for calculations, formatting, and process flow; SQL for data storage and control; Power BI for dashboard visualizations and publishing• Developed multiple Excel frontend/Python backend tools to completely automate parts of the LTC Re-Rate process significantly reducing the time and energy required to produce necessary files while maintaining flexibility to handle a wide range of use cases, and including detailed process flows and documentation• Worked closely with members of the Re-Rate team to design tools to their specifications, UAT, and to maintain tool’s ease of use for end users• Managed, reviewed, and approved Python programming projects for several team interns and contributed to recruiting by participating in Campus Connect events

• Redesigned and implemented a more efficient process for reporting new business sales using R and Rconnect to publish the report for upper management and outside reporting agencies • Mapped and identified inefficiencies in the previous design allowing the reporting process to be cut down from four hours to ten minutes• Assisted with rollout of cloud-based R platform, attended various trainings, and completed documentation on usage applications for the company• Gained insight and experience in the actuarial field from a data perspective

• Organized and analyzed financial data to identify issues in patient services costing • Gained insight into the healthcare industry through attending company meetings and evaluating reports• Tested financial models using the company’s software to verify the program’s usefulness as well as remedy any issues

• Designed and implemented web scrapers using Python and extracted data into .json databases• Updated and maintained relevant databases for use in a mobile consumer app

• Compiled and evaluated hiring data • Managed databases recording government required forms, temporary employees, recruiting, and new hires • Assisted department head with various parts of the hiring process including filing relevant documentation, assessing application quality, and acting as a liaison between both parties

• Supervised five lifeguards and one pool attendant; evaluated performance, assigned day to day duties, verified and signed off on daily cash balances, ensured all employees completed jobs properly and efficiently • Maintained pool and surrounding facility