Mary Grace Stachnik Email and Phone Number

- Spearheaded effort to track M&A program cybersecurity metrics by developing and maintaining an end-to-end data storage, ETL, and visualization pipeline in Domo, consisting of 10 datasets and 6 dashboards with 350 end users- Ensured source data was accurate and accessible by API by multiple development teams to enhance collaboration- Redesigned a multi-team data input and update process, training approximately 80 employees on the new system in Smartsheet Dynamic View and reducing the time needed for data updates by 75%- Supervised 1 direct report, overseeing the development of new dashboards and encouraging professional growth

Rotation 1: Data Engineer (OmniChannel Reporting and Analytics Team)- Built 3 Power BI dashboards and executed ad hoc data analysis in Python to improve leadership’s understanding of call center agent metrics- Ensured adherence to organization-wide policy by migrating reports from SAP BusinessObjects to Power BI, consisting of modifying SQL code, integrating data from multiple sources, and developing relevant visualizations- Developed and trained a SARIMAX time series model in Python to forecast the daily maximum number of concurrent call center agent interactions, ensuring accurate planning and resource allocationRotation 2: Data Analyst (OptumCare Domo Reporting and Analytics Team)- Guided data sourcing and dashboard creation efforts on an internal consulting team to increase the visibility of multiple projects, including M&A integration pipelines and company-wide COVID-19 vaccination reports- Developed ETL processes using built-in Domo tools and Python scripting to manage, clean, and present data- Partnered with end users and subject matter experts across the organization to enhance dashboard functionality

- Collaborated with academic and industry professionals to enhance companies’ ability to measure, visualize, predict, and control their supply chain health through machine learning and data analytics- Developed inventory KPI visualizations and decision support tools in Microsoft Excel using VBA- Created tools to support participating companies in determining proper KPI target values using statistical analysis

- Researched software alternatives to reduce costs for the IT Hire to Retire Team, which supports HR business applications utilized by approximately 17,000 employees across 49 countries- Updated documents and templates related to the purchasing and implementation of new softwares and contractual licensing etitlements- Led 8 Hire to Retire team members in implementing Phase I of a large-scale SAP SuccessFactors data audit project with the goal of mitigating costs related to incorrect or missing employee data

- Attended all class sessions for freshman engineering and programming classes and assisted the professor with monitoring the classroom and answering technical questions from 30+ students - Tutored students in both group and one-on-one settings- Graded in-class activities and homework using Gradescope, an online AI-assisted grading software

- Analyzed package operations data to create an Excel dashboard showing areas of the preload operation where improvement was most needed- Used work measurement calculations to optimize the package car lineup for the Bluegrass facility's preload operation- Managed a Sharepoint database of preload operations data for the Ohio Valley District, communicated with division managers to ensure data was inputted on a daily basis, and reported calculated PPH (packages-per-hour) values to a nationwide Sharepoint site