SUMMARY

• Over 9+ years of professional experience in IT field with rich experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase, Cognos and other OLAP tools, Oracle Hyperion System 11.1.2, Hyperion System 9.3 BI+, Hyperion Planning, Financial Reporting, Interactive Reporting, Hyperion Analyzer/Web Analysis, Essbase Administration Services, ESSCMD, MAXL,SmartView, Excel add - in in, under Windows 2003/2008/NT4.0 and Unix environments.
• Experience in writing custom Essbase Calculations Scripts, Automating the Essbase Cubes using Esscmds, MAXL and Batch Scripts.
• Expertise in Creating Planning Application and Web Forms.
• Experience in the entire Life Cycle of Data warehouse design, development and implementation including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans.
• Strong understanding of dense and sparse strategy dimension allocation, performed dynamic calculations, and also developed report queries.
• Expertise in developing Financial and Budgeting reports.
• Expertise in creating ad-hoc queries, business analysis/models and reports using Hyperion Business Intelligence (Interactive Reporting) to provide the users with easy access to relevant information. Excellent in maintaining and updating queries, reporting, configuration tables, exception handling and data quality/control.
• Good experience in building financial budgeting and forecasting, sales profit margin, contribution margin, different calculations, with Hyperion Planning and Report.
• Strong program analyzing skills, with ability to follow project standards.
• Strong ability to understand new concepts and applications.
• Proficient in software documentation, technical report writing, flexible in work schedules and also having strong leadership qualities.
• Excellent verbal and written communication skills have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 7.x/ 9.2.0/ 9.3.0/9.3.1 /11.1.2 , Hyperion MS Excel Add-In and Hyperion Smart View 9.2.0/ 9.3.0/9.3.1 /11.1.2 .

Business Intelligent Tools: Hyperion Planning 9.2.0/ 9.3.0/9.3.1 /11.1.2 .,Hyperion Application Link (HAL) 3.5.1/ 9.2.0/ 9.3.0/9.3.1 /11.1.2 ., Hyperion Web Analysis Studio 9.3.0/9.3.1 /11.1.1.2. Hyperion Financial Reports 7.x/ 9.3.0/9.3.1 , Hyperion Interactive Reports 9.3.0/9.3.1 and Hyperion Workspace 9.2.0/ 9.3.0/9.3.1 /11.1.2 .

Database: MS SQL Server 2005/2008/7.0/6.0 , MS Access, DB2

Operating Systems: WINDOWS 98/00/ XP/7

Programming Languages: C/C++, SQL, PL/SQL, Visual Basic 6, and HTML

Web Designing & other Tool: Microsoft FrontPage, MS Office 2003/2007/2010

Dimension Modeling: Star Schema Modeling, Fact and Dimension Tables, Physical and Logical Modeling

Designing Tool: Microsoft Visio, Rational Rose, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Hyperion Analyst/Developer

Responsibilities:

• Responsible for gathering requirements and creating detail design documents.
• Established a workflow process to keep track of the plan, review the plan, and change the ownership and status of the planning unit.
• Designed Data-forms and custom Menus to allow users to key in the data. Also attached business rules with these data forms to calculate results based on the user input.
• Automated Task Lists to guide the planning users through a several sets of data forms, calculations, business rules, etc. required to complete the plan cycle.
• Created Smart Lists to create custom drop-down lists that users access from data form cells.
• Translated Excel Reports requirements into clear technical documentation. Documented design, development, test and maintenance processes and procedures for Report development activity.
• Worked with users to get detail information on translating Excel reports formula into Financial Reports formulas.
• Involved in creating Books for different departments and regions in Workspace.
• Created Ad-hoc reports using Smart View.
• Used Excel AddIn and Smart view to retrieve data from the cube to do data validation in the reports.
• Designed and developed different Monthly, Year-to-Date, FullYear, Fixed Income, and Accounts Reports for different Stations using Oracle Hyperion Financial Reporting Studio 11.1.2.
• Designed and developed user-friendly reports & graphs self-contained in financial models having drill downs and expansions as per user requirements with substitution variables, for comprehensive understanding of the data.
• Used latest Annotations commentary option for multiple reports.
• Scheduled batches for different timing and snapshots according to user requirements.
• Assisted users in using Hyperion Smart view to perform the drill-downs and ad-hoc reporting.

Confidential, Brackenridge, NJ

Sr. Hyperion Analyst/Developer/Administrator

Responsibilities:

• Responsible for gathering requirements and creating detail design documents.
• Responsible for modifying and optimizing the existing outlines.
• Optimized proper database calculations and loads by modifying the existing dimensions.
• Creating new Dense and Sparse settings of members by providing appropriate storage allocations.
• Involved in creating ASO and BSO Cubes using Essbase Admin Services (EAS) 9.3.1.
• Created Users and Groups in Hyperion Shared Services 9.3.1 and assigned privileges to them.
• Applied security on different applications by creating Filters on its dimension members.
• Responsible for providing technical and production support for more than 500 business users.
• Loaded data from flat files, Excel sheets, and SQL interface.
• Developed Excel Templates for user interface in Essbase database.
• Created and made changes to the existing MaxL Scripts and scheduled the batch script to automate daily production cube load process.
• Did daily monitoring of the Essbase cube to check the data is loaded and to maintain the dimension members.
• Analyzed and loaded data using SQL queries and also created substation variables for Time dimension.
• Responsible for migrating Essbase Application to Production.
• Involved in HFM installation and upgrade from 9.3.1 to 11.1.1
• Worked on user systems to install Excel Add-in and trained users on Excel client usage.

Confidential, New York, NY

Sr. Hyperion Developer/Analyst

Responsibilities:

• Translated Excel Reports requirements into clear technical documentation. Documented design, development, test and maintenance processes and procedures for Report development activity.
• Worked with users to get detail information on translating Excel reports formula into Financial Reports formulas.
• Created Linked Reporting Objects, which can be used in multiple reports.
• Involved in creating Books for different departments and regions in Workspace (ORBIT).
• Involved in creating complex batches with busting options.
• Used Excel Add In to retrieve data from the cube to do data validation in the reports.
• Designed and developed different Daily, Weekly, Monthly, Fixed Income, and Accounts Reports for different regions using Hyperion BI+ Financial Reporting Studio 11.1.1.2. Designed and developed user-friendly reports & graphs self-contained in financial models having drill downs and expansions as per user requirements with substitution variables, for comprehensive understanding of the data.
• Used latest Annotations commentary option for multiple reports.
• Scheduled batches for different timing and snapshots according to user requirements.
• Created Users and Groups and Provisioned to give limited access using Hyperion Shared Services 11.1.1.2.

Confidential, Houston, TX

Sr. Hyperion Developer

Responsibilities:

• Responsible for gathering requirements and creating detail design documents.
• Predefining data mapping from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Created Users and Groups and Provisioned to give limited access using Hyperion Shared Services 11.1.1.2.
• Created complex Web Analysis Reports using Hyperion Web Analysis Studio 11.1.1.2.
• Responsible for migrating Web Analysis reports to Production.
• And also responsible for maintaining users and security in Hyperion Web Analysis Reports and Hyperion Essbase applications.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions.
• Developed Complex Calc scripts for calculating weighted average days old.
• Developed Block Storage Cubes using Essbase Administrator Services 11.1.1.2.
• Updated cube by changing the hierarchy and building dimension in Parent child relationship.
• Involved in gathering requirements and developing project plan & system level requirement definition (SLRD).
• Created and made changes to the existing MaxL Scripts and scheduled the batch script to automate the running of the new Calc Scripts.
• Analyzed and loaded data using SQL query’s and also created substation variables for time dimension.
• Responsible for migrating Essbase Application to Production.
• Responsible for providing technical and production support for live applications and also for end users.
• Developed Technical Design documentation required for knowledge transfer to users for application administration and support.

Confidential, Irving, TX

Sr. Hyperion Developer

Responsibilities:

• Responsible for creating Planning Application as per the business user requirements.
• Designed and developed Web Forms, Calc Scripts and Business Rules.
• Hyperion Planning was used in testing of the new calculation scripts.
• Hyperion Planning was used to define business rules to match the needs of the users.
• Involved extensively in optimization/tuning of Hyperion Planning application.
• Created and mapped HAL jobs for loading dimensions and members into new Planning application from the existing the Essbase Outline and incorporated the extra changes for optimization.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions and efficient solutions in a timely manner.
• Usage of Hyperion BI+ Financial/Web Analysis/Interactive Reports
• Designed and developed 10 different reports for Invoice, Payment, and Past Due and Interval period using Hyperion BI+ Web Analysis Studio.
• Translated the requirements and reporting need into clear technical documentation. Documented design, development, test and maintenance processes and procedures for Report development activity.
• Designed and created new server Substitution Variables thereby narrowing down the management of a single calc script for current & prior month/year.
• Designed and developed 15 different Income and Budget Reports using Hyperion BI+ Financial Reporting Studio.
• Designed and developed user-friendly reports & graphs self-contained in financial models having drill downs and expansions as per user requirements with substitution variables, for comprehensive understanding of the data.
• Designed and developed different Income and Budget Reports using Hyperion BI+ Interactive Reporting Studio.
• Created different reports including dashboard sections to provide improved performance for pricing, inventory and policy decisions
• Developed ad-hoc queries, pivots, charts and reports using Hyperion intelligence for the end users based on their requirements. Responsible for creating different Oracle Procedures and View Tables for Interactive Reports.
• Created different reports with Oracle Procedure using Hyperion BI+ Interactive Reporting Studio.
• Responsible for maintaining and updating queries as well as reports for daily, weekly, monthly and quarterly reporting requests
• Responsible for end-user training with various applications and to view and access the reports through web.
• Involved in the designing the architectures and outline of the cube.
• Developed Cubes that includes creating dimension build rule file, data-load rule file.
• Created MaxL statements to automate the cube-build process.
• Developed complex MDX formulae for cube definition.
• Involved in creating ASO and BSO Cubes using Essbase admin Services (EAS).

Confidential, Reston, VA

Sr. Hyperion Administrator/Developer

Responsibilities:

• Involved in the full lifecycle of the project that involved development, UAT and production.
• Interacted with users to support analysis and provide definition and requirements for the Hyperion Planning Application and other Essbase supported processes.
• Responsible for troubleshooting and error handling production issues.
• Managed shared services by creating user groups and filters for different business segments. Recovered applications from its back up.
• Responsible to open Tickets with Hyperion support for product related issues and involved in working with Hyperion Support to solve the product related issues.
• Involved in creating SLA document. Involved in providing full support for Hyperion Planning.
• New security measures were set up using Hyperion Planning to accommodate for the new driver data block thereby maintaining Location Transparency.
• Responsible for scheduling batch jobs for planning application.
• Responsible for providing full support for all Applications in Hyperion System 9.2.0
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies. Involved in Back ups of all production cubes.
• Responsible for starting and stopping all Hyperion Services in production and development environment.
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how many forms, how many business rules, how many calc scripts are there in the developed application and what is all this use for in the application.
• Involved in creating documentation for all the log files in Hyperion System 9.2.0 Software.

Confidential, Glendale, CA

Hyperion Developer /Administrator

Responsibilities:

• Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan. Interacted with finance and accounting customers who possessed various levels of technical knowledge.
• Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members. Migrated Essbase server into newer versions and newer operating systems.
• Used incremental and complete backup methods to backup all the applications and databases.
• Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, Executive Viewer, and Hyperion Reports.
• Responsible for providing technical and production support for live applications and also for end users.
• Did daily monitoring of Hyperion Essbase cubes for errors and find out the cause of the errors if any.
• Create webpage on which there were links of the analyzer reports grouped according to Confidential Corp classifications. This webpage used Analyzer security and directly opened the reports required by high-level management without login into analyzer. Involved in providing security authentication for the users of Hyperion Analyzer, Essbase and maintaining workflow management process.
• Used smart view to provide enhanced integration with MS Excel and access to multiple data sources.
• Involved in creating Rule files and batch files to automate the data load process.
• Developed Data Loads and numerous Calc Scripts and optimized them. Used ESSCMD in an interactive and batch mode to load data files. Developed and maintained Rules file for loading of data.
• Installed, configured, set up Hyperion Analyzer and Hyperion Analytical server on Windows server.
• Analyzed financial results and prepared trend reports to support business managers make prudent and profitable decisions. As an administrator, created users in Analyzer and Essbase and assigned different roles to them
• Did daily monitoring of the Essbase cube to check the data is loaded and to maintain the dimension members.
• Run the member’s consolidation to calculate, translate, and consolidate data across different dimensions.

Confidential, Kent, OH

Oracle Developer / OLAP Developer

Responsibilities:

• Assisted senior DBA in installations and upgrades of various oracle products.
• Configured the oracle enterprise editions on the user computers based on the security specifications given by the Team Lead.
• Created SQL scripts for creating tables, views, stored procedures, loading data into the tables.
• Created PL/SQL scripts for two custom applications.
• One application accessed the inventory of the various servers and connections.
• One application accessed the disaster recovery database for the IT support group.
• Configured test servers, development servers with the help of system administrator.
• Wrote VB scripts to automate the creation of users and mailboxes in Exchange server 5.5
• Was responsible for moving cubes to production server using Cognos Powerplay series 7 for the sales department which used Hyperion EssBase as their OLAP Server. I was sent to boot camp for Hyperion EssBase learning due to my interest in OLAP technology.

Environment: Oracle 7.x, Win2000, Pl/SQL