Mary Grace Stachnik
Details
Industrial Engineering
Clemson University
2020
Assumption High School
Optum
Cybersecurity Data Engineer
Rotation 1 : Data Engineer (OmniChannel Reporting and Analytics Team)
- Created dashboards for business users and performed ad hoc data analysis to answer business questions related to OmniChannel agent skill changes
- Migrated reports from SAP BusinessObjects to Power BI by editing and implementing SQL code, joining data from multiple sources, creating relevant visualizations, and upgrading based on user feedback
- Programmed and trained a SARIMAX time series model in Python to predict the daily max number of concurrent agents on calls for the OmniChannel and VCC platforms
Rotation 2 : Data Engineer (OptumCare DOMO Reporting and Analytics Team)
- Analyst on the DOMO team within Optum Care responsible for sourcing in data to create interactive dashboards for multiple domains, including Program Management, COVID, and Mergers & Acquisitions
- Developed dataflows using built-in tools and Python scripting to manage, clean, and present data
- Regularly communicated with and asked for feedback from the dashboards’ end users and SMEs across UHG
2021 : 2021
Optum
Technology Development Program Associate - Data Engineering
- Member of a project team using machine learning and data analytics to help companies measure, visualize, predict, and control supply chain health
- Created inventory KPI visualizations and decision support tools in Microsoft Excel using VBA
- Created tools to support participating companies in determining proper target values for KPIs and other performance metrics using statistical analysis
2020 : 2020
Clemson University Industrial Engineering
Supply Chain Performance Researcher
- Member of the IT Hire to Retire Team, which supports Global HR, Payroll, Total Rewards, and other business applications utilized by approximately 17,000 employees in 49 countries
- Used Microsoft communication tools, Agile Engineering, and Lean Six Sigma methodologies to plan and implement projects in a remote working environment due to COVID-19
- Researched software alternatives to reduce IT costs
- 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
2020 : 2020
Sealed Air Corporation
IT Business Analytics Intern
- Attended all class sessions for a freshman introductory engineering class and assisted the professor in taking attendance, monitoring the classroom, and answering students' questions about the material
- Held tutoring hours outside of class for students who needed help with their homework
- Graded in-class activities and homework using Gradescope, an online AI-assisted grading software
2018 : 2019
Clemson University College of Engineering, Computing and Applied Sciences
Undergraduate Teaching Assistant
Skills
Agile Methodologies, Arena Simulation Software, AutoCAD, Creative Problem Solving, Critical Thinking, Customer Service, Cybersecurity, Data Analysis, Data Analytics, Data Visualization, DOMO, Ergonomics, Leadership, Machine Learning, MATLAB, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft Power BI, Operations Research, Optimization, Python (Programming Language), R, Rally, Research, SAS, SQL, Teamwork, Visual Basic for Applications (VBA)
About
I am skilled at exploring and processing large datasets, creating data storage and reporting solutions, and working with business partners to determine how their metrics are best visualized. In my current position at Optum, I use a combination of Python, SQL, DOMO, Excel, and Power BI to achieve these goals.
I have experience working on multiple interdisciplinary teams, both small and large, within academia and the logistics, healthcare, tech, and manufacturing industries. I have enjoyed working in both highly technical and business-focused roles within these teams, and my broad skillset allows me to quickly adapt to any role that might need to be filled for a project to be successful.
Outside of my day-to-day work, I enjoy staying up to date on business, finance, and technology trends. My current learning portfolio includes ML/AI, cybersecurity, and blockchain technology.
Profile Photo
