Jack W. Email & Phone Number

Richmond, Bc, Ca

+ Streamlined workflow by coding macros via Excel, making Excel workbooks improvements, and removing unnecessary work process(es)+ Created an inventory management workbook in Excel that helped programs track and manage their inventory level for gift cards, bus tickets, and care packages+ Identified problem transactions causing general ledger & sub-ledger differences in Great Plains and determined the appropriate solutions (SQL scripts, if needed)+ Managed Workplace and Great Plains' administration settings (batch recovery, opening and closing fiscal periods, users access, user setup, etc)+ Created budget and forecast templates and train program staffs how to use them+ Ensured claims and forecasts are completed within deadlines+ Assisted with hiring by filtering resumes and conducting in-person interviews+ Involved extensively with the audit and audit working paper preparation+ Provided training to team and programs to help improve productivity and inefficiencies+ Provided mentoring to new and existing team members+ Assisted with hiring by filtering resumes and conducting in-person interviews+ Worked with consultants regarding Great Plains upgrades

+ Processed medium volume of accounts payable each month and ensured payments were paid on a timely schedule+ Ensured EFT payments were prepared accurately and processed within a timely basis+ Prepared invoices and followed up with outstanding receivables+ Worked with programs to reconcile monthly and quarterly expense for claims+ Reconciled credit card, advance payments, bus tickets inventory, and bank accounts on a monthly basis+ Prepared month-end internal binders+ Assisted with audit working preparation+ Assisted with payroll when the Payroll Clerk was on vacation

Vancouver, Canada Area

+ Worked closely with product launch team, buying team, and room managers to create and maintain an accurate inventory database+ Created and updated bill of materials for work in process and finished goods+ Reduced the amount of time required to create bill of materials by improving the SKU item# for labels and barcodes+ Updated standard cost for raw materials and packaging supplies

Vancouver, Canada Area

+ Involved with Green team and Charity Pot events whenever possible + Reconciled and resolved discrepancies during month end relating to bank accounts, inter-company accounts, and various prepaid and fixed assets accounts+ Updated supplier database and foreign exchange rates+ Processed medium volume of accounts payable each month and ensured that all raw materials and packaging materials are vouched

Vancouver, Canada Area

+ Reported weekly out of stock report to customer service team+ Accurately recorded production entries into system in a timely manner+ Planned production and ensured production runs smoothly+ Managed inventory stock level and performed monthly inventory counts

Vancouver, Canada Area

+ Verified receipt of goods to packing list before receiving+ Sorted and distributed mails, faxes, and packages to appropriate department+ Shipped out pamphlets and resource materials in a timely manner

Vancouver, Canada Area

+ Issued invoices and reminders to tenants and collected rent payments varying between $250 and $4000 in forms of cash, cheque, debit, or credit+ Prepared financial statements for individual owners and responded to owners’ inquiries of financial statements+ Reconciled bank accounts and sales report+ Performed daily bank runs and other administrative duties

Vancouver, Canada Area

+ Performed duties with little to no supervision+ Safely marshalled lift truck to the door of a parked plane

Vancouver, Canada Area

+ Acted as lead hand for 6 months and supervised a team of 3+ Trained new employees and resolved customers’ concern+ Performed accurate cash handling and cashed out an average of $4000 per week

Bachelor Of Technology (Btech), Accounting

Completed

Non-Profit/Public/Organizational Management

+ Studied two courses: --- Essentials of Fundraising --- Financial Management for Nonprofit Organization

Diploma Of Technology, Financial Management

Completed

Electrical And Computer Engineering Technology

+ Successfully completed 2 of 4 terms + Studied c programming, calculus, and various electrical courses