SUMMARY

• An accomplished professional with a background as an Oracle Hyperion Consultant with 7 years of experience in diverse corporate environments, applying strong business intelligence, technical and communication skills, possessing a knack for consistently recognizing technical issues and adequate troubleshooting skills.
• More than 7 years of experience in I.T. industry with 6 years as a Hyperion Consultant, hands on exposure to Data Warehouse and OLAP software systems design and implementation.
• Deep expertise in various Oracle EPMA technologies and areas such as Hyperion Essbase 11.1.2.x, 11.1.1.x, 9.x, Planning, Workspace, Shared Services, EAS, EIS, Hyperion Financial Management, MaxL, MDX, Excel Add - in, Interactive Reporting, Smart View.
• Strong experience in creating complex Calc Scripts & Business Rules, Data Forms, Task Lists, Menus and Smart Lists.
• Experienced in design of Multi-Currency applications for large corporations operating in several countries.
• Experienced in design and maintenance of multidimensional cubes involving both BSO and ASO storage types and Partitioning.
• Skilled in Optimization (optimize Essbase caches, restructuring, dataloads, calculations and reports) and Performance Tuning of Essbase applications.
• Centrally managed and collaborated financial information and processes with Hyperion Financial Management (HFM).
• Expert in developing application security process, creating users/groups, security profiles and application access to different groups using filters.
• Manage Application, Metadata changes, Rule changes, Member list changes, Journals, Reports and security.
• Automation of daily tasks through MaxL and Batch scripts.
• Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules.
• Strong communication, organizational and interpersonal competencies along with detail­ oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS

Hyperion Modules: Hyperion Essbase, Planning, HFM, FDM, DRM, EAS, EIS, Shared Services, Workspace, Smart View, MaxL, MDX, EssCmd, Business Rules, Interactive Reporting.

Business Intelligence: Business Objects, Crystal Reports, Xcelsius, Tableau, ETL, Informatica, OBIEE, PeopleSoft, ODI

Project Management & Process Designing: MS Project, Rational Rose, MS Visio

Databases: SQL Server 2005/2008, Oracle 10g.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Document Management: SharePoint

Operating Systems: Windows 7/XP/NT/2000/98

Office Software: MS Word, MS Excel, MS PowerPoint, MS Access

Programming Languages: Visual Basic, ActiveX Technology, COM, ActiveX Data Objects (ADO), Active Reports, Data Reports (Having working knowledge of JAVA, C++, HTML)

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Hyperion Consultant

Responsibilities:

• Supported already developed applications which include 5 Hyperion Planning apps, 9 Essbase BSO apps and 7 Essbase ASO apps used for reporting and analysis.
• Support daily automated batch jobs which run on Unix environment, handling job failures and random server issues.
• Update variables/filters at the start of every month, backup/backfill Actuals data to different cubes, load Forecast data in concerned cubes, change access levels as the current outlook changes, etc.
• Coordinate batch job activities with the offshore team, ensure that 24*7 support is in place, hand-off pending jobs to the off-shore
• Updating dimensions, metadata, calc scripts, business rules, etc. to match ever changing requirements, translate the new business requirements into tweaking/developing applications.
• Developed two new cubes, migrated from Dev to QA server to Production.
• Develop complex MDX scripts to match the business, optimize ASO cubes for efficient reporting.
• Implemented buffers to speed up the data loading process, created the SQL config file to enable parallel data loads using buffers.
• Resolve issues related to planning apps, modify business rules, security, user access/groups, etc.
• Based on Scrum methodology, attend daily stand up meetings, Version One to implement Scrum.
• Worked with Subject Matter Experts (SME) and business analysts to gather the business requirements during development stage.
• Executed performance tuning and optimization of both the data retrieval and data loading scenarios.
• Provided 24*7 Production support to existing applications and also performing enhancements as required.

Environment: Hyperion planning 11.1.2.3, Essbase 11.1.2.3, Hyperion DRM, Hyperion smart view, Oracle 11g, Oracle Applications, MS Excel Add-in, VB Scripting

Confidential, Maitland, FL

Hyperion Consultant

Responsibilities:

• Developed Hyperion Business Rules with Run - Time Prompts.
• Supported complex applications for budgeting that are flexible enough to adapt to changes in the business life cycle on Hyperion system 9/11.1 planning.
• Created simple and composite data forms using Hyperion Planning.
• Created a planning application to fulfill their complex business requirements.
• Created ASO cubes to track their day to day revenue from different entities.
• Creating and updating HFM dimensions (metadata), rules, forms, grids, Smart View (Excel) Reports and other HFM system related maintenance.
• Responsible for handling security to the users and maintained shared services.
• Designed and developed several ad-hoc and financial reports using Hyperion Financial reports.
• Involved in Automation of Interactive Reporting to run in web and pdf formats and send as attachments to people across the business.
• Involved in designing and creating Multidimensional database cubes for financial and analytical business queries.
• Involved in the requirements gathering for Essbase cubes for designing and development phase using Hyperion System 9/ 11.1x.
• Provided database optimization with Dimension building, Data loading, Indexing, Calculations, Cache management and Partition management.
• Optimized the cubes memory by changing Dense/Sparse configuration and changing the cache related to Essbase applications.
• Strong knowledge of ODI to retrieve data from various source systems and the output them to Hyperion Essbase applications.
• Migration of Financial Reports and Web Analysis Reports from one environment to another i.e from dev to test and from test to prod and vice versa.
• Administering security, user creation with Native and External Authentication, Filters, dimension level security and Groups.
• As a techno functional consultant worked on entire SDLC of entire Hyperion Implementation.

Environment: Hyperion planning 11.1.2, Essbase 11.1.2, EIS-Integration services 11.1.2, Essbase Studio 11.1.2, Hyperion Data Integration management 11.1.2, Hyperion smart view, Oracle 11g,, Oracle Applications, MS Excel Add-in, VB Scripting

Confidential, Peoria, IL

Sr. Essbase/Planning Developer

Responsibilities:

• Analyzing business requirements and mapping them into Hyperion tools.
• Metadata, such as building metadata for Account, Scenario, Entity Dimensions.
• Loading Meta data, Business Rules and Process units using Workspace.
• Used Oracle Hyperion EPM Architect to build and maintain both Shared and Local dimensions and members for use in Profitability and Cost Management. Through the Dimension Library built the application using common dimensions and members like Oracle Hyperion Planning.
• Designing the Hyperion Model with queries joined using the Data warehouse tables.
• Implemented the EPMA v11 applications for the Hyperion modules and developed calculation scripts using calculation manager.
• Workspace was used to register the application, creating the Web data forms/data grids, Workflow, Task lists, launching business rules.
• Developed Business Rules in HFM using Visual Basic for calculating and allocating data.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Created reports for Income Statements, Balance Sheets, Key Metrics, OTC, Operating and Admin Expenses, Consolidation, Corporate P&L, Functional P&L, Revenue.
• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO option. Also, created BSO application to support Financial Budgeting and Forecasting Application. Used best practice to optimize calculation time.
• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel, Developed Excel reports using the advanced member selection techniques.
• Developed comprehensive reporting system using Interactive Reporting.
• Created Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.

Environment: Hyperion Essbase 9.3.1, FDM, HPCM, 11X, Shared Services, HFM, EIS, Oracle 11i, Calc Scripts, MaxL, VBA, Smartview, UML, MS Office, MS Visio.

Confidential, Charlotte, NC

Hyperion Essbase Developer

Responsibilities:

• Installation and Configuration of the server consisting of Hyperion System Essbase, Hyperion Planning, Hyperion Shared Services, Financial Reports and Workspace.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting using Hyperion Planning.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Wrote several MaxL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Used Smart Lists in many data forms for easy communication between the functional and technical staff.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.
• Configured Data Sources through Hyperion Configuration Utility.
• Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Created and scheduled Batch Scripts for complete automation processes for application refresh and backup.
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Assisted financial users in using SmartView to view the data and the basic concepts of multidimensional databases.

Environment: Hyperion 9.0, SQL Server 2008, WINDOWS

Confidential, Jersey City, NJ

Jr. Essbase Developer

Responsibilities:

• Obtained a detailed knowledge of the business process being followed in the project environment
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
• Used Web sphere application server for installing and configuring the Planning Web applications.
• Developed Business rules to facilitate the users to aggregate data based on user inputs.
• Developed Web forms using Hyperion Planning for various planning scenarios.
• Involved in validating the web forms for the OTC users on the consolidation cube.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in optimization and tuning of the Essbase application to bring down the calc time.
• Automated the monthly loading process using Maxl, Shell Scripts.
• Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
• Developed reports required for the business needs using Hyperion Reports and Hyperion Analyzer (ad-hoc).
• As a part of team, involved in the installation and configuration of Hyperion Essbase (6.5.3) on VMware environment to test the application.
• Extracted the business requirements from the end users keeping in mind their need for the application and prepared business requirement document as per the requirements.
• Involved in the day-to-day implementation of the Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities
• Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
• Created users, user groups in the Planning application for accessing the various application elements.

Environment: Hyperion ESSBASE 6.5.3, Hyperion Planning 3.5.1, Spreadsheet Add-In, PL/SQL and Oracle 8i

Confidential

Database Developer

Environment: SQL Server 2005, Database Queries, Scripting for Tables, Views and Data Manipulation; Data Quality Analysis and Solutions.

Responsibilities:

• Plan, design, and implement application database code objects.
• Develop SQL scripts, indexes, and complex queries.
• Perform quality assurance and testing of SQL server environment.
• Perform normalization of database.
• Identify business requirements and provide solution options.
• Ensure data integrity is maintained through security and change management.
• Coordinate between project management and development teams.
• Identify the data issues and provided solution options for resolution.
• Provide disaster recovery plans to the data services.
• Monitor entire application development, execution, and maintenance.