Hyperion Essbase sample resume - 1
Sr. Hyperion Administrator
Project Scope: NII Holdings, Inc., formerly known as Nextel International, ("NII") is one of the world's leading providers of fully integrated wireless communication services designed to meet the needs of business customers in international markets. The Project involved in Maintaining Hyperion Servers UNIX and Windows Based for Production and Development Environment. Providing help and support to over sea’s Users on daily basis.
Role & Responsibilities:
· Responsible for system enhancement, maintenance, and administration.
· Interacted with users to support analysis and provide definition and requirements for the Hyperion Planning Application and other Essbase supported processes.
· Responsible for providing production and development support.
· Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them. Recovered applications from its back up.
· Installed and set up the server with Hyperion Essbase.
· Responsible to open Tickets with Hyperion support for product related issues.
· Involved in working with Hyperion Support to solve the product related issues.
· Involved in creating SLA document.
· Involved in providing full support for Hyperion Planning.
· Responsible for scheduling batch jobs for planning application.
· Responsible for providing full support for all Applications in Hyperion System 9.2.0
· Actively participated in defining requirements, functional specifications, designing documentations and testing strategies. Involved in Back ups of all production cubes.
· Responsible for starting and stopping all Hyperion Services in production and development environment.
· Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how many forms, how many business rules, how many calc scripts are there in the developed application and what is all this use for in the application.
· Involved in creating documentation for all the log files in Hyperion System 9.2.0 Software.
· Involved in improving Hyperion application performance for over sea’s user.
Technology/Platform: Hyperion Essbase 9.2.0, Hyperion System 9.2.0, Hyperion Planning System 9.2.0, Hyperion Analytic Administration Service (AAS) System 9.2.0 and Hyperion Performance suite. Essbase Services 9.2.0, Microsoft Excel XP, Oracle 9i, Windows 2000 Advance Server, Unix servers HP-UX 11.23
Sr. Hyperion Administrator/Developer
Project Scope: The Project involved developing Sales & Marketing Cubes & Reports; Nestle Corp wanted a webpage on which they wanted to put Analyzer reports link, this helped their top level management to view desired reports just a click away, and avoid to surf tool to get the reports. This webpage used Analyzer Security. Nestle Corp always is in need of numerous web-based Sales reports as well as their in-house Sales reports for its widespread National markets. Essbase, EIS, Hyperion Reports, Hyperion Analyzer are extensively used to generate these reports. With the help of these Hyperion products, Sales are deployed online and managers can see the numbers on a daily basis.
Role & Responsibilities:
· Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan.
· Performed advanced planning of automation needs necessary to define business system project objectives and prepare project plan.
· Performed functional gap analysis and Full Development Lifecycle through RUP methodology.
· Interacted with finance and accounting customers who possessed various levels of technical knowledge.
· Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members. Migrated Essbase server into newer versions and newer operating systems.
· Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server.
· Used incremental and complete backup methods to backup all the applications and databases.
· Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, Executive Viewer, and Hyperion Reports.
· Responsible for providing technical and production support for live applications and also for end users.
· Did daily monitoring of Hyperion Essbase cubes for errors and find out the cause of the errors if any.
· Create webpage on which there were links of the analyzer reports grouped according to Nestle Corp classifications. This webpage used Analyzer security and directly opened the reports required by high-level management without login into analyzer.
· Involved in providing security authentication for the users of Hyperion Analyzer, Essbase and maintaining workflow management process.
· Used smart view to provide enhanced integration with MS Excel and access to multiple data sources.
· Involved in creating Rule files and batch files to automate the data load process.
· Created (.ksh) scripts to automate the entire data load.
· Developed Data Loads and numerous Calc Scripts and optimized them. Used ESSCMD in an interactive and batch mode to load data files. Developed and maintained Rules file for loading of data.
· Installed, configured, set up Hyperion Analyzer and Hyperion Analytical server on Windows server.
· Analyzed financial results and prepared trend reports to support business managers make prudent and profitable decisions.
· As an administrator, created users in Analyzer and Essbase and assigned different roles to them
· Did daily monitoring of the Essbase cube to check the data is loaded and to maintain the dimension members.
· Did modifications in the ASO cubes according the user requirements.
· Run the member’s consolidation to calculate, translate, and consolidate data across different dimensions.
Technology/Platform: Hyperion Essbase 6.5, Hyperion System 7.1, and Hyperion Metrics Builder, Hyperion Performance suite. Essbase Integration Services (EIS-7.1), Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server
Sr. Hyperion Developer/Business Analyst
Project Scope: Project was to add all data feeds currently going to the retail profit and loss Database to the Management Reporting System (MARS). The old system generated web based canned reports in business objects and did not have a drill down formatting and graphical charts facility. The finance dept wanted information system at the agent level, moving from a geographically based sales structure to one focused on sales channels – Retail/Consumer, B2B and National Distribution.
Role & Responsibilities:
· Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan
· Interaction with finance and accounting customers who possessed various levels of technical knowledge.
· As an administrator, created users and assigned different roles to them.
· Created different security classes and assigned them to the different users and dimensions.
· Managed Task Security, task securities determines tasks within an application and authentic valid user to access the data; each user role is associated with the set of tasks.
· Worked on Data Security to protect data and prevent unauthorized access of users from changing data in Hyperion Planning and developed web forms in Hyperion Planning.
· Designed and developed metadata and assigned member properties like consolidation/ calculations, UDA, and Alias to the different dimension members.
· Developed different rules files to implement business logic.
· Worked extensively with windows and web client to manage different Planning applications.
· Provided training to accounting/ business users on navigating through windows/web clients of Planning.
· Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase cubes.
· Exported the data contents using the VBA procedures, which copied cells into a new worksheet.
· Developed Aggregate Storage Cubes (A.S.O) using Essbase 7.1. Optimized applications to bring down runtime and database size considerably.
· Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
· Developed star schema for the OLAP model, and created EIS Meta-outline for the Essbase cubes.
· Created custom designed reports by complex procedures for accessing, manipulating and reporting enterprise data from Oracle and SQL Relational Databases. Used HTML procedures to generate complex reports and created many Web Reports.
· Involved in Installing, configuration, backups and client installation of Planning.
Technology/Platform: Hyperion Essbase 7.1/6.5.4, Hyperion Planning 3.5, Hyperion Reports7.0, Hyperion Integration Services, Hyperion Administration Services, Hyperion Analyzer7.0, MAXL, ESSCMD, Excel Add-In, MS Project, Oracle, Windows NT/2000, Rational Rose, Visio 2003, Oracle 8i, UML – Magic Draw.
Sr. Hyperion Essbase Consultant
Project Scope: This was a prototype project in the Strategy and Risk Cost Center to integrate scattered data in spreadsheets and an Oracle database into Essbase Applications. And further use it for reporting using the analyzer. As part of a team of 4 we worked together to develop several applications in Essbase, Planning, H.F.M.
Role & Responsibilities:
· Assisted Business users in creating Journals, Data entry forms, and Data grids.
· Defined different journal groups and developed templates to assist end users in developing journals for entering data into HFM database.
· Developed workspaces that can be used for the monthly close process.
· Run the member’s consolidation to calculate, translate, and consolidate data across different dimensions.
· Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process.
· Written and executed unit test plans / system test plans, UAT plans, quality assurance test plans and test strategies.
· Used smart view to provide enhanced integration with MS Excel and access to multiple data sources.
· Interacted with end users and developed numerous Business Rules in Hyperion Planning.
· Involved in creating Rule files and batch files to automate the data load process.
· Created wrapper scripts (.ksh) to automate all the variables and all the (.scr) scripts.
· Developed Data Loads and numerous Calc Scripts and optimized them.
· Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
· 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.
· Implemented Data Access layer to Communicate with the Oracle Database.
· Installed and upgraded Hyperion Planning applications.
§ Created and mapped H.A.L jobs to load the hierarchies into different planning applications.
§ 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.
§ Created and managed numerous Data entry forms and created many Business Rules for several applications.
§ Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes. Created various Reports in Hyperion planning.
Technology/Platform: Hyperion Essbase 6.5.4, Hyperion Analyzer 7.0, Hyperion Planning 3.5.1, Hyperion Reports 7.1.2, EIS 6.5.4, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server.
Hyperion Essbase Developer/Analyst
Project Scope: The Project involved developing Sales & Marketing Cubes & Reports; Johnson Controls always is in need of numerous web-based Sales reports as well as their in-house Sales reports for its widespread international markets. Essbase, Hyperion Reports, Hyperion Analyzer are extensively used to generate these reports. With the help of these Hyperion products, Sales are deployed online and managers can see the numbers on a daily basis. Almost 320 different types of reports are recreated in one single report with the help of Essbase cubes. The IT department of Johnson Controls was in need of Calculation Scripts which would allocate Plan, Actual and Forecast data values to various SBU’s.
Roles & Responsibilities:
· Made changes in the database outline of the CONSOL application to accommodate the working of the Allocation Calc Scripts.
· Designed and developed a new Calculation script to copy all the allocation driver data from Plan->Version1 to Plan->ALLOC_VERSION and then transferring these data values to the new created substitution variables &AllcScenario->&AllcVersion thus easing the maintenance of the allocation Calc Scripts.
· Designed and created new server substitution variables thereby narrowing down the management of a single calc script for both Plan and Actual Scenario Dimension.
· Used Essbase functions such as @MDALLOCATE and @DESCENDENTS in creating these calc scripts.
· Created and made changes to the existing MaxL scripts and scheduled the batch script to automate the running of the new Calc Scripts.
· Used Excel Spreadsheet Add-in to test the working of the Allocation Calc Scripts.
· Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, Executive Viewer, and Hyperion Reports.
· Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members.
· Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server.
Technology/Platform: Hyperion Essbase 6.54.2, Hyperion XTD, MaxL, Essbase Spreadsheet Add-In, Windows NT, DOS
=========================================================================
hyperion essbase sample resume - 2
Project Summary: Bank of America is one of the world's leading financial services companies growing rapidly with new acquisitions, providing financial services to individuals, small businesses and corporate clients. At Bank of America, I worked on projects Hoshin Kanri, Funds Transfer and Pricing (FTP) and Customer Level Profitability Reporting (CLPR). As part of these projects, I had to analyze the existing data models, provide alternative solutions, develop HLD’s/LLD’s and test plans and set up development environment and test environment. These projects involved development of reports in Hyperion Intelligence and Hyperion Reports and co-ordinate near shore-off shore activities.
Roles & Responsibilities:
· Installed and configured Hyperion Intelligence Designer and Hyperion Intelligence Architect.
· Installed and configured Hyperion Reports and Essbase run time clients on Windows XP upgrade the software with the newest releases.
· Was responsible for the development of reports and dashboards using Hyperion Intelligence and Hyperion Reports.
· Designed and developed various types of reports (Pivot, Tabular, Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
· Analyze the requirements and data model and come up with a working model and provide alternative solutions.
· Develop HLDs/LLDs and test plans.
· Set up the development and test environments.
· Grant access privileges to users and user-groups as part of security needs.
· Develop Dashboards providing extensive functionality.
· Develop Java scripts to provide functionality to various dashboard objects and also modify local result sets.
· Worked on Report layouts and Report formatting.
· Worked on stored procedures and local result sets to retrieve the required data efficiently.
· Build queries to transform user requests to result sets.
· Develop and test reports in Hyperion Reports.
· Perform administrative tasks on the repository.
· Was the onsite lead and had to co-ordinate near-shore and off-shore activities.
Environment: Hyperion Intelligence 8.3, Hyperion Reports 7.2.1, Hyperion Essbase 7.1, Excel Add-In, MS Project, SQL server, Teradata, Windows XP.
Client: Regions Bank, Birmingham, AL
Role: Hyperion Intelligence Developer/Analyst Dec 2004 – Dec 2005
Project Summary: This project was carried out as part of the Hyperion development and maintenance at Regions Bank Birmingham. The project involved development of reports highlighting the financial results of various businesses at the bank. These financial reports give a snapshot of the various businesses enabling the managers and decision makers to analyze the business trends. Hyperion Performance Suite was used to develop the reports. Extensive Dashboards were built providing easy access to the managers and executives to various reports.
Roles & Responsibilities:
· Installed and configured various components of Hyperion Performance Suite on windows server and was responsible for the development of reports and dashboards using Hyperion Intelligence.
· Hands-on experience on the various facets of the Hyperion Performance Suite.
· Created an OCE connection to connect to the Oracle database.
· Publish reports to the Foundation and give access privileges to various user groups.
· Apply various Filters for efficient and accurate retrieval of required data.
· Integrated SQR with front-end user interface tools and spreadsheets and tuned programs for optimum performance.
· Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion SQR Developer and Hyperion SQR Viewer.
· Using functionality of Hyperion Intelligence and SQR, created a personalized dashboard, developed personalized report query and performed analysis.
· Designed and developed various types of reports (Pivot, Tabular, Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
· Performed migration of reports from previous versions to the current version of Hyperion Intelligence.
· Created and managed BQY job schedule, created and managed time events using Hyperion Performance Suite.
· Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reports in Hyperion SQR and Hyperion Intelligence by working with the business managers.
· Used Hyperion Analyzer to develop reports to outlines the quarterly region wise financial results.
· Used Hyperion Intelligence Clients to facilitate intelligent querying of multiple databases and analytical reporting across the extended enterprise, quickly and intuitively.
Environment: Hyperion Essbase 7.1/6.5, Hyperion Intelligence 8.0, Brio SQR, Hyperion Performance Suite 8.x, Hyperion Analyzer 7.0, Excel Add-In, MS Project, Oracle, Windows 2003/2000
Client: Benchmark Medical, Inc., Philadelphia, PA
Role: Hyperion Intelligence/Essbase Developer May 2004 – Nov 2004
Project Summary: Benchmark is one of the Nation’s leading providers in the musculoskeletal outpatient rehabilitation industry, with over 350 points of service in 19 states. Benchmark has service lines which include outpatient therapy, orthotics and prosthetics, and industrial rehabilitation. The project involved building a cube, putting the processes for automation and designing and generating reports and dashboards for helping the management with the financial reports and decision making.
Roles & Responsibilities:
· Was involved in the installation, configuration, and administration of the Hyperion/Brio Performance Suite product packages such as Designer, Explorer, Insight Server, Intelligence iServer, Reports iServer, Brio SQR.
· Did reporting, charting and spotlighting using Dashboards.
· Developed SQR code to create tabular, non-tabular, master/detail system independent portable reports along with graphs and charts to present data in visual terms.
· Models were used to analyze many business issues and to integrate the strategic planning processes. Developed user friendly reports and graphs self contained in financial models.
· Extensively worked with Hyperion SQR, Hyperion Reports and Hyperion Analyzer to generate financial reports from different Multi-Dimension Databases.
· Extensively involved in the financial planning model calculations i.e. (Profit, Forecast, Marginal Profit, Elimination, Consolidation, and Headcount) using Hyperion Business Rules.
· Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends and Expense Variances over prior periods using Hyperion SQR Developer.
· Optimized the applications to bring down calc runtime and database size considerably.
· Designed and implemented batch scripts for loading data from the financial system’s database to Essbase cube through data files and rule files.
· Designed users input capability to the applications maintained by Filters.
Environment: Hyperion Intelligence 8.1, Essbase 6.5, Hyperion Planning 3.3 Hyperion Application Link, Hyperion Essbase Integration Services 6.5, Hyperion SQR 8.3, Hyperion Analyzer 6.5, Essbase Spreadsheet Add-in, SQL Scripting, MS Access, MS-SQL Server, Windows 2000/NT
Client: Dun & Bradstreet (D&B), Parsippany, NJ
Role: Hyperion Intelligence/Essbase Developer Aug 2003 – Apr 2004
Dun & Brad Street has a range of solutions to help you integrate data from different sources, automate credit decisions and analyze the risks in your portfolio. Risk Management Solutions; helps customers manage credit exposure and cash. Sales & Marketing Solutions; helps customers find profitable clients and grow. Supply Management Solutions; help customers manage suppliers effectively and save. E-Business; help customers convert prospects to clients faster. Existing Essbase application Market Bridge Demo was build by a third party, which had no support.
Roles & Responsibilities:
· Involved in the installation of Hyperion Performance Suite products.
· Used BRIO SQR extensively for creating custom designed reports for accessing, manipulating and reporting enterprise data from relational databases.
· Using combined functionality of Hyperion/BRIO Intelligence and SQR, created a personalized dashboard.
· Developed users and groups in Hyperion Analyzer and assigned users to different groups.
· Involved in system installation, configuration, and software upgrades from Essbase version 6.0 to 6.5.
· Involved in defining requirements, functional specifications, designing documentations and testing strategies.
· Created Essbase outlines formulas and Calc Scripts using advanced Calc Script functions.
· Extracted the Source Systems Data from the distributed environment, transformed and loaded into the data warehouse database and then populated into Essbase Cube.
· Provided 24/7 Essbase technical support to all business units, offered suggestions and proposed solutions to resolve issues.
· Planning and coding complex reports developed in Excel using Visual Basic for Applications and the EssBase API.
· Developed Excel Templates for user interface in Essbase database.
Environment: Brio Intelligence 6, Hyperion Essbase 6.5.4.2/6.0, Hyperion Analyzer, Essbase Excel-Add-in, MS Access, Oracle 8.x, Windows 2000/NT 4.0, DB2.
Client: United Health Group, Minneapolis, MN
Role: Hyperion Essbase Developer Nov 2002 – Jul 2003
Project Summary: United Health Group is a group of companies, which include United Health Care, Ovations Uniprise, Specialized Care Services, Ingenix and various other business segments. Each of these different segments provides various products and services across the nation. The aim of the project was to provide the top management and end users, a fully functional data warehouse for each of the business segments separately and as per the user requirements. Development of various cubes, developing calc scripts, developing load rules forecast and budgeting for the next 24 months, combining various cubes, SQL performance tuning, optimization of calc time, were few of the performed tasks.
Roles & Responsibilities:
· Installed and set up the server with Hyperion Essbase and Hyperion Reports.
· Improved data loading and database calculation by modifying the Essbase configuration file settings.
· Developed a multi-dimensional database (MDDB) application using EssBase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Load Rules files.
· Create system models, specifications, diagrams, charts, and document system operational procedures to enhance support functions.
· Developed Calc scripts using the Calc script editor for performing calculations.
· Developed and maintained Rule files, Calc Scripts, and Esscmd Scripts.
· Automated Essbase Cubes through Batch Scripts using Esscmd.
· Optimization and performance tuning for Data Loads/Calculations.
· Maintained cubes and took regular backup.
· Provided technical guidance and support to end-users by developing documentations.
· Involved in weekly meetings to discuss current project status.
Environment: Hyperion Essbase 6.5/6.0, Hyperion Analyzer, Hyperion Reports 2.6, Essbase Spreadsheet Add-in, MS SQL Server 7.0, Windows NT 4.0
Client: Electronics Corporation of India Limited, Hyderabad, India
Role: Technical Officer Dec 2000 – Oct 2002
Project Scope: V5.2-COT is a central office terminal (COT) that interconnects Local Exchange (LE) on one side through V5.1/V5.2 interface and RT-480 through STM-1/4 interface on the other side. A maximum of 16 E1 interfaces can be connected on the LE side and a maximum of 63 E1 interfaces can be connected on the Remote Terminal (RT) side, supporting a maximum of 1890 subscribers and provides facilities such as the POTS and the ISDN. The V5.2-COT uses the concept of Fiber in Local Loop (FLL) and is one of the improvements in the access network area of telecom operations.
Roles & Responsibilities:
· Did porting of Network Layer of the V5.2 stack to integrate the V5.2 stack with the application software.
· Designed and developed Protocol Conversion Module which receives PSTN and ISDN message packets from LE and converts them to RT-proprietary protocol and vice versa.
· Designed and developed Inter Processor Module which exchanges data received on serial port between the OSI card and the control PC.
· Designed and developed OSI device driver for the OSI interface card for both the ISA based card as well as PCI based card.
· Made extensive use of IPC mechanism for message transfer and worked on TCP and UDP sockets.
· Coordinated the system integration and environmental testing.
Environment: C++, C, IPC, Sockets, Windows’98, Red Hat Linux 7.2.
Sr. Hyperion Administrator
Project Scope: NII Holdings, Inc., formerly known as Nextel International, ("NII") is one of the world's leading providers of fully integrated wireless communication services designed to meet the needs of business customers in international markets. The Project involved in Maintaining Hyperion Servers UNIX and Windows Based for Production and Development Environment. Providing help and support to over sea’s Users on daily basis.
Role & Responsibilities:
· Responsible for system enhancement, maintenance, and administration.
· Interacted with users to support analysis and provide definition and requirements for the Hyperion Planning Application and other Essbase supported processes.
· Responsible for providing production and development support.
· Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them. Recovered applications from its back up.
· Installed and set up the server with Hyperion Essbase.
· Responsible to open Tickets with Hyperion support for product related issues.
· Involved in working with Hyperion Support to solve the product related issues.
· Involved in creating SLA document.
· Involved in providing full support for Hyperion Planning.
· Responsible for scheduling batch jobs for planning application.
· Responsible for providing full support for all Applications in Hyperion System 9.2.0
· Actively participated in defining requirements, functional specifications, designing documentations and testing strategies. Involved in Back ups of all production cubes.
· Responsible for starting and stopping all Hyperion Services in production and development environment.
· Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how many forms, how many business rules, how many calc scripts are there in the developed application and what is all this use for in the application.
· Involved in creating documentation for all the log files in Hyperion System 9.2.0 Software.
· Involved in improving Hyperion application performance for over sea’s user.
Technology/Platform: Hyperion Essbase 9.2.0, Hyperion System 9.2.0, Hyperion Planning System 9.2.0, Hyperion Analytic Administration Service (AAS) System 9.2.0 and Hyperion Performance suite. Essbase Services 9.2.0, Microsoft Excel XP, Oracle 9i, Windows 2000 Advance Server, Unix servers HP-UX 11.23
Sr. Hyperion Administrator/Developer
Project Scope: The Project involved developing Sales & Marketing Cubes & Reports; Nestle Corp wanted a webpage on which they wanted to put Analyzer reports link, this helped their top level management to view desired reports just a click away, and avoid to surf tool to get the reports. This webpage used Analyzer Security. Nestle Corp always is in need of numerous web-based Sales reports as well as their in-house Sales reports for its widespread National markets. Essbase, EIS, Hyperion Reports, Hyperion Analyzer are extensively used to generate these reports. With the help of these Hyperion products, Sales are deployed online and managers can see the numbers on a daily basis.
Role & Responsibilities:
· Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan.
· Performed advanced planning of automation needs necessary to define business system project objectives and prepare project plan.
· Performed functional gap analysis and Full Development Lifecycle through RUP methodology.
· Interacted with finance and accounting customers who possessed various levels of technical knowledge.
· Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members. Migrated Essbase server into newer versions and newer operating systems.
· Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server.
· Used incremental and complete backup methods to backup all the applications and databases.
· Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, Executive Viewer, and Hyperion Reports.
· Responsible for providing technical and production support for live applications and also for end users.
· Did daily monitoring of Hyperion Essbase cubes for errors and find out the cause of the errors if any.
· Create webpage on which there were links of the analyzer reports grouped according to Nestle Corp classifications. This webpage used Analyzer security and directly opened the reports required by high-level management without login into analyzer.
· Involved in providing security authentication for the users of Hyperion Analyzer, Essbase and maintaining workflow management process.
· Used smart view to provide enhanced integration with MS Excel and access to multiple data sources.
· Involved in creating Rule files and batch files to automate the data load process.
· Created (.ksh) scripts to automate the entire data load.
· Developed Data Loads and numerous Calc Scripts and optimized them. Used ESSCMD in an interactive and batch mode to load data files. Developed and maintained Rules file for loading of data.
· Installed, configured, set up Hyperion Analyzer and Hyperion Analytical server on Windows server.
· Analyzed financial results and prepared trend reports to support business managers make prudent and profitable decisions.
· As an administrator, created users in Analyzer and Essbase and assigned different roles to them
· Did daily monitoring of the Essbase cube to check the data is loaded and to maintain the dimension members.
· Did modifications in the ASO cubes according the user requirements.
· Run the member’s consolidation to calculate, translate, and consolidate data across different dimensions.
Technology/Platform: Hyperion Essbase 6.5, Hyperion System 7.1, and Hyperion Metrics Builder, Hyperion Performance suite. Essbase Integration Services (EIS-7.1), Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server
Sr. Hyperion Developer/Business Analyst
Project Scope: Project was to add all data feeds currently going to the retail profit and loss Database to the Management Reporting System (MARS). The old system generated web based canned reports in business objects and did not have a drill down formatting and graphical charts facility. The finance dept wanted information system at the agent level, moving from a geographically based sales structure to one focused on sales channels – Retail/Consumer, B2B and National Distribution.
Role & Responsibilities:
· Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan
· Interaction with finance and accounting customers who possessed various levels of technical knowledge.
· As an administrator, created users and assigned different roles to them.
· Created different security classes and assigned them to the different users and dimensions.
· Managed Task Security, task securities determines tasks within an application and authentic valid user to access the data; each user role is associated with the set of tasks.
· Worked on Data Security to protect data and prevent unauthorized access of users from changing data in Hyperion Planning and developed web forms in Hyperion Planning.
· Designed and developed metadata and assigned member properties like consolidation/ calculations, UDA, and Alias to the different dimension members.
· Developed different rules files to implement business logic.
· Worked extensively with windows and web client to manage different Planning applications.
· Provided training to accounting/ business users on navigating through windows/web clients of Planning.
· Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase cubes.
· Exported the data contents using the VBA procedures, which copied cells into a new worksheet.
· Developed Aggregate Storage Cubes (A.S.O) using Essbase 7.1. Optimized applications to bring down runtime and database size considerably.
· Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
· Developed star schema for the OLAP model, and created EIS Meta-outline for the Essbase cubes.
· Created custom designed reports by complex procedures for accessing, manipulating and reporting enterprise data from Oracle and SQL Relational Databases. Used HTML procedures to generate complex reports and created many Web Reports.
· Involved in Installing, configuration, backups and client installation of Planning.
Technology/Platform: Hyperion Essbase 7.1/6.5.4, Hyperion Planning 3.5, Hyperion Reports7.0, Hyperion Integration Services, Hyperion Administration Services, Hyperion Analyzer7.0, MAXL, ESSCMD, Excel Add-In, MS Project, Oracle, Windows NT/2000, Rational Rose, Visio 2003, Oracle 8i, UML – Magic Draw.
Sr. Hyperion Essbase Consultant
Project Scope: This was a prototype project in the Strategy and Risk Cost Center to integrate scattered data in spreadsheets and an Oracle database into Essbase Applications. And further use it for reporting using the analyzer. As part of a team of 4 we worked together to develop several applications in Essbase, Planning, H.F.M.
Role & Responsibilities:
· Assisted Business users in creating Journals, Data entry forms, and Data grids.
· Defined different journal groups and developed templates to assist end users in developing journals for entering data into HFM database.
· Developed workspaces that can be used for the monthly close process.
· Run the member’s consolidation to calculate, translate, and consolidate data across different dimensions.
· Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process.
· Written and executed unit test plans / system test plans, UAT plans, quality assurance test plans and test strategies.
· Used smart view to provide enhanced integration with MS Excel and access to multiple data sources.
· Interacted with end users and developed numerous Business Rules in Hyperion Planning.
· Involved in creating Rule files and batch files to automate the data load process.
· Created wrapper scripts (.ksh) to automate all the variables and all the (.scr) scripts.
· Developed Data Loads and numerous Calc Scripts and optimized them.
· Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
· 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.
· Implemented Data Access layer to Communicate with the Oracle Database.
· Installed and upgraded Hyperion Planning applications.
§ Created and mapped H.A.L jobs to load the hierarchies into different planning applications.
§ 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.
§ Created and managed numerous Data entry forms and created many Business Rules for several applications.
§ Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes. Created various Reports in Hyperion planning.
Technology/Platform: Hyperion Essbase 6.5.4, Hyperion Analyzer 7.0, Hyperion Planning 3.5.1, Hyperion Reports 7.1.2, EIS 6.5.4, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server.
Hyperion Essbase Developer/Analyst
Project Scope: The Project involved developing Sales & Marketing Cubes & Reports; Johnson Controls always is in need of numerous web-based Sales reports as well as their in-house Sales reports for its widespread international markets. Essbase, Hyperion Reports, Hyperion Analyzer are extensively used to generate these reports. With the help of these Hyperion products, Sales are deployed online and managers can see the numbers on a daily basis. Almost 320 different types of reports are recreated in one single report with the help of Essbase cubes. The IT department of Johnson Controls was in need of Calculation Scripts which would allocate Plan, Actual and Forecast data values to various SBU’s.
Roles & Responsibilities:
· Made changes in the database outline of the CONSOL application to accommodate the working of the Allocation Calc Scripts.
· Designed and developed a new Calculation script to copy all the allocation driver data from Plan->Version1 to Plan->ALLOC_VERSION and then transferring these data values to the new created substitution variables &AllcScenario->&AllcVersion thus easing the maintenance of the allocation Calc Scripts.
· Designed and created new server substitution variables thereby narrowing down the management of a single calc script for both Plan and Actual Scenario Dimension.
· Used Essbase functions such as @MDALLOCATE and @DESCENDENTS in creating these calc scripts.
· Created and made changes to the existing MaxL scripts and scheduled the batch script to automate the running of the new Calc Scripts.
· Used Excel Spreadsheet Add-in to test the working of the Allocation Calc Scripts.
· Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, Executive Viewer, and Hyperion Reports.
· Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members.
· Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server.
Technology/Platform: Hyperion Essbase 6.54.2, Hyperion XTD, MaxL, Essbase Spreadsheet Add-In, Windows NT, DOS
 |
| Hyperion Essbase Sample Resume |
=========================================================================
hyperion essbase sample resume - 2
Project Summary: Bank of America is one of the world's leading financial services companies growing rapidly with new acquisitions, providing financial services to individuals, small businesses and corporate clients. At Bank of America, I worked on projects Hoshin Kanri, Funds Transfer and Pricing (FTP) and Customer Level Profitability Reporting (CLPR). As part of these projects, I had to analyze the existing data models, provide alternative solutions, develop HLD’s/LLD’s and test plans and set up development environment and test environment. These projects involved development of reports in Hyperion Intelligence and Hyperion Reports and co-ordinate near shore-off shore activities.
Roles & Responsibilities:
· Installed and configured Hyperion Intelligence Designer and Hyperion Intelligence Architect.
· Installed and configured Hyperion Reports and Essbase run time clients on Windows XP upgrade the software with the newest releases.
· Was responsible for the development of reports and dashboards using Hyperion Intelligence and Hyperion Reports.
· Designed and developed various types of reports (Pivot, Tabular, Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
· Analyze the requirements and data model and come up with a working model and provide alternative solutions.
· Develop HLDs/LLDs and test plans.
· Set up the development and test environments.
· Grant access privileges to users and user-groups as part of security needs.
· Develop Dashboards providing extensive functionality.
· Develop Java scripts to provide functionality to various dashboard objects and also modify local result sets.
· Worked on Report layouts and Report formatting.
· Worked on stored procedures and local result sets to retrieve the required data efficiently.
· Build queries to transform user requests to result sets.
· Develop and test reports in Hyperion Reports.
· Perform administrative tasks on the repository.
· Was the onsite lead and had to co-ordinate near-shore and off-shore activities.
Environment: Hyperion Intelligence 8.3, Hyperion Reports 7.2.1, Hyperion Essbase 7.1, Excel Add-In, MS Project, SQL server, Teradata, Windows XP.
Client: Regions Bank, Birmingham, AL
Role: Hyperion Intelligence Developer/Analyst Dec 2004 – Dec 2005
Project Summary: This project was carried out as part of the Hyperion development and maintenance at Regions Bank Birmingham. The project involved development of reports highlighting the financial results of various businesses at the bank. These financial reports give a snapshot of the various businesses enabling the managers and decision makers to analyze the business trends. Hyperion Performance Suite was used to develop the reports. Extensive Dashboards were built providing easy access to the managers and executives to various reports.
Roles & Responsibilities:
· Installed and configured various components of Hyperion Performance Suite on windows server and was responsible for the development of reports and dashboards using Hyperion Intelligence.
· Hands-on experience on the various facets of the Hyperion Performance Suite.
· Created an OCE connection to connect to the Oracle database.
· Publish reports to the Foundation and give access privileges to various user groups.
· Apply various Filters for efficient and accurate retrieval of required data.
· Integrated SQR with front-end user interface tools and spreadsheets and tuned programs for optimum performance.
· Analyzed financial results and prepared trend reports to support business managers make profitable decisions using Hyperion SQR Developer and Hyperion SQR Viewer.
· Using functionality of Hyperion Intelligence and SQR, created a personalized dashboard, developed personalized report query and performed analysis.
· Designed and developed various types of reports (Pivot, Tabular, Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
· Performed migration of reports from previous versions to the current version of Hyperion Intelligence.
· Created and managed BQY job schedule, created and managed time events using Hyperion Performance Suite.
· Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reports in Hyperion SQR and Hyperion Intelligence by working with the business managers.
· Used Hyperion Analyzer to develop reports to outlines the quarterly region wise financial results.
· Used Hyperion Intelligence Clients to facilitate intelligent querying of multiple databases and analytical reporting across the extended enterprise, quickly and intuitively.
Environment: Hyperion Essbase 7.1/6.5, Hyperion Intelligence 8.0, Brio SQR, Hyperion Performance Suite 8.x, Hyperion Analyzer 7.0, Excel Add-In, MS Project, Oracle, Windows 2003/2000
Client: Benchmark Medical, Inc., Philadelphia, PA
Role: Hyperion Intelligence/Essbase Developer May 2004 – Nov 2004
Project Summary: Benchmark is one of the Nation’s leading providers in the musculoskeletal outpatient rehabilitation industry, with over 350 points of service in 19 states. Benchmark has service lines which include outpatient therapy, orthotics and prosthetics, and industrial rehabilitation. The project involved building a cube, putting the processes for automation and designing and generating reports and dashboards for helping the management with the financial reports and decision making.
Roles & Responsibilities:
· Was involved in the installation, configuration, and administration of the Hyperion/Brio Performance Suite product packages such as Designer, Explorer, Insight Server, Intelligence iServer, Reports iServer, Brio SQR.
· Did reporting, charting and spotlighting using Dashboards.
· Developed SQR code to create tabular, non-tabular, master/detail system independent portable reports along with graphs and charts to present data in visual terms.
· Models were used to analyze many business issues and to integrate the strategic planning processes. Developed user friendly reports and graphs self contained in financial models.
· Extensively worked with Hyperion SQR, Hyperion Reports and Hyperion Analyzer to generate financial reports from different Multi-Dimension Databases.
· Extensively involved in the financial planning model calculations i.e. (Profit, Forecast, Marginal Profit, Elimination, Consolidation, and Headcount) using Hyperion Business Rules.
· Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends and Expense Variances over prior periods using Hyperion SQR Developer.
· Optimized the applications to bring down calc runtime and database size considerably.
· Designed and implemented batch scripts for loading data from the financial system’s database to Essbase cube through data files and rule files.
· Designed users input capability to the applications maintained by Filters.
Environment: Hyperion Intelligence 8.1, Essbase 6.5, Hyperion Planning 3.3 Hyperion Application Link, Hyperion Essbase Integration Services 6.5, Hyperion SQR 8.3, Hyperion Analyzer 6.5, Essbase Spreadsheet Add-in, SQL Scripting, MS Access, MS-SQL Server, Windows 2000/NT
Client: Dun & Bradstreet (D&B), Parsippany, NJ
Role: Hyperion Intelligence/Essbase Developer Aug 2003 – Apr 2004
Dun & Brad Street has a range of solutions to help you integrate data from different sources, automate credit decisions and analyze the risks in your portfolio. Risk Management Solutions; helps customers manage credit exposure and cash. Sales & Marketing Solutions; helps customers find profitable clients and grow. Supply Management Solutions; help customers manage suppliers effectively and save. E-Business; help customers convert prospects to clients faster. Existing Essbase application Market Bridge Demo was build by a third party, which had no support.
Roles & Responsibilities:
· Involved in the installation of Hyperion Performance Suite products.
· Used BRIO SQR extensively for creating custom designed reports for accessing, manipulating and reporting enterprise data from relational databases.
· Using combined functionality of Hyperion/BRIO Intelligence and SQR, created a personalized dashboard.
· Developed users and groups in Hyperion Analyzer and assigned users to different groups.
· Involved in system installation, configuration, and software upgrades from Essbase version 6.0 to 6.5.
· Involved in defining requirements, functional specifications, designing documentations and testing strategies.
· Created Essbase outlines formulas and Calc Scripts using advanced Calc Script functions.
· Extracted the Source Systems Data from the distributed environment, transformed and loaded into the data warehouse database and then populated into Essbase Cube.
· Provided 24/7 Essbase technical support to all business units, offered suggestions and proposed solutions to resolve issues.
· Planning and coding complex reports developed in Excel using Visual Basic for Applications and the EssBase API.
· Developed Excel Templates for user interface in Essbase database.
Environment: Brio Intelligence 6, Hyperion Essbase 6.5.4.2/6.0, Hyperion Analyzer, Essbase Excel-Add-in, MS Access, Oracle 8.x, Windows 2000/NT 4.0, DB2.
Client: United Health Group, Minneapolis, MN
Role: Hyperion Essbase Developer Nov 2002 – Jul 2003
Project Summary: United Health Group is a group of companies, which include United Health Care, Ovations Uniprise, Specialized Care Services, Ingenix and various other business segments. Each of these different segments provides various products and services across the nation. The aim of the project was to provide the top management and end users, a fully functional data warehouse for each of the business segments separately and as per the user requirements. Development of various cubes, developing calc scripts, developing load rules forecast and budgeting for the next 24 months, combining various cubes, SQL performance tuning, optimization of calc time, were few of the performed tasks.
Roles & Responsibilities:
· Installed and set up the server with Hyperion Essbase and Hyperion Reports.
· Improved data loading and database calculation by modifying the Essbase configuration file settings.
· Developed a multi-dimensional database (MDDB) application using EssBase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Load Rules files.
· Create system models, specifications, diagrams, charts, and document system operational procedures to enhance support functions.
· Developed Calc scripts using the Calc script editor for performing calculations.
· Developed and maintained Rule files, Calc Scripts, and Esscmd Scripts.
· Automated Essbase Cubes through Batch Scripts using Esscmd.
· Optimization and performance tuning for Data Loads/Calculations.
· Maintained cubes and took regular backup.
· Provided technical guidance and support to end-users by developing documentations.
· Involved in weekly meetings to discuss current project status.
Environment: Hyperion Essbase 6.5/6.0, Hyperion Analyzer, Hyperion Reports 2.6, Essbase Spreadsheet Add-in, MS SQL Server 7.0, Windows NT 4.0
Client: Electronics Corporation of India Limited, Hyderabad, India
Role: Technical Officer Dec 2000 – Oct 2002
Project Scope: V5.2-COT is a central office terminal (COT) that interconnects Local Exchange (LE) on one side through V5.1/V5.2 interface and RT-480 through STM-1/4 interface on the other side. A maximum of 16 E1 interfaces can be connected on the LE side and a maximum of 63 E1 interfaces can be connected on the Remote Terminal (RT) side, supporting a maximum of 1890 subscribers and provides facilities such as the POTS and the ISDN. The V5.2-COT uses the concept of Fiber in Local Loop (FLL) and is one of the improvements in the access network area of telecom operations.
Roles & Responsibilities:
· Did porting of Network Layer of the V5.2 stack to integrate the V5.2 stack with the application software.
· Designed and developed Protocol Conversion Module which receives PSTN and ISDN message packets from LE and converts them to RT-proprietary protocol and vice versa.
· Designed and developed Inter Processor Module which exchanges data received on serial port between the OSI card and the control PC.
· Designed and developed OSI device driver for the OSI interface card for both the ISA based card as well as PCI based card.
· Made extensive use of IPC mechanism for message transfer and worked on TCP and UDP sockets.
· Coordinated the system integration and environmental testing.
Environment: C++, C, IPC, Sockets, Windows’98, Red Hat Linux 7.2.
Nice tutorial. The Hyperion Essbase tutorial was help ful for me. Keep Sharing Tutorials.
ReplyDelete