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 $350M.Developed complex Excel workbooks to analyze multiple vendor ‘responses for proposal’; prioritize accretive transactions and support efforts in negotiating company-wide arrangements.Performed programming reconciliation for contracts entered into through NCTC. Evaluated capital and expense projects through financial studies, research and budget affects.Performed financial analysis and research as needed for VP of Business Development.

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 targets.Managed advanced financial reporting and performance reviews for stakeholders in the supported departments.Reviewed and approved Purchase Orders to ensure compliance with corporate directives.Interacted with corporate accounting and finance to ensure monthly close and forecasts were accurate, timely and in compliance with internal directives.

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 for the contract portion of the due diligence process related to the sale of Adelphia assets.Prepared exhibits to Plan Supplement and Cure Notice filings for over 45,000 contracts.Coordinated project to research information needed for potential 1099 filings for over 16,000 claims/schedules.Acted as liaison to outside bankruptcy counsel on contract related issues; prepared exhibits used in preparation of court orders and provided ad hoc information to aid in adjudication of contract related matters; compiled information from outside counsel to internally track settlements and other court documents.Collaborated regularly with claims reconciliation arm of the team to resolve contract issues linked to filed claims and prepared exhibits to claim settlement agreements.

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 senior leadership team and provided variance explanations.Tracked and reported project costs related to network integration of Budget Rent-a-Car into the Cendant network, including verifying proper accounting of capital and expense items related to the project; processing capital lease payments; producing monthly capital and expense forecasts.Assisted in special projects to reconcile business unit circuit cost billing to contract pricing.

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 reductions; consulted with individual leadership team members and made recommendations on attainable expense cutbacks.Collaborated with corporate accounting and corporate finance to manage monthly and year-end accruals; established reserves on specific legal matters; resolved legal settlement issues; and provided detailed reports on particular legal matters.Primary financial contact for legal leadership team, department employees, corporate finance and corporate accounting to resolve issues on variance explanations, accounts payable and miscellaneous financial issues.Managed the consolidation of MediaOne and TCI L&GA budgets to form AT&T Broadband L&GA. Established key contacts in both organizations; built bottoms-up baseline budget for 2000; negotiated transfer of budget amounts and headcount. Initial 2001 budget before cost reductions totaled $117.2M and included 234 employees. Final budget totaled $105.3M and included 204 headcount. Supervised one contract employee.Coordinated the automation of 3 formerly manual processes, resulting in time and cost savings: 1) reconciliation of internal outside counsel invoice tracking system to corporate Oracle accounts payable 2) preparation and production of the monthly financial reports 3) account coding for invoices with multiple business unit responsibility.

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 reporting.Maintained budget adjustment database used by senior management for bonus planning. Maintained normalization spreadsheet used to make logical comparisons for the calculation of growth rates, year over year comparisons and variance explanations. Performed financial analysis using Retrieve Hyperion applications.

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 value.Prepared tax based financial statements, multi step cash payments and maintained IRS compliance of foreign status for Foreign Service Corporations.Provided consolidated cash flow analysis and financial reporting to senior management. Coordinated with corporate legal department to prepare corporate resolutions relating to asset dispositions and changes in officers and directors of various corporations.Performed accounting, variance analysis and reconciliation of Loan Portfolio payments and balances.Recorded payments of accounts receivable and balanced daily cash receipts.Reconciled various balance sheet accounts and made necessary adjusting journal entries.Held Staff Accountant position prior to being promoted to Accounting Manager.

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, incremental shares, stock option activity, earnings per share and stock award program.Reconciled general ledger accounts related to lease originations, leases after original expiration, accounts receivable, residual reserves, equipment payables and prepared audit work papers.Prepared monthly compliance and net book value reports.Based on work performance, given additional responsibilities and promoted to this postion.