We provide IT Staff Augmentation Services!

Planning Consultant Resume Profile

Palo Alto, CaliforniA

Professional Summary

  • Over 7 years combined experience in general application development. Efficient, dynamic and result oriented experience in IT/Design, Decision support systems, Business Intelligence, Client/Server Applications.
  • Experience in working with a range of Hyperion products including Essbase, Integration Services, Planning, Reports, Analyzer, and Excel Add-In, in both Windows and UNIX environments.
  • 5 years experience in Finance modules and Interactive Reporting and Dashboard Design Studio.
  • Extensive expertise in Hyperion Essbase system 11.X/9.X/7.X/6.X
  • Skilled in scheduling jobs in ODI, generating scenarios, and running automated processes.
  • Hands on experience on OBIEE 11.1.1.7. and 11.1.1.7.1
  • Profound expertise in Workforce Planning Applications.
  • Skilled expertise in Application/Production support area.
  • Profound knowledge on Oracle GL, SQL Queries and reporting tools.
  • Hands on experience in FDM integrations with HFM.
  • Skilled expertise in installations, configurations and upgrade procedures in the Client/Server environment.
  • Hands on experience of Times Ten in memory database.
  • Worked extensively in architecture design of Essbase Cubes using Block/Aggregate storage Partitioning.
  • Expert in building the hierarchies from DRM, Import/export process, Blenders, various metadata validation processes.
  • Exposure to the integration of OBIEE integration with Planning.
  • Skilled expertise in Oracle E- Business Suite - Essbase, Planning and HFM prominently hands on experience in CapEx applications.
  • Skilled knowledge of ESSCMD, MaxL, MDX, Calc scripts, and Report scripts under Windows and UNIX environments.
  • Excellent communication skills to interact with business users and gather the requirements and convert into technical solutions. Techno- functional .
  • Experience in creating the Properties, Nodes, filters, writing automators in different versions. Member and Hierarchy ordering in DRM, setting up different properties to members in export process etc.
  • Worked with cross functional departments and Business analysts to gather exact Financial Data Quality Management FDQM
  • Metadata sourcing for DRM from various kinds of different data sources like from flat file, Databases.
  • Knowledge and 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.
  • Knowledge of OBIEE Cache optimization and Management.
  • Exposure in automating the cube loads, dimension build, calculation scripts using Batch files in UNIX and Windows environment.
  • Expertise in Hyperion Planning Applications, Workforce, Business Rules, Macros, and the Web Forms. Worked with the Financial, Forecast and Budgeting Applications.
  • Skilled in developing and populating planning applications using Hyperion System 9 Planning, Hyperion Application Link, MS Access and Hyperion System 9 Planning Desktop.
  • Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
  • Knowledge of general warehousing theories and OLAP reporting. Familiar with all aspects of OLAP technology and development of multi-dimensional data cubes.
  • Proficiency in Database Administration DBA such as enhancing security, database tuning, backup and recovery on different servers and platforms, and operating systems.
  • Skilled knowledge on creating Cash Flow Statements using the balance sheet accounts.
  • Strong SQL skills, RDBMS development knowledge and understanding of relational data marts in ORACLE and MS SQL SERVER and knowledge of Essbase server upgrades over NT/UNIX platforms.
  • Excellent communication, documentation, interpersonal, training and presentation skills.

Technical Skills

OLAP Tools Hyperion Essbase System 9.x/11.x, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Essbase Integration Services, Essbase Administrative Services, Hyperion Planning, Shared services, FDQM, ODI 11g, DRM.

Reporting Tools System 9 BI Financial Reporting, Web analysis Hyperion Reports 2.x/7.x, Hyperion Spreadsheet Services, WinSCP, Putty, Excel Add In, Executive viewer, Smart View, Essbase studio, Hyperion IR, Dashboard Design Studio.

Databases Oracle 8i/9i, 10g, 11g, 12c, SQL Server 6.5/7.0, MS Access, Teradata

Oracle tools SQL Loader, SQL Plus, Toad

Operating Systems Windows NT/2000/XP/98/95, UNIX Solaris, HP, AIX , Linux Server

Languages C, C , SQL, Java, ESSCMD, MaxL , SQL, PL/SQL Scripting.

Office Tools MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential

Hyperion Essbase/Planning Consultant

Roles and Responsibilities:

  • Extensively worked on the Workforce planning, Capex and FinPlan modules of Hyperion.
  • Designed and implemented the end to end testing strategy for the Capital Expense module, including the data integration between source and Hyperion, data validations, and the security configuration.
  • Developed business rules for the Capex module, end to end, to seed the forecast cycles, copy the assets to Financial Planning, and to Archive plan and forecast scenarios.
  • Developed the depreciation calculations for the new assets added, and verified if they are pushed into oracle GL account.
  • Validated the data movement from workday to Hyperion planning that copies the employee details, market data and the headcount reports.
  • Extensively worked on the enhancements for the Workforce and FinPlan modules.
  • Worked with the development team to design and develop the multiple merit calculations of the new hires, and the salary calculations in HR Planning.
  • Extensively copied the data from Hyperion planning to Reporting cubes, using shell scripts.
  • Worked in the team to trouble shoot the business rules, calculation scripts, and the shell scripts to ensure data is accurately integrated.
  • Worked on the right click menus and adding assets in various scenarios, to calculate depreciation.
  • Tested the asset categories in Capex, with various combinations of the In-service date, Purchase time, and the Useful life.
  • Involved with the Business team to understand their requirements and expectations on the enhancements, and the product releases.
  • Extensive usage of substitution variables and setting appropriate values in them using MAXL/EAS.
  • Assisted the production support team, with security filters and application configuration.
  • Automated the Control-M jobs using BMC software, to execute EBS GL Non close extracts.

Environment: Essbase 11.1.2.2, Hyperion Shared services, Essbase Integration Services, Hyperion Workspace 11.1.2.2, Windows server 93, MS Excel, Oracle 11g, DRM, and Peoplesoft Application Designer.

Confidential

Hyperion Planning/Essbase Administrator

Role Responsibilities:

  • Involved in ticketing system in support of the Production issues raised and the problem management process.
  • Worked with business analysts for gathering requirements, functional specifications, testing strategies and developing a project plan.
  • Assisted in the integration of Hyperion Systems with SAP R3.
  • Extensively worked on CapEx applications, Workforce planning and reporting cubes.
  • Created custom dimensions along with the default Employee dimension available in the Workforce Planning to generate the headcount and support employee rollup for 24 month period.
  • Generated daily data back-ups and migrated files from Prod to Test via UNIX.
  • Executed the entire Capital Management System monthly process, to adjust the missing depreciations of approved projects for various cost centers.
  • Assisted end-users with Web Forms, Security access, and production issues.
  • Developed Calc scripts/Calc Manager Rules for Expense allocation, currency conversion and depreciation of CapEx. Wrote PL/SQL reports to extract.
  • Developed various Outline Load Utility automation scripts to load the Metadata into the Planning Applications.
  • Automated Hyperion Essbase Cubes to minimize manual entry through Batch File using ESSCMD/MaxL Scripts. Removed errors occurring during the nightly dimension build and data load processes by referring to Log files.
  • Provisioned various user groups via shared services, and provided assistance in planning issues.
  • Extensively worked on the migration of objects between environments DEV, TEST, PROD using LCM, or manually for the earlier versions.
  • Modified the ODI processes in DEV to enable a full 1 allocation for the EXLB projects, by changing the SQL queries, and enabling extra decimal points. Migrated it to PROD to schedule it as a nightly process.
  • Moved ODI jobs from one server to another, replicating the physical schemas.
  • Updated the outlines of Reporting cube and PPMS cubes, to add extra dimensions and regenerate the automated processes.
  • Assisted in the integration with HFM and FDM with Hyperion Planning.
  • Involved in Metadata Loading using Outline Load Utility and Actual data load using MaxL scripts.
  • Extensively worked with the ESSBASE database settings, caches and the outline optimization, as well as tuning of the ESSBASE cubes for the retrieval and calculation performances.

Environment: Hyperion Essbase 11.1.2.2, Oracle EPM system 11, Microsoft Excel 2010, Windows NT 4.0, ESSCMD, MaxL, Excel Add-In, SQL Developer, Windows Server 2008 R2 . Web Logic, ODI 11g, Hyperion Financial Management System 9.

Confidential

Hyperion Planning Administrator

Role and Responsibilities:

  • Involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
  • Loaded the Metadata Using Outline Load Utility. Expert in building the hierarchies from MDM / DRM, Import/export process, Blenders, various metadata validation processes.
  • Created and managed data forms, involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
  • Utilized validation Rule in Data form to Validate Balance Sheet.
  • Created Menus and attached to Data forms where users can open excel and Input data into excel and submit Data using VBA. Automated the Process to save and load data from this excel into the Planning application with wrapper that checks the update every 2 minutes.
  • Optimized the Designs of Data forms.
  • Created Business Rule with Run time prompts for Web Forms using Global variables.
  • Involved in Data Mapping and Validation for Actuals.
  • Created Task Lists and User Instructions for the easy Workflow.
  • Setup User security according to business requirements, restricting the views by dimensions, Entities. Wrote MAXL scripts to automate these cubes in Development, Testing and Production environments.
  • Designed planning applications and involved in the building of EPMA planning application.
  • Extensive usage of substitution variables and setting appropriate values in them using MAXL/EAS.
  • Created/Modified Calculation Script for Existing Application in Production.
  • Responsible for all the scripts migrations and their validations in all the environments - HAL to ODI: Extraction of data and integrating into EPM suite.

Environment: Essbase 11.1.2.2, Hyperion Shared services, Essbase Integration Services, Hyperion Workspace 11.1.2.2, Windows server 93, MS Excel, Oracle 11g, DRM, and Peoplesoft Application Designer.

Confidential

HFM/Planning Administrator

Role and Responsibilities:

  • Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
  • Provided integration of various data like derived, historical, and projected data.
  • Developed Rules files in order to upload data from financial system's database to Essbase cube.
  • Implemented calculation engine for computing derived data.
  • Loaded, reconciled and consolidated key financial data with Hyperion using FDQM Financial Data Quality Manager and HFM consolidation.
  • Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports.
  • Implemented an automated Cash Flow statement in HFM.
  • Involved in Data Loads and Calc Scripts optimization for Essbase and Planning.
  • Hands on experience with integrations between FDM and EPM planning.
  • Automated the Cube building through MaxL shell scripts and scheduled them though Control-M
  • Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
  • Loaded data using Essbase Integration Services EIS .
  • Implemented star schema and used EIS to interface with the company's existing Oracle 10g data warehouse.
  • Created various filters as per user requirement in EIS.
  • Assisted in the integration of OBIEE with Planning, on the Essbase cubes.
  • Involved in the installations and configurations of ODI 11.1.1.5
  • Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
  • Involved in requirements definition, functional specifications, documentations design and testing strategies.
  • Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
  • Involved in data-access security and user management.
  • Developed Excel Templates for user interface in Essbase database.
  • Involved in regular maintenance of the Essbase Server like cube backup's, security file back up and file system backup.
  • Involved in system installation, configuration and software upgrades from Essbase.
  • Prepared ad-hoc reporting and management reporting using Hyperion Interactive Reports, quarterly forecasts, annual budget, by working with the business managers.
  • Configured and Designed Reports within Financial Reports.

Environment: Hyperion Reporting, Essbase Excel Add-in, Hyperion system 11.1.2.2, Windows server 93, Oracle 11g, Essbase excel add in 11.1.2.2, Smart view 11.1.2.2, Workspace 11.1.1.4, Workspace 11.1.2.3, Ms excel, HFM, Oracle E-Business Suite.

Confidential

Hyperion Essbase Developer

Role and Responsibilities:

  • Assisted senior DBA in installations and upgrades of various Oracle products.
  • Created SQL scripts for creating tables, views, and stored procedures, loading data into the tables.
  • Configured test and development servers with the help of system administrator.
  • Installed Essbase family products in both Windows 2000/NT and UNIX environments.
  • Installed and configured Hyperion Planning System 11 on Unix based AIX
  • Maintained two previous Essbase cubes.
  • Maintained discrete data store within one physical database using ERP system
  • Reduced budgeting time and ensured accuracy using Hyperion Planning
  • Involved in script writing for dynamic dimension builds and data loads.
  • Designed and developed calc scripts.
  • Used ESSCMD extensively to run calc scripts.
  • Developed the Load Rules to automatically validate the data and feed into Essbase new structure.
  • Developed report scripts to populate data, which was fed into the other cube.
  • Created batch files to run calc scripts, data load and data calculations.

Environment: Windows server 93, Oracle 11g, Essbase excel add in 11.1.2.2, Smart view , Workspace 11.1.1.4, Workspace 11.1.2.3, Ms excel, Hyperion Planning Applications, Workforce Planning.

Confidential

Hyperion Database Developer

Role Responsibilities:

  • Involved in total SDLC Software Development Life Cycle with Essbase Cube development.
  • Worked with business analysts for gathering requirements, functional specifications, testing strategies and developing a project plan.
  • Developed Batch Scripts and Rules files to dynamically upload dimensions and data from Legacy System to Essbase Cubs. Also developed Rule files for multi-dimensional databases.
  • Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
  • Involved in Performance Tuning to minimize data load time. Analyzed all dimensions and members in the Essbase outline.
  • Implemented calculation engine that includes robust mathematical functions for computing derived data.
  • Extensively used Essbase Integration Services EIS for loading data.
  • Implemented star schema and used EIS to interface with the company's existing Oracle 10gig data warehouse.
  • Created various filters as per user requirement in EIS.
  • Assisted in the installing, implementation and configuration of ODI.
  • Worked on the Data loads from Oracle Finance modules- Oracle GL
  • Worked on the performance tuning Cube Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulae and Calc scripts.
  • Worked with Essbase DBA for security management.
  • Developed Excel Templates for user interface in Essbase database. Created new batch files and scheduled these batch files for complete automation process for nights and weekends calculations and backups.

Environment: Hyperion Essbase 11.1.1.2, Hyperion Reports7.0, Microsoft Excel 2007, Oracle 10g, Windows NT 4.0, ESSCMD, MaxL, Excel Add-In, SQL Developer, Windows Server 2008 R2 . Web Logic, ODI, Hyperion Financial Management.

Confidential

Essbase Developer

Role and Responsibilities:

  • Design and maintenance of cube periodic reports related to two cubes.
  • 24/7 support for the existing Essbase applications, application maintenance Monthly End Roll over Reporting maintenance.
  • Extensively worked with Hyperion Reports and Hyperion Analyzer, Developed several reports for Sales and Marketing Performance Packages which included Operating Expense Analysis, Allocation Analysis separately and as per the user requirements.
  • Loaded, reconciled, and consolidated financial data using FDQM.
  • Assisted in the configuration of ODI and migrated the settings from the previous release.
  • Automated daily/monthly/annual PDF/Snapshot book generation, developed Excel Templates for user interface in Essbase database.
  • Provided technical assistance and support to end-users and was involved in developing documentation required.

Environment: Hyperion Essbase 9.3.3, Hyperion Reports 6i, Essbase Spreadsheet Add-in, UNIX HP , SQL Server, Windows NT.

Hire Now