Manager Financial Analyst
Resume:
John P. Burns, CPA Telephone: 410-***-****
E-mail: *******.***@*****.***
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