SUMMARY:

• Over 9 years of detail - oriented, skilled professional experience in Relational Databases, Data warehousing (Hyperion/OLAP), Client-Server applications, Oracle and SQL Server Database Administration.
• Five plus years of implementation experience as Hyperion Developer, Planning Administrator, hands on experience using Hyperion ESSBASE, Planning, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports, Hyperion SQR, Hyperion Analyzer, Financial Reporting Studio environments.
• Thorough knowledge of the SDLC and also the entire life cycle of Data warehouse design, development and implementation.
• Expertise in architecting complete data models combining multiple transaction systems ETL tools and relational and multi-dimensional data stores for star schema, snowflakes schema designs and reporting tools.
• Proficient in the development of ETL processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.
• Hands on experience in installation, configuration and maintenance of Hyperion Shared services 11.x/9.x, Hyperion Essbase 11.x/9.x, Administration Services 11.x/9.x.
• Responsible in migrating Hyperion 11.1.2.1. To 11.1.2.3.500 and 9.x to Hyperion 11.1
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outline.
• Commendable knowledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Strong experience as Essbase Cube Analysis & Design, Essbase database Administration and performed upgrades, Maintenance, database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
• Experience and proficiency in functional and technical development for Hyperion Planning application involving budgeting, strategic planning, forecasting Capex planning and workforce planning. Experience in application implementation in different industry sectors. Solid understanding of Planning architecture and solutions expected by client.
• Extensively involved in generating monthly/quarterly financial reports (Balance sheet Statement, cash flow statement) using Hyperion Intelligence, Hyperion Analyzer, Hyperion Reports and Hyperion Essbase Spreadsheet Add-in.
• Worked on financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase also, building Financial Budgeting and Forecasting OLAP applications.
• Responsible in providing production support, maintenance, development, and administration of Essbase cubes.
• Involved extensively in developing load rules, calc scripts, automation scripts, and partitioning.
• Strong knowledge of Financial Domain using Hyperion Financial Management Suite (HFM).
• Experienced in knowledge transfer, preparing the required documentation, the clients.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle/SQL Server databases.
• Strong communication, organizational and interpersonal competencies along with detail oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS:

OLAP Expansion Tool: Hyperion System 11/9 BI+ Analytic Administration Services, Hyperion Planning System 11.1.X/9.X, Capex Planning, Hyperion Shared Services 9.3, Web Forms, Hyperion Essbase 11.1.2/9.X/7.X/6.X, Essbase Integration Services 7.X/6.X (EIS), Hyperion System 9 Smart View, Essbase Excel Add In, ESSCMD, MAXL, MDX, Hyperion Reports 7.2/7.0, Hyperion Financial Reporting Studio 9.3,, Life Cycle Management(LCM),Hyperion Performance Suite,, Hyperion DRM, Hyperion MDM.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View.

Languages: C, C++, SQL, PL/SQL, Java, Java script and HTML.

Databases: Oracle 11,9i/8.x/7.x/6.x, DB 2, MS Access, MSSQL Server

Markup Languages: HTML, DHTML, XML, XSL

Web & Application Server: Apache Tomcat web server, Microsoft IIS, Web logic 9.x 10.x

Operating Systems: MS-Windows XP/ /NT/98/95, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Hyperion Planning Developer/ Admin

Responsibilities:

• Involved in creating functional & technical specification documents depending on the Business requirements.
• The project involved in implementing a new budgeting cube for the existing General Ledger.
• Involved In upgrading Hyperion suite from 11.1.2.1. To 11.1.2.3.500 and also creating interfaces with ODI and SQL.
• Migrated all the existing planning apps and Business rules.
• Worked with Treasury to create a cash based forecast model and also created reports for the cash management.
• Built ODI integrations to load actual data for cash from Accounts Payable (AP) and Accounts Receivable (AR).
• Created master repository and interface in ODI. Also, Automated ODI Process by creating various interfaces to load metadata into planning application.
• Created SQL scripts to extract data from Oracle EBS for GL and populate SQL staging tables.
• Created a number of web forms to enter, update, analyze, print, and report on data. Also, created Task lists, planning units to ease the work of the users when working with the web forms.
• Performed optimization of data forms, report scripts, Calc Scripts, business rules.
• Developed simple to complex calculation scripts to arrive at the aggregated data for each application based on the functional specifications.
• Maintained database for optimum performance for using calculation scripts and business rules.
• Assisted the integration of Interactive reporting process along with streamlining of method improvement for data collection and loading processes.
• Created various process automation using ESSCMD and MaxL Scripts.
• Involved in performance tuning of database modifying the cache & essbase.cfg file settings.
• Initiated, developed workforce planning cube with metadata and data from oracle HR with their existing employees. Created business rules to Add/Remove employees, plan departures, transfers, add/remove benefits, plan TBH’s and budget the employee expenses.
• Developed various A.S.O and B.S.O Cubes for reporting purposes.
• Created a number of new users in the native directory meeting with their security standards, setup user and group level securities using shared services and implemented dimension level security.
• Involved in Loading metadata and data into Planning and Essbase.
• Created a number of Reports for their existing Application and for the new planning application as well. Created P&L variance reports, Expenses by departments-Activity-product-project in a monthly-quarterly-yearly, using some complex FR functions, used UDA’s in the reports when needed. Also, created some Ad-hoc reports with Smart view.
• Created content and trained all the business users on smart view 11.1.2.5.400
• Designed various financial reports on Balance Sheet, Income Statement and Cash Flow.
• Prepared documents for the End-users and was responsible for their, for administration and support.
• Created automated backups procedure for the application.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.

Environment: Hyperion Shared Services v 11.1.2.3/11.1.2.1, Hyperion planning Web app, Workspace, Hyperion interactive reporting, Amazon Cloud Services, Hyperion Financial reporting studio, Hyperion Web Analysis, Excel-add in, Hyperion Smart view, Essbase Administration Services (EAS), Oracle data integrator (ODI), SQL, Windows server 2003.

Confidential, Chandler,AZ

Sr Hyperion Consultant/Developer

Responsibilities:

• Involved in the requirements gathering, and had a role in creating the Design document.
• The project involved implementing a new Project Budgeting cube. Worked closely with IT and Business and Functional consultants to finalize the Project Cube design.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion Interactive reporting studio.
• Performed system maintenance, supporting and monitoring of production environment, resource management, evaluating and implementing patches, performance tuning as well as security maintenance.
• Successfully installed Hyperion Shared Services, Hyperion planning, workspace, Financial Reporting Studio for V11.1.2.1 in all the environments.
• Automating of cube refresh through MaxL and UNIX scripts.
• Used HAL to create dimensions in the planning application, also, had to create new dimensions to meet the application demands.
• Created a number of web forms to enter, update, analyze, print, and report on data. Created Task lists to ease the work of the users when working with the web forms.
• Developed and maintained Web Forms, Task lists and Planning Units and managed security for the same.
• Used EIS to create logical OLAP model from tables, views and columns tocreate meta-outline containing the structure required to generate Essbase outlines.
• Developed a few complex Business Rules and attached them to the web forms. Also, created a few calculation scripts when needed.
• Created a number of new users in the native directory meeting with their security standards.
• Involved in running ODI interfaces and EPMA profiles to load metadata.
• Setup user and group level securities using shared services.
• Created dimension level security for each of these users/Groups.
• Involved in Migration of Calc Scripts, Business rules, Task lists, Menus, Data forms, and Security using LCM.
• Created a number of Reports for their existing Application and for the new planning application as well. Created P&L variance reports, Expenses by departments-Activity-product-project in a monthly-quarterly-yearly, using some complex FR functions, used UDA’s in the reports when needed. Also, created some Ad-hoc reports with Smart view.
• Developed Essbase cube & loaded data file extracts from HFM for reports validation.
• Created Web Analysis reports for the users for those reports where they wanted to use the Drill down Functionality effectively and some Ad-hoc reporting.
• Created shell scripts & Maxl scripts to load Actual & Budget data.
• Involved in Optimization & Performance tuning of Cubes/Outline/Data load/Calculations.
• Prepared profitability reports detailing price/volume trends and expense variance over previous periods by usingFinancialReporting & Web Analysis.
• Monitoring the current Production environment servers for performance and stability.
• Prepared documents for the End-users and was responsible for their, for administration and support.
• Created automated backups procedure for the application.
• Worked on importing hierarchies from Budfcst App’s into EPMA dimension library.
• Developed Books from the Financial Reports.
• Using Life Cycle Management (LCM) exported & imported Dimensions, Financial Reports from Dev to QA.
• Created an archive cube to save the data every week, from the planning application to a standalone Essbase application for the reporting needs of the client. Automated this process as well.

Environment: Hyperion Essbase 11.1.2.1, Financial Reporting 11.1.2.1, Oracle PBCS, UNIX Shell Scripts, Workspace 11.1.2.1,, Hyperion Planning 11.1.2.1,, EAS, EIS, DB2, Windows 2008 server, Excel Add-in, EBS. Hyperion Shared Services 11.1.2.1, Hyperion Smart view.

Confidential, Boston,MA

Sr Hyperion Consultant / Developer

Responsibilities:

• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Involved in creating Meta outlines using Metadata extracts from PeopleSoft files in Hyperion EPMA.
• Developed Data Load Rules, Calc Scripts & Report Scripts.
• Involved in automation ofEssbase Cuberefresh, securityset upusingMaxL shell scriptand interacted with the users to gather report requirements and there upon designed reports and also utilized theEssbase Query Designerto customize query builds and generate tailored reports to illustrate details in a spreadsheet format.
• Created ASO cube for historical data linked to forecast cubes by partition.
• Created new members into the Existing hierarchies with the desired member properties as per the client’s requirement, using the ADS files.
• Developed a Planning application from the created dimensions and successfully deployed it.
• Worked extensively on planning application for Planning, budgeting and Forecasting (PBF), Business Rules and web forms for planning users.
• Created web forms to enter, update, analyze, print, and report on data.
• Developed the Consistent Financial & Interactive Reports & moved them to Production.
• Developing numerous simple to complex Business Rules and attached them to the web forms.
• Worked on creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions, and security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Used Life Cycle Management (LCM) for migrations between different environments, Development to QA, QA to production.
• Worked on Excel spreadsheets using Excel-add in for data cleansing and validation.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Involved in Loading Sales, Revenue, and Head Count Data to cubes, creating current Actual/Forecast/Budget members.
• Involved in creating cubes, outline modifications, maintenance of batch scripts, scheduling runs, developing report scripts and load rules.
• Worked on in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Developed web forms using Hyperion Planning for the users to input data.
• Developed various financial reports on Excel spreadsheets add-In using Essbase Query Designer for analyzing the data at different levels and for data validations.
• Involved in mapping data from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Created Web Analysis reports for the users for those reports where they wanted to use the Drill down Functionality effectively and some Ad-hoc reporting.
• Involved in filing Service requests (SR) to the Oracle if there were any production issues.
• Detailed documentation for everyday- easy to use maintenance guide for DBAs and financial controllers.

Environment: Hyperion Workspace 11.1.1.3/9.3, UNIX Shell Scripts, Enterprise Performance Management Architect (EPMA) 11.1.1.3/9.3, EAS 11.1.1.3/9.3, calculation manager, Life cycle Management (LCM), Smart view, Excel Add in, Microsoft Access, Windows XP.

Confidential, Sunnyvale,CA

Hyperion Essbase Developer

Responsibilities:

• Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis, HFM and Smart View.
• Maintaining the Existing Hyperion Planning Environments.
• Coordinated Hyperion application migrations across the Environments, Security set-up and ongoing support.
• Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
• Discussed with clients on user needs and analyzed their business requirements in converting draft outlines into technical and functional specifications of Essbase.
• Extensively involved in the financial planning model calculations i.e. (Actual, forecasts, Profit, Elimination and Consolidation and Headcount)
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion System 9.x.
• Performed Unit testing for both break/fix and maintenance/minor enhancements.
• Coordinated Disaster Recovery Planning and Capacity Planning.
• Applied software patches to resolve the issues encountered by Hyperion system 9 bugs.
• Created and maintained batch - jobs (UNIX and Windows) which automate Data Loads, Calculation and developed scripts for automation of services start up and stop up using Control-m Scheduler.
• Maintained Hyperion Application on virtualization and remote access software CITRIX.
• Debug and enhance various calculation scripts and business rules.
• Maintain outline, metadata and member formulas as business requirements.
• Created and provision the users with necessary roles on applications using Hyperion Shared Services and in Hyperion Planning.
• Maintained Rules file for loading of data using Essbase administrative services and loading the metadata using Enterprise Performance Management Architect.
• Installed and maintained Load Balancing software BIGIP.
• Loaded planning applications using ODI.
• Conducted essbase performance tuning and troubleshooting activities such as periodic export and data load, re-arranging the dimensions for optimized performance.
• Managed Hierarchies, Business Rules, Mappings and Validations using Data Relationship Management (DRM) and Hyperion Application Link (HAL).
• Implemented robust data-access security and user management.
• Configured and maintained MSAD and OID with the shared services and implemented single sign-on.
• Automated data loading from multiple sheets using MaxL.
• Tuned Analytic services for optimal performance, data retrieval and calculation.
• Worked on Essbase Integration Services (Metadata workflow/filters/drill through reports using Hybrid Analysis).
• Provided oversight of the technical migration of the code and configuration in Hyperion Planning Environment.
• Coordinated in End-user and developed appropriate materials.

Environment: Oracle EPM System 9.3.1, Hyperion Planning 9.3.1, Hyperion Analytic Services 9.3, Shared Services 9.3, Business Rules 9.3, Enterprise Performance Management Architect (EPMA), Hyperion Data Relationship Management 9.3, Workspace 9.3, Financial Reporting Studio 9.3, Hyperion Financial Management, Hyperion web Analysis Studio 9.3, Excel Add-In, Smart View, MaxL Hyperion Application Link (HAL), Oracle 10g/9i, Sun Solaris 9, Red Hat Linux 4.0, Web Logic 910.

Confidential, Detroit, MI

Hyperion Planning / Essbase Consultant

Responsibilities:

• Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM 11.1.1.3, Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis, HFM and Smart View.
• Involved in gathering requirements and developing project plan & system level requirement definition(SLRD), defining functional specifications, developing design documentations and testing strategies
• Analyzing the raw data and converting it into valuable business information by design & development of appropriate cubes & reports provided seamless integration of historical, projected & derived data.
• Designed OLAP database to support Market strategy planning, Workforce planning, resource utilization and logistics for nationwide sales and operations.
• Assisted Project Manager with modifications of Planning application Entity and Accounts dimensions to improve application capabilities interacted with IT to develop overall system Security standards on Shared Services.
• Developed the Calc scripts and Business Rules to calculate complex values like Infrastructure, Net Income and YTD & MTD Commitment, Variance, Capital expenditures, Forecasts, Budgeted cash flow statements, & etc.
• Developed and managed Web Forms for users to input data values and created Task List, Menu’s for the assigned tasks in order to organize process flow and monitoring of budgeting process by business partners to meet deadlines.
• Extensively worked with Financial Reports & Hyperion Analyzer 11.x/9.x, Developed reports for annual planning and beyond, Budgeting monthly expenditures, Expense management and control, Reconciliation reports, comparing actual vs. budget expenditures using Financial Reports 11.x/9.x and Hyperion Smart view11.x/9.x.
• Developed Complex web forms for calculating workforce calculations and attached them to business rules and sequence for calculating workforce data like benefits, taxes and salaries using runtime prompts.
• Coordinated Hyperion application and planning artifacts migrations across the Environments, Security set-up and using Life cycle management (LCM) and command line prompts.
• Responsible for development of Workforce planning application in order to calculate workforce data such as FTE’s, Taxes, Economic factors for various employees based on their salary grades.
• Developed and implemented Sequences, RTP’s and Macros for business rules in order to stream line calculations and perform in a sequential order and reduced complexity.
• Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
• Setting up MAXL scripts to batch outline updates, data loads and Calc Script executions and automating Hyperion data load and created scheduled batches from Workspace using report and batch bursting techniques.
• Responsible for setting up securities to distribute the system among various levels of users who were accessing the database and also creating dimension and member level security for dimensions like accounts, entities and scenarios .Setting new groups and users under the modules of the organization and giving privileges according to their access requirements using single sign on.
• Trained end user in budgeting and forecasting using web forms for both general ledger and workforce artifacts and developing and running Hyperion and Excel Add-in and financial reports.
• Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
• Troubleshoot and resolve anyHyperionSystem related Issues.

Environment: Oracle EPM System 11.1.1, Hyperion Planning 9.3.1, Hyperion Analytic Services 9.3, Shared Services 9.3, Business Rules 9.3, Enterprise Performance Management Architect (EPMA), Hyperion Application Link (HAL), Crystal Reports,, Workspace 9.3, Financial Reporting Studio 9.3, Hyperion Financial Management, Hyperion web Analysis Studio 9.3, Excel Add-In, Smart View, MaxL, Teradata, Sun Solaris 9.