MARCIA COSGROVE
Sacramento,CA
Summary
I am a thorough and meticulous analyst with 20 years of experience examining the economic, financial, and social problems of a variety of industries, while working in both contracted and permanent consulting capacities. I am a competent people and project manager who is enthusiastic about business intelligence, data analysis and visualization, and promoting data literacy in ways that are easy to understand.
Overview
19
19
years of professional experience
1
1
Certification
Work History
SOCIOECONOMIC CONSULTANT
SELF-EMPLOYED
06.2004 - Current
- Consulting in finance and business analysis; economic impact analysis; demographic analysis; statistics and machine learning; business management and accounting; grant proposal writing for nonprofit organizations
- Areas of Expertise: Project and People Management; Education Program Development and Assessment; Quantitative and Qualitative Research Methods; Machine Learning Methods and Application; Mentoring in Skills Development and Data Literacy
PROJECT MANAGEMENT CONSULTANT
PROVISIONS GROUP
04.2022 - 12.2022
- Assisted the Director of Operations Analytics department in managing a team of 10 data engineers and business analysts, including weekly meetings with individuals to discuss workload, deadlines, and pain-points
- Maintained the department’s Jira Kanban board using an Agile framework and reviewed team progress with the Director
- Found resolutions for bottlenecks in department workload and balanced responsibilities among team members
- Met with business stakeholders to define project requirements, reporting deliverables, and deadlines
- Communicate with stakeholders about project and reporting progress
- Developed and wrote reference guides on best practices in data governance, data validation, data pipelines, and the data lifecycle
- Worked with IT department on data systems errors
- Assisted in drafting and validating Tableau dashboards on various healthcare measures in physician practice, service delivery, and HEDIS measurement
ANALYTICS MANAGER
OPTUM360 (UNITEDHEALTH GROUP)
01.2017 - 12.2019
- Managed regional financial & Charge Description Master (CDM) revenue reporting for Dignity Health hospital system (39 hospitals in AZ, CA, NV) including routine financial and ad hoc reporting
- Defined target KPIs for pilot program in Clinical Documentation Improvement in AZ
- Produced entity relationship models of data structures of healthcare claims databases
- Project manager on development of SQL database for reporting Dignity Health Charge Description Master (CDM) revenue
- Provided project management to cross-functional team as a subject matter expert on EMR host system databases and data structures; oversight of data engineering and ETL development; and ensured development addressed user needs and requirements for self-service automated reporting
- Compassionate people manger successful at recruiting, training, managing, and reviewing employees; managing schedules and deadlines; and controlling the quality of work output
- Attended Optum Data Science University (DSU) courses in (1) Optum Scale Data Science and (2) Machine Learning Methods, a review of both structured and unstructured statistical methods.
SENIOR FINANCIAL ANALYST
OPTUM360 (UNITEDHEALTH GROUP)
04.2013 - 01.2017
- Responsible for the consolidation and standardization of regional financial reporting for Dignity Health hospitals in Sacramento, Bay Area, Northern and Southern California throughout transition of the merger between Dignity Health Patient Financial Services and Optum360/UnitedHealth Group
- Reporting included weekly, monthly, quarterly, year-end, and ad hoc data extraction from EMR host systems databases (MS4, Meditech); reporting of service-level contract KPIs and metrics; data analysis and visualization of accounts receivable for 16 hospitals by age of AR, payer, and services rendered
- Established lasting relationships with Dignity Health finance and accounting managers in working to reconcile financial data from EMR host systems databases and general ledger errors
- Developed team communications, process mapping, and standard operating procedures on data analytics and business requirements for reporting
FINANCIAL CONSULTANT
CALIFORNIA EARTHQUAKE AUTHORITY
06.2012 - 03.2013
- Analyzed the development of CEA’s reinsurance financial structure since 1996 and created a series of visualizations depicting changes to the financial structure over time, which were used in presentations to credit bureaus and state agencies
- Analyzed and reported on real estate market trends in California and demographic information relevant to CEA policyholders using a combination of both public and private data sources
- Estimated the price elasticity of CEA earthquake insurance products
- Created process maps and visualizations detailing CEA’s post-earthquake response strategies for the Finance Department
- Assisted the CFO, Reinsurance, and Accounting Units with ad hoc projects related to reinsurance operations and the analysis of the reinsurance program
- Monitored news and developments in the catastrophe insurance and reinsurance markets.
RESEARCH CONSULTANT
CALIFORNIA FACULTY ASSOCIATION
09.2011 - 06.2012
- Responsible for consulting with CFA on subjects related to the state and CSU budget processes, legislation, bargaining, executive compensation, tuition, faculty and student demographics
- Designed and conducted research using quantitative and qualitative frameworks and a range of publicly available data sources
- Generated visualizations of data, wrote analytical reports, and presented work to management and other CFA members
- Evaluated impacts of changes in state funding on the CSU budget process since 1960, including impact on instruction expenditures and faculty salaries
- Presented on faculty and student demographics at CFA's biennial conference on diversity in the CSU system, Los Angeles, March 2012.
Education
Bachelor of Arts - ECONOMICS
CSU SACRAMENTO
Sacramento, CAAssociate of Arts - SOCIAL SCIENCES
SACRAMENTO CITY COLLEGE
Sacramento, CAAssociate of Arts - LANGUAGES & LITERATURE
SACRAMENTO CITY COLLEGE
Sacramento, CASkills
Economic & Financial Analysis
Data Exploration, Mining & QA
Advanced Statistical Analysis
SQL Database & Query Design
Regression & Correlation Analysis
Python, R, Advanced Excel, Tableau
Machine Learning Methods
Teaching Methods & Data Literacy
Social Scientific Research Methods
Demographic Analysis
Certification
Certificate in Data Analytics & Meta Skills
UC Davis Data Analytics Bootcamp, Completed July 2020
UC Davis Division of Continuing & Professional Education
Credential ID: UCDE-23490419
Additional Information
For additional work experience, please connect with me on LinkedIn: https://www.linkedin.com/in/marciacosgrove/
Timeline
PROJECT MANAGEMENT CONSULTANT
PROVISIONS GROUP
04.2022 - 12.2022
ANALYTICS MANAGER
OPTUM360 (UNITEDHEALTH GROUP)
01.2017 - 12.2019
SENIOR FINANCIAL ANALYST
OPTUM360 (UNITEDHEALTH GROUP)
04.2013 - 01.2017
FINANCIAL CONSULTANT
CALIFORNIA EARTHQUAKE AUTHORITY
06.2012 - 03.2013
RESEARCH CONSULTANT
CALIFORNIA FACULTY ASSOCIATION
09.2011 - 06.2012
SOCIOECONOMIC CONSULTANT
SELF-EMPLOYED
06.2004 - Current
Bachelor of Arts - ECONOMICS
CSU SACRAMENTO
Associate of Arts - SOCIAL SCIENCES
SACRAMENTO CITY COLLEGE
Associate of Arts - LANGUAGES & LITERATURE
SACRAMENTO CITY COLLEGE
Similar Profiles
KEVIN ROSEKEVIN ROSE
Independent General Maintenance and Automotive Mechanic at Self-employedIndependent General Maintenance and Automotive Mechanic at Self-employed
Emma Austin-DimentEmma Austin-Diment
Education Consultant, Private Tutor, Coach at Self-employedEducation Consultant, Private Tutor, Coach at Self-employed
Sonalika SinghSonalika Singh
Spiritual Consultant at Self-EmployedSpiritual Consultant at Self-Employed
Aamuktha MadabhushiAamuktha Madabhushi
Singing teacher at Self-employedSinging teacher at Self-employed
Bonnie StanleyBonnie Stanley
Radiologic Technologist IV at Kaiser PermanenteRadiologic Technologist IV at Kaiser Permanente