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.

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 to uncover response time patterns and dispatch trends across NYC.
  • 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.
🚗
Public Safety
PROJECT / 02

US Traffic Accidents Analysis (2016–2023)

SQL DuckDB Python Jupyter Notebook Data Visualization
  • Analyzed 7.7M+ US car accident records (2016–2023) using SQL via DuckDB inside a Python/Jupyter environment.
  • Identified California as the leading state for accidents, with Miami topping all cities at 186,768 incidents.
  • Uncovered that accidents in fair weather are 2.5× higher than in mostly cloudy conditions — challenging common assumptions.
  • Revealed peak accident hours align with working hours, and December, November, and January as the highest-risk months.
📣
Marketing Analytics
PROJECT / 03

Facebook Ads Manager Performance Analysis

Python Pandas Excel Power BI
  • Analyzed real ad campaign data from personal Facebook Ads Manager, leveraging 9+ years of digital marketing expertise.
  • Cleaned and transformed raw campaign exports 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 business data and translate marketing metrics into actionable insights.
Ivan Piniella
📍  New York / New Jersey, 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.

With a background spanning digital marketing, sales management, and customer service, I bring a rare combination of business intuition and technical skill to every analysis. My IBM Data Science Professional Certificate deepens my capabilities with 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.

IBM Data Science certified — ML, EDA, and beyond
9+ years of business & marketing experience
End-to-end projects: SQL → Python → BI
Focused on healthcare data as a long-term specialty

Education

🎓
Master Executive in Technology & Industrial Business Management
EOI — Spain
2014
🎓
Bachelor's Degree in Business Administration
UNAPEC
2007

Career History

June 2022 – Present
Labcorp · New Jersey

🔬 Customer Service Representative

LogisticsOperationsHealthcare
  • Managed time-sensitive transport of medical specimens across 50+ daily pickups, maintaining 98%+ on-time accuracy and ensuring integrity of healthcare data documentation.
  • Coordinated routing and collaborated with dispatch teams to optimize delivery efficiency, reducing turnaround time through data-informed scheduling decisions.
  • Operated within HIPAA-compliant healthcare workflows, developing firsthand familiarity with medical data standards and patient-adjacent operations.
Jan 2021 – Present
The Home Depot · Paterson, NJ

🏠 Pro Service Associate

Customer ServiceSalesOperations
  • Provide fast, friendly service by actively seeking out customers to assess their needs and provide project-level assistance.
  • Deliver customer service across return processes, curbside pickups, online order pickups, and account payments.
  • Maintain a safe working and shopping environment by following all safety policies and completing required safety training.
Apr 2015 – Aug 2024
Marketing Useful · Paterson, NJ

📣 Entrepreneur / Small Business Owner

Facebook AdsDigital MarketingAnalyticsConsulting
  • Analyzed campaign performance metrics (CTR, CPC, conversion rate) across 20+ client accounts, building Excel dashboards that increased reporting efficiency by ~40% and improved client decision-making speed.
  • Applied data-driven optimization to Facebook Ads campaigns, identifying underperforming ad sets and reallocating budgets to consistently improve ROI across client portfolios.
  • Leveraged AI tools and automation to streamline campaign reporting workflows, reducing manual analysis time while improving insight accuracy.
Dec 2008 – Mar 2017
Evolucion BMP · Santo Domingo

💼 Sales Manager

Sales StrategySEOEmail MarketingTeam Leadership
  • Designed and executed the company's full online marketing strategy including website maintenance, SEO, social media, and email marketing.
  • Planned and directed the sales and marketing department, managing key accounts and driving engagement with customers.
  • Led recruitment and selection of sales staff, developed sales strategy combining online and offline marketing initiatives.
  • Promoted consistent achievement of sales quotas while supervising a team of key account managers.
2026
IBM / Coursera

🏅 IBM Data Science Professional Certificate

PythonSQLMachine LearningData VisualizationModel 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.