Work History
- October 2020 - Present: Lead Analyst II
- Duquesne Light Company
Pittsburgh, PA
- Conduct statistical analysis, modeling, and machine learning using Databricks and RStudio to deliver actionable insights
- Lead cross-functional advanced analytics projects using R, Databricks, SQL, and Microsoft Suite
- Perform all stages of the data analytics lifecycle, including: data cleansing & transformation, analysis & modeling, and creating & presenting impactful and engaging summarizations and visualizations of project results
- Developed a predictive model that increased marketing campaign engagement by over 200%
- Recipient of the Employee Excellence Award (2023) for outstanding contributions to project success and team development
- Promoted from Lead Analyst to Lead Analyst II in March 2024 after consistently exceeding performance goals
- September 2020 - October 2020: Lead Analyst
- Gateway Health
- Pittsburgh, PA
- Promoted internally to Gateway Health, a subsidiary of Highmark Health
- Utilized SAS and SQL to perform complex data extractions and in-depth analysis
- Analyzed health and condition data to identify trends and uncover areas of concerns, supporting data-driven decision making
- Provided SQL training and mentorship to team members, improving overall team efficiency
- October 2019 - September 2020: Senior Decision Support Analyst - People Analytics
- Highmark Health
- Pittsburgh, PA
- Transferred to the Organizational Analytics team to focus on my passion for People Analytics and drive strategic HR initiatives
- Designed, distributed, and analyzed surveys using Qualtrics to inform employee engagement and retention decision making
- Extracted, combined, and cleaned complex datasets using Alteryx, Workday, and RStudio
- Conducted advanced statistical analysis and modeling using RStudio
- Collaborated in shaping team priorities and standards, helping establish best practices for a newly created team
- January 2019 - October 2019: Senior Decision Support Analyst - Health
- Highmark Health
- Pittsburgh, PA
- Developed a logistic regression model to predict the likelihood of complications from spinal surgery, allowing physicians to better assess individual patients’ relative risk
- Created and delivered a comprehensive training on basic R to a group of peers, enhancing team-wide proficiency in data analysis
- Wrote complex SAS and SQL queries to extract and manipulate large datasets
- Conducted statistical analysis including linear regression, chi-squared tests, and propensity score matching on care pathway data to identify key trends and insights
- Leveraged knowledge of clinical norms, data structures, and medical codes to explore and interpret healthcare data
- Built dashboards in Tableau and presented findings to physician-led teams
- October 2016 - January 2019: Actuarial Analyst - Health
- Highmark Health
- Pittsburgh, PA
- Conducted ad hoc analyses requiring summary statistics, data normalization, correlations, etc., to provide insights into healthcare reimbursement programs
- Developed complex data queries combining multiple data sources using SAS and SQL
- Designed value-based reimbursement programs using Excel and VBA
- Performed program monitoring and reporting for providers
- Collaborated with cross-functional teams to ensure data accuracy and program understanding
- November 2015 - September 2016: Business Analyst - People Analytics
- GEICO Insurance Agency
- Washington, DC
- Analyzed associate experience to drive corporate change
- Designed and implemented surveys using Qualtrics software, capturing valuable insights into employee engagement
- Performed in-depth analysis of survey responses, applying quantitative methods, statistical techniques, and text analysis to identify key trends and insights
- Explored the link between employee satisfaction and key performance indicators (KPIs) using regression analysis
- Presented data-driven recommendations to a variety of audiences, including senior management
- June 2014 - November 2015: Actuarial Analyst
- GEICO Insurance Agency
- Washington, DC
- Extracted and validated data using SAS and SQL
- Conducted in-depth data analyses to determine insurance rates
- Developed automated reports using VBA, streamlining workflows and improving reporting efficiency.
- Mentored and trained two new associates, providing guidance on processes, answering questions, and fostering their professional development
- Completed Lean Six Sigma Yellow Belt training
- Summer 2013: Actuarial Intern
- The Hartford Financial Services Group
- Hartford, CT
- Interned with the Enterprise Risk Management department, contributing to risk assessment and mitigation projects
- Developed an automated reporting solution using VBA
- Presented work before actuarial senior management