We provide IT Staff Augmentation Services!

Senior Consultant And Architect Resume

SUMMARY:

  • SAP BPC expert with 18 years of OLAP multi - dimensional expertise across multiple industries and functional areas including financial consolidations (including inter-company eliminations, foreign currency translation and legal consolidation), budgeting, planning, forecasting as well as performance and analysis reporting
  • Financial 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 BPC solutions on time and on budget with complete customer satisfaction. Constantly focused on delivering manageable value added EPM solutions by utilizing my Financial combined with my OLAP multi-dimension background.
  • SAP BPC Pre-Sales expert in product demos, supporting sales, requirements gathering, business process reviews.

TECHNICAL SKILLS:

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

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), BPC Script Logic, Basic SQL Scripting, Essbase Calculation Script

EXPERIENCE/PROJECT WORK:

Confidential

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

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 BPC 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

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, CapEx 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.
  • CAPEX 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 leve l 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

Project Manager and Architect

Responsibilities:

  • Implemented SAP BPC 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 BPC 7.5. Techniques included partitioned EvDre’s, multiple axis sharing, insert filtering, block expansions as well as integrated VBA functionality.

Confidential

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 BPC 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

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

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 BPC 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

Senior Consultant and Architect

Responsibilities:

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

Confidential

Senior Consultant and Architect

Responsibilities:

  • Implementation of SAP BPC 4.3
  • Designed Forecasting solution at a summary account level.
  • Developed Input templates to accommodate summary forecasting using detail data utilizing properties and VBA functionality.
  • Developed flexible variance reports utilizing EvDRE functionality

Confidential

Project Manager and Architect

Responsibilities:

  • Upgraded SAP BPC from 5.0 to 7.5 MS
  • Provided functional support and testing for migration from version 5.0 to 7.5 in development and production environments.
  • Functional support included updating all dimensions, applications and security profiles for version 7.5.
  • Testing included Report and Input templates as well as the Monthly close process which included Data loads, Journal Templates, and Intercompany elimination logic.
  • Reviewed and optimized reports, input schedules and hierarchy structures.

Confidential

Senior Consultant and Architect

Responsibilities:

  • Implementation of SAP BPC 7.5 NW
  • Designed a full Budgeting, Planning, Forecasting and Management Reporting solution including HCM, CapEx, Capital Project Spend and detail GL Account planning by Center
  • Provided training to client development team. Facilitated design/development sessions with client team.
  • Redesigned the Budgeting and Forecasting processes to maximize multi-dimensional functionality.
  • Developed SAP BPC script logic:
  • HCM headcount transfers between Centers
  • Data transfer between applications
  • 5-year expense forecasting
  • Allocations across lines of business
  • Product profitability allocations
  • Developed input templates to accommodate complex data modelling requirements. Wrote VBA integration to multiple EvDREs.
  • Development multi-use management reporting templates.
  • Implemented work status functionality

Confidential

Senior Consultant and Architect

Responsibilities:

  • Upgrade to 7.5 SQL 2008
  • Redesigned and enhanced performance of IT Project reporting and budgeting application.
  • Enhanced all hierarchies to increase retrieval performance (report and input template performance improved by 70%
  • Redesigned all reports and input templates to utilize EvDRE functionality.
  • Updated all dimension logic and script logic to enhance performance

Confidential

Senior Consultant

Responsibilities:

  • Implementation of SAP BPC 7.0
  • Provided management consulting to define user requirements.
  • Designed comprehensive Management Reporting, Budgeting and Forecasting solution planning by Accounting Center. Consolidations part of the Application included intercompany eliminations and foreign currency translation.
  • Provided training to client development team. Facilitated design/development sessions with client team.
  • Developed fully functional flexible input templates using SAP BPC EvDRE functionality.
  • Development multi-use management reporting templates.

Confidential

Senior Consultant and Architect

Responsibilities:

  • Implementation of SAP BPC 5.0
  • Resigned budget input and report templates, for performance enhancement, utilized by 1300 retail stores
  • Created the design used to implement the final Corporate budgeting and reporting phase of the project
  • Provided training to client development team. Facilitated design/development sessions with client team.

Confidential

Principle Consultant

Responsibilities:

  • Implementation of SAP BPC 5.0
  • Designed a full Budgeting, Forecasting and Management Reporting solution detail GL Account planning by Center
  • Provided training to client development team. Facilitated design/development sessions with client team.
  • Developed SAP BPC script logic:
  • Data transfer between interfaces (applications)
  • Developed Unit x Rate calculations
  • Developed input and report templates to accommodate complex data filtering requirements.
  • Utilized BPF and work status functionality to guide the user through the budgeting and forecasting processes

Hire Now