We provide IT Staff Augmentation Services!

Senior Hyperrion/bi Customer Service Consultant Resume

3.00/5 (Submit Your Rating)

Greensboro, NC

SUMMARY

  • 9+ years of diverse experience in Information Technology and customer Service wif users wif emphasis on Data warehousing and Hyperion products for customers
  • Over 8++ 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 6 Hyperion Essbase and Financial Management Projects in version 11.1.2
  • Implemented 4 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
  • Worked on ETL Tools(DataStage,Informatica) and BI Tools (SAP Business Objects, QlikView and Microsoft SQL Server Reporting Services) during implementation of Projects
  • 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 wif 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 wif 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 wif 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 wif 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, TEMPeffective tax rate, and deferred tax for tax provisioning purposes in last project
  • Worked wif 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 wif ease

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 11g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6,IBM AS/400

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Senior Hyperrion/BI customer service Consultant

Responsibilities:

  • Responsible for maintenance of more than 4 Cubes (ASO & BSO), including daily, monthly and Quarterly Loads
  • Worked on Hyperion Financial Management Modifying outlines, business rules,backing up application, reloading data, optimizing as needed using 11.1.2.4
  • Worked on Essbase Studio 11.1.2.4 Modifying outlines for Essbase ASO Cubes .
  • Worked on ODI 11.1.1 to Extract HFM Jobs and Outline for Essbase and Modify Substitution Variables
  • Worked on Budgeting Process wif Financial Planning users of Different Markets
  • Worked on EPMA 11.1.2.4 on Shared Dimensions and deploy essbase ASO and BSO cubes and HFM .
  • Worked on Shared Services for giving user permissions and access to Hyperion suite of products.
  • Worked Extensively on Admin Services, Essbase, 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
  • 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
  • Implemented solutions are well designed and developed for a secure, reliable, high performing, and highly-available experience for end users
  • Supported the solution development process by providing Customer Finance business best practices and technical best practices and identifying functionalities necessary to cover business needs
  • Provided metrics to measure the performance of the solutions in run-time
  • Validate the functional and technical specifications and test cases
  • Provided business expertise and knowledge in simple or complex process flows and mapping wif applications, group of applications, or applications sub-portfolios
  • Provided support for multiple departments and segments
  • Participated in design reviews, identify inefficiencies and ways to improve design, provide alternatives and improve development processes
  • Worked on Troubleshooting systems production/performance issues under tight deadlines
  • The ability to translate functional requirements into system design/build and Reports
  • Advanced understanding of financial allocations, consolidations and reporting processes
  • Extensive working knowledge of Hyperion Suite of products
  • Support project team wif the implementation of solutions
  • Analysed business requirements to understand needs for solution modifications
  • Analysed the application environment to detect critical deficiencies and identify improvement opportunities
  • Worked wif Project Manager, Business Analyst and Software Lead to provide detailed IT development estimates and implementation plan
  • Tested software products thoroughly through both unit and QA test phases, and assist the Project Manager in resolving software issues during the UAT testing phase
  • Assisted in product launch and production support operations as appropriate to ensure quality
  • Experience wif complex IT and Finance environments wif multi-tiered reporting systems
  • Used extensively maxl scripts to automate dimension building and data loading process of ASO and BSO applications

Environment: Hyperion planning 11.1.2.4, Essbase11.1.2.4, ASO, BSO cubes, Hyperion smart view, Hyperion Financial Reporting 11.1.2.4,Hyperion Financial Management 11.1.2.4,Essbase Studio 11.1.2.4,ODI 11.1.1, Oracle 11g, Oracle Applications, MS Excel Add-in, JavaScript,, Foundation, HTML, CSS, and SASS

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 wif Essbaseand optimize their processing
  • Identify and coordinate data related issue resolution wif 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 wif 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

Hyperion Consultant

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 wifin 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 Consultant

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 wif customers and data analysts in design of data flow, integration and transformation of data into data marts
  • Project wifin 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 wif complex IT and Finance environments wif 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

We'd love your feedback!