We provide IT Staff Augmentation Services!

Hyperion Essbase Developer Resume

Secaucus, NJ

QUALIFICATIONS/SUMMARY

  • Overall 7+ years of IT experience with 5 years of experience in application designing and development using Oracle/Hyperion Essbase as a Developer/Analyst with analytical and designing skills.
  • Adept in preparing Hyperion reports to measure financial performance, analyze profitability, and facilitate effective business decision making.
  • Extensive experience in Design and development of applications in client/server environment using Hyperion Essbase 11.x/9.x/7.x/6.x , Hyperion Essbase Integration Services, Hyperion Financial Reporting, Hyperion Web Analysis, MaxL and ESSCMD scripts, Essbase Spread sheet add-in.
  • Familiar with different operating system environments like Windows 2000/NT/XP/2003/2008 and Unix.
  • Have worked in all stages of SOFTWARE DEVELOPMENT LIFE CYCLE (SDLC) like Business requirement, planning and analysis, designing, development, implementation and testing.
  • Also have considerable experience in SQL Server 2000 and 2005 like designing complex queries, triggers, stored procedures and functions.
  • Extensive experience of designing and developing Essbase applications with balance of Dense and Sparse Dimensions.
  • Skilled in architecture design of Essbase cubes using Block/Aggregate storage and Partitions.
  • Experience of creating Calculations scripts and automate the Essbase cubes using MaxL and ESSCMD scripts.
  • Working experience of developing reports using Hyperion Financial Reports, Excel Add-in and SmartView.
  • Extensive experience in Excel based custom reporting solutions over diversified data sources.
  • Involved in testing and migration of cubes under different environments to assure security.
  • Experience working with SQL and PL/SQL.
  • Excellent analytical, presentation and interpersonal skills.

TECHNICAL SKILLS

OLAP:Oracle Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion System 9 BI+, MaxL and ESSCMD scripts Reporting Tools: Essbase Spread sheet add-in, Hyperion Integration Services, Hyperion Web Analysis, Hyperion Reports, SmartView Languages SQL, PL/SQL, VB.NET, C#, XML,HTML Databases: SQL 2000/2005, Oracle 10g/9i, MS Access Operating Systems:Windows 2000/NT/XP/2003/2008, UNIX

PROFESSIONAL EXPERIENCE

Hyperion Essbase Developer Mar 2010 - Till Now Confidential, Secaucus, NJ

Responsibilities

  • Analyzed business/user requirements to design and develop new Essbase applications.
  • Developed multidimensional database (MDDB) applications using Essbase that stored and maintained company’s private data.
  • Designed and developed cubes using both kind of storage options ASO and BSO.
  • Extensively involved in designing, developing and modifying outlines by grouping and positioning.
  • Developed rules file for building dimensions using different build methods and data loading.
  • Retrieved data using Excel Add-in to analyze cube outline for data integrity.
  • Created and examined all the Standard and Attribute dimensions and members in the outline for the optimization.
  • Designed and developed monthly, quarterly and yearly profit and loss cubes.
  • Involved in installation and up-gradation of Hyperion Essbase family products.
  • Designed and developed number of applications with balance of dense and sparse dimensions arranged in hour glass fashion.
  • Automated Essbase operations by using MaxL and ESSCMD scripts to run period-to-date balance sheets and ledgers.
  • Retrieved data using Excel spread sheet add-in to analyze the data.
  • For generating reports, used Substitution Variables and also created Report Scripts for analysis.
  • Created various filters as per user requirements.
  • Responsible for granting user access based on their specific needs and assigned them to specific groups to provide security for confidential data.
  • Presented detailed analytical reports to the higher administrative people using Hyperion Reports and Analyzer.

Environment: Hyperion Essbase 11.1.0/9.x, Hyperion Financial Reporting 9.3.1, Hyperion Analyzer 7.2.5, Windows 2008/NT, Excel Spread sheet add-in, SQL Server 2000, Microsoft Excel

Hyperion Essbase Developer/Analyst Sep 2008 - Feb 2010 Confidential, Alpharetta, GA

Responsibilities

  • Involved in finalizing the dimensions for cubes along with the analysis of user requirements.
  • Translated user requirements into application design specification.
  • Extensively involved in designing and modifying outlines for Essbase cubes.
  • Used Essbase Integration services to design and develop cubes.
  • Worked in developing automation scripts using Hyperion Essbase ESSCMD and MaxL scripts.
  • Developed and ran calculation scripts to calculate complex values.
  • Optimized Data load and Calculation scripts by using different techniques.
  • Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations.
  • Involved in system installation, configuration and software upgrade of Hyperion Essbase.
  • Handled performance tuning, weekly back-ups and monthly consolidations of data.
  • Automated monthly/quarterly/annual report generation.
  • Maintained user input capabilities to the applications using Filters.
  • Modified the existing outline for some applications according to the requirements.
  • Provided technical support for existing cubes, resolving and troubleshooting related issues and documentation.
  • Established user security, managed application migration, established substitution variables and setting for dynamic time series, editing/validating scripts.
  • Provided business analyst with advice and options on opportunities to leverage the tool and increase the usage.

Environment: Hyperion Essbase 11.1.0/9.3.1, Essbase Integration Services 9.3.1, Hyperion Financial Reporting 9.3.1, Essbase Excel Spread sheet Add-in, oracle 10g, Windows Server 2003

Hyperion Essbase Consultant Oct 2007 - Aug 2008 Confidential, Overland Park, KS

Responsibilities

  • Responsible for modifying and optimizing the existing outlines.
  • Also created few new cubes.
  • Optimized proper database calculations and loads by modifying the existing dimensions and creating new Dense and Sparse settings of members and by providing appropriate storage allocations.
  • Responsible for performance tuning, regular backup and recovery of cubes.
  • Responsible for identifying problems, resolutions and documentation.
  • Used Essbase integration services to load the data.
  • Created OLAP model and Meta outline for Essbase server using EIS.
  • Created Substitution variables to generate monthly/quarterly/annual balance reports for the company.
  • Created new users and groups, assigned existing users to those groups and granted access to the users and groups as per their specific needs to access the cubes.
  • Used Filters to control the access of those users and groups to individual data within the database to provide security at the detailed level.

Environment: Hyperion Essbase 7.0, Hyperion reports 7.0, Essbase Integration services, Excel Spread sheet Add-in, SQL server 2000, Windows NT

Essbase Developer/DBA Feb 2006 - Sep 2007 Confidential, Tulsa, OK

Responsibilities

  • Played major role in user requirement analysis, development and implementation of finalizing dimensions and members of the cubes.
  • Developed Rules files to upload data from financial system’s database to Essbase cube.
  • Created and maintained Essbase application objects including Database outline, Calculation scripts and security settings.
  • Involved in defining requirements, functional specifications, design documentation and testing strategies.
  • Involved in designing and implementing new cubes.
  • Worked on Rules files to manipulate data source file using various build methods.
  • Involved in redesigning existing cubes for overall database outline performance and optimization.
  • Maintained and supported existing applications, worked on production, participated in routine maintenance of applications for better performance.
  • Performed tuning by using Dense/Sparse settings and developed the required alternate roll ups for the reports.
  • Responsible for Partition the databases for better data retrieval, security of databases, database migration, Managed sessions and log analysis to optimize the database.
  • Performed recovery and back up process on regular basis.
  • Developed SQL and PL/SQL scripts to extract and transform data into the data warehouse system.
  • Assisted in migrating the Essbase cubes.
  • Worked on user systems with Excel Add-in and trained users on Excel client usage.
  • Used Hyperion Analyzer to design reports like Balance sheets, P&L sheets, and Cash flow and Income statements.

Environment: Hyperion Essbase 6.5.1, Hyperion Reports, Hyperion Analyzer 6.5, Excel Spread sheet add-in, Oracle 9i, Window 2000 and Unix

Software Developer July 2004 - Nov 2005 Confidential, Baroda, Gujarat, India

Responsibilities

  • Developed "Project Status Monitoring" tool to keep track of the status of various projects.
  • Interacted with business units and collected project related requirements.
  • Worked through whole Software development life cycle process starting from requirement gathering, planning, designing, coding and testing the application. And built the whole system using ASP.Net and C#.Net.
  • Also involved in the database design and development using SQL.
  • Developed stored procedures, triggers using SQL 2000 to facilitate ADO.Net functions of the project.
  • Worked as a Trainee on Hyperion Essbase 6.0 to develop multidimensional database (MDDB) which was a new concept being deployed in the company.
  • Extensively involved in analysis of user requirements to design and develop new Essbase applications.
  • Responsible for designing and developing outline using sparse and dense dimensions.
  • Used Rules files to build dimensions and load data into the Essbase Server.
  • Also involved in developing Report Scripts to generate Income and Expense statement analysis reports.

Environment: ASP.Net 1.1, C#, Hyperion Essbase 6.0, Excel Spread sheet Add-in, SQL Server 2000, MS Access

Junior Developer Jan 2004 -June 2004 Confidential, Baroda, Gujarat, India

Responsibilities

  • Project handled was "Online Examination Systems" using VB.Net and ASP.Net as a Front end and MS Access as a Back-end.
  • This project helped the education department of the company to maintain the records of their students and also their results in online exams.
  • Created Windows as well as Intranet application for this purpose.
  • Responsible for database design and architecture.
  • Developed stored procedures, triggers using SQL 2000 to facilitate ADO.Net functions of the project.

Environment: Vb.Net 1.1, ASP.Net 1.1, SQL 2000, MS Access, Windows 2000

References: Provided upon request.

Hire Now