Lea Horner Email & Phone Number

Greenwood Village, Colorado, United States

Greenwood Village, CO

Reconcile information related to programming contracts under negotiation and prepare contract exhibits for Retransmission Consent Agreements.Analyze budget to actual variances.Prepared financial analysis for Strategic Procurement to calculate total spend, year over year and actual to budget savings for key vendors with anticipated total spend of over.

Denver, CO

Contractor at United States Securities and Exchange Commission

Provided operations support to the Call Center, Customer Retention and Web Marketing teams, including forecasting and budgeting, ad-hoc reporting and forecast to actual variance analysis using Oracle and Hyperion.Coordinated with the Customer Care and Web Marketing Organization leaders to set the annual budget in accordance with the company’s financial.

Audit over 100,000 post-acquisition contracts for data consistency; input pertinent information into imaging system.Review pre-acquisition contracts for essential information and ensure data accuracy and integrity.

Audited and extracted critical data from over 60,000 pre and post bankruptcy petition contracts (linked to 200+ legal entities); interacted monthly with corporate accounting to produce accrual report for rejected contracts.Reconciled contracts against information provided by creditors to resolve discrepancies in contract information; compiled information.

Compiled and distributed monthly forecast of wide area network circuit data costs to 26 business units with an annual budget of approximately $55M.Developed and maintained integrated modeling spreadsheets to track detailed actual and forecast costs; year-to-date and full year variances by business unit.Produced consolidated monthly management report for.

Coordinated budget process; reviewed and analyzed monthly financial results against proposed budget; and prepared monthly reporting packages for 22 Law & Government Affairs (L&GA) groups with a total 2002 budget of $67M and 196 headcount. Supervised one contract employee during 2002 budget submission.Managed multiple requests for compulsory budget.

Produced monthly management reports for senior management, including compilation of subsidiary financial reports and the validation of revenue and cost information to ensure data integrity.Performed monthly cash flow analysis for corporate and all subsidiaries. Reconciled management report cash flow, EBITDA, revenue and year-over-year growth to external.

Analyzed financial information to forecast EBITDA, net income and after-tax cash flow to produce, consolidate and submit to corporate headquarters the budget and quarterly long range plan models using Retrieve Hyperion.Performed accounting, compliance, cash tracking and management reporting for Leverage Lease portfolio totaling over $600M in net book.

Supervised staff of two general ledger accountants, including review and approval of reconciliations and journal entries; supervised internal audit project.Prepared and verified accuracy of consolidated financial statements, including preparation of flash financial statements for senior management.Prepared schedules of weighted average shares outstanding.