Post Job Free
Sign in

Manager Oracle

Location:
Denver, CO, 80218
Posted:
August 31, 2010

Contact this candidate

Resume:

CATE MACADAM

*** ******** ******, ***. *** ~ Denver, Colorado 80218

720-***-**** ************@*******.***

ACCOUNTING & ACCOUNTING SYSTEMS

Industries: Oil & Gas, Manufacturing, Consulting

Multi-faceted, detail-oriented finance professional with over 20 years

experience delivering solutions and savings through expert management of

financial systems and accounting processes for a broad range of

companies. Results achieved through development of innovative procedures

and reporting processes that locate discrepancies, automate key

functions, and streamline activities. Provide firsthand support to

finance managers and executives, with a reputation for consistently

developing solutions and policies that ensure the accuracy and success of

fiscal operations.

PROFESSIONAL EXPERIENCE

DESTINATION HOTELS AND RESORTS (for Technisource, Inc.), Englewood,

Colorado ~ 2006-Present

Consultant - Report Writer

Create operating statement reports and documentation for processes

associated with development of a custom reporting tool designed for the

Oracle environment. Conduct monitoring and testing for all changes and

upgrades.

. Ensured success of new system through careful monitoring and

documentation of all processes and validation of its effectiveness for

organizing operating, budget, and forecast reports and statements.

. Recognized by company for important contributions - grew assignment

originally contracted for 3-months into longer and more integral role.

KNOWLEDGE LEARNING CORP (for Resource Global Professionals), Portland,

Oregon ~ 2005-2006

Consultant - Oracle/Hyperion

Reviewed/documented existing chart of accounts and cross-validation rules

for Oracle system, and recommended process changes to optimize efficiency

and effectiveness of personnel and systems. Created new consolidated

financial reports in Oracle FSG, and utilized Oracle Trial Balance to

validate results. Developed multiple queries for monthly, quarterly, and

yearly audits, as well as for variance and cash flow for users and

management.

. Provided vital support and training to Revenue Manager on methods for

balancing systems.

PRECISION CASTPARTS CORP, Portland, Oregon ~ 1997-2004

Manager - Corporate Financial Systems

Managed and validated monthly data from all external sources, coordinating

information for 8 divisions, 134 operating units and corporate office to

Oracle 11i. Oversaw corporate systems and reporting, as well as

implementation of improvements to enhance processes. Prepared consolidated

balance sheets and income statements for SEC filings, and provided results

for use in analysis and board reports.

. Slashed close cycle time by 60%, from 10 days to 4, through strategic

reengineering and automation of the financial statement process.

. Maximized accuracy and precision of reporting by redesigning the

accounting process to use a consolidated chart of accounts.

. Created and documented an internal system that alerted to potential

reporting issues; designed and documented corporate policy for

international reporting to U.S. GAAP.

. Provided CEO with personally compiled worldwide accounts payable database

for vendors, which enabled better-informed negotiations and delivered

significant cost savings.

Cate Macadam

Page Two

PROFESSIONAL EXPERIENCE CONTINUED

DAT SERVICES, Beaverton, Oregon ~ 1994-1997

Staff Accountant

Reconciled and resolved discrepancies in A/R accounts, reporting to

Controller. Directed setup, testing, and training on Oracle applications

and SMS Teletrak revenue system. Established and documented month-end close

procedures and reporting, and implemented procedures and policies for

financial activities and practices.

. Achieved 95% success rate for bringing past due accounts to a 30-60

balance through development of a more efficient system to identify and

track delinquent customers.

. Optimized efficiency through strategic automation of A/R processes by

preparing a cost-benefit analysis for automating the management of 3K-5K

checks daily. New process paid for itself in 4 months and virtually

eliminated discrepancies.

NERCO OIL & GAS, Portland, Oregon ~ 1991-1993

Offshore Revenue Supervisor

Ensured optimum accuracy and efficiency through development of key

departmental policies and procedures, including a monthly variance analysis

to compare MCF/BBLs sold to MCF/BBLs paid. Controlled the accounting for

special marketing arrangements involving purchase and resale gas. Audit

lead for revenue department, reviewed, documented and presented results as

needed.

. Project lead for Oracle Systems - Oil & Gas package development.

Documented, tested and managed setup of Oracle GL, AR, AFE, Land, JIB and

Revenue systems. Validated converted data, documented processes for end

users, and served as primary contact for issue resolution.

. Located, explained and recovered $500k (acquired) overpayment from

working interest partners.

UMC PETROLEUM CORP, Houston, Texas ~ 1984-1991

Revenue Manager

Developed and implemented a multi-level, interdepartmental information

system to compare Land data with JIB and Revenue data, Production and

Contracts to Actuals, Actuals to Accruals, and to prepare Property Income

Statements on the AS400 and Artesia system. Documented, tested and managed

the setup of Artesia revenue systems. Developed and tested accounting for

acquired Gas Gathering System. Prepared market hedges, accruals, Federal -

State - Local royalties and taxes.

. From the shared information, we discovered $1.2M in unreported

receivables and exposed underpayments with many Koch contracts (Koch

admitted to this improper activity in the late 1990s).

. Artesia did not offer the shared information system that UMC developed

for the AS400. They worked with our staff to add this program to Artesia

and included it as part of their package. UMC received a flat payment

plus royalties for this enhancement to the Artesia package.

. Located an acquired $300k underpayment to the State of Louisiana (post-

due diligence). Recommended an honest presentation to the State that

resulted in the waiving of all penalties and interest against UMC.

. Spot Market activity caused underpayment concerns for a number of our

prominent landowners. I gathered the appropriate documents, prepared

simple worksheets and reported these results to each concerned landowner.

Within six months, each landowner was either auditing their own payments

or had concluded that they were being properly paid.

EDUCATION

Undergraduate Studies - Temple Buell College, Denver Colorado



Contact this candidate