**** ******* ****

Catonsville, MD *****-****

John P. Burns, CPA Telephone: 410-***-****

E-mail: abgucd@r.postjobfree.com

Summary:

Versatile financial professional with excellent analytical and systems

skills; Within the engineering, insurance and financial services

industries, have performed monthly closings, account reconciliations;

revenue validation, Work-in-Process (WIP) analyses, Profit & Loss statement

preparation, financial analyses, budget development; and external audit

support; Advanced skills in MS Excel, MS Access; Hyperion, Structured Query

Language (SQL) and Oracle Financials; Have played key rolls in system

implementations and maintenance with extensive interaction with staff,

Information Technology (IT) and Accounting and Management

Professional Experience:

KCI Technologies Inc., Sparks, MD 2004 to Present

Senior Financial Analyst/Systems Accountant

Responsible for the Oracle Financials Projects module at an engineering

firm with over $100 million in annual sales and over 800 staff, to ensure

that project revenue, and Work-In-Process (WIP) balances in the General

Ledger are accurate and posted on schedule:

. Created a "Weekly Unbilled Receivables (WIP) Analysis", using Oracle

Discoverer and MS Excel to monitor unbilled revenue (fee for services

rendered), identify exceptions related to costing and revenue

recognition, and respond to ad-hoc information requests.

. Authored the Project Accountants' Manual to document the Oracle Projects

procedures necessary to invoice KCI Technologies' engineering services.

. Implemented a training program for new project accountants to provide an

introduction to KCI Technologies financial reporting and invoicing

procedures.

. Delivered presentations utilizing MS PowerPoint to executive and

professional engineering staff to explain the key role of Oracle

Projects in KCI Technologies' financial reporting environment.

Responsible for the Oracle Financials Projects monthly systems close,

general ledger account analyses, ad hoc financial analysis of revenues,

expenses, staff chargeability metrics, and budget development:

. Designed a monthly close preparation protocol to ensure that all costs,

revenues and WIP balances are correctly posted to the General ledger

during the monthly system close.

. Developed a process to import and parse on-line accounting reports into

MS Excel so that the data could be summarized into pivot tables to

perform general ledger account reconciliation more efficiently.

. Streamlined the corporate budget files to facilitate revisions to

organizational structure, to update actual financial results posted in

the files and reconcile corporate overhead allocations.

. Automated the upload process for the approved annual budget to the

Oracle General Ledger, eliminating several days of manual entry and data

verification by the Corporate Finance staff.

John P. Burns, CPA

Page 2 of 3

St. Paul Insurance, Baltimore, MD 2003 to 2004

Senior Financial Analyst

Financial reporting, budget analysis and business planning for the Surety

and Ocean Marine business units:

. Enhanced the monthly Management Report to automatically update from

Hyperion.

Allfirst Bank, Baltimore, MD 2000 to 2003

Senior Financial Analyst

Cost reporting and financial analysis for a large regional retail bank:

. Played key role in system conversion to Oracle Financials as a member of

the Profitability Implementation Team:

( Conversion of cost allocation rules ( SQL Queries

( Testing and verification ( Oracle Discoverer Report

Writer

. Assisted the streamlining of workflows through an analysis of time

expended on key business activities in the Capital Markets Group, using

MS Access and MS Excel to convert text-file information from web-based

surveys.

CitiFinancial, Baltimore, MD 1999 to 2000

Senior Financial Analyst

Monthly, managerial financial reporting via Hyperion Enterprise and

Hyperion Retrieve

Zurich Insurance, Baltimore, MD 1979 to 1999

Internal Reporting Manager 1994 - 1999

Drove Profit and Loss (P&L) reporting for the Commercial and Construction

business units:

. Developed a system to generate P&L's via SQL queries, downloads and

spreadsheets.

. Wrote SQL queries to populate cost tables, eliminating a significant

amount of data entry.

. Received multiple service awards for the quality of support to the

business unit financial staffs under stringent deadlines.

Senior Financial Analyst 1989 - 1994

Monitored key insurance metrics including earned premiums, losses/loss

adjustment expenses and reinsurance; performed ad-hoc financial analyses;

annual forecasting; budget development and budget variance analyses.

Treasury Services Manager 1989

Agency Automation Supervisor 1985 - 1989

Responsible for the company's participation in Insurance Value Added

Network Services.

Senior Information Systems Auditor 1983 - 1985

Operating system audits, application control reviews, and data center

reviews.

Computer Programmer 1981 - 1983

Commercial Casualty Underwriter 1979 - 1981

John P. Burns, CPA

Page 3 of 3

Professional Certifications and Affiliations:

. Certified Public Accountant (currently inactive)

. Maryland Association of Certified Public Accountants

Technical Skills:

. Oracle Financials including Projects, General Ledger and Discoverer

. Hyperion Enterprise, Hyperion Retrieve

. SQL

. Microsoft: Windows, Excel, Access, PowerPoint and Word

Education:

. Bachelor of Arts in History, Cum Laude, Towson University, Towson, MD

. Community College of Baltimore County, Catonsville: 30 hours of

accounting classes and six hours of business law to qualify to sit for

the Maryland Certified Public Accountant examination

Contact this candidate