Projects and Experience
Systems - Management & Financial
Managed team of internal employees and external consultants in successful implementations of Hyperion Planning.
Rebuilt Hyperion-based system from ground up to provide single source access to companywide financials as well as logical modeling for forecasting, with a level of detail supporting in depth real time financial analysis of the company and products.
Worked with all departments to improve structure of the system for usability and functionality.
Developed green-light model in Hyperion with an Excel front-end for finance and marketing to run various scenarios of individual products. Integrated outputs into a long term plan.
Designed a highly customized Excel-based “Dynamic Query Tool” to give executives access to a large number of standardized reports with adjustable and relevant criteria. Essbase is used as the back-end to provide constantly updating financial information.
Built sales performance tools, giving real time access to inventory, sales, and other key metrics, and providing an integrated system for Sales Representatives to input sales forecasts. Integrated with the demand planning system.
Created working prototypes for customized reporting systems using financial data from Microsoft Dynamics NAV and royalties information from Media Maestro, and worked with IT organization to complete production roll-out.
Constructed a “Digital Sales" database to provide a reporting and analysis tool for product downloadable content, micro-transactions, and full game sales. Built logic and automation necessary for creating an easy to understand, structured, and customized database from multiple constantly updating external data sources.
Created multiple intranet sites for financial systems staff and system end users, documenting detailed systems maintenance and update procedures, in-depth forecasting and calculation methodologies, training documents, and “how-to” guides.
Implemented disaster recovery system, and created a suite of tools for reviewing the system for errors and data problems.
Finance - Corporate & Strategic - Financial Planning & Analysis
Prepared long term business plans and successfully obtained offer to purchase assets of the company.
Developed and operated an “on-the-fly” financial model based on the business plan with 3 statement projections for multiple years. Model built to provide flexibility for adjustments to see the impact of various scenarios, such as shifting release dates of products, changing number of unit sales anticipated, etc.
Used product focused green-light models to build consolidated worldwide projections for multiple years.
Designed model to forecast the impact to overall company financials of entering distribution deals with varying terms.
Defined required forecasting structure and schedule for divisional finance organizations. Consolidated, reviewed, and analyzed quarterly companywide forecasts for the full fiscal year.
Provided forecast and actual financial information in preparation for public company quarterly earnings calls and Board of Director’s meetings.
Worked with various business groups and management for the development and evaluation of business cases and Cost Benefit Analyses for large projects.