Manager Financial Analyst

THOMAS J. HORN, MBA

*** ******** ****** * ******** Meeting, PA 19462 n 484-***-**** n Email: ab8w1e@r.postjobfree.com

PROFESSIONAL EXPERIENCE

AmeriGas LLP King of Prussia, PA 2009 2012

Manager, Financial Analysis

Support 24 propane production centers with reviewing KPIs to achieve operational efficiency.

Facilitate the annual budget process for the production centers totaling $25MM and provide monthly

budget analysis against plan.

Manage revenue recognition and reconciliation for $90MM of company owned inventory at customer

locations.

Develop metrics and analysis around the propane cylinder inventory, which includes perpetual

inventory, region and market variances and volume to budget comparisons.

Developed internal and external inventory policies and procedures to manage the cylinder inventory

and reduce shrinkage with annual savings of $1.1MM.

Perform routine audits of the production centers and district retail locations to ensure compliance with

policies and variance tolerance guidelines.

SunGard Availability Services Wayne, PA 2003 2009

Manager, Financial Analysis [2006 2009]

Responsible for facilitating annual capital and expense budget of $185M for $1.5B IT services

business.

Support executive management team through review of business KPIs, and budget management of

400+ employee IT managed services line of business.

Perform profitability analysis of IT managed service facilities and review structure of existing and new

customer contracts to ensure margin targets.

Manage and mentor team of seven financial analysts to review, audit and reconcile over $100M of

annual telecommunications expense.

Drove savings of over $11M in 2007 through telecommunications expense audits and carrier contract

negotiations.

Developed metrics and analysis around the telecommunications spend, which includes installations,

decommissions and a full monthly financial transaction dashboard.

Maintain telecommunications vendor relationship through quarterly stewardship meetings and review

performance based on company objectives.

Financial Analyst Supervisor [2003 2006]

Manage the process of inventorying, auditing and corporate governance for SunGard’s circuit ordering.

Develop single repository for managing circuit inventory for analyzing network costs and optimization.

Drove savings of over $7M in 2006 through telecommunications expense audits 2006.

Responsible for facilitating annual capital and expense budget of $90M for $1.5B services business.

Manage all SGS vendor contract and analysis.

General Fiber Communications Conshohocken, PA 2003

Senior Financial Analyst

Provide financial analysis support for the North East and South cable audit and installation facilities.

Facilitate the monthly revenue and expense forecasts based on field reported activity.

Assisted the controller in the month end close process and reporting division results to corporate.

The Vanguard Group Valley Forge, PA 2000 2003

Senior Financial Analyst [2001 2003]

Assisted with the planning process for Direct Investor Services division information technology

projects.

Act as liaison with the divisional business technology managers and the technology system integration

teams for project scheduling and resources.

Prepared monthly actual versus budget reports for the business technology managers to assist with

managing their information technology projects.

Produced project budget reports and analysis for senior management during the annual budget

process.

Financial Analyst [2000 2001]

Responsible for facilitating the budget process for the Technology Planning and Integration Group ($14

million annual budget).

Act as liaison with Corporate Planning and Analysis for budget preparation and variance explanation.

Develop forecast models for volume and staffing needs of department.

Implement project tracking database to measure productivity, volume and quality trends.

Create and distribute financial reports from database and budget applications.

Cingular Wireless Wayne, PA 1998 2000

(formerly Comcast Cellular Communications)

Financial Analyst [2000]

Prepare monthly analysis of roaming revenue for all Philadelphia markets using databases.

Assist in the forecast of roaming revenue throughout the month.

Develop and implement automated processes for use in the monthly close and forecasts.

Assist in the design, implementation and documentation of internal controls and procedures.

Prepare monthly journal entries for roaming revenue.

Prepare account analysis of roamer revenues and receivables for the net settlement process between

cellular carriers.

Fixed Asset Accountant [1999 2000]

Assisted in the conversion of the fixed asset system from PeopleSoft to Oracle Asset Management.

Develop, implement and document purchasing and capitalization procedures for capital equipment.

Responsible for monthly closing of nine operating companies.

Prepare consolidated rollforward schedules reporting capital expenditures on a monthly, quarterly and

YTD basis against budget.

Prepare account and variance analysis of depreciation.

Staff Accountant [1998 1999]

Responsible for monthly closing of three holding companies.

Prepare account analysis, quarterly rollforward schedules and variance analysis.

Prepare consolidated financial statements in accordance with Generally Accepted Accounting

Principles.

Assist with reporting capital expenditures and necessary schedules required for SEC 10 K reports.

ARAMARK Corporation Philadelphia, PA 1996 1998

Staff Accountant – Healthcare Support

Staff accountant solely responsible for Midwest and Southwest Regions of Healthcare Support

Services Division (142 client facilities), with annual budgets of over $95 million.

Verify and reconcile general ledger accounts, generate monthly reports, produce monthly operating

statements.

Perform financial/operational field audits on a quarterly basis and present at district and regional

meetings as requested.

Assist facilities with accounting policies, variance analysis of month end closing, and ensuring contract

compliance between Division and client facility.

EDUCATION

Villanova University, Villanova, PA Six Sigma Green Belt Certification, 2009

Eastern University, St. Davids, PA Masters of Business Administration, 2005

Philadelphia University, Philadelphia, PA Bachelor of Science, Accounting, 1996

QUALIFICATIONS AND TECHNICAL SKILLS

Experienced finance and accounting professional with strong analytical, modeling and leadership

skills.

Computer literate with extensive knowledge of Microsoft Excel, Access, PowerPoint and Word.

Experienced with financial applications such as Oracle 11, Hyperion Financials 9, SAP, and Business

Objects 6.5 and XI.

Contact this candidate