DOUGLAS A. WATERS

*** ***** ******* ****** *****: 303-***-****

Lakewood, Colorado 80226 Email: ac4dyc@r.postjobfree.com

FINANCIAL ANALYST

Built Budget Models for Depreciation/ Prepared Budget to Actual Variances

Prepared Monthly Reconciliation of Fixed Asset Accounts

Created Major Database to Analysis Large Sets of Data

Created many Ad-Hoc reports / Customer Service / Team Leadership/Prepared Hyperion reports both inputting into and extracting/Experience in Oracle Project

PROFESSIONAL EXPERIENCED

Denver Water

Contractor 1/2018-2/2018

Reconciled Capital Projects to bring the actual to date. Conducted research on actual to insure projects were charged correctly. In addition copied cost supporting documentation to be included in project workpapers.

Nagra

Contractor 6/2017-12/2017

Created IT and Security projects in Oracle and Dynamics. Conducted ad hoc analysis of project status, status of unprocessed timesheets and prepared migrated project reports for migration from Oracle to Dynamics.

DISH Network 12/2016-3/2017

Contractor

Created process tool in Access. This tool is analysis subscriber information to generate the cost of service at the subscriber level based on contract rates. In addition, it was determining new connects for a month.

XCEL Energy – Contract Position 2/2016-8/2016

Project Control Specialist

Created Cost Analyst Report (CAR) for Capital project over 10M. This involved reporting ETC and EAC with variance explanation. Consulted with the Project Manager in developing the Monthly Forecasts and provided financial guidance when required.

KINDER MORGAN, Lakewood, Colorado 9/2004-7/2015

Largest independent Natural Gas and Petroleum pipeline transport company in the United States.

Senior Financial Analysis

Created and developed reporting tools for Project Managers; created standard reports for the Project Manager to determine if project is in budget; developed summary reports for management to see over all status by budget code to determine if budgets are on spend schedules

Create the prototype of a project management financial tool to monitor individual projects; provided guidance to the IT department in creating a deployed version on a corporate-wide basis; maintained guidance on enhancement and improvements on the deployed tool.

Maintained Fixed Assets including projecting Depreciation, FERC Form 2, and FERC 3 reporting on specific Pipeline companies.

DOUGLAS A. WATERS Page Two

Had responsibility to maintain in the Lawson Ledger application the Activities module. This included set-up of activity groups, adding account categories, and establishing general ledger accounts to activity groups.

Built complex Access Databases to perform calculation on monthly Capital Interest on Projects, resulting in the journal entry being generating and supporting documentation.

Developed Ad-Hoc databases to generate reports of balanced Project Costs to the General Ledger, Fixed Asset module to the General Ledger, and various others requiring the ability to handle large volumes of data to generate these type of analysis and reports.

Created reports out of hyperon as the source. This involved extracting the data and using features within hyperon to summarize and export the results.

CD TELECOM, Englewood, Colorado 1/2002-8/2004

A division of Cendant Corporation that has responsibilities for all telecommunication for the entire corporation.

Financial Analyst II

Created Capital Project Access database to improve all aspect of processing and reporting of status of projects

oPurchase Requisitions processing, reducing the time of 1 hour to 15 minutes per requisition

oCreated and established standard management reports ranging from the amount of the Project requisition to the overall view of all Capital Projects currently underway.

LEVEL 3 COMMUNICATIONS, INC., Broomfield, Colorado 4/1999-12/2001

Global communications networking company that is the first network to be completely optimized for advanced Internet Protocol (IP) technology.

Sr. Analyst

Created major Access databases to capture Cost Savings Initiatives and Ad hoc analysis of over 32,000 leased circuits; created management reports to summarize actual to budget;

lead and coordinated the Cost Saving Initiatives to identify circuit savings of over $8 million of reduced lease expenses.

Prepared monthly forecasts using marketing forecast units and current run rate to determine the year-end leased costs.

Developed the monthly close process involving all journal preparation, internal management reports, and Liability Account Reconciliation with a value of over $45 million

TECHNICAL SKILLS

Proficient Software Experience:

Microsoft Word, Excel, Access and PowerPoint,

WordPerfect, Oracle, Lawson, Dynamics, Quicken, Essbase, Hyperion, SAP, Oracle and Business Objects

EDUCATION

B.S., B.A., Accounting (emphasis in Financial Accounting), Metropolitan State College, Denver

Metropolitan State College, Denver, Colorado

Contact this candidate