SUMMARY

• Over 6 years of professional experience in development, implementation, migration, analysis, reporting, administration/support and consulting in a Client - Server environment with an expertise in EPM and Online Analytical Applications (OLAP) using Hyperion ESSBASE 11.x/9.x, Hyperion Planning 11.x/9.x, Workforce Planning, Hyperion Financial Reporting Studio, Hyperion Web Analysis, Hyperion Shared Services, ESSBASE Spreadsheet Add-in, Smart View, ODI, FDM, Hyperion Performance Suite and also acted as a Business Analyst /Hyperion Analyst. Well-versed inSDLC (Software Development Life Cycle).
• Extensive experience in planning, analysis, design, implementation, testing, quality assurance and administration in a client-server environment with expertise in developing business applications inRelational (RDBMS) and Multi-Dimensional (MDBMS) Databases.
• Worked on several projects in different domains like Financial Services, Bank, Health Care, Insurance and Retail Services.
• Expertise in the areas of Requirements Gathering, Business Analysis, Business and Functional Specifications Documentation, Project plan execution, Test automation and Documentation.
• Substantial experience in creating, maintaining and supporting all numerous application and database with excellent balance of objects including outlines, dense/sparse dimensions, members, attributes and UDAS across Block Storage (BSO) and Aggregate Storage(ASO) using Administrative Services Console tool.
• Developed and maintained Rules files for loading of data and building the dimensions dynamically. Detailed grasp of Hyperion Administration and optimization and performance tuning techniques relating to data loading.
• Worked on ESSBASE Integration Services and created OLAP models and Meta-Outlines.
• Load the metadata using ODI (Oracle Data Integrator).
• Used Outline Editor to restructure and modify existing dimensions, dimension members, attribute dimensions, and member properties.
• Used Time, Account Dimension tag and Storage Properties for cube optimization.
• Skillful in upgrades of Oracle Hyperion products, retrieval and modification through ESSBASE Excel Add-In and Smart view.
• Expert level creation of ESSBASE Rules Files, Business Rules, Calculation Script, working with different foreign exchange currencies. Automating and Partitioning the ESSBASE Cubes using MAXL and Batch Scripts.
• Expert in replicated and transparent partitions and security objects like filters through executing calculation.
• Technical experience gained in administration of Hyperion performance suit by using shared services for user/group accesses/privileges and assigning roles and responsibilities to groups of application organization.
• Rules Files, Indexing, formulas, cache management knowledge and overall system Architecture compiled with expertise in ESSBASE database Optimization and Calc Script optimization.
• Expertise in working on web analysis and for both input and output specific. Creating database connections and providing the authentication/security both for user and group access.
• Created reports using Dashboards/Hyperion Financial Reporting studio and Hyperion Web Analysis.
• Expertise in Functional aspects related to financial planning and analysis. Worked on Financial Consolidation to create applications.
• Successfully implemented Classic Planning Application as the business needs.
• Experience in working with all activities of Hyperion Planning applications.
• Expertise in designing Planning model using EPMA and setting up application using data forms, business rules, task list, workflow in Hyperion planning.
• Exceptional skills acquired in Planning Workspace by designing Web forms for data inputs, registering applications and retrieving data in real time.
• Expertise in implementing Workforce Planning and Capital Assets Planning.
• Performed metadata Load using outline load utility for different dimensions.
• Automate the data loading through MAXL Script Editor and batch files and schedule task windows.
• Created Shared Services, Security, Filters, Metadata Maintenance and Business Rules.
• Using Hyperion Planning created Web forms for the end users to input values for Forecast, Budget and Actual.
• Developed calculation scripts and member formulas using XREF also used the function to make data available from the source cube to the target cube.
• Strong Knowledge of financial reporting systems and Decision Support Systems (DSS) using Hyperion ESSBASE and developed Financial Budgeting and Forecasting OLAP applications-(Planning tools).
• Results-oriented individualwho views challenge as an opportunity.
• A strong team player capable of working independently withexcellent communication, analytical, hardworking and inter-personal skills.
• Experienced in knowledge transfer, preparing technical documentation, training the clients.
• Outstanding analytical and problem solving skills.
• Trained and assisted end-users with developing complex reports to meet requirements and developed ad-hoc analysis reports as needed.
• Proven ability to work in teams and handle stressful and time sensitive situations
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables.

TECHNICAL SKILLS

Hyperion ESSBASE/ Business Intelligence Tools: Pre System9, ESSBASE, ESSBASE 9.x/11.x, Hyperion BI+ Suite, Hyperion ESSBASE, Hyperion Planning

Hyperion Planning: Pre System9 Planning, Hyperion Planning 9.x & Hyperion Planning 11.x

Data Modeling: Star Schema Modeling, Snow-flake Modeling

Hyperion Financial Reporting: Hyperion Financial Reporting Studio 9.x/11.x, SQR, Hyperion Web Analysis

Hyperion Workspace, Shared Services: 9. x and 11.x

Hyperion Financial Data Quality Management: Hyperion FQDM 11.x

Reporting Tools: Hyperion Financial Reporting Studio, Web Analysis, Hyperion Reports, Dashboards, Smart View & Excel Add-ins, Hyperion spreadsheet Add In.

OLAP Tools: Hyperion ESSBASE System 11.X/9.X/7.X//6.X, Hyperion Planning 11.X/9.X/4.X, ESSBASE Integration Services, ESSBASE Administration Services 11.x/9.x/7.x/6.x, Hyperion Excel Add-In, MAXL, Hypérion Shared Services, ODI.

Databases: SQL, ESSBASE, Oracle 11.x/9.x/8.x, MS SQL Server 2000/2003/2005 , SQL Server Management Studio, Ms Access

Languages: SQL, PL/SQL, C, HTML, Shell Scripting

Operating system: Ms-Dos, UNIX, Win98/2000/XP, Windows Vista

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Hyperion ESSBASE and Planning Developer

Responsibilities:

• Involved in end to end architecture and design of ESSBASE/Planning applications.
• Worked with business analysts/End Users for gathering requirements, functional specifications, testing strategies and developing a project plan.
• Worked on the performance tuning (Cube Optimization) of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Shared members, Outline formulas and Calc scripts.
• Developed Batch Scripts and Rules files to dynamically upload dimensions and data from Legacy System to ESSBASE Cubes and multi-dimensional databases.
• Wrote MAXL Scripts to Automate the ESSBASE Load Process.
• Designed and developed numerous ESSBASE applications with excellent balance of dense and sparse dimensions, arranged in an HOURGLASS FASHION.
• Involved in Gathering Requirements for the Planning and Budgeting Cycles.
• Created Planning Applications to manage all their Budget, Forecast and Financial planning using Classic planning application.
• Involved with Hyperion planning budgeting application to add dimensions, assign member properties, dynamic time series, two pass calculation, variance reporting procedures, time balancing, currency dimension properties, overall metadata building and refreshing the data.
• Developed Excel Templates for user interface in ESSBASE database.
• Created new batch jobs and scheduled these batch files for complete automation process for nights and weekends calculations and backups.
• Worked with ESSBASE DBA for security management.
• Created Multiple Hyperion Ad-hoc Financial Reports, Web Analysis Dashboards, based on the requirements.
• Created Multiple Template’s of Smart View and Excel Add in for every day analysis of the user.
• Intensive troubleshooting was one of the requirements due to heavy data loads and the cubes were supposed to be available to the users 24/7.
• Created and managed data forms, involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
• Created Business Rules with run time prompts for planning web forms (consolidation, and currency conversion).
• Worked closely with the testing team to help them in data validation and issues related to it.
• Involved in installation and configuration of Hyperion software.
• Involved in total SDLC (software Development Life Cycle) with ESSBASE Cube development.
• Created Business Rules and assigned it to Various Data Forms according to the requirement.
• Created Data Sources for Planning Applications.
• Developed composite web forms and used smart lists, Task lists and Menus as per the user requirements.
• Security by creating different folders and assigning security to these folders in Hyperion Workspace.

Environment: Hyperion ESSBASE 11.x, Hyperion Planning 11.x, Workforce Planning, Hyperion Shared Services 11.x, Analytic Integration Services, Web Analysis, Dashboards, Financial Reporting Studio, Windows Scheduled tasks, MAXL, Hyperion Workspace, Microsoft SQL Server 2005, Excel Add-In, Smart View, Windows NT/2003, FDM, ESSBASE Utilities, Microsoft Windows XP.

Confidential, Denver, CO

Hyperion developer/Report Planning

Responsibilities:

• Involved in meetings with the business users to get the requirements, worked on documenting the Detailed Requirement Specifications.
• Worked on design and development of different cubes used for creating reports about various business strategies, decision-making and future planning.
• Created and maintained BSO cubes as per user requirements and performed OPTIMIZATION by using appropriate dense/sparse configuration, outline structure strategies such as dynamic loading calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Involved in developing design specifications of ESSBASE cube with customers.
• Developed Calc Scripts and Rules file for data loads and dimension builds.
• Developed batch scripts using MAXL and ESSCMDs to load/automate data from relational systems database to ESSBASE cube.
• Created the Planning applications with the plan types for Revenue & Expenses, Sales and corporate.
• Improved the Performance (Optimized the Planning, ESSBASE system) by changing the dimension order and working on configuration file including Cache design techniques.
• Created data forms for business users for budget, forecasting and estimates. Worked on reports and data forms to give the flexibility to the users to review the detail/summary data and to allocate the Budget/Forecast amount.
• Tested user connectivity to sample application and databases.
• Involved in troubleshooting Production issues in support to Planning Applications and all databases.
• Migration to new production server and supporting end user, planners for budgeting.
• Maintained security for Planning, Business Rules and ESSBASE.
• Creating Repository for Hyperion Planning Application.
• Developed and administered ad-hoc reports with Spreadsheet Add-in and Smart view.
• Developed Task lists and workflow process for all the Planning applications.
• Involved in developing Process management for workflow to promote the budget or forecast for different scenarios and versions.
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications.
• Created and designed the existing reports using Financial Reporting Studio and Web Analysis.
• Prepared Profitability Reports, which detail Unit Cost, Price/Volume Trends, and Expense Variances over prior periods.
• Very good knowledge of Budgeting, Forecasting, Financial planning, Balance Sheet, Income Statement, P&L Statements, Cash Flow Statement and Human Resource management.

Environment: Hyperion ESSBASE 11.x, Hyperion Planning 11.x, Capital Assets Planning, Hyperion Shared Services, Hyperion Interactive Reporting Studio, Web Analysis, Dashboards, SQR, Financial Reporting Studio, Hyperion Workspace system, Windows Scheduled tasks, Microsoft SQL Server 2005, MAXL, Excel Add-In, Smart View, ESSBASE Utilities, Windows NT/2003, FDM, Microsoft Windows.

Confidential, Warrenville, IL

Hyperion ESSBASE/Planning Developer

Responsibilities:

• Involved in Determining customer business requirements, project scope, and assisting the estimation of efforts.
• Involved in Developing and implementing applications for customers based on identified requirements.
• Developed Planning applications for Sales, Production, Planning and Budgeting.
• Developed outlines, Calc Scripts, Load Rules for loading dimensions and data into ESSBASE cube.
• Developed ESSBASE outline formulas and Calc Scripts using advanced Calc Scripts functions.
• Developed detailed Reports for every functional Unit, stocking, Price, Volume Trends and calculating Expense Variances over prior periods.
• Created graphical reports using web analysis which allows users to visualize the data and investigate the concerned areas.
• Developed batch scripts using MAXL for the automation of various processes.
• Optimized outlines to have faster data loads, calculation and retrievals.
• Created rich analytic applications using web analysis for powerful data analysis.
• Involved in assigning access and groups to various users of the company and maintained the applications securely using Hyperion System 9 Shared services.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Updated the planning applications to ESSBASE multidimensional database by performing Planning Refresh and involved in security refreshes.
• Developed web forms for Hyperion Planning applications for users to interact and forecast.
• Worked with moving, copying, and deleting an application in Planning.
• Managed Planning Task Lists.

Environment: Hyperion System 9 BI+ ESSBASE, Hyperion ESSBASE 11.x/9.3.x, Hyperion Planning 11.x/9.x, Hyperion Web Analysis, Hyperion Shared Services, Hyperion Financial reporting, Hyperion Excel Add-In, MAXL, Windows 2003/NT, Microsoft SQL server 2005.

Confidential, San Francisco, CA

Jr. Hyperion ESSBASE and Planning Developer

Responsibilities:

• Involved in gathering specifications, design and development of outlines for cubes.
• Involved in design and development of OLAP Models and Meta Outlines in ESSBASE Integration Server.
• Designed and developed data Load Rules using the Prep Editor in Hyperion ESSBASE and created outlines for cubes.
• Exposed and Involved in installation of System 9 BI + Software on Windows 2003 Server on development servers.
• Created report scripts to export the data out of ESSBASE cubes.
• Involved in estimating and tuning the ESSBASE database performance.
• Exported and imported all documents to Microsoft office documents using Web Analysis.
• Created reports graphically using Web Analysis for better visualization of data.
• Involved in supporting the applications on daily Maintenances, user creations and developing user interfaces.
• Created planning applications using Planning Application Wizard.
• Involved in design of planning web forms.
• Involved in determining the user experience from an end user budgeting and reporting Perspective.
• Involved in maintenance of Hyperion Planning cube, involved in creation of Web Forms, data refreshes and user creation in Planning.
• Involved in refreshing security and filters in Planning production environment
• Optimized data load forms in Hyperion Planning.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Provided security for various levels of users using Hyperion Shared Services.

Environment: Hyperion ESSBASE 9.x, Hyperion Planning 9.x, Hyperion Shared Services 9.x, Hyperion Financial Reporting, Hyperion Web Analysis, Hyperion Excel Add-In, PL/SQL, ESSBASE Administration Services 9.x, ESSBASE Integration Services 9.x, Oracle 9i/10 g, Windows 2003 Server.

Confidential, Tulsa, OK

ESSBASE Developer

Responsibilities:

• Developed batch files and rules files to upload files from financial system and data warehouse system to ESSBASE cubes.
• Assisted in creating rules files for multidimensional databases
• Developed Data Load Rules, Calc Scripts & Report Scripts.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Prepared Hyperion profitability reports, which detail unit cost, business volume trends, and expense variances over prior periods, for all BUs across the organization
• Through internal training and practical experience, got familiarized with budgeting system, mainframe applications and the General Ledger database.

Environment: OLAP Data Warehousing using Hyperion ESSBASE 6.5, Hyperion Analyzer 6.5, ESSBASE Excel Add-In and MS- Access.

Confidential

Jr. Database Programmer/Analyst

Responsibilities:

• Developed an application to monitor and control data load for Supply Chain System.
• Designed the databases in oracle for data load control and product maintenance.
• Designed and developed many forms to monitor various data load status.
• Created monthly reports using Oracle Reports and PL/SQL.
• Automated many processes using Oracle Job Scheduler.
• Created PL/SQL procedures, functions and packages to connect to Oracle Supply Chain System to pull information.
• Gathered Business requirements through interviews, surveys and interacting with Managers. Conducted brainstorming sessions.
• Designed data load integration scripts using PL/SQL.
• Developed many PL/SQL test scripts to test the load of products from the Product database.
• Developed many reports which were used by the client for forecasting and budgeting.

Environment: Oracle 7i, MS-Office, Windows 98/2000/NT, PL/SQL, SQL, EXCEL, Visual Basic 6.0.

Confidential

Jr. SQL developer

Responsibilities:

• To investigate and answer routine queries arising from Budget Holders,Management, Managers, suppliers and customers.
• To trade currencies and perform daily banking transaction using Nepal’s PUMORI PLUS Software. To apply basic accounting knowledge and techniques to all areas of work, including the production of journals, routine costing and variance analysis.
• Perform daily file import/export using SQL.
• Extensively used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
• Troubleshoot file import/export issues and SQL scripts/tasks.
• Provide quality control for automated processing tasks.

Environment: Ms-Office Suite, PUMARI Software, My SQL, SQL, Windows 98/2000 and Microsoft Access.