/Users/MichaelPanico/Portfolio -- -zsh
live system
Recruiter-first briefing

Proof over polish, with enough polish to hold attention.

This portfolio is designed to answer the recruiter questions that matter fastest: what Michael builds, what business leverage he creates, and why his operator-first background makes the analytics work stronger.

Manual work removed

20+ hrs/week

Automation delivered on recurring reporting workflows.

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.

Quick recruiter summary

BI builder with operator instincts and measurable automation leverage.

Michael is strongest in business intelligence, analytics, and automation work that turns vague stakeholder asks into reporting systems, cleaner KPI logic, and decision-ready outputs.

20+ hrs/week removed from recurring reporting work
$280K in modeled savings tied to predictive analytics
$12.7M revenue signal surfaced through commercial analysis
B.S. in Business Analytics expected June 2026

Recruiter read

Strongest when a team needs someone who can absorb messy asks, structure the reporting logic, automate the repetitive pieces, and still explain the result clearly to stakeholders.

Signal path

Trajectory snapshot

Operator pressure turned into analytics judgment.

The portfolio is built around the same pattern that shows up across Michael's work: 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 · BI Developer

Current posture

Portfolio first, PDF resume second

Location

Phoenix, Arizona

Current status

B.S. Business Analytics, expected June 2026

Project atlas

Seven serious projects, kept scannable on the homepage.

The homepage stays fast. The full technical depth, proof surfaces, and methodology details now live in the dedicated project library.

Portfolio rule

Equal visual seriousness for every major project, without turning the landing page into a wall of case-study prose.

Live

Power BI + stakeholder adoption

Command Center BI Infrastructure

Internal BI infrastructure for KPI clarity, adoption tracking, and recurring executive reporting at Avnet.

Headline outcome

Reporting cadence scaled beyond manual capacity

Power BIDAXPower QueryVBA

20+ hours per week removed from manual reporting and follow-up effort

Deep dive
Live

CLI orchestration + durable context

Gemini/Codex Workflow Automation

A multi-agent automation system for context persistence, cross-model handoff, and deterministic session close-out.

Headline outcome

Multi-agent AI work stopped depending on chat memory

ShellPythonGemini CLICodex CLI

100 automation scripts, 34 operating docs, and 58 research receipts in a working cross-model CLI workflow ecosystem

Deep dive
Completed

Adidas IT · Gradient Boosting

Ticket Reassignment Prediction

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

Headline outcome

Reassigned tickets averaged roughly a week longer to resolve

Pythonscikit-learnFeature EngineeringModel Evaluation

76% accuracy, 86% recall, 73% F1, and roughly $280K in modeled annual labor savings

Deep dive
Completed

Regression + cross-validation

Spotify Popularity Prediction

Regression case study focused on feature interpretation, model significance, and business-readable music analytics.

Headline outcome

Turned audio features into business-readable popularity signals

PythonRegressionCross ValidationFeature Analysis

Statistically significant regression work with feature-level interpretation instead of inflated black-box claims

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 signals a manager could act on

Deep dive
Completed

Multivariable regression

TJIX Net Sales Drivers

Retail and e-commerce driver analysis combining regression, industry benchmarking, and scenario-based recommendation framing.

Headline outcome

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

RegressionCorrelation AnalysisExcelDecision Trees

Estimated ~$12.7M in net-sales lift per +$1M of advertising spend in the final model

Deep dive
Completed

Access + SQL queries

Relational Database Design

Normalized Access 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 relational model built for queryability, consistency, and future growth

Deep dive
Skills snapshot

Technical range without a giant taxonomy.

Enough signal for a recruiter to understand the stack quickly, without turning the homepage into a full capability matrix.

Analytics

Power BIDAXPower Query (M)SQLKPI DesignRLS

Programming

Pythonpandasscikit-learnRegressionClassificationGradient Boosting

Automation

Workflow AutomationVBADocumentationQA 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 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
Career arc preview

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

The full chronology lives on the web CV. The homepage just shows the progression quickly: operator foundation, analytics entry, automation buildout, and current recruiter-facing positioning.

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

Portfolio-Led Builder Positioning

Recruiter-facing narrative · Phoenix, Arizona

automation

Packaging operational credibility, analytics rigor, and automation instinct into a recruiter-first personal product.

Social proof

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, analytics, BI developer, and automation conversations.

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, ArizonaSanitized proof friendly
Business Intelligence Analyst
Data Analyst
BI Developer
Analytics / Automation
Operations Intelligence

Hidden in plain sight

LinkedIn

linkedin.com/in/michaelspanico

GitHub

github.com/mp2123

Resume PDF

Download the current one-page resume