April R. Barnes, MBA

**** ****** ***** ****, *******, Texas 77047

acdux0@r.postjobfree.com

832-***-****

Technical

Skills:

Financial Modeling, Budgeting, Forecast Reporting, Government, Tax, Cost and Private Sector Accounting

Variance & Trend Analysis, EVM & Financial Calculations and Excel Formulas

Strong Excel Skills Performing V-Lookups, Pivot Tables, Macros, Formulas, Slicers & Dashboard Reporting

5 years of Management/Supervisory Skills and Experienced with Month End Close Process

Documentation Audits, Managing Project, Financial Reporting & Conversion in GAAP & IFRS

Preparation of Balance Sheet, Income Statement and Cash Flow Reports

19 Years Finance, Accounting, Tax, Analytics and Project Management Experience

Experienced in Various Industries (i.e. Government, Cable/entertainment, Wireless Communications,

Software, Non-Profit, Biopharmaceutical, Healthcare, Retail, Investment and Construction)

Software

Skills:

Oracle Financial

PeopleSoft COGNOS

SAP MACS (Mail Order Catalog System)

BAAN FAS

Great Plains Hyperion (HFM)

MAS90 GWYNN Report Writer

Crystal Report Writer

QuickBooks User Certified

Advanced Functionality in Excel MS Word, PowerPoint, Access, Project

MOSCAS ADP/Paychex/Empower Payroll Systems

DELTEK Incent/SalesForce.com

Professional

Background:

Consulting Agency, Houston, Texas/ San Diego, CA (03/12 – Present)

Controller (Consultant)

Perform the monthly close process and prepare monthly financial statements (Compilations)

Develop and implement accounting policies and procedures

Improve Process and give input on and document financial internal controls

Monitor and implement changes in the industry accounting standards

Responsibility for the general ledger, fixed assets, accounts receivables, accounts payable and daily

cash management

Implement new various states payroll taxes, participate in compliance with local, state and Federal tax

reporting

Data Extraction, Validation and Import into QuickBooks

Oversee Payroll Administrator

Report directly to the CFO and President, work closely with Operations, Sales and company

Management

Sr. Sales Ops Business Analyst (Consultant)

Prepare Client for Compliance and Perform Reconciliations

Heavy Report Writing & Updating Templates in Excel (Pivot Tables, V -lookups, Nesting Formulas,

IF, Text, INDEX+MATCH and WORKDAY Formulas)

Data Extraction/Data Manipulation from Commission &Payroll Systems for Adhoc Reporting

Maintain Material Master Reports and Sales Accounts in SAP

Improve Process and Implement Systems Changes, Controls and Documentation

Review and Research Payroll Laws in Various States for Overtime and Commission Calcs

Prepare Various Financial Models and ADHOC Reports for Management and Executives.

Manage Cases, Troubleshoot Issues and Support about 80 Reps, Managers and Executives

April R. Barnes, MBA Page 2

Professional

Background:

Robert Half International, San Diego, CA (04/07 – 03/11)

SPS Consultants

Sr. Accountant/Financial Analyst – Time Warner Cable

Revenue Commission Calculation and Process Improvement

Manage Month End Close Activities, Allocations, Accruals, Forecast and Variance Analysis

Work Closely with Revenue and AP Team to Assess Commissions and Analysis

Senior Accountant /Project Manager – Thunderbird Resort

Convert Financial Reporting from GAAP to IFRS

Handle the Project for Las Vegas Launching.

Project Manager - L-3 Communications

Interviewed Team and Implemented a Business Continuity Plan

Create and Maintain WBS and Tracked Task and Deliverables

Various Agencies, San Diego, CA (08/05 –03/07)

Sr. Financial Analyst/Inventory Data Analyst

Inventory Data Analyst – Cricket Communications

Analyze and Process Data and Report Writing for Inventory Tables

Develop Journals using Advanced Excel Skills (i.e. VLOOKUP and Pivot Tables)

Verify Integrity of Data for Inventory/Cost, Reconciliation of Tables and Accounts

Manage Month End Close Activities, Allocations, Accruals, Forecast and Variance Analysis.

Gather Data for SOX Inventory Processes and Prepare Working papers for SOX Compliance Audits.

Pricing Analyst - Qualcomm Wireless Business Solutions

Assist with Oracle Upgrade and Import/Configure New Pricing in Oracle for Existing and New Parts

Respond and Troubleshoot Issues from Contracts and Sales Administration

Prepare Financial Models for Customers and Products (i.e. BOM).

Develop Documentation and Training Manual for Pricing

Analyze Contracts, Report Writing, Process Improvement for Pricing of Customer and Analysis of

Various Data in Oracle 11.5.9i

Prepare Analytical Data for Product Life Cycle/Cost/Pricing

Education

Background: (2007-2008) Project Management Certification Program

UCSD, La Jolla, CA

(1999-2001) National University, San Diego, CA

M.B.A., Major: Electronic Commerce and Finance

(1996-1998) National University, San Diego, CA

B.S., Major: Accounting

(1991-1994) Mesa College, San Diego, CA

A.S., Major: Health Information Technology

Contact this candidate