Deborah S Newton

*** ****** ** *** ***, Conroe,, TX. 77301

936-***-****

Email: adt55j@r.postjobfree.com

ACCOUNTING & FINANCE

Accounts Payable • Accounts Receivable • Cash Management • Credit and Collections • Controller • Management

Financial Planning, Analysis & Reporting • Asset Management • Banking/Investor Relations

MS Excel VBA Macros • MS Access Applications • Payroll Tax • Regulatory Reporting • Process Improvement

Innovative, versatile and solutions-driven professional with outstanding financial management, team building and communication skills. Consistently successful in identifying, designing and implementing solutions that link accounting with general operations, regulated reporting, and technology to optimize efficiency and profitability.

Industry expertise in transportation and distribution of oil & gas, commercial real estate, staffing, business process outsourcing, insurance, food processing, auto repair and accounting software consulting.

PROFESSIONAL EXPERIENCE:

Retired, Conroe, Tx 2021-2022

LEAD SR. ACCUNTANT

Lincoln Harris CSG, Dallas Tx 2020-2021

Review and approve Journal Entries and schedules for 6 Sr. Accountants regarding month end close.

●Bank Schedule

●Balance Sheet reconciliations

●CAM Reconciliations

●Late Fee Entries, Rent-ups and Bad Debt Entries

●Property Tax Analysis development, review and approve Tax entries

SR. ACCOUNTANT

CBRE, Inc., Dallas, TX 2014 – 2020

Development and support of GWS Excel VBA Macros and MS Access Databases. Accounting for 5 client contracts to properly record revenue and expenses according to GAAP and company policies and procedures.

●Developed and maintained Excel VBA Macros and MS Access Databases for invoicing and financial reporting.

●Revised Operating Variance Analysis to enable PeopleSoft queries to run in less time, allow reporting to have necessary controls for SOX compliance.

●Support approximately 60 users regarding Excel, PeopleSoft, Excel VBA Macros and MS Access Databases.

●Reconciled general ledger accounts in Blackline.

●Coordinated with Governance on Shared Service Entries and Accounts Receivable reconciliation process to eliminate unidentified variance.

●Accounting and Financial Reporting for 6 Commercial Real Estate Clients including reconciliation to forecast.

CONTRACT POSITIONS 2006 - 2014

SR. FIXED ASSET ACCOUNTANT

SoftLayer Technologies Addison, TX

Maintenance 200,000+ assets in FAS500. Duties included analysis, upload, depreciation and reporting of all fixed assets for multi-national entities.

●Developed and implemented templates, reconciliation and reporting for multi-locations and multi-entity application using MS Access, MS Excel and FAS500.

●Developed and implemented process to extract data from FAS500 to Excel, manipulate data for re-pricing and upload back into FAS500.

●Identified and communicated inconsistent data in legacy system

●Reconciled general ledger accounts to subledgers and bank accounts.

●Communicated with vendors and other departments to determine proper capitalization of fixed assets.

CONTROLLER

Integrity Marine Services, McKinney, TX

Developed and implemented 3 way match for Accounts Payable for multi-locations and multi-entity application.

●Identified and communicated inconsistent data in legacy system

●Implemented purchase order system and centralized accounts payable.

●Reconciled general ledger accounts to subledgers and bank accounts.

●Communicated with vendors to resolve payment issues and establish work-out plans.

●Preparation of data for W-2 and payroll tax reporting

CONSULTANT

Kforce, Dallas, TX

Assigned to Sales and Use Tax for convervsion of data from legacy system to SAP

●Test data in SAP for major energy provider during conversion from legacy system

●Assisted in development of procedures for Sales and Use Tax Reporting

●Completed FERC schedules

●Provided detail for Sales and Use Tax audits.

ASSISTANT CONTROLLER

Service King Collision Repair, Richardson, TX

Month end closing for 47 locations. Improved processes and accounting controls. Managed 3 direct reports and 29 indirect reports.

●Reduced number of days to close by 10 days

●Revised monthly Management Package to provide Dashboard of key metrics at top level and by location

●Evaluation of centralized accounts payable reconciliation and check release process.

●Developed accounts payable reporting, payment projections

●Evaluated imaging, electronic invoicing and payments procedures

●Primary contact with external audit team.

ACCOUNTING MANAGER

Affiliated Computer Services, Dallas, TX 2006 – 2011

Responsible for the work product of accountants in US and Mexico. Balance Sheet reporting and accounts payable.

●Reported monthly, quarterly and annual balance sheet variance analysis

●Developed reconciliation process in MS Access utilizing JD Edwards download reducing preparation time by 68%

●Resolved vendor reconciliation issues on Accounts Payable.

●Coordinated vendor payments utilizing PCards during Xerox acquisition of Affiliated Computer Services

●Determined proper accounting treatment for expenses and capitalization of assets.

●Trained International personnel on US GAAP and ACS Accounting Policies and Procedures

MANAGER TREASURY, CREDIT AND COLLECTIONS

Snelling Franchising, LLC, Dallas, TX 2003 – 2006

Managed 7 accounting personnel to ensure all tasks, duties and deadlines were met.

●Integral team member working with the turn-around, funding company auditors and the acquisition team.

●Resolved outstanding tax and vendor delinquencies while maintaining on-going obligation requirements

●Developed Cash Flow Studies.

●Reduced Days to Pay by 50% through the development of Accounts Payable controls and analysis.

CONTROLLER

AMS Staff Leasing, Dallas, TX 1996 - 2003

Managed 40 accounting personnel for 6 entities.

●Conversion of accounting system, policies and procedures resulting in lower costs, increased accuracy and compliance with GAAP

●Developed/implemented a Federal and Multi-State Payroll Tax reporting database

●Designed/procedures using MS Access to validate the SQL payroll system and communicate inconsistencies and enhancements to owner to ensure data integrity and compliance

●Designed customized reporting process utilizing Microsoft Access and Crystal Reports to meet requirements

●Managed all payroll tax, accounts payable, accounts receivable, licensing and financial reporting.

Self-Employed

El Paso, TX 1993 – 1996

Accounting software-consulting business assisting small to medium-sized companies with accounting software issues.

●Successfully sold, implemented, trained, customized reporting and supported clients in non-profit, property management, manufacturing and construction industries.

●Accounting software packages included ACCPAC Plus Accounting, ACCPAC for Windows, Great Plains, BPI Accounting, and Peachtree Accounting to include all financial modules.

●Managed accounts payable process for clients on a weekly basis.

SENIOR RATE ANALYST

El Paso Energy, El Paso, TX 1980 - 1993

●Daily involvement in high-profile positions which included supervision of the Property, Plant and Equipment; Gas Settlement, Planning, Forecast, Regulatory, SEC and Financial Reporting, Special Projects, General

Accounting and Rate Departments

●Developed rate base/cost of service model utilizing Microsoft Excel that enabled what-if analysis to be conducted in minutes rather than days

●Analysis/implementation of the Allowance For Funds Used During Construction calculation/reporting to comply with Federal Energy Regulatory Commission and to maximize the benefit to the Company

●Utilized extensive knowledge of Federal Energy Regulatory Commission Regulations to audit, expand and amend software to ensure compliance with all Federal Regulations

●Design/implement Plant Work Order Closing procedures that reduced labor costs by 30%

●Reconciled and remitted payment for Take-or-Pay and monthly gas settlements to producers and royalty owners.

SOFTWARE

PeopleSoft, ACCPAC Plus (Sage), Great Plains Dynamics, BPI, QuickBooks, FAS500, Premier Depreciation, MAS90, APEX Summit, Peachtree, JD Edwards, SAP, Hyperion Essbase, Crystal Reports, FRx, Microsoft Access (Intermediate/Advanced), Microsoft Excel (Advanced), Microsoft Word, Microsoft PowerPoint, Transactional SQL applications.

EDUCATION

Bachelor of Science in Accounting, University of Wyoming, Laramie, WY

Associate of Arts in Business, Eastern Wyoming College, Torrington, WY

Certified Public Accountant (Non-active)

Contact this candidate