SUMMARY

• Over 8+ years of diversified experience in software development, design, implementations and testing using Hyperion Essbase (System 9,V11), and Hyperion Planning(System 9) including Workforce, CapEx and DRM (System 9 and 11.1.2)
• Used various ERP tools to manage monthly financial consolidation process.
• Extensive experience with automation and batch scripting using Hyperion scripting languages such as MaxL, Esscmd and Visual Basic API
• Extensive experience in Excel based custom reporting solutions over diversified data sources.
• Hands on exposure in leading and participating in at least 5 Hyperion implementation projects.
• Extensive experience on the installation, configuration, server settings, backups, client installations of Hyperion products on both Windows and UNIX environments.
• Extensive experience in Business Rules, Web Forms, Calculation Scripts, Load Rules and Report scripts.
• Experience and expertise in managing and administering numerous Essbase applications and cubes (Block Storage and Aggregate Storage), forms, reports, and books.
• Applied in - depth understanding of STAR and SNOWFLAKE SCHEMA modeling techniques to develop optimized OLAP models and meta-outlines using relational and other database sources.
• Expert technical/developer knowledge of Hyperion Planning
• Substantial experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions, and security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Thorough understanding of multidimensional and relational database architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Experience in creation and maintenance of finance, ledger, planning, and reporting cubes across BSO and ASO Essbase kernels along with strong database development and business intelligence modeling capabilities.
• Extensive experience with migrations of Essbase version 7.x and 9.x,11x
• Excellent communication skills and better understanding of business requirements and software development cycle in the Hyperion Essbase environment.
• Highly dedicated towards work goals and creative in new development as well as solutions to critical issues.
• Experience developing and implementing Hyperion Planning applications

TECHNICAL SKILLS

Database: Oracle 7.x/8.x/9.x/10g, IBM DB2, SQL Server

BI Tool: Hyperion Essbase system 11.x, 9.x,7.x, EPM 11, Hyperion Planning, Workforce Planning, Hyperion Shared Services, Hyperion Work Space, Hyperion Financial reporting,Life Cycle Management Smart view, Excel AddIn

DW/ETL: Hyperion Data integration Management(DIM), Informatica 8.2,ODI 11.x

Server side: Calc script, ESSCMD,MaxL script, Batch scripts, JDBC

ERP: Oracle apps 11i (MM, AP and AR)

Internet scripts: HTML, XML, Java script, VB script

Languages: SQL, PL/SQL

Other Software / tools: Quality Center, Test Director, MS Visio, MS Access, Citrix, Toad, Rapid SQL.,WINSCP, PUTTY, DAC

Operating System: Windows NT4.0/2000/XP/2003

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Hyperion Essbase Developer

Responsibilities:

• Involved in creating new Essbase cubes and restructure and redesigning of existing cubes.
• Extensively used MaxL, ESSCMDS for creating automation scripts and batch files. Scheduled these batch files for complete automation process for nights and weekends cube refresh and backups.
• Engaged full life cycle Essbase implementation in Hyperion 9.3 to consolidate multiple outlines for bank retail incentive plan; Deploy EIS for member load; Using SQL 2005 to extract data sources from ORCL 10g and variety 3rd party databases for data load; Translating design and coding into Essbase construction; Create rules files and perform mapping; Restructure and re-engineer outline; Creating complex and complicated Calc Scripts; Testing and validation; Create Financial Report for retail incentive scorecards, books, and batch schedules;
• Engaged and delivered a new EIS creation in Hyperion 9.3 for members and data load, and also for drill through to navigate to lower level; Created OLAP Model and Metaoutline; Deploy SQL 2005 to extract data sources from IBM DB2 for data load. Assist a new full life cycle Essbase implementation for loan and investment report analytical needs; Performed outline coding and structure; Created Rules Files and Calc Scripts; Created Esscmd/Maxl scripts and batch process; Financial Report development and creation.
• Designed, re-architected and created new cubes for Sales Forecasting applications using attributes and shared hierarchies across ASO/BSO partitions.
• Improved performance using Query Tracking; Essbase ASO databases using Maxl, Linux scripts and Essbase’s Excel API in VBA/VBS
• Developed various load rules for dimension build and data load to the cubes.
• Involved in the performance tuning and optimization of data files, dimensions and calc scripts for ASO and BSO cubes.
• Migrated Planning, Financial Report, Web Analysis 9.2 to 9.3.1
• Developed and troubleshoot: Business Rules ESSCMD Calculation Scripts and MXL Load Rules.
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.

Confidential, FL

Sr. Hyperion DRM / Essbase Developer

Responsibilities:

• Supported Hyperion Planning, Essbase, Hyperion Report, for FP&A and Accounting Groups.
• Performed Hyperion system maintenance and upgrades, coordinate user security
• Provided deep-level Hyperion Essbase and data warehouse subject-matter expertise and consultancy to the team in areas of functional design data warehouse design, dimensional model design, ETL, dashboards and optimization.
• Performed ODI transformation, mapping, and integration for Planning App
• Lead Hyperion planning apps upgrade/migration from earlier versions to latest release.
• Heavily involved in new business GL account GAAP mapping
• Specialist/Architect in Hyperion planning implementation teams.
• Maintaining an in-depth understanding of Oracle Information Management & BI Technologies
• Experience with consolidation, reporting and business rules and forms using HPM.
• Experience with data transformation utilizing HPM
• Did implementation for CAPEX, Headcount planning in Hyperion.
• Played an active role in all phases of the development lifecycle including requirements gathering and analysis, application design and development, testing - user acceptance and quality assurance, Implementation, and maintenance.
• Wrote & maintained data load rules, Calc scripts and business rules in Hyperion Essbase and Hyperion Planning.
• Researched new requirements, collaboratively, with FP&A Directors, managers and Analysts.
• Successfully re-architected/ re-designed, programmed and implemented driver based Budgeting and rolling Forecasts using Hyperion Planning.
• Performed client/server installations, setup, configuration, and upgrades of Hyperion Essbase as well as other Hyperion products.
• Developed Calc scripts/ Business Rules for Expense allocation, currency conversion and depreciation of CapEx. Wrote PL/SQL reports to extract
• Created allocation scripts for Corporate Budgeting and Actuals-Consolidation cubes. Created new dimension in Planning and cubes. Improved performance of Essbase and Planning. Researched workarounds to bugs in Smartview, trained supported Planning users. Extracted data from HFM.liaised between Finance and IT.
• Essbase\Planning\and Hyperion Report, create/ monitor/execute batch jobs .
• FDM design, test, migration, import formats, location setup, security, custom scripting for GL integration.
• ODI: Created Repositories, Agent, Contexts, Data Server, and both of Physical & Logical Schema in Topology Manager; created both of source and target models folders, models and datastores; Created Project, Project Folder, and Packages; imported required Knowledge Modules.

Environment: Hyperion Essbase,Planning, EIS-Integration services, Hyperion Financial reporting 11,, Hyperion Interactive Reporting.,Hyperion), Hyperion Web analyzer 11,HAL Hyperion Application Link, Hyperion Planning desktop, Oracle 9i/10gHyperion version (9.3.1, 11.1.1.3, 11.1.2, 11.2.3)

Confidential, Mclean VA

Hyperion Essbase / Planning / Analyst

Responsibility:

• Designed and managed applications using Hyperion System 11, 9 BI+.
• Involved in installation and upgrading the Hyperion Essbase and Hyperion Reports.
• Worked on Hyperion Application Link (HAL) routines to load data from PeopleSoft to Planning. HAL routines included metadata refresh, translation of metadata.
• Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR’s—Global Security Filters and Web forms. Salary script based on HeadcountsRundown units calculation, cost of sales were few of HBR’s.
• Translated design and coding into Essbase construction, Create rules files and perform mapping; Restructure and re-engineer outline; Creating complex and complicated Calc Scripts; Testing and validation; Created Financial Report for retail incentive scorecards, books, and batch schedules.
• Developed a Multi-Dimensional Database (MDDB) application using Hyperion Essbase that stored and maintained company\'s financial and marketing data and performed the loading and manipulation of data into the database using Build and Load Rules files.
• Administered Security, User creation with Native and External authentication, Filters, Dimensional level Security, Groups and assign the proper privileges.
• Used attribute dimensions to retrieve and analyze data in terms of characteristics of dimensions.
• Developed and maintained Calc Scripts for performing calculations and developed member formulas for dynamic calculations.
• Automated Hyperion Essbase Cubes to minimize manual entry through Batch File using ESSCMD/MaxL Scripts. Removed errors occurring during the nightly dimension build and data load processes by referring to Log files.
• Involved in creating ASO Cubes for better performance, migrated BSO Cubes to ASO Cubes and also changed Calc Scripts to MDX.
• Owned and delivered new planning implementations
• Lead Hyperion planning apps upgrade/migration from earlier versions to latest release.

Environment: Hyperion System 11 BI+, Hyperion Essbase 11, 9.3.2/9.3.1 , Essbase Integration Services 9.1.2, Hyperion Essbase Administrative Services 9.1.2, Hyperion Planning11, 9.3, Hyperion Financial Reporting Studio11, 9.3, Hyperion Application Link (HAL), Hyperion Reports 7.2, Shared Services 9.3, Hyperion Smart View, Hyperion Essbase Excel Spreadsheet Add-In, MaxL, ESSCMD, Web Analysis, MS-Office, Oracle 10g and 9i, MS-SQL Server, SQL, PL/SQL, JavaScript, UNIX (AIX, Sun Solaris, Linux), Windows 2003/XP

Confidential, IL

Hyperion / Admintrator / Developer

Responsibilities:

• Installed and Configured Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports and Workspace in development, staging and production environments.
• Used Hyperion Planning to create, maintain and manage the budget and plans. Maintained Essbase Databases using Planning application to input financial data requirements.
• Involved in assigning Security for Hyperion Planning applications using Hyperion Shared Services.Created and managed numerous data entry forms, business rules for several applications and various Reports in Hyperion planning.
• Involved in building Hyperion Application Link (HAL) adapters for loading metadata into planning.
• Write & maintained data load rules, Calc scripts and business rules in Hyperion Essbase and Hyperion Planning
• Performed dynamic dimension build and data load using rules files, developed member formulas and Calc Scripts computing input values into actual scenario results and projecting these values using Excel Add-in and Hyperion Reports.
• Documented solutions and/or workaround in Knowledge Database that is shared with customers
• Replicated customer’s bugs by setting up their RDBMS/Hyperion systems in-house. Assisted the project team in the final phase of Hyperion System EPM 11.1.1.3 Planning, Reporting, Workforce, and CapEx applications implementation; interface with Peoplesoft ERP; execute ODI metadata map and build; deploy LCM to move application in between environment; Develop and test Business Rules per Peoplesoft’s formulas, Data Web Forms, Financial Reporting, Web Analysis, and Smart view.
• Completed tuning, debugging, routine maintenance of Essbase applications as well as provided support for these applications.
• Involved in creation, update, deletion and maintenance of user accounts and groups for cube access. Monitored the log files of the cubes to make sure there are no errors related to dimension build and data load.
• Provided Database optimization with dimension building, data loading, Indexing, calculations, cache management and partition management.
• Involved in migration of Hyperion Essbase Cubes and transfer of applications, outlines and data exportation (ETL).

Environment: Hyperion System 11, 9 BI+, Essbase Integration Services, Hyperion Essbase Administrative Services 11x,9x, 7.x, Hyperion Planning 9.3/3.3, Hyperion Financial Reporting 9.3, Hyperion Application Link (HAL), Hyperion Analyzer, Shared Services 9.3, Hyperion Essbase Excel Spreadsheet Add-In, Hyperion Smart View, MaxL, ESSCMD, MS-Office, DB2, SQL, PL/SQL, UNIX (AIX, Sun Solaris), Windows 2000/XP.

Confidential, OH

Hyperion Essbase Planning

Responsibilities:

• Involved in creating new Essbase cubes and restructure and redesigning of existing cubes.
• Extensively used MaxL, ESSCMDS for creating automation scripts and batch files. Scheduled these batch files for complete automation process for nights and weekends cube refresh and backups.
• Engaged full life cycle Essbase implementation in Hyperion 9.3 to consolidate multiple outlines for bank retail incentive plan; Deploy EIS for member load; Using SQL 2005 to extract data sources from ORCL 10g and variety 3rd party databases for data load; Translating design and coding into Essbase construction; Create rules files and perform mapping; Restructure and re-engineer outline; Creating complex and complicated Calc Scripts; Testing and validation; Create Financial Report for retail incentive scorecards, books, and batch schedules;
• Engaged and delivered a new EIS creation in Hyperion 9.3 for members and data load, and also for drill through to navigate to lower level; Created OLAP Model and Metaoutline; Deploy SQL 2005 to extract data sources from IBM DB2 for data load. Assist a new full life cycle Essbase implementation for loan and investment report analytical needs; Performed outline coding and structure; Created Rules Files and Calc Scripts; Created Esscmd/Maxl scripts and batch process; Financial Report development and creation.
• Designed, re-architected and created new cubes for Sales Forecasting applications using attributes and shared hierarchies across ASO/BSO partitions.
• Improved performance using Query Tracking; Essbase ASO databases using Maxl, Linux scripts and Essbase’s Excel API in VBA/VBS
• Developed various load rules for dimension build and data load to the cubes.
• Involved in the performance tuning and optimization of data files, dimensions and calc scripts for ASO and BSO cubes.
• Migrated Planning, Financial Report, Web Analysis 9.2 to 9.3.1
• Developed and troubleshoot: Business Rules ESSCMD Calculation Scripts and MXL Load Rules.
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Created HAL 9.2 templates for updating Planning outline. Installed and configured Planning & Essbase 9.3.1
• Hyperion Essbase/ Planning Developer and Database Administrator
• Administered and supported worldwide financial planning, forecasting, budgeting
• Investigated and resolved consolidation and metadata design issues.

Environment: Environment: Hyperion Essbase 11x, 9.3,EPMA,Hyperion planning 9, Hyperion Reporting, Shared Services, Work Space, Hyperion Smart View,Excel Add-In Oracle 10g, Windows 2003, Hyperion DRM 9X

Confidential, Woodcliff Lake, NJ

Hyperion Developer

Responsibilities:

• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development, tests and production environments.
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
• Maintain Hyperion Servers, create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups
• Creating Calculation scripts, MaxL script for process automation.
• Migration to new production server and supporting end user, planners for budgeting.
• Daily and weekly back up process as well as Data loading job monitoring.
• Reporting using Excel add-in, Hyperion Analyzer.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using HAL.
• Loading planning data using planning desktop and smart view client.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Installed and configured Oracle 9i/8i/8.05
• Designed and developed database tables, triggers, cursors using PL/SQL.
• Developed and optimized a framework for extensible automated production support in PL/SQL.
• Created spreadsheets and reports using oracle PL/ SQL, Toad and SQL.
• Developed stored procedures and complex packages using PL/SQL.
• Developed triggers and PL/SQL procedures for automation of jobs scheduling.
• Managed performance and tuning of SQL queries and fixed the slow running queries.
• Ported Oracle Database procedures, functions, triggers and PL/SQL blocks to DB2 Database.