Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Lorenzo Vaccaro

Hudson County,NJ

Summary

Accomplished Senior Data Analyst with a proven track record at Blackstone, enhancing data-driven decision-making by migrating SQL to Snowflake, achieving a 70% improvement in data processing. Expert in SQL, Python, and Tableau. Excelled in cross-functional collaboration and mentorship, significantly boosting project efficiency and stakeholder satisfaction.

Overview

6
6
years of professional experience

Work History

Senior Data Analyst

Blackstone
New York, NY
01.2023 - Current
  • Led a work stream and facilitated weekly meetings to track project progress and ensure deadlines were consistently met.
  • Collaborated cross-functionally and with stakeholders to discuss solutions and define KPIs, ensuring alignment and successful project execution.
  • Migrated SQL stored procedures to Snowflake views, resulting in a 70% improvement in Tableau data extract runtimes.
  • Assisted with employee onboarding and ongoing mentorship.
  • Developed the first external self-service portal for limited partners in Tableau, enabling access to track real-time market updates and portfolio company financials.

Data Analyst

Blackstone
New York, NY
03.2019 - 12.2022
  • Automated reporting using SQL and optimized stored procedures, views, and functions for seamless integration with BI tools such as Tableau and SSRS.
  • Reduced code redundancy and technical debt while enhancing extendibility by centralizing SQL scripts, resulting in a 30% decrease in development time.
  • Achieved an 80% reduction in report generation time by implementing a Python program in Jupyter Notebook.
  • Created and maintained 30+ Tableau dashboards for various business units, visualizing over $200B in AUM.

Education

Bachelor of Science - Computer Science

HOFSTRA UNIVERSITY
Hempstead, NY

Skills

  • SQL
  • Python
  • Tableau
  • Snowflake
  • Data integration
  • Business intelligence
  • Sigma
  • SQL Server Management Studio
  • SQL Server Reporting Services
  • GitLab
  • Visual Studio
  • Jupyter Notebook
  • PyCharm

Affiliations

  • Pianist with a social media presence, with over 450K followers combined across TikTok, Instagram, and YouTube!

Timeline

Senior Data Analyst

Blackstone
01.2023 - Current

Data Analyst

Blackstone
03.2019 - 12.2022

Bachelor of Science - Computer Science

HOFSTRA UNIVERSITY

Similar Profiles

CREATE PROFILE
Lorenzo Vaccaro