Manager Financial
Resume:
DAVID KASTEL
Stamford, CT 06905
*******@*********.***
EDUCATION:
UNIVERSITY OF MEMPHIS May 2000
MBA Program - Finance
POLYTECHNIC UNIVERSITY January 1993
Bachelor of Science Aerospace Engineering
EXPERIENCE:
AFFINION GROUP, Stamford, CT April 2007 - Present
Sr. Manager: Revenue Forecasting, Financial Planning and Analysis
Responsible for revenue and commission forecasting
Including cash, GAAP and balance sheet accounts
Development and automation of standard monthly reporting on key performance
Metrics such as billing success rates and member attrition rates
Produce effective analytical documents to provide management with tools to
measure company performance
Present results and variance analysis in monthly forecast review meetings
Built complex models for sensitivity analysis to support future business
decisions
Work cross functionally with accounting, marketing and business statistics
groups
Continue development of Hyperion tool by working closely with Director of
Financial Systems
Audit calculation script for corrections and improvements
Create forecast driver files through segmentation and consolidation of
large datasets
Management of two financial analysts
Including oversight responsibility of active member forecast
Complete various ad-hoc projects to assess financial impacts of changes in
deal structures, accounting policies and regulatory environment
Financial representative on weekly billing operations meeting
Develop and present training materials for rollout of Hyperion forecast
tool to other groups
MX ENERGY, INC, Stamford, CT
May 2006 - April 2007
Senior Financial Analyst: Financial Planning and Analysis
Developed corporate operating expense budget
Discounted cash flow analysis for merger and acquisition opportunities
Prepared financial information for Note offer memorandum and SEC filings
Participated on the teams which revised and audited these documents
Provided financial support to auditors for year-end financial audit, with
particular regard for commodity derivative valuations
Completed various ad-hoc projects of financial analysis and presented
results
CITIZENS COMMUNICATIONS, Stamford, CT July 2004 - May 2006
Senior Business Analyst: Central Region
Performed annual budgeting and capital expense profitability analysis
Analyzed P&L variance after month end close
Presented results of analysis to management
Provided financial assistance on marketing business cases and capital
expenditures
1
ATLAS AIR, INC, Purchase, NY October 2000 - May 2004
Manager: Financial Planning and Analysis
Responsible for forecast of P&L and annual budgeting
Developed database for consolidation of entire company's annual budget
Built table structure as well as all queries, macros, forms and reports
Database used by FP&A and divisional controllers for budget development
reporting as well as to report company budgets ranging from low level
departmental budgets to high level corporate budgets
Created process to integrate accounting actual results from SAP into
database for use in monthly variance reporting
Provided daily report of actual flight hour volume and forecasted end of
month flight hour volume for senior management and marketing teams
Coordinated flight hour demand forecast with aircraft availability forecast
to project short term sales volume and revenue forecast
Cash flow and cost-benefit analysis for corporate cost saving initiatives
Manager: Budgets and Cost Analysis, Technical Operations Division
Managed monthly accounting close and budget development for Aircraft
Maintenance Division
Performed cost-benefit analysis for aircraft maintenance schedule
Optimized total cost of maintenance considering station maintenance cost,
aircraft and personnel transportation costs, and cost of aircraft down time
Provided financial support for renegotiation of aircraft engine maintenance
contracts
Participated on cross functional team developing system requirements for
SAP Fi/Co module
Assisted in migration of accounting system from SAP to JD Edwards
Provided financial support for Chapter 11 bankruptcy filing
2 FEDERAL EXPRESS, Memphis, TN May 1996 -
February 2000
Sr. Operations Engineer, Sr. Financial Analyst: Financial Planning and
Analysis
Conducted payload/range studies for proposed aircraft acquisitions
Performed cost-benefit analysis for capital expenditure requests including,
new trucks, wireless scanning equipment and divisional incentive program
Developed AGFS annual budget and monthly variance analysis and reporting
Automated monthly revision process for airplane performance computers
COMPUTER SKILLS:
Excel (Advanced), Access, Word, PowerPoint, Hyperion, SAP, JD Edwards
Computer programming languages include VBA, C++, Fortran, Unix
[pic][pic][pic][pic][pic][pic]
Contact this candidate