JK

Joshua Kong

Data Science Immersive Student · General Assembly

Los Angeles, CA

In My Own Words

I'm a Data Scientist with a background in accounting within the insurance and construction industries. Through my work, I regularly had to explain technical accounting concepts to non-accounting personnel in an effective way they would understand. This prior experience combined with my skills in data science, will allow me to successfully communicate data-driven recommendations to both technical and non-technical audiences.

Work Experience

Data Science Immersive Student

General Assembly

2019 – 2020

? Developed SQL queries with varying syntax to create reports answering questions posed from a business setting ? Created Tableau dashboards, which tackle subjects such as sales, human resources, accounts receivable, shipping, sales agent, and stock price analytics

Accounting Supervisor

Bernards

2018 – 2019

? Had leadership role by supervising accounts payable (AP) department by holding weekly meetings to ensure timely completion of projects and assignments, helping troubleshoot problems related to software and accounting, and reviewing their accounting schedules ? Made minimal and effective custom reports to identify misclassified job costs with SQL Server Reporting Services and SAP Crystal ? Created two Excel macros utilizing Vlookups and nested if statements to automate repetitive, manual processes AP was working on to code employee credit card charges ? Audited employee credit card transactions for legitimacy and unusual transactions weekly ? Wrote new procedures and updated antiquated documentation on wide-ranging topics across the department ? Interacted frequently with project team by answering questions, making requests, setting deadlines, and sending assignment reminders, while developing rapport and providing customer service ? Compiled monthly budget information submitted by all department heads, performed analysis on it as it pertains to KPIs and OKRs, and wrote explanations on significant fluctuations. This report was sent to president, CEO, CFO, and other main stakeholders in company

PROFESSIONAL EXPERIENCE (CONTINUED)

Senior Audit Associate

JLK Rosenberger, LLP

2016 – 2018

Audit Associate

California State University, Northridge (CSUN) and Woodbury University

2014 – 2016

? Trained 10 California State University, Northridge (CSUN) and Woodbury University students on fundamentals of cash and cash equivalents (CE) and how to audit cash and CE during Audit 500 ? Juggled 2-3 audit engagements at times, and was tasked with prioritizing, delegating, and coordinating with clients

Education

Bachelor of Science

University of Southern California

2014

Bachelor of Science