SUMMARY

• Overall 8+ years of IT experience with 7 years of experience in application designing and development using Oracle/Hyperion Essbase as a Developer/Analyst with analytical and designing skills
• Extensive experience in Design and development of applications in client/server environment using Hyperion Essbase 11.x/9.x/7.x, Hyperion Planning, Hyperion Essbase Integration Services, Hyperion Financial Reporting, Hyperion Web Analysis, MaxL, MDX and ESSCMD scripts, Essbase Spread sheet add - in, SmartView
• Extensive experience of designing and developing Essbase applications with balance of Dense and Sparse Dimensions
• Skilled in architecture design of Essbase cubes using Block/Aggregate storage and Partitions
• Experience in creation and maintenance of numerous applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Involved in managing the infrastructure and services supporting Business Intelligence, troubleshooting and assisting in month-end/Year-end consolidations.
• Written and implemented Calculations scripts
• Automated the Essbase cubes using MaxL, Esscmds, MDX and Batch Scripts
• Developed reports using Hyperion Financial Reports, Excel Add-in and SmartView
• Skilled in optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migration of cubes in different environment to assure security
• Developed and Implemented SQL, PL/SQL scripts

TECHNICAL SKILLS

Reporting Tools: Hyperion Financial Reporting Studio 11.x/9.x, Web Analysis 9.3, Hyperion Reports 7.2/7.0, Hyperion Analyzer 7.2/7.0, Hyperion Essbase Excel Spreadsheet Add-in 11.x, Hyperion Smart View 11.x, 9.2, MS-Excel.

Job Function: Design, Analysis, Processing, Upgrading, Maintenance, Testing

Database: DBMSEssbase 9BI+/7.x/6.x, Oracle 10i, SQL Server2012

Languages: JavaScript, C, C++, Java, PL/SQL

Operating Systems: Windows

Change Mgt Tools: TFS, Quality Centre, Selenium Eclipse, QTP

Office Tools: MS Office Suit

PROFESSIONAL EXPERIENCE

Confidential, Kettering, Ohio

Hyperion Essbase Consultant

Responsibilities:

• Involved in creating new members in outlines and optimized them by grouping and positioning.
• Modified Essbase Cube outlines and created member formulas for various Block storage cubes.
• Created and modified rule files for accommodating data format changes theirby enabling cube loading.
• Developed and optimized outlines by grouping and positioning developed rules files for dimension building and data loads.
• Created and modified various Unix scripts for data loads.
• Implemented mathematical functions for computing derived data and worked on optimization of data loads and calc-scripts.
• Developed outline formulae, calc scripts, developed MaxL and batch scripts to automate dimension build, data loading, backups and other Essbase processes.
• Developed Transparent partition on BSO cubes between source and target cubes.
• Modified and developed numerous report scripts.
• Involved in testing tasks and validating reporting data by retrieving through Excel Add-in

Environment: Hyperion Essbase 11.x, Microsoft Excel 2010, MaxL, Excel Add-In, Smart View 11.x, UNIX.

Confidential, SanFrancisco, CA J

Hyperion Systems Analyst

Responsibilities:

• Translate business requirements into application design
• Responsible for design and development of Hyperion Planning applications and related artifacts such as dimension structures, data forms, business rules, task lists, etc.
• Assist in the design and development of data interfaces and testing templates.
• Perform and assist in unit, system, integration and user acceptance testing.
• Develop administrative, user and testing manuals.
• Transfer knowledge Hyperion System Administrators.
• Involved in analysis of user requirements and finalizing dimensions for cubes
• Translated user requirements into application design specification
• Extensively Used Essbase Integration services to design develop and modify outlines for Essbase cubes.
• Modified the existing outline for some applications according to the requirements
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and dynamic calculations
• Designed the ETL process for data load into the new database from SQL tables
• Developed and ran calculation scripts to calculate complex values
• Worked in developing automation scripts using Hyperion Essbase ESSCMD, MaxL scripts and UNIX Shell Scripts
• Optimized Data load and Calculation scripts by using different techniques
• Maintained user input capabilities to the applications using Filters
• Managed application migration, established substitution variables and setting for dynamic time series, editing/validating scripts
• Handled performance tuning, weekly back-ups and monthly consolidations of data
• Automated monthly/quarterly/annual report generation
• Provided technical support for existing cubes, resolving and troubleshooting related issues and documentation
• Provided business analyst with advice and options on opportunities to leverage the tool and increase the usage

Environment: Hyperion Essbase 9.3.1, Essbase Integration Services 9.3.1, Hyperion Financial Reporting 9.3.1, Essbase Excel Spread sheet Add-in.

Essbase Developer

Responsibilities:

• Played major role in user requirement analysis, development and implementation of finalizing dimensions and members of the cubes
• Involved in defining requirements, functional specifications, design documentation and testing strategies
• Involved in designing and implementing new cubes
• Created and maintained Essbase application objects including Database outline, Calculation scripts and security settings
• Developed Rules files to upload data from financial system’s database to Essbase cube and manipulate data source file using various build methods
• Responsible for Partition databases for better data retrieval, security of databases, database migration, managed sessions and log analysis to optimize the database
• Performed tuning by using Dense/Sparse settings and developed the required alternate roll ups for the reports
• Developed SQL and PL/SQL scripts to extract and transform data into the data warehouse system
• Involved in redesigning existing cubes for overall database outline performance and optimization
• Maintained and supported existing applications, worked on production, participated in routine maintenance of applications for better performance
• Performed recovery and back up process on regular basis
• Assisted in migrating Essbase cubes
• Worked on user systems with Excel Add-in and trained users on Excel client usage
• Used Hyperion Analyzer to design reports like Balance sheets, P&L sheets, and Cash flow and Income statements

Environment: Hyperion Essbase 9.x, Hyperion Financial Reporting, Web Analysis, Excel Spread sheet add-in

Confidential

Hyperion System Analyst

Responsibilities:

• Worked as a systems analyst in the sales reporting team on various reporting tools
• Worked with Business Analysts and Business Integrators to gather requirements for various projects
• Responsible for design and development of Hyperion Planning applications and related artifacts such as dimension structures, data forms, business rules, task lists and workflows
• Designed and developed ASO cubes according to the business needs.
• Involved in modifying existing cube outlines to meet the business requirements
• Managed Data Form Builds
• Created business Rules for rolling month’s calculations and allocations
• Involved in migration of different applications across different environments
• Involved in cube and report design changes for performance and optimization
• Implemented Security through Shared Services
• Developed numerous reports using Financial Reporting and SmartView for managing business processes
• Created various reports from different databases using Web Analysis, MDX and Query Designer for management for their monthly and quarterly reviews
• Planned, coordinated, and managed the testing strategy and activities for testing of Reporting applications in Oracle Enterprise Performance Management System Version 11.1.1
• Assisted testing team with bug and defect resolutions in the testing environment
• Worked closely with production team for the end user support in resolves emergency issues
• On time completion of all assigned tasks and desirables meeting of business expectations and timelines
• Involved in Knowledge transfer and development transition to the other team members and to production team

Environment: Oracle Enterprise Performance Management System Fusion Edition 11.1.1, Oracle Hyperion Financial Reporting 11.1.1 Oracle Hyperion Web Analysis 11.1.1 Hyperion Essbase System 9 BI+, Oracle Hyperion Planning 11.x, Hyperion System 9 BI+ Financial Reporting 9.3.0.1, Hyperion System 9 BI+ Web Analysis 9.3.0.1, Hyperion System 9 SmartView for Office 9.3.0, Microsoft Excel 2007, Unix, MaxL, MDX, Excel Add-In, Query Designer

Confidential

Test Engineer

Responsibilities:

• Involved in Preparation of Test Plans & Test Cases.
• Performed all kinds of testing starting from Smoke test, Acceptance testing, System testing, User acceptance testing etc.,
• Performed Positive, Negative and Boundary testing around the application
• Performed thorough Regression testing when bugs were resolved.
• Generated reports using Excel.
• Coordinated with QA Leads during the test cycle.
• Generated Training docs for internal and Clients use.

Environment: HP Quality Center, Microsoft Excel, Outlook.