peter sidi

PROFESSIONAL SUMMARY

Results-driven Analytics Lead Developer with extensive experience in data visualization, database modeling, ETL development, and business analytics. Expertise in Tableau, SQL, Python, and data warehousing with a strong background in financial, academic, healthcare, and environmental analytics. Adept at transforming business requirements into actionable insights through advanced data solutions.

PROFESSIONAL EXPERIENCE

Citibank – Senior Manager, Visualization Data Engineer/Business Intelligence Analyst

Community Reinvestment Act Group
July 2022 – Present

• Designed and developed Tableau dashboards to track Citi Bank’s compliance with the Community Reinvestment Act (CRA) across Metropolitan Statistical Areas (MSA), ensuring adherence to financial regulations.
• Collaborated with CRA Analysts to build interactive Tableau dashboards (Tableau Desktop 2023.1) based on Excel and PDF reports.
• Engineered Kimball dimensional models, implementing star schema designs with fact and dimension tables to enhance data accessibility and performance.
• Developed ETL processes to refresh the data warehouse daily, leveraging MS SQL Server 2016 stored procedures and scripts.
• Established and managed the CRA Tableau SharePoint site, consolidating best practices, templates, and procedural documentation.

New York University – Tableau Lead Support

May 2018 – July 2022

• Partnered with NYU schools and departments to create Tableau dashboards measuring key performance indicators, including student success, graduation rates, and retention.
• Automated ETL processes using Python REST API scripts to import data from survey tools like Qualtrics (Python 3.9, Pandas).
• Taught Tableau Desktop classes to NYU staff, introducing best practices and data visualization principles.
• Developed a web portal integrating Tableau dashboards with HTML, CSS, JavaScript, and the Tableau JavaScript API for enhanced user navigation.
• Monitored and maintained Tableau Server (2021.4), optimizing performance and managing Active Directory groups.
• Implemented sentiment analysis of student class evaluations using Python (Pandas, TextBlob, NumPy).

Scholastic Inc. – Senior Tableau Analyst

Sept 2016 – Apr 2018

• Developed and maintained Tableau dashboards for tracking revenue, customer counts, and other KPIs.
• Embedded Tableau dashboards into web pages for improved content navigation.
• Managed Tableau Server (10.5), enhancing performance monitoring and user management.
• Created Redshift SQL scripts embedded in Tableau workbooks using CTEs and window functions.

Memorial Sloan Kettering Cancer Center – Business Intelligence Analyst/Developer

Aug 2011 – Sept 2016

• Designed hospital web portals integrating Tableau dashboards for performance tracking.
• Built OLAP cubes measuring key hospital metrics, including surgery costs and operating room efficiency.
• Developed Tableau dashboards for urgent care center analysis, tracking patient triage efficiency.
• Managed Tableau Server operations and optimized performance.
• Developed ETL packages (MS SSIS - VB.NET) for updating snowflake schema databases.

New York-Presbyterian Hospital – Senior Business Intelligence Analyst / QARR Data Manager

May 2003 – Aug 2011

• Developed OLAP cubes and views to track key healthcare finance and operations performance indicators.
• Managed ETL processes for Quality Assurance Reporting Requirements (QARR) incentive measures.
• Led the development of a business intelligence data warehouse for clinical and financial integration.
• Created predictive analytics reports and performance dashboards.

Mount Sinai/NYU Health System – Senior System Software Specialist

Jan 1999 – May 2003

• Generated reports for quality assurance committees and financial analysis.
• Designed ad-hoc reports using PL/SQL and SAS to support clinical performance tracking.
• Developed web-based reporting systems to monitor hospital KPIs.

CONSULTING EXPERIENCE

Barry Commoner Center for Health and Environment, Queens College – Business Intelligence Architect/Developer

May 2014 – July 2017

• Designed and implemented a real-time air pollution monitoring database using PostgreSQL and Python ETL scripts.
• Developed Tableau dashboards to visualize air quality metrics in coordination with NYC’s Department of Health.
• Integrated citizen science air quality data using Python APIs and PostgreSQL.

Mount Sinai School of Medicine – Consultant, Dept. of Medicine/Clinical Immunology

Sept 2000 – June 2015

• Conducted data analysis for NIH-funded research on primary immunodeficiency diseases in minority populations.
• Extracted and analyzed patient diagnosis codes using SAS and Oracle.

B.A. in Psychology, Minor in Cultural Anthropology – Beloit College, Beloit, WI

NYU School of Professional Studies: Data Mining, Predictive Analytics & Big Data

General Assembly Certificates: Data Science, Front-End Web Development