Learn Data Skills
Andrew Ferguson

Andrew Ferguson

Industry Risk Analyst

Zions Bancorporation | Utah

Technologies

My Portfolio Highlights

My New Course

Introduction to R

Innovative thinker, shaping the future through data intelligence.

My Work

Take a look at my latest work.

course

Introduction to R

course

Intermediate R

course

Data Visualization with ggplot2 (Part 1)

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Merrick Bank | Jan 2020 - Present

Senior Risk Analyst - Loss Forecasting

N/A

Zions Bancorporation | May 2018 - Jan 2020

Financial Analyst - Portfolio Risk Analyst

• Produced 8 actionable annual reports, researching the impact of industry and macroeconomic conditions on loan portfolio performance, which were used to inform our team’s senior vice president of business insights. • Eliminated 3 days of work every month, by automating the extraction and transformation of data from the enterprise data warehouse and by loading the results into more than 5 summary tables for the concentration risk team (SQL in SAS). • Served as liaison between the concentration risk team and the reporting analytics group, by defining data analytic dashboard requirements and by replicating analytic dashboards using data warehouse tables. • Reduced our senior vice president's required presence by coordinating with the senior management of Credit Reporting Analytics and Quantitative Analytics Modeling teams to implement the senior executive’s decisions.
Show More

Zions Bancorporation | Oct 2014 - May 2018

Quantitative Modeling Analyst

• Produced 10 production statistical models to forecast financial line items for the bank’s biannual stress test (SAS and R). • Ensured models were fit-for-purpose by conducting advanced time series statistical tests, out-of-sample tests, variance analysis, model sensitivity, and forecasts analysis (SAS and Excel). • Engaged the internal risk and corporate finance (FP&A) teams biannually, to ensure stress test regression-based models were fit-for-purpose, properly implemented and produced expected forecast results. • Created 4+ main datasets through the extraction, transformation, and loading of data (ETL) from the enterprise data warehouse (SQL) and Oracle Hyperion Essbase databases (Excel). • Developed 9+ program scripts used for data management (2; SQL in SAS), variable selection and model fit (1; SAS), reporting (3; R, RMarkdown, and LaTeX), and visualization (3; R, SAS, and Excel).

My Education

Take a look at my formal education

Masters of Science (MS),Ā Financial EconomicsUtah State University | 2015
Bachelor of Science (BS),Ā EconomicsUtah Valley University | 2012

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free