We provide IT Staff Augmentation Services!

Hyperion Consultant Resume

Parsippany, NJ

SUMMARY:

  • 9+ years of diverse experience in Information Technology with emphasis on Data warehousing and Hyperion products
  • Over 6+ plus years of diverse experience in OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning, workforce planning, Essbase Integration Services, Hyperion Workspace, Hyperion Reports, Hyperion web Analysis, Hyperion EssbaseSpread Sheet Add - in/Smart-view, Oracle Data Integrator, Hyperion Financial Management, Financial Data Quality management under Windows and Unix environments
  • Implemented 2 Hyperion Planning Projects in version 11.1.2 and having strong knowledge of entire SDLC process
  • Strong Experience in creating, designing and planning Classic and EPMA applications
  • Used various types of utilities in Hyperion planning applications for dimension building and maintenance purposes like outline load utility, import export security and cube refresh
  • Strong skill set in Installation, Configuration, Troubleshooting and application demo presentation of Hyperion 9 & 11 on Windows and Linux operating systems
  • Maintained around 10 servers in 4 environments (Dev, Test, QA, and Prod)
  • Installed and configured complete Hyperion EPM suite from server requirement gathering to server deployment
  • Implemented security group with around 100 users. Used various security utilities for bulk user and group’s creation process
  • Strong knowledge of clustering and Load balancing procedures
  • Used various application and web servers in versions 9 and 11
  • Used Apache Tomcat application Server and web server in version 9 and used web logic application server and Oracle HTTP server in version 11
  • Experience in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO)
  • Designed custom substitution variable Excel template using Visual Basic scripts. Those templates are used for updating the variables
  • Designed Essbaseapplications for day to day end user reporting and planning applications as per client requirements for budgeting and forecasting
  • Strong experience in dimension building, data loading using rules file in EAS
  • Designed web analysis, Hyperion financial reports, and Smart view & Excel templates as per end user reporting requirements
  • Extensive knowledge of building dimensions and data loading from Flat Files (Text, Excel, CSV) into Hyperion applications
  • Worked with Hyperion Calc Manager
  • Integrated ERP Systems (People Soft, Oracle EBS, SAP) to Hyperion applications and vice versa
  • Used Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse databases as well as Hyperion applications
  • Extensively used VBA scripting to design excel templates for Hyperion Essbase retrieval and calculation
  • Expert level knowledge and understanding of ESSCMD and MAXL scripts used for automations
  • Knowledge and experience in Automation Autosys for 3 Years using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications
  • ImplementedData Level Security, Object Level Security and LDAP authentication
  • First SSL (Secure Socket Layer) upgrade in the last two projects
  • Web logic & SSL certificates deployment to respective Hyperion components
  • Worked with Oracle’s Hyperion Tax Provision is a pre built application for Oracle Hyperion Financial Management 11.1.2.4.0 and calculates global tax provision, effective tax rate, and deferred tax for tax provisioning purposes in last project
  • Worked with EPMA for 3+ years hierarchies can be imported from interface tables, flat files, and DRM. The EPMA shared library serves as a central hub for all dimensions, where they are imported, created, and refined for all applications. Dimensions, as well as their associated members and member properties, are viewable in the Shared Library and can be dragged into new or existing applications from the shared library to the application library with ease
  • Worked with Oracle Hyperion Financial Reporting for 4+ years, Fusion Edition (Financial Reporting) enables book-quality financial management and reporting targeted Confidential meeting the unique requirements of the Finance department or any functional area that requires very highly formatted multidimensional reporting. This financial reporting solution can use Hyperion Financial Management, Hyperion Planning and Hyperion Essbase as data sources
  • Worked with FDMEE for 3+ Years is a data integration tool that helps transform data and metadata from a variety of sources into a consumable format for Hyperion products like HFM, Planning and Essbase
  • Worked with Oracle Data Integrator Designer for 3+Years to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse databases as well as Hyperion applications

TECHNICAL SKILLS:

Hardware: Pentium 4, IBM AS/400 Mid-Range machine

Operating Systems: Windows XP, Window 2000, MS-Dos, OS/400, UNIX,MVS

Languages & Software: Java2.0, Java script, C, COBOL 400, RPG 400, CL 400, SQL, J2EE, Applets, Servlets, HTML, EJB 1x, 2.0ERP:SAP, People soft, Oracle Financials

ETL Tools: Informatica 8.1/7.1, Data Stage 8.x/7.x

Middleware: Web Logic, IBM s Web Sphere, Java Web Server

Others: MS Project, Visio, MS Office, MS Excel

BI Tools: Hyperion planning 11.x/9.x/4.x/3.x, Hyperion Workforce Planning, Essbase11.x/9.x/7.x/6.x, Oracle Business Intelligence suite, Hyperion Financial Reporting, Hyperion interactive reporting (BRIO) 11.x/9.x/8.x/6.x, Brio Insight, Brio Server 11.x/9.x/6.x,Brio Explorer, Hyperion strategic finance(HSF) Hyperion financial management 4.x/9.x,Smart View, EssbaseAdministration services, Hyperion Data integration management (DIM), Hyperion workspace, Hyperion shared services, Hyperion web Analyzer 9.x,7.x/6.x/5.x, Hyperion Reports 9.x/7.x/2.x, Excel Add- in, EssbaseStudio, Hyperion Visual Explorer.

Tools: Erwin 3.5.2, PVCS, Rational Clear Case

Databases/ERP: Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6,IBM AS/400

EXPERIENCE:

Confidential, Parsippany, NJ

Hyperion Consultant

Responsibilities:

  • Implementing Hyperion Essbase and Planning Systems
  • Worked on Workforce and Total Expense Planning Cubes, Modifying outlines, business rules, calculation scripts, backing up application, reloading data, optimizing as needed using 11.1.2.3
  • Document all designs, processes, map data flows, and explain calc logic and operational concepts to business users
  • Customization of applications, smart lists, data forms, menus and dimensions where done through workforce planning
  • Developed new Hyperion Planning Application Matrix from scratch as per business requirement
  • Created users and user groups in the Planning applications and assigned security to web forms
  • Maintenance of user security and troubleshooting user access issues as they arise
  • Setting up security in planning and assigning access to Forms, Rules and Reports
  • Migration of planning applications from Test to Production
  • Design and development of financial reports on this Planning application.Testing, documentation and user training
  • Building Essbase Cube, writing Calculation Scripts
  • Developing Load Rules, MaxLScripts and batch Scripts for Automating of Data load and Dimension Build Process
  • Coordinating activities to support clients through requirement gathering and process design, MDM leading practices and providing recommendations to manage master data for the EPM and in some cases ERP applications
  • Automated data fetch using UNIX shell script
  • Used macros and VB script to perform advanced operations on data in Excel spreadsheets for data cleansing and validation
  • Responsible for maintenance of more than 5 Cubes (ASO & BSO), including daily, monthly and Quarterly Loads
  • Worked Extensively on Admin Services, Essbase, Planning, Performed monthly and quarterly data loads and verifications
  • Development of PL/SQL and Web PL/SQL stored procedures. Also created Web PL/SQL stored procedures by creating Web pages through Dreamweaver and then used WebAlchemy to convert the HTML to PL/SQL
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, Procedures, cursors and packages. Created programming code using advance
  • Responsible for developing the full stack (from the Markup, JavaScript, Application Services, Database, and Build Scripts)
  • 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..Developed a custom program to report on user/group access information and disabled users in Hyperion Shared Services
  • Full Life cycle project Implementation
  • Creating properties, Property Category as per the requirement
  • Design and development of OBIEE repositories including physical layer, business mapping and model layer, presentation layer as per Business requirements
  • Creation of analyses, dashboards using OBIEE
  • Creating aggregate tables using aggregate procedures in database to improve performance in reports and dashboards
  • Scheduled OBIEE reports to distribute the reports to business users
  • Used OBIEE Eventing poll table to refresh the BI server’s cache and corresponding reports
  • Optimized the SQL queries performance and made the OBIEE dashboards perform better
  • Creating imports for one time build in DRM. Further, Creating Heir and version from the import file from stage Area
  • Creating business rules using validations and verification in MDM/DRM.
  • Creating custom exports as per the requirements by different target systems
  • Automating the whole end-to-end process by using tool internal ability
  • Created simple and composite data forms using Hyperion Planning
  • Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation create and document user procedures, training materials and conduct end user training classes examine business and technical processes enabled with Essbaseand optimize their processing
  • Identify and coordinate data related issue resolution with upstream applications
  • Lead application upgrades, patches and approve changes to the application system software or hardware
  • Extracted, loaded and tied opening and roll forward balance
  • Created Hyperion Security by creating Users, Groups and Filters for Essbase, Analyzer and Hyperion Reports
  • Implemented outline changes to the existing Capex and Workforce planning applications
  • As an administrator I have worked on backup and recovery of applications and security groups. Worked on setting up single sign on security between shared services and other Hyperion products
  • Involved in User sessions to train users on newly developed products and its new functionalities
  • Worked with business users in each and every phase of the project like business requirement gathering, development, UAT and supporting users for existing reports and applications in production

Environment: Hyperion planning 11.1.2.3, Essbase11.1.2.3, ASO, BSO cubes, Hyperion smart view, Hyperion Financial Reporting 11.1.2.3 Oracle 11g, Oracle Applications, MS Excel Add-in, JavaScript,, Foundation, HTML, CSS, and SASS

Confidential, Middletown, NJ

Senior Hyperion Essbase/ Planning Developer

Responsibilities:

  • Implementation of Essbase and Planning Systems
  • Design the infrastructure for the Hyperion Environment from the scratch for 1000 users
  • Installed and configured entire Hyperion infrastructure for test and production instances
  • Involved in Installation, configuration and validation of all 11.1.2.2 Hyperion components
  • Implemented Hyperion Planning Classic applications in four months from the scratch to the Go Live
  • As a technical/functional consultant worked on complete life cycle of the Hyperion Planning Implementation
  • Solution the Data Quality and Data Cleansing tracks for the MDM project
  • Designed application as per end user requirements and fulfilled all the customizations as required
  • Developed Batch Scripts to load data into cubes and schedule to run on a periodic basis
  • Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbaseperformance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision, restructuring cubes for defragmentation
  • Created Hyperion planning web forms to enter, update, analyze, print, and report on data
  • Created transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting
  • Project within budgeting, planning, forecasting, OLAP and reporting solution and manage security of Hyperion apps
  • Building Multi Currency Hyperion Planning Application, Dimension Building using Outline Load Utility
  • Managing hierarchy changes as part of COA (Chart of Accounts) process as well as updating calc scripts, business rules, web forms and reports according to changes
  • 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..Developed a custom program to report on user/group access information and disabled users in Hyperion Shared Services
  • Functioning as a single point of contact for the clients/BPO's on all production related support and maintenance issues
  • Maintenance of user security and troubleshooting user access issues as they arise
  • Monitoring the current Production environment servers for performance and stability
  • Maintenance and Support for Essbase, - and FDM Applications
  • Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application
  • Ability to meet travel requirements, up to 100%
  • Performance tuned the ODI interfaces
  • Optimized the knowledge modules to improve the functionality of the process
  • Performed unit and integration testing. Created various test scenarios to test the application
  • Delivered the assignments before the deadlines
  • Conducted code reviews and planned the knowledge transfer to client
  • Budget Baseline Vs Budget Working Report reports built over the Reporting Cube under the Planning Application in Hyperion Financial Reporting
  • Budget Working Vs Budget Final reports built over the Reporting Cube under the Planning Application in Hyperion Financial Reporting

Environment: Hyperion Financial management 11.1.2.2,Hperion FDQM 11.1.2.2, Hyperion planning 11.1.2, Essbase11.1.2, ASO, BSO cubes, Hyperion smart view, Hyperion Financial Reporting 11.1.2 Oracle 11g, Oracle data Integrator 11g, Oracle Applications, MS Excel Add-in, JavaScript,, HTML, CSS.

Confidential, Saint Louis, MO

Hyperion Essbase/ Planning Developer/Report Developer

Responsibilities:

  • Implemented entire SDLC of Hyperion planning and Essbaseapplications
  • Implemented Workforce and capex planning modules to budget and forecast on HR and capex related data
  • Responsibilities include gather requirements, design, implement, and test and deploy planning and forecasting system
  • Involved in defining requirements, functional specifications, design documentation and test strategy
  • Involved with customers and data analysts in design of data flow, integration and transformation of data into data marts
  • Project within budgeting, planning, forecasting, OLAP and reporting solution and manage security of Hyperion apps
  • Solution the Data Quality and Data Cleansing tracks for the MDM project
  • Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
  • 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..Developed a custom program to report on user/group access information and disabled users in Hyperion Shared Services
  • Created shell scripts for backup and recovery of Essbaseapplications and server file system
  • Experience in Essbase application design and development, focusing on ASO and BSO combination
  • Designed detailed level of security for Hyperion applications using shared services
  • Experience with complex IT and Finance environments with multi-tiered reporting systems
  • Used extensively maxl scripts to automate dimension building and data loading process of ASO and BSO applications
  • Developed numerous financial Reports like Income Statement, cash flow and balance sheet
  • Strong experience in migration of Hyperion application components from one environment to other

Environment: Hyperion planning 11.1.2, Essbase11.1.2, ASO, BSO cubes, Hyperion smart view, Hyperion Financial Reporting 11.1.2 Oracle 11g, Oracle Applications, MS Excel Add-in, JavaScript, Bootstrap, Foundation, HTML

Confidential

ETL (Informatica)/Hyperion Essbase Developer

Responsibilities:

  • Involved in the creation of dimensions and members in EssbaseOutline
  • Involved in the complete Software Development Life Cycle of the applications
  • Optimized the Hyperion application to balance the calculation and retrieval performance
  • Developed the reports as for given client templates in Hyperion analyzer
  • Developed, maintained, debugged and optimized Rule files, Calc Scripts, and batch scripts
  • Created security for the cubes ( created users/Groups)

Environment: OLAP Data Warehousing using Hyperion Essbase7.0, Hyperion Planning 7.0, EssbaseExcel Add-In, MS-Excel, Oracle & Windows 2000

Hire Now