zwl216@stern.nyu.edu  •  LinkedIn  •  GitHub  •  Long Island, New York

Experience

Technical Business Analyst
January 2024 - Present
  • Design, build, and maintain institutional research dashboards in Power BI (enrollment, retention, major migration, faculty teaching history) using data from Ellucian Banner (Oracle/PL-SQL).
  • Partner with senior leaders (Provost, Deans, Chairs) to translate strategic questions into data-informed analyses.
  • Lead the transition from Tableau to Power BI, reducing ad hoc data requests by 50% and improving timeliness of executive decision making.
  • Develop automated reporting pipelines with Power BI and Power Automate, improving data integrity and reproducibility.
  • Presenter for the SUNY Power BI User Group on best practices.
M.S. in Business Analytics Candidate
May 2023 - May 2024
  • Class Representative for 2024 MSBAi cohort.
  • Capstone: Digital Marketing Analytics using Marketing Mix Modeling (MMM) & Multi-Touch Attribution (MTA) for path to purchase.
  • Coursework: Machine Learning, Generative AI, Data-Driven Decision Making, Big Data (GCP, AWS), Network Analytics, Statistics, Data Mining.
Human Resources Program Manager
July 2022 - June 2023
  • Designed and launched a national Employee Resource Group (ERG) framework for 14,000+ US associates.
  • Planned and executed virtual, hybrid, and in-person programs across the US and India.
  • Developed DEI communications and reports, aligning messaging with organizational strategy and metrics.
Project Manager
January 2022 - July 2022
  • Led a team to develop and deliver a Power BI Finance dashboard for client VP.
  • Developed a client Innovation Program, generating 20+ upsell opportunities.
  • Created employer branding content through podcast-style video interviews.
National Lead - CREATE Employee Resource Group
December 2021 - July 2022
  • Winner: ERG of the Year.
  • Plan and execute events for 800+ member CREATE Employee Resource Group.
  • Increased engagement through quarterly newsletter and internal channels.
Business Analyst
September 2021 - January 2022
  • Led strategic workshops for cloud readiness, collaborating with client stakeholders.
  • Coordinated with India-based team to analyze application data for high-stakes presentations.
Software Developer
February 2021 - January 2022
  • Developed and deployed database migration tool in C# for Sitefinity to Azure SQL.
  • Gathered requirements from 10+ client stakeholders for 3 high-value IT projects, achieving 95% client satisfaction.
Professional Photographer & Founder
September 2009 - July 2022
  • Full-time boutique wedding photography & videography company for 12+ years.
  • Increased operating revenue 250% year over year through SEO and social media campaigns.
  • 3x Fearless Photographers winner for excellence and creativity in wedding photography.
Head of Operations
Camera Concierge, LLC
September 2009 - May 2014
  • Launched & operated startup camera equipment rental website servicing local photographers & filmmakers.
  • Grew through Google Ads, Facebook Ads, social media, and local partnerships.
Front Office Manager
Marriott International
June 2003 - February 2011
  • Atlanta Marriott Airport Gateway, Orlando World Center Marriott, Orlando Airport Marriott.
  • 24/7 front-of-house management: staffing, scheduling, service recovery, and daily performance.

Education

M.S. in Business Analytics and AI
New York University, Stern School of Business
2024

Class Representative. Capstone: Digital Marketing Analytics using MMM & MTA for path to purchase. Coursework: Machine Learning, Generative AI, Data-Driven Decision Making, Big Data (GCP, AWS), Network Analytics, Statistics, Data Mining, Modern Artificial Intelligence.

B.S. in Computer Science
Auburn University
2020

Algorithms, Data Structures, Databases, Web Development, Mobile Development, Cloud Computing (AWS/Docker), Parallel Programming.

B.S. in Hospitality Management
University of Central Florida
2005

Skills

Analytics & BI

Power BIDAXStar SchemasTableauPower Automate

Programming

PythonSQLRC#.NETJavaJavaScript

Data & Cloud

Oracle/PL-SQLGCP BigQueryAWSAzure SQLPySpark

AI & ML

Machine LearningGenerative AIPredictive AnalyticsNLP

Business

Project ManagementStakeholder CommunicationData-Driven Decision MakingDEI Strategy

Fun Facts