Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
pwb
Ian Olivo

Ian Olivo

Bronx

Summary

Results-driven Sr. Data Analyst & Project Manager with over 5 years of experience transforming complex datasets into actionable insights that enhance operational efficiency and inform business strategy. Skilled in designing automated data pipelines and developing scalable BI dashboards using Tableau, Python, SQL, and Google BigQuery. Proficient in Excel, including PivotTables, Power Query, and VBA, with a strong history of automating reports to facilitate data-driven decision-making. Bilingual in Spanish and English, experienced in supporting multi-site teams and executive leadership.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Project Manager / Data Analyst

Essen Health Care
Manhattan, NY
04 2022 - Current
  • Designing and automating daily, weekly, and monthly Excel dashboards (PivotTables, Power Query, VBA) tracking productivity for 6 General Managers, 20 Supervisors, and 200+ staff.
  • Partnering with Senior VP, Executive and engineering teams to ensure data design testing, budget adherence, resource optimization and validation of reporting workflows.
  • Building data workflows and dashboards that ensured consistent integrity across multi-site operational data.
  • Creating, developing, supporting, updating and maintaining KPI, Sharepoint Data bases and advanced analytics projects while translating business needs into technical requirements.
  • Utilizing Python, Jupyter Notebooks, and Pandas to rapidly clean, transform, and analyze large datasets; automated recurring data preparation workflows, accelerated reporting turnaround time by 40%+, and delivered actionable insights to leadership through reproducible, scalable code-based reporting tools.
  • Scheduling and facilitating meetings between project stakeholders to discuss deliverables, schedules and conflicting

Account Executive

Lake 5 Media
Manhattan, NY
12.2018 - 04.2022
  • Developed and managed reporting systems for executive-level projects, improving visibility into timelines, budgets, and workflows.
  • Streamlined document organization and workflow tracking using Excel and digital tools, reducing administrative overhead.
  • Analyzed CEO scheduling, priorities, and project logistics to optimize resource allocation and decision-making.
  • Coordinated domestic and international travel and expenses, producing standardized tracking reports.
  • Supported high-pressure projects by translating complex operational data into actionable insights for executive planning.
  • Delivered media measurement and campaign analytics, applying cross-platform metrics to evaluate performance and guide strategy.
  • Produced executive-facing data visualizations and reporting tools to communicate campaign effectiveness.

Loaner Coordinator

BMW of Manhattan
Manhattan, NY
07.2017 - 12.2018
  • Analyzed vehicle usage and turnaround data, reducing average loaner cycle time from 6.75 to 2.5 days and improving fleet availability.
  • Developed and maintained Excel-based tracking systems to monitor service schedules, vehicle utilization, and performance KPIs.
  • Consolidated vehicle maintenance, ticketing, and damage data into structured reports, enabling management to identify cost drivers.
  • Produced weekly performance dashboards for service managers, improving forecasting accuracy and resource allocation.
  • Implemented data-driven decision support tools that forecasted vehicle demand and optimized fleet utilization.

Education

B.S. - Business Administration

Monroe College
Bronx, NY

Skills

  • BigQuery reporting solutions
  • Dashboard design and deployment KPI analysis with Tableau Python data processing
  • Performance tuning
  • Data integrity assessments
  • Data analysis techniques
  • SQL expertise BigQuery proficiency Excel analytics Tableau dashboards Python and R coding
  • Microsoft productivity tools Team collaboration software
  • Collaboration and documentation tools
  • KPI tracking Data visualization Automated reporting
  • English and Spanish speaker

Certification

  • SQL Professional Certification (Professional Level)
  • OSHA 10 Certified

Languages

Spanish
Native or Bilingual

Timeline

Account Executive

Lake 5 Media
12.2018 - 04.2022

Loaner Coordinator

BMW of Manhattan
07.2017 - 12.2018

Project Manager / Data Analyst

Essen Health Care
04 2022 - Current

B.S. - Business Administration

Monroe College