SUMMARY

• Over 7 years of IT experience in analysis, design, development, implementation, testing, reporting, administration and consulting in a Client - Server environment.
• Over 5+ years of technical and functional experience in analysis, design, development, application architecture and administration of various financial applications using Hyperion Essbase 11.x/9.x/7.x, Hyperion Financial Reporting, Web Analysis Reporting, Hyperion Planning 11.x/9.x, Essbase Administration Services (EAS), Essbase Spreadsheet Add-in, Hyperion Smart View, Essbase Query Designer on Windows and Unix environments. Well-versed in SDLC (Software Development Life Cycle).
• Designed and developed numerous cubes and multi-dimensional databases both ASO and BSO in Essbase with excellent balance of dense and sparse dimensions allocation strategy, arranged in an hourglass fashion. Developed several partitions for the Essbase applications.
• Extensive experience in planning, design, analysis, implementation, testing, quality assurance and administration in a client-server environment with expertise in developing business applications in Relational (RDBMS) and Multi-Dimensional (MDBMS) Databases.
• Extensive experience in end-to-end development process till product implementation and support process.
• Experience in Essbase Cube Analysis, Design and Maintenance, Essbase Database Administration Upgrades, Performing Database Backups, Performance Tuning and Optimization.
• Experience in Hyperion software installation, configuration, upgrading and then testing the applications and reports.
• Experience in loading the dimensions and data using Essbase Studio and Essbase Integration Services (EIS).
• Experience in applying several application related patches on the server environments.
• Worked on Dimension Building, Data Loading, Database Optimization, Data Partitioning.
• Good knowledge on DRM, FDM, EPMA and HFM.
• Extensive experience in Calculation Scripts, Report Scripts, Business Rules, Data Forms, Load Rules.
• Extensive experience with automation of cubes and batch scripting using Hyperion Scripting languages such as MaxL, Esscmd, Batch Scripts and Visual Basic API.
• Experience in developing application security process, creating users/groups, reporting folder security, security profiles and application access to different groups using filters and also by using Import Security Utility and Export Security Utility.
• Worked with several Business Units to understand their requirements and solving their issues.
• Good knowledge in the star and snowflake schema data modeling technique used to design for data warehouse and data mart.
• Worked on Workforce Planning to calculate the related expenses such as headcount, payroll, salary, taxes and health benefits.
• Worked in Star Command Center (SCC) to set up the process that supports applications and run backups automatically.
• Experience in understanding the source systems Oracle E-Business Suite and extracting the data the metadata from the system.
• Experience with Hyperion System 11.x/9.x in Interactive Reporting Studio, Dashboard Studio, JavaScript, and HTML.
• Experience in enterprise level applications that is based on Java and J2EE technologies including JSP, Servlets, Struts, Web Services.
• Extensive experience in trouble shooting the System Related and Hyperion issues with Oracle Support.
• Experience in migrating the applications and reports from one environment to other using the Life Cycle Management (LCM) Utility.
• Implemented coding through Oracle SQL and PL/SQL.
• Proficient in writing program through Oracle on UNIX and Windows platforms.
• Knowledge of integrating the Microsoft Office tools with OLAP Server.
• Experience in knowledge transfer, preparing technical documentation, training the users.
• Worked with Offshore teams for development and postproduction support and involved almost round the clock.
• Results-oriented individual who views challenge as an opportunity. A strong team player capable of working independently with excellent communication, analytical, and inter-personal skills.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x, Hyperion Planning 11.x/9.x, Financial Reporting, Web Analysis Reporting, Hyperion Interactive Reporting, Hyperion Shared Services, Hyperion Workspace, Essbase Administration Services (EAS), Excel Add-In, Hyperion Smart View, ERP Integrator 11.x, ESSCMD, MaxL, MDX, EPMA, HFM, Financial Data Management (FDM), Data Relationship Management (DRM), Essbase Studio, Essbase Integration Services (EIS).

Databases: Oracle 9i/11i, SQL Server 2000, MS Access

Reporting Tools: Hyperion System 11.x/9.x, Qlikview 9.0

Web Technologies: HTML, XML, VB Script, Java Script, JSP

ETL Tools: Knowledge in ODI

Languages: SQL, PL/SQL, Java, UNIX Shell Scripting

Operating Systems: Unix, Windows 2003/2000/NT/XP, Linux

Schedulers: Star Command Center, Autosys

Testing Tools: Win Runner, Load Runner

PROFESSIONAL EXPERIENCE

Hyperion Techno Functional Consultant

Confidential, Boston, MA

Responsibilities:

• Worked as a part of the Business Operations Team.
• Worked with different agencies/departments (around 150 agencies) which are involved in various state government organizational activities.
• Worked closely with the Budget Director on the budget cycle and frequent meetings on the system progress.
• Worked regularly with the IT team on the new enhancements and deliverables.
• Worked very closely with the agencies in getting the requirements and documented the requirements to the IT team.
• Performed the regression testing once after the IT team delivers the enhancements and written many test scripts based on the results in the regression and unit testing.
• Extensively supported agency users at the time of testing process and conducted group testing with many users.
• Worked extensively on the Workforce Planning web forms, Interactive Reports and tested all the IR forms and other reports and developed test scripts for each test process.
• Worked mainly on two (2) planning applications, Workforce related application and Spending Revenue related application.
• Worked very closely with the agency users in solving their application related issues, data related issues and other performance related issues.
• Created documentation is some cases to help the users in their Spending and Revenue process.
• Developed many detailed Job Aids for the agency and analyst users for each Planning application along with the process of few of important forms like Labor Cost Management, Leases Information, Employee Details etc.
• Trained the agency and analyst users on the planning application and also new enhancements in the applications.
• Communicated by sending a postcard (emails) to the MBA team and also all the users on the downtime, performance issues, and application related changes etc.
• Explained the users on the system compatibility for the Hyperion Version and advised many users to install the required Excel and IE Version.
• Worked in setting up the Platform and Budget Language Database security for many agency users in Central Client Maintenance, which is a custom functionality.
• Modified the excel template and logged all the daily issues (application, data, performance etc.) in the template
• Involved in modifying and creating a new shared project folder structure in tracking all the MBA (Massachusetts Budget Application) related issues, training issues, CCM requests etc.
• Attended the daily triage meetings with IT team to discuss on the issues during testing.
• Involved in providing suggestions to the IT team on few technical issues.

Environment: Hyperion System 11.1x, Hyperion Planning 11.1x, Hyperion Financial Reports, Hyperion Workspace, Hyperion Interactive Reports, Essbase Excel-Add in, Smart view, Windows NT.

Hyperion Consultant

Confidential, Research Triangle Park, NC

Responsibilities:

• Assisted in the Hyperion System upgrade from 9.3.1 to 11.1.1.3 in all the environments and migrated the reports and applications from system 9.3.1 to 11.1.1.3.
• Worked on procedures related to Planning, Essbase, Reporting with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Worked closely with business users to design, develop and enhance Hyperion queries.
• Worked as a team member in Hyperion Essbase & Planning Implementation.
• Worked on the regular Plan cycle update changes.
• Worked with the Oracle resource in creating few views for the schemas and making SQL changes whenever required.
• Worked on the load rules ODBC connection problems for all the environments to make it consistent.
• Developed many rules files as part of the plan cycle changes for analysis and forecasting and pull the data from the Oracle database and also modified the existing rules files.
• Involved in loading data from text files into Essbase cubes for analysis and forecasting.
• Developed several batch and maxL scripts for different purposes like loading data, calculating data, clearing data, rebooting servers, setting the substitution variables etc.
• Scheduled several jobs using the Windows batch scheduler as well as in the workspace by FR Batch Scheduler.
• Worked most often with the business to solve their system related issues as well as Hyperion issues.
• Involved in trouble shooting the system related issues with Oracle Support and worked on several service requests with Oracle on these system related and functionality issues.
• Worked on ad-hoc requests from business to give security access to different Essbase and Planning users. Involved in giving shared folder level security to different users on the servers.
• Involved in creating the security filters and assigned to the users for restricting the data from being accessed.
• Developed many calculation scripts, rules files and business rules to meet the ad-hoc requests of the business functionality.
• Developed Business Rules with run time prompts for planning web forms.
• Worked on database and security refreshes for Hyperion Planning and security refreshes for Essbase.
• Involved in the regular data load from the latest production backup text files into Essbase cubes and running the aggregations calc.
• Created and managed data forms, involved in implementation of decided budgeting process involving Planning units, starting review process, and entity hierarchy and workflow notifications.
• Worked to help the business in solving the FR studio issues, Web Analysis studio issues many times and created some FR and Web Analysis reports for testing purpose.
• Involved in the migration of the functional account from one domain to other domain.
• Worked on few important issues like to solve the excel frond end (VB Script) issue for the business, FR Books export and DB connection issue and FR Batches disappearance issue after server reboot, IE settings problem issues as it leads to re-initiate the BR twice after 15 minutes, FR reports red color and text values not displayed issue, FR email configuration and PDF generation issue, ODI settings in topology manager issue, EAS esssvr.exeservice issue etc.
• Worked on the LCM exports to copy over to the different external location with the help of remedy agency.
• Knowledge transfer to users regarding Hyperion smart view and its installation.
• As a member of the team, involved in resolving the issues related to Data corruption.
• Interacted with the production team to get appropriate data into Essbase cubes into staging and development and also worked with the production team to solve some of the end-user related issues.
• Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
• Developed several batch and xml files for the LCM export process and prepared a document on the disaster recovery process of LCM Process.
• Worked on the LCM Import process to migrate the applications and reporting artifacts to the desired destination location.
• Played an active role in debugging procedures by developing test cases.
• Worked on the 18 Essbase Applications and 2 Planning Applications.
• Implemented transparent and replicated partitions to link the databases and enable calculations for the Essbase cubes.
• Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with certain updates on data values.
• Used to take the manual back up of all the required Essbase and Planning applications when needed in staging and development.
• Involved in client interactions for enhancements in the existing applications and for supporting purposes.

Environment: Hyperion System 11.1x, Essbase Studio, Hyperion Planning 11.1x/9.x, Hyperion Essbase 11.1x/9.x, EASv11.1x, Hyperion Financial Reports, Hyperion Web Analysis Reports, Oracle 10g, Essbase Excel-Add in, Smart view, ODI, Windows NT

Hyperion Consultant

Confidential, Foster City, CA

Responsibilities:

• Worked on procedures related to Planning, Essbase, Reporting with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Involved in providing security authentication for the users of Hyperion Planning and Reporting and also maintained workflow management process.
• Developed security access to different users, groups in Essbase, Hyperion Planning and Reporting.
• Designed Filters using Essbase Administration Services and assigned them to different users and controlled their access to the database.
• Developed several maxL and batch scripts and automated most of the operations using these scripts.
• Worked extensively on security and access settings for the reports and cubes in Workspace and Shared Services.
• Involved in testing the web forms and scripts during UAT and helped the users in their test process.
• Configured different user directories such as LDAP, MSAD and migrated the users.
• Involved in supporting the Business users in Essbase, Hyperion Planning and Reporting issues.
• Provided technical guidance and support to end-users by developing documentations as per requirement.
• Involved in trouble shooting the system related issues with Oracle Support and worked on many service requests 24/7 with Oracle on system related and functionality issues.
• Involved in the knowledge transfer sessions from the technical team and also vice versa.
• Developed Dashboards using templates and JavaScript.
• Automated the monthly loading process using MaxL, Batch Scripts.
• Worked with user community to identify solutions to reporting requirements and enhance system performance.
• Worked in Star Command Center (SCC) to set up the process that supports applications and run backups automatically.
• Worked with ERP Integrator to load the data and metadata to the Hyperion Essbase and planning from the source systems.
• Involved in regular metadata and data refresh process in Essbase and Planning.
• Involved in the phases of the project life cycle like Development, Testing (performed UAT) and Production.
• Interacted with the end users in support process, troubleshooting the issues for Essbase/Planning applications.
• Managed the Hyperion Planning Administrative Activities.
• Involved in setting up the source system as Oracle E-Business Suite in the ERP Integrator.
• Involved in all the backup activities such as system backups, full backups and level 0 backups in Windows and UNIX.
• Worked on four (4) environments which are Development, Staging, Production and Disaster Recovery. Involved in the High Availability test on the Hyperion environments performed by the Oracle resource.
• Migrated all the applications and reporting artifacts from one environment to other using Life Cycle Management (LCM) Utility and Import Security Utility.
• Provided 24/7 Essbase technical support to all business units, offered suggestions and proposed solutions to resolve issues.
• Knowledge transfer to end users regarding new excel add-in (smart view) and its installation.
• Worked with all the teams on the frequency of metadata refresh, data load, substitution variables/objects change, add/remove security.
• Involved working in DRM, FDM and EPMA components during the daily metadata refresh process.
• Worked on FDM as part of data loading process.
• Involved in writing custom Essbase calculation scripts and business rules.
• Worked on the UNIX OS commands for different operations on the Essbase server, which is installed in UNIX environment.
• Monitored the services in Essbase daily in UNIX and running in case if there are any issues in the Essbase services.
• Developed rules files to do regular data load for some Essbase and Planning activities.
• Worked on few important issues like excel rows issue, mutex for synchronization error, smart view issues with the users, regular services issues, web logic console issues, maxL issues etc.
• Involved in production support and maintenance of existing Essbase and Planning cubes.
• Worked on the 3 Essbase Applications and 2 Planning Applications. Worked on both ASO & BSO Cubes.
• Assisted the Financial Reporting resource to work on some of the reports to meet the end user requirements.
• Involved in database and security refreshes in Hyperion Planning.
• Worked with the offshore team for the knowledge transfer sessions and also some of the support activities.
• Coordinated with different onsite teams all over the globe in the process of support activities to the end users.
• Involved in client interactions during projects, for enhancements in the existing application and for supporting purposes.

Environment: Hyperion System 11.1x, Hyperion Planning 11.1x, Hyperion Essbase 11.1x, EASv11.1x, FDQM, Oracle 10g, UNIX, Essbase Excel-Add in, Oracle E-BS 11.5.x, DRM, EPMA 11.1x, ERP Integrator 11.x, BI+ (Financial Reports, Web Analysis Reports), Windows NT.

Hyperion Consultant

Confidential, Hicksville, NY

Responsibilities:

• Worked on the procedures related to Planning, Essbase, Reporting with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Managed the Planning and Essbase Administration activities.
• Involved in regular data loads and metadata refresh process.
• Involved in the regular monthly maintenance process as a part for the users to enter the actuals and forecast data.
• Worked closely with the users to solve their Hyperion related application and data queries.
• Developed the maxL and batch scripts for the automation process and maintained the scripts.
• Monitored the daily night batch process, which executes all the calculation scripts and take the backups of Planning and Essbase applications.
• Manually worked on entering the exchange rates for the current and forecast months from the currency file received from corporate.
• Involved in setting up the security for few of the Essbase and Planning users.
• Worked on the task lists to modify as per the users to enter the actuals and forecast data.
• Worked with the users in solving their smart view related issues.
• Interacted with the users in sending out the emails for the Work Day and Down Time communication.
• Worked on setting up the security for the Essbase and Planning users.
• Worked on the Manage Approvals or Work Flow Management Process as a part to lock and unlock the users.
• Worked with the 13 Business Units on the Planning Administration Activities and in getting the Hyperion related requests.
• Worked on the SQL Management Studio on few stored procedures and trigger process.
• Monitored all the xml and batch files as part of trigger process during weekly maintenance.
• Regular verification of all the FR reports moving to two different locations after the trigger process.
• Worked on Reference Central, which is custom functionality, to update the hierarchies whenever I get any requests.
• Helped users in retrieving the data using smart view.
• Adding the kickoffs manually into Hyperion whenever an email received from Hyperion DB.
• Worked in creating the web forms when requested by the users and modified few business rules and calculation scripts.
• Involved in the regular client interactions for the enhancements of the existing applications and for the supporting purposes.

Environment: Hyperion System 11.1x, Hyperion Planning 11.1x, Hyperion Essbase 11.1x, EASv11.1x, Hyperion Financial Reports, Hyperion Shared Services, Hyperion Workspace, ERP Integrator 11.1x, SQL Management Studio, Essbase Excel-Add in, Smart view, Share Point, ODI, Windows NT.

Hyperion Analyst

Confidential, Memphis, TN

Responsibilities:

• Worked on procedures related to Planning, Essbase, Reporting with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Involved in the analysis of existing business model, requirements and mapping the traceability of the same.
• Designed, Developed and Implemented Planning applications and Essbase applications, which is now the platform for all the financial and reporting analysis.
• Maintained Essbase databases using Planning application to meet financial requirements.
• Involved in requirements gathering, design, development, implementation, production testing, and implementation of HFM, Planning and Essbase projects.
• Responsible for the continued modeling/design, extensions and implementation supporting reporting requirements for Hyperion suite.
• Created properties, formulas and exports in DRM to serve different reporting requirements for Essbase and Planning.
• Worked on Workforce Planning to calculate the related expenses such as headcount, payroll, salary, taxes and health benefits.
• Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Used Hyperion Financial Management (HFM) to improve productivity by accessing multiple data sources at the same time.
• Responsible for setting FDM security standards and administration of FDM roles across the company.
• Maintenance of previous Essbase cubes along with the newly designed cube.
• Optimization of data storage, which increased the performance of existing cubes.
• Designed load rules for Dimension build and data loads.
• Involved in automation of all operations using MaxL scripts.
• Designed new Calculation Scripts and Report Scripts.
• Created Security access to different users in both Essbase and Hyperion Planning.
• Designed Filters using Essbase Administrative Services (EAS) and assigned them for different users and controlled their access to the database.
• Involved in Monthly Hierarchy process.
• Responsible for taking timely back up of all the required Essbase and planning applications.
• Developed Dashboards using templates and JavaScript.
• Used Dashboard Studio Optimize Utility features to edit the Interactive Reporting documents for Move, Show or Hide, Lock and Unlock, Rename, and Delete sections.
• Involved in performance tuning to improve the query performance and also involved in performing database tuning by setting appropriate index, data and calc cache.

Environment: Hyperion Essbase 9.3.1/7.1.3 , Hyperion Planning 9.3/7.x, Hyperion DRM 9.3,Hyperion Interactive Reporting, EASv9.x, Hyperion Financial Reporting 9.3, FDM, Informatica, MaxL, Java Script, Excel Spread Sheet Add-In, Hyperion Shared Services, Hyperion Workspace, Smart View, HFM, Web Analysis Reporting, Windows 2000/NT.

Database Developer

Confidential

Responsibilities:

• Responsible for developing technical specifications from business requirements.
• Developed PL/SQL programs that included writing of Stored Procedures, Packages, Functions and Database Triggers.
• Developed PL/SQL queries to check the data.
• 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.
• 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.
• Used Visual SourceSafe for version control and performing various builds.
• Performed database and logbackups & restoration,backup strategies and scheduling the backups.
• Backing up System & User Databases and restoring them when necessary.

Environment: Oracle8i, PL/SQL, SQL*Plus, Windows NT, VisualBasic5.0.