SUMMARY:

• Over 10+ years of IT experience with over 10+ years experience as a Hyperion Consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 11.1.X/9.X, Hyperion Essbase 11.1.X/9.X/7.X, Hyperion Planning, Enterprise Planning and Budgeting Cloud Services (ePBCS), Hyperion Financial Management (HFM) both EPMA and classic, Hyperion Financial Data Quality Management (FDM, FDMEE), Essbase Integration Services 11.1.X/9.X, Hyperion Reports, Hyperion Financial reporting studio, Hyperion Web analysis studio, Hyperion Smartview and Essbase Spreadsheet Add - In on Windows 2000/NT/2003/2008 and Unix environments.
• Commendable knowledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Designed and developed numerous cubes from conceptual stage, Essbase MDDB applications, OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions.
• Involved in conducting various steps in testing life cycle. Conducted various UAT sessions.
• Worked on financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and in building Financial Budgeting and Forecasting OLAP applications.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.

TECHNICAL SKILLS:

OLAP Tools: Hyperion System 11.1.X/9.X,Hyperion Essbase 11.1.X/9.X/7.XMicrosoft Excel Add-In, Essbase Integration Services 11.1.X/ 9.x/ 7.X / 6.x, ESSCMD, MaxL, MDX, Essbase Administration Services, Hyperion Smartview.

Business Intelligence Tools: ePBCS, Hyperion Planning 11.1.X/9.X/ 3.3.X, EPBCS, HAL, EPMA and Classic Hyperion Financial Management (HFM) 11.1.X/9.X, Hyperion Financial Data Quality Management (FDM) and FDMEE.

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/7/2003/2008

Languages: SQL, PL/SQL, C, C++, HTML, DHTML, XML

Databases: Essbase, Oracle 10g/8.x/7.x/6.x, MS SQL Server 2012/2008/2005/2000/7.0, MS Access 2000, DB2, Sybase

Internet Technologies: HP Application lifecycle Management, Rational ClearCase 7.2 and VB Script.

Reporting Tools: Hyperion Financial Reporting Studio 11.1.x/9.x, Hyperion Web Analysis Studio 11.1.x/9.x, Hyperion Analyzer 7.0, Hyperion Reports 7.0, SQR and Micro Strategy 8.2

Dimensional Modeling: Star-Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling, Erwin 4.0.

PROFESSIONAL EXPERIENCE:

Hyperion Systems Analyst

Confidential

Responsibilities:

• Involved in upgrading Hyperion System from version 11.1.2.1 to 11.1.2.3
• Involved in preparing a project plan for upgrading Hyperion system from 11.1.2.1 to 11.1.2.3.
• Managed Management reporting Essbase (ASO & BSO) applications and supported the month-end close process.
• Optimized essbase applications and various calculation scripts.
• Developed Associate reporting essbase cube.
• Developed financial reports for associate reporting.
• Developed Budget and forecasting reports.
• Followed change request process (JIRA ticketing system) for any code changes to scripts, rules, formula etc.
• Followed SDLC process for any changes or enhancements to application and reports.
• Optimized financial reports performance and developed new reports as and when required.
• Maintained operational and technical design documents.
• Maintained documentation for Hyperion Smartview for purposes (Connecting, utilizing the features etc.).
• Automated application, data, Reports and security backup process
• Migrated business rules into Hyperion calculation Manager.
• Involved in implementing EPMA HFM application.
• Involved in conducting UAT session. Supporting with any queries and access issues
• Involved in security setup and administration the application.
• Involved in implementing EPBCS.
• Involved in testing all the modules for any issues or bugs.
• Involved in documenting new features and accessibility.
• Involved in Month-end activities for Management reporting and GAAP reporting close.
• Involved in Budgeting and forecasting process.
• Managed Metadata changes for Management reporting applications(Essbase Applications), Budgeting application(Hyperion Planning, ePBCS) and GAAP reporting application(HFM)
• Communicated well in advance to respective team for any maintenance that would need down time.
• Managed user access to the financial applications and reports.
• Managed data loads to HFM via FDM in timely manner following the month end close schedule.
• Managed mappings, locations, import formats and script changes that were required.
• Involved in testing quarterly OS patch testing.
• Involved in DR test setup.
• Maintained quarterly security review documentation for all the financial applications for audit purpose.

Environment: Hyperion Essbase 11.1.x, Hyperion Planning 11.1.x, ePBCS, EPMA Hyperion Financial Management 11.1.x, Oracle Hyperion BI+ 11.1.x, Hyperion Smartview 11.1.x for Microsoft Excel, Microsoft Office 2013, Microsoft Windows server 2008 R2 Standard, Microsoft Windows 7 Enterprise, Microsoft Sql Server 2008 R2, Oracle data integrator 11g, IE 11 enterprise mode.

Sr. Hyperion Consultant

Confidential, Mettawa IL

Responsibilities:

• Troubleshooting issues and working with Oracle support as and when required.
• Involved in working with Oracle support on existing and new service requests.
• Involved in migrating and testing the applications.
• Managed metadata changes and data loads.
• Involved in maintenance of the various essbase applications and Hyperion Financial Reports.
• Involved in user management. Providing users with requested access.
• Developed various smartview and financial reports.
• Trained users in utilizing various functions in Essbase Excel addin
• Involved in maintaining essbase applications on Unix environment
• Documented the change requests, approvals for audit purpose
• Involved in setting up Disaster recovery environment.

Environment: Oracle Hyperion Essbase 9.3.x, Oracle Hyperion BI+ 9.3.x, Hyperion Essbase addin. Microsoft Windows server 2003, Microsoft Office 2010, Microsoft Window’s XP & Window’s 7, Unix AIX 5.3, IBM Websphere 6.1, IBM Http Server, Microsoft Sql Server 2005.

Sr. Hyperion Consultant

Confidential, Atlanta GA

Responsibilities:

• Lead the team of three in onsite offshore model.
• Involved in gathering requirements from the respective SME’s.
• Involved in upgrading the Hyperion system 7.1.2 to Oracle EPM system 11.1.2.0
• Involved in Installation and configuration of Oracle EMP 11.1.2.0
• Developed various maxl scripts and batch scripts for automation.
• Maintained essbase applications and achieved historical data.
• Involved in migrating static applications from one environment to another.
• Documented the migration steps for the operations team to perform the migration from Acceptance to Production.
• Prepared objects checklist to migrate the objects to production.
• Used Rational Clear Case 7.2 for version control of the data, scripts, rules, BR’s etc.
• Involved in reconciling the data.
• Involved in preparing the strategy for testing the applications and batches.
• Involved in managing security for various applications.
• Developed various Visio diagrams like architecture, batch flow, Scripts flow and sequencing of batch run.
• Developed reports for business users based on the requirements using Hyperion SmartView 11.1.2.0.

Environment: Hyperion Essbase 11.1.2.0, Hyperion EIS 11.1.2.0, Hyperion Planning 11.1.2.0, Hyperion Financial Management 11.1.2.0, Windows Server 2003, Linux, Oracle Peoplesoft Enterprise system 9.1, Hyperion SmartView 11.1.2.0, Hyperion Financial Reporting Studio 11.1.2.0.

Sr. Hyperion Consultant

Confidential, Maumee OH

Responsibilities:

• Led the team of two to support existing HFM application and enhancements required.
• Managed HFM application.
• Involved in Monthly closing cycle.
• Maintained metadata changes, data loads, and security requests.
• Conducted KT sessions with the business users and administrators.
• Documented all the operational activities and environment details.
• Followed SDLC process with any new request.
• Followed change request process for metadata changes, rule changes, MemberList changes etc.
• Involved in regular migrations of HFM applications from Development to QA environment and then Production Environment.
• Addressed numerous issues and errors with Hyperion Financial Management performance.
• Maintained user security of all HFM application in all three (Dev, QA, Prod) environments.
• Involved in creating ICP reports and financial reports and helped users with Excel templates.
• Conducted consolidations for HFM application using Task Flow Manager.
• Developed various financial reports based on the requirements gathered from SME’s using Hyperion Financial Reporting Studio.

Environment: Hyperion Essbase Administration Services 11.1.1, Hyperion Essbase Integration Services 11.1.1, Hyperion Essbase addin, Hyperion Planning 11.1.1, Hyperion Financial Reporting Studio 11.1.1, Hyperion Web Analysis Studio 11.1.1, Hyperion Workspace 11.1.1, Sql server 2005, QTP, Windows XP, Microsoft Office 2007.

Sr. Hyperion Consultant

Confidential, San Francisco, CA

Responsibilities:

• Converted various forecasting and planning tools from legacy system Mars2xl to Essbase.
• Developed forecasting tool for the Inventory management team called as IM Regv which had a write back and Actualization functionality.
• Involved in unit testing and performance testing of the IM Regv tool.
• Developed Build sheets for the business partners to have trends of the history data for each of the product.
• Developed Merchandise performance recap report to assess how each product is doing in different regions.
• Developed alternate hierarchy for one of the existing applications as part of BI enhancement project.
• Administrated various essbase applications and also various forecasting and planning tools.
• Automated multiple reports to be refreshed on a single click of a button by applying module of VB code.
• Automated the backup process for all the applications.
• Trained business partners to use Essbase addin for adhoc queries and helped them to build their own tools for different purposes.
• Involved in performance tuning of various Hyperion reports.
• Updated and supported the clarity web based reports and templates for end users use.
• Installed and configured Web analysis studio.
• Developed various reports using Web analysis studio based on the requirements gathered for the SME’s.

Environment: Hyperion Essbase Administration Services 11.1.1, Hyperion Essbase Integration Services 11.1.1, Hyperion Essbase addin, Hyperion Planning 11.1.1, Hyperion Web Analysis Studio 11.1.1, Hyperion Workspace 11.1.1, Teradata 12, Windows XP, Clarity, Microsoft Office 2007.

Sr. Hyperion Consultant

Confidential, Warren, NJ

Responsibilities:

• Developed the structure of having three ASO cubes and a BSO cube which will be the interface for the three ASO cubes developed models.
• Developed four data models and their respective Meta outlines.
• Models include models for three ASO cubes and one BSO cube.
• Created the partition between the three ASO cubes and the BSO cube. ASO cubes will act as source and BSO cube as target.
• Each source ASO cube contains the data for different scenarios such as one with Actuals other with planned data and Forecast.
• The Source cubes are fed by an hourly update of an Essbase Integration Services data mart.
• A relational data model enhanced the existing operational data store to permit drill thru to relational querying in Essbase Interactive Reporting and Excel Add-in client.
• Involved in migration of entire Development environment to Production environment
• Provided technical leadership and mentoring, helping those on the team less familiar with Hyperion System 9 to come up to speed.
• Production support issues as necessary to improve issue turnaround time as well as the customer's perception of the team's customer service.

Environment: Hyperion Essbase Integration Services 9.3.1, Essbase Administration Services 9.3.1, Hyperion Shared

Hyperion Administrator

Confidential, Dulles, VA

Responsibilities:

• As an Administrator created a security matrix design document based on the business requirements. This matrix covers five components where the security has to be setup they are Hyperion Shared Services, Hyperion Planning, Hyperion Financial Management, Business rules and Reports.
• Created users groups based on the security matrix design document in Hyperion Shared Services and assigned roles to the user groups based on the matrix document. Assigned users to the appropriate groups.
• Created automated security scripts for the Hyperion Planning applications.
• Created security classes for Hyperion Financial management applications.
• As a part of system administration group supported the clustered environments, i.e. Dev, QA and Production.
• Worked with business and technical team to come-up with the testing strategy in QTP.
• Involved in coming up with test scripts to test the security of different applications.
• Supported UAT session with needs of access to the users to complete testing.
• Involved in preparing test scenarios and test users for specific applications for performance testing.
• Migrated reports from one environment to another and created appropriate database connections to the reports.

Environment: Hyperion Essbase 9.3.2, Administration Services 9.3.1, Hyperion Business Rules 9.3.1Hyperion Shared Services9.3.1, Hyperion Workspace 9.3.1, Hyper1on Planning 9.3.1, Hyperion Financial Management 9.3.1, Financial Reporting studio 9.3.1, Hyperion SmartView 9.3.1, Oracle 10i, Windows Server 2003.

Hyperion Developer

Confidential, Ashburn, VA

Responsibilities:

• Developed BSO application for operations as per the requirements.
• Involved in gathering requirements, Pilot sessions with the progress of the application build.
• Involved in creating Rule files for multi-dimensional databases, optimized Data Loads and Calc Scripts.
• Prepared Profitability Reports, which would compare the actual data to forecast data.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Involved in conducting UAT session and supported with issues.
• Developed various financial reports using Hyperion financial reporting studio.

Environment: Hyperion Essbase 9.2.3, Hyperion Workspace 9, Hyperion Planning, Administration and Analytical Services 9.0 Financial reporting studio 9.2.3, Web Analysis studio 9.2.0, MS-Excel 2000 Spreadsheet Add-In, Oracle 10i, Windows XP.