Power Bi Accounting Manager

Carla Moody

*************@*****.***

*** ********* *** *****

Englewood, CO 80112

SUMMARY

- Solid accounting knowledge

- Ability to analyze complex data and interpret into meaningful ways for others to comprehend

- Reconciliations = My Specialty

TECH

+ Power BI

+ Microsoft Dynamics 365

+ MySQL (Oracle)

+ Blackbaud

+ G-Suite / Netsuite

+ QuickBooks (desktop/online)

+ Spectrum

+ ViewPoint

+ Job Nimbus

+ Sage

+ JD Edwards + SalesForce / Textura / Tableau

EXPERIENCE

Dec 2020 – Present (contract)

Finacial Analyst/Accounting Consultant (remote) VACO Denver, CO

Created Power BI dashboards based on assessment of employee entry analytics

Set up Power BI automations & queries (M Language) to replace complex Excel formulas

Produced/presented graphically visual reports (Revenue Analysis, Job Cost, WIP, KPI, etc.)

Revenue Recognition (ASC 606)

Form 990 reporting (non-profit)

Implemented Quickbooks inventory module

Aided in streamlining inventory tracking/reporting process

Assessed accuracy of various backlogged data entered in QuickBooks. Made recommendations / necessary adjustments.

Prepared financial statements

Bank reconciliations

June 2018 – July 2020 (business closed)

Accounting Manager FRONT RANGE CONTRACTING (ROOFING) Littleton, CO

Full Cycle Accounting - Financial Statements, Month-End/Year-End, G/L adjustments

Bank & CC Reconciliations

A/P (3-Way Match) & A/R (aging)

Job Costing - Analyze production, material usage, labor variances, etc.

W.I.P. (work in progress) reports

Tax Filings – Payroll, Sales & Use

Management of contractor licenses & permits

July 2017 – June 2018 (Moved)

Accountant ENCORE ELECTRIC, INC. Lakewood, CO

Reconciled bank & Comdata accounts, Monthly expense analyses

Ensure all financial statements were in accordance with GAAP

Manage A/P & A/R departments (5 employees)

Taxes – Sales/Use, W/H, Local, OCIP

Certified Payroll (LCP Tracker)

Taught an on-site “VLOOKUP & Pivot Tables” class at Encore University

Monthly lease maintenance (5-year maturity schedule) Nov 2012 – May 2017

Cost Accountant AMERICAN CIVIL CONSTRUCTORS, LLC Littleton, CO

Job Cost Analysis- Allocating costs on a project basis (labor & equipment hours)

Aided in ERP change-over (JD Edwards to ViewPoint).

Fixed Assets /Depreciation Maintenance

Managed A/P for Rocky Mtn Division

Lien Releases/Progress Payments

Managed certified payroll including auditing subcontractor compliance

Oversaw weekly payroll/garnishments weekly for 320 employees

HR cross-training – New hires / open enrollment

Jan 2007 – Nov 2012

Bookkeeper DIRTWORKS EXCAVATION, INC. Lakewood, CO

Invoicing

Bank Reconciliations

A/P & A/R

Vendor Maintenance

Make adhoc adjustments to offset data entry errors, account misclassifications, etc. EDUCATION, ETC.

B.B.A - University of Denver Denver, CO

Major – Business Analytics

Minor – Accounting

Diploma - Bear Creek High School Lakewood, CO

Microsoft Office Specialist: Excel -

https://www.credly.com/badges/40ec6b68-45ee-445f-9e7b-c94c124a2c97/email Notary Public

Contact this candidate