SUMMARY

• Over 7 years of professional experience in development, analysis, implementation, administration in a client-server environment.
• 5 years of experience as Hyperion Developer, hands on experience using Hyperion ESSBASE, ESSBASE Studio, Planning, ESSCMD, MAXL, MDX, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports, Web analysis, Financial Reporting Studio, HAL/ODI, HFM in Windows 2000/NT and UNIX Environment.
• Strong experience in Hyperion ESSBASE v11.x/v9.x, Hyperion Planning v11.x/9.x, Shared services, Hyperion WebAnalysis, Workspace, HAL/ODI, EIS, EPMA 11 (Enterprise Performance management Architect), MDM/DRM and Hyperion Financial Reports 11.x/9.x on windows and UNIX systems.
• Involved in Business User meetings and requirement gathering.
• Worked on deriving Functional and Technical requirements Using Business requirements.
• Worked as Financial Analysis and Reporting Systems Team Lead.
• Developed ESSBASE cubes using Block/Aggregate storage technologies.
• Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child references.
• Performed regular Database backups, Dense/Sparse settings, Partitioning (using Transparent, Replication and Linked Techniques) and ESSCMD scripts, MAXL scripts, MDX scripts.
• Hands on Experience in calculation scripts(creation , Manipulation and maintenance)
• Experience in Hyperion System 9 modules (Planning, Financial Reports, and Dashboards)
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Widespread experience in Hyperion Planning Forms, Security, Metadata Maintenance, Business Rules and ESSBASE Excel Add-In.
• Performed several administrative tasks like installing and troubleshooting of Essbase Services, ESSBASE Administrative services, Shared Services and Planning on server machines.
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, migrating fact data between different Hyperion applications.
• Involved in Several Meetings with both SAP, PeopelSoft team regarding RuleFiles, Data Files.
• Excellent communication skills with proficient expression, transmission and interpretation of knowledge and ideas.
• Outstanding team player with an aptitude to learn.

Technical skills:

Hyperion Essbase v11.1/9.x/7.x/6.x, Excel Add-In, Essbase Integration Services and Essbase Query Designer Hyperion System 9 Smart View, Essbase Excel Add In, ESSCMD, MAXL, MDX, Hyperion Reports 7.2/7.0, Hyperion Financial Reporting Studio 9.3, HAL 7.3/7.1, Hyperion Analyzer 7.2/7.0, Hyperion Performance Suite, Hyperion Intelligence 8.3

Business Intelligence Tools

Hyperion BI+ Suite, Hyperion Planning, Hyperion Application Link (HAL) and Hyperion Financial Management Suite.

Reporting Tools

Hyperion Financial Reporting, Web Analysis Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View and Hyperion Reports Scripts.

Dimensional Modeling

Star-Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.

RDBMS

Oracle 10g/9i/8i,8.0/7.0, MS SQL Server.

Operating system

Win 95/98/2000/XP/Vista/07, MS DOS 6.22., UNIX.

Languages

C, C++, SQL. PL?SQL

PROFESSIONAL EXPERIENCE:

Confidential, LA Dec 11 - Present
Role: Hyperion Consultant
Project Description: (Application Support and Maintenance) Project scope consists of providing technical support and enhancement on various IT applications being in use by different business units. These applications are developed using Essbase and Oracle as a pre-dominant database also creating reports and publishing.

Responsibilities:

• Worked on installation, configuration and maintenance of Hyperion Essbase 11.1.2.1, Administration Services 11.1.2.1, Hyperion Financial Reporting 11.1.2.1 and Hyperion Shared services 11.1.2.1.
• Strong understanding of the Hyperion System relational repositories which support front end applications.
• Involved in Business Requirement Gathering.
• Involved in Technical requirement Designing.
• Worked Closely with GL team, Accounting Team, and FP & A
• Develop Reports to enable the users to analyze the data at a level of detail using Financial Reports and Web Analysis.
• Writing Unix Scripts for Automating the Daily Process.
• Writing MAXL scripts to automate the calculation scripts.
• Performance optimization by tuning the caches.
• Developed load scripts, calc scripts, report scripts, security and overall maintenance Hyperion Planning.
• Developed financial reports like P & L, GL, Trial Balance reports.
• Installation and Configuration of the servers consisting of Hyperion ESSBASE, Hyperion Shared Services, Financial Reports, Web Analysis and Workspace.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Involved in developing design specifications of ESSBASE cube with Customers.
• Writing MaxL scripts to automate data load into ESSBASE database using Rules files.
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL API, Backup, Outline, Load rules).
• Excel Reports Using VBA.
• Developed Report Scripts for generating reports.
• User Training on Essbase Excel Add-in, Financial Reporting, Workspace.
• Providing support to the Hyperion user community.
• Experience in the Hyperion Administrator Jobs.
• Experience in leading a team of 3 in offshore and 2 onsite.

Environment: Hyperion Essbase 11.1.2.1/9.3.1, Hyperion System 9 BI+, Hyperion Analytic Administrative Services, Hyperion Web Analysis, Financial Reporting Studio 9.3.1.0, ESSBASE Excel Add-in, Financial Reporting, Unix.

Confidential, San Antonio, TX Jul 10 - Nov 11
Role: Hyperion Developer
Project Description: The Project was to create a Planning and Budgeting application to get the finance users away from excel spreadsheets and create a centralized tool to plan for all the regions with audit capabilities.

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) using ESSBASE.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to ESSBASE cube.
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases.
• Involved in installation of Hyperion Planning on Windows environment.
• Created Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation. Created and registered Planning applications in Hyperion System 9 Workspace.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer.
• Created Complex and Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks.
• Involved in Structure changes and creating Alternate Roll up's in Web Forms.
• Developed Calc scripts to calculate values like Hourly Wages, Depreciation, Benefits and Revenue.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Presented detailed analytical reports to higher administrative people using Hyperion Planning induced collaborative decision making.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in Error Handling, Trouble shooting, handling restructuring and server problems.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion ESSBASE & Planning Implementation.
• Involved in database and security refreshes in Hyperion Planning.

Environment:Hyperion System 9, Hyperion System 9 BI+, Hyperion ESSBASE 9.0.1, Hyperion Planning 4.1.1, Hyperion Analyzer , Excel Spreadsheet Add-in, Hyperion Application Link, Hyperion Reports , Workspace, Windows 2003 Server, SQL Server 2005/2008.

Confidential, Newark, NJ Oct 08 - Jun 10
Role: ESSBASE Developer
Project Description: The Project was a Operational maintenance and enhancements to the existing Essbase (ASO/BSO) applications. Responsibilities would include in creating load rules, Calc Scripts writing Maxl for automating the jobs.

Responsibilities:

• Designed, developed, and implemented multi-dimensional databaseapplication using ESSBASE & Planning.
• DevelopedOutline for the cubeand created various filters as per user requirement.
• Used ESSCMDin an interactive and batch mode to load data files.
• Developed andoptimized Data Loads and Calculations.
• DevelopedCalc Scripts to calculate various figures for the outline.
• ConfiguringODBCEnvironment Variables.
• PreparingRelational Data Sources, Consolidating Relation data & developed the OLAP model & Meta -Outlines,Implemented Star Schemaand usedEIS to interface with the company's existing Oracle data warehouse.
• Developed andmaintained Rulefiles, Calc Scripts, MaxL Scripts & Reports.
• Developed theCalc scripts to calculate complex valueslike Acquisition Cost, Gross Margin / Inventory Turn, Revenue / Payroll Hr, Total Head Count, Revenue per QTY, Revenue per Square Foot, Return on Assets, Property, Plant & Equipment, Cash Cost Per User and YTD Commitment & Variance.
• Involved inPerformance Tuningto minimize data load time.
• Analyzed all dimensions and members in the ESSBASE outline.
• Performed tuning by using theDense/Sparse settings and developed the required alternate rollups for reports.
• Responsible forPerformance Monitoring, Backup and Recovery of the cube.
• Implemented various troubleshooting procedures torecover databases.
• Developed thePL/SQL stored proceduresfor implementing the business logic.
• Constructed Oracle DatabaseTriggers and Indexes.
• Responsible for CodeReviews and PL/SQL Code Tuning.

Environment:Hyperion ESSBASE 7.1.2,Hyperion Planning 3.5, ESSBASE Integration Services 7.x, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, UNIX, Oracle 10g , PL/SQL, SQL*Loader.

Confidential, Hyderabad, India. Nov 06 - Aug 08
Role: Hyperion Developer
Project Description: Spry was introducing Hyperion to the Finance team and the project involved in creating the Technical requirements, Creating Essbase App, writing ESSCMD scripts to automate the metadata and data loads. Creating Reports on the Essbase application and publishing.

Responsibilities:

• Involved in gathering requirements and developing a project plan.
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
• Developed Batch files and Rules files to upload data from financial system's database to Essbase cube.
• Involved in creating Rule files for multi-dimensional databases.
• Worked on Data Loads and Calc Scripts.
• Implemented calculation engine that includes robust mathematical functions for computing derived data.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Implemented star schema and used EIS to interface with the company's existing Oracle 10g data warehouse.
• Designed and developed numerous applications with excellent balance of dense and sparse dimensions.
• Developed Excel Templates for user interface in Essbase database.
• Involved in system installation, configuration and software upgrades from Essbase version 6.5 to 7.1.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Used Hyperion Financial Management (HFM) for Financial Analysis and Reporting.
• Worked with Hyperion Data Integration Management
• Thorough internal training and practical experience got familiarized with budgeting system, mainframe applications and the General Ledger database.
• Used Hyperion Application Link (HAL) to establish connections between an Essbase database and Developed translation rules and used them with the translation adapter in HAL. Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.

Environment: Hyperion Essbase 7.0/6.5.1, Hyperion Analyzer 6.5, Hyperion Reports 7.0/ 6.5, Essbase Integration Services 6.5,Hyperion Financial Management (HFM), Hyperion Application Link(HAL), Cognos Report Net 1.1,Erwin 6.0, MS-Excel 2000 Spreadsheet Add-In, SUN Solaris 7, Windows NT 4.0.

Confidential, Bangalore, India June 05 - Oct 06
Role: Software Developer
Project Description: This project deals with various stages of Enhancements in the Application.

Responsibilities:

• Involved in various stages of Enhancements in the Application by doing the required analysis, development, and testing.
• Configuration ofTomcat Web Serverto authenticate and authorize the customers for the application access.
• Developed logic and code for the registration and validation of the enrolling customer.
• Developed Code forTCP/IP-Based Provisioning Server and Customer Care Billing System.
• Performed client side validation usingJavaScript.
• Developed web-based user interfaces usingServlets,JSP,HTML,andXMLbased client and server application.
• Integration of front-end withOracledatabase usingJDBC APIthroughJDBC-ODBCBridge driver at server side.
• Responsible for the development of databaseSQLqueries.

Environment: Java Servlets, JSP, Java Script, XML, HTML, UML, Rational Rose, JDBC, Apache Tomcat, JDBC, SQL Server2000, Oracle 9i, Windows.