SUMMARY

• Around 7 years of rich experience in IT including 6 years experience in design, analysis, development and implementation of various applications environment using Hyperion Essbase, Hyperion Planning, Essbase Administration Services, Essbase Studio Services, Hyperion Financial Reporting, Interactive Reporting, Web Analysis, Smart View for Office, ESSCMD, MaxL, MDX, Essbase Excel Add - in, Oracle Data Integrator (ODI) on Windows and Unix environment.
• Experience in Hyperion System 11 (Oracle EPMA System 11 - Fusion version
• Extensive knowledge of upgrade between different versions of Hyperion Suite to 11.1.2.x
• Extensive experience in designing and developing OLAP cubes from a conceptual level.
• Extensive experience in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Expertise on End to End implementations of Hyperion projects (HFM,FDM/FDMEE, Essbase and Planning).
• Expertise in complex security model for HFM, Planning, and Essbase applications as per client requirements
• Experience in the ETL process of HFM applications using FDMEE as the ETL tool.
• Managed the preparation of various internal and external financial reporting in accordance with GAAP
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Key strength in optimization and tuning of Essbase cubes across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.
• Experience in Accounting: Balance Sheet, P&L, A/P, A/R, G/L, Fixed Assets, Budgets, Closing, Reconciliations, Journal Entries, Payroll, Banking,Trail Balance Financial Analysis, Financial Audits, ERP Implementation.
• Entered Foreign Exchange Rates grids and their entries for Balance Sheet and Income Statement.
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes and calc scripts to facilitate effective business decision making.
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Scheduling loading of data, and writing scripts to perform loads and calculations, Essbase Partition database models and Essbase Block Storage database models.
• Database optimization and performance-tuning expertise with Essbase.
• Experience in cost accounting.Validate the cost of goods sold as part of the month-end close
• Experience in extracting data from Hyperion Financial Management using Extended Analytics.
• Monitoring and support Hyperion Essbase Business Intelligence applications and batch load processes to ensure the highest level of system availability.
• Support user training, documentation, and rollout of new projects.
• Excellent communication and interpersonal skills with ability to be a team player and team leader.

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Planning 11.x/9.x Hyperion Essbase 11.x/9.x/7.x, Essbase Administration Services (EAS), Analytic Integration Services (AIS /EIS), Workspace, Smart View for Office, MS Excel Add-In Essbase query designer, Integration Services, Performance ManagementReporting Tools Web Analysis, Smart View, Hyperion Financial Reporting (FR)

MS Office Tools: MS Office Suite 2007/2003/2000.

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, Shell Script.

Data Integration: Hyperion Financial Data Quality Manager, Data Relationship Manager, Oracle Data Integrator

Databases: Oracle 11i/10g/9i/8i, MS SQL Server, MS Access.

Operating Systems: Windows NT/2000 /XP/Server 2003, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Bethlehem, PA

Hyperion Consultat

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning and Essbase Applications.
• Working with financial system super users, infrastructure team, other IT system administrators for daily data loads and verification process.
• Analysis, design, integration and implementation of solutions across multiple applications in domain, to include work processes, modifications, interfaces, and reports
• Created web forms in Hyperion planning for users to create, modify the plan details and also web forms for the capital controllers to allocate amount among various plans
• Designed and developed standalone Essbase cube for corporate reporting framework using Block storage (BSO).
• Designed the data flow from ERP applications to the Hyperion application using FDMEE as the ETL Tool.
• Strong knowledge of working on FDMEE components like ODI, ERP Integrator,FDM.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports.
• Maintaining daily data backups and weekly Application backup processes.
• Performing weekly, monthly and yearly activities such as archiving, monthly actual load.
• Installing Essbase add-in, Smart View and Essbase Ribbon for users.
• Optimized Essbase cube by updating Essbase Config. files for faster retrieval and loading of data
• Restoring database from backups and importing current data (created after backup points) whenever database corruption or failures occur.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups..
• Developed reports for users to view the data in the planning applications using Hyperion Financial Reports.
• Responsible for extracting Hyperion Financial Management data using Extended Analytics

Environment: Hyperion Essbase 11.1.2.2 Hyperion Planning 11.1.2.2, Financial Reports 11.1.2.2, Essbase Administration Services (EAS), Shared Services, Hyperion Smart View 11.1.2.1, Hyperion Financial Data Quality Manager 11.1.2.2, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Confidential, Hoboken, NJ

Hyperion Consultant

Responsibilities:

• Coordinated with client to understand the business requirements.
• Created functional specifications based on the requirements for each Business unit.
• Involved in creation of technical design document based on the functional specification.
• Created POCs for each OPCo in Aggregate Storage Option (ASO)and set the properties for each dimension based on the technical specification.
• Worked on MDX queries to View dimension for Dimension type “Time” to avoid DTS as per the requirement
• Changed Compression Dimension and used TB properties to enhance performance
• Created MaxL scripts to load dimension rule files and data files.
• Tested Smart View compatibility with MS excel -2010
• Analyzed hierarchies for Entity dimension and worked on the removal of the Alternate hierarchies present in Entity. Created separate dimensions for each alternate hierarchy.
• Created schemas for Essbase studio to create outline for ASO cube.
• Tested Essbase studio 11.1.2.2 to check drill through reporting on Transactions and Balances.
• Designed and materialized aggregation using query tracking and ratio method and automated the aggregated view creation.
• Created functional design document for planning application based on the present HFM applications as per the business needs.
• Developed advanced automation process to perform incremental data loads in to ASO cubes and integrated with in house portal to provide the status of data loads
• Integrated Planning and Financial management data via Financial data warehouse.
• Created Essbase Filters to restrict the user access to specific entities/departments.
• Developed complex load rules in loading data.
• Developed various KPI's using MDX to minimize calculation in Financial Reports
• Built various FR reports by utilizing Prompts and POV's

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, Essbase Studio 11.1.2.2 Essbase Administration Services (EAS), Shared Services, Hyperion Smart View 11.1.2.2, Hyperion Financial Management 11.1.2.2. Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Confidential, TX

Sr. Hyperion Planning Consultant

Responsibilities:

• Maintenance, enhancement and optimization of existing 4 planning applications as part of company's Financial Planning Budgeting and Forecasting application.
• Creating scripts to utilize Hyperion Planning utilities for automation of planning processes
• Developed business rules to accommodate new accounts and sub-accounts flowing through the planning applications from various feeds for the purpose of forecasting, budgeting, consolidation and allocations
• Designing and developing user friendly data loading processes by incorporating Essbase Excel add-in, and VBA
• Assessing different scenarios and designs for building integrated Hyperion Planning applications to process financial data coming from acquired company (Merger & Acquisition)
• Conducting demos and Q&A sessions for new functions/utilities available in version 11 to assist business and higher management in the upcoming upgrade project from Hyperion version 9.3.1.3 to 11.1.1.3 and 11.1.1.3 to 11.1.2
• Improving response times of Hyperion Planning web forms by modifying web forms design settings and optimizing business rules associated with the web forms
• Designing and developing tools by utilizing Essbase Excel add-in to automate movement of subaccounts between different Hyperion Planning forms so that maintenance overheads due to a large amount of these requests is significantly reduced
• Facilitate enhanced response timing and optimization of BSO/ASO Cubes by optimal setting of dense/sparse dimensions, tuning of cache setting, and buffer setting, tuning calc scripts.
• Automated backups and archive of database in nightly process.
• Handle large database size around 30GB and wrote batch scripts for automation of restructuring of the cubes.
• Development and maintenance of business rules and calc scripts to derive complex calculations such as project splitting, allocations and auditing
• Developing processes to remove hard-coding in many of the business rules and calc scripts by introducing new Attributes to the Hyperion planning applications and maintaining them in an fashion which is easy and flexible for business users
• Developing MaxL script to automate the cube build process and wrapper shell scripts to integrate all the MaxL scripts into it

Environment: Hyperion Planning 11.1.1.3, Essbase 11.1.1.3, Hyperion Workspace, Hyperion Shared Services, Hyperion Interactive Reporting 11.1.1.3, Hyperion Smartview for Office, Essbase add-in, Hyperion Web Analysis, STAR Analytics, Oracle Data Integrator

Confidential

PL/SQL Developer

Responsibilities:

• PL/SQL Development and Implementation
• Involved in creation of Partitioned Tables and Indexes, Packages and Stored Procedures.
• Involved in writing SQL Queries to implement the business requirements
• Involved in loading data into Database using SQL*Loader
• Data Migration using PL/SQL stored Procedures and maintaining migrated data
• Involved in Index Monitoring for identifying the unused Indexes
• Made enhancements and applied defect fixes using PL/SQL and TOAD.
• Created Issue resolution documents and plans for minor enhancements.
• Involved in analyzing schema’s, Tables and Indexes as part of Optimization
• Created summary reports to address fix/ enhancement code change
• Created Technical Design documents for major enhancements and attended Technical Design Reviews

Environment: Oracle 10g, SQL DEVELOPER, TOAD