John Jeong - FOX BBA in MIS Student

EDUCATION:

TEMPLE UNIVERSITY, Fox School of Business, Philadelphia, PA

Bachelor of Business Administration, Graduation: December 2020

Major: Management Information Systems

DELAWARE COUNTY COMMUNITY COLLEGE, Media, PA

Associate of Business Administration, Graduation: August 2018

Major: Business Administration, Dean’s List: Fall 2017

Member of honor society, Phi Theta Kappa, Spring 2018
Member of Association for Information Systems (AIS)
Conducted direct marketing strategy as a team to a client (The Cow and The Curd) from direct marketing class. The lead role of collecting data and visual interpretation.

Chubb Insured, Inc. • business intelligence Analyst intern • 06/2019 – 12/2019

Initiated/contributed to advance projects as part of Collection Shared Service Center. Extended from 3 month to 7 months.
Presented ideas and discussed best approaches with supervisor before independently implementing.
Responsible for extraction, data cleansing, aggregations, data load, validation, and visualization using BI tools, with a focus on most effective methods of transforming data into useable presentations.
Partnered with MIS to query internal software and extract data for specific reports, including observing fields.
Enhanced business unit-specific reports to provide clear insights for management, including AVPs, VPs, and SVPs.

Projects:

Automating Manually Generated Reports: Migrated existing reporting modules from Excel to Power BI or Qlik Sense, saving 7 hours monthly that was redirected for workflow efficiency.
Call Center Service Performance Quality Analysis Reporting: Measured criteria such as call duration, hold duration, roll-over to next agent, and call pick-up time and implemented acceptable standard rate for senior management, using Qlik Sense to visualize and highlight agent underperformance by criteria.
In-Force Count Report: During reporting migration, identified flaw in calculation and flaws in calculation logic for one of the reports. Proposed new method of calculation that highlighted thousands of missing policies and millions of dollars. Correction was acknowledged by AVP and put in the pipeline.
System Performance Analysis Reporting: Used system requirements to evaluate its performance and created flag variable within SQL query to identify number of failure system encountered or if system itself failed. Developed dashboard with Power BI to visualize findings.

Fast Signs, Inc. • assistant manager • 01/2019 – 06/2019

Quickly assumed management responsibilities not entrusted to most college students, with authority for overseeing time-complex projects to ensure all deadlines were met.
Assisted with financial functions such as invoicing, collecting payments, and managing accounts receivable.
Trained new hires on company’s policies, procedures, and business ethics codes.