Manual work removed
20+ hrs/week
Automation delivered on recurring reporting workflows.
Web CV
Michael Panico
Web CV
Michael Panico
Business Analytics, BI, and Automation
Working across business analytics, BI systems, financial-data visibility, automation, OSU business analytics coursework, and applied project development.
Business analytics builder with a hospitality leadership foundation.
Strongest in Power BI, SQL, Python, workflow automation, financial-data visibility, and stakeholder translation.
Best fit for BI, data analytics, financial analyst, market-data analyst, and automation roles.
Based in the Greater Chicago Area and completing a B.S. in Business Analytics, expected Spring 2027.
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.
Experience
Frontline Hospitality Leadership
Hilton Hotels & Resorts
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.
Analytics Entry Point
Avnet
Moved from business questions to decision-ready metrics by building dashboards, KPI logic, and recurring reporting outputs.
- Built Power BI dashboards and DAX KPI layers for opportunity visibility and executive trend reporting.
- Partnered with marketing and data-engineering stakeholders to translate messy asks into scalable reporting outputs.
- Established the analyst-to-stakeholder communication style that anchors the current portfolio.
Automation and Predictive Systems
Avnet
Expanded from dashboarding into automation, predictive analytics, adoption-focused BI infrastructure, and teammate enablement across sales enablement.
- Supported the multi-year Command Center expansion with scalable Power BI models, DAX logic, and Power Query transformations.
- Integrated Python-based predictive analytics into business-facing Power BI outputs for opportunity and forecasting use cases.
- Automated recurring workflows with VBA and QA checks, saving 20+ hours per week while producing enablement materials that improved self-serve usage.
Systems and Analytics Buildout
Independent projects + OSU coursework
Building analytics, automation, market-data, and AI-assisted workflow systems while completing B.S. Business Analytics coursework and working in Chicago hospitality.
- Continuing applied project work across BI, financial-data visibility, market-data analysis, workflow automation, and AI-assisted systems.
- Expanding the Avnet analytics foundation through private buildouts, public-safe docs, and validation-focused project artifacts.
- Balancing current hospitality work, OSU coursework, and systems development while targeting entry-level analyst and quant-adjacent opportunities.
Selected Projects
Command Center BI Infrastructure
Power BI + stakeholder adoption
Built scalable Power BI reporting systems that turned fragmented sales data into decision-ready operating visibility.
Operational leverage: 20+ hours/week removed from recurring reporting and follow-up effort.
Gemini/Codex Workflow Automation
AI workflows + durable context
Built a file-driven AI workflow system that keeps Gemini CLI and Codex CLI aligned through durable context, reconciliation, and validation gates.
System scale: Working system with 100 scripts, 34 docs, and 58 research artifacts in the read-only source repo.
Ticket Reassignment Prediction
Adidas IT · Gradient Boosting
Modeled IT ticket reassignment behavior to reduce escalation friction, rerouting cost, and downtime risk.
Model performance: 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.
Spotify Popularity Prediction
Regression + cross-validation
Used audio-feature data to model song popularity and translate statistical results into business-readable recommendations.
Model insight: Statistically significant feature analysis and model interpretation, positioned as an interpretable analytics case study rather than a hard business-impact claim.
Yelp Review Rating / Sentiment Modeling
TF-IDF + logistic regression
Built a text-mining workflow to classify Yelp review sentiment and surface operational signals from customer language.
Decision support: High-accuracy sentiment classification paired with operational feedback a manager could act on, as documented in the final project materials.
TJIX Net Sales Drivers
Multivariable regression
Linked advertising, e-commerce growth, and market trends to a business-readable net-sales growth story for TJX.
Revenue signal: Final materials attribute roughly $12.7M in net-sales lift per additional $1M in advertising spend.
Relational Database Design
Access + SQL queries
Designed a relational data model to replace spreadsheet-driven project and staffing tracking for a growing IT support business.
Systems design: Replaced spreadsheet thinking with a structured data model built for queryability, reporting consistency, and future operational growth.
Institutional Market Data Engine
Python + SQLite + Streamlit
Private Python/SQLite/Streamlit workspace for market-data ingestion, local storage, dashboard review, risk summaries, and validation-oriented market-data experiments.
Data scale: 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.
Local-First Financial Intelligence
Plaid API + Apps Script + Gemini
Private Python/Google Apps Script finance-automation project with Plaid sync, spreadsheet data modeling, and a local Gemini sidebar for grounded financial questions.
AI Automation: Shows practical privacy judgment, fintech integration skill, and multi-system automation across Python, Plaid, Google Sheets, Apps Script, charts, and bounded AI assistance.
Skills
Core technical and functional domains used across projects.
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
Recommendations
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.
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.
Contact
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 Area
michael_s_panico@outlook.com
linkedin.com/in/michaelspanico
github.com/mp2123
Experience visuals
Geography, stage progression, and systems-thinking context.
This is the deeper visual layer for the career arc: where the geography, stage sequencing, analytics work, systems projects, and current learning path connect without crowding the main overview.
Globe mode
A live route map across Chicago, Iowa City, Phoenix, and Greater Chicago with stage cards that refocus the story in place.
Systems map
A single orbital stage model shows how the operator, analytics, automation, and current systems-building phases connect.
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.
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.
Capabilities matrix
Full technical capability view, organized for deeper review.
This section keeps the deeper technical surface available in a deliberate layout for skills, systems, and project-capability review.
Analytics systems
Power BI, DAX, Power Query, SQL, KPI design, and reporting architecture.
Automation rigor
Workflow cleanup, QA thinking, documentation, and recurring-output reliability.
Operator translation
Stakeholder framing, pressure handling, prioritization, and people-facing execution.
Analytics
7 signals
Power BI
DAX
Power Query (M)
SQL
KPI Design
Financial / Market Data
RLS
Programming
6 signals
Python
pandas
scikit-learn
Regression
Classification
Gradient Boosting
Automation & Systems
7 signals
Workflow Automation
Agentic Workflow Systems
VBA
Documentation
QA Thinking
Repeatable Reporting
Databricks
Operator Strengths
6 signals
Stakeholder Translation
Leadership
Prioritization
Crisis Management
High-Volume Ops
Team Coaching