Mira Solano

• Built Looker and Tableau dashboards tracking weekly product KPIs across user engagement and retention, actively used by 4 product squads. • Wrote optimized SQL queries in BigQuery to extract and clean funnel and retention datasets, cutting ad-hoc data request turnaround time by ~40%. • Partnered closely with PMs on standardized A/B test readout templates and documented metric definitions and data dictionaries in Notion.

• Automated weekly inventory variance and discrepancy reporting in Python using pandas, saving operations teams ~6 hours per week. • Segmented customer cohorts for targeted lifecycle marketing emails, supporting a +3 percentage point open-rate lift on seasonal promotional campaigns. • QA'd CRM data exports and reconciled discrepancy logs against physical warehouse counts prior to executive leadership reviews.

• Cleaned and analyzed longitudinal survey data for over 1,200 graduating students and produced presentation-ready charts for the annual career outcomes report. • Maintained and streamlined internal Excel and Google Sheets tracking workflows for on-campus employer recruiting events and student attendance.

Graduated with 3.6 GPA. Relevant coursework: Business Intelligence, Relational Databases & SQL, Statistical Methods for Data Science, Predictive Analytics, Spreadsheet Modeling, and Data Visualization.

Comprehensive hands-on training in end-to-end data analysis workflows including data cleaning, SQL query design, Tableau dashboard development, and analytical case studies.