Member of multiple projects to provide EPM solutions to a variety of clients; supervised the creation of budgeting/forecast models to analyze operational trends in support of efforts to evaluate performance, metrics, and other operational standards. Continuing focus to drive technology integration and improvements with establishment of effective business systems processes. Lead administration for BPC Cloud Administration Team

Applied expert knowledge of financial planning, mastery of designing & implementing models, and leadership skills to develop dynamic planning environments. Oversaw areas including long-range budgeting & forecasting for revenue, expenses, capital expenditures and headcount while supporting variance analysis techniques. Conducted ongoing quality assurance to ensure accuracy and consistency of data in support of internal and external clients.Developed Access DB Employee model to capture employee start dates, salary, incentive compensation % and fully loaded costs. Model tracks of current employees, new hires (either newly approved new hires or replacements) and provides for terminations. Tracks job position from approval thru recruiting process to hiring. This allows management a fully burdened cost for both annualized and prorated expenses. Model assists in calculation of replacement savings.Implemented headcount managing environment in BPC 7.0 (formerly Outlooksoft (OLAP)) as part of a company wide implementation to improve Business Intelligence for Senior Management.Developed Access db Consolidation Model. Model consolidated over 100 excel templates which contained detailed line items. Model used Employee db above to spread employee costs by month requiring no management intervention. All employee related costs driven by automated process. Developed Access model to facilitate sending stock option transaction information to option holders and automated the sending of personalized emails with detailed stock option grant informationEXCEL: adept in building dynamic excel models for budgeting/forecasting, revenue and expense reporting, commission modeling and headcount tracking. ACCESS: Experience in developing Access models to consolidate excel files, text files and connection queries to other data sources to provide backbone for detailed reporting. VBA: Resourceful user of VBA to automate repetitive tasks

Modeler: Developed an Access and Excel model for commission calculations for sales team. This model was used to validate the current implementation of the commission software. Worked with a SQL programmer to bring sales results into Access, where relationships were built to define commissionable revenue for each sales representative. Also built an excel process to produce Commission Contracts for each member of the sales team including plan details

Created TM1 model for cost of sales analysis which resulted in increasing GM by 6% . Worked with revenue and accounting teams to build model to identify Sales Tax Exposure for newly acquired company. Supported Finance team during new ERP conversion by providing excel and access expertise to convert previous systems data into the Oracle format.

3000-5000 employees, ADSK; Computer Software Industry; Financial Modeler for Asia Pacific region. Managed Consolidation process for Asia Pacific Region. Developed models to consolidate P&L and revenue by country. Introduced TM1 OLAP model to Autodesk and received Grand Tiger Award for excellence for initiating this "best practice" environment. APAC liaison/coordinator for implementing Hyperion Enterprise and Pillar.