michael-panico-portfolio -- verified public surface
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.

Manual work removed

20+ hrs/week

Automation delivered on recurring reporting workflows.

Predictive model impact

$277K

Annual savings tied to ticket reassignment prediction work.

Revenue signal surfaced

$12.7M

Sales-driver analysis tied analytics to commercial decision-making.

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.

20+ hrs/week removed from recurring reporting work
$277K in modeled savings tied to predictive analytics
$12.7M revenue signal surfaced through commercial analysis
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

Project atlas

Seven project snapshots, kept scannable at first pass.

Fast snapshots here, deeper context in the project library: technical depth, proof surfaces, methodology details, and full project context.

Open full project library
Live

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.

Headline outcome

Reporting cadence scaled beyond manual capacity

Power BIDAXPower QueryVBA

20+ hours/week removed from recurring reporting and follow-up effort.

Deep dive
In Progress

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.

Headline outcome

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.

Deep dive
Completed

Adidas IT · Gradient Boosting

Ticket Reassignment Prediction

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

Headline outcome

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 annual labor savings, with additional downtime savings cited in the project materials.

Deep dive
Completed

Regression + cross-validation

Spotify Popularity Prediction

Regression case study focused on feature interpretation, model significance, and communication of statistical results.

Headline outcome

Turned audio features into business-readable popularity signals

PythonRegressionCross ValidationFeature Analysis

Statistically significant feature analysis and model interpretation, positioned as an interpretable analytics case study rather than a hard business-impact claim.

Deep dive
Completed

TF-IDF + logistic regression

Yelp Review Rating / Sentiment Modeling

Restaurant review modeling using NLP preprocessing, TF-IDF, sentiment analyzers, and logistic regression.

Headline outcome

Customer review text became a usable service-improvement signal

PythonTF-IDFLogistic RegressionVADER

High-accuracy sentiment classification paired with operational feedback a manager could act on, as documented in the final project materials.

Deep dive
Completed

Multivariable regression

TJIX Net Sales Drivers

Commercial analytics case study combining regression, benchmarking, and scenario framing to explain net-sales growth levers.

Headline outcome

Advertising and e-commerce were tied directly to net-sales upside

RegressionCorrelation AnalysisExcelDecision Trees

Final materials attribute roughly $12.7M in net-sales lift per additional $1M in advertising spend.

Deep dive
Completed

Access + SQL queries

Relational Database Design

Normalized database design for projects, employees, tickets, services, and client reporting.

Headline outcome

Operations data became structured, relational, and report-ready

Microsoft AccessSQLERD DesignNormalization

Replaced spreadsheet thinking with a structured data model built for queryability, reporting consistency, and future operational growth.

Deep dive
In Progress

Python + SQLite + Streamlit

Institutional Market Data Engine

The public-facing proof surface for the market-data analytics lane, connecting ingestion, SQLite storage, dashboard review, source governance, and adjacent QuantStrat ML research docs.

Headline outcome

Market-data experiments became governed analytics workflows

PythonSQLiteStreamlitPandas

Shows practical financial-data engineering, dashboarding, source governance, and validation discipline without exposing live credentials, token files, private databases, broker/account data, or production quant runtime state.

Deep dive
In Progress

Plaid API + Apps Script + Gemini

Local-First Financial Intelligence

A local-first finance automation project combining a Python sync engine, spreadsheet data marts, deterministic local analytics, and a bounded Gemini sidebar over explicitly supplied context.

Headline outcome

Private financial records became a local-first analytics workflow

PythonGoogle Apps ScriptGemini APIPlaid API

Shows practical privacy judgment, fintech integration skill, and multi-system automation across Python, Plaid, Google Sheets, Apps Script, charts, and bounded AI assistance.

Deep dive
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 2024

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.

Jun 2024 - Sep 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