Financial Analyst/Director Of Finance
Kmsp Tv/Wftc Tv/Fox Sports Net North
Performed and supervised accounting activities of up to six team members, including Journal Entries, General Ledger, Account Reconciliations, Accounts Payable, Billing, Accounts Receivable, Payroll, Budgeting, Fixed Assets System and Film Inventory System. Used JDE, Hyperion, Upstream and Excel for accounting, reporting and analysis activities. Financial reporting and analysis activities included:• Various weekly, monthly and quarterly revenue analysis reports• Monthly Cash Flow, P&L, Consolidation, Forecast and Budget Variance Reports• Quarterly SEC Footnote Package• Quarterly Analytical Package• Annual Tax Package• Program Acquisition Profitability Studies• Reports for Auditors• Sarbanes-Oxley Compliance Reporting Achievements included:o Quickly learned Upstream and Hyperion Financial Management software. Trained and assisted local users when we submitted financial reports to parent company for SEC reporting.o Implemented automation of financial reporting, forecasting and budgeting through the use of JDE downloads, customized database queries and linked spreadsheet files, which improved efficiency by eliminating duplicate data entry efforts.o Converted film inventory and accounts receivable systems to Enterprise system, established procedures and forms for maintaining data, wrote detailed instruction manual and trained several employees in the procedures.o Trained staff of acquired companies in Fox accounting policies, finance systems and procedures.o Analyzed and reconciled opening balance sheet items to ensure correct valuation and classification of purchased entity.