Mike Schultz

Extracted and analyzed data from All-Payer Claims Database (APCD) for pre-sales requests and clients' medical study projects. Taught five data analyst interns to work with APCD data. Utilized BigQuery, Jupyter notebooks, SQL, and Excel for most tasks.

Augmented a team of 8 analysts working on network security tasks and coded automated logs using Visual Basic for metrics files. Analyzed and updated a 4000-row database using SQL, and transferred data to JIRA using Postman software.

Wrote free-hand SQL code in Teradata and SQL Server against Cerner medical data for clinical dashboard reports. Taught teammates to use SQL and Teradata through four one-hour classes and 12 written lessons.

Managed a web portal for 1200 doctors, showing 220 ACO/PQRS metrics, sourced by 8 data sources. Performed ad hoc data analysis projects involving diagnosis codes, procedure codes, and lab results. Quality checked the work of web and ETL developers and determined root cause of user-reported issues.

Tested two systems as investigation cases were transferred, validating correct reappearance in the second system. Investigated faults to identify their root cause. Developed 25000 lines of script to use in ALM 11.

Learned and used Attensity software to perform text analytics against written customer survey comments and customer service agent comments. Analyzed point of sale data to assess out of stocks, wait times, and seasonal variability, with data hosted in Teradata.

Supported as the sole data analyst, meeting deadlines and providing support with minimal documentation and continuity. Conducted the company's first return on investment (ROI) analysis for a client, using medical and pharmaceutical claims.

Used SQL to find missing or incomplete data in a database utilized for tracking doctors and sales representatives. Ensured data integrity and accuracy for critical business operations.

Expertly instructed online classes of 18-20 students, lasting five weeks. Taught SQL (structured query language) to students obtaining a B.S. in Information Technology. Consistently received high student feedback, often being recognized as the 'Best Facilitator'.

Solved complex business problems through statistical analysis and designed agent KPI ratings, optimizing call center staffing and customer service. Developed automated hourly reporting which allowed Medicare Part D prior authorization staff to manage case turn-around times in accordance with government standards. Single-handedly supported the metrics and reporting needs of eight call center units

Calculated the staffing needed for a section of 40 call center workers by constructing a mathematical model of their work-flow in Excel. Performed financial modeling calculations for the 1999 $20 million call center budget.

Answered computer questions for students and staff both over the telephone and in person at a university computer lab help desk, part time. Assisted users with technical issues and software inquiries.

Served as a Platoon Leader for an engineer platoon and Executive Officer for an engineer company. As battalion maintenance officer, was responsible for supervising the staff of 80 mechanics that maintained 300 vehicles and constantly made internal processes more efficient.

Grade: 3.9 out of 4

Achieved a perfect 100.0% in Corporate Finance class, demonstrating exceptional understanding of financial principles. Graduated with a GPA of 3.9 out of 4, showcasing strong academic performance across all coursework.

Completed a rigorous curriculum focused on mathematical principles and their applications. Developed strong analytical and problem-solving skills essential for a career in data analysis.