Financial Analyst Accounting Consultant
Resume:
PAUL A. SMITH
Lake Forest Park, WA 98155
EXPERIENCE
July 2022 – Aug 2022
Senior Accountant – Contractor
Beacon Hill Staffing - City of Seattle
Accounts Receivable entry and reconciliation
Accounts Payable entry and reconciliation
Review program contracts and bill accordingly
Assist in Travel and Entertainment expense recording and reporting through Center
Review MIP accounting transactions for completeness and functionality
Participated in operational procedure and activity mapping discussions to assure propr SOD and transaction and activity efficiencies.
2021 Nov – July 2022
Senior Accountant – Contractor
Beacon Hill Staffing - Coinstar
Month End close for multiple foreign entities
Cash Reconciliations in excess of 150M
Reconcile Kiosk coin machines to bank deposits
Assist in the transition from SAP to CSI Infor
oReconcile and catch-up bank accounts
oAccount and bank code mapping translations
2021 Financial Operations Analyst - Contract
Supporting Strategies
GAAP accounting for numerous small to mid-sized clients
1099 Reporting
Financial Reporting
Month End Close – numerous clients
Payroll processing
2019 Consulting Assignments: Everett Clinic Everett, WA
ASSISTANT CONTROLLER
Review leases for oncology group and determine proper accounting for renewals
Review Asset Purchase Agreement for National Physicians Network being sold and determine proper patient claims reserved for in escrow agreement
Review and sign off on account reconciliations for 3 divisions
Reconcile incoming ACH wires in operating account for month end timing differences
Reconcile credit card deposits for month end timing differences
2012-2018 Consulting Assignments: 20th Century Fox, Live Nation, Miramax,,Filtec, Westfield, LLC, Ovation TV, Toyota Motor Sales, Panavision, Hundreds is Huge, LA Regional Food Bank – Los Angeles CA
SR ACCOUNTING CONSULTANT
General Ledger Accounting
Month End Close
Journal Entries
Bank Reconciliations
Account Reconciliations
Deferred Revenue Reconciliation
Management Reporting
Consolidated Artist Management Companies through Oracle – Live Nation.
Posted Revenue Accruals
Ad Hoc Analysis
Fixed Assets
Automated the forecasting and variance analysis review, saving preparation time by 50% - Live Nation
Created and automated variance analysis reporting – Live Nation
Reconciled long standing balances in CIP and reclassed to Assets – Toyota Motor Sales
Prepared inventory roll forward – LA Regional Food Group
Audit Support – Multiple assignments
Budgeting and Forecasting – Multiple Assignments
Reconcile Full Circle ERP and Quick Books ledger after conversion. – Hundreds is Huge
Create Weekly Cash Flow Review – Live Nation, Hundreds is Huge
Schedule and Reconciliation Preparation – All Assignments
Systems Used – Oracle, SAP BPC, SAP, Great Plains, Netsuite, Hyperion, Peoplesoft, Cognos, Lawson, MAS 500, MAS 200, MAS 90.
Feb 2011 – Oct 2012 Agensys, Inc., Santa Monica, CA
SR. FINANCIAL ANALYST
Built payroll model used for budgeting, forecasting and compensation accrual calculations
Prepared and maintained headcount budgeting and forecasting database
Prepared and booked payroll journal entries
Prepared bank reconciliations
Prepared other month end journal entries
Project lead on a web based time keeping implementation to keep track of staff time by major projects, tasks and activities and used for project cost allocations and corporate budgeting
Prepared and distributed Month End Cost Center reports to supervisors for review of current month results against plan and forecast
Prepared and reconciled intercompany accounts monthly
Other projects for Director and CFO as needed
Worked with consultant to implement Oracle Discoverer for setup and distribution of financial reports
Systems Used – Oracle V10
May 09- Feb 11 Mercury Air Group, Playa Del Rey, CA
SR. FINANCIAL ANALYST
Prepared and managed Fixed Assets
Prepared month end journal Entries
Management reporting
Setup FRX Management Reporting for managers and supervisor reviews
Created management reports for Cargo division to assist in the monthly review
Prepared line of credit reporting to Bank of America
Assisted CFO in the yearly budgeting process
Reported to and assisted the CFO on other projects as needed
May 08 – Apr 09 Don Ed Hardy Apparel (dba Nervous Tattoo) Culver City, CA
ASSISTANT CONTROLLER
Project lead on ERP selection process
Drafted end user needs analysis for each department to use in our evaluation of a new ERP software solution
Organized the ERP selection process coordinating software demonstrations from big vendors such as Oracle, Innovative Systems and SAP
Created software selection score card that was reviewed by executive management and used in our decision to implement an Oracle/DAZ software ERP platform
Performed a thorough business process review in conjunction with assessing each department’s ERP software needs.
Re-engineered the commission calculation process in MS Access and corrected prior month payments upon my arrival.
Hired needed staff for G/L accounting
Identified all M/E closing tasks and created a month end close schedule for the staff to follow and facilitate a timely close.
Implemented a supplemental revenue and A/R reporting processes in MS Access to assist in facilitating the closing of the revenue cycle each month.
Worked with Management to implement FRX reporting
Assisted in first year audit with Ernst & Young
Oversaw retail accounting divisions
Audited retail pro accounting system for correct inventory valuation
Assisted in physical inventory process by reconciling tag numbers and log sheets to Y/E inventory adjustments entered into Pacific Apparel ERP system.
Reconciled Factored Receivables and Revenue reports to internal ERP system in Pacific Apparel.
Reconciled intercompany purchases between wholesale and retail divisions.
Journal Entries
Feb 05 – Apr 08 WMG (Wasserman Media Group) Productions/Sportnet, West Los Angeles, CA
DIVISION CONTROLLER
Supervised, trained and developed accounting staff, including clerks, staff accountants and managers
Full responsibility and management of multiple general ledgers, month end close and financial reporting, ensuring accuracy of information in accordance with GAAP
Managed accounts receivable activities, including invoicing, collections, cash applications, write-offs and bad debt provisions
Managed accounts payable activities, including invoice approval, expense categorization, reconciliation to the G/L, timely payment of invoices
Oversaw all other financial areas, including product costs, inventory, billing and collections.
Conducted month and year end close, reconciled and balanced all accounts and reviewed month end journal entries.
Oversaw the audit process with external auditors
Review intercompany transactions and reconciliation
Manage day to day accounting operations
Perform monthly analytical reviews
Assist in budgeting and forecasting
Implement and improve operational and financial processes
Manage special projects
Designed and implemented royalty reporting process for over 73 partners using Microsoft Access and Netsuite accounting software.
Project lead for full accounting system conversion from Microsoft Great Plains to Netsuite
Manage a staff of 4 accountants and 1 accounting clerk
Fast paced start up environment with the need to provide quick solutions and implement new processes
Systems Used – Great Plains, Netsuite
Journal Entries
Dec 03 – Feb 05 THQ Wireless, Calabasas, CA
OPERATIONS MANAGER
Created financial and headcount projections model to plan for quality assurance resource needs and cost allocations. The financial model supported the ongoing forecast and budgeting processes for the quality assurance business unit
Created and managed the product release calendar.
Worked with SAP team leads to implement SAP project systems for the wireless division.
Designed and created access database to track all aspects of the Product Lifecycle from contract management, tracking the statuses of sku production, to distribution of product into the sales channels.
Project lead in an initiative to create a stand alone Quality Assurance department previously resourced by our corporate partner. Included creating an operational and capital budget proposal and analysis.
Worked with Business units to create division wide policies and procedures.
Project reporting manager for all aspects of the production life cycle from product concept to delivery of finished goods to customer. Product portfolio for 2005 was 30 + projects.
Implemented project reporting tools to track all aspects of production.
Worked directly with president on many projects including assisting in creating business case proposals to executive management. This included the financial forecasting of offshore porting operations for wireless games.
Project lead on implementing Company wide Intranet which supports the project management reporting needs of the division
Was responsible for tracking and reporting to executive management the costs, schedules and quality of ongoing projects.
Created project specification templates utilized by producers to manage their projects and assist them in reporting the schedule, cost and specifications of each project to management.
Created numerous reporting tools in Access, Excel and MS SQL to analyze and report on status of products in production, deployment and submission phases of the product life cycle.
Created royalty calculation tool in MS Access and Excel to track royalties due to asset properties of the MLB, NFL and other major movie brands included in the distributed games.
Systems Used – SAP, Hyperion
July 03 - Nov 03 Homestore, Inc., Westlake Village, CA
SENIOR ACCOUNTANT
Responsible for end month journal entries, and account reconciliations
Prepared balance sheet and profit and loss statements for the Homestore rentals division
Liaison between accounting and information technology
Worked to improve sales commission system for more accurate and timely commission payouts
Jan 97 - Jul 03 DIRECTV, El Segundo, CA
ACCOUNTING SUPERVISOR (1/00 – 07/03)
Was responsible for designing and implementing Access databases to perform payment/royalty calculations for payments to major suppliers of DIRECTV programming including, MLB, NFL, NHL, MLS and other sports programming.
Served as a liaison between Accounting and IT to implement several projects to assist in the calculation of payments to major subscription suppliers such as HBO and Cinemax.
Assisted in the implementation of Hyperion for the purposes of consolidated financial reporting.
Reviewed supplier contracts and performed backend payment processes for all seasonal sports, ESPN and STARZ/Encore. Each payment was in excess of $15 million.
Was responsible for creating a backend process to handle the company’s monthly invoice preparation to the NRTC affiliate in excess of $50 million per month.
Was responsible for the supervision of two revenue accountants and the one staff accountant.
Assisted in the conversion of existing payment processes of major suppliers of DIRECTV to a new Enterprise Payment System.
SENIOR REVENUE ACCOUNTANT (1/97 – 12/99)
Materially involved in the A/R and Revenue conversion to SAP
Helped prepare A/R and revenue end user scripts to assist in SAP setup and conversion
Managed and supervised the conversion of Accounts Receivable and Revenue into SAP
Assisted in the preparation of consolidated and published financial statements.
Responsible for the recording of subscription revenues of over $300 million per month.
Designed and implemented an access database to compile billing reports into journal entries between billing system and SAP general ledger for the recording of revenues.
On the conversion team for the Primestar acquisition to prepare and integrate the Primestar revenue process into DIRECTV’s model.
Worked in Tokyo Japan with DIRECTV Japan partner to assist DIRECTV Japan in setting up accounting functions, for new Operation, specifically assisting staff in creating a process for interfacing the customer billing system revenues into a Solomon G/L platform.
Systems Used - SAP
EDUCATION
San Diego State University
Bachelor of Science, emphasis in Accounting
Pepperdine University
Master of Arts, emphasis in Clinical Psychology
SKILLS
Software
Planning Tools
Office Tools
Other Skills
Oracle R12
Hyperion
Advanced Excel
Project Management
Netsuite
SAP BPC
Word
Staff Management
SAP
Cognos
Power Point
People Soft
RDBMS (Access, MS SQL)
Advanced Access
MS Great Plains/Dynamics
Adaptive Planning
MS Project
MS Navision
Oracle Discoverer
VB for Excel and Access
MAS 90 thru MAS 500
FRX
Fox Pro
Quickbooks
Power BI and Power Query
Contact this candidate