Sr. Essbase Developer/admin Resume
Burbank, CA
SUMMARY
- 8 years of proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Integration Services, Smart view, and Spreadsheet Add - In, in both Windows and UNIX environments.
- Expertise in architect tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, MDX Querying, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework.
- Strong experience as a Hyperion Essbase Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
- Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
- Experience in working through all phases of Software Development Life Cycle (SDLC) including the design, development, implementation, and maintenance of financial applications.
- Skilled in installations, upgrades, and configuration procedures in client/server environments.
- Thorough understanding of multidimensional and relational database architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
- Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase.
- Expertise in building Relational Databases using SQL Server and Oracle and knowledge of Essbase server upgrades across NT and UNIX platforms.
- Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment
- Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
TECHNICAL SKILLS
OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Financial Management Suite (HFM), Excel Add-In, ESSCMD, MaxL, MDX and Hyperion Planning, ODI, FDQM, DRM, Essbase Studio.
Databases: Essbase 11/9.3.1, Oracle 8i/9i/11i, SQL Server 2000, DB2, Toad 8.0, MS Access
Reporting Tools: BI+, Financial Reporting, Web Analysis, Hyperion Reports, Hyperion Interactive Reporting, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Smart View, Cognos series 8,OBIEE.
Internet Tools: HTML, DHTML, XML,VB Script, Java Script, JSP, ASP
Languages: SQL, PL/SQL, C/C++, Shell Scripting
Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista/, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux
Testing Tools: Win runner, Load Runner, Quick Test Professional QTP.
PROFESSIONAL EXPERIENCE
Sr. Essbase Developer/Admin
Confidential, Burbank, CA
Responsibilities:
- Involved in system installation, configuration and migration of Hyperion Essbase 11 from one server to a server at different location.
- Involved in gathering requirements from business users and developing a project plan for their Planning Cube.
- Involved in defining requirements, functional specifications, designing documentations and testing for creating forecasting tool
- Created Maxl and Batch scripts to load and update data from Data warehouse
- Maintenance and Support for Essbase Applications.
- Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application
- Defined and documented the steps to migrate applications in the Hyperion Essbase between Prod, QA, and Dev environments.
- Worked with Hyperion Support on a number of issue resolutions.
- Performance tuning and 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, Outline formulas.
- Backup and Recovery of Hyperion applications. Scheduling daily backups.
- Maintenance of user security and troubleshooting user access issues as they arise.
- Converted one ASO cube to BSO due to tweaks and changes requested by Business User.
- Monitoring the current Production environment servers for performance and stability.
- Involved in decision making functions for Environment Infrastructure needed while migrating to new server.
- Keeping all the environments in sync.
- Created and migrated ODBC connections within the servers.
- Performed Aggregate and Smoke Test for SQL in Teradata and AS/400.
- Trained and did KT to In-house person before rolling over the applications.
- Troubleshooting the Client install issues.
- Supported and Co-ordinate for VM patching over Informatica and Essbase Production servers.
- Carried out nightly updates for refreshing the cubes
- Documented migration of users and user groups in the standalone environment.
- Administered and knowledge on installation, configuration, and optimization of Hyperion System 11.
- Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
- Monitor ETL Informatica Jobs and provided On-Call support in Trouble shooting and debugging.
- Worked with Informatica Power Center for running and managing related workflows.
- Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
- Specific role as Essbase Administrator involved Shared Services security development for Essbase.
- Setting up users and groups according business department and assigning security to users and groups using Shared Services.
- Documenting the processes and installation steps for Essbase 11.1.1.3.
- Implemented robust data-access security and user management
- Developed Excel Templates for user interface in Essbase database
- Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
Environment: EPM System 11,Hyperion Essbase 11.1.1.3, Essbase Excel Add-in 11.1.1.3/11.1.1.4 , EIS 11.1.1.3, Hyperion Shared Services 11, Microsoft Excel 2007/2010, Microsoft Windows Server 2003 R2, Microsoft Visual Studio 2005, Microsoft SQL Server 2005, Teradata Client 14.0, Teradata SQL Assistant 14.0, AS/400 Client, iSeries Navigator, DB2 query, Informatica 9.1.0 (Power Center Client), Rally, Jira, GIT Hub.
Sr. Essbase/Planning Developer
Confidential, Miami FL
Responsibilities:
- Involved in system installation, configuration and software upgrades from Essbase version 7.1 to 9.3, EIS upgrade from version 7.1 to 9.3.
- Involved in gathering requirements from business users and developing a project plan
- Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool
- Implemented star schema and used EIS to interface with the company’s existing Oracle data warehouse
- Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
- Loaded data using Essbase Integration Services (EIS)
- Carried out nightly updates for refreshing the cubes
- Hyperion planning was used to create new web forms. The same was used to define business rules.
- Developed new Planning Application Matrix from scratch as per business requirement.
- Created users and user groups in the Planning applications and assigned security to web forms.
- Administered and knowledge on installation, configuration, and optimization of Hyperion System 9 Essbase, Planning, Financial Reporting and Web Analysis.
- Created, published and migrated a number of reports (BQYs) using Hyperion Interactive Reporting.
- Built several custom reports using Hyperion Financial Report V 9.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
- Created reports in web analysis 9.3.1 and administered those reports from Hyperion workspace.
- Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis & Hyperion Reporting Studio V 9.3.
- Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
- Specific role as Essbase Administrator involved Shared Services security development for Essbase and Planning.
- Setting up users and groups according business department and assigning security to users and groups using Shared Services.
- Implemented robust data-access security and user management
- Developed Excel Templates for user interface in Essbase database
- Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
Environment: s: Hyperion system 9, Hyperion Essbase 9.3/7.1/6.5, Essbase XTD Analytic, Microsoft DTS, Hyperion Analyzer 9.x/7.0/6.5, EIS 9.0/7.0/6.5, Hyperion Planning, Hyperion Interactive Reporting 9.3, Hyperion Reports 9.x, Microsoft Excel 2000, Oracle 11i,Business objects 5.0, Oracle SQL Loader, Windows 2000 Advanced Server
Hyperion Developer
Confidential, Hoboken, NJ
Responsibilities:
- Responsible for designing the database for improved ETL and building a new financial database, gather all user requirements, conduct interviews for offshore candidates, lead offshore team for future maintenance activities. Cut the run time from 6.5 hrs. To 1.5 hrs. With negligible impact for existing users' interaction.
- Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis & Hyperion Reporting Studio V 9.3.
- Extensively worked on SQL drill through process to prepare the financial reports.
- Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
- Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube; develop MDX queries.
- Created and maintained multidimensional database (MDDB) financial applications to perform ad-hoc General Ledger analyses for accountants and financial analysts.
- MS Excel Report generation with VBA programming for Essbase. Created various test-data using SQL and excel to perform more DBA activities of performance tuning of developed Calc scripts and created mechanism to allow periodical Essbase backups.
- Involved in developing report scripts, formulas using ESSCMDs; tested and optimize their performance.
- Used PL/SQL for extracting and transferring selected data into Oracle data warehouse and then wrote several load rules for smoothly loading the data into Essbase server.
- Built a new Essbase financial database for reporting Actuals, Budget, Flash and Forecast numbers. Designed the ETL process for data load into the new database from SQL tables. The key point for the project was 'maintenance', as the existing team didn’t yet have any Financial Systems analysts.
- Managed BSO and ASO cubes and improved their performance through tuning: recognizing design issues, eliminated fragmentation, sizing caches, grouped sparse dimensions together, optimized Essbase caches, fine tuning of cache settings usage of filters.
- Automated data loads using ESSCMDs and MaxL in both interactive and batch modes. Generated several MDX queries for ASO cubes.
- Built several custom reports using Hyperion Financial Report V 9.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
- Responsible for month-end tie-out and provide related support to financial controllers.
Environment: Hyperion Essbase 9.3.1, Hyperion Planning, Hyperion Financial Reports Studio V9.3, Interactive Reporting, Web Analysis, Hyperion Integration Services, Web Logic, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX Shell scripts.
Hyperion Consultant
Confidential, Charlotte, NC
Responsibilities:
- Installation and configuration of whole suite of Oracle EPM products including Hyperion Shared Services, Hyperion Essbase, Hyperion Planning, DRM Hyperion Workspace, Hyperion Smart View and other related tools - in all environments.
- Provided support for Hyperion Essbase, Hyperion Planning, Hyperion Reports, DRM and other Hyperion Suite.
- Involved in research and resolving complex issues related to any Hyperion Suite.
- Troubleshoot and resolve complex Hyperion System related Issues.
- Setup Disaster Recovery environment for Hyperion customer of Oracle.
- Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging on demand Customer environments.
- Closely worked with System Administrator to resolve server related issue.
- Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation.
- Imported security profiles from Hyperion planning to Hyperion Essbase.
- Improved the Performance (Optimized the Planning, Essbase system) by changing the dimension order and working on configuration file including Cache design techniques.
- Migrated reports from development to Preproduction and then to production.
- Involved in Trouble shooting the Production issues in support to the Planning Applications and all databases (Production Support).
- Researched and reported the Defects and Enhancements to the Hyperion Development team and enforce standards and best practices.
- Configured the Application server software to each individual application’s requirements Performance Tuning with the Application server software for optimization of use.
- Performed recovery under various circumstances on production database.
- Successfully resolved archive log and NFS lock related issues.
- Troubleshooter connectivity issue from middle tiers to database tier.
- Synced up standby database with primary.
- Involved in the documentation of the related tasks in the project.
Environment: s: Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Web Analysis, Smart View, Workspace, Shared Services, EPM, UNIX, Linux.
Sr. Hyperion Developer/Administrator
Confidential, Florence, AL
Responsibilities:
- Reviewed the backup scripts for the Hyperion environment.
- Monitored the Hyperion process scripts on a 24/7 basis.
- Responsible for the Essbase applications, as a application and system administrator
- Address, re-route and resolve user issues generated by help desk.
- Involved in analysis and requirements gathering of the Interactive Reports.
- Created Interactive Reports using Hyperion Interactive Reporting Studio 11
- Supported and participated in the testing and implementation phase of the Interactive reports
- Used ClearQuest for implementation documentation.
- Used TOAD for SQL programming to Interactive Reports code testing
Environment: s: SYSTEM 11.1, Hyperion Planning 11.1, Hyperion Interactive Reports 11, Oracle 11g, Smart view, Windows 2003 server, UNIX, Web Sphere, TOAD, Windows SharePoint.
Oracle Jr. Developer
Confidential
Responsibilities:
- Developed PL/SQL programs that included writing of Stored Procedures, Packages, Functions and Database Triggers.
- Created Temporary Tables to store the data from Legacy system.
- Designed and developed Graphical User Interface using Forms.
- Used SQL*Loader scripts to load the data into temporary tables and PL/SQL procedures to validate the data.
- Creation of Materialized views and function based indexes.
- Setting up various notification scripts which will notify if the database is not up and running or if any directory space is filled up.
- User Management Duties involved: Create, Modify and Delete user accounts.
- Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
- Used Oracle packages for automation and Oracle designer for data modeling.
- Used Visual SourceSafe for version control and performing various builds.
Environment: s: Oracle8i, PL/SQL, SQL*Plus, Windows NT, VisualBasic5.0.