Looking for a job

Tae Min Kim

@taeminkim

Message

I automate mortgage and reporting workflows with SQL, Access, VBA, and SSIS.

United States

Message

What I'm looking for

I'm seeking a position where I can maximize my SQL, Access, VBA, reporting, analytical thinking, and data-process automation experience.

I've automated ETL processes, loan-tracking workflows, and monthly reporting at Oak Hill Advisors, using Microsoft Access, VBA, SQL, and SQL Server to improve data collection and delivery.

Across Bank of America, Corelogic, GameStop, and First American Real Estate Tax Service, I've built reporting databases, vendor scorecards, dashboards, and automated processes—including work that saved 125 manual hours per week and a $2.5 million early-servicing project.

Experience

Work history, roles, and key accomplishments

Current

Mortgage Data Analyst

Current

Oak Hill Advisors

Jan 2016 - Present (10 years 8 months)

Automated several ETL processes using Access database, VBA, SQL, and Task Scheduler to house vendor data. Created a Microsoft Access GUI to monitor interim collection of new loans purchased, and enhanced monthly procedures for robust data loading and report distribution.

VBA SQL MS Access Microsoft SQL Server ETL Windows Task Scheduler

Data Reporting Analyst

GameStop, Inc.

Jan 2014 - Jan 2016 (2 years)

Implemented automated reports using Access database and VBA to extract, export, format, and email Excel reports on a daily and weekly basis. Created Excel macros, updated weekly dashboards, and analyzed sales data to support business decisions.

VBA SQL MS Access Excel Hyperion Data Analysis Reporting

Cons Prod Strategic Analyst II / Senior Reporting Analyst

Bank of America / Corelogic

Jan 2011 - Jan 2014 (3 years)

Developed SSIS processes to extract loan search requests and facilitated migration of Non-Impound loans from Bank of America to Corelogic. Developed 12 key scorecard metrics, maintained vendor-tracking database, and created processes that saved 125 hours per week.

SSIS SQL MS Access Data Migration Vendor Management Reporting

Senior Operations Analyst / Mortgage Servicing Specialist III

Countrywide / Bank of America

Jan 2005 - Jan 2011 (6 years)

Developed and maintained Microsoft Access databases, automated recurring reports using Pervasive and Access, and manipulated tax collector data. Created a database that saved Bank of America $2.5 million and received a Faster Gold Award.

MS Access Pervasive Software VBA SQL Data Analysis Reporting

Data Analyst

First American Real Estate Tax Service

Jan 2005 - Dec 2005 (11 months)

Developed daily, weekly, and monthly reports for SVPs using Microsoft Access and Excel. Improved operations by creating a database to track workflow and solved operational issues with Microsoft Access.

MS Access Excel Reporting Data Analysis

Business Analyst

First American Real Estate Tax Service

Jan 2002 - Jan 2005 (3 years)

Developed reports with Microsoft Access to balance daily checks written and refunded. Prepared user documentation for customer billing system with Microsoft Excel and solved operational issues with Microsoft Access.

MS Access Excel Documentation Reporting