Experience

DataScout, LLC

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• ETL Developer

  • Mar 2022 - Present



Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Automation Programmer

  • Jun 2020 - Mar 2022

  - Implemented, and currently maintaining an in-house data application to support medical and pharmacy coding departments in daily data pulls saving 100+ hours in manual work yearly. - Wrote 30+ VB scripts of varying complexity to develop automated reports from former manual reports across multiple departments.  Built dozens of SQL scripts to assess, clean, validate and analyze large datasets for reporting purposes. - Engaged and consulted for 3 major departments (medical, pharmacy, and reporting) to achieve data needs and analytical results more effectively. Show less



Canton & Company

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• Data Architect Intern

  • Oct 2019 - Jun 2020

  - Analyzed business requirements and produced a prototype solution design for the development of a modern data warehouse: tables, indexes, and procedures through Azure with a $1000 monthly budget. - Developed ETL scripts using SSIS and python to enable monthly processing of 2-4 GB data sets into our data warehouse solution. - Created analytical reports and dashboards with Power BI to provide actionable insights that support data-driven decision-making for dozens of clients. - Analyzed business requirements and produced a prototype solution design for the development of a modern data warehouse: tables, indexes, and procedures through Azure with a $1000 monthly budget. - Developed ETL scripts using SSIS and python to enable monthly processing of 2-4 GB data sets into our data warehouse solution. - Created analytical reports and dashboards with Power BI to provide actionable insights that support data-driven decision-making for dozens of clients.



The University of Texas at Arlington - College of Business

• United States
• Higher Education
• 100 - 200 Employee

• OIIR Assistant

  • Nov 2018 - May 2020

  - Increased security and performance of systems by implementing new anti-virus software and critical system updates. - Coordinated with IT Network Services for all software upgrades/patches and escalated/resolved equipment issues. - Increased security and performance of systems by implementing new anti-virus software and critical system updates. - Coordinated with IT Network Services for all software upgrades/patches and escalated/resolved equipment issues.



Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas

• United States
• Hospitals and Health Care
• 700 & Above Employee

• IT/Software Development Intern - Benefits Management

  • Jun 2019 - Aug 2019

  - Designed and built a Power Apps solution that collected data for hiring capacity analysis in our 300+ people operations department. - Wrote 18 total scripts using SQL and VB to transform manual excel reports to an automated process. - Designed and built a Power Apps solution that collected data for hiring capacity analysis in our 300+ people operations department. - Wrote 18 total scripts using SQL and VB to transform manual excel reports to an automated process.