Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Edward Scott

Desoto,Texas

Summary

Analytical financial manager with extensive accounting and finance experience. Successful in streamlining financial processes through the leveraging of technology to make processes more efficient and to advance staff skills set. Highly proficient with ERP finance systems and very skilled unitizing the following applications: Oracle, Hyperion, Quick Books, ADP, STW, Advantage & Info Adv, Workday, Hyperion, advance Excel, and Access.

Overview

28
28
years of professional experience

Work History

Finance Supervisor - Sr. Accountant

City Of Dallas - Dallas Police Dept.
Dallas, TX
08.2017 - Current

Supervise operations that process an estimated 650 invoices monthly and procure over 150 purchase orders monthly. Oversees Accounts Payable, Travel, and Petty Cash functions.

Accomplishments

• Performed external audited of landlord ledger and identified $204k of invalid charges. All charges were recovered from the landlord.

• Establishing a central inbox to receive all invoices, Improved performance.

• Reviews orders and receivers to advance payments and to ensure timely/accurate invoice submission.

• Reviews and monitors master agreements and contracts for compliance.

• Serves as liaison to accounts payable and vendors.

• Generated trended performance metric reports.

• Manages Lease Facilities programs for DPD, maintains a Lease Payment matrix that drives accurate payments per the contractual agreements.

• Automated the invoice payments confirmation process.

• Reconciles open encumbrances to closure.

• Manages SalesForce exceptions. by reconciling AMS back to salesforce.

• Developed an analysis based process to manage aging orders. ESUM & Info-Adv.

• Support grant management doing grants close out.

• Collaborates with vendors to avoid misc. fees.

• Conducts quarterly reviews looking to eliminate inefficient procedures.

Accounting Supervisor

City of DeSoto
DeSoto, Texas
10.2015 - 08.2017

Managed all aspects of accounting including payroll, billings, cash management, accounts payable and fixed assets. Provided financial support and analysis to Court, Information Systems, Police, Code, Fire, 911, Parks, Facilities and Library.

• Responsible for financial management of Property Liens.

• Assisted in the preparation of the City’s budget and Comprehensive Annual Financial Report.
• Assisted in the management of the City’s cash and investments, including online banking, cash collections, reviewing of deposits and performing periodic internal audits.

• Assisted with the preparation of the comprehensive annual financial report.
• Reconciled daily utility billing collection reports to bank statements.
• Managed 2 direct reports.

Accomplishments

• Developed a complete Payroll processing manual.

• Reviewed all changes in pay rates and all special pay exceptions.

• Supervised depositing of payroll taxes and retirement contributions.

• Performed bi-weekly payrolls audits in conjunction with HR.

• Streamlined the payroll task list and reduced processing time by 6 hours.

• Reformatted journal entry templates to reduce data entry; Produced 30% in time saving.

• Coordinated software conversion project from CLASS to Active-Net. (PARKS)
• Completed all bank accounts and balance sheet accounts reconciliations.
• Created financial reporting packages for new entities: Housing and Economic Boards.
• Provided annually cash handling training to non-finance departments.

Senior Financial Analyst

British Telecom ­- Global Services
Irving, Texas
04.2012 - 09.2015

Provided accounting and analysis support to a global sales team of 7 entities, with total combined revenue of $5b. Prepared and uploaded Oracle ADI journal templates into the Global Finance Platform (GFP) to recognize revenue and cost of sales. Provided month to month and year to year revenue, margins, and cost of sales analysis and reporting. Ensured SOX compliance and supported annual audits.

Accomplishments
• Lead the migration of the accruals cost system to an Access based platform.

• Persuaded management to release $16m of aged accruals by performing an in-depth analysis of liabilities.

• Completed monthly account reconciliations four days earlier by utilizing VLOOKUP to match projects to accounting codes on incoming transferring entries.

• Assisted with the implementation of new global circuit inventory system.

• Developed written operating procedures for the MS Access accruals database.

• Spear-headed the“Continuous Improvement” team that retrieved $2.5m sales tax refund from vendors.

• Managed Access database for circuits cost of sales accruals.

• Facilitated monthly balance sheet review meetings with management.

Sr. Accountant

City Of Dallas - Technology Services
Dallas, Texas
01.2009 - 01.2012

Responsible for the cost allocation of IT costs to internal departments. $75m.

Created service level agreement in MS Access, prepared cost schedules, and approved all allocations journal entries. Supported government auditors during vendor audits. Processed cash revenue receipts and prepared weekly cash forecasting. Coordinated annual inventory for technology services assets.

Accomplishments

• Reduced receivables that were over 90 days outstanding by 90%.

• Reduced inter-department charge-back disputes case by 75%.

Accounting Manager

Dallas Housing Authority
Dallas, Texas
01.2007 - 01.2009

Managed day to day accounting for Rental properties and Housing Tax Credit (HTC) programs. Developed financials for executives, property managers and investors. Reconciled YARDI sub ledger accounts to general ledger activity. Managed 3 direct reports, provided employees performance and development plans.

Accomplishments;

• Collected $15m of outstanding capital contributions from investors.

• Performed audit of vendor invoices and discovered that $25k of sale taxes were paid on exempted items.

• Performed market research and analysis on rental rates.

Director of Finance Administration

Work Source Solutions
Dallas, Texas
01.2005 - 01.2007

Directed accounting services for State of Texas, $75m Work-Force contract. Responsible for payroll management, accounts payable, gas cards funding, and the call center. Administered annual operating and capital budgets.

Accomplishments
• Improved employee's accountability by developing performance measures for all finance positions.

• Managed leasing contracts and all service based contracts.
• Slashed security and maintenance cost by 20%, negotiated reduced rate.

• Directed 12 employees and reviewed all performance evaluation.
• Ensured audit deliverables were completed on schedule.

• Prepared weekly cash flow analysis.

Finance Manager - Revenue Manager

Nortel Networks - Verizon Account
Richardson, Texas
07.1995 - 12.2004

Managed financials for Sales Team to record $2.5b in Networks revenue, exceeding budget by 1b due to market growth.
Provided financial guidance for region revenue recognition process.
Accomplishments:
• Developed revenue forecasting matrix for global sales team. Total $2.5b
• Maintained Revenue Contract Ledger system.
• Managed spending budget for customer service unit. $120m expenses.
• Centralized Fixed Assets by merging all U.S. operations into one database.
• Developed labor rates for engineering and installation departments.
• Reviewed and approved financial cost justifications for capital projects.

Education

Bachelor of Science - Accounting

Southern University
Baton Rouge, LA

Professional Tax Preparer - PTP - Taxes

Universal Accounting
Salt Lake City, UT
2015

Skills

  • Budget & Analysis
  • Liens Management
  • Payroll Management
  • Accounts Payable
  • Grant Management
  • Travel and P-Cards
  • Contracts/Procurement
  • Financial Reporting/Ad-Hoc
  • Revenue Recognition & Cash Receipts
  • Audit Reviews
  • Process Improvement
  • Fixed Asset Management
  • Data Modeling
  • Policy and Procedures Development
  • Internal Controls

Additional Information

  • COMMUNITY INVOLVEMENT:
  • President of Brotherhood - Freedom Church
  • Sports Commissioner ­- Dallas YMCA
  • Meals On Wheels ­ Group Coordinator
  • Men Bible & Breakfast Small Group - President

Timeline

Finance Supervisor - Sr. Accountant

City Of Dallas - Dallas Police Dept.
08.2017 - Current

Accounting Supervisor

City of DeSoto
10.2015 - 08.2017

Senior Financial Analyst

British Telecom ­- Global Services
04.2012 - 09.2015

Sr. Accountant

City Of Dallas - Technology Services
01.2009 - 01.2012

Accounting Manager

Dallas Housing Authority
01.2007 - 01.2009

Director of Finance Administration

Work Source Solutions
01.2005 - 01.2007

Finance Manager - Revenue Manager

Nortel Networks - Verizon Account
07.1995 - 12.2004

Bachelor of Science - Accounting

Southern University

Professional Tax Preparer - PTP - Taxes

Universal Accounting
Edward Scott