SUMMARY

• Overall 8.5 years of IT experience wif 7 years of experience in application designing and development using Oracle/Hyperion Essbase as a Developer/Analyst wif 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, Oracle Data Integrator (ODI), 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 wif 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 wif excellent balance of dimensions, developing various OLAP Models and Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.
• CreatedODIInterfaces to update HyperionPlanning/EssbaseMetadata
• 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 teh infrastructure and services supporting Business Intelligence, troubleshooting and assisting in month-end/Year-end consolidations.
• Written and implemented Calculations scripts
• Automated teh 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

Analysis Methods: Object Oriented Analysis and Design (OOAD)

Reporting Tools: Hyperion Financial Reporting, Studio 11.1.2.x/9.3.1, Web Analysis 9.3,Hyperion Reports, Hyperion Analyzer, 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: DBMS, Essbase 9BI+, Oracle 10i, SQL Server2012

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

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

Automation Tools: Maven, JUnit, SOAP UI, CVS, SVN, GitHub, Apache Ant, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Kettering, Ohio

Hyperion 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 thereby enabling cube loading.
• Developed and optimized outlines by grouping and positioning developed rules files for dimension building and data loads.
• Automated teh data loading process in Oracle Data Integrator (ODI) throughODIscheduler
• 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 Maxl, and Shell scripts to automate Nightly backup of metadata, Security and Level- 0 data
• Developed Transparent partition on BSO cubes between source and target cubes.
• Modified and developed numerous report scripts.
• Created Financial Reports using Hyperion Financial Reporting Studio.
• Supported Essbase Apps, Financial Reports, and Planning applications during month end close
• Involved in testing tasks and validating reporting data by retrieving through Excel Add-in.

Environment: Hyperion Essbase 11.1.x,Oracle Hyperion Planning 11.1.2.3,Microsoft Excel 2010, MaxL, Hyperion Shared services 11.1.1.3, Hyperion Workspace 11.1.1.3, Excel Add-In, ODI11g, Hyperion Financial Reporting Studio 11.1.1.3,Smart View 11.x, UNIX.

Confidential, Indianapolis, IN

Hyperion Essbase Developer

RESPONSIBILITIES:

• Played major role in user requirement analysis, development and implementation of finalizing dimensions and members of teh cubes
• Involved in defining requirements, functional specifications, design documentation and testing strategies
• Involved in designing and implementing new cubes.
• Created ODI Interfaces to update Hyperion Planning or Essbase Metadata and to import Essbase Data and to export data from Hyperion Essbase to File System and relational databases
• Created and maintained Essbase application objects including Database outline, Calculation scripts and securitys 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 teh database
• Performed tuning by using Dense/Sparse settings and developed teh required alternate roll ups for teh reports
• Developed SQL and PL/SQL scripts to extract and transform data into teh 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
• Involved in automationthrough MAXL, ESSCMD and Batch scripts
• Developed Load Rules to automatically validate teh data and feed into Essbase
• Performed recovery and back up process on regular basis
• Assisted in migrating Essbase cubes
• Ran Financial Reports using Hyperion Financial Reporting Studio
• Worked on user systems wif 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: Oracle Hyperion Planning 11.1.2.x, Hyperion System 9 BI+, Hyperion Essbase 9.x, Hyperion Financial Reporting Studio 11.1.2.x, Web Analysis, VBAODI11g, MaxL, Smart View Excel Spread sheet add-in.

Confidential, Coral Springs, FL

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 teh 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 noledge Hyperion System Administrators.
• Involved in analysis of user requirements and finalizing dimensions for cubes
• Translated user requirements into application design specification
• Meta data is developed in Hyperion Planning for teh actual or Budget data and loading teh data through HAL, ODI, DIM
• Created calculation scripts, member formulas to calculate Essbase database, Rules file to load data and maxl scripts to automate Essbase daily and weekly cube refresh
• Worked on Oracle data integration (ODI) platform dat covers all data integration requirements - from high-volume, high-performance batches, to event-driven processes.
• Extensively Used Essbase Integration services to design develop and modify outlines for Essbase cubes.
• Modified teh existing outline for some applications according to teh requirements
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and dynamic calculations
• Designed teh ETL process for data load into teh 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 teh 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
• Involved in creating Financial Reports using Hyperion Financial Reporting Studio
• Provided technical support for existing cubes, resolving and troubleshooting related issues and documentation
• Provided business analyst wif advice and options on opportunities to leverage teh tool and increase teh usage

Environment: Hyperion Essbase 11.1.2.x, Essbase Integration Services 9.3.1, Oracle Hyperion Planning 11.1.2.x, Hyperion System 9 BI+ Financial Reporting, ODI11g, Hyperion System 9 SmartView for Office Essbase Excel Spread sheet Add-in

Confidential

Hyperion System Analyst

RESPONSIBILITIES:

• Worked as a systems analyst in teh sales reporting team on various reporting tools
• Worked wif 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
• Loaded Metadata through Outline Load Utility OTL, and Created interfaces inODIfor data loading for actual and historical data for previous forecasting scenarios.
• Designed and developed ASO cubes according to teh business needs.
• Involved in modifying existing cube outlines to meet teh 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
• Used MaxL to load data files and automate Essbase operations
• 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 teh testing strategy and activities for testing of Reporting applications in Oracle Enterprise Performance Management System Version 11.1.1
• Assisted testing team wif bug and defect resolutions in teh testing environment
• Worked closely wif production team for teh 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 teh other team members and to production team

Environment: Oracle Enterprise Performance Management System Fusion Edition 11.1.1, Oracle Hyperion Financial Reporting 9.3.x Oracle Hyperion Web Analysis 9.0 Hyperion Essbase System 9 BI+, Oracle Hyperion Planning 11.x, ODI11g, 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

Software 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 teh application
• Performed thorough Regression testing when bugs were resolved.
• Generated reports using Excel.
• Coordinated wif QA Leads during teh test cycle.
• Generated Training docs for internal and Clients use.

Environment: HP Quality Center 9.0, Microsoft Excel, Jira.