SUMMARY

• Over 9 years of professional experience in development, implementation, analysis, reporting, administration and consulting in a Client - Server environment
• Over 9 years of extensive experience in application designing and development using Hyperion Essbase 7.x / 6.x, Hyperion Financial Reports, Essbase ASO BSO cubes, Essbase Planning Data forms Hyperion Interactive reporting, HAL / DIM, Hyperion Reports, Essbase Excel Add-In and Hyperion Analyzer
• Experience in patches, upgrades and migration.
• Experience in design, Architect, and implementation of Data Warehouse systems Oracle Tools - OBIEE 10g/11g, Oracle 10i/11i, Essbase MOLAP and ROLAP technologies.
• Extensive experience in the installation, configuration, server settings, backups, client installations of Hyperion products such as Essbase, Essbase Integration Services, Analyzer and Hyperion Reports on both Windows and UNIX environments
• Extensive Experience with OBIEE 10g/11g (RPD, Dashboards, Metadata).
• Experience in working with ETL tools like Informatica and ODI.
• Extensive experience with various aspects of project management: project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation
• Experience with implementation and administration of Oracle Hyperion DRM / MDM / Razza
• Experience with core Oracle Hyperion System 9 Applications: Financial Management, Planning or Essbase
• Experience with functional, business process and Hyperion Essbase technical design and configuration skills within the performance reporting and planning areas
• Strong knowledge of Financial Domain applications using Hyperion Financial Management Suite (HFM)
• Experience 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
• Extensive experience in ASO / BSO Cubes and in Calc scripts, Load Rules, MDX, Report scripts, Architecture, Design, Business Logic, Performance tuning, Report development and all the areas related to whole life cycle of Essbase application implementation
• Commendable knowledge and experience in Automation, Essbase cube designing and partitioning and optimization of report queries in Microsoft Excel
• Extensive Experience in Stress, negative, regression, system integration, acceptance (UAT), load/performance, performance testing.
• Experienced in the configuration and maintenance of Windows servers and UNIX servers with different operating systems
• Extensive functional experience with Management Accounting, Budgeting / Forecasting, allocations, multi currency, GAAP and statutory reporting needs activities using the Hyperion suite of products

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase11.x/ 9.x / 7.x / 6.x, Excel Add-In, Smartview,EISESSCMD, MaxL, Essbase Administration Services, Hyperion Planning, Informatica

Business Intelligence Tools: Hyperion Planning 4.x, 9.3, 11.x, H.A.L, Hyperion Financial Management Suite (HFM) 9.3 / 4.x, Hyperion Enterprise 6.x, OBIEE 10g/11g

Operating Systems: MS-DOS, UNIX, AIX, WINDOWS 98 / 2000 / NT 4.0 / XP

Languages: SQL, PL / SQL, C, C++, HTML, DHTML, XML

Databases: Essbase, Oracle 10g / 9i / 8.x / 7.x, MS SQL Server 2000 / 7.0 / 6.5 , MS Access 2000DB2, Sybase

Internet Technologies: ASP, Java Script, HTML, MS FrontPage, Dreamweaver, Macromedia FlashDHTML and VB Script

GUI: Visual Basic 6.0 / 5.0, SAP GUI

Reporting Tools: Web Analysis Studio 9.2.0, Financial Reporting Studio 9.2.3, Hyperion Analyzer 7.0Hyperion Reports 7.0, Brio, Micro Strategy 8.2

Dimensional Modeling: Star-Schema Modeling, Fact and Dimensions Tables, Physical And logical data modeling, Erwin 4.0

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Hyperion Planning and HFM Consultant

Responsibilities:

• Managed the Development/Support activities on Hyperion System 11 - Financial Management at client site as well as hands on application, security and reports.
• Administrator of Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, System 11 Web-based solution for Corporate Accounting and Financial Reporting area.
• Worked with Hyperion Support on number of issue resolutions.
• Involved in Determining customer business requirements, project scope and assisting the estimation of efforts.
• Production Support and problem solving Financial Monthly End Closing using Essbase.
• Analyzing the raw data and converting it into valuable business information by Design & development of appropriate cubes. Created new Essbase Application/Database/Outline and Making changes to existing Outline.
• Support Management Reporting Group with Hyperion Essbase, Hyperion Planning and Hyperion Reports.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Leveraged HFM dimensions including custom dimensions for the essbase cube implementation.
• Leveraged corrections in the metadata and mapping rules made in HFM and FDM.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase and Essbase Integration Services
• Developed outlines, Data Load rules for loading dimensions and data into Essbase cube
• Optimized outlines to have faster data loads, calculation and retrievals
• Played key role in troubleshooting data reconciliation issues, extract issues and technical issues.
• Trouble shooting any load failures, restoring a cube from backup if DB is corrupted.
• Involved extensively in creating Data Grids and Data Entry Forms using HFM web client.
• Developed Import formats, Mapping, Dimensions and POV in FDM.
• Designed and built a partitioned database as per business requirement
• Coordinate UAT and fix any bugs/issues reported by the users. Creating mock reports for user.
• Closely worked with functional and Business during the pre-implementation phase of applications.
• Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer.
• Experienced in data transformation, data mapping from source to target and data cleansing using FDM.
• Maintenance of user security and troubleshooting user access issues as they arise.
• FDM design, test, migration, import formats, location setup, security, custom scripting for GL integration from BW, Hyperion Enterprise and disparate legacy GL’s to development and production environments.
• Design, data validation, and data loads of Historical Data to Production using FDM.
• Monitored and oversaw batch jobs developed in the reporting environment
• Introduced Balancing concept to existing applications in order to have all the Interfaces and upstream in Synch with Essbase cubes.
• Maintenance, enhancement & creating of planning web forms.
• Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS Patches. Backup and Recovery of Hyperion applications.
• Participated in the application testing while monitoring the system performance, thereby reporting any anomalies in the application. Provided 24*7 supports.
• Interacted with users to understand their reporting needs. Gathered business requirements from financial team. Analyzed and Supported Reporting Environment. Suggested improvements for reporting purposes.
• Involved in monitoring the current environment servers for performance and stability.
• Involved in assigning the Security for FDM, Essbase and Planning applications.

Environment: Hyperion Essbase 11.X, Hyperion Planning 11.x, Financial Management (HFM), FDM, DRM, Analytic Administration Services 11.X, Hyperion Financial Reporting, Essbase Excel Add-in, AIX UNIX, Hyperion Web Analysis, Hyperion shared services, Smart view, and Windows 2005/2008 Server

Confidential, Phoenix, AZ

Hyperion Consultant

Responsibilities:

• Responsible for Administering Hyperion EPM 11. 1. 2. 3 Essbase, HFM, Planning and Reporting security, system tuning, backups and recovery, troubleshooting system issues.
• Managed data and metadata load processes and mappings, including validation, to confirm the quality and accuracy of data.
• Provided day-to-day end user support including trouble shooting both system and data issues related to the Hyperion Planning / Essbase applications.
• Developed and maintained detailed end user documentation and application administration documentation.
• Responsible for support role in planning, implementation and end user support of financial consolidation system to ensure the integrity of data, including data is received by all systems interface
• Responsible for Setting up and maintaining user access to the Hyperion applications including the creation and provisioning of user groups and security profiles
• Created/modified, test and promote business rules/calcs in the Hyperion application to meet the needs of the business
• Maintained metadata mapping tables among all financial systems as needed and communicate changes to global users and management.
• Ensure the monthly close processes run timely and efficiently in all Hyperion environments (coordinate the closing in HFM using Process Control, running the forecast transfer from the Planning to the Reporting application, HFM loads via FDM)
• Performed routine HFM and FDM system maintenance
• Responsible for Loading and reconciling monthly revenue, expense, headcount, procedure, systems and other data into Hyperion
• Responsible for Developing ODI integrations between Essbase applications.
• Validated data interfaces in to/out of Hyperion and ensuring a clear audit trail for systemic Hyperion interfaces
• Manage applications change/updates and software upgrades, set up new users with software and security access, & monitor capacity and usage of application and server.
• Responsible for Administration of Hyperion environment by tracking Essbase cube build, data load, aggregation logic and fiscal day related operational tasks pertaining to financial data.
• Responsible for Administration of Hyperion Infrastructure of Hyperion servers, troubleshooting production issues related to Essbase server, Security Server, cube load and processes.
• Administered Hyperion Financial Data Quality Management environment where users performed direct data load to HFM.
• Responsible for Creating and maintaining Essbase/Planning applications, Planning data entry forms, reports, security, scripts, calculations, business rules, and batch processes
• Installed, build, configured, and test various Hyperion 11.x components in complex distributed UNIX/windows environment including Hyperion Foundation Services, Reporting and Analysis, HFM, Hyperion Planning, Essbase Integration Services/Studio, Essbase, Web Analysis, Financial Reporting
• Managed and administered the general ledger system and Essbase applications to ensure accurate reporting of financial statements by providing technical expertise in accounting principles, including GAAP and SOX related compliance policies.
• Performed application changes to entities, accounts, calculations/business rules, and migration of data
• Maintained system integrity through regular system maintenance and log monitoring
• Analyzed requests for changes, new requirements to production system, determine impact on existing systems processes and develop appropriate specifications, enhancements and/or procedures to comply
• Coordinated IT activities with Hyperion users, ADM, Enterprise Infrastructure, Oracle product support, and Oracle On-Demand with respect to system patching, upgrades, outages, troubleshooting, code promotion, etc

Environment: Hyperion Essbase 11.1.2.2, Hyperion planning 11.12.2, EAS Administration services, Hyperion Financial reports, Hyperion Planning desktop, Smart View, Oracle 11g, MS Excel Spreadsheet Add-in.

Confidential, Mclean Virginia

Hyperion Admin/Lead

Responsibilities:

• Managed product installations, configurations, and administrations of enterprise products. Created monitoring, scripts, alerts, security designs, backup strategies, and file system management. Creates documentation and follows IT operations processes. Assisted in troubleshooting and resolving infrastructure compatibility issues based on system architecture, project requirements, customer expectations
• Built a common enterprise framework to prepare, analyze, and assess the annual budget, utilizing Hyperion Planning to automate and streamline the process
• Managed product installations, configurations, and administrations of enterprise products. Creates monitoring, scripts, alerts, security designs, backup strategies, and file system management. Creates documentation and follows IT operations processes. Assist in troubleshooting and resolving infrastructure compatibility issues based on system architecture, project requirements, customer expectations
• Responsible for Software upgrades and patches, administer Hyperion services on servers, Visual Basic script development, research, install, configuration, test and education of new tools, responding to support questions from users and assist users with leverage of technology to meet business needs.
• As an Administrator was as a primary member of the team providing day to day support to global systems and cross departmental support including analyses, issue resolutions, maintenance and training for global users of the Hyperion applications
• Acted as a liaison in understanding business requirements and relaying these into systematic requirements by combining their finance business knowledge, project management experience and technical systems expertise on Hyperion applications with a focus on teamwork and strong background in financial business processes and controls.
• Providing day to day support to the Hyperion user community. For example: coordinating user account setup/changes within HFM & FDM, resolving access and data related questions from a variety of stakeholders. Performing systems administrator responsibilities for HFM, FDM, Financial Reporting and Smart View (v. 9.3.1), including proactively analyzing/root-causing issues, providing and implementing solutions for global Hyperion systems responsibilities in a fast paced work environment requiring multi-tasking and prioritizing.
• Proactively driving process improvement initiatives in supporting timely, accurate and efficient month-end consolidations close processes, development and maintenance of Hyperion financial reports as well as reducing month-end close cycles. Formulate and recommend objectives, plans, and procedures primarily related to HFM
• Creating and maintaining documentation of HFM instructions and the timeliness and quality of the execution of procedures and controls. Ensuring compliance with Sarbanes-Oxley (SOX) requirements. Supporting external and internal audit requests.
• Maintenance of the global chart of account and legal entity organizational structure in HFM and the JD Edwards Enterprise One ERP system
• Primary responsibility is to provide administration and user support for the Hyperion Planning, Essbase and Financial Reporting applications, including month end close, budget/forecast cycle administration, first point of contact for WW Planning user support, granting user security access, etc.
• Used Hyperion Interactive Reporting to create static and dynamic reports and pivots
• Rebuilt the Finance Dashboard using Interactive Reporting and advance JavaScripting techniques
• Provided project management on Finance systems projects, including working with the business to identify solutions, define projects and associated timelines, hold stakeholder meetings and communicate progress of the project.
• Act as the finance liaison with the Data Warehouse team working production support analyses and facilitate month-end close process and Margin cube tie out
• Provided worldwide training for the Finance community on finance information flows, reporting tools (Planning, Essbase, Analyzer, Discoverer, SharePoint) and reporting processes (cube expert)
• Identify and help gather requirements on new Hyperion projects and managing them through implementation once approved
• Performed regular assessment of Hyperion system performance, identifying any issues along with action plans to address
• Worked on special projects within client’s org on financial system initiatives, performing overall project management on specific assignments
• Provided financial support and ad hoc analysis for various Corporate Planning projects as needed
• As Hyperion System Administrator was responsible for the architecting, configuration, and maintenance of a large Oracle Hyperion deployment across Windows OS.
• Configuration of Windows, IIS, Web logic, Citrix for use with Hyperion or other team related software
• Responsible for Installation and configuration of Hyperion EPM Workspace, Shared Services, Planning, Essbase, HPCM, DRM, and the BI Plus suite of products.
• Responsible for Opening and managing tickets with Oracle Support
• Responsible for Supporting engineering staff with operating system patching
• Responsible for Day-to-day management of the Hyperion Financial Planning Platform (Hyperion Planning), Essbase, BI+ Environments and other related products, including, Metadata, rules and security as well collaborate with IT for deployment of upgrades and patches across all environments.

Environment: Hyperion Financial Management 9.3/11.x, Hyperion Enterprise 6.x, FDM 9.x, EPMA,Hyperion Financial Reports, ODI, SQL Server 2008, Citrix, Windows 2003, AIX 6.x

Confidential, Austin, Texas

Hyperion Admin/Developer

Responsibilities:

• Design and interacted with business users and created applications and databases (ASO & BSO) - Planning cubes to capture the financial and quantity data for Inter Company Billings to enhance reporting.
• Automated “REFRESH” from planning application to ESSBASE application using the appscheduler.
• Involved in assigning security for Hyperion Planning application using Hyperion Shared Services.
• 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.
• Responsible for Performance optimization by tuning the caches.
• Involved in Installation and Configuration of the Development server consisting of Hyperion System 11 ESSBASE, Hyperion Planning, Hyperion Shared Services,FinancialReports, Web Analysis and Workspace.
• Created ODI routines and packages to update metadata for several Planning apps.
• Worked on multiple projects as Essbase/BI Architect. Involved in all aspects of the project from inception, POC, implementation, deployment, integration to post production support.
• Implemented Essbase studio for building cubes in Essbase and then integrated EPM with BI Server for CEM implementation
• Integrated Essbase with OBIEE and involved in modeling in BI using OBIEE from various data sources, including federated modeling, drill through from Essbase to Relational.
• Involved in POC for OBIEE and Essbase integration for the client to implement the reporting in OBIEE.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Admin tool
• PerformedUnit tests based on sample data, stipulated functional test conditions and stipulated expected results; resolve any issues of functionality related to integration of Essbase with OBIEE.
• Collaborated with delivery teams to understand business context and provided suggestion direct appropriate methods to acquire data from various performance sensitive source systems in to OBIEE
• Consulted, reviewed and approved enhancements to existing model from Essbase/ETL and verified impact/ assessment standpoint
• Have Written MaxL scripts to automate data load into ESSBASE database using Rules files.
• Responsible for Migration of the Planning Application from Development to Production.
• Responsible for Migration of Financial Reports and Web Analysis Reports from Production to Development.
• Developed Business Rules to copy data from one version to another using Run-time prompts
• Involved in ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL API, Backup, Outline, Load rules).
• Provided support to the Hyperion user community.

Environment: EPMA, Hyperion Planning 9.3.1/11.x,ODI,Essbase Studio, OBIEE11g, Excel Add-in, SmartView

Confidential, St.Louis, MO

Hyperion Admin

Responsibilities:

• Created HFM application and was responsible for Managing Metadata and defining attributes.
• Responsible for loading the metadata into RDBMS server and Creating, managing Journal Templates.
• Created the application structure by creating application, setting up dimensions, configuring application settings and loading metadata and involved in Consolidations and Analysis through HFM Client and Web.
• Involved in configuring the security and its process management.
• Responsible for creating Reports of Financial areas using Hyperion Financial Reports (H.F.R).
• Responsible for Creating Intercompany Matching reports verifying using Intercompany Transactions module.
• Validated the source data against mapping table to optimize the design, to increase the performance and troubleshooting with workflow process in Hyperion Financial Data Management (FDM).
• Developed KPI Rules as per the business request.
• Provided production support and user support in Month End Close process
• Responsible for Performance Monitoring, Backup and Recovery of the HFM App.
• Responsible for Planning and scheduling the Testing activities with respect to releases with co-ordination of onsite, offshore manager and client.
• Responsible for Allocation & co-ordination of the work to all the team members as per schedule
• Performed Automation cubes and automated data loads in Hyperion Essbase- system 9.3.
• Generated the batch process to build dim, load data and calc on scheduled time.
• Generated files to update and modify the members in the outline change Aliases and business unit upon request of business analyst and users. Lock and send data.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server and modification of cubes based on new business requirements from Business and Financial Analysts.
• Created Transparent partitions for ASO cubes for better query retrieval times and Reporting Cube flips in order to minimize the downtime.
• Automated all production BSO cubes daily/monthly dim build and data loads by using Windows batch scripting.
• Installed and upgraded Hyperion Planning applications from Hyperion 9.3 to Hyperion 11.1(Installation and configuration).
• Developed three cubes in Planning for Revenue, Expense, and Staffing Cubes and have developed business rules supporting business logic.
• Designed Security process and migrated application to EPMA and tested their performance.
• Involved in Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design of Analytical Data Model (Metadata / .rpd) and Reports / Dashboards.
• Participated in the installation and configuration of Oracle BI EE 10g in the windows as well as the Linux environment.
• Responsible for Analysis, design, Integrating, testing, Essbase applications for Business Intelligence system based on OBIEE.
• Architected OBIEE /Essbase integration solution to analyze multiple client reporting needs
• Hyperion planning - system 9 was used in testing of new calculation script, define business rule with run time prompts or allocation sequences to match the need of the users.

Environment: EPMA, Oracle Business Intelligence (OBI) EE 10g, Hyperion Smart View 9.3.1,Oracle 10g, Windows Server 2003

Confidential, Jacksonville, FL

Hyperion Admin

Responsibilities:

• Installed and configured Hyperion BI 9+ Suites (Enterprise Analytics, Interactive Reporting, Shared Services, Admin Services, Integration Services, Web Analysis, Reporting Metrics etc)
• Created Transparent partitions for ASO cubes for better query retrieval times and Reporting Cube flips in order to minimize the downtime
• Automated all production BSO cubes daily / monthly dim build and data loads by using Windows batch scripting
• Worked with Hyperion Financial Data Quality management (FDM) 9.3.1 to integrate Oracle GL with HFM and Essbase
• Used Hyperion System 9 BI Financial Reporting to perform automatic calculations to focus and filter reports
• Developed reports for financial analysis, trending and results analysis related to revenue and expenses using Hyperion Interactive Reporting
• Assigned users to the user groups. Based on the business requirements and Sync up the security with Essbase by refreshing security from shared services in Essbase and with Hyperion Planning from Planning applications
• In conjunction with Client's Hyperion and IT administrators, identified all application data elements (Web Forms, Reports, etc) and ETL processes (HAL) that needed to be migrated to the new System 9 environments
• Defined system architecture to enable Oracle Business Analytics Warehouse using Oracle ODI with Oracle Warehouse Builder Version 11g, Release 1
• Primarily responsible for developing ETL processes, loading and validating data from source systems into the data warehouse using Informatics and / or Oracle Data integrator (ODI) and Oracle SQL, PL / SQL procedures
• Used ODI and FDM to extract data from people soft.
• Developed workflows, mappings, mapplets and transformations in ODI
• Migrated all HFM applications to the new System 9 HFM Classical Application format
• Migrated all applicable Hyperion Application Link integrations to System 9, updated as necessary, and worked with Client to validate their work as expected in the new System 9 environments
• Performed Custom Query and Report Development using Hyperion Financial Reporting Tool
• Accomplished planning applications migration within environments for security updates through Security scripts
• Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server
• Developed various reports such as tabular report, chart report, cross-tab report using Web analysis studio 9.2
• Created Data Requirements, Security Structure for Ad hoc / Dashboard Reporting of Hyperion System 9
• Lead in development of executive information system, Dashboard, using Hyperion products
• Installed and configured Web analysis studio and created user / groups in it
• Defined queries with cube navigators formatted spread sheet add-in and saved the reports as web page
• Created reports and mapped DIM jobs to load the hierarchies into different planning applications
• Created and modified ESSBASE and Planning applications to meet ongoing future business requirements
• Configured ESSBASE components as it relates to Hyperion Planning 9.3, including database structure, calc scripts, and complex Business Rules
• Designed reports using Hyperion SQR and Hyperion Intelligence
• Conducted Hyperion SQR training classes,
• Responsible for IR scripting via javascript.
• Used IR for Joole programming
• In Hyperion Planning created web forms for user input for loan allocation percentages
• In Hyperion Planning created business rules working with business users and calculation scripts for allocations of loans by region
• Set up forms, smart lists for input of loan allocation percentages as per region in planning
• Performed Meta data load using outline load utility in Hyperion planning
• Completed work flow design and development across complete planning life cycle
• Hyperion Planning was used in testing of the new calculation scripts and to define business rules to match the needs of the users
• Supported global users of the Planning applications during quarterly projection cycles. Supported end-user training by developing training materials

Environment: HyperionEssbase 9.3.2, Administration Services 9.3.1, Hyperion Business Rules 9.3.1, Hyperion Shared Services9.3.1, Hyperion Workspace 9.3.1, Hyperion Planning 9.3.1, Hyperion Financial Management 9.3.1, Financial Reporting studio 9.3.1, Interactive Reporting, Hyperion SmartView 9.3.1, Oracle 10i, AIX 5.3, Windows Server 2003

Confidential, New York, NY

Hyperion Admin/Developer/Reporting Analyst

Responsibilities:

• Designed and developed Planning applications and Essbase applications where data was coming from upstream system
• Generated Rule Files to load data into Essbase applications
• Developed Calc scripts to calculate values like Sales, Allocations, Hourly Wages, Depreciation, Benefits and Revenue
• Developed ASO cubes by first designing OLAP Model and Meta Outline, and then loading dimensions and data for Essbase OLAP Server using Essbase Integration Services
• Extensively Worked on ASO cubes and frequently involved in running aggregations to lower the reports run time
• Worked on performance tuning of ASO cubes and also on ASO cube enhancements
• Loaded Essbase cubes twice or three times on daily basis
• Designed and developed reports according to specific business requirements inclusive of extracting information and building reports from various data sources
• Worked with clients to design and develop Executive Information Systems Dashboards used by Senior Management down to Analysts to facilitate their decision-making processes
• Created and customized Dashboards using JavaScript
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing / validating scripts
• Developed Batch files using MaxL, and Rules files to upload data from financial systems database to Essbase cube
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications. Also worked on User Authentication and Provisioning (Role-Based Authorization) for Essbase, Planning, Reporting and Analysis and Business Rules users
• Security Maintenance: Maintained users, user groups and access securities for all the developers and end users depending on their current privileges
• Responsible for performance tuning and optimization of cubes for satisfying the users reporting requirements
• Developed a financial data model to support data warehousing and Financial Reporting needs, In this process developed Essbase Source cube to permit the reconciliation of sub ledger balances to source system detail stored in the data warehouse
• Created a relational data model and enhanced the existing operational data store to permit drill thru to relational querying in Essbase Interactive Reporting and Excel Add-in client
• Resolved issues with Hyperion Administration Services working in a secured environment using Secured Sockets Layer technology and ensured the encrypted authentication, traffic and data transmission functionality of the system
• Assisted in the development of the Security model and successfully implemented it via Shared Services across HFM, Planning, Reports, and Essbase
• Configured the Hyperion Workspace and related components
• Created automated solutions flowing data from source system (PeopleSoft HR) to Workforce to multiple Hyperion Planning databases.
• Maintained a large and diverse population of employee types within Workforce (employee base consists of contractors onshore and offshore, that must considered in Workforce)
• Worked on custom coding Workforce solution as needed (for the shelf product based on 12 month forecast cycle, calculations which only support one year, and which required minimum of 24 month forecast cycle)
• Configured the managing of dimensional models which were used in the sharing of hierarchies between the applications
• Assisted with user testing for Hyperion Planning version migration and new expense forecasting application. Helped refine scope and system requirements; edited and developed test cases, scripts; participated in testing
• Supervised the migration of the Hyperion Planning 3.5 environment to Hyperion System 9. In addition to rebuilding all of the Hyperion applications, which also included a new deployment of Hyperion Workforce Planning
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications. Also worked on User Authentication and Provisioning (Role-Based Authorization) for Essbase, Planning, Reporting and Analysis and Business Rules users
• Created numerous reports in Financial Reporting Studio on Income Statement, Statistics, Net Revenue, EBITDA, Net Income and Expenses to calculate Budget and Actuals; Summary and Detailed reports, Monthly and Quarterly reports, Consolidating and Combined reports. Also created Books and Snapshots

Environment: Hyperion Essbase 9.1.2 / 7.1.2 / 6.5.4 , S.Q.R 8.0, Brio, Essbase XTD Analytic, HFM 9.x Hyperion Reports 7.0, Hyperion Analyzer 7.0 / 6.5, EIS 7.0 / 6.5, ESSCMD, MaxL, Perl, and Hyperion Planning 4.x, Hyperion Enterprise Services, Microsoft Excel 2000, SQL Server 2000, and Windows 2000 Advanced Server

Confidential, New Orleans, LA

Hyperion Admin/Analyst

Responsibilities:

• Designed and developed numerous Essbase applications in system 9. Using Hyperion System 9 BI Interactive Reporting created various reports to provide executives, business user and analyst with intuitive user-directed relational query and capabilities
• Interacted with users to support analysis and provide definition and requirements for the Financial Management reporting and other Essbase supported processes
• Responsible for providing production support and coaching to technical team
• Involved in Backups of all production cubes
• Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them
• Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, HAL, and Executive Viewer
• Developed and Maintained Aggregate Storage Cubes using Essbase system 9
• Responsible for ASO and BSO cube design and optimization, calculation / MDX scripts, security management, partitioning) using System 9
• Created MDX member formulae for the ASO cubes in production environment
• Set up the server settings, optimized different Essbase objects, and implemented partitioning among different production cubes to improve performance of all the Essbase applications
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases
• Created Row Set Generators using Excel VBA
• Created and registered applications in Hyperion System 9 Workspace
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning
• Involved in Creating Data Forms and Folders and Customizing Data Forms
• Tested the forms and reports before moving them to the production environment
• Involved in designing reports and snapshots using Hyperion Reports / Financial Reporting, Worked on Workspace for administration like Setting Preferences and security
• Involved in periodic back up of metadata and data
• Developed automation scripts for application refresh and backups using Hyperion EssbaseEsscmds and MaxL
• Implemented application with Hyperion planning for user input for location allocation percentages
• Hyperion planning - Created and maintained Web forms, developed and maintained business rules as per business requests
• Enhanced and developed calculation scripts for tasks such as allocations or percentage splits
• Involved in security designing of HFM applications along with reporting, ad hoc spreadsheet analysis creating and managing reports, objects, books and batches
• Worked with Hyperion or Razza packages to build hierarchies
• Created and Maintained Financial Hierarchies for Planning using Hyperion MDM
• Functioned as a member of the project team and / or as a major contributor / subject matter expert responsible for the development, implementation, and maintenance of HFM and FDM applications and worked with the project team to ensure HFM / FDM system is available and accessible to financial users domestically and internationally
• Involved in system installation, configuration and responsible for system enhancement, maintenance and administration of Hyperion System 9
• Worked with upgradation from System 7 to System 9
• Created Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation
• Developed automation scripts for application refresh and backups of all production cubes using Hyperion Essbase, Esscmds and MaxL. Recovered applications from its back up when database was corrupted
• Converted automation scripts from Esscmd to MaxL for all existing production cubes
• Designed, developed, and implemented Expense Planning and Reporting System for the Financial reporting.

Environment: Hyperion Financial Management, Hyperion FDM, Hyperion Essbase, Hyperion Planning, HAL, Hyperion Analyzer 7.0, Hyperion Reports 7.0, Hyperion Intelligence, Razza Hierarchy, Microsoft Excel 2000, Oracle 11i, VisualBasic6.0

Confidential, New York, NY

Hyperion Developer/Admin

Responsibilities:

• Responsible for analysis, design and implementation of seamless integration between Oracle Applications and Hyperion with Oracle Applications modules of Oracle General Ledger, Accounts Receivable, Accounts Payable and Cash Management, Implementation of Oracle Accounts Payable and Cash Management (6 Business Units)
• Defined Chart of Accounts, Inter-Co. Accounting, Multi-Org set up, FSG, Data Migration Plan and Design, etc
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed ASO Cubes using Essbase 7.1
• Recovered / tested BSO cubes during Tests performed in coordination with the IT team
• Responsible for monthly DIM Builds and Data Loads for BSO cubes
• Converted BSO cubes to ASO without modification Even for those that cannot be directly converted, partitioning was done in ASO
• Involved in the feasibility study for the ASO implementation and finally it was decided to have Hybrid architecture due to Lock and send issues with ASO cubes and then I was involved in the Member Formula to MDX conversions for the ASO cubes
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow
• Lead a team of three for Software Development Life cycle of developing new cubes and redesigning and restructuring the existing cubes
• Performed migration of Hyperion Enterprise from 6.3 to 6.4
• Installed Hyperion Smart view and Hyperion Retrieve along with App server, Data Server
• Involved in Setting up security Parameters through LDAP for Hyperion Enterprise 6.4
• Involved in collection of raw data from disparate systems for Hyperion Enterprise
• Using Hyperion Enterprise captured and validated data from ASCII files, Spreadsheets, Web based schedules, General Ledgers and other sources for consolidation process
• Performed optimizations of Essbase database calculations, load and query performance times
• Responsible for Troubleshooting Essbase database partitioning related issues and data-load on portioned cubes
• Automated Essbase system with MaxL and server side batch scripting
• Responsible for Backup and Restore: Hyperion Essbase, EAS, AAS, and Shared services, Reports of v6.x, v7.x
• Responsible for Version Control Management and Documentation of new implementation as well as changes
• Using HAL Mapped and Transformed source data into Hyperion Enterprise applications from various GL’s ERP Systems and other data sources
• Involved in Manual data entry via familiar spreadsheets or customized, data entry screens that allow users to manually input data directly into Hyperion Enterprise from any Windows desktop or through a web browser
• Involved in using Enterprise for Journal Entry adjustment and provide a detailed organized journal entry audit trial through the system
• Involved in using pre built functionalities for expediting period end closings using Hyperion Enterprise
• Simplified the process of comparing Hyperion Essbase metadata (dimensions) against source trees in PeopleSoft. Created a Visual Basic .NET application that connects to Essbase databases and produces simple text files containing dimension information. These files can be loaded in Excel or Access and quickly compared against PeopleSoft reports
• Extensively involved in developing templates (Relational and OLAP) using Clarity and wrote CalcScripts for efficient results
• Involved in migration from development to test Scripts, wrote test scripts for testing purpose backup of the templates during migration
• Created wrapper scripts (.ksh) to automate all the variables and all the (.scr) scripts
• Developed Data Loads and numerous Calc Scripts and optimized them
• Create Process flowcharts in Visio as part of analysis and Requirements gathering / documentation
• Created complex technical, functional and business specifications along with UML diagrams for Payroll / HR and GL / Financial
• Worked as an administrator to give access and privileges to various end users in different planning applications, and synchronizing the passwords during the Essbase logon, or using external provider in Essbase
• Maintained outline, metadata, and member formulas as business requirements change
• Written, debugged, and enhanced various Calculation Scripts and Business Rules
• Enhanced and supported web-based data entry forms within the Hyperion Planning application
• Created an alternate view of financial p&l within Essbase i.e., an internal view that’s focused on operating expenses and accounts and an external view that reconfigures some accounts and costs into potentially a different roll-up

Environment: Clarity, Hyperion Essbase 7.1, Hyperion Analyzer 6.5, Hyperion Enterprise 5.1, Hyperion Reports 7.0, EIS 7.1, Hyperion MDM, Oracle9.x, Peoplesoft, AS / 400, Microsoft Excel 2000, Windows 2000 Advance Server, AIX, Cognos, Powerplay

Confidential, Atlanta, GA

Hyperion Developer

Responsibilities:

• Responsible for Day-to-day management / administration of the Hyperion environment, with primary responsibilities for the Essbase, Planning and Reporting applications
• Involved in gathering requirements and developing a project plan
• Loaded data using Essbase Integration Services (EIS)
• Implemented star schema and used EIS to interface with the company’s existing Oracle 10g data warehouse
• Created various filters as per user requirement in EIS
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services
• Involved in system installation, configuration and software upgrades from Essbase version 6.5 to 7.1
• Developed Load Rules, Calculation Scripts, Report Scripts (write / maintain / enhance) for the existing cubes
• Created Backup and Recovery processes for critical ESSBASE applications and created security filters
• Developed scripts to automate key processes (Backups, Cube overnight load and Calcs, Tieouts, etc)
• Imported and manipulated data from multiple disparate systems (SQL based, Flat Files), etc and performed data validation to confirm system outputs are correct (data integrity)
• Worked on Essbase Integration Services (Meta-Outline workflow / filters / drill through reports using Hybrid Analysis)
• Developed and maintained Calc Scripts, MaxL Scripts, batch scripts to automate data load / calculation
• Used Essbase functions such as @DESCENDENTS, @MDALLOCATE, etc were very supportive for these calc scripts
• Participated in a Finance project to implement FM system modifications and upgrades in preparation for sale to major international conglomerate. Assisted client in decision to select and migrate to HFM. Where the Tasks included reconciliation of Hyperion currency translation methods and adjustments to SAP FI/CO; creation of flexible Essbase reporting models for Treasury/Tax; improvements to Hyperion reporting processes and worked as Hyperion administrator in corporate consolidation and closing effort
• Prepared and delivered one-day workshop to visiting team of finance managers on SAP-to-Hyperion data integration from functional perspective. Topics included methods and tools available, business drivers, and multidimensional data modeling (OLAP).

Environment: Hyperion Essbase 7.0 / 6.5.1, Hyperion Analyzer 6.5, Hyperion Reports 7.0 / 6.5, Essbase Integration Services 6.5, Hyperion Financial Management (HFM), Hyperion Application Link(HAL), Erwin 6.0, MS-Excel 2000 Spreadsheet Add-In, SUN Solaris 7, Windows NT 4.0