Katherine Schmidt Email & Phone Number

Chapel Hill, Nc, Us

Chapel Hill, Nc, Us

Reston, Virginia, Us

• Primary data analyst supporting the Mission Execution Excellence Program (MEEP).• Built and optimized weekly data processing tasks using Python and Excel as well as aweekly dashboard using Tableau and Qlik.• Created data-driven slides for quarterly Wing- and squadron-level briefings to shareperformance updates throughout the duration of the program.• Assisted in budgeting for consecutive years of the program, including savings projectionsto determine how many additional units can be added into the program.• Analyzed flight data recorder data for multiple MDS including C-17, C-5, KC-135, and C-130, to find distributions of shutdown fuel, altitude, and speed. Work was done using Databricks on ADVANA.

Bala Cynwyd, Pennsylvania, Us

• Operated as the project manager for three international teams simultaneously, being themain point of contact between the client and the team. This includes sharing results withthe client in an understandable manner, demonstrating Tableau reports to both technicaland nontechnical end users, and informing the team of client decisions along with anaction plan.• Worked to migrate each project’s existing SAS programs to PySpark to automate andstreamline monthly extraction, transformation, and loading (ETL) processes.• Reviewed and implemented national quality measures for use in reports based onMedicaid administrative claims data.• Transformed Medicare administrative claims datasets to run on the 3M Grouper softwarewithin the Chronic Conditions Data Warehouse environment and analyzed output forclient needs.

Fort Washington, Pa, Us

• Responsible for reporting and the overall data analysis for the Marketing Department, byanalyzing, mapping, and concluding trends in the data with regard to energy savings andbudgeting.• Used R to streamline the reporting process, reducing the time of reporting by one-third.• Created data visuals (maps, graphs, etc.), mainly in R, Tableau, and ArcGIS, as requestedby clients and team members.• Designed and populated end-of-year data analysis for multiple contracts, which includedextensive analysis on company projects and suggestive ways to improve energy efficiencyprograms.• Gathered, cleaned, and analyzed demographic data for RFP’s as well as supporting datafor existing projects.

Glassboro, Nj, Us

Researched the cardiotoxic effects of chemotherapy treatments, focusing mainly on leukemia and its subtypes. Data analysis in this role consisted of implementing machine learning algorithms using R, specifically artificial neural networks and decision trees, to examine the role of the cardiac biomarker myeloperoxidase in classifying acute myeloid leukemia.

Glassboro, Nj, Us

Cleaned and manipulated NJDEP data of solid waste tonnage collected from 1994 to 2015. Also collected demographic data, including income, education level, poverty level, and age, to run a multiple linear regression analysis to determine how the demographics of a municipality affects the amount solid waste produced in an area.

University Of Sydney, Sydney, Au

Worked on a report titled, "Failure to Launch: The United States, Australia, and the Threat of Inefficient Innovation." Used the Global Innovation Index (GII) report to examine the roles numerous economic and social variables play in the development of innovation in Australia and the United States. Contributed to drafting sections of the report as well as collecting microeconomic data in both the US and Australia.

Master Of Science - Ms, Applied Statistics

Bachelor'S Degree, Mathematics, Economics