SUMMARY:

• SAP Confidential expert with 18 years of OLAP multi - dimensional expertise across multiple industries and functional areas including Confidential consolidations (including inter-company eliminations, foreign currency translation and legal consolidation), budgeting, planning, forecasting as well as performance and analysis reporting
• Confidential expert with 6 years of comprehensive industry experience in Budgeting, Forecasting and performance analysis.
• EPM project expertise including client relations, project management, application design, development, training, documentation and knowledge transfer.
• Certified Public Account (CPA)
• Comprehensive knowledge of OLAP/multidimensional models, Enterprise Performance Management (EPM) solutions utilizing NetWeaver, Microsoft SQL Server Analysis Services, and Oracle/Hyperion Essbase
• Experienced in delivering sophisticated SAP Confidential solutions on time and on budget with complete customer satisfaction. Constantly focused on delivering manageable value added EPM solutions by utilizing my Confidential combined with my OLAP multi-dimension background.
• SAP Confidential Pre-Sales expert in product demos, supporting sales, requirements gathering, business process reviews.

TECHNICAL SKILLS:

Application Development Tools: MS Office Suite - Word, Excel, PowerPoint.

Application Package: 11 years - SAP BusinessObjects Planning and Consolidation ( Confidential )

3 years: Cognos Finance

4 years: Hyperion Essbase

Databases / DB Tools: Netweaver, HANA, Microsoft Access, Microsoft SQL Server Analysis Services, Oracle/Hyperion Essbase, SQL Server.

Operating Systems: Windows 8

Programming Languages: Visual Basic, VBA for Excel, MDX (Dimension Logic), Confidential Script Logic, Basic SQL Scripting, Essbase Calculation Script

Industries: Confidential Services, Confidential, Confidential, Medical, Confidential & Gas, Semiconductor, Confidential, Personnel/Staffing, Hospitality, Media

Functional Areas: Confidential business processes include Monthly Confidential and Management Reporting, Strategic Planning, Operational Planning & Forecasting, Rolling Forecasts, Management reporting & Analytics, and Legal Consolidations.

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Senior Consultant and Architect

Responsibilities:

• Designed and Implemented Balance Sheet and Cash Flow Forecasting. Automated Actual Cash Flow process
• Responsible for requirements gathering, design creation and overall approach.
• Automated the approach to allocate CTA to the Cash Flow statement.
• Created driver based forecasting for the Balance Sheet. All Cash Flow data flows through the model dynamically.
• Integrated VBA and EPM API calls to automate and data validate before/after refresh.
• Trained users on EPM best practices.

Confidential, New York, NY

Senior Consultant and Architect

Responsibilities:

• Converted Reports from HFM to EPM 10.1 NW
• Responsible for requirements gathering, design creation and leadership of report writing team. Created alternative approaches and final strategy to complete report conversions within a very tight timeline. The team converted 1500 report tabs from HFM to SAP Confidential and MS in house reporting tool.
• Integrated VBA to assist in repeatable conversion processes.
• Reports included Operational, SEC, SOX and IFRS reporting.
• Developed user error handling code by implementing Before Refresh functions that utilized API calls to trap unrecognized members. The design and concepts were later turned into an Excel add-in.
• Trained users on EPM best practices.

Confidential, Minneapolis, MN

Project Manager and Architect

Responsibilities:

• Implemented EPM 10.1 NW
• Responsible for all project management, requirements gathering, designing and documentation.
• Architected a multi model Budgeting and Forecasting environment including Workforce Planning, Confidential Planning, Revenue and Cost Center Planning. Architecture included requirements gathering, design document and project plan.
• Workforce Planning included multi-level merit increases, LTIP and STIP calculations, employee tax limits, local tax calculations, employee transfer, new employee, and employee termination functionality.
• Confidential calculated depreciation and tracked spend on existing and new assets and CIP.
• Cost Center and Revenue Forecasting used drivers to pre-populate all the data for the Planners. Promoted trending and spreading functionality as well as summary level data entry.
• All models performed immediate calculations and were updated when data was sent to the database. As an example when Workforce Planning data is updated Cost Center data is also updated for reporting analysis.
• Delivered 20 full function reports. These reports included Consolidation P&L and Balance Sheet reports as well as management reporting for Cost Center analysis.
• The management reporting included summary and detail reporting across models. Techniques included multiple reports sharing dimensions, integrated VBA for user error trapping, dimension overrides for report flexibility, fully integrated formatting based on hierarchy level builds and linking summary reports from one model to detailed reports in a supporting model (i.e. Summary Cost Center -> Detail Workforce).
• Integrated and driver based Balance sheet and Cash Flow forecasting.
• Script logic included (Seeding staring data, FX translation, variance allocations, moving data between models)

Confidential, Houston, TX

Project Manager and Architect

Responsibilities:

• Implemented SAP Confidential Consolidations
• Responsible for requirements gathering, design creation and project management.
• Utilized all consolidation tools including ownership model, elimination and currency conversion functionality.
• Designed reports including intercompany eliminations, Consolidated balance sheet, income statement and cash flow statements.
• Migration from 7.5 MS to EPM 10.0 NW
• Coordinating the migration of ETL, models, reports, input templates and script logic from 7.5 MS SQL Server to EPM 10.0 NW.
• Responsible for the Project Manager role on the project.
• Managing all project resources to deliver necessary application functionality.
• Updated 85 reports and input templates from EvDre and EvEXP to the EPM 10.0 report writer. Input templates include conversion of sophisticated modelling and VBA techniques used in EvDre with Confidential 7.5. Techniques included partitioned EvDre’s, multiple axis sharing, insert filtering, block expansions as well as integrated VBA functionality.

Confidential, Houston, TX

Project Manager and Architect

Responsibilities:

• Implementation 7.5 MS - HCM
• Provided management consulting for requirements gathering.
• Responsible for the Project Management role on the project
• Designed a multi approach HCM model for 18-month quarterly planning. The model accommodates a Job planning approach for the operational side of the business and an Employee planning approach for the corporate employees.
• Created complex input templates integrating Confidential with Excel and VBA functionality. The Input templates accommodated employee new hire, termination, transfer in, transfer out as well as Meta data changes (i.e. region, job etc.). All GL data was created using Unit x Rate calculations (labor, fringe, annual Incentive, long term, sign-on and severance).
• All calculations were mirrored in script logic including employee updates (new hire, term etc.) as well as GL calculations. Created script logic to push data to the main Finance application from the HCM model. Created script logic to populate a Headcount flow report used to track headcount activity by department.
• Designed security for the HCM model.
• Created several reports for headcount as well as validation reporting.

Confidential, Houston, TX

Senior Consultant and Architect

Responsibilities:

• Provided Go-Live support 7.5 MS
• Designed Security requirements including Task and User profiles.
• Designed and created extract process for two separate target systems.
• Provided Go-Live support and troubleshooting including:
• Data reconciliation issues
• Application calculation discrepancies
• FX Translation and CTA adjustment reconciliations and discrepancies
• EvDRE report training and best practices
• General Go Live user questions

Confidential, Napa, CA

Senior Consultant and Architect

Responsibilities:

• Implementation EPM 10 MS
• Designed a rolling 24 month multi model Planning and Management Reporting solution including HCM, Production Spend, Capital Project Spend and detail GL Account planning by Center/IO.
• Facilitated design/development sessions with client team.
• Developed SAP Confidential script logic:
• Unit x Rate calculations:
• Driver based model (Production Spend).
• Pricing Conditions (Finance)
• Data transfer between applications
• Allocations across lines of business
• Product profitability allocations
• FX translation
• Developed input templates to accommodate complex data modelling requirements.
• Developed flexible management reporting templates using EPM 10 report writer.

Confidential, Plano, TX

Senior Consultant and Architect

Responsibilities:

• Implemented Confidential for Finance transformation project.
• Updated all metadata, reports and input templates to match the new GL