Headshot Jason Luu
Contact Me
Summer 2025 | Arvest Bank

Banking and Financial Services Internship Experience

10 Weeks
4 Major Projects
3 Development Areas
Internship Experience

Default Account Servicing Department

A comprehensive 10-week internship program focused on supporting loan servicing systems, optimizing account management workflows, and ensuring data integrity. Gained hands-on experience in IT operations, automation, process improvement, and data visualization, while while learning multiple banking systems and developing skills in Power BI and SQL.

📈

Process Improvement

Identified inefficiencies in current processes and developed recommendations to streamline operations and enhance customer experience.

📊

Data Visualization

Built interactive Power BI dashboards on HR key metrics and conducted data analysis to support decision-making.

🎯

Professional Development

Participated in training sessions on banking regulations, financial products, and professional skills development workshops.

💻

IT Operations & Automation

Managed IT operations, created automation solutions, and optimized workflows to improve efficiency and reduce manual work.

🗄️

Database Management & SQL

Learned foundational SQL while working with company database systems, performing account analysis and data extraction to support operations.

🏦

Loan Servicing Systems

Supported daily loan servicing operations, account management workflows, and system maintenance while ensuring data accuracy and integrity.

Key Projects

Projects & Achievements

Major projects completed during the internship that contributed to business operations and process improvements.

Matured Line of Credit Report

3 weeks

Automated the report process using Excel Macros, cutting it from 53 steps to 3 (94% reduction) and reducing processing time from 15 minutes to 5 seconds (99% faster). Integrated loan officer lookups and ShowCase Query joins to eliminate additional manual steps, improving accuracy and associate productivity.

Excel VBA / Macros Data Cleaning Process Automation

Loan Extension Report

1 weeks

Automated the BOT Loan ExtensionDDC Report using Excel Macros, cutting processing time from 5 minutes to 5 seconds (99% faster). Generated Loss Mitigation, Denied, and Approved reports with automated formatting, file saving, and version control, eliminating repetitive manual work.

Excel VBA / Macros Data Cleaning Process Automation

Liquid Payments Report

1 weeks

Automated the Liquid Payments Report using Excel Macros, reducing processing time from 8–10 minutes to 5 seconds (99% faster). The solution automated row extraction, formatting, and report generation into Charge Off Credits and Charge Off Payments, improving accuracy and significantly increasing associate efficiency.

Excel VBA / Macros Data Cleaning Process Automation

Redesign Onboarding Process

5 weeks

Analyzed Arvest Bank’s onboarding process to identify opportunities to reduce early attrition and improve time-to-productivity. Conducted HR KPI analysis, created data-driven recommendations, and collaborated with HR and IT teams to highlight efficiency gains and cost-saving opportunities.

Power BI Data Visualization Data Analysis Power Point
Professional Growth

Skills & Development

Technical and professional skills developed during the internship experience.

Technical Skills Gained

  • Excel Automation & VBA
    Developed advanced Excel Macros to automate reporting processes, reduce manual steps, and improve accuracy.
  • Data Analysis & Visualization
    Performed HR and operational data analysis, creating interactive dashboards and reports using Power BI and Excel.
  • SQL & Database Management
    Gained foundational SQL skills and hands-on experience querying and analyzing banking data across multiple internal systems.
  • Banking Systems & Reporting Tools
    Worked with Default Account Servicing (DAS) systems, ShowCase Query, and internal banking platforms to support loan servicing and reporting.

Professional Accomplishments

  • Attended public speaking and interview preparation workshops, improving communication and presentation skills.
  • Participated in inclusion and diversity seminars to gain awareness of workplace culture and DEI initiatives.
  • Engaged in executive speaker sessions on topics including Wealth Management and Information Technology to broaden understanding of banking operations.
  • Gained exposure to career development and professional growth strategies through Arvest Bank’s internship programs.
  • Developed automation skills through VBA Macros, streamlining reporting processes and reducing manual work across multiple projects.
Documentation

Internship Documents

Important documents, reports, and deliverables from the internship experience.

📄

Matured Line of Credit VBA

This VBA macro filters and organizes the Matured Line of Credit report, creates segmented sheets by loan maturity, and outputs the report automatically.

View Code
📄

Loan Extension VBA

This VBA macro formats the BOT Loan ExtensionDDC Report, creates Loss Mitigation, Denied, and Approved sheets, and saves the file automatically.

View Code
📄

Liquid Payments VBA

This VBA macro automates the Liquid Payments report by extracting error rows, creating Charged Off Credits and Payments sheets, and formatting the output.

View Code