Available for opportunities

Ivan
Piniella

Data Analyst  ·  Healthcare Data  ·  IBM Certified

SQL Python Power BI Tableau Excel Gen AI PostgreSQL
👤

Ivan Piniella

Records Analyzed
968K+
Certification
IBM Data Science

Tools & Technologies

📋
Excel
🤖
Generative AI
🐼
Pandas
📉
Matplotlib / Seaborn
📓
Jupyter Notebook
🔗
GitHub / VS Code
🌐
Socrata API
🧠
Machine Learning
🏅

IBM Data Science Professional Certificate

Covers Python, SQL, data visualization, machine learning, and model evaluation — beyond typical junior DA requirements.

Certified

Featured Projects

🚑
Public Safety
PROJECT / 01

FDNY EMS Incident Dispatch Analysis

SQL PostgreSQL pgAdmin Python Power BI
  • Analyzed ~968K FDNY EMS incident records from 2024 using PostgreSQL and pgAdmin to uncover response time patterns and dispatch trends.
  • Wrote complex SQL queries with CTEs, window functions, and aggregations to transform raw 911 data into operational insights.
  • Sourced live data via the NYC Open Data Socrata API and built a structured, reproducible pipeline in Python.
  • Expanding with multi-year comparisons, Python EDA, and a Power BI / Tableau dashboard phase.
📣
Marketing Analytics
PROJECT / 02

Facebook Ads Manager Performance Analysis

Python Pandas Excel Power BI
  • Analyzed real ad campaign data from personal Facebook Ads Manager to derive performance insights and ROI patterns.
  • Cleaned and transformed raw campaign export data using Pandas to surface click-through rates, cost-per-result trends, and audience performance.
  • Built visualizations to identify top-performing ad sets, budget allocation opportunities, and engagement anomalies.
  • Demonstrates ability to work with proprietary business data and translate metrics into actionable recommendations.
📍  New York, USA

"Turning raw data into clarity — one query at a time."

I'm a self-taught data analyst in career transition, building a portfolio of end-to-end projects that span SQL analysis, Python EDA, and BI dashboard development. My approach is hands-on and iterative — I work with real, publicly available datasets and structured pipelines that reflect production-level workflows.

My IBM Data Science Professional Certificate gives me skills beyond the typical junior DA baseline — including machine learning, class imbalance handling, and model evaluation metrics. My long-term focus is on the healthcare data space, both as a practitioner and entrepreneur.

When I'm not building projects, I'm reinforcing my Python fundamentals through daily practice and exploring how Generative AI can augment the analyst's toolkit.

Self-taught via IBM certification & project-based learning
Focused on healthcare data as a long-term specialty
End-to-end projects: SQL → Python → BI visualization
Active on GitHub & LinkedIn — shipping consistently

Career History

2024 – Present
Your Current Role

💼 [Current Role Title]

SQL Python Data Analysis
  • Add your current experience bullets here — tailor to quantifiable achievements and tools used.
  • Focus on data-related responsibilities even if your title isn't officially "Data Analyst."
Previous Role
Previous Company

💼 [Previous Role Title]

Excel Reporting
  • Add your previous experience here — highlight any data, analysis, or reporting responsibilities.
  • Quantify impact wherever possible (e.g. "Analyzed X, resulting in Y% improvement").
2023
IBM / Coursera

🏅 IBM Data Science Professional Certificate

Python SQL Machine Learning Data Visualization Model Evaluation
  • Completed a 10-course program covering the full data science lifecycle, from data wrangling to machine learning and model deployment.
  • Gained skills in class imbalance handling, model evaluation metrics, and Python-based ML pipelines — skills that exceed typical junior DA requirements.