SUMMARY:

• ESSBASE developer with 11+ years combined experience in general application development and as a Hyperion Administration.
• Strong ability to work with of Hyperion Financial Management System11,BI reporting applicationwith the majority of the experience. resolution of system errors, Budget planning forcasting, object administration.
• Over 5 years of in depth experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion ESSBASE 11.X/9.X/7.X/6.X, ESSBASE Integration Services, Finacial Reports, Hyperion Interactive Reporting, Object Oriented Programmnig, ESSBASE Spreadsheet Services, under Windows 2000/XP and Unix Environment.
• Experience includes all aspects of ESSBASE cube development and maintenance: Design and optimization of Block Storage & Aggregate Storage ESSBASE applications, developing OLAP Models and Meta - Outlines, using data load rules, developing calculation scripts and report scripts and partitioning of databases.
• Skilled in automation, optimization and performance tuning of ESSBASE application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Experienced in writing custom ESSBASE calculation scripts and automating the ESSBASE cubes using MaxL, ESSCMD and QA, Code Scripts.
• Knowledge of Base Dimension,Business Rules,data integration workflow,reports,smart view.
• Strong SQL skills, RDBMS development knowledge and understanding of relational data marts.
• Extensive knowledge and understanding of all the phases involved in Software Development Life Cycle (SDLC), whether an existing system is being modified or being developed from start.
• Strong analytical and organizational skills with an ability to deliver on agreed timescales. Demonstrated experience of working in a team environment.
• Excellent communication, documentation and presentation skills.

TECHNICAL SKILLS:

OLAP Tools: Hyperion ESSBASE 11.x/7.x/6.x/9.x, Hyperion ESSBASE Integration Services, ESSBASE Administrative Services, Shared services.

Reporting Tools: Hyperion planning implementation, intractive reporting Hyperion Reports 2.x/7.x, SAP/Excel to Hyperion

Databases: Oracle 8i/9i/11i, SQL Server 6.5/7.0, MS Access

Operating Systems: Windows 2000/XP/NT, UNIX (AIX, HP)

Languages: SQL, Perl, KSH, AWK

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Webster,NewYork

Sr. Hyperion Developer

Responsibilities:

• Coordinating with Client and Business Analyst to understand and develop an Optimized Cube. involved in gathering requirements and developing a project plan.
• Base Dimensions, Business Rules, data integration workflow, reports, smart view
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE 7.1.
• Developed Transparent partition with ASO & BSO cubes to leverage the advantages of both technologies.
• Developed load rules for loading data files and for dimension build.
• Implemented robust data-access security and user management.
• Created various filters as per user requirements in EIS.
• Automating of cube refresh through MaxL and Unix scripts.
• Restructured as well as maintained existing ESSBASE cubes.
• Optimized QA, Code,business analyst Scripts.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Optimized the applications to bring down the runtime considerably.
• Retrieve reports using Excel add-in and generate reports out of batch in Hyperion Reports.
• Utilized Java web-client user interface of Hyperion Analyzer 6.5 for creating Marketing Analysis reports.
• Routine maintenance of the OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing documentations required.

Environment: Hyperion ESSBASE 7.1/6.5, EIS 7.1, Hyperion Analyzer 6.5, Hyperion Reports 7.0, Hyperion ESSBASE Excel Add-in, MaxL, MS Excel 7.0/2000, AIX UNIX 5.2.

Confidential, NY

Sr. ESSBASE Reports Developer

Responsibilities:

• Created reports using Hyperion Financial Reports and Smartview (Excel Add-In) from HFM (Hyperion Financial Management) and HP (Hyperion Planning).
• Wrote various Balance Sheets, Cash Flow, Income statement, Expense, Operations Reports for different entities.
• Used various functions like Variance, Relative Member, PercentOfTotal.
• Created numerous templates which were used to design similar other reports.
• Resolved some of the outstanding and all the current issues reported by users.
• Tested and Cross tested all the reports before publishing.
• Maintained User and Groups for reports defining users and groups and assigning them roles/access privileges.
• Designed and developed various kinds of reports like Long, Medium and Short versions for all the divisions and entities.
• To enhance the look and feel of the reports, used functions like Conditional Suppression, Conditional formatting for all the reports.
• Used functions like User POV and Prompt to cut down on the number of reports.
• Extensively used various Member Lists to develop the reports.
• Extensively created numerous workarounds to make reports possible to create.
• Helped owners of reports to make their reports more efficient in performance, ease of use and for future maintenance.

Environment: Hyperion ESSBASE System 11, Hyperion Financial Management System11, ESSBASE Administration Services, ESSBASE Excel

Confidential, San Francisco, CA

ESSBASE Developer

Responsibilities:

• Developed and maintained ESSBASE cubes in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
• Translated end user requirements into application design specifications and maintained applications to support user requests for modifications to current Excel Reporting.
• Developing the Rules Files, MaxL, Report Calculation scripts.
• Automated the cube build process using MaxL & Batch scripts.
• Optimized structure and loading through appropriate storage allocations and also optimized calculations scripts.
• Managed system upgrades and client installations based on users’ requirements, extensively involved in upgrading current 7.1.6 Hyperion environment to system 9
• Involved in development of four cubes - one for Sales, one for Production Planning and Budgeting, one for Market Research and one for Customer Analysis
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Developed Reports for monthly P&L reports, Sales Analysis reports.
• Designed reports in Hyperion Interactive Reporting, including creating queries, chart reports, table and pivot reports, and dashboards.
• Created Monthly, Quarterly and Yearly Reports for Balance Sheet and Income statement using Interactive Reporting.
• Prepared profitability reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Documented procedures pertaining to ESSBASE applications

Environment: Hyperion ESSBASE 11.X, ESSBASE Administration Services, ESSBASE Excel Add-In, Hyperion BI+, Hyperion Interactive Reporting System 9, Hyperion Analyzer 7.0, Windows XP, Unix AIX 5.3.

Confidential, Boston MA

ESSBASE OLAP Developer

Responsibilities:

• Developed the project plan for the implementation that identifies the schedule, task, milestones and requirement.
• Created dimension building load rule and data load Rule for dynamic dimension building, attribute dimension building and data loading in ESSBASE.
• Worked on ESSBASE Application Manager and created OLAP models and Meta-Outlines.
• Involved in performing DBA activities like create users, password setting, group and filters.
• Involved in making the ESSBASE backups and restores of ESSBASE application. Implemented robust data-access security and user management.
• Extensive usage of substitution variables and setting appropriate values in them.
• Implemented ESSBASE in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.

Environment: Hyperion ESSBASE 6.5.4, EIS 6.5, Microsoft Excel 2000, Oracle 8i, PL/SQL, SQL*Loader, MS SQL Server 7.0, Windows NT 4.0.

Confidential, Edina, MN

ESSBASE Developer

Responsibilities:

• Coordinating with Client and Business Analyst to understand and develop an Optimized Cube.
• Developed and maintained ESSBASE cubes in connection with sales forecasting and marketing analysis to produce customer profitability reports
• Translated end user requirements into application design specifications and maintained applications to support user requests for modifications to current Excel Reporting.
• Developed the Rules Files, MaxL, Calc Scripts to calculate various figures for the outline, which included Operating Expense Analysis, and Allocation Analysis.
• Involved in development of cubes - For Financial Reporting, Market Research and for Customer Profitability Analysis.
• Developed Reports for Distribution Centers, Customer P&L reports, and Sales Analysis reports.
• Performed testing though Excel add-in, and developed test cases.
• Documented procedures pertaining to ESSBASE applications For Planning and Testing.
• Provided technical guidance and support to end-users by developing documentations required.
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage.

Environment: Hyperion ESSBASE 7.2.5, ESSBASE Administration Services, ESSBASE Excel Add-In, Hyperion BI+, Hyperion Reports 7.2.5, Windows 2003.

Confidential

ESSBASE-Developer

Responsibilities:

• Utilized professional communication skills by consulting with clients on user needs, and analyzed their business requirements in converting draft outlines into technical and functional specifications of ESSBASE.
• Installed Hyperion Planning and operated Hyperion Reports and Analyzer to produce sophisticated reports on the Web that contained Measures, Markets, and Product information for financial management teams.
• Generated reports of Forecast Trend, Comparative Performance, and Stock Exchange for and their business partners.
• Developed Calculation Scripts and Member Formula for enhanced performance on computer systems.
• Worked with team member to Utilize ETL (Extract Transform Load) tools to enable data reformatting to migrate from multiple sources into data warehouse and Hyperion ESSBASE for analysis to support business processes and requirements.
• Retrieved various data records from ESSBASE cubes by using Hyperion Reports.
• Created Maxl scripts to automate data loading and to calculate the ESSBASE cubes.
• Generated rules files to accurately build dimensions and load data according to client requirements.
• Documented all ESSBASE changes, automation scripts, and optimization processes for other ESSBASE users to coordinate in developing the database system. Environment: Hyperion Planning(4.x), Hyperion Analyzer(7.x), Hyperion ESSBASE(6.x/7.x), Hyperion Reports(7.x), MaxL commands and scripts, ESSBASE Excel Add-In. ICCI BANK, Pune India Hyperion DeveloperEmployers seek to maximize investment gains while obtaining tax-favored treatment for both the employer and the employees. Project involved design and development of various modules for the trust-owned life insurance (TOLI) product. The product is a typical client/server application running on Windows NT environment, being developed in Visual Basic 6.0 and Oracle 8i.Role & Responsibilities:
• Played a lead role in the estimation, design and development of several modules of the product like Stable value option, Contributions/Withdrawals and Surrender/Termination.
• Extensively worked with Oracle Packages, Procedures and Views.
• Developed DTS jobs to feed data from SQL Server to Oracle. Developed data transfer procedures to manipulate data in Oracle.
• Also played an important role in performance enhancement and optimization with Oracle.