Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

ESAFE VALIKOULA

SLC,Utah

Summary

Detail-oriented Data Analyst with over 5 years of experience turning data into actionable insights in both financial and nonprofit sectors. Skilled in building automated workflows, developing ETL pipelines, and creating executive-level dashboards using Python, SQL, Tableau, and SAS. Strong background in credit loss reporting, data visualization, and performance tracking. Certified in SAS and equipped with an M.S. in Data Analytics.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Sr. Risk Analyst

Merrick Bank
South Jordan, UT
01.2022 - Current
  • Automated 10+ recurring processes, reducing manual effort and improving team efficiency
  • Built Python scripts and API integrations to collect, standardize, and prepare data for analysis
  • Developed SAS and Python workflows to generate monthly portfolio snapshots for CECL modeling
  • Executed and analyzed PD models for Credit Card and Personal Loan portfolios, identifying key risk drivers and performance trends
  • Designed and maintained ETL pipelines for large-scale datasets (millions of records), ensuring data quality for credit risk analysis
  • Produced and enhanced monthly CECL reports across multiple portfolios, improving visibility into credit performance
  • Performed and documented CECL controls to ensure compliance with regulatory and internal governance standards
  • Leveraged Moody’s Impairment Studio to execute CECL models and support accurate expected credit loss calculations
  • Developed model overlays to correct under- and over-prediction in Credit Card portfolios, improving alignment between predicted and actual losses
  • Delivered monthly portfolio insights to senior leadership, highlighting key trends, risks, and actionable recommendations

Data Analyst II

Church of Jesus Christ of Latter-Day Saints
Salt Lake City, UT
01.2021 - 01.2022
  • Designed and maintained 50+ Tableau dashboards to support data-driven decision-making.
  • Conducted 100+ quality reviews and audits on Tableau reports to ensure accuracy and performance.
  • Developed 5 Python scripts to automate reporting and streamline manual processes.
  • Collaborated with cross-functional teams to define data requirements and streamline reporting processes.

Technical Support II

Church of Jesus Christ of Latter-Day Saints
Riverton, UT
01.2019 - 01.2021
  • Built 5 ServiceNow dashboards to monitor team KPIs and service performance.
  • Resolved 25+ technical issues for internal users, improving customer satisfaction.
  • Managed and tracked 300+ IT assets using an internal asset management system.
  • Skilled at working independently and collaboratively in a team environment.

Education

Master of Science - Data Analytics

Western Governors University
Salt Lake City, UT
03-2021

Bachelor of Science - Applied Mathematics

Brigham Young University
La'ie, HI
06-2018

Skills

  • Python
  • Power BI
  • MS Excel
  • Power Automate
  • SAS
  • Data cleaning
  • SQL
  • Tableau
  • Statistical analysis
  • ETL processes
  • Web scraping

Certification

  • SAS Certified Specialist: Base Programming Using SAS 9.4
  • SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling

Timeline

Sr. Risk Analyst

Merrick Bank
01.2022 - Current

Data Analyst II

Church of Jesus Christ of Latter-Day Saints
01.2021 - 01.2022

Technical Support II

Church of Jesus Christ of Latter-Day Saints
01.2019 - 01.2021

Master of Science - Data Analytics

Western Governors University

Bachelor of Science - Applied Mathematics

Brigham Young University
ESAFE VALIKOULA