Leon Zhang

Experience

• 

  Lenox Hill Construction Co.

  Aug 2014 - Sept 2016

  Project Engineer

  • Worked onsite as project engineer, from start to finish, on a $22M skilled nursing home project.• FPDCC Forest Preserve.• Generated takeoffs for bidding new projects and verifying subcontractor invoices.• Processed transmittals, submittals, and RFIs through Timberline and Newforma.• Received, tracked, and coordinated material deliveries• Inspected the quality of installation on daily walkthroughs and assisted the Superintendent to notify subcontractors of work.• Assisted in calling lists of potential bidders leading up to bid deadlines. Show less

• 

  Novak Construction

  Sept 2016 - Jan 2019

  Project Engineer

  • Worked as a project engineer on a $45M 11-story, 200,000 SF multi-function building and worked as LEED AP to achieve LEED silver for this project, use Naviswork to show 3D model for BIM to coordinate MEP subs. • $18M Costco 160,000 SF. $4.6M Senior living. $3M CVS Pharmacy projects. • Other: Aldi, Thornton Gas Station.• Doing paperwork (submittals / RFI) through Bluebeam, Primavera Expedition. Coordinate with the architect, subcontractor, and owner. • Punch list, Estimating, Bidding current or potential projects. Show less

• 

  Leopardo Companies

  Feb 2019 - Apr 2020

  Estimator

  • Estimated at different levels of design (ROM, Conceptual, SD, DD, CD).• Mainly estimated project type: Commercial, Retail, Healthcare, and Governmental. • Mainly worked on following projects: $80M CHA apartment, $70M hotel, and a couple of $3 to $5 million projects.• Preformed quantity takeoff on the interior finishes and scoped out corresponding subs of a new 435,488 SF $130M athletic facility at North of Chicago.

• 

  Pepper Construction Group

  Jun 2021 - Aug 2022

  Software Developer

  • Deployed web-based Microsoft SSRS reports using SQL Server stored procedures, enhancing the visualization of key metrics and improving data retrieval with SQL best practices.• Enhanced web services, integrating technologies like C#, HTML, CSS, and JavaScript, and collaborated with teams to ensure a 30% time-saving through improved usability and aligned functionality with organizational needs.• Crafted a Power BI dashboard, transforming SQL Server data into intuitive visuals, facilitating a 20% improvement in stakeholder decision-making through clear, strategic data representation.• Analyzed 15 years of data using Python (Scikit-learn, Pandas, NumPy) and created predictive models, optimizing resource allocation and implementing real-time visual dashboards with Streamlit and Altair. Show less

• 

  LivCor, a Blackstone Company

  Aug 2022 - Sept 2023

  Software Integration Engineer

  • Coordinated with business engineers to centralize LivCor's property-level data into Dynamics, enabling efficient property and deal creation processes. This was achieved by building out LivCor's Property Lifecycle Integrations, connecting all our Operational systems using a multitude of Azure services and Python. The systems developed were event-driven micro-services for property lifecycle and other software integrations. • Collaborated with cross-functional teams to align departmental OKRs with company objectives, monitored, evaluated, and reported on key results, ensuring 90% of set objectives were achieved or surpassed. • Enhanced the tagging pipeline, implemented an alerting system for error detection and resolution, and improved data quality and reliability from the ROI team. • Centralized property-level data into Dynamics (ERP), enabling efficient property and deal creation processes while setting up seamless data synchronization through webhook triggers.• Successfully migrated Federal Reserve Economic Data to Databricks workspace, ensuring scheduled and automated data digestion into the Snowflake data warehouse at various intervals (daily, weekly, monthly, and quarterly)• Improved logging and trace management (App Insights) in Azure functions, while also leading efforts to refactor and optimize integration pipelines for various systems.• Utilized Azure services, Azure Databricks, and Python innovatively to harvest data from 3rd party vendors using methods like REST APIs, ODBC connections, SFTP Connections, and SAS Tokens. • Improved ESG team Excel sheet from Blackstone to update ESG data by using Python. Save the process from 1 month to 1 day. Show less

• 

  Milliman

  Dec 2023 - Aug 2024

  Data Engineer

  ● Spearheaded the importation and sophisticated data transformation of extensive datasets, leveraging advanced mapping techniques to enhance data accuracy and utility.● Led the seamless migration of legacy SAS code to AWS Databricks, optimizing data processing capabilities and ensuring a modernized, scalable analytics environment.● Devised and implemented strategic approaches for data reconciliation, ensuring data integrity and accuracy across key fields within the dataset. Use Pyspark and Parquet to deal with big data, and save necessary data in Delta Lake.● Developed and shared a comprehensive notebook containing a suite of general-purpose functions, significantly boosting productivity and collaboration among team members by facilitating easy access to common data manipulation tools.● Testing and validation of the data to make sure the datasets are accurate and valuable.● Work in a Jira Agile environment with a strong sense of responsibility and delivery.● Collaborate with the team to resolve issues and use ETL/ELT to achieve the best BI solutions in designing the best enhanceable solutions. Show less