PROFILE:

• 7+ years of IT experience with Client/Server Technology, designing and developing Data Warehouse Applications and working with Data Warehouse tools like Hyperion EPM System 11.1 / 9 BI+ tools Hyperion Essbase applications using Essbase Administration Services.
• Strong experience in system 9.x and 11.x products such as Hyperion Essbase, Hyperion Planning, Smart view for office, Web Analysis and Financial Reporting, Interactive Reporting, EPMA, DRM, EIS.
• Experience in Excel Add-in, Smart view and reports development on all financial statements, P&L reports, Income statement, Balance sheets, Sales and revenue customized reports.
• Experience in Essbase Cube Analysis & Design, Essbase Database Administration, upgrades, maintenance, database backups, Performance tuning and Optimization
• 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.
• Experience in working through test cases for Essbase, Planning applications. Experience in doing unit testing, performance testing.
• Experience in working through UAT testing and co-coordinating with teams and documentation for different projects.
• Expertise in MaxL, MDX Querying, EssCmd, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework
• Experience in knowledge transfer, preparing technical documentation, training the clients.
• Hands on experience in administering Hyperion reporting and analysis and Essbase
• Scheduling loading of data, and writing scripts to perform loads and calculations, models and Essbase Block Storage database models.
• Good understanding on the architecture of the Oracle Hyperion Products.
• Extensive knowledge on Hyperion Metadata storage information.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Excellent communication skills with proficient expression, transmission and interpretation of knowledge and ideas.
• Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS:

• Reporting tools : Hyperion Financial Reporting, Web Analysis,Hyperion Visual Explorer, Smart view, Interactive Reporting.
• Integration Tools : Essbase Integration Services (EIS), Oracle Data Integrator (ODI),EPMA
• OLAP : Hyperion Planning, Hyperion Essbase
• Operating Systems : Windows OS, UNIX.
• RDBMS : Oracle7.3/8.0/8i/9i/10g/11i, Microsoft SQLServer, MS Access.
• Scripting Languages : VB Script, Java Script, C,C++.

PROFESSIONAL EXPERIENCE:

Confidential Alto, CA July 2011-Present
Hyperion Planning/Essbase Consultant
Responsibilities:

• Involved in the installation and configuration of the new Oracle/Hyperion Performance suite 11.1.2.1.
• Involved in migration and documentation of various old legacy applications (Essbase and Planning) to the newer version.
• Involved in the analysis and implementation of user\'s needs and requirements gathering of the various work streams and tasks by meeting with the business user on a regular basis. Developed FDQM applications to provide data integrity and verifications for Hyperion applications.
• Implemented Security provided Training and Technical/Power-User/End-User documentation.
• Extensive DBA experience in activities such as filter creation, creation of users, creation of groups and related activities. Involved in analysis, development and enhancement of database outlines. Maintained application security and added/deleted users per management requests.
• Evaluated Hyperion system architecture including logical views, data hierarchies and reporting structures.
• Created different applications on Planning for Sales, Budget and Cost forecasting.
• Created Web Forms, task lists to be used in Hyperion Planning applications.
• Participated in providing the management with more flexibility to generate financial reports without relying completely on the IT team by using Hyperion Workspace.
• Authorized and authenticated users access in Hyperion shared services regularly to provide permissions to users for Planning, Essbase, Interactive and Financial Reporting.
• Designed and developed reporting solutions using Financial Reporting.
• Worked extensively on Excel Add-in for testing and templates design.
• Converted Excel based Forecasting and budgeting process into Hyperion Planning 11.x

Environment: Hyperion Essbase 9.x/11.x, Hyperion Planning 9.x/11.x, Hyperion Workspace 9.x/11.x, Hyperion Web Analysis 9.x/11.x, Hyperion Financial Reporting, Essbase Studio, Hyperion Smart view, Hyperion Shared Services, Oracle Data Integrator (ODI), Oracle 10g.

Confidential-Toledo, OH January 2010-July 2011
Hyperion Planning/Essbase Consultant
Responsibilities:

• Involved in gathering and analyzing requirements, functional specifications, design documentation and testing strategies.
• Involved in Capacity Planning meetings and project management meetings.
• Dealt with customers and data analysts in the design of Extract, Transform and Loading of data into data marts.
• Responsibilities include gather requirements, design, implement, testing, deploy planning and forecasting system that allows finance users to gather and allocate expenses, and other expenses to projects.
• Designed and developed OLAP models and Meta outlines in EIS for Essbase cubes.
• Extensively used ESSCMD & MaXL script to run automation job.
• Optimized data loads and calculation scripts by proper ordering of members in dense/sparse dimensions.
• Migration from system 9 to system 11 and migrate all the Financial and Web-Analysis reports from system 9 to system 11.
• Verified and Validated Hyperion Migrated reports in Hyperion System 11 environment.
• Installed the EPM applications Essbase 11.x, Hyperion Financial Reporting 11.x, Smart view in Windows Server 2003
• Actively participated in the installation of Hyperion Financial Management 11.x (HFM) in windows environment.
• Built information reporting/budgeting systems using Excel, Essbase and worked on building client dashboards using Web Analysis for generating reports.
• Designed and developed predefined management reports using Hyperion Reports and Web Analysis, and also generated ad hoc reports using Hyperion Excel Add-in and published in Hyperion Workspace.
• Worked on building client dashboards using Web Analysis for generating reports and also involved in developing and maintaining currency conversion applications
• Maintained security of the project in Hyperion Shared Services.
• Set up filters, user roles, and administrative privileges to access applications, reports, and database essential for Hyperion application infrastructure and maintenance.

Environment: Hyperion Essbase 9.x/11.x, Essbase Integration Services 9.x, Hyperion Planning 9.x/11.x, Hyperion Planning 9.x/11.x, Hyperion Financial Management 11.x, Hyperion Workspace 9.x/11.x, Hyperion Web Analysis 9.x/11.x, Hyperion Financial Reporting 9.3.3/9.3.1, Essbase Studio, Hyperion Smart view 9.x/11.x, Hyperion Shared Services, Oracle Data Integrator (ODI), Oracle 10g.

Confidential -Chicago, IL August 2008-December 2009
Hyperion Consultant
Responsibilities:

• Conducted several What-if analyses using MS Excel, ran advanced MDX queries using MaxL.
• Developed Load Rules, for data load in to Essbase OLAP server using Essbase Application Manager.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Performed application development tasks using Hyperion Essbase API and Hyperion Essbase Objects to manage Essbase security, partitioning, and meta-data management and change control.
• Partitioned Essbase cubes using transparent partitions, created and managed the partitions, and processed cube’s administrator and end user security.
• Used Clarity Systems template builder to create new templates to reduce the work load of the user thereby focusing on Planning, Budgeting and Forecasting.
• Building input templates and reports using the Clarity template builder for OLAP (Essbase) based and Relational (Oracle) data sources.
• Designed and built custom Clarity forms, functions, calculations and calc scripts in Essbase.
• Applied Intelligent Calculation - for calc scripts, partial calculations, and calculating data blocks and turned it off wherever it was not necessary and affected performance.
• Applied HFM to create dynamic Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Optimized and tuned Database outline tuning to increase retrieval speed of Hyperion Essbase BSO cube.
• Created Database backup and dynamic dimensions for Hyperion OLAP Server.
• Performed Essbase calc script tuning and debugging as well as enhancements.
• Populated data into STAR Schema objects to load data into cubes for creating cube outlines.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Responsible for implementation, installation, migration and validation for Hyperion Essbase upgrade from V6.5.4.2 to V7.1.6.
• Took part in the Clarity software upgrade plan and was responsible to identity any implementation, installation and interaction issues with Hyperion Essbase and Microsoft Excel.
• Responsible for identifying the complete installation process of both Server and Client modules, for both Hyperion Essbase and Clarity on Windows Virtual servers.
• Migrated the entire security on both the development and production Hyperion Essbase servers in a totally seamless fashion, with no data loss for users, groups, hierarchy and access information. This included no changes in passwords too.
• Migrated all databases (60) from V6.5.4.2 to V7.1.6, loaded data for all databases and ran calculation to roll-up the databases.
• Validated all the databases for data using standard Excel retrievals and Essbase reports.
• Responsible for the stability of servers following the upgrade, worked on resolving issues related to Virtual memory and configuration file settings.
• Built a new Hyperion Essbase database to track all users accessing Essbase production databases on a daily basis based on Essbase log file.
• Created several ad-hoc Excel macros, Access queries and SQL queries for data mining tasks for the financial team.
• Acted as the technical lead for Hyperion Essbase related issues including providing technical support for users and supervisors.

Environment: Hyperion Essbase 7.1.6/6.5.4.2, Hyperion Reports7.0, Hyperion Integration Services, Hyperion Administration Services, Hyperion Analyzer 7.0,Clarity, PeopleSoft, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, SQL, Windows NT/2003, Shell scripts.

Confidential - NYC, NY October 2007-July 2008
Hyperion Developer
Responsibilities:

• Constructed Oracle Database Triggers and Indexes.
• Analyzed all dimensions and members in the ESSBASE outline.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Administer day to day maintenance and loading of Hyperion Essbase cubes with fresh data. Re-run the jobs if they fail.
• Developed Block Storage Cubes (B.S.O) cubes using Essbase 6.1.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Build and maintained two new Essbase cubes, Corporate Planning and Sales departments.
• Worked on the accounts for Sales department and designed graphs based on the sales, exported the results to various departments for budget allocation.
• Developed and maintained Rule files, Calc Scripts and Esscmd Scripts.
• Automated Essbase Cubes through Batch Scripts using Esscmd.
• Optimization and performance tuning for Data Loads/Calculations/backup.
• Worked as a team member in Hyperion Essbase & Planning Implementation.
• Involved in database and security refreshes in Hyperion Planning
• Developed and created Web forms for users to input the data into Essbase cube through Hyperion planning.
• Presented detailed analytical reports to the upper management using Hyperion Planning induced collaborative decision making.
• 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.
• Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection.

Environment: Hyperion EssBase 6.5.4, Essbase Integration Services 6.5.,HyperionPlanning 4.0/3.5, Hyperion Reports 2.6, Hyperion Analyzer 6.5 Excel-Add-in, MS Access, Oracle 9.x, Windows 2000/NT 4.0 and UNIX.

Confidential - York, PA August 2006-September 2007
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
• Automated 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: VBA, Pl/Sql, Hyperion EssBase 7.1.2, Oracle 8i, Hyperion Brio, SPC Excel, Excel VBA Macros,MaxLscript Windows XP.

Confidential - India May 2005-July 2006
QA Engineer

Responsibilities:

• Prepared technical specifications based on user requirements.
• Prepared Test plans and Test cases based on functional and technical specification documents.
• Modified the test cases as per testing requirements.
• Involved in Functional Testing and Regression Testing of Account maintenance and transaction entry screens.
• Used Test Director to Report Bugs and upload Test cases.
• Tested the project according to business rules and specifications.
• Documented test cases, test results and test procedures.
• Involved in testing the application against different browsers such as Netscape Navigator, Internet Explorer,etc.
  

EDUCATION:

• Bachelor of Technology in Mechanical Engineering.