Developer Data
Resume:
Manasa Ch
Atlanta, GA
E-Mail: ********.*******@*****.***
Professional Summary
3.9 years of IT experience with extensive hands on technical expertise in working with OLAP/Business Intelligence solutions as a Hyperion Developer.
Have very good experience in Hyperion Essbase and Hyperion Planning and worked in Development and Application Support roles.
As a Hyperion developer worked on Hyperion 11.1.2.3 and 11.1.2.4 EPM suite of products.
Solid understanding of multidimensional database architecture.
Designed and developed Block Storage (BSO) and Aggregate Storage (ASO) Essbase cubes.
Having good Experience on Hyperion Classical and EPMA Planning applications.
Knowledge in Creating the Planning application for multi currencies.
Working knowledge of Budgeting and Forecasting process by using Hyperion planning.
Expert level experience in all areas of Essbase such as outline design, member formulas, Calc scripts, Report scripts, build rules and load rules.
Experienced in data loading through Free-Form Loading and using Rules files.
Automated the Essbase Cubes using MaxL Scripts.
Skilled in optimization and performance tuning of Essbase application.
Have good experience in Developing Web forms, business rules, Smart lists, task lists, menus and LCM Migrations.
Maintaining data back-ups and security.
Worked on Creating numerous users, groups and provided them different privileges
Quick Learner and Good Understanding Capabilities.
Good interpersonal skills, commitment, result oriented, hard working with quest and zeal to learn new technologies and undertake challenges.
Domain Skills
DWH Tools
Oracle Hyperion Essbase 11x, Hyperion EPM, Hyperion Planning 11x, MaxL, Oracle Hyperion Essbase Administration Services console (EAS), Hyperion Shared Services.
Databases
Oracle 10g, Oracle 11g, MS SQL Server 2005
Other Applications
Toad, SQL Developer.
Reporting Tools
Excel Add-in, Smart view
Operating Systems
Linux, Windows XP/Vista/2003/2008 Server
Industry Experience
Worked as Software Engineer at Capable Groups from Dec 2014 To April 2018.
Education:
M. Pharma from Andhra University.
Professional Experience
CARA Operations Limited
Feb/16 to Apr/18
Hyperion Developer
Cara is a leader in the Canadian hospitality industry and it is also the largest caterer to the airlines and railways in Canada. Cara owns more than 700 restaurants across the country.
The GL data is flown into the oracle data warehouse using ETL during WD1 to WD10 which is organized according to requirements of the organization. The aim of the project is to transfer Actual data from the warehouse to Hyperion Planning system. Cara is using Hyperion Essbase for monitoring/analyzing the daily sales throughout the firm, Webforms and Smart-view reporting for companies financial reporting and Hyperion Planning for the company’s Budgeting and forecasting.
Environment: Hyperion planning 11.1.2.4, Hyperion Essbase 11.1.2.4, Hyperion EPMA, Oracle 11g, Windows 2008 Server, MAXL.
Responsibilities:
Developed and Supported one EPMA Planning application and two BSO Essbase cubes for Management Reporting.
Played an active role in Application design, development, testing and Implementation including security and automation. Also played a key part in Application support.
Created ASO and BSO applications, databases and designed outline in an hour glass model.
Created Rules files for building dimensions and loading Data into Essbase applications.
Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions.
Created Essbase outline formulas and Calc scripts.
Involved with Hyperion Planning budgeting application to add dimensions, assign member properties, variance reporting procedures, time balancing, currency dimension properties, overall metadata building and refreshing the data.
Designed and developed web forms for data inputs as per the business requirements. Developed Smart lists and Task Lists for end users.
Created Business Rules with run time prompts for planning web forms (consolidation, and currency conversion).
Involved in automating the entire build, load, calculations using MAXL.
Migrated applications across the environments by using LCM and provided documentation on the process.
Set up users and groups according to the departments and maintained security to users and groups from Hyperion shared services and assigned security to data forms.
Provided the support to the Essbase and Planning applications post development phase and performed the required enhancements for metadata and forms based on business requirement.
Monitoring the daily backup process and weekly service restart and Responsible for Hierarchy Maintenance Process as part of monthly operational activities.
Creating the users, Groups and assigning Security Provisions through Shared Services based on new requirements.
Performing daily Health Checks and Ensuring that the environment is up and running and restoring the environment with minimal downtime.
Ensuring that the Hyperion environment is available for Month end activities like Actuals load, Headcount load.
Involved in several releases and created documentation for final list of migration components.
Strabag
Dec/14 to Feb/16
Hyperion Developer
Strabag SE is one of Europe’s leading construction groups with approximately 66,000 employees. Strabag operates in its core markets within Austria and Germany, and has numerous subsidiaries in all countries of Eastern and South-East Europe.
Strabag was using Hyperion Essbase and Hyperion Planning for Forecast, Budget and Reporting for Monitoring company sales performance.
Environment: Hyperion Planning 11.1.2.3, Hyperion Essbase 11.1.2.3, Smart View, Web Analysis, Oracle 11g, Windows 2008 Server, MaxL.
Responsibilities:
Involved in the Hyperion planning application development with two plan types by using the functional specifications document for the Budgeting and Forecasting application.
Involved in designing, building and modifying of Outlines and assign different member properties for members.
Created Rules files for building dimensions and loading Data to the cubes.
Made data loads using Selection and rejection criteria.
Developed various web forms for all the key departments in the company to enter budget and forecasting data, attached business rules to the forms by selecting run on save option and assigned security to data forms.
Involved in automating the entire build, load, calculations using MAXL.
Set up Users and Groups in Hyperion Essbase and assigned access privileges.
Developed Menus and task lists for end users.
Involved in designing security filters to control the user access to specific dimensions and members.
Involved in creating the ad-hoc and customized reports based on the user requirements using Excel spread sheet add-In and Smart view.
Scheduled & Developed batch scripts for weekly and month end process.
Contact this candidate