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
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.
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.
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.
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.
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.
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.
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.
Experience map
Operator experience, analytics work, and systems thinking in one view.
The interactive career map connects frontline leadership, Avnet analytics work, automation projects, current systems-building, OSU coursework, and ongoing project development.
Frontline Hospitality Leadership
Aug 2016 - Sep 2024
Established
Built frontline leadership and operational discipline in high-pressure environments where trust, speed, and judgment mattered every shift.
Promoted from bartender to manager across high-volume hospitality operations.
Drove 35% year-over-year net profit growth and 18% bar profit through labor, purchasing, and process optimization.
Built repeatable systems for staffing, inventory, and guest experience under pressure, a pattern that now carries into analytics and automation work.
Momentum88%
Connected stages
Analytics Entry Point
Jun 2024 - Sep 2024
Established
Moved from business questions to decision-ready metrics by building dashboards, KPI logic, and recurring reporting outputs.
Automation and Predictive Systems
May 2025 - Jan 2026
Compounding
Expanded from dashboarding into automation, predictive analytics, adoption-focused BI infrastructure, and teammate enablement across sales enablement.
Systems and Analytics Buildout
Now
Emerging
Building analytics, automation, market-data, and AI-assisted workflow systems while completing B.S. Business Analytics coursework and working in Chicago hospitality.
Established
Aug 2016 - Sep 2024
Frontline Hospitality Leadership
Hilton Hotels & Resorts · Phoenix, Arizona
Built frontline leadership and operational discipline in high-pressure environments where trust, speed, and judgment mattered every shift.
Promoted from bartender to manager across high-volume hospitality operations.
Drove 35% year-over-year net profit growth and 18% bar profit through labor, purchasing, and process optimization.
Built repeatable systems for staffing, inventory, and guest experience under pressure, a pattern that now carries into analytics and automation work.
Momentum88%
Connected stages
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.