Michael Mcknew Email and Phone Number

• Hyperion Essbase query writing and reporting. • Advanced Excel skills and techniques – Lookups, pivot tables, slicers, nested formulas, charts & graphs. • Advanced Oracle DB queries, development of forecast vs actual reporting tools.• Extensive, accurate periodic reporting meeting fast paced, time sensitive requirements.• Variance analysis and historical research techniques and tools.• Periodic financial and P&L statement reporting, numerous ad-hoc reports and analysis.

• Revenue and cost, sales analysis for investment properties management.• Access and download electronic monthly reports, Cost tracking and analysis tools.• Provide detailed and summary tax preparation backup documentation.

• Support executive, production and administrative management teams.• Advanced MS Excel skills to produce complex daily reports, quarterly P&L, BS and Cash-Flow Statements, numerous projects and ad-hoc reports. • Month end closing journal entries and other closing duties, extensive periodic reporting, account reconciliations, research and analysis.• Treasury functions, daily cash flow, ACH/EFT/bank statement recon. State taxes. • Capital asset budgets, reporting and coordination. • Managed 80 operational and maintenance contracts. • Produced reporting procedures using MS Visio and Project. Trained reporting staff.

• Support the Division Controller with the annual budget preparation and monthly monitoring of critical operational performance indicators.• Month end closing JEs and variance analysis as required.• GL account reconciliations, account receivable functions, fixed asset inventory tracking. • Managed Citibank card program. Position consolidated to Johnstown, PA 06/2005