gil lu

resume

Brooklyn, NY · gillu1212@gmail.com

Download PDF

Education

CUNY Baruch College

Aug 2026

M.S. Information Systems, Data Analytics · 3.80/4.0

CUNY Brooklyn College

May 2025

B.S. Computer Science, Data Science Minor · 3.55/4.0

Experience

Data Analytics Intern

Feb 2026 – May 2026

NYC Aging, Social Service Agency · New York, NY

  • Analyzed and validated program datasets across 11 service categories using SQL and Tableau, identifying data quality gaps and ensuring integrity on services reaching over 200,000 older New Yorkers
  • Produced recurring reports and dashboards for program performance evaluation, developing metrics that translated large datasets into concise insights for non-technical stakeholders
  • Designed and maintained a centralized data-request tracking system, streamlining reporting workflows and improving accessibility and operational efficiency across the data management pipeline

Software Engineer Intern

Jul 2021 – Aug 2021

MetaBronx, Startup Accelerator · Brooklyn, NY (Remote)

  • Collaborated with a multidisciplinary team on Python-based workflows and backend process improvements, and contributed to front-end updates and organizational program support

Projects

SkyNYC

2026

NYC Airport Operations Data Platform

Orchid

2026

Collaborative Data Notebook IDE

Bertram

2025

AI Email/Inbox Management Platform

ohmo

2026

Local-first AI Job-Search Desktop App

License Plate Recognition

2024

Computer Vision Platform

Customer Churn Analysis

2025

Telecommunications Analytics

Sokin

2025

Personal Finance Platform

Skills & Certifications

Languages
Python (pandas, NumPy), SQL, T-SQL, R, JavaScript, TypeScript, Java
Data Engineering & Cloud
dbt, Dagster, Apache Kafka, Apache Spark (PySpark, Structured Streaming), Databricks (Unity Catalog), Delta Lake, Terraform, AWS (S3, Glue, Athena, Lambda, EC2, EMR, Aurora), Azure (Data Lake Storage, Data Factory)
Databases
PostgreSQL, MySQL, SQL Server (SSMS), SQLite, MongoDB, Firebase (Firestore), Redis (Upstash), Neo4j, Supabase, Snowflake, BigQuery, Redshift
Analytics & Visualization
Tableau, Tableau Prep, Power BI, Grafana, Excel, Alteryx, Matplotlib, Seaborn, Plotly, scikit-learn, statsmodels, SciPy, XGBoost, LightGBM, Optuna, PyTorch, TensorFlow, YOLOv5, Tesseract OCR, Google Cloud Vision, CUDA
Developer Tools & Frameworks
Git, GitHub Actions (CI/CD), Docker, Docker Compose, Flask, FastAPI, Node.js, Express.js, React, Next.js, Tailwind CSS, Electron, Vercel, OAuth 2.0
Certifications
IBM Data Analyst Professional Certificate