Over 8 years of IT experience which includes 7 years of cross-functional experience in development, analysis, implementation, Administration in a client-server environment. Held positions as a sr. Essbase developer, Planning Developer, Administrator. Specialized in Hyperion Products like Hyperion ESSBASE, Planning, MAXL, MDX, ESSBASE Excel Add-In, Hyperion Smart View Add-In and Hyperion Reportsin Windows and UNIX Environment. Self motivated with the ability to work independently and in team environments.
Thorough Knowledge of entire life cycle of Data Warehouse Design, development and implementation.
Developed ESSBASE cubes using Block/Aggregate storage technologies (BSO/ASO).
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.
Performed regular Database backups, Dense/Sparse settings, Partitioning (using Transparent, Replication and Linked Techniques) and MAXL scripts, MDX scripts.
Extensively worked on Essbase (ASO\BSO\Hybrid) applications.
Designed and developed Block Storage (BSO) and Aggregate Storage (ASO) Essbase cubes.
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.
Migrated applications across the environments.
Developed Hyperion Planning Data Forms, Businessrules, Task lists, Menus,Smart list.
Hands on Experience in calculation scripts(creation, Manipulation and maintenance)
Experience in Hyperion System 11(188.8.131.52, 11.1.2.x) modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting and Financial Reports).
Written\modified simple to complex Calc script and simple to complex Business rules as per business requirement Written\modified MDX script for ASOapplications, written member formulas for ASO applications.
Written\edited Maxl’s for automation, data retrieval, Properties settings, cube building and etc.
Created new Hyperion planning applications (Classic and EPMA).
Good Experience in application creation using both Hyperion EPMA and Classic Administration.
Expertise in building Financial Budgeting and Forecasting OLAP applications with ESSBASE and Planning.
Widespread experience in Hyperion Planning Forms, Security, Metadata Maintenance, Business Rules and ESSBASE Excel Add-In.
Experienced in design of Multi-Currency applications for large corporations operating in several countries.
Performed several administrative tasks like installing and troubleshooting of ESSBASE Administrative services, Shared Services and Planning on server machines.
Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups.
Involved in Scheduling daily batch processes using CONTROL-M workload automation software, migrating fact data between different Hyperion applications.
Created templates and ad-hoc reports using Excel Add-in, Smart view for budget and forecast analysis.
Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions.
Expertise in Hyperion V 11.x Essbase, Planning.
Knowledge in Navigating PBCS environment.
Knowledge in creating and configuring different types of enterprise applications as per business process (Financial and Capital Asset planning) in PBCS.
Expertise in managing Capital Asset Planning application in EPBCS.
Domain Expertise & Solutions
Health Care,Retail,Financial Systems
OLAP Expansion Tools
Hyperion System 11.x/9.3.1 BI+ (Financial reporting, Interactive reporting), Hyperion System 11.x/9.3.1 Analytic Administration Services, Hyperion Planning 11.x/9.3.1.x, Hyperion System 9 Application Link (HAL), Essbase 11.x/9.3.1.x/7.x/ 6.5/6.2/5.0, Hyperion Enterprise, Hyperion Essbase Administration Services console (EAS), EIS 11.x/9.3.1.x, Performance Score Card, Essbase studio 11.x, FDM 11.x/9.3.1.x, FDMEE 184.108.40.206, HFM 11.x/9.3.1.x, Hyperion Data IntegrationManagement (DIM)
Oracle 11g/10g/9i, MS SQL Server (2003, 2005), Essbase 9 BI+
Oracle 9i/10g, IBM DB2, MS Access
Financial Reporting, Interactive reporting, Spreadsheet Add-In,
Financial Reporting Studio, Hyperion Reports,Hyperion Intelligence,
Hyperion System Smart View, Hyperion Spreadsheet Add in Hyperion Analyzer,Web Analysis
Web & Application Servers
Apache Tomcat, WebLogic 8.1.2, WebSphere 6.1
Unix, Windows 2000/XP/NT
Capital-One- Plano, TX Nov 2018 – Till date
Role: Senior Hyperion Developer
Capital Asset Planning is an Enterprise Planning and Budgeting application leverages Hyperion Essbase technologies. Thus, all changes made within Capital Asset Planning are automatically reflected in Planning allowing real-time impact analysis of capital investments and expense plans on overall Financials.
Capital Asset planning shares common administration, user management, and installation and configuration support with other Oracle Performance Management applications. This common infrastructure provides one point of access for end users to all content while reducing the maintenance required from IT professionals.
Maintaining and supporting Capital asset planning application in EPBCS.
Importing Entity, Asset detail dimensions.
Import/ loading data using Data management integration into Capital asset planning application.
Integrating Capital assets investment and expenses data into Financials cube.
Ability to do budgeting and forecasting at the entity, multiple currency and department level with the ability to generate reports at these levels.
Ability for users to easily input budget and forecast information using the planning Web Forms.
Ability to create and manage flexible workflows as it pertains to the budgeting and planning process.
Create and modify ASO applications for Reporting purpose.
Involved in assigning security for end users.
Assign security on Artifacts.
Able to do Depreciation and Amortization Assumptions.
Transferring and Retiring Existing Assets.
Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports.
Expertise in using Investments, Existing assets, Intangibles and Analysis cards of Capital cluster.
Expertise in Navigating PBCS.
Created web forms and used Smart push to move data from BSO to ASO reporting cube.
Set up Backups jobs to archive nightly artifact jobs Snapshot from oracle using EPM automate tool.
Down loadData TemplatesfromConfigure card for data upload.
Created Data mapping between BSO and ASO cubes.
Environment: EPBCS, Financial Data management.
Genpact, Hyderabad, India Jun 2016-April 2018
Client: CARA Operations Limited
Role: Hyperion Developer
Project Summary: 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.
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 properties, overall metadata building and refreshing the data.
Designed and developed web forms for data inputs as per the business requirements. DevelopedSmart 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.
Environment:Hyperion planning 220.127.116.11, Hyperion Essbase 18.104.22.168, Hyperion EPMA, Oracle 11g, Windows 2008 Server, MAXL.
Genpact, Hyderabad, India Feb 2014 – May 2016
Role: Hyperion Developer
Project Summary: 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.
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.
Environment: Hyperion Planning 22.214.171.124, Hyperion Essbase 126.96.36.199, Smart View, Web Analysis, Oracle 11g, Windows 2008 Server, MaxL.
Saralee– Genpact-Downers Grove, IL Jun 2013 to Jan 2014
Project Description: Sara Lee North America (SLNA) is a leader in meat-centric food solutions for the retail and foodservice markets. This is an AMS project where the main function is to provide maintenance and support of the applications of the client. This project is divided into two main parts, SLNA and SLI (Sara lee international). I worked within the Hyperion team of SLNA-NON-SAP part. This team comprises of functional and technical consultants who support different clusters of Hyperion application
Involved in the design to build up / rolling budget from individual entity level and at consolidated level.
Actively involved in Period opening.
Involved in Data reconciliation between source data and HFM data.
Created Webforms, MemberList in HFM.
Involved in Consolidation.
Developed financial reports and scheduled them as per business needs.
Ensure monthly close process runs smoothly in Hyperion HFM, FDM, FR and Smart View applications.
Coordinate issue resolution with internal and external technical support providers.
Support, corporate, field and remote users with Hyperion applications and Smart View.
Build, maintain and run financial reports in Hyperion Financial Reporting Studio.
Load data to HFM as needed during monthly close process.
Work with end users to develop and enhance the application process in a manner that will result in a stable productive environment.
Monitor application performance, identification and communication of resolution of issues.
Participate in the analysis of the efficiency and effectiveness of current departmental processes and procedures and ultimately help to implement identified improvements.
Special projects and process improvements as determined necessary by management.
Support end users' needs by providing assistance with report creation/implementation, user training and functionality guidance as needed.
Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
Maintenance of user security and troubleshooting user access issues as they arise.
Updating the existing Rule files to match HFM structure.
Created Member lists in Hyperion Financial Management.
Creating and Scheduling the Extended Analytics data loads based on the requirement.
Stopping and Starting the Hyperion services on weekly backup times.
Trouble shooting the daily issues, Creating Oracle SR's and applying Patches.
Load required data into Hyperion with appropriate checks and controls.
Create and maintain system documentation and internal controls.
Develop training materials and provide formal/informal training.
Perform Hyperion administration duties related to the operations of Hyperion.
Attend the regular review calls and provide an update to client.
Environment: HFM 188.8.131.52/184.108.40.206, FDM, Smart View, Hyperion Financial Reporting 220.127.116.11/18.104.22.168, Windows 2008, Microsoft Access, Oracle 10g.
Soitec –Genpact-Peabody, MA Sep 2012 to May 2013
Project Description: Soitec is the world leader in generating and manufacturing revolutionary semiconductor materials for electronic and energy industries. I developed and supported various Essbase and Planning applications while working on the Soitec Financial Systems application.
Interacted with Business Users for gathering requirements and converted them to technical specification.
Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
Extensively involved in modifying the outlines by adding new members for Essbase Cubes.
Developed batch files using MaxL and ESSCMD to take data backups for all the Databases.
Developed Load Rules to build Dimensions dynamically and to load data in to Essbase OLAP server.
Optimized and tuned Database outlines to increase retrieval speed.
Responsible for setting up users, security groups and access filters to ensure maximum-security maintenance through shared services.
Added new members for the dimensions and deployed them to Planning applications.
Created numerous Planning web forms in Hyperion Planning Workspace and attached Business Rules to run on them.
Involved in migrating to different environments using Migration utilities provided by Oracle.
Responsible for Form security and functionality.
Taking frequent outline and data backups.
Responsible to update substitution variables daily, weekly and monthly.
Enhancement of Web Forms as per Business Process Owner's request.
Made modifications in Financial Reports as per Business user requirements.
Troubleshot Production issues like spanning of drives, security.
Environment: Hyperion Essbase 9.3.1, Essbase Administration Services 9.3.1, Hyperion Planning 9.3.1, Web Analysis Studio, MSSQL, Windows Server 2003.
CMA CGM – Genpact-India Dec 2011 to Aug 2012
Project Description: CMA CGM is an international operator serving maritime shipping routes around the world. As part of a teach I developed various Essbase applications and components like calc scripts, rules files, outlines, report and report books and also supported user questions and UAT.
Responsible for designing the database for improved ETL and building a new financial database, gather all user requirements, conduct interviews for offshore candidates, lead offshore team for future maintenance activities. Cut the run time from 6.5 hrs to 1.5 hrs with negligible impact for existing users' interaction.
Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis &Hyperion Reporting Studio V 9.3.
Extensively worked on SQL drill through process to prepare the financial reports.
Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube; develop MDX queries.
Created and maintained multidimensional database (MDDB) financial applications to perform ad-hoc General Ledger analyses for accountants and financial analysts.
MS Excel Report generation with VBA programming for Essbase. Created various test-data using SQL and excel to perform more DBA activities of performance tuning of developed Calc scripts and created mechanism to allow periodical Essbase backups.
Involved in developing report scripts, formulas using ESSCMDs; tested and optimize their performance.
Used PL/SQL for extracting and transferring selected data into Oracle data warehouse and then wrote several load rules for smoothly loading the data into Essbase server.
Built a new Essbase financial database for reporting Actuals, Budget, Flash and Forecast numbers. Designed the ETL process for data load into the new database from SQL tables. The key point for the project was 'maintenance', as the existing team didn't yet have any Financial Systems analysts.
Managed BSO and ASO cubes and improved their performance through tuning: recognizing design issues, eliminated fragmentation, sizing caches, grouped sparse dimensions together, optimized Essbase caches, fine tuning of cache settings usage of filters.
Built several custom reports using Hyperion Financial Report V 9.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
Responsible for month-end tie-out and provide related support to financial controllers.
Environment: Hyperion Essbase 9.3.1, Hyperion Planning, Hyperion Financial Reports Studio V9.3, Interactive Reporting, Web Analysis, Hyperion Integration Services, WebLogic, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX Shell scripts.
Elder pharmaceuticals-Hyderabad, India. May 2011- Nov 2011
Role: SAS Programmer
Project Description: Elder pharmaceuticals, India. Is a project module on clinical data analysis of patients with renal diseases (kidney transplantation) and cancer. The client provides the Case Report Forms. The data imported to a SAS system. Generated reports as per client requirements.
Planned, directed and implemented the programming components of the project as required by the client.
Primary responsibilities include the Protocol Review, CRF Review and SAP Review.
Import data from internal and/or external sources into SAS.
Organize datasets for statistical analysis by merging, combining, splitting, coding and performed edit-check for datasets to assure the quality of the datasets.
Built Macros to produce customized tables. These Macros are produced by DATA STEP and various procedures.
Perform statistical analysis, generate reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
Create chart, graph and plot using PROC GCHART and PROC GPLOT for inclusion of reports.
Ensure that validation/quality control is performed on project programs.
Ensure whether the output meets quality standards and project requirements and the findings are documented and communicated to the client.
Documented and maintained SAS programs/Macros, including independent development of Macros and utilizing existing Macros, verify statistical programs and results.
Customize SAS outputs to RTF, PDF and HTML files through Output Delivery System (ODS) facility.
M. Pharma from Andhra University.
B. Pharma from Acharya Nagarjuna University