Derek Dewar Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

• Completed all assigned Limited Contract Compliance audits moving to our contingency audit schedule for 2024.• Built the risk assessment for 2024 analyzing over a 125 contracts for risk and prior audited periods to determine who we should audit for 2024.• Designed a new test for our audits, ACDBE participation.• Proficient in using GAAP and GASBA (Yellow Book) for designing and testing audits.• Facilitated and owned the departmental budget, coordinating information between managers and staff to the director, updating the spending forecast with detailed explanations on the future spending. Fixed variance between the budgeted and actual spending for each month and quarter.• Enhanced the departmental budget for greater user friendliness and to easily see how much budget remains after spending and after what time period.• Trained a team member in the use of the departmental budget process.• TeamMate Champion (Administrator) for our audit software.• Setup of all departmental audits, audit plans and risk assessments setup in Teammate.• Trained two team members in using TeamMate software.• Reviewed and processed departmental payroll and generated payroll reports for management and team members.• Spearheaded the development of upgrading our audit software for more functionality and better security, coordinating with the IT team and Wolters Kluwer with the implementation of the upgrade.• Created thought provoking equity moment presentation to inform and create discussion about how we view race and family.• Presented audit controls and risks to new employees at their new employee orientation.

Seattle, Wa, Us

• Reconciled over 25 different bonus accrual recons monthly.• Analyzed metrics to determine recipients’ eligibility for bonus payment and type.• Utilized formulas to cut manual process times down when reconciling roll forward files.• Created over 60 different types of journal entries per month.• Resolved variations in data on the balance sheet through detailed descriptions of what occurred during the month.

Redmond, Washington, Us

• Reconcile short term and long term prepaid contracts monthly, utilizing ASC 842.• Record Fixed asset additions, disposals, accelerated depreciation, transfers and gain/loss on sale of fixed assets for Nintendo of America, sub and sister companies.• Report changes in equity on a quarterly basis with corporate headquarters.• Coordinate, prep, and sent out mid year budget updates for NOA, NMI and NOCL.• Reconcile the miscellaneous payroll account.• Prepared the financial statements for Nintendo Software Technology and reported major changes monthly.• Bill Nintendo Software Technology for intercompany transactions from NOA.• Complete lease calculations for the sub and sister companies.• Calculate internal labor charges for software projects.• Create extensive documentation for all JE’s and reconciliations to show completeness and reasoning behind all related financial transactions.• Perform month end, quarter end and year end reconciliations.

Bellevue, Washington, Us

• Finalized financial statements and representation letters.• Tested cash for completeness and existence.• Performed HUD required compliance testing of tenant files, security deposits, work order completion and disbursement testing.• Completed audit programs and related checklists documenting procedures taken during the audit.• Inspected accounts payable ensuring proper cutoff and accrual of invoices.• Brainstormed fraud risk factors relating to misappropriation of assets, fraudulent financial reporting, compliance and IT related risks.• Analyzed expense accounts using a comparative approach between budgeted balance to actual spending.• Evaluated loan documentation to ensure correct payments to the principle are made and interest is properly recorded.• Reviewed client cash flow water fall for related party fees ensuring waterfall related fees were paid or accrued in correct order and to the right party.

San Francisco, Ca, Us

• Maintained the integrity and accuracy of over 20,000 fixed assets.• Ran depreciation on all agribusiness areas in accordance to month end schedule and depreciation trend analysis.• Reconciled and balanced our multi billion dollar intercompany account between Agribusiness and Corporate.• Largest reduction in WIP carryover in company history for the Western division. • Calculated asset cost from Multi-million dollar acquisitions insuring accuracy from the legal documentation of the acquisitions.• Created over 114 assets per month with efficiency and attention to the details of the asset.• Transferred assets between branches calculating gain/loss in the process.• Disposed of assets that were sold, had insurance payouts, were scrapped, traded in or destroyed.• Created WIP carryover report so that business analysts could see how much money was outstanding for their respective business units and so that they could budget appropriately for 2020.• Completed and filed tax Form 720.• Distributed Model Waiver L forms to suppliers for tax exemption on fuel tax.• Researched economic nexus, sales and use taxes laws for 18 states.• Accrued use tax on specific invoices and relayed that information back to Accounts Payable.• Coordinated with data analytic team on the construction of an asset tracking file for improved user turn out of annual fixed asset review.• Create fixed asset reports for operations and corporate personal.• Automated tasks from the capital report cutting processing time and increasing the accuracy of the report.• Coordinated financial information with 140 branches in 18 states.• Assisted in year-end fixed asset audit and sales and use tax audit.

Kingston, Wasington, Us

• Audited Hotel’s revenue and expenses.• Balanced daily cash flow for the bank reconciliation.• Inventory and related revenue to COGS analysis for offsite properties.• Researched into credit card fraud.• Prepared the 2018 budget for the Casino and Hotel.• Collaborated with management on the creation of a Hotel tax tracking system.• Processed Accounts Payable.