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
Portfolio-first CV for recruiters who want the concise version and the deeper proof behind it.
Business analytics builder with a hospitality leadership foundation.
Strongest in Power BI, SQL, Python, workflow automation, and stakeholder translation.
Best fit for BI, analytics, BI developer, and operations-intelligence roles.
Based in Phoenix and currently completing a B.S. in Business Analytics, expected June 2026.
Predictive model impact
$280K
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.
- Co-led 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.
Portfolio-Led Builder Positioning
Recruiter-facing narrative
Packaging operational credibility, analytics rigor, and automation instinct into a recruiter-first personal product.
- Highlights quantified outcomes instead of generic resume bullets.
- Frames cross-functional leadership as a technical advantage, not a tangent.
- Creates clear paths for BI, analytics, automation, and operations-intelligence conversations.
Selected Projects
Command Center BI Infrastructure
Power BI + stakeholder adoption
Built scalable reporting systems that turned fragmented sales data into decision-ready operating visibility.
Operational leverage: 20+ hours per week removed from manual reporting and follow-up effort
Gemini/Codex Workflow Automation
CLI orchestration + durable context
Built a file-driven AI orchestration system that keeps Gemini CLI and Codex CLI aligned through durable context, reconciliation, and validation gates.
System scale: 100 automation scripts, 34 operating docs, and 58 research receipts in a working cross-model CLI workflow ecosystem
Ticket Reassignment Prediction
Adidas IT · Gradient Boosting
Modeled IT ticket reassignment behavior to reduce escalation friction, rerouting cost, and downtime risk.
Model performance: 76% accuracy, 86% recall, 73% F1, and roughly $280K in modeled annual labor savings
Spotify Popularity Prediction
Regression + cross-validation
Used audio-feature data to model song popularity and translate statistical results into product and marketing recommendations.
Model insight: Statistically significant regression work with feature-level interpretation instead of inflated black-box claims
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 signals a manager could act on
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: Estimated ~$12.7M in net-sales lift per +$1M of advertising spend in the final model
Relational Database Design
Access + SQL queries
Designed a relational database structure to replace spreadsheet-driven project and staffing tracking for a growing IT support business.
Systems design: Replaced spreadsheet thinking with a relational model built for queryability, consistency, and future growth
Skills
Core technical and functional domains used across projects.
Analytics
Power BIDAXPower Query (M)SQLKPI DesignRLS
Programming
Pythonpandasscikit-learnRegressionClassificationGradient Boosting
Automation
Workflow AutomationVBADocumentationQA 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 fast recruiter handoff for anyone who wants the one-page version before diving deeper.
Phoenix, Arizona
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, and recruiter-facing positioning all connect without crowding the homepage.
Globe mode
A live route map across Chicago, Iowa City, and Phoenix with stage cards that refocus the story in place.
Systems map
A single orbital stage model shows how the operator, analytics, automation, and portfolio-builder 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.
Portfolio-Led Builder Positioning
Now
Emerging
Packaging operational credibility, analytics rigor, and automation instinct into a recruiter-first personal product.
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 15+ 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.
What it shows
Recipe judgment, visual presentation, and the hospitality side of the broader portfolio.
Future state
Ready for your spreadsheet-backed cocktail catalog once the full recipe sheet lands.
Negroni
Paper Plane
Last Word
Old Fashioned
Margarita
Espresso Martini
Capabilities matrix
Full technical capability view, organized for deeper review.
The homepage handles the first-pass skim. This section keeps the deeper technical surface available in a more deliberate, review-friendly layout.
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
6 signals
Power BI
DAX
Power Query (M)
SQL
KPI Design
RLS
Programming
6 signals
Python
pandas
scikit-learn
Regression
Classification
Gradient Boosting
Automation
6 signals
Workflow Automation
VBA
Documentation
QA Thinking
Repeatable Reporting
Databricks
Operator Strengths
6 signals
Stakeholder Translation
Leadership
Prioritization
Crisis Management
High-Volume Ops
Team Coaching