Summary
Overview
Work History
Education
Skills
Projects
Certification
Sql Portfolio
Tableau Portfolio
Timeline
Generic

Gary Zhang

Philadelphia,PA

Summary

I’m an analyst with a strong background in capital planning and data analysis, where I’ve supported over $1.2 billion in projects for clients including TD Bank and Amazon. Excel is my go-to tool for cleaning, transforming, and analyzing data, and I’ve also built dashboards and visualizations through SQL and Tableau projects. I enjoy turning numbers into stories that help teams make smarter decisions. Colleagues know me as someone who works well across finance, engineering, and operations to deliver results.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Capital Planning Analyst II

BGIS
11.2023 - Current
  • Planned and managed over $130 million in capital projects for TD Bank, including asset lifecycle renewals and infrastructure improvements.
  • Developed capital plans totaling $679 million for Canadian Tire, ensuring alignment with financial objectives and risk prioritization.
  • Created dynamic dashboards and visualizations using Tableau to present key capital allocation strategies and spending forecasts.
  • Conducted advanced data cleaning and transformation across large project datasets to ensure integrity, consistency, and reporting accuracy.
  • Supported cross-functional collaboration between finance, engineering, and operations teams to drive strategic capital planning decisions.

Data Analyst

BGIS
06.2022 - 11.2023
  • Analyzed and managed a capital plan encompassing over 15,000 assets, ensuring accurate tracking and reporting of asset conditions and maintenance needs.
  • Utilized advanced Excel functions and pivot tables to perform in-depth data analysis, enhancing decision-making processes and operational efficiency.
  • Conducted data cleaning and transformation to maintain data integrity and accuracy across various databases.
  • Collaborated with cross-functional teams to leverage data insights for strategic planning and resource allocation.
  • Familiar with LIDAR technology for asset mapping and condition assessment, contributing to data-driven project planning and execution.
  • Developed and maintained dashboards and reports to visualize key metrics and trends, improving stakeholder understanding of asset performance.

Real Estate Broker Associate

eXp Realty
02.2021 - 12.2021
  • Performed analytics within multiple portals/apps to create data reports on properties/land/rental rates.
  • Experienced with eXp Realty’s cloud-based web for marketing, client engagement, and virtual learning campus.
  • Promoted sale of properties through open houses, engagement in multiple listing services, and social media marketing.
  • Communicated with buyers, sellers, and renters to understand property needs, timelines, and budgets.
  • Collaborated positively with peers and other staff to maintain a friendly, supportive, and cooperative work atmosphere.

Education

Some College (No Degree) - Data Analytics

Western Governors University
Salt Lake City, UT

Skills

  • SQL and PostgreSQL
  • Capital planning
  • Data analysis
  • Project management
  • Dashboard visualization
  • Data cleaning
  • Cross-functional collaboration
  • Financial forecasting
  • Effective communication
  • Problem solving
  • Client engagement
  • Strategic thinking
  • Data analysis and visualization
  • Excel pivot tables
  • Tableau expertise
  • Attention to detail

Projects

Product Revenue Dashboard, Identified stores with the lowest and highest sales rates, quantified revenue by product, and identified average revenue by account; published a Tableau dashboard to track KPIs. COVID-19 Rates Dashboard, Quantified COVID-19 vaccination rates over time, by country, and by total deaths per continent; published a Tableau dashboard to visualize results. Superstore Sales and Profitability Executive Dashboard, Quantified sales, profitability, profit ratio, and sales per customer. Visualized profit ratio by city on US map. Quantified monthly sales by segment and category over time by profitable vs. unprofitable orders. Electronics Store Database Design, Designed an electronics store database using SQL and analyzed statistics by product. Furniture Store Sales Analysis, Quantified sales rates per category, group, date, and purchase location, and determined most and least profitable store locations.

Certification

  • Google Data Analytics Certificate Course, Coursera
  • SQL: The Complete SQL Bootcamp 2022: Go from Zero to Hero, Udemy
  • Google Cybersecurity Professional Certificate, Coursera

Sql Portfolio

https://github.com/EatSleepSQL/PortfolioProjects

Tableau Portfolio

https://public.tableau.com/app/profile/gary.zhang4062#!/

Timeline

Capital Planning Analyst II

BGIS
11.2023 - Current

Data Analyst

BGIS
06.2022 - 11.2023

Real Estate Broker Associate

eXp Realty
02.2021 - 12.2021

Some College (No Degree) - Data Analytics

Western Governors University

Similar Profiles

CREATE PROFILE