Skip to main content
Michael Panico · Portfolio
live system
Proof-first briefing

Practical proof, organized for fast evaluation.

The work is organized around the questions that matter most: what was built, what business leverage it creates, and why an operator-first background makes the analytics work stronger.

Follow-Ups preparation

4–5h → 15–30m

Per cycle. Expanded data and recipient scope would require about 20 hours/week manually, not measured time savings.

Modeled labor-savings scenario

$277K

Academic scenario using assumed ticket costs/benefits, not realized savings.

Exploratory sales regression

10 observations

10 annual observations; association, not causal lift. Advertising p = .103; 95% interval includes zero.

Operator-side impact

35% YoY profit

Delivered before the analytics pivot through high-volume hospitality leadership.

Quick professional summary

BI and financial-data builder with operator instincts.

Strongest in business intelligence, financial-data reporting, market-data curiosity, analytics, and automation work that turns vague stakeholder asks into cleaner KPI logic and decision-ready outputs.

4–5h → 15–30m Follow-Ups preparation per cycle
$277K academic labor-savings scenario, not realized savings
10 observations in an exploratory sales regression, not causal lift
B.S. in Business Analytics expected Spring 2027

Professional read

Strongest when a team needs someone who can absorb messy asks, structure the reporting logic, automate the repetitive pieces, and explain the financial, market, or operational signal clearly to stakeholders.

Signal path

Trajectory snapshot

Operator pressure turned into analytics judgment.

Across my work, the pattern is consistent: absorb ambiguity fast, translate it into a cleaner system, then hand back something stakeholders can actually use.

hospitalityanalyticsautomationstorytelling

Best-fit roles

Business Intelligence Analyst · Data Analyst · Financial Analyst · Market Data Analyst

Professional focus

Business analytics, BI, financial data

Location

Greater Chicago Area

Current status

B.S. Business Analytics, expected Spring 2027

Featured work

Three ways I turn data and workflows into useful tools.

Start with BI reporting, applied machine learning, and agent-assisted workflows. Explore all projects for methods, artifacts, contributions, and limitations.

Open full project library
Internship experience

Power BI + stakeholder adoption

Command Center BI Infrastructure

Internal BI infrastructure for KPI clarity, adoption tracking, and recurring executive reporting inside Avnet's Command Center buildout.

What the work demonstrates

Reporting cadence scaled beyond manual capacity

Power BIDAXPower QueryVBA

Follow-Ups preparation reduced from 4–5 hours to 15–30 minutes per cycle. Expanded recipient and data scope would have required about 20 hours/week manually, not measured savings.

View case study
Academic team project

Adidas IT · Gradient Boosting

Ticket Reassignment Prediction

Classification case study for identifying reassigned tickets before extra handling time and store downtime accumulate.

What the work demonstrates

Preventable routing friction became a measurable prediction target

Pythonscikit-learnFeature EngineeringModel Evaluation

Approximately 76.1% accuracy, 85.8% recall, 73.3% F1, and about $277K in modeled annual labor savings (not realized savings). Assumption-based academic scenario, not deployment evidence.

View case study
Workflow documentation

AI workflows + durable context

Gemini/Codex Workflow Automation

A multi-agent workflow system for durable context, cross-model handoff, explicit guardrails, and deterministic session close-out.

What the work demonstrates

Multi-agent AI work stopped depending on chat memory

ShellPythonGemini CLICodex CLI

Working system with 100 scripts, 34 docs, and 58 research artifacts in the read-only source repo.

View case study
Skills snapshot

Technical range without a giant taxonomy.

Enough signal to understand the stack quickly, without turning the first pass into a full capability matrix.

Analytics

Power BIDAXPower Query (M)SQLKPI DesignFinancial / Market DataRLS

Programming

Pythonpandasscikit-learnRegressionClassificationGradient Boosting

Automation & Systems

Workflow AutomationAgentic Workflow SystemsVBADocumentationQA ThinkingRepeatable ReportingDatabricks

Operator Strengths

Stakeholder TranslationLeadershipPrioritizationCrisis ManagementHigh-Volume OpsTeam Coaching

The Non-Traditional Advantage

The same judgment required to protect margins, lead teams, and keep service moving under pressure now shows up in my analytics and automation work.

High-Volume Operations

Hospitality Management

  • People & Crisis Management

    Led high-volume operations and coached 50+ employees while resolving guest and operational issues in real time.

  • Profit and Process Ownership

    Drove 35% YoY net profit growth and roughly 18% bar profit improvement through inventory, labor, and service-process discipline.

Transferable edge

Margin awareness, prioritization under pressure, and the ability to keep teams aligned while things are moving fast.

Scalable Data Systems

Business Analytics

  • Stakeholder Translation

    Translated messy stakeholder asks into structured Power BI models, KPI layers, and reporting outputs people could actually use.

  • Automated Throughput

    Automated recurring reporting, added QA checks, and connected predictive Python work to business-facing Power BI outputs.

Current leverage

BI systems, analytics, and automation that turn operational ambiguity into cleaner reporting cadence and better decisions.

Hospitality-side bonus

Spin up a random craft cocktail.

A small bartender-side module for anyone who wants to see the service craft behind the operator story. Press the rotor and pull a full build, garnish, and glassware call for a seeded classic.

Service craft

Recipe judgment, visual presentation, pacing, and hospitality detail from high-volume service work.

Current scope

A focused public sampler that keeps the bartender experience complete and lightweight.

Career arc preview

Chicago to Iowa City to Phoenix to Greater Chicago, with the throughline intact.

The full chronology lives on the web CV. This first pass shows the progression quickly: operator foundation, analytics entry, automation buildout, and current systems-building focus.

Open web CV

Aug 2016 - Sep 2025

Frontline Hospitality Leadership

Hilton Hotels & Resorts · Phoenix, Arizona

hospitality

Built frontline leadership and operational discipline in high-pressure environments where trust, speed, and judgment mattered every shift.

May 2024 - Aug 2024

Analytics Entry Point

Avnet · Phoenix, Arizona

analytics

Moved from business questions to decision-ready metrics by building dashboards, KPI logic, and recurring reporting outputs.

May 2025 - Jan 2026

Automation and Predictive Systems

Avnet · Phoenix, Arizona

automation

Expanded from dashboarding into automation, predictive analytics, adoption-focused BI infrastructure, and teammate enablement across sales enablement.

Now

Systems and Analytics Buildout

Independent projects + OSU coursework · Greater Chicago Area

automation

Building analytics, automation, market-data, and AI-assisted workflow systems while completing B.S. Business Analytics coursework and working in Chicago hospitality.

Recommendations

What leaders noticed first.

The throughline is consistent: strong judgment under pressure, fast ramp-up, and work that leaves the system better than before.

managerreference signal

"Michael brought tremendous value to my team during his internship. He quickly understood our business needs and consistently went above and beyond to solve challenges, including turning a manual process that took hours into an automated solution completed in about 30 minutes."

Rashmi

Global Sales Enablement Manager

Avnet

operatorreference signal

"Michael’s attention to detail, interpersonal strength, and instinct for consumer habits helped him grow quickly into management responsibilities. He is dedicated, adaptable, and willing to push himself into new domains."

Tania

General Manager

Multi-Unit Hospitality Group

Contact funnel

Open to BI, data analytics, financial-data, market-data, quant-adjacent analytics, and automation conversations.

This site is the fuller portfolio and working CV. The PDF resume is available as a concise one-page version for anyone who wants the one-page version before diving deeper.

Greater Chicago AreaSanitized proof friendly
Business Intelligence Analyst
Data Analyst
Financial Analyst
Market Data Analyst
Business Analyst
Quantitative Analyst Intern (stretch)
Analytics / Automation

Hidden in plain sight

LinkedIn

linkedin.com/in/michaelspanico

GitHub

github.com/mp2123

Resume PDF

Download the current one-page resume