Brian J Zhang

Analyst @FI Consulting

Arlington, VA, US

At FI Consulting, I supported critical financial analytics projects for Fannie Mae, leveraging advanced statistical modeling and data manipulation techniques in R and SQL. My role involved developing, debugging, and optimizing sophisticated predictive models, including logistic regression and XGBoost to analyze mortgage and loan performance. I frequently managed and aggregated large datasets to track and predict key metrics such as default rates, unpaid principal balances (UPB), and home price indices (HPI).I regularly performed complex data transformations and visualizations using R packages including dplyr, tidyr, ggplot2, plotly, and Shiny. Additionally, I created interactive dashboards and automated reporting tools that significantly improved data-driven decision-making processes. My work required detailed financial modeling, especially with mortgage amortization schedules, impairment forecasts, and structured financial transactions, delivering insightful analytics to stakeholders for strategic planning and risk assessment.I also leveraged Git for version control and collaboration across ETL workflows, ensuring reproducibility, auditability, and efficient team coordination in data engineering and analysis pipelines.Key highlights include: • Extensive use of SQL and R to streamline data extraction, transformation, and loading (ETL) processes.• Implementation of machine learning models, including XGBoost, to improve predictive accuracy for mortgage default and loss forecasting.• Development and enhancement of interactive Shiny dashboards for real-time analytical reporting.•Strategic collaboration with teams to deliver actionable insights, directly supporting Fannie Mae’s business decisions and risk management strategies.

The University of British Columbia

Bachelor's Degree, Marketing and Business Analysis

Georgetown University

Master's degree, Business Analysis

Shanghai American School

High School Diploma