SUMMARY

• Over 6 years of extensive experience in Multi - dimensional Database, Relational Database, User Interaction Design, Development & Systems Analysis.
• Highly knowledgeable, expert-level, and years of experience in the following Applications, Reporting tools, and Scripting Languages for EPM applications.
• Experience implementing/developing applications using Oracle Hyperion EPM System 11.x, 9.x, 7.x and 6.x
• Expertise in Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Oracle Data Integrator (ODI), Hyperion Financial Reporting, Smart View, Hyperion Web Analysis, ESSCMD, MaxL, Essbase Excel Add-in, Calc scripts, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts
• Experience in creating cubes using BSO (Block Storage) and ASO (Aggregation Storage) options.
• Extensive Experience designing/building Reports using various Hyperion Reporting Tools (Smart View, Financial Reporting and Spreadsheet Add-in)
• Extensive experience in installing Oracle Hyperion EPM Suite (Essbase, Planning, Financial Management (HFM), Web Analysis)
• Experience in installing and migrating applications in Version 7.x/9.x to Oracle Hyperion EPM System 9.x/11.x
• Experience in Performance/UAT testing of Hyperion Applications.
• Experience in the installation/upgrading/implementation of Oracle Hyperion Planning and Financial Management modules.
• Experience working on IIS, WebSphere, Tomcat and Weblogic servers.
• Experience working on Windows, UNIX, Linux and Solaris environments.
• Comprehensive experience developing scripts using MaxL and ESSCMD
• Created and managed Essbase users, user groups, and setting their privileges by utilizing Hyperion Essbase Security filters and Shared Services.
• Improved performance and stability of the Essbase server by adjusting configuration file and application settings.
• Used Web analysis to write financial reports with ability to drill-through feature.
• Designed and modified Essbase database outlines, dynamic calculations, calculation scripts using the Calc Script Editor, and rules files for dynamic dimension building and data loading.
• Experienced with Oracle development, Oracle Database administration, and PL/SQL.
• Proficient in creating financial reports (Forecast Budget, Balance Sheet, and P&L Statement) using the Essbase Excel Add-In.
• Querying multidimensional databases using the Query Designer.
• Have used Outline Editor to restructure and modify existing dimensions, dimension members, attribute dimensions and member properties.
• Have very good understanding and experience in writing Visual Basic/PHP/ASP.NET scripts to create dynamic web pages.
• Experienced in analyzing, designing, reorganizing, and developing with relational databases such as MS SQL server 2005, Oracle 8i, 9i, & 10g and MySQL.
• Excellent oral & written communication and analytical skills.
• Ability to work in a team environment as well as independently.
• Hands on experience with data integration from multiple data sources to Hyperion Planning and Essbase through Oracle Data Integrator (ODI)

TECHNICAL SKILLS

Oracle Hyperion: Hyperion Planning 11.x/9.x/4.x/3.x, Essbase Administration Services, Oracle Hyperion Smart View, Oracle Essbase 11.x/9.x/7.x/6.x, Oracle Hyperion Financial Reporting 11.x/9.x, Hyperion Web Analysis, Oracle Essbase Spreadsheet Add-In

Databases: Advanced knowledge of Relational Database Management System (RDBMS) databases, Oracle 10g (SQL, SQLJ, PL/SQL, SQL*plus, Oracle Reporting tool), MS SQL server 2005, MS Access and MySQL

Operating Systems: Microsoft Windows NT/ 98/2000/2003/ XP, Red Hat Linux and Solaris

Testing Tools: Win runner, Load Runner, Quick Test Professional QTP

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Essbase Hyperion Analyst and Support Consultant

Responsibilities:

• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development, tests and production environments.
• Involved in performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization, Unix shell script, Report script.
• Maintained Hyperion servers, and scripts to automate the data load process, Dimension Building, calculations and backups.
• Developed Excel VBA Macros.
• Creation of UNIX shell script, screen saver file, report script.
• Optimized Essbase cubes and calc scripts.
• Generated Reports using Hyperion Analyzer and VB scripts.
• Perform backup/ recovery on various database cubes in Hyperion Essbase system.
• Performed documentation on any changes to the Essbase cubes, data files, rules files and calculation scripts based on end-users requests.
• Restructure components in Essbase cubes in order to optimize overall database performance, calculations, and data retrieval.
• Designed several pivots, charts, tables and graphs

Environment: Hyperion Essbase 6.5.4,Oracle 10g Tools: Excel Addin, Excel Macros with VBA, Esscmd, Shell scripting, Interactive Reporting O/s: UNIX.

Confidential, CA

Sr.ODI Developer

Responsibilities:

• Installation and Configuration of Oracle Data Integrator Server.
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Used Operator GUI to schedule and automate data load processes through ODI
• Used ODI to load data into Essbase and Planning from various data source.
• Monitoring the Job and health Check of Report for correct data.
• Created Planning applications using workspace.
• Performed documentation on creating project and models in Topology and interfaces in designer and execution steps in Operator.

Confidential, NY

Sr. Hyperion Analyst

Responsibilities:

• Member of Hyperion Essbase development team, duties involve creating, redesigning, testing, documenting, reporting, protecting, supporting and administering the full life cycle of multidimensional database development using the Hyperion EPM suite.
• Dynamically designed database outlines in the Hyperion Essbase platform.
• Developed and executed calculation scripts and member formulas.
• Performed automation of the process of adding members to an existing outline using ESSCMD commands.
• Used Hyperion Reports tool to retrieve data from Hyperion Essbase and present them graphically (charts), also have modified existing reports within Hyperion Reports upon business tactics.
• Perform backup/ recovery on various database cubes in Hyperion Essbase system.
• Used Hyperion Analyzer to develop and maintain various traditional and non-traditional financial reports.
• Adjusted and reconstructed the Essbase database outlines in order to optimize data loading time, database performance, and database size. To reduce calculation time, Intelligent Calculation was utilized.
• In order to load data into the Essbase cubes, wrote SQL statements to extract data from MS SQL server.
• Written financial reports such as Income Statement and Balance Sheet with the drill-through feature where users can drill-down to journal entry level data.
• Substitution variables and UDAs were used for formatting and automating process monthly reports.
• Formulas and Functions were used to drive data requested by financial team and to give multi-dimensional view.
• Performed usability evaluation and user acceptances test on all the Hyperion Financial Reports.
• Dashboards were created to help novice and technologically challenged users to carry out their daily tasks.
• Integrated FDM to HFM and Planning for loading Data.
• Designed Reports against HFM.
• Involved in implementing the HFM 11.1.2 application
• Wrote the Rule file for translations and calculations in HFM Application.

Confidential, NY

Sr. Hyperion Developer

Responsibilities:

• Proposed a business plan to implement Hyperion System 9BI +
• Installed Smart View and integrated with Microsoft products (Excel and Word)
• Created, changed, and deleted users and groups, and granted them with privileges on the Essbase applications, databases, and subsets of databases.
• Performed documentation on any changes to the Essbase cubes, data files, rules files and calculation scripts based on end-users requests.
• Worked with Financial team to gather business requirements and convert those requirements to design Essbase applications.
• Based on the business strategies, designed and altered the Essbase cubes’ outline, data files, rules files, calculation scripts, and member formulas dynamically on the Essbase Application Manager.
• Loaded free-form data into the Essbase cubes using the Prep-Editor
• Used MaxL Scripts to create applications, databases, and calculations scripts.
• Installed Hyperion Reports on UNIX and configured it with Oracle 9i and Hyperion Essbase.
• Utilized the Hyperion Reports tool to generate traditional financial reports such as balance sheets, profit and loss statements, and cash management reports.
• Made use of Query Designer to produce reports (i.e. quarterly forecast and annual budget) to support financial users.
• Hyperion Analyzer was used to run fast, accurate, and ad hoc reports.
• Restructure components in Essbase cubes in order to optimize overall database performance, calculations, and data retrieval.
• Used Hyperion Application manager tool to monitor Hyperion Essbase performance and determine whether configuration need to be adjusted.
• Tuned Essbase cubes for better performance using Dense/Sparse settings.
• Performed weekly application and database backup.
• Provided training, support and guidance to novice Hyperion Essbase users
• Performed data entry on Hyperion Planning creating forms to accomplish flexible data collection and analysis
• Several web forms were created in Hyperion Planning base to accommodate senior level staff’s requests
• Maintained security for Planning, Business Rules and Essbase

Confidential, Jersey City, NJ

Hyperion Planning & Essbase Developer/Administrator

Responsibilities:

• Involved in project case study by interacting with the Business users and Data Team.
• Implemented Business Logic Layer, Data Access Layer and User Interface Layer (GUI).
• Building Classic Planning Application for Global HR and Finance Team.
• Creating Business Rules for expenses calculation.
• Building cubes by creating Rule files for dimension building and data loading from Oracle database.
• Creating shell script and MaxL script for automation of the Data load and dimension build process daily and weekly basis.
• UNIX job monitoring in Autosys tool.
• Creating Custom calculation script and Report scripts and Building expenses and variance reports in Financial Report.
• Monitoring the Job and health Check of Report for correct data.
• Reporting and security access to user through Clarity Performance Management tool.

Environment: Hyperion Planning 9.3, Hyperion Essbase 9.3, Hyperion Administration services, Smart View, Oracle 9i, and Autosys. OS- UNIX

Confidential, TX

Esssbase Developer and System Administrator

Responsibilities:

• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase
• Excel Add-Ins and Hyperion Analyzer for development, tests and production environments.
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
• Maintain Hyperion Servers, create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups.
• Creating Calculation scripts, MaxL script for process automation.
• Migration to new production server and supporting end user, planners for budgeting.
• Daily and weekly back up process as well as Data loading job monitoring.
• Reporting using Excel add-in, Hyperion Analyzer.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using HAL.
• Loading planning data using planning desktop and smart view client.

Environment: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, Shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential 

Essbase & Report Developer

Responsibilities:

• Generated Scorecards using System 9 Interactive Reporting Studio.
• Formatted the query results to get required data for implementation of business logic.
• Designed several pivots, charts, tables and graphs
• Automate the export process from dashboard to excel sheet.
• Extensively used Dashboard Studio to merge and integrate discrete dashboards into an Application.
• Worked with Dashboard Architect to debug and manage objects, items and scripts.
• Created scripts for managing Interactive Reporting Document (BQY) start-up, shut-down processes.

Environment: Languages: Java Script, VBA, Pl/Sql, Database: Hyperion EssBase 7.1.2, Oracle 8i