SUMMARY

• Over 7 years of experience in the field of Information Technology, this includes pioneering work in business Analysis, requirements, development, testing, implementing and support of Hyperion system applications and Client/Server projects using industry accepted methodologies and procedures.
• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 9/11, Hyperion Essbase 11.x/9.X, Hyperion Planning 11.x/9.x
• Strong experience in the design, development, and administration of Hyperion applications.
• Experience in performing upgrade, migration. Production support and database backups, Performance tuning and Optimization of Hyperion applications.
• Actively involved in interacting with the users and gathering the requirements for a new implementation and enhancing existing Applications.
• Expertise in Life Cycle Management (LCM) to migrate the artifacts from source to target server for all Hyperion products and DB export/Import.
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules and Essbase Excel Add - In), and Reports.
• Excellent proficiency in both Star Schema and Snow-Flake Schema data modeling techniques.
• Skilled in Partitioning, automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Expert in installing and configuring Hyperion applications across different platforms.
• Extensive experience in writing scripts using ESSCMD and MaxL.
• Expert Level experience in Hyperion Reports, Essbase Excel Spreadsheet Add-In and Smart view.
• Experienced in Hyperion Data management tools like ODI & FDQM.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Extensive knowledge in Oracle, SQL Server, MS Access.

TECHNICAL SKILLS

EPM: Hyperion System 11.x/9.x/7.x

OLAP: Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Essbase Integration Services, Hyperion Hub, Hyperion Workforce Planning, Hyperion Capital Asset Planning (CAPEX).

Reporting Tools: Hyperion Analyzer 7.2, Hyperion Financial Reporting, Hyperion Interactive Reporting (Brio), Essbase Spreadsheet Add-In, Smart View, Clarity6.0/7.0/FSR.

Data Management: HAL, ODI, FDQM

ERP Knowledge: SAP, Lawson, Oracle Apps

Languages: XML, Visual Basic 6.0,PL/SQL,SQL, Perl, Shell Scripting

Software: MS Office, MS Visual Basic, MS Project, FileMaker Pro, BIG-IP

Database: MS Access 7.0/2000/97, Oracle 8i/9i/10g,11g, MS SQL Server 2000/7.0

Operating Systems: Windows 98/2000/NT, Unix, Solaris 8.x

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Hyperion Administrator/Developer

Responsibilities:

• Involved in the implementation of Hyperion System 11.1.2.3 and configured the system (Essbase, Planning, Hyperion Interactive Reporting, Financial Reporting, Web Analysis and Smart View).
• Designed Essbase applications for Finance and Sales departments as per the requirement and optimized them for better performance.
• Improved data loading and database calculation by modifying the Essbase configuration
• Maintained cubes and automated regular backup.
• Migrated and took backups of different Hyperion applications across Development, Test and Production environments.
• Maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console.
• Involved in the design, and implementation of numerous Planning applications from transactional data (SAP Fixed Asset, GL, AP and AR) which is now the platform for all the financial reporting and analysis.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning.
• Involved in Creating Data Forms and Folders and Customizing Data Forms.
• Used procedures to generate complex reports.
• Created many Web Reports and wrote queries, analyzing data, producing reports using Hyperion Designer and translating functional requirements into technical specifications.
• Implemented Row level security on Reports.
• Built Dashboards for user interface to filter data and get access to the various sections like Pivots, Report Section and Charts.
• Created a custom authentication provider, which uses Active Directory, to control access to FDM.
• Formatted and Developed Reports using Workspace.
• Involved in developing the reports using Hyperion System 9 BI+, Hyperion Financial Reporting Studio and Interactive Reporting Studio with Dashboards and Web Analysis tools.
• Created SQL Load rules to load data and metadata into the cubes.
• Created ASO cubes based on the existing BSO cubes to enhance the performance of the existing Sales Margin cubes.
• Worked on the creation of alternate hierarchy for the ASO cube.
• Used Views and Stored procedure on that view to create complex Dashboards.
• Used HTML procedures and Stored Procedures to generate complex reports.
• Implemented Spotlight feature in Report Sections. Worked on Mercury Quality Center for Bugs handling during UAT and Production.

Environment: Hyperion System 11.1.2.3, Hyperion Essbase 11.1.2.3, Web Analysis, Hyperion Financial Reports, Interactive Report Studio (Dashboard Studio for Interactive Reporting), Hyperion Planning(Workspace), Toad 8.3, Excel Add-In, MS Project, Oracle 11g, SQL Server8.0, Windows XP/Server 2008,UNIX.

Confidential, Santa Clara, CA

Sr Hyperion Administrator/Developer

Responsibilities:

• As a part of production support, look after Hyperion applications; make sure the system is up and running, available for all users.
• Working on daily tickets from users, application Owners on various Hyperion issues, change requests, enhancements.
• Make sure daily routine jobs, backups were successfully completed.
• Involved in various monthly procedures for various Hyperion planning applications.
• Involved in month end, quarter end activities and making system available for future cycles.
• Involved in modifying and setting up new security access to Hyperion applications.
• Working with users closely in installing Hyperion client and troubleshooting their issues.
• Working on application metadata enhancements.
• Enhancing and improving Business rule performance.
• Loading exchange rates to various applications on a monthly basis, quarterly basis as per cycle.

Environment: Windows 2008, Hyperion EPM 11.1.1.3, (Planning, Essbase, Financial reports), ODI.

Confidential, Middletown, NJ

Hyperion Administrator/Developer

Responsibilities:

• Involved in the installation of Essbase Administration Services, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer and Hyperion Application Link in Windows environment.
• Migrating Essbase cubes into newer versions and newer operating systems.
• Involved in analysis, development and enhancement of database (MDDB) outlines.
• Responsible for creating users and groups and providing authorization to them.
• Provided Essbase technical supports to all business units, offered suggestions and proposed solutions to resolve issues.
• Developed EIS OLAP Models and Meta outlines for the cube.
• Created one Essbase cube for DFSs financial data related to the cost of processing checks and credit cards.
• Restructured and redesigned previous Essbase cubes.
• Involved in the performance tuning and optimization of data load calc scripts.
• Extensively used MaxL, ESSCMDS for creating batch files for automation.
• Hyperion Planning was used to maintain data access to the cube.
• Used Hyperion Planning environment to build interfaces and upgraded Business Rules.
• Maintenance of Batch scripts and scheduling runs through AutoSys.
• Created numerous new web forms in Hyperion Planning from sample Excel Mock Ups.
• Worked in different modules like books, accounts in Hyperion Enterprise to generate reports.
• Implementation of Essbase Security Bridge to integrate Hyperion Essbase security in PeopleSoft.
• Created several MDX formulas using functions such as Parent, IsUda, etc., to translate the BSO design to an ASO model
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends and Expense Variances over prior periods.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Created Transparent partition to use the functions of BSO cubes along with the existing ASO cube.
• Developed and performed tuning and optimization of the ASO cubes.
• Responsible for providing training to the end users.

Environment: Hyperion Essbase 9.3.1, Hyperion Enterprise 9, Web Analysis, Hyperion Report, Hyperion SQR, VBA, Essbase Integration Services, Hyperion Interactive Reporting, Hyperion Administration Services, Hyperion Planning 9.3.1, ESSCMD, Excel Add-In, MS Project, Oracle, Sun Solaris.

Confidential, Richardson, TX

Hyperion Administrator/Developer

Responsibilities:

• Loaded data and metadata from flat files through Hyperion Application Link to the Planning application using planning, flat file, and other adapters.
• Created custom dimensions, data sources, applications, and web forms for Planning.
• Moved the metadata from planning application to Essbase cube.
• Updated the web forms offline using Hyperion Smart View.
• Created complex Business Rules for the Planning applications.
• Developed MaxL scripts to automate the process of loading and swapping the ASO cubes.
• Migrated ASO and BSO cubes from one server to another to regulate the server load.
• Maintained job schedules for periodic generation of reports using different modules of Hyperion Performance Suite.
• Restructured as well as maintained existing Essbase cubes on a regular basis.
• Developed batch and rule files to load data from the database to Essbase cube. Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Developed Calc scripts and optimized them according to the Essbase outline. Used Essbase functions like @Descendants and @Ismbr for scripts involving financial data.
• Developed star schema for the OLAP model, and created EIS Meta-outline for the Essbase cubes.
• Resolved data storage requirements and upcoming needs of the server and storage devices to support the required performance level of Essbase applications.

Environment: Hyperion Essbase 9.3, AIS 9.3, Hyperion Analyzer 7.2.5, Hyperion Planning 9.3, Hyperion Application Link 9.2, Hyperion Performance Suite 8.3.2, Essbase Excel-Add-in, MaxL, Oracle 10g, MS Office Professional 2003, and Solaris 9.

Confidential

Hyperion Administrator/Developer

Responsibilities:

• Production Support for the existing Hyperion System 9.
• Performing monthly Financial close procedure which involves
• Extracting Actual data from SAP and loading in to Essbase.
• Copying data across Essbase applications.
• Opening and closing financial forecast for Users and Controllers.
• Generating monthly Summary reports.
• Involved in requirement gathering for setting up new Hyperion environment for Siemens Canada group.
• Implemented 4 Essbase applications for Siemens Canada & USA as per request to support their reporting.
• Provisioning and creating Users to access Hyperion System.
• Provided Knowledge transfer to users and other Hyperion team members to handover my responsibilities.

Environment: Hyperion system (Essbase (ASO, BSO), Financial Reporting) 9.3.1, Windows 2005, SQL Server, SAP.