PROFESSIONAL SUMMARY:

• Confidential has been a consultant with over 7+ years experience in efficient, dynamic, result - oriented, design & development of OLAP and decision support systems with focus on Anaplan & Oracle Hyperion Suite of Technology.

TECHNICAL SKILLS:

Skills: Anaplan Essbase Planning HFR FDM EPMA Excel SmartView

PROFESSIONAL EXPERIENCE:

Anaplan Associate

Confidential - Greater Chicago Area, IL

Responsibilities:

• Translated from model-building in Excel to multi-dimensional technologies.
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Created and implemented database designs and data models.
• Coordinated with project management staff on development timelines and project scope.
• Set up and controlled user profiles and access levels for each model segment to protect important data.
• Consistently met deadlines and requirements for all production work orders.
• Coordinated with systems partners to finalize designs and confirm requirements.
• Designed modules, reports and dashboards derived from excel based reports for P&L, OpEx, CAPEX processes

Sr. Financial Systems Consultant

Confidential - Melville, NY

Responsibilities:

• Worked with IT in terms of application and Development, QA, and Production environment support and ongoing server/environment health
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Provided Technical support for existing cubes & problem identification
• Assisted in the management of end-user relations, including needs, troubleshoot installations, administer security access, and system outages for a world - wide user community
• Documented existing system process and updates for approve process change
• Exposure to monthly load and verification of subsidiary month-end financial reporting results where appropriate
• Participated in User story creation specified to client needs
• Migrated Financial Data Quality Management Application from one environment to another

Sr. Hyperion Consultant

Confidential - Holmdel, NJ

Responsibilities:

• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Used experience in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Worked Extensively on Shared Services, Essbase applications 11.1.1.3.
• Involved in administrative activities such as setting up users, security groups and access filters to set the security policy and to ensure maximum security.
• Involved in unit test plans / system test plans, UAT plans, quality assurance test plans and test strategies

Sr. Hyperion Consultant

Confidential - Newark, CA

Responsibilities:

• Used best practices to optimize calculation and query times
• Rebuilt the dev environment, patched both prod and dev.
• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Developed process to Load Actual data into Planning to provide consolidated Actual, Forecast and Budget data to support variance reporting
• Update the member formulas, calculation scripts and business rules as per the new Teams, Departments and Company dimension in application in 11.1.2.3 environment.

Hyperion Essbase Developer

Confidential - King Of Prussia, PA

Responsibilities:

• Setup and maintained user access and security Production support for the existing planning application in 11.1.2.3 environment
• Created users, user groups and administered security for multiple applications
• Worked extensively on security/access settings for the reports and cubes in Shared Services
• Formulated different design and support documents for the applications
• Maintain Documentation for installation and troubleshooting procedures of the application
• Written and executed unit test plans, quality assurance test plans, and test strategies
• Developed and implemented Dimensions and member Attributes

Hyperion Essbase Developer

Confidential - Pittsburgh, PA

Responsibilities:

• Performed requirement analysis which included compiling an inventory of existing reports in several formats and analyzing the reports to define the dimensional requirements for a new Hyperion Essbase Sales Analysis Cube
• Involved in defining requirements for a relational data mart to support the Essbase databases
• Designed and developed numerous complex Essbase applications and developed an excellent understanding of appropriate use of the different storage options in Essbase
• Created BSO application to support Financial Budgeting and Forecasting
• Developed Excel reports using the advanced member selection techniques
• Researched, identified and fixed data errors using Essbase log files, data load error files, ad-hoc retrieves from Excel