Gabriel Schneider Email & Phone Number

Sykesville, Md, Us

• Worked closely with the trend analytics team to aid in automation of reporting and completion of ad-hoc requests.• Worked to transition oversight of various Cost of Care initiatives to newer team members.• Continued to aid in development of various ad-hoc analyses and provide insight for our cost of care strategy.• Led a team of analysts as part of a collaborative initiative to establish a robust semantic layer for medical claims data, driving significant improvements in data organization, analysis, and decision-making processes. • Collaborated closely with data analysts, subject matter experts, and IT professionals to ensure alignment with business requirements and data integrity standards. • Effectively communicated complex technical concepts to stakeholders and provided strategic guidance throughout the project lifecycle.

• Supported the development, implementation, and management of a medical economic strategy supporting a $40M annual cost of care strategy across multiple commercial and government plans, insuring over 500,000 members.• Used SQL scripting and Tableau dashboards to analyze trends and associated drivers relative to utilization, cost, and mix.• Developed financial reporting and analytics to measure ROI and support cross-functional initiatives.• Worked closely with Finance and Business Intelligence departments to maximize effectiveness of data sources and quality.• Supported ad-hoc reporting and financial projects for business units throughout the organization.• Taught and mentored junior staff to develop their technical and analytical problem-solving skills.• Served as a go-to for leaders and stakeholders throughout the organization to craft creative financial approaches to practical business issues.• Created financial and predictive models to evaluate the feasibility and key success drivers for new ventures, opportunities, and initiatives.

6704 Curtis Ct. Glen Burnie, Md 21060

• Designed an automated SQL model that accurately calculated CMS Risk Scores using a combination of internal and external data sources.• Supported the development of Incurred but not Received (IBNR) models for both commercial and government-sponsored health plans to assist in accurate reserving of expected medical expense; worked directly with stakeholders each month to communicate recommendations and insights.• Built actuarial models to support multiple health plans, teams, and initiatives.• Developed financial projections that impacted strategic decisions and plan management.• Incorporated the use of data visualization software to help audience absorb data and identify emerging trends.• Simultaneously pursued an ASA designation, using a combination of work and personal time to pass the actuarial Probability and Financial Mathematics exams.

6704 Curtis Ct. Glen Burnie, Md 21060

• Provided Hopkins executive decision-makers with change-based, project-oriented analyses performed on an as-needed basis to diagnose the reason for an unexpected trend or to evaluate the impact of a proposed alternative approach to business operations.• Supported the Johns Hopkins ACO with financial metrics to help guide strategic decision making.

6704 Curtis Court, Glen Burnie, Md 21060

I assist the finance department with various projects, including analysis of administrativeexpenses, modeling expected healthcare expenses, and ad hoc projection based on historicaltrends.