Institute of Mental Health logoCurrently an Extern @Institute of Mental Health
Vraj Shah portrait

A Finance-trained Analyst with hands-on Research experience

2+ years experience in Finance + Administrative Operations, 1 year in AI-focused Research; Corporate Finance + Business Intelligence

Work samples

Dive into my recent projects, where I tackle real-world financial challenges and develop solutions that drive success.

  • Attronica Financial Planning & Analysis and Private Company Valuation Externship
    Attronica logo

    Attronica · Jun 2026 · ✅ Verified by Extern

    Attronica Financial Planning & Analysis and Private Company Valuation Externship

    A 40-year-old, $63M family-owned IT firm is weighing what's next — and the founder has handed it to FP&A to lay out the paths. Six options are on the table, from doubling down on growth to holding steady. Organize the books, model the forecast, value the business, and deliver a Strategic Recommendation Document that lands on the CEO's desk.

    Top performerFinancial ModelingFinancial Statement AnalysisExcelValuationForecasting
  • Healthcare Operations & Consulting Externship
    Institute of Mental Health logo

    Institute of Mental Health · ✅ Verified by Extern · ⏱️ In progress

    Healthcare Operations & Consulting Externship

    This externship explores how care coordination work in acute mental health settings can be designed, analyzed, and communicated as a customer-centric operational system. Externs study the case manager’s role at IMH to understand how workflows shape patient experience, surface hidden risks, and make invisible coordination work visible. Through structured analysis, process mapping, and dashboard prototyping, externs learn how operational clarity supports continuity of care, safety, and institutional decision-making.

    Stakeholder MappingSystems ThinkingProcess MappingChange Management

About me

2+ years experience in Finance + Administrative Operations, 1 year in AI-focused Research; Corporate Finance + Business Intelligence

I'm an aspiring finance professional with a Bachelor's degree, eager to build my skills and contribute to impactful projects. I thrive on challenges and am excited to start my career in financial planning and analysis.

Externships

Healthcare Operations & Consulting Externship

Institute of Mental Health

Experience

Business Intelligence Extern

Extern · July 2026 – Present

FP&A Extern

Extern · June 2026 – July 2026

Research Associate, Learning and Language Lab

University of Illinois at Urbana-Champaign · June 2025 – February 2026

Campus Operations Assistant

Amerigo Education · October 2025 – June 2026

Finance Operations Associate

Uline · Sep 2026

Operations and Consulting Extern

Extern · Aug 2026

Project Management Intern

Eaton Corporation · Sep. 2023 – Jan. 2024

Education

University of Illinois at Urbana-Champaign

B.S. Agricultural and Consumer Economics, Consumer Economics and Finance, Minor in Business · Class of 2025

Skills

Financial PlanningFinancial AnalysisValuation ModelingStrategic RecommendationsExcel ModelingSQLAI

✅ Verified by Extern

Attronica Financial Planning & Analysis and Private Company Valuation Externship

A 40-year-old, $63M family-owned IT firm is weighing what's next — and the founder has handed it to FP&A to lay out the paths. Six options are on the table, from doubling down on growth to holding steady. Organize the books, model the forecast, value the business, and deliver a Strategic Recommendation Document that lands on the CEO's desk.

Financial ModelingFinancial Statement AnalysisExcelValuationForecasting

Overview

The work reviewed five years of Attronica financials, reconstructed a standalone AV division P&L, built five-year projections, and produced a DCF enterprise valuation with sensitivity notes. Deliverables included ratio benchmarking, operational findings, and a four-page Strategic Recommendation Document. The work was awarded Top Performer by Attronica.

Attronica Financial Planning & Analysis and Private Company Valuation Externship

What I've accomplished

I produced a package including a five-year financial review with FY25 ratios and peer comparisons, a reconstructed AV division P&L with five-year projections, a DCF enterprise valuation with sensitivity notes, and a four-page Strategic Recommendation Document.

Top performer

Project breakdown

View all work

✅ Verified by Extern · ⏱️ In progress

Healthcare Operations & Consulting Externship

This externship explores how care coordination work in acute mental health settings can be designed, analyzed, and communicated as a customer-centric operational system. Externs study the case manager’s role at IMH to understand how workflows shape patient experience, surface hidden risks, and make invisible coordination work visible. Through structured analysis, process mapping, and dashboard prototyping, externs learn how operational clarity supports continuity of care, safety, and institutional decision-making.

Stakeholder MappingSystems ThinkingProcess MappingChange Management

Overview

The project examined care coordination workflows at the Institute of Mental Health, mapping the case manager role and related processes. The work combined process mapping, structured analysis, and dashboard prototyping to make coordination tasks and risks visible. Deliverables included process maps and prototype dashboards representing workflow data.

Healthcare Operations & Consulting Externship

What I've accomplished

I produced a consolidated scope-of-work spreadsheet and annotated workflow maps that documented case manager responsibilities, crisis coordination tasks, transitions, information-integration steps, and identified daily pain points.

Project breakdown

The module presented a case study of inpatient mental health operations. I mapped case manager responsibilities, daily workflows, pain points, and direct quotes, and produced a consolidated scope-of-work spreadsheet detailing tasks like crisis coordination, transitions, and information integration.

Google Sheets
Access
View all work