SUMMARY

• 6+ years of professional IT experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using Hyperion Essbase, Hyperion Planning, Hyperion Business Rules, Essbase Administration Services, Essbase spread sheet services, Smart view Office, MaxL.
• Experience in development of Hyperion Planning applications with Data forms/Web Forms, Business rules, Menus, Task lists, User Variables and application migration as well as application management and troubleshooting.
• Experience in planning and designing multi - dimensional cubes using both ASO and BSO options while leveraging important design considerations such as storage options, member properties, dense/sparse dimensions, user management and security, formulas, hardware requirements, data sources etc.
• Designed customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the Client requirements.
• In-depth experience in Hyperion components such as ESSBASE Excel Add-In and MaxL Automation. For ESSBASE maintained database optimization while performing Dynamic Dimension Building, Data Loading, Calculation Scripts, Report Scripts, and Cache Management.
• Expertise in Developing and Deploying Cubes using various dimension build and data load methods, automation of data loads using MaxL batch scripts.
• Hands on Experience in calculation scripts (creation, manipulation and maintenance).
• Expertise in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Expertise in Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Involved in Administrative tasks like installing and troubleshooting of ESSBASE Administrative services, Shared Services and Planning on server machines.
• Complete Understanding of Database Design Life Cycle.
• Solid interpersonal skills with excellent analytical and logical skills with a good understanding at the conceptual level, with demonstrated experience in documenting and working through issues as part of a team.
• Keen learner with self-commitment, innovation and possess ability and willingness for learning new applications as needed.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Essbase 11.1.2/9.3. x, MS Excel spreadsheet add in

Business Intelligence Tools: Hyperion Planning 11.1.2/9.3. x

Reporting Tools: MS Excel Add-in, Hyperion Smart View, Hyperion Financial Reporting studio

Operating Systems: WINDOWS 2000/NT 4.0/XP/2003 server

Languages: C, Java, Oracle9i (DBA), SQL, PL/SQL, HTML, JavaScript, Apex and Visual Force

Databases: Oracle 11i/10i, MS SQL Server 2000, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Hyperion Essbase Consultant

Responsibilities:

• Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child references.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles, also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Designed and developed the Classic Hyperion planning and EPMA applications according to the gathered requirements.
• Produced data forms for end users to enter the manual inputs according to the hospital clients.
• Involved in database and security refreshes in Hyperion Planning.
• Worked extensively on Hyperion shared Services and Created numerous users, groups and provided them different privileges.
• Development of Essbase components Load rules for actual and other data loads, setting up substitution variables
• Automated dim build, data loads, partitions creation and backup and automate Essbase application refresh process using MaxL scripts and UNIX scripts.
• Involved in improving performance of the applications, optimized the various cache settings to enhance the performance of Cubes.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Worked on Attribute dimension and UDAs and optimized the storage, retrieval time and the report performance.
• As an administrator created and automated various batch scripts to build the dimension, load data, perform calculations and taking the nightly backups.
• Developed reports for financial analysis, trending and results analysis related to revenue and expenses using Financial Reporting.
• Migrated the various components of the application including reports, calculation scripts, and outlines using Lifecycle Management Utility (LCM) among development, test and production environments.
• Document Hyperion system processes and responsible for complete system documentation and training materials.

Confidential, Los Angeles, CA

Hyperion Essbase Consultant

Responsibilities:

• Conducted and Involved in the requirements and design documents review and updating meetings to meet the current requirements.
• Development of Essbase components Load rules for actual and other data loads, setting up substitution variables
• Extensively involved in designing and modifying the outlines for Aggregate Storage (ASO) & Block Storage (BSO) cubes in Essbase.
• Worked on Hyperion planning 11.1.1.3/9.3.1 to support complex financial applications for budgeting and Forecasting.
• Configured Data Sources through Hyperion Configuration Utility.
• Designed, developed, tested and deployed Hyperion Planning Applications in Hyperion Workspace.
• Created Web Forms/Data Forms in Hyperion Planning for users to input forecast, budget, actual, accounting changes and other data.
• Developed Task Lists, Work Flows, Menus and Business Rules with an option for Run-time prompts.
• Involved in improving performance of the applications, optimized the various cache settings to enhance the performance of Cubes.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Worked on Attribute dimension and UDAs and optimized the storage, retrieval time and the report performance.
• As an administrator created and automated various batch scripts to build the dimension, load data, perform calculations and taking the nightly backups.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Interactive Reports and Financial Reporting Studio.
• Document Hyperion system processes and responsible for complete system documentation and training materials.

Confidential

Jr. Hyperion Consultant

Responsibilities:

• Involved in analyzing, designing and developing of Hyperion Essbase Applications.
• Analyzing the Outline and Hierarchy, modifying members in outline and change the hierarchy as per requirement.
• Automation of dimension building, data loading, Calculations using MAXL scripts.
• Providing authentication by designing filters as per user level and group level access.
• Debugging the issues fetching through Excel-Add In and giving the desired solution.
• Responsible for overseeing 24x7 Support and Fixing the Issues Raised.
• Taking Back-ups daily and validating, checking log files regularly.
• Monthly loading forecast values and actual values and Aggregation of cube.
• Analyzing the requirements and building Hyperion Financial Reports as per the Functional designs provided.
• Providing access to users, assigning roles and removing users from groups and provisioning/de-provisioning the groups in shared services.
• Monitoring the daily system maintenance process.