SUMMARY

• Senior Information technology professional over 13 of years Extensive experience in Hyperion Essbase,EIS and web analysis, Hyperion Planning, Financial Reports, Interactive Repots/Brio,Cognos, MS Sql servies, Analysis services,OBIEE
• Working as Project coordinator and project lead for the on - site development team
• Extensive work as a technical and functional resource for the Business users
• Hands-on work with the data warehouse and financial reporting
• Preparing Conceptual Design Document and data dictionary from scratch
• Designing and executing multiple UAT test plans/cycles
• Handling frequent business requirements changes before production migration
• Creating Oracle Hyperion Planning Applications with EPMA 11.1.2.4
• Data warehousing environment with Analysis, Design, Implementation of Business Intelligence systems, Reporting tools and OLAP environments along with strong analytical skills & vast Report expertise.
• Designing database, creating outlines, data load rules and Dimension Build rules files.
• Experience in writing Essbase calculations scripts, Report Scripts automated the Essbase Cubes using MaxL, Esscmd, MDX and Batch Scripts.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Financial Consolidation using HFM, and Data mapping and Data loading using FDMEE
• Build the HFCM/ARM applications for Financial close management
• Created the Hyperion Planning Application for Workforce and Capital Plan Types
• Work with Financial Close management (FCM)and Account Reconciliation Modules(ARM) for month end activates
• Build the RPD files for OBIEE,(Physical, BMM, Presentation layers),
• Build the OBIEE report using Subject Area, Analyses for different Regions
• Proficient Design and develop Essbase applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Proficient in Managing Security for Users and Applications
• Experience Migrating from BSO to ASO.
• Design, develops and maintains Hyperion Planning web forms, business rules, and security and Planning Administration tasks. creating a Public Sector Planning and Budgeting application and Preparing Forms and Enabling Custom Forms, Accessing, Reviewing, and Approving Decision Packages and Budget Requests from Task list
• FTE, Headcount, Overtime, and Vacancy Calculations for TE and Short-Term Disability, and Maternity Leave
• Implementation of Workforce Planning and Capital assets applications for headcount, salary, and compensation planning
• Created all Income Statement, Balance Sheet, Financial Reporting templates using Excel VBA and reports in System BI+.
• Using Hyperion Calculation Manager (HCM) build the business rules and debugs calculation scripts in Oracle Hyperion Essbase and Hyperion Planning. wrote VBA programming for the Budget processing using Essbase API’s and functions in Excel
• Wrote SQL queries,StoredProcedure, T-Sql, for reporting
• Experience in Optimization and performance tuning of Hyperion ESSBASE applications
• Strong Data Warehousing ETL Informatics Tools & Business Intelligence knowledge
• Experience includes Implementation, Maintenance and Production Support, working with tickets and resolving the issues
• RDBMS experience with Oracle11g,DB2 and MS SQL Server

TECHNICAL SKILLS

OS System: UNIX and Windows, Linux OS, Exalytics

OLAP Tools: Hyperion Essbase11, MS Analysis services, cognos 10

Reporting Tools: Hyperion Financial, Reports, Interactive Repots, Web Analysis, Hyperion Reports x, Hyperion Analyzer, Crystal Reports

Business Intelligence Tools: HFM, Hyperion Planning, ODI, FDM, MDMDimensional Modeling Star-Schema Snow-Flake Modeling, Fact and Dimensions Tables

Data warehousing Tools: Informatica, Congo’s 10

Web Servers: Apache Tomcat, Web Sphere 5.1/5.0, Web logic.

Databases: Oracle 11g/10g/9.x/8.x, MS SQL Server 2008/7/5, MS Access, DB2

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Hyperion Planning Architect

Responsibilities:

• Gathering the function requirement from financial users and Preparing Technical Design Document (Budget Process) for the Hyperion Planning Application
• To maintain month end Close process and year end process from People Soft Source system to Essbase databases(Actual load process MEC)
• Implementation of EPM Workforce Planning and Capital assets(CAPEX) applications for headcount, salary, and compensation planning creating a EPM Public Sector Planning and Budgeting application, create budget type for the level of driver-based compensation budgeting to use to derive overall compensation budget expenses.
• Implementation of Public Sector Planning and Budgeting creates predefined accounts, System Members, Unspecified Account, Human Capital Planning Accounts, Revision Properties, Segment Descriptions
• Create positions and assign employees to positions, Define entity-specific allocation and compensation defaults for new positions
• Build the Planning applications/cubes and Essbase Applications/Cubes in 11.1.2.3 version.
• EPMA application, using metadata structure for creating the Planning application
• Dimension Library, for metadata on the shared and local dimensions used by EPMA-applications
• Data load and data mapping using FDMEE, Rule and scripts for Accuracy of data
• Budget detail to budget employees by their assignments to positions, which drive compensation expense calculations
• Developed planning Web Forms for the users to easily input budget and forecast information
• Primary support for Maintenance and Production Support, working with tickets and working with functional team, resolving the issues
• To main the actuals from People Soft to Essbase databases up to date Created reports Profit & Loss, Balance Sheet statement
• Created all Income Statement, Balance Sheet, Financial Reporting templates and reports in System BI
• Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Hyperion Capital Asset planning of capital assets and capital asset-related expenses, such as depreciation, maintenance, and insurance.
• Developed planning Web Forms for the users to easily input budget and forecast information
• Load Budget data to Planning Application using input forms
• Calc scripts, report scripts, security and overall maintenance Hyperion Essbase
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• To Create and maintain the security using Hyperion shared Services
• Migration of the Essbase Application from Development to Production using LCM.
• Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Feed Budget data to ASO Reporting cube on an established frequency to enable users to have an aggregated view of the submitted Budget data
• Involved in loading metadata into planning by using Oracle Data Integrator (ODI).
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL, Outline, Load rules).
• Monitoring the System Performance by using Accelaties tool
• Responsible for, Backup and Recovery of the cube.
• Build the RPD files for OBIEE,(Physical, BMM, Presentation layers),
• Build the OBIEE report using Subject Area, Analyses for different Regions
• Using ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Involved Created ESSCMD Maxl Scripts for ESSBASE Automation process
• Involved in Error Handling, Trouble shooting, Handling restructuring and server problems

Environment: Exalytics server with Hyperion 11.1.2.4, Essbase Administration Services, Hyperion planning,ESSCMD, MS-Excel Add-in, Excel VBA, VB Script, Hyperion Reporting Tools, MS Sqlsever2010, People soft, web analysis studio, Financial Reports, Interactive Repots, workspace,OBIEE11g

Confidential, Saint Louie’s MO

Hyperion Essbase senior Consultant

Responsibilities:

• To maintain month end Close process and year end process from People Soft Source system to Essbase databases
• Primary support for Maintenance and Production Support, working with tickets and working with functional team, resolving the issues
• To main the actuals from People Soft to Essbase databases up to date Created reports Profit & Loss, Balance Sheet statement
• Created all Income Statement, Balance Sheet, Financial Reporting templates and reports in System BI
• Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Build the Planning applications/cubes and Essbase Applications/Cubes in 11.1.2.2 version.
• Implementation of Workforce Planning and Capital assets(CAPEX) applications for headcount, salary, and compensation planning
• Hyperion Capital Asset planning of capital assets and capital asset-related expenses, such as depreciation, maintenance, and insurance.
• Developed planning Web Forms for the users to easily input budget and forecast information
• Involved in Structure changes and creating Alternate Roll up’s.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Managed Metadata structure in HFM from existing hierarchy for all dimensions.
• Calc scripts, report scripts, security and overall maintenance Hyperion Essbase
• To Create and maintain the security using Hyperion shared Services
• Migration of the Essbase Application from Development to Production using LCM.
• Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Outline of ASO &BSO cubes are synchronized by using Outline Extractor.
• Involved in loading metadata into planning by using Oracle Data Integrator (ODI).
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL, Outline, Load rules).
• Responsible forPerformance Monitoring, Backup and Recovery of the cube.
• Using ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Involved Created ESSCMD Maxl Scripts for ESSBASE Automation process
• Involved in Error Handling, Trouble shooting, Handling restructuring and server problems

Environment: Hyperion 11.1.2.2, Essbase Administration Services, ESSCMD, MS-Excel Add-in, Excel VBA, VB Script, Hyperion Reporting Tools, MS Sqlsever2010, People soft, web analysis studio, Financial Reports, Interactive Repots, workspace,OBIEE11g

Confidential, Los Angeles, CA

Hyperion senior Consultant

Responsibilities:

• As a Senior Consultant working with Finance team to gather requirements and Resolving the issues
• Created reports Profit & Loss, Balance Sheet statement (GL,B/S,COGS,PCA,CCA)To maintain month end Close process and year end process from SAP Source system to Essbase
• Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Build the Planning applications/cubes and Essbase Applications/Cubes
• Implement the Workforce Planning application to driver based for Employee information
• Implement the Capital asset planning for Pre-built functionality and plan for all capital expenses
• Developed planning Web Forms for the users to easily input budget and forecast information
• Involved in Structure changes and creating Alternate Roll up’s in Web Forms.
• Developed load rules, calc scripts, report scripts, security and overall maintenance Hyperion Essbase
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Managed Metadata structure in HFM from existing hierarchy for all dimensions.
• Migration of the Essbase Application from Development to Production using LCM.
• Design and develop the Hyperion Financial Management Consolidated Web -based Applications
• Develop Business Rules to copy data from one version to another using Run-time prompts.
• Outline of ASO &BSO cubes are synchronized by using Outline Extractor.
• Involved in loading metadata into planning by using Oracle Data Integrator (ODI) .
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL, Outline, Load rules).
• Using ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Involved Created ESSCMD Maxl Scripts for ESSBASE Automation process

Environment: Hyperion ESSBASE 6.5/7.2/9.3/11.1.2.3 , Essbase Administration Services, ESSCMD, MS-Excel Add-in, Excel VBA, VB Script, Hyperion Reporting Tools, MS Sqlsever2008, SAPCOPA, web analysis studio, Financial Reports, Interactive Repots, workspace

Confidential, New York city, NY

ESSBASE Developer

Responsibilities:

• Design architecture diagrams and hardware recommendations.
• Upgrade the Essbase Severs from 6.5/7.2/9.3.
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL API, Backup, Outline, Load rules).
• Experience promoting objects from development to production in same environments
• Design, develops and maintains Hyperion Planning web forms, business rules, and security and Planning Administration tasks.
• Involved in cube enhancements of adding new units into Aantaylor business
• For Automating and coping the cube from Dev to Prod wrote the Unix Shell Scripts
• Wrote the Java Scripts For Event Handling the Interactive Reports
• Creating Groups & Users and level of access based on their Roles.
• Backup & Recovery of Production Databases & supported the production application
• Installed in the Excel Add-ins and Smart view and test VBA ' API' to run the Macros
• Created templates/Reports for business users using ESSBASE Add-In for Excel
• Created ESSCMD Scripts for ESSBASE Automation process

Environment: Hyperion ESSBASE 9 B I+, Essbase Integration Services, ESSCMD, MDX, MS-Excel Add-in, Excel VBA, VB Script, Java Script Hyperion Reporting Tool, Oracle 10g, and Unix Shell script, web analysis studio, Financial Reports, Interactive Repots, workspace

Confidential Stamford, CT

ESSBASE Developer

Responsibilities:

• Involved in gathering requirements from Business users and implementing in to ESSBASE cube design
• Developed Excel macros using Hyperion Essbase API’s.
• Created outlines and optimized them by grouping and positioning
• Written various Calc Scripts & modified existing scripts based on the reporting needs
• Created reports using ESSBASE Query Designer (EQD) for business
• Involved in creating Groups & Users and level of access based on their Roles.
• Involved in Backup & Recovery of Production Databases & supported the production application
• Created user formatting templates using Excel VBA for users entering the data in to templates
• Wrote Load Rules and data Builds using SQL Schemas.
• MS analysis services, reporting services and integrations services using MS Sql server
• Wrote Stored procedures for MS Reporting services
• Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
• Created templates/Reports for business users using ESSBASE Add-In for Excel
• Involved Created ESSCMD Scripts for ESSBASE Automation process
• Trained Management on ESSBASE, EQD & Excel Add-In
• Environment: Hyperion ESSBASE 7.5,/6.5.1, MAXL, ESSCMD, MDX, MS-Excel Add-in, Excel VBA, SQL SERVER 2000 and Windows, Informatica

Confidential, Pasadena, CA

Hyperion Developer

Responsibilities:

• Involved in developing Filters & Security matrix
• Loading data in to the cube
• Writing Calc Scripts & Report scripts
• Involved in Optimization of Data Loads
• Involved in writing Data load Rule files using Data Prep editor using application desktop window
• Involved in Writing Calc Scripts & Report scripts
• Involved in writing scripts for DOS Batch files.
• Involved in optimizing the calc scripts.
• Coordinated in training sessions and demonstration of HYPERION ESSBASE to End-users.
• Loading data in to the cube
• Writing Calc Scripts & Report scripts
• Involved in Optimization of Data Loads and Calc Scripts
• Developed Excel Templates for user interface in ESSBASE database
• Involved in creating reports using Hyperion Analyzer
• Created Formatted Reports by using Hyperion Reports
• Used MAXL, ESSCMD in an interactive and batch mode to load data files
• Involved in writing MAXL, ESSCMD scripts for ESSBASE production operations
• Developed and maintained Rule files, Calc Scripts, MAXL Scripts & Reports.
• Involved in installation and up-gradation of Hyperion ESSBASE, ESSBASE Integration Services (EIS)
• Involved in writing Test scripts for Data validation
• Involved in Production support of FSRS system.

Environment: Hyperion ESSBASE 6.5,,Analyzer 5.0, Reports 2.0, MAXL, ESSCMD, MS-Excel, ORACLE and Windows NT

Confidential

Programmer Analyst

Responsibilities:

• Involved in requirements collection, analysis, design, implementation, integration, testing and validation and deployment of the PEA Vehicle Maintenance Management, Accident Management modules.
• Developed Java script functions for client side validations.
• Involved in integration of modules.
• Involved in writing of test cases, test plans, system and functional testing.
• Involved in estimation and impact analysis of the change requirements.
• Involved in bug fixing during maintenance phase.
• Responsible for the optimization of the system performance and Quality Reviews.

Environment: Visual Basic 6.0, Crystal Reports, SQL Server, ASP, Oracle 7, VB Script, JavaScript, HTML and IIS.