SUMMARY

• Overall 8 years in IT and 7+ years of experience in Hyperion/OLAP/Business intelligence.
• Extensive knowledge of client/server applications working in Essbase OLAP environment using Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Smart View, Hyperion Essbase integration Services (EIS),. Strong command over Interactive Reporting, Financial Reporting.
• Designed and developed Essbase using Block Storage (BSO) & Aggregate Storage Block (ASO) applications with excellent balance of dimensions..
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, installing, upgrading, testing and migrating of cubes in different environment.
• Extensive knowledge in Hyperion Planning Business Rules (HBR), Essbase Calculation scripts, Essbase Commands and Essbase functions.
• Experience in writing business rules in HFM.
• Strong experience in maintaining Hyperion Essbase, Planning and HFM applications.
• Experience in metadata and data integration using HAL.
• Experience in developing effective production support model and BI service desk.
• Involved in writing custom calculations scripts, automating the Essbase Cubes using Maxl, EssCMD, MDX, VB Scripting and Batch Scripts.
• Good knowledge, experience and understanding in Software Development Life Cycle (SDLC).
• Extensively worked on Hyperion Financial Reports and developed numerous financial reports.
• Excellent proficiency in both Star Schema and Snow - Flake Schema data modeling techniques.
• Responsible for security groups and access for the users in Hyperion Reports and Hyperion System 9 Planning and Hyperion Shared Services.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Analytic Administration Services, Hyperion Enterprise Hyperion Financial Management 11.1.x, Financial Data Quality management (FDQM), Hyperion Planning 11.1.x/9.3x, Hyperion EPMA(Enterprise Performance Management Architect)Hyperion Essbase 6. x/7.x/9.x/11.x Essbase Integration Services, Essbase Studio, ESSCMD, MAXL and Hyperion Shared Services and IBM Cognos TM1

ETL Tools: Oracle Data Integrator(ODI), Hyperion Application Link(HAL)

Languages: C, C++, SQL,, Perl, VBscrpting

Operating Systems: Windows 2000/NT 4.0/98/95, UNIX

Reporting Tools: Hyperion Web Analysis, Hyperion Financial Reports, Hyperion Interactive Reporting (Brio), Hyperion Retrieve, Excel Addin and Smart View

Database: MS SQL Server, Oracle 10g

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr. Hyperion Consultant/ Sr. Hyperion Technical Lead

Responsibilities:

• Setting Up effective service desk model for IBM TM1.
• Currently working on decommissioning of Essbase and Hyperion Enterprise cubes.
• Working on developing and coordinating a new Monitoring procedure for IBM TM1.
• Currently working in role administering Essbase, Enterprise and planning applications.
• Maintenance and Supporting Essbase, Planning, Financial Management and Hyperion Enterprise applications.
• Regular Performance Tuning the ASO/BSO applications.
• Working on support and maintenance of Hyperion Enterprise 5.5, Hyperion Essbase 9, Hyperion planning.
• Leading an offshore and working together during close-monthly maintenance between Essbase, Planning and Hyperion Enterprise Systems.
• Currently involved in designing, development and validation of Sec Report packages using financial reporting tool.
• Experienced in writing Business riles in HFM.
• Experience in Developing and performing monthly maintenance to HFM applications.
• Working on validating business rules between source and HFM system.
• Experience in creating FDM applications and performing monthly maintenance.
• Step by step documentation of monthly maintenance regarding hierarchy changes, data validation results.,
• Expertise in financial reporting building and its validation against the source systems.
• Experience in building several reports and books for the financial team.
• Experienced maintaining security through filters and also guide users how to create the filters and assign security through simple Maxl statements using EAS for Essbase.
• Experience in writing new calc scripts for BSO and MDX formulas for ASO, updating them and testing during monthly maintenance.
• Currently Training offshore team and the team with Hyperion Financial Reporting tool.
• Took initiative for conducting meetings for resolving issues, clarification of report design and validation with senior Hyperion Lead business analyst.
• Troubles shooting the issues experienced by the end users regarding smart view/essbase add in connectivity, essbase queries and also helping other team members regarding maxl scripts, calc scripts, member formulas and smart view queries.

Environment: Hyperion Enterprise 5.5 Essbase 9.3.1, Planning 9.3.1, HFM 9.3.1, FDQM 9.3.1, DRM 9.3.1, Financial Reporting 9.3.1, Smart View 9.3.1 and Essbase Excel Add in 9.3.1, Microsoft Windows 2008.

Confidential, Cedar Rapids, IA

Sr. Hyperion Planning Lead

Responsibilities:

• Active involvement in gathering the requirements during the workshop conducted.
• Gathered requirements from end users what can and cannot be implemented and leveraged from the Hyperion Planning system.
• Experience with EPMA to create planning applications and Managing metadata.
• Hands on experience with creating Hyperion system documents.
• Developed numerous Planning web forms.
• Engaged the team of two with new Hyperion system 11.1.2 with needed skills for the project.
• Heavily worked independently designing test cases, gathering and clarifying requirements.
• Worked with business users clarifying their issues and generating draft version of requirements into final version of requirement document.
• Gatherings excel based submitting templates and transforming them into Planning data forms.
• Performing optimizations of the data forms.
• Effectively demonstrated the Hyperion Planning system and its key features across the client and its advantages over standard excel based forecasting and budgeting process..
• Hands on experience with writing custom currency calc scripts for Hyperion Planning.
• Designed and maintain several data forms during the project.
• Possess the ability to trouble shoot the Hyperion Planning and Essbase application issues.
• Will be able to train smart view to the users either in groups or individually.
• Experienced in migrating applications from Dev->QA->PROD and also between different versions of Hyperion system.
• Currently working on building 6 Planning applications and data reconciliation and building calc scripts.
• Experienced in creating Hyperion financial reports and enhancing it as required.
• Ability to train users how to navigate, open and run financial reports. From the workspace.
• Experienced maintaining security through shared services and also guide users how to create the filters and assign security through simple Maxl statements.
• Also has the ability to learn and understand financial terms and their purpose of applications to provide better Hyperion solution to the users in effective way.
• Conduct Meeting with users and the Hyperion team for the clarification of their requirements to be implemented.

Environment: Essbase 11.1.2.1, Planning 11.1.2.1, HFM 11.1.2.1, FDQM 11.1.2.1, Financial Reporting, Smart View 11.1.2.x and Essbase Excel Addin 11.1.2.x, Microsoft Windows 2008.

Confidential, Atlanta, GA

Sr Hyperion Essbase and Planning Lead Consultant

Responsibilities:

• Involved in migrations from Essbase 6.5, Planning 3.5 to Hyperion system 11.1.2.x
• Performed installation of clients on client computer and Blade PC’s like EAS, SmartView and Essbase Addin.
• Designed and builded test cases effectively.
• Written Deep-dive test cases scenarios for the functional and security test cases.
• Conducted meetings with BA’s, SA’s, DBA’s and architects for the requirement walk-through.
• Involved in trouble shooting issue during the build phase of the project.
• Trained the offshore team of four with new Hyperion system 11.1.2 with needed skills for the project.
• Created and maintained several dataforms as per the requirements.
• Experienced in writing business rules and also developed Calc Scripts for Essbase Cubes like XREF calcs, Aggregations, tax calculations etc., .
• Maintained security for using shared services and Maxl.
• Have written .Maxl and SQL scripts needed for automation.
• Trained Essbase Studio and how to create drill through reports using smart view.
• Worked with the installation of Oracle EPM 11.1.2 system in Hyperion QA environment.
• Tested integrity of Hyperion Financial Reports when migrated from version 7.x to Version 11.1.2.x
• Worked with business users clarifying their issues and educating them during UAT.

Environment: Essbase 6.5/11.1.2, Planning 3.5/11.1.2. x, Essbase Studio 11.1.2.x, PeopleSoft Financial and HCM, Smart View 11.1.2.x and Essbase Excel Addin 11.1.2.x, Microsoft Windows 2008, Oracle Linux.

Confidential, Torrance, CA

Sr. Essbase and Planning Consultant

Responsibilities:

• Involved in the migration of Essbase 7.x and Planning 3.5.
• Involved in the installation of Oracle EPM 11.1.1.3.
• Provided support to the end user regarding the issues related to smart view.
• Responsible for migrating security to Oracle EPM 11.1.1.3.
• Enhanced the several reports according the requirements.
• Created two Essbase applications using EIS.
• Created several drill through reports using smart view.
• Experienced in writing Maxl, Calc and batch scripts.
• Trained the existing Hyperion resources about the new feature in the Hyperion 11.1.1.3 like Essbase studio, LCM, EPMA and shared services.
• Used HAL to maintaining Essbase applications.
• Gathered and presented the requirements and prerequisites for installing Essbase 11.1.1.3.0 .
• Used EPMA to create and maintaining Essbase applications.
• Developed HAL (Hyperion Application Link) Routines to automate dimension building.
• Performed the Upgrade/Installation of Hyperion Modules from 9.3.1 to 11.1.1.3.0 version.

Environment: Essbase 7.1.2 / 11.1.1.3.0 , Classic Planning 11.1.1.3.0 , Smart View 11.1.1.3.0 , Essbase Spreadsheet Add in 6.1.EIS, Studio, Hyperion Financial Reporting11.1.2, Windows 2008 server, RHEL 4.0, Microsoft SQL Server 2005.

Confidential, Michigan

Sr. Essbase Consultant

Responsibilities:

• Involved in all phases of software Life cycle.
• Gathered and presented the requirements and prerequisites for installing Essbase 11.1.1.3.0 .
• Resolved the way to migrate security users, groups and filters from existing Essbase 7.1.2 to 11.1.2.0 which has shared services and also configured LDAP with the shared services.
• Solely responsible regarding the security issues and request of the users.
• Migrated more than 130 Essbase applications both BSO and ASO including artifacts from the existing production server.
• Trouble shooted the isues with Essbase version 11.1.2.0, 11.1.1.3.0 and 7.1.2. with in a limited time without lagging behind the schedule.
• Educated the users with the Smart View .
• Actively involved with installation Essbase 11.1.1.3.0 and Planning 11.1.1.3.0 on RHEL 5 and Essbase 11.1.2 .0 on IBM AIX OS.
• Also migrated applications from Essbase 6.1 to 11.1.1.3.0 .
• Involved in training and support for the new Planning application to the developers.
• Involved in a team interactions for regular hierarchy maintenance.
• Experience with Hyperion Planning with multi-currency development Excel and web form interfaces
• UsedLCM (Life Cycle Management) to migrate Hyperion applications, cubes, repositories, or artifacts across product environments and operating systems whichis accessed through the Shared Services Console.
• Created several report scripts and redefined the partitions on the Essbase.

Environment: Essbase 6.1 /7.1.2 / 11.1.1.3.0 /11.1.2.0, Classic Planning 11.1.1.3.0 , Smart View 11.1.1.3.0 , Essbase Spreadsheet Add in 6.1.IBM AIX UNIX, Red Hat Enterprise Linux 5.0, Windows 2008 server, Microsoft SQL Server 2005.

Confidential, Fort Lauderdale, Florida

Sr. Hyperion Planning Consultant

Responsibilities:

• Involved in the all phases of software life cycle.
• Involved in defining requirements, functional specification, design documents, test strategy and implementation specification.
• Involved in Design of Essbase Close and consolidation and Tech expense Cubes and documentation of Design Document for CITRIX Hyperion implementation.
• Created Database outlines and optimized the outlines arranging the Dimensions.
• Developed Business Rules like indirect expenses, allocations, aggregations etc.,
• Developed Load Rules Files, for dimension building and loading data from flat files to the Essbase Cube.
• Used EPMA to manage, create and deploy Hyperion applications.
• Built the corporate submission process from CITRIX business, which includes the building of Report Scripts, load rules and Calc scripts.
• Automated cubes using MaxL statements and running it through Windows Batch scripts.
• Designed and developed Web forms for corporate submissions.
• Developed HAL (Hyperion Application Link) Routines to automate dimension building.
• Designed the UAT scripts and involved in the UAT testing.
• Involved in training and support of users.
• Involved in active user interactions for regular hierarchy maintenance.
• Wrote batch scripts to automate user security for different planning cycles.
• Developed the MaxL scripts to take backup of the database and to recover from the failure.
• Developed reports for financial analysis, trending and results analysis related to revenue and expenses using Hyperion Interactive Reporting,
• Experience with Hyperion Planning with multi-currency development Excel and web form interfaces
• Scheduled the weekly status meetings to ensure the weekly progress of the project.
• Scheduled the meetings for issues resolution, prioritizing the issues and fixing the issues.
• Created easy-to-share customized views that represent performance, financial and operational reports using the Hyperion Financial Reports.
• Scheduled and conducted meetings with the business clients to review and collect the feedback and revisions.
• Performed the Upgrade/Installation of Hyperion Modules from 9.3.1 to 11.1.1.3.0 version.
• UsedLCM (Life Cycle Management) to migrate Hyperion applications, cubes, repositories, or artifacts across product environments and operating systems which is accessed through the Shared Services Console.

Environment: Hyperion Essbase 11.1.1.3.0 /9.3.1, Hyperion Planning 11.1.1.3.0 /9.3.1, Hyperion EPMA, Hyperion Financial Reports, Hyperion Application Link (HAL), ODI, Hyperion Web Analysis, Hyperion workspace, Excel-Add-in, Smart View, MS SQL Server 2005.

Confidential

Hyperion Developer

Responsibilities:

• In depth understanding of multi-dimensional database application using Essbase.
• Designed and developed monthly, quarterly and yearlyRetail P&L Cubes.
• Developed Calc Scripts to calculate various figures for the outline.
• Developed and maintained Rule files, Calc Scripts, EssCMDs & Maxl Scripts.
• Automated the Essbase Cubes using EssCMDs and Batch Scripts.
• Developed and optimized Data Loads and Calculations.

Environment: Hyperion Essbase 7.0, Essbase addin6.1, Microsoft Excel 2000, MS SQL Server, Windows NT/2000, UNIX, .