SUMMARY

• Over 7 years of IT experience with around 4 yrs of experience in design, development and maintenance of various applications using Hyperion products in OLAP and client/server environments.
• Worked extensively on Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Excel Add - in, Smartview for Office, Shared services under Windows and UNIX environment.
• Work experience on both ASO and BSO Hyperion Essbase cubes.
• Worked extensively on creating applications, databases, Outlines building Cube Dimension Rules, Data Load Rules, Essbase Calc Scripts, report scripts, MaxL, MDX and ESSCMD.
• Experienced in scheduling Batches to run Reports, Books.
• Expertise in performance tuning and optimization of Hyperion applications, report scripts, Calc scripts using MaxL and ESSCMD.
• Extensive knowledge of upgrade between different versions of Hyperion Suite.
• Strong experience in implementing Hyperion Essbase security features, planning dimension level securities and creating user and group profiles.
• Engaged in implementation of planning application, Analytic database, Shared Services, Business Rules, and Web data entry form design.
• Estimating tests and Processes, scheduling the workflow and meeting the project requirements using Planning.
• Worked extensively in resolving production issues.
• Practical experience in Relational Databases, SQL Server, Oracle etc.
• Proficient in writing simple to complex SQL Queries.
• Highly experienced in resolving analytical issues, enormous under pressure work capabilities, an excellent trouble shooter, good inter-person skills and a very friendly in nature.

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Planning 11.x/9.x/7.x, Hyperion Essbase 11.x/9.x/7.x.

Reporting Tools: Hyperion Financial Reporting (FR), Web Analysis, Smart View for Office.

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, JAVA, UNIX Shell Scripting.

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

Databases: Oracle 10g/9i, MS SQL Server2000/7.0, DB2, MS-Access 2000.

Web-Technology: HTML, XML, DHTML, CSS, PHP and JAVA SCRIPT.

Operating Systems: Windows NT/ 98/2000/2003/ XP, UNI

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Hyperion Developer

Responsibilities:

• Responsible for creation of user groups in Shared Services, provisioning those groups with right accesses.
• Responsible for Forms and Business Rules security.
• Developed and optimized Report scripts, converted Report retrieves into CSV files to export the data into database tables.
• Ran calculations to calculate the data, loaded calculated data into different cubes to run Reports on them weekly, monthly.
• Responsible for running monthly aggregations, calculations and dynamic data loads.
• Developed Forms in Workspace, attached and ran Business Rules on them.
• Retrieved actual data stored in cubes through Excel addin to compare with the Report extracts.
• Added new members to Dimensions in Workspace and deployed them to push them into Essbase.
• Responsible for Restructure and Optimization of ASO and BSO Cubes.
• Updated Configuration Files, when changing environments (from QA to Prod, Prod to Prod).
• Developed MSH and Windows Command Prompt files to export all the Cube data and Outline for backups.
• Developed Financial Reports in Hyperion Financial Reporting Studio.
• Created xmls and batches to send monthly Reports to the respective users in PDF format and was responsible for the updates in xmls when changing environments.
• Scheduled Batches to run Hyperion Financial Reporting Books.
• Worked on Production issues like securities, alias changes, adding members, database restructures, validating the functionality on Forms by checking Business Rules, updating some of the variables daily.
• Troubleshot Production issues as and when needed.

Environment: Hyperion EAS for Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1 Hyperion Financial data management (FDM), Excel add-in, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Confidential, Mount Olive, NJ

Hyperion developer

Responsibilities:

• Developed Block Storage Cubes (B.S.O) using Oracle Essbase system 9.3.1.
• Involved in development of rules files - for performing operations on records, fields, data, dimension building.
• Optimized and tuned Database outline to increase retrieval speed of Hyperion Essbase BSO cube.
• Generation of reports using Smart view according to user requirements.
• Developed reports (monthly/quarterly/yearly) as and when demanded by the Business users.
• Designed and developed web forms for data inputs as per the business requirements using Hyperion Planning.
• Developed Business Rules and attached them to the web forms.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Created Database backup and dynamic dimensions for Hyperion OLAP Server.

Environment: Hyperion Planning11.x, Hyperion Essbase 11.x,Hyperion Analytical Services 11.x, Hyperion Shared Services 11.x,Excel add-in, Cobol reports, Hyperion Smart View for Office, Oracle 9i, and Windows Server 2003.

Confidential, Norwich, NY

Hyperion Developer

Responsibilities:

• Extensively involved in modifying the outlines for Essbase Cubes.
• Developed batch files using MaxL and ESSCMD and rule files to upload data from system’s database to Essbase cube.
• Created Database backup and dynamic dimensions for Hyperion OLAP Server.
• Developed Load Rules, for data load in to Essbase OLAP server.
• Optimized and tuned Database outline tuning 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 maintained Planning applications.
• Created numerous Planning web forms in Hyperion Planning Workspace.
• Added and removed dimension members from Essbase outline using Planning Web Forms.
• Enhancement of planning applications as per Business Process Owner's request.

Environment: Hyperion Essbase 9.3.1, Essbase Administration Services 9.3.1, Hyperion Planning 9.3.1, Web Analysis Studio, MSSQL, Windows Server 2003.

Confidential, Houston, TX

Hyperion Developer

Responsibilities:

• Designing Essbase Cubes using Blocks storage and filters for the new cube.
• Designing and developed Essbase Applications with Dense & Sparse Dimensions, arranged in hourglass model.
• Created Rule file for Dimension building and Loading data dynamically.
• Involved in issues solving like Hyperion Essbase Excel Add-In client installation, Excel add-In problems related to data extraction.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the client requirements.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Used Hyperion Analyzer to create and modify various business reports.
• Automated the Data Loading using MaxL.
• Generated reports through Excel Add-in.

Environment: Essbase Administration Services 9.3.1, Hyperion Planning 9.3.1,Web Analysis Studio, MSSQL, Windows Server 2003.

Confidential, West Kingston, RI

Oracle Developer (Offshore)

Responsibilities:

• Analyzed business requirement documents to extract data related requirements.
• Created tables, indexes, views and triggers
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Developed PL/SQL stored procedures, functions and packages for various data operations.
• Developed and Tuned SQL statements, PL/SQL triggers and stored procedures.
• Developed SQL *Loader scripts to load the data from the flat files into the database.
• Have done the troubleshooting and error handling.
• Unit tested on PL/SQL Stored Procedures, Functions.
• Tuning database and SQL statements and schemas for optimal performance.

Environment: Oracle 8i, Developer 200, PL/SQL, SQL* Loader, Windows NT

Confidential, CA

Oracle Developer (Offshore)

Responsibilities:

• Created new tables in the existing database and fields in the existing tables in the database according to new requirements.
• Designed and implemented the database as per the requirement of the application.
• Created Oracle Packages, Procedures, Functions and Triggers using PL/SQL to enforce business roles and /or relationships in data model.
• Creation of complex SQL statements performs data modeling and create/maintain and modifies complex database triggers and data migration script.
• Developed on-line context-sensitive help pages for the new users.
• Responsible for Code Reviews and PL/SQL Code tuning..
• Responsible for import and export of data using Oracle’s Export/Import Utility.
• Responsible for monitoring the day-to-day activities of the application for the performance of the database.

Environment: Oracle 8i, Developer 2000, PL/SQL, SQL* Loader, Windows NT.