SUMMARY

• 10+ years of rich experience in IT including 7 years experience in design, analysis, development and implementation of various applications environment using
• Oracle Planning and Budgeting Cloud Services(PBCS), Hyperion Essbase, Essbase Administration Services,Hyperion Planning, Hyperion shared Services, Hyperion Financial Reporting Studio, Hyperion Financial Reporting Web Studio, Smart View for Office, ESSCMD, MaxL, MDX, Essbase Excel Add - in, Financial Data Management enterprise edition (FDMEE) on Windows and Unix environment.
• Extensive knowledge of upgrade between different versions of Hyperion Suite.
• Migration from on premise Oracle Hyperion planning and Essbase to cloud Planning and Budgeting cloud services (PBCS).
• Responsible for looking into the performance issues, Disc space
• Knowledge of Change management for the System/Infrastructure Changes.
• Extensive experience in designing and developing OLAP cubes from a conceptual level.
• Extensive experience in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, Business Process Modeling, Project planning and creation of user cases.
• Hands on experience in Oracle Enterprise Performance Management Architect (EPMA) technology.
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Key strength in optimization and tuning of Essbase cubes across Block
• Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes and calc scripts to facilitate effective business decision making.
• Capable of managing organization's data, assess and fulfill its reporting needs and develop powerful BI solutions that have true impact on the performance of a company using Hyperion Financial Reporting Studio.
• Hands on experience with data integration from multiple data sources into Hyperion Planning and Essbase through Financial Data Management enterprise edition (FDMEE)
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Scheduling loading of data, and writing scripts to perform loads and calculations, Essbase Partition database models and Essbase Block Storage database models.
• Database optimization and performance-tuning expertise with Essbase.
• Creating innovative solutions to automate processes.
• Monitoring and support Hyperion Essbase Business Intelligence applications and batch load processes to ensure the highest level of system availability.
• Experienced in developing Data warehouse/Data Marts, Star Schema, Snowflake Schema and slowly changing Dimensions.
• Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
• Support user training, documentation, and rollout of new projects.
• Excellent communication and interpersonal skills with ability to be a team player and team leader.

TECHNICAL SKILLS

OLAP and BI Tools: Oracle Planning and Budgeting Cloud Services (PBCS), Hyperion Planning 11.x/9.xHyperion Essbase 11.x/9.x, Essbase Administration Services (EAS), Hyperion Planning, Financial Data Quality Management (FDQM), Financial Data Management Enterprise Edition (FDMEE), Analytic Integration Services (AIS /EIS), EPM Automate Utility, Workspace, Smart View for Office, MS Excel Add-In Essbase query designer, Integration Services, Performance Management

Reporting Tools: Web Analysis, Smart View, Hyperion Financial Reporting Studio and Hyperion Financial Reporting Web Studio

MS Office Tools: MS Office Suite 2010/2007/2003.

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL.

Modeling Tools: Star schema, Snowflake schema, Dimension and Fact tables

Databases: Oracle 11i/10g/9i/8i, MS SQL Server, MS Access.

Operating Systems: Windows XP/Server 2003/2007/2008 , UNIX.Work Experience

PROFESSIONAL EXPERIENCE

Sr. Hyperion Consultant

Confidential

Responsibilities:

• Worked on new implementation of Hyperion Planning and Essbase applications in every phase of the implementation cycle.
• Created 2 Budget related Hyperion Planning applications, 1 Forecast related application and 1Essbase application for reporting purpose in Hyperion 11.1.2.1.
• Conducted requirement gathering sessions for Cost Center Expense Planning, Labor Planning, Sales revenue planning and Forecast applications.
• Analyzed all the requirements and created 2 plan types for each Budget related application.
• Based upon the analysis on the requirements, created required dimensions and populated the members with ODI interfaces.
• Developed 2 new cubes for Cost Center Budgeting purpose. One is Opex and another one is Labor cube. Created a Sales cube for sales revenue planning as well as program based planning.
• Developed different type of web forms both simple and composite for entering the warehouse square footage stats, operating expenses data by cost center (both domestic and Non - Domestic, Labor FTE, Compensation related data and revenue data by program.
• Developed Load rules and added them in ODI interfaces to load the data.
• Developed different type of business rules and calcscripts to calculate Warehouse square footage allocation expenses, operating expense allocation by cost center, Base salary calculation based on hourly rate plus FTE, Bonus, compensation calcs for To be hired employees based on start month, Material commission calculation, Rebates calculation and Balance sheet related calculations.
• Developed some special business rules to move the data in between the cubes dynamically and used@XWRITE function within the business rule for the data integration.
• Created Tasks lists and Menus for the Financial Analysts for easy navigation within the Planning application.
• Developed a security matrix to document every Hyperion Planning object security such as Business rules security, Web form security, Task lists security, Dimension level security and workflow security
• Worked on a complex security model, created different type of groups such as READ access groups and WRITE access groups within the shared services console and provisioned them. Added users to appropriate groups and users getting the provision from the groups.
• Developed workflow and assigned appropriate owners to their respective cost centers as per the promotional path.
• Created an Essbase application for reporting purpose as well as to store the Actuals and also created a transparent partition to show the Budget data in reporting application from Budget applications.
• Developed different kind of reports by using Financial Reporting Studio such as Cost Center Expenses Variance Report, Program Income Statement report, Sales revenue and Gross profit by program reports, Balance sheet reports, FTE validation reports and Labor Compensation reports.
• Written automation scripts using MAXL for daily data backups, weekly backups and included these MAXL scripts within the batch file then added this job to the windows scheduler.
• Performed user training, prepared design documents and administered end to end process in Budget period.
• Worked on Optimization and performance tuning of the cubes, developed calculation scripts and Business rules.
• Created Adhoc reports for Finance department using smart View.
• Migrated Hyperion applications from one environment to another environment using LCM

Environment: Hyperion System 11, Hyperion Essbase 11.1.2.1, Hyperion Planning, Oracle EBS, ODI, Windows 2010, Hyperion Smartview, Hyperion Financial Reporting Studio.

Sr. Hyperion SME

Confidential

Responsibilities:

• Implemented Hyperion suite on AWS environment for lift and shift kind of a project for move out of data center effort.
• Developed software components, adhering to existing process guidelines.
• Perform application Lifecycle Management by Programming, testing, Validation and Deployment and Documentation.
• Developed and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes.
• Developed SQL Loader functionality to interact Essbase Cubes to and from with Oracle Database.
• Developed Essbase Partitioning, automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Created and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rules.
• Designed custom Essbase calculations scripts, MDX scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
• Created database objects such as outlines, report scripts, load rules, Calculation scripts, dimension build rules, MaxL scripts to automate administrative/query operations, data load automations and security provisioning.
• Coordinate software installation and monitor implementation process with different agile teams.
• Executed Proof of Concept (POC) by using CI/CD (continuous integration / continuous deployment) practice using Subversion, Jenkins, Nexus, uDeploy.
• Monitor system performance trends using tools like Zabbix, Grafana, Site Scope to identify potential issues.
• Successfully adopted internal tools like Artemis to simplify the change order process with integration of Version One and HPSM.
• Developed Essbase BSO application for CCAR (Comprehensive Capital Analysis and Review) which was recognized by internal TechXcellence award.
• Suggested Opportunities for improvement within the applications.
• Analyze internal user needs and desired results and develop software solutions with responsibility for the delivery of requirements, with limited or no supervision
• Understand desired application capabilities and testing scenarios by working with Product Owner.
• Work within and across Agile team to design, develop, test, implement, and support technical solutions across a full - stack of development tools and technologies.
• Prepare test cases and effectively conduct unit testing, including interacting with business users to validate results
• Supported data conversion and interfacing activities, including user support to load and reconcile data.
• Lead Reporting, Planning, and Master Data design sessions and own the architecture and design of aggregate solution.
• Worked with business application developers to determine how enterprise infrastructure will optimally meet business needs, while promoting adherence to analysis, design, and development standards and methodologies.
• Actively participated in planning discussions with development and other IT teams.
• Worked with System Integrators to understand the business requirements to ERDs (Entity Relationship Diagram).
• Clearly communicate technical information to both developers and business stakeholders.

Sr. Hyperion Consultant

Confidential, Chicago, IL

Responsibilities:

• Participated in defining requirements from the end - user, functional specifications, design documentations and test strategies.
• Designed and developed Planning application facilitating Budgeting and forecasting.
• Involved in creating the load utility files for both dimension member loading and data loading into the application.
• Created web forms for the user inputs that were tuned by creating the attribute and substitution variables.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created classic planning applications using Workspace.
• Created and managed numerous Business Rules and Member formulas for the application.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, Calc scripts, MaxL scripts and reports.
• Continuous monitoring of Essbase performance by checking Essbase database size, index and page size, calculation times, fragmentation ratios, etc. and tuning performance by following dense/sparse settings, cache settings, creating separate sub-accounts dimension to take the load off due to large accounts dimension as well as optimize calculation scripts and data loads/retrievals.
• Maintaining daily data backups and weekly Application backup processes.
• Performing weekly, monthly and yearly activities such as archiving, monthly actual load.
• Performing monthly downtime on Hyperion Development and Test Servers. This is done in order to upgrade Operating Systems and security related software. And monitoring Hyperion Applications to see if there is any malfunctioning in Software or any issues in performing the tasks.
• Performing Quarterly Downtime on Hyperion with the IT team to check if all the upgrades on production server are done successfully and not affecting the Hyperion Applications.
• Installing Essbase add-in, Smart View and Essbase Ribbon for users.
• Optimized the Essbase Config. files for faster retrieval and loading of data
• Restoring database from backups and importing current data (created after backup points) whenever database corruption or failures occur.
• Synchronizing test environment with Production so as to keep the applications using LCM
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Was responsible for handling the Hyperion server to keep online 24X7.
• Training users on Hyperion System.
• Developed reports for users to view the data in the planning applications using Hyperion Financial Reports.
• Monitoring Hyperion Services and making sure that every month financial reports are running and sent to the financial super users.

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Financial Reports 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Smart View 11.1.2.1, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Sr. Hyperion Consultant

Confidential, Hoboken, NJ

Responsibilities:

• Coordinated with client to understand the business requirements.
• Created functional specifications based on the requirements for each Business unit.
• Involved in creation of technical design document based on the functional specification.
• Created POCs for each Aggregate Storage Option (ASO) and set the properties for each dimension based on the technical specification.
• Worked on MDX queries to View dimension for Dimension type "Time" to avoid DTS as per the requirement
• Changed Compression Dimension and used TB properties to enhance performance
• Created MaxL scripts to load dimension rule files and data files.
• Tested Smart View compatibility with MS excel - 2010
• Analyzed hierarchies for Entity dimension and worked on the removal of the Alternate hierarchies present in Entity. Created separate dimensions for each alternate hierarchy.
• Created schemas for Essbase studio to create outline for ASO cube.
• Tested Essbase studio 11.1.2.2 to check drill through reporting on Transactions and Balances.
• Identified problem areas of MDX member formulas and Used NONEMPTY DIRECTIVES appropriately, to enhance performance of MDX codes.
• Designed and materialized aggregation using query tracking and ratio method and automated the aggregated view creation.
• Created functional design document for planning application based on the present HFM applications as per the business needs.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, Essbase Studio 11.1.2.2 Essbase Administration Services (EAS), Shared Services, Hyperion Smart View 11.1.2.1, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Sr. Hyperion Planning Consultant

Confidential, Chicago, IL

Responsibilities:

• Maintenance, enhancement and optimization of existing 4 planning applications as part of Exelon's Financial Planning Budgeting and Forecasting (PBF) team
• Creating scripts to utilize Hyperion Planning utilities for automation of planning processes
• Developing business rules to accommodate new accounts and sub - accounts flowing through the planning applications from various feeds for the purpose of forecasting, budgeting, consolidation and allocations
• Designing and developing user friendly data loading processes by incorporating Essbase Excel add-in, and VBA
• Assessing different scenarios and designs for building integrated Hyperion Planning applications to process financial data coming from acquired company (Merger & Acquisition)
• Conducting demos and Q&A sessions for new functions/utilities available in version 11 to assist business and higher management in the upcoming upgrade project from Hyperion version 9.3.1.3 to 11.1.1.3 and 11.1.1.3 to 11.1.2
• Improving response times of Hyperion Planning webforms by modifying webforms design settings, implementing Hyperion Planning web application server HspCompression filter, adjusting JVM heap size and optimizing business rules associated with the webforms
• Designing and developing tools by utilizing Essbase Excel add-in to automate movement of subaccounts between different Hyperion Planning forms so that maintenance overheads due to a large amount of these requests is significantly reduced
• Providing troubleshooting methods, root cause analysis report and support for issues relating to theHyperion Planning applications for example: data loading issues, metadata mismatch with source and target systems, cleaning up dirty blocks produced by calc scripts accidentally run by business users using STAR Analytics, webforms and associated business rules function and availability, security filters for different groups
• Facilitate enhanced response timings and performance of web-forms which are the critical means of user input for the planning, budgeting and forecasting
• Facilitate enhanced response timing and optimization of BSO/ASO Cubes by optimal setting of dense/sparse dimensions, tuning of cache setting, and buffer setting, tuning calc scripts.
• Optimized the Essbase config files for faster retrieval and loading of data.
• Automated backups and archive of database in nightly process.
• Handle large database size around 30GB and wrote batch scripts for automation of restructuring of the cubes.
• Handle Invalid Block headers in Essbase Cubes by performing repairing, restoring cubes from the backup
• Was responsible for handling the Essbase server to keep online 24X7 by recycling the services .when ever required and handle instability that occurred.
• Development and maintenance of business rules and calc scripts to derive complex calculations such as project splitting, allocations and auditing
• Developing processes to remove hard-coding in many of the business rules and calc scripts by introducing new Attributes to the Hyperion planning applications and maintaining them in an fashion which is easy and flexible for business users
• Developing MaxL script to automate the cube build process and wrapper shell scripts to integrate all the MaxL scripts into it
• Creating tabular and cross tabular reports, Chart Reports and manipulating query results with Interactive reporting studio
• Creation and maintenance of Knowledge Transfer documents, Functional and Detailed Design documents and Migration documents

Environment: Hyperion Planning 11.1.1.3, Essbase 11.1.1.3, Hyperion Workspace, Hyperion Shared Services, Hyperion Interactive Reporting 11.1.1.3, Hyperion Smartview for Office, Essbase add-in, Hyperion Web Analysis, STAR Analytics, Oracle Data Integrator

Sr. Hyperion Developer

Confidential, Calhoun, GA

Responsibilities:

• Participated in defining requirements from the end user, functional specifications, design documentations and test strategies
• Created schema/user for the Hyperion database and managed the Hyperion servers.
• Designed and developed Planning application facilitating Budgeting and forecasting.
• Involved in creating the load utility files for the dimension member loading and the data loading into the application.
• Created web forms for the user inputs which were tuned by creating the attribute and substitution variables.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Actively Designed and configured Hyperion planning and FDM applications.
• Developed Oracle GL Interfaces using Hyperion FDM so as to load the data in the Essbase Applications.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM.
• Set up locations and import formats, including import scripts and formats for general ledger data generated by FSG in Oracle GL, as well as headcount data.
• Rewrote import formats and scripts to handle fixed width file, instead of delimited.
• Created a custom authentication provider, which uses Active Directory, to control access to FDM and Configured users and access rights in FDM
• Created maps to handle sign flips for some accounts
• Created and managed numerous Business Rules and Member formulas for application.
• Developed Data Load and MaxL scripts. Created data load files for loading client and department data. Also MaxL scripts were created to automate the same.
• Designed currency conversion Rule to facilitate reporting in more than one currency.
• Developing user friendly data loading processes by incorporating Essbase Excel add - in and UNIX scripting
• Provided training to end users in using the MS Excel spreadsheet add-in and Web forms to enter data.
• Involved in user access provisioning and the security filter on the system. Assigned accesses and privileges to various end users in different planning applications using Shared Services.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA 11.1.1.3, Hyperion Smartview, Workspace, Hyperion Financial Reports 11.1.1.3, Hyperion Shared Services 11.1.1.3, Financial Data Management(FDM), MS SQL Server 2005, Windows XP,Linux.