Director of Accounting
Resume:
Joon Lee
La Canada, CA 91011
Cell: 213-***-****
E-mail: ***********@*****.***
EDUCATION
University of California, Riverside - Class of 2006
Bachelor of Arts Degree in Business Economics with an emphasis in Computer Science
Work Experience
Ghost Mountain Books – Director of Accounting (5/20/19-present)
Calculating Quarterly Royalties with Easy Royalty Maker
Maintaining and reconciling Accounts Payables
Overseeing and reconciling Accounts Receivables
Managing Purchase Orders
Preparing and paying vendor invoices and expenses
Reviewing and reconciling the G/L in Quickbooks
Reconciling the company bank accounts
Interacting and maintaining business relations with vendors and other third party companies
Continuously monitoring and improving transactional revenue procedures
Using Excel to forecast and budget projections and analyze financial variances
Disney via Software Resource - Financial Accounting Analyst (5/29/18-7/13/18)
Monitored and posted invoices into SAP
Maintained accurate AP coded and reclassification
Processed invoices into ZPO uploads or Service Entry via SAP
Assisted in preparing reporting packages for management
Updated vendor account logs in Excel
Audited invoices for payment
Asclepes Research Centers - Financial Analyst/Bookkeeper/HR (3/14/16-5/25/18)
Practiced GAAP in Quickbooks to reconcile and manage the general ledger
Analyzed contract agreements and invoiced for billable transactions
Ad-hoc P&L and revenue reports in Excel
Managed payroll with ADP and Tri-Net
Issued checks for expense purposes
Acted as liaison for vendors and customers
Assisted the COO with day to day operations
Monitored accounts receivable and accounts payable
Handled EDD claims
Organized employee hiring packages and data files
Filed and paid company business licenses
Served as a systems administrator for Clinical Conductor
Paramount Pictures via Mergis Group - Financial Analyst (4/14/14-12/30/14)
Calculated and validated P&L financial data of movie and television catalogs with Excel
Analyzed and forecast financial activity of movie and television catalogs in foreign territories
Prepared several financial reports for management on monthly, quarterly, yearly basis
Managed and extracted title performance in SAP, Ad-hoc reports for revenue, expenses, profit
Conducted research and analysis for industry trends
Monitored third party data and vendors.
Warner Brothers via Mergis Group - Senior Participation Analyst (11/25/13-3/31/14)
Used Edocs to pull pencil drafts, Analyzed pencil drafts, interest reports, digests, negative cost schedules, and contracts
Inputted and tabulated negative costs into Microsoft Excel spreadsheets
Utilized SAP Business Objects to pull residual reports
Analyzed actual figures against projected numbers
Created and calculated statement reports and validated financial figures with intricate accuracy
Worked with Gatekeeper to retrieve Schedule A reports
Reconciled interest reports and term deals
Tabulated revenue, expenses, profit from multiple distribution channels.
Midori Ribbon - Inventory/Purchasing Manager (11/28/12-8/9/13; Logistics/Warehouse 4/29/13-8/9/13)
Managed and adjusted inventory with Macola Exact
Analyzed and forecasted item sales with Crystal Reports
Conducted inventory counts
Acted as a point of contact with vendors for sales products
Utilized finance experience to determine monetary value of stock items
Utilized Microsoft Excel to create purchase orders for stock
Oversaw pick-packing for shipping wholesale and retail orders
Utilized UPS tracking to ship and track orders to customers
Organized stock in an efficient manner
Confirmed and tabulated incoming shipment orders.
Warner Brothers via Mergis Group - Business Analyst (9/6/12-11/2/12)
Used Microsoft Excel (features such as vlookups, pivot tables, and some macros) to prepare data conversion from ITD to SAP
Learned about copyright dates and territory mappings
Analyzed distribution protocols and regulations.
FLS International - Accountant/Human Resources (7/26/10-10/14/11; HR 8/15/11-10/14/11)
Used Navision Financial to reconcile month end bank and budget statements
Utilized Microsoft Excel to tabulate student refunds and balancing accounts
Managed and verified multi-state payroll
Analyzed invoices and credit memos
Reconciled the General Ledger
Utilized Paychex to administer payroll, manage employee tax profiles and personal information
Responsible for unemployment claims and employee benefits
Connect Wireless - Commissions Analyst/Accountant (12/10/09-7/16/10)
Utilized programs like RetailIQ, Microsoft Excel, Microsoft Access to collected and tabulated and consolidated sales transactions that translated to commissions for sales employees
Calculated and determined eligible promotions like monthly featured deals (Spiffs) and Buy One, Get One free offers (BOGOs)
Researched into non-commission items and their monetary value
Calculated and organized the weekly and monthly gross profit from all store locations
Southern California Edison via Principal Technical Services - Accounts Payables Clerk (8/17/09-9/18/09)
Reviewed invoices, tabulated shipment weight and quantity
Commuted to actual vendor location to assist in invoicing process in order to meet deadlines
Filed follow up paper work
Organized and archived previous letters of payments.
Alcoa Fastening Systems – Accounts Receivables Coordinator (3/12/08-3/30/09)
Analyzed and reconciled customer accounts
Handled CER claims against customer orders (i.e. shortages, overages, certificate charges, unit pricing, freight, tax, returns, etc.)
Used Oracle Legacy, Oracle Trade Management, Oracle EBS to balance outstanding invoices, credits, debits, and funds open on customers’ accounts
Organized data on Microsoft Excel spreadsheets
Used Microsoft office software to manage day-to-day tasks
Inputted government invoices via WAWF and GSA systems
Mailed out customer credits, and inputted and processed customer checks for placed orders
Trained and certified to be an Internal Auditor.
ABC via Ajilon Finance – Financial Coordinator (12/3/07-1/18/08)
Calculated and reconciled viewer visits, product endorsements, royalties, determined which shows garnered the majority of viewers
Tabulated data with Microsoft Excel spreadsheets
Used SAP to balance day-to-day functions
Disney via Ajilon Finance – Credit & Collections Specialist (4/4/07-11/2/07)
Prepared and arranged weekly credit letters, validated proof of deliveries, used AS400, Citrix, Spyview, and Retaillink to gather invoices, electronic proof of deliveries, signature proof of deliveries, and claim notifications
Organized data on Microsoft Excel spreadsheets, calculated debit and credit amounts per invoice mainly deductions and overpayments of DVD sales
NBC-Universal via Ajilon Finance – Account Receivables Clerk (1/18/07-3/31/07)
Prepared and arranged account charge backs, gathered proof of deliveries from freight companies via websites
Used SAP, Infoport, Techincolor Gold, and Retaillink to pull up invoices, packing slips, and proof of deliveries
Inputted account information on Microsoft Excel spreadsheets, calculated debit and credit amounts per invoice, tabulated month end totals and amount owed on DVD sales
PNC Business Credit via Kelly Financial Resources – Account Receivables Analyst (12/11/06-1/8/07)
Analyzed and reconciled account receivables and month end aging for client companies
Examined the companies’ collateral, inputted and processed daily advances
Reconciled and posted borrowing bases and remittance reports
Searched and calculated cross aging and tabulated AR spreads and concentrations, all data was inputted on Microsoft Excel spreadsheets
Used Lotus Notes, Stucky, and Stuckynet programs to interact with the clients.
SBS (Seoul Broadcasting System), Future and Vision Desk Department - Intern (3/29/06-6/9/06)
Served as a translator between English and Korean at the Seoul Digital Forum
Created documents into formal English
Checked grammatical and spelling errors
Wrote speaker profiles, website introductions, formal invitations, and presentation guidelines
Wrote transcripts of the speeches given at the Seoul Digital Forum.
Computer Skills
Proficient in using Windows 95, 98, NT, 2000, Me, and Linux
Programmed with Microsoft Visual C++
Skillful in using Microsoft Software: Microsoft Word, Excel, Outlook, Power Point, Peachtree Accounting, and Great Plains
Competent with graphics Adobe Photoshop
Contact this candidate