Introduction:
Almost 4 years of experience in the field of Information Technology. This includes pioneering work in analytical software applications, Business Analysis, Requirements, Development, Testing, and Database Administration of OLAP and Client/Server projects using industry accepted methodologies and procedures.
Experience Summary:

• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 9 BI+, Essbase Analytic Services, Hyperion Essbase 11.X/9.X/7.X, Essbase Administration Services, Hyperion Planning 11.x/9.x/4.x.
• Good experience in Hyperion Reports and Essbase Excel Spreadsheet Add-In on Windows and UNIX environments.
• Experience in performing upgrade, Maintenance, database backups, Performance tuning and Optimization.
• Experienced in developing numerous cubes from conceptual stage, designed Essbase MDDB applications, OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions.
• Extensive experience in writing calculation scripts using ESSCMD and MaxL.
• Worked on Financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and developed Financial Budgeting and Forecasting OLAP applications.
• Experienced in the functionality of various modules of Hyperion Intelligence / Brio.
• Good knowledge of reporting tools like Business Objects, Congo’s EP7 series and Congo’s Report net.
• Good experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
• Strong communication, organizational and interpersonal competencies, adapt to change and a quick in learning new versions and applications.
• Strong knowledge in Oracle, SQL Server, MS Access.
• Extensive knowledge of Hyperion Financial Management.

Technical Skills:

BPM:

Hyperion System 11.x/9.x/7.x

OLAP:

Hyperion Essbase, Hyperion Planning, Essbase Integration Services, HFM, Hyperion Hub.

Reporting Tools:

Hyperion Analyzer 7.2, Hyperion Reports 2.0/2.5/7.0, Essbase Spreadsheet Add-In, Seagate Crystal Reports (6.0)

Languages:

HTML, DHTML, XML, Visual Basic 6.0,PL/SQL,SQL

Software:

Lotus Notes R5, Domino Designer, MS Office , MS Visual Basic, MS Project,

Database:

MS Access 7.0/2000/97, Oracle 8i/9i, MS SQL Server 2000/7.0

Operating Systems:

Windows 98/2000/NT, Unix, Solaris 8.x

Certifications:

• Hyperion Essbase 9.3 Developer Certified Expert.
• Hyperion Planning 9.3 Applications Administrator Certified Expert.

Education:

• Master Of Science in Electrical & Computers Engineering
• Bachelor Of Engineering

Project:

Database Design and Application:
Organization: Confidential,Carbondale, IL.

Confidential,that works to train caring and competent doctors, and develop new models for providing health care in rural areas.
Database contains brief history about the doctors’ like their name, email address, their phone numbers, doctor license number, etc. It also keeps track of other information like doctors’ on call hours (hours in which the doctor works), number of patients examined, their examination room numbers, etc.

Responsibilities:

• Designed the database ER diagram depending upon the requirement using MS Visio.
• Implemented the database in MS Access from the ER diagram.
• Inter linking different tables based on the design.
• Gathered the data from hospital authority and uploaded them in to the database.
• Performed various tests to check the accuracy of the database.
• Created various queries and generated reports depending up on request.

Environment:
Windows XP, MS Access 2007, MS Visio 2007, MS Excel.

Work Experience:

Graduate Assistant/COLA Lab Admin at Confidential,Carbondale, IL May 2007 – August 2008

Confidential,supervised the COLA lab. Duties include maintaining the computers up-to-date with all the latest software installations. Performing upgrades and tuning the systems available for examinations. Installing software in to computers for each department upon request.
Awarded 100% fee waive for two semesters.

Professional Experience:

Confidential,NJ May 2009 – Till Date
Hyperion Developer/Admin

Involved in the design of Reporting system for Sales and Marketing at Unilever. Using Hyperion Interactive Reporting as front end reporting and SQL Server, Oracle as back end. The system has been designed to track the Field activities, Promotional approaches, Sales and Marketing from the source systems. Extracted data from multiple sources and applied various transformations on the source data to populate the data mart. Created Management reports for sales and Marketing Departments for the Complete Analysis on the Market sales trend and Planning for the future introductions.
Responsibilities:

• Involved in the configuration of Oracle Hyperion products suite in System 9 (Hyperion Web Analysis, Hyperion Intelligence, Hyperion Planning, Hyperion Essbase, HFM, Shared Services and Workspace).
• Created the Sales and marketing reporting Data model using Brio/Hyperion Designer.
• Created different data models for Calls, AWR, and Rx.
• Designed & developed the calculation scripts to aggregate the data for different scenarios.
• Optimized the Essbase Cube to balance the calculation & retrieval performance
• Automated building dimensions, loading data and calculation scripts using MaxL
• Optimized Reports for better Retrieval Performance.
• Creating and Designing reports using Essbase in spread sheet Add-ins, Web Analyzer.
• Provided technical guidance concerning business implications of reporting applications.
• Performed the performance tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Developed the ESSCMD scripts to take backup of the database and the data load scripts.
• Developed Cubes using Pivot tables.
• Developed reports like Income statement reports, profit and loss reports, balance sheet reports, expenses reports by different alternatives, summary of claims reports, overhead allocation reports, headcount repots etc.
• Created executive Dashboards for better user flexibility
• Drill down functionality applied for most of the reports from top to bottom and bottom to top level.
• Each type of reports contains 3 levels of drill down functionality like Summary Level, Customer Level, and Territory Level.
• Control user Security via Categories and groups.
• Developed HTML Code Generator Engine in Dashboard.
• Created and Managed users, Groups.
• Published reports and published jobs.

Environment:

Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1,Hyperion Financial Management, Hyperion Financial Reports 9.3.1, Hyperion Excel Add-in, Essbase Integration Services, Hyperion Pillar, Windows 2005 server.

Confidential,MI Sep 2008 – May 2009
Hyperion Essbase/Planning Developer

Confidential,is an IT service organization with a focus on providing Consulting, Training and Solutions. Premier business partners of Lotus Development Enterprise Solutions in India. Business Partners of BRIO and Hyperion Software in India Full life cycle services and support organization.
Worked as a Hyperion consultant with Sutherland Technologies pvt Ltd (Off shore).It is an implementation and maintenance support project.

Responsibilities:

• Designed & developed the Essbase CUBE dynamically using Rule Files.

• Developed the Rule Files to the load actual data.
• Creating users in EAS and assiging security.
• Creating Applications using block storage.

• Escalating Hyperion product related issues for different clients aligning with Hyperion support documentation.
• Supporting Hyperion team for regular maintenance of Hyperion servers.
• Troubleshooting windows related problem in Hyperion products.
• Installing and maintaining Hyperion servers(OLAP server)
• Checking system requirement and designing infrastructure.
• Conceptual knowledge of UNIX commands.
• Prepared the Technical Design Document from the Functional Specification Document.
• Involved extensively in generating Daily/Monthly/Quarterly financial reports for Billing and Sales/Purchase Order processing using Hyperion Interactive Reporting.
• Designed & developed the calculation scripts to aggregate the data for different scenarios.
• Optimized the Essbase Cube to balance the calculation & retrieval performance.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Worked on various forms using Hyperion Planning.
• Used Hyperion financial Reporting 9.3.1. to create and modify various business reports.
• Provide facility to the end user to perform Web analysis like slicing/Dicing and Drill down/up in order to let the end user view data from various business angles.
• Troubleshooting Hyperion Analyzer for End Users (Report Issues).

Environment:
Hyperion Essbase 11.1.1, Hyperion Planning 11, Hyperion Financial Reports 11, Hyperion Interactive Reporting 11.1.1, Hyperion Excel Add-in, Essbase Integration Services, SQL, Oracle 9i, UNIX & Windows 2005 server.

Confidential,Hyderabad, INDIA Jan 2006 - Dec 2006
Client: Confidential,
Hyperion Essbase/Planning Developer

Initially involved in the implementation of System 9 and later worked in support and enhancement project.

Responsibilities:

• Creating database and instances on oracle 10g server.
• Installation and configuration of Oracle Hyperion products suite in System 9 (Hyperion Web Analysis, Hyperion Planning, Hyperion Essbase, Shared Services, License Server, Workspace).
• Creating EIS and Maxell scripts to automate the process.
• Creating ASO cube in Essbase using EIS.
• Creating Load rules to load data from Oracle through EIS scripts.
• Automated the whole process of loading data and members using windows scheduler.
• Resolved queries from user regarding adding new member in Essbase.
• Creating Analyzer reports using Essbase as data source.
• Resolving Issues with Analyzer like connectivity with Essbase server.
• Resolving all user related issues for Essbase and Analyzer.
• Created the Sales and marketing reporting Data model using Brio/Hyperion Designer.
• Optimized Reports for better Retrieval Performance.
• Creating and Designing reports using Essbase in spread sheet Add-ins, Web Analyzer.
• Developed the Corporate financial reports using Hyperion Analyzer, Reports.
• Developed reports like Income statement reports, profit and loss reports, balance sheet reports, expenses reports by different alternatives, summary of claims reports, overhead allocation reports, headcount repots etc.

Environment:
Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Financial Reports 9.3.1, Hyperion Excel Add-in, Essbase Integration Services, Oracle 10g, Windows NT 2005.

Confidential,Bangalore, INDIA. Jun 2004 – Dec 2005
Client: Barclays Bank PLC, UK
Hyperion Developer

Joined as a fresh graduate and undergone formal training on Hyperion Business Performance Management. Involved in the project team and performed the tasks under the supervision of Project Manager.

Responsibilities

• Installed System 9.
• Configured the Hyperion Products (Essbase Analytic Services, HFM, Planning).
• Migrated Security files from EAS, HFM, and Planning systems to Hyperion System 9 Shared Services.
• Used Hyperion Planning to create EAS applications, EAS security filters, modify existing and developed new Database outlines, Business Rules, setting up dimensions, users, user groups and their security rights.
• Involved in data mapping by using Hyperion Application Link (HAL).
• Involved in Production support (Creating users/user groups and provisioning user security from Shared Services).
• Extensively used the Report Objects like Charts, Grids, Images, and Text Boxes in Financial Reporting Studio and set up options in Property Sheet to customize the Report Objects.
• Designed the end user manuals and conducted the end user training on usage of the system (Reports, Web forms, User POV’s, User Templates, Running Consolidations and Journal Processing).
• Involved in Optimizing the Hyperion Analytic Services Database and Reports performance.
• Involved in writing Calc Scripts and Batch scripts using ESSCMD, MAXL and Unix Shell Scripts.
• Involved in Data loading, Optimizing the Data Loads and Data issues in Hyperion Analytic services.
• Worked with Dashboard Objects to customize the Sections, Graphics, and Controls.
• Worked with Design tools for layout like Design Guides, Grids, and Rulers.
• Created User Templates, Queries, Tables, Charts, Pivots and Reports using Dashboard Studio.
• Used Dashboard Studio Optimize Utility features to edit the Interactive Reporting documents for Move, Show or Hide, Lock and Unlock, Rename, and Delete SECTIONS.
• Configured and Customized Filters, Properties, Frames, Files for Spotlighting Charts, Template Structure using Dashboard Studio.
• Created Load Rules Files for loading the data and for building the Dimensions dynamically.
• Conducted Essbase performance tuning and troubleshooting activities such as periodic export and Data load, re-arranging the Dimensions for optimized performance.

Environment:
Hyperion 9, Financial Reports, Web Analysis, Hyperion Planning, Hyperion Essbase, ESSCMD, MAXL, HAL, MS Access, MS Office, Solaris 8.x, Windows 2005.