SUMMARY

9+ years of experience in software industry and a wide range of progressive experience in assisting business users with design, product development and documentation, budget management and providing BI reports.8+ years of experience in data warehousing and administration using Hyperion Essbase 11.x, Reports 11.x, Planning 11.1.3.x, Planning 11.1.1.3, Interactive Reporting, HFM. Proficient in all the phases of Data Warehousing life cycle, including Extraction, Transformation, Loading, dimensional modeling, reporting and end - user support. Extensive experience in OLAP development, administration, and maintenance in a client-server environment using Hyperion Essbase 7.x/6.x,9.x Hyperion Reports, ESSCMD, MAXL, Essbase Excel Add-In and Hyperion Version 11.x smart view, Financial Reporting studio, Web analysis, ODI, DRM, EPM Version 11.1.1 OBIEE, Business Objects, ASO, BSO, MDX. Strong database development and business-intelligence modeling capabilities. Excellent understanding of Essbase calculation scripts.

SKILLS PROFILE

Application Package: Oracle Hyperion Planning, Oracle Hyperion Workforce Planning, Oracle Hyperion Capital Asset Planning, Oracle Essbase, Smart View for Microsoft Office, Essbase Add-In for Microsoft Excel, Oracle Hyperion Financial Data Quality Management (FDM), Oracle Hyperion Financial Reporting, Hyperion Interactive Reporting, Enterprise Reporting, Oracle, TOAD, SAP, Business Objects

Database / DB Tools: Oracle, SQL Server, Neteza, Teradata, MS Access, People Soft, Lawson

Desktop Tools: Microsoft Office

Operating Systems: Windows, Unix

Other: Microsoft Project Manager

PROFESSIONAL EXPERIENCE

Confidential

Oracle Hyperion Developer Consultant

Upgrade to Oracle Hyperion System 9.3.1 for Hyperion Planning, Essbase and Financial Reporting. Responsible for the coordination and project management between the internal and external project team members, providing training and knowledge transfer within the timelines.

• Upgrade Essbase 9.2 to 9.3, migration of Essbase application, database, and reports.
• Create new reports for revenue analysis using Financial Reporting studio and Interactive Reporting and dashboards.
• Working on ASO and BSO cube for financial database.
• Using Maxl script for automation, and create Bath Files for Backups, Building Dimensions, loading data, and executing calc script.
• Working on budget, revenue, salary and commission Applications.
• Maintain Application Security; assign users on shared service environment,
• Loading data and build dimension using rules files, EIS, and HAL process.
• Create Reporting and Application documentation for end users.
• Hyperion Planning Application Capex module and workforce for their budget and Planning Application.
• Calc script and business rules for budget application.
• Maintain Hyperion Planning/Essbase security.
• Installation and Configuration system 9.3.

Environment: Essbase Integration Services, System 9.2 Essbase, Smart View, HAL, Neteza, Redbrick, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10, Hyperion Planning, Lawson, AIX, Web sphere, Oracle 10g, MS Access

Confidential

Oracle Hyperion Developer Consultant

Upgrade to Oracle Hyperion Interactive Reporting 9.3.1. Gather user requirements and create new cube for supply chain department. Interact with client and provide solutions for HR database which calculated number of hrs for each employee.

• Designed, developed, and implemented Cube for Item Transaction and Reporting System for the Supply Chain Department using EIS, for better decision-making for Top Management. Complete SDLC with short amount of time.
• Create ASO cube for supply chain department and create MDX formulas.
• Involved in gathering requirements and developing a project plan for Finance Department
• Created Dynamic reports by using Interactive reporting based on the user requirements.
• Created Outlines, Calc script, Load Rules for General Ledger using Essbase System 9 Application
• Database applications Using Essbase that stored and maintained company Financial, operations, Employee, and Sales data, and also data loading and Manipulations into the database.
• Created reports (POV, Prompt in a Page, Page) based on the user requirement using Financial Reporting Studio, Web Analysis and Dashboard (Demo)
• Created Calc scripts using the Calc script editor for performing calculations.
• Maintained security and added/deleted users per management requests.
• Developed several Reports for Hyperion, validating and reconciling data using Interactive Reports and Smart View
• Convert Oracle Reports from RDBMS to Multidimensional Database through EIS by creating OLAP MODEL and Meta outline
• Used both Block storage and Aggregate Storage.
• Convert Business Object universe to Essbase cube.
• Maintain Hyperion Planning/Essbase security.
• Installation and Configuration system 9.3.

Environment: Essbase Integration Services, System 9.3.1 Essbase, Smart View, TOAD for Oracle, Teradata, Dashboard, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10g,

Brio, Visual Studio, MS Access, Business Object.

Confidential

Hyperion Consultant

Create Hyperion reports form Hyperion Planning and Essbase, Calculate churn for monthly reports. Working with end users for their new requirements during transition period.

• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Created customized and ad-hoc reports using Excel spreadsheet add-in
• Creating and calculating Subscription Acquisition Cost (SAC) Reports for Management
• Developed various management web Reports using Hyperion Reports and scheduled the reports
• Extensively involved in using Hyperion Reports, Analyze and Brio (Interactive Reporting)
• Provided technical support to business units and end users
• Retrieved data in Excel for the analysts and other end users for the purpose of forecasting and analysis
• Identifies the report as being either Fully Automated, Automated with Manual Adjustment,
• Produce Monthly, Quarterly, and Trended SAC Reports
• Create Snap Shot, Books on Workspace

Environment: Hyperion Essbase 6.5.2, Hyperion Reports, ESSCMD, Excel Add-In, Windows NT/2000, Lawson G/L, Crystal Reports, Hyperion Planning. Brio

Confidential

Essbase and Report Developer

Designed Expense Planning and Report System for the Financial Department using Hyperion Planning. Gathered the user requirements and developed an effective project plan. Developed several reports for Hyperion, validating and reconciling data using Hyperion Reports.. Responsible for the coordination and project management between the internal and external project team members, providing training and knowledge transfer within the timelines.

• Designed, developed, and implemented Expense Planning and Reporting System for the Financial Department using Hyperion Planning,
• Involved in gathering requirements and developing a project plan.
• Created forms based on the user requirement using Hyperion Planning.
• Created Business Rules, using Hyperion Business Rules, to attach the forms in order to facilitate the business process
• Database applications Using Essbase that stored and maintained company Financial, operations, marketing, and Sales data, and data loading and Manipulations into the database using the Hyperion Application Link (HAL).
• Created reports (POV, Prompt in a Page, Page) based on the user requirement using Hyperion Reports and heavy use of brio.
• Created Calc scripts using the Calc script editor for performing calculations.
• Maintained security and added/deleted users per management requests.
• Developed several Reports for Hyperion, validating and reconciling data using Hyperion Reports.

Environment: Hyperion Planning 3.5, Hyperion Essbase 6.5.4, Microsoft Excel Add In 2000, Hyperion Business Rules 3.3, Hyperion Application Link, Hyperion Reports 7.2, MS SQL Server 7.0, and Windows 2000 Server

Confidential

Essbase and Report Developer

The Essbase application provides business intelligence analysis services to Capital One finance department on cost-margin performance metrics through interactive client tools. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted, related, transformed and loaded into the Oracle data warehouse using Ab Initio and PL/SQL. Then the transformed data from data warehouse is loaded into Hyperion Essbase OLAP server to provide Business Intelligence Analysis Services. Security was implemented to control the end user data access.

• Created applications, databases and data outlines using Essbase Application Manager with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
• Involved in defining requirements, functional specifications and transformation rules
• Developed calc scripts for allocations, eliminations, moving the data, calculating formulae etc depending upon the business case
• Developed Report Scripts for extensive reporting in Report Extractor.
• Developed various management web Reports using Hyperion Reports and scheduled the reports
• Integrated data from multidimensional Essbase cubes and oracle database to create reports from financial and non-financial information
• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Involved in writing the Shell Scripts to run the batch files
• Involved in partitioning the Essbase server for optimization and tuning of the Essbase sever.
• Optimized the applications to bring down the runtime considerably
• Developed Various Maxl Shell Scripts to automate the Partitions
• Additional tasks included configuration, and production support

Environment: Hyperion Essbase 7 series, Essbase Integration server, Hyperion Analyzer 6.2, People Soft, ESSCMD, Maxl, Hyperion Reports 2.5, MS-Excel, Oracle, Windows NT, Unix

Confidential

Essbase Developer

• Created Applications, Databases and data outlines using Essbase Application Manager
• Setup and updated security at user level as well as at the application level
• Involved in analysis, design and development of multi-dimensional database application using ESSBASE that stored and maintained company's data
• Analyzed all dimensions and members in the Essbase outline
• Involved in loading and manipulation of data into the database by dynamically building outlines and using Rules files
• Extensively used ESSCMD to run calc scripts for manipulating the data and performing calculations
• Created customized and ad-hoc reports using Excel spreadsheet add-in
• Extensively involved in using Hyperion Reports and Analyzer

Environment: Hyperion Essbase 6.1/6.0, Hyperion Reports, Hyperion Analyzer, Oracle, Excel add-in, and Windows NT/2000.