John Kim

Experience

• 

  C2 Education

  Sept 2012 - Aug 2013

  Director Assistant

  -Utilized Excel spreadsheets to handle 100+ transactions of tuition and workbook/material fees on a quarterly basis and clients’ information to maximize the efficiency in the database by operating pivot tables function via Excel. -Computed Director’s expenses by recording the financial transactions and transferring daily receipts and financial summary to the headquarters. -Scheduled clients’ appointment and students’ class schedules while reporting the updates with their monthly test results and improvements in the scores within the programs. Show less

• 

  Wang Cho BBQ

  Apr 2016 - Jun 2018

  Head Server

  -Calculated and distributed approximately $1,000-$1,500 in daily tips by ensuring the accurate cash records.-Curated the optimal customer experience according to their experience and tastes, leaving them consistently fulfilled.-Developed meaningful relationships with customers, making them regulars through above and beyond service.-Demonstrated excellent communication skills with customers, which led to a large customer base of regulars.-Consulted customers with questions, such as suggesting a new cuisine that could match their appetite. Show less

• 

  Kim & Co.

  Jun 2016 - Aug 2016

  Accounting Intern

  -Assisted in the preparation and execution of 6 annual financial reports and bookkeeping of 120 client accounts by ensuring the data accuracy and identifying major discrepancies between budget and actuals. -Created client tracking system in a spreadsheet that allowed to enter the client database while minimizing errors and reducing entry input time from average 3.5 hours to 1 hour. -Reviewed all tax returns prepared by individuals and clothing marketing companies before approval.

• 

  Deloitte

  Jul 2017 - Aug 2017

  Financial Advisory Services Intern, Merger&Acquisition

  Intern for the Deloitte financial advisory department. -Developed comprehensive timelines for Merger and Acquisitions (M&A) projects to provide the company history and the annual revenue of the acquiring company to compensate the merge between the national transportation service company and the railroad transportation company. -Illustrated the potential profit from the acquisition of the midsized company by using the exponential growth financial formula and the quarterly annual income based on the journal entries. -Collected and analyzed client insights, competitive analysis, and in-depth market research to develop an account plan for two companies to merge to ultimately provide the major up-sell opportunities. -Significantly reduced the time spent on tracking M&A project deliverables from average 3.5 hours to 1 hour via robust project tracking spreadsheet which includes the budget, expense management, and deadline.-Managed a variety of projects within the client M&A portfolio for US and international to support revenue growth in priority channels and regions. Show less

• 

  Robert Half

  Oct 2018 - Jan 2019

  Salaried Professional Service Consultant

  Hispanic Scholarship Fundhttps://www.hsf.net/-Daily approved and voided 20 to 30 fraudulent online donations and recorded the approved transactions accurately in the Salesforce software.-Processed the bank reconciliations every month by pulling out the data from the operating bank activity for the month and cancelling out 1,000+ bank activities by organizing the data in Excel to adjust the balance to 0 for the end of the month.-Executed the reimbursements for the scholars by filing and recording 120 receipts in the Excel and calculating $24,000 worth of the reimbursements to accurately report it to the accounts payable manager. Show less

• 

  EY

  Jan 2019 - Jun 2019

  Associate, Sales & Use Tax

  -Took in charge of filing taxes for the numerous big clients in different industries, such as Coca Cola, Ford Motor, BMW, Rolls Royce, and Hubbell by communicating with the clients to report the taxes in a timely manner. -Accurately prepared and filed approximately 630 sales and use tax returns with various entities every month to the different jurisdictions, including the home rule states. -Utilized tax service software to report and display the appropriate tax data in the filing returns and the monthly reports. -Handled 25 different letters and notices to resolve the issues with the jurisdictions by actively calling and researching about the notice logs. -Fully completed the compliance cycles of monthly, quarterly, annual, and semi-annual tax returns without creating any significant error. Show less

• 

  Robert Half

  Sept 2019 - Jul 2021

  Pixelogic Mediahttps://pixelogicmedia.com/-Took a full initiative of the UK AP department to take care of the daily payments and invoices, along with the side audit projects for the account.-Daily communicated with the vendors and the clients regarding the cash and payments to the companies like Disney, Warner Bros, Netflix, Amazon, Fox, NBC Universal, etc.-Operated capable foreign transactions going through 4 different currencies with the FX write-offs and VAT regulations.-Supported US department’s AR side as well with their remittance collections and bank statements.-Executed End of month tasks and duties to close the books for payroll, depreciation, prepays, and COGS. Show less IQ Air https://www.iqair.com/us/-Reconciled the 4 months’ worth of the credit card transactions with the various accounts in the span of the week to meet the due date. -Prepared and scanned credit card receipts and bills in the PDF and spreadsheet to attach with the appropriate Net Suite credit card entries. -Completed 3 thousand sales reconciliation with Amazon and QuickBooks data to report the discrepancies of the two data. -Entered the freight bills to Net Suite from the various delivery services. Show less Retail Food Group USAhttps://www.rfg.com.au/-Fully initiated a chart of accounts project by effectively condensing the 500 accounts into 200 accounts within the time span of 3 days and successfully incorporated the chart of accounts into the new accounting software. -Utilized both QuickBooks and Dynamics NAV to record invoices and cash receipts, make journal entries, and produce AP/AR aging summaries for the end of month tasks for two different companies in a timely manner. -Handled cash tab and non-cash tab reconciliations for 8 different entities every month by utilizing spreadsheets and checking the correct figures on the accounting software to send over the accurate data to the Australia corporate. -Supported the marketing department by extracting the franchises' sales data and recorded the data into the created spreadsheets to make the marketing analysis for the marketing director and the other executives. Show less

  • Salaried Professional Service Consultant

    Aug 2020 - Jul 2021

  • Salaried Professional Service Consultant

    Jun 2020 - Aug 2020

  • Salaried Professional Service Consultant

    Apr 2020 - May 2020

  • Salaried Professional Service Consultant

    Sept 2019 - Mar 2020
• 

  Atlas Copco

  Jul 2021 - now

  Assistant Business Controller/Office Manager

  Edmac Compressor Parts, Atlas Copco OriginAir