SUMMARY

• 7+ years of IT experience in design, analysis, development and implementation of various applications in client/server environment usingb Essbase,Hyperion Planning, Financial Reporting Studio, Hyperion Interactive Reporting Studio, Web Analysis, Shared Services, Smart View, Essbase Query Designer on Windows and UNIX environments.
• Over 6 yrs of experience in developing and supporting Budgeting &forecasting applications using Hyperion Planning.
• 6+ years of experience in Business Intelligence with major focus on design development, implementation and support of Hyperion Essbase and Hyperion Planning applications.
• Domain expertise includes finance, retail and Consumer Goods
• Followed Agile/water fall model for the SDLC process of Hyperion projects.
• Extensive experience in application designing and development using Oracle EPM system 11.x, Hyperion Essbase 9.x/7.x/6.x, Hyperion Financial Reports, ESSCMD, MAXL, Essbase Excel Add - In, Smart View and Hyperion web Analyzer
• Hands-on experience with various aspects of project management project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation Excel
• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
• Designed and developed Essbase applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Extensive experience using Hyperion tools like Hyperion Planning, Hyperion Business Rules (HBR) and Hyperion Application Link (HAL), ODI on Windows and UNIX environments.
• Extensive experience using Outline Load Utility to load meta data into Hyperion Planning.
• Having good experience in developing Essbase objects such as dimension build rules, data load rules, Calc scripts & report scripts.
• Expertise in Hyperion Planning objects such as Data forms, Business Rules, Task lists.
• Extensive experience using Hyperion tools like Hyperion Analytic Services, Hyperion Analytic Administration services (AAS), Hyperion Spread Sheet Services (Excel Add-In), Smart View for Office, Hyperion Shared Services, and on Windows and UNIX environments.
• Expertise in optimizing calculations, data loads, retrievals performance.
• Extensive Integration experience with Hyperion cubes and OBIEE Environment.
• Worked with Answers, BI Publisher, repository, Physical Layer, Business Layer.
• Expertise in providing the access using the shared services.
• Hands-on experience in creating reports using EXCEL ADD-IN and Smart View.
• Extensive experience performing DBA activities on Hyperion Essbase.
• Hands on experience in developing MAXL scripts and ESSCMD scripts and automating the jobs.
• Experience in designing Data Marts and Data Warehouse using Star Schema.
• Extensive knowledge in writing the custom SQL on various relational databases to perform dimension builds and data load.
• Diverse background with fast learning skills and creative analytical skills.
• Good interpersonal skills, team coordination and versed with Software Development.

TECHNICAL SKILLS

MDDB Database: EPMA, Oracle Hyperion Essbase 11.x /9.x /7.x

Budgeting and Forecasting Tool: Hyperion Planning 11.x/9.x,HFM

Reporting Tools: Hyperion BI+ 11.x/9.x, Interactive Reporting(IRS) 11.x/9.x, Financial Reporting(FRS) 11.x/9.x, Smart view, Excel spreadsheet Add In

Operating Systems: Win XP, Windows 2003/2005/2008 , Windows 7, 8, Win 9X and Unix, Linux

Databases: Essbase11.x/9.x, Oracle 9i/10g, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2.0., DB2, Teradata V2R6.

ETL tools: HAL, ODI,EIS and DIM, Outline Load Utility

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr. Hyperion Planning System Analyst

Responsibilities:

• Worked as Techno functional consultant responsible for requirement gathering, analyzing requirement and building planning applications.
• Worked with business analysts for gathering requirements, functional specifications and developing a project plan.
• Worked with end users as part of requirement gathering and drafting business requirement documents.
• Designed Balance Sheet, Cash Flow Statement and Income Statement on Hyperion Planning by integrating various data sources.
• Designed data forms, Smart lists, Menu, Task List, Planning units as part of planning development.
• Designed complex business rules to accomplish various business requirements like revenue allocation and Workforce related calculations.
• Used Oracle Out of the box models of Workforce and Capex applications as part of planning application implementation
• Strong knowledge of Debugging data and application related issues on planning applications.
• Worked on end to end implementation of 5 Essbase ASO and BSO applications used for Accounting and Marketing purpose data analysis.
• Designed dimensions and designed ETL related to dimension building and data loading using ODI.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Extensively used Essbase Integration Services (EIS) for building dimension.
• Developed Rules files to upload data from Flat files to Essbase cube.
• Performed and excelled in proficient automation of reports into excel by making use of Macros and VBA.
• Automating the cubes using Maxl statements and running it through UNIX shell scripts.
• Designed complex financial reports using Hyperion financial reporting.
• Designed security model of applications using Hyperion shared services.
• Developed and modified Excel Templates for user interface in Essbase database.
• Planning and coding complex reports developed in Excel using Visual Basic for Applications.
• Involved in database migration from development servers to QA and Production servers.
• Reported the defects using the Mercury Quality Center.

Confidential, Memphis, TN

Sr. Hyperion Planning System Analyst

Responsibilities:

• Installation and Configuration of Oracle Enterprise Performance Management Suite
• Worked on development projects related to Essbase, FDQM and HFM.
• Designed ETL using FDQM for all Hyperion Essbase cubes and HFM applications.
• Used Operator GUI to schedule and automate data load processes through FDQM
• Used FDQM to load data into Essbase and Planning from various relational and file data source.
• Created dimension
• Created documentation related to all Hyperion projects development and administration.
• Provided production support for existing applications and handled enhancements related to those applications.
• Developed comprehensive reporting system using Hyperion Financial Reporting.
• Designed financial reports for the complex business requirements.
• Worked 24*7 on production support tickets and completely responsible for reporting the status to higher level managers.
• Designed security related to BI applications using shared services.

Confidential, Delaware, Delaware

Sr. Hyperion Developer / Administrator

Responsibilities:

• Developed a Business Requirement Document for Financial Planning System.
• Created Hyperion Planning Application USFS for Forecasting, Budgeting and Planning FY08 Business for SME’s.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase cube, and the optimization of the old data loads and calc scripts.
• Developed applications using HFM for automation and reporting process.
• Used HFM to improve productivity by accessing multiple data sources at the same time.
• Created and maintained and consolidated Hyperion Enterprise applications and generated reports through those applications. Installed and upgraded Hyperion Planning applications.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Hyperion Application Link
• Loaded data using Essbase Integration Services (EIS)
• Prepare rules for loading data files and for building different dimensions.
• Wrote report scripts to extract data from the existing cube.
• Created Web Forms to facilitate Data Entry for Planning Process.

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL programs that included writing of Stored Procedures, Packages, Functions and Database Triggers.
• Created Temporary Tables to store the data from Legacy system.
• Used SQL*Loader scripts to load the data into temporary tables and PL/SQL procedures to validate the data.
• Loaded data to the Interface tables from multiple data sources such as MS Access, SQL Server, DB2, Text files and Excel Spreadsheets using, SQL Loader Informatica.
• Creation of Materialized views and function based indexes.
• Setting up various notification scripts which will notify if the database is not up and running or if any directory space is filled up.
• Used Oracle packages for automation and Oracle designer for data modeling.