Sr Hyperion developer/admin
Resume:
Rinku Shah 614-***-****
Sr. Hyperion Consultant ***********@*****.***
SUMMARY OF QUALIFICATIONS:
• over 5 + years experience as a Hyperion consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems Administration, design and implementation.
• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 9 ,Hyperion Essbase 7.X/6.X, Essbase Integration Services, Hyperion Analyzer, Hyperion Reports, Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Performance Suite, BRIO, and Essbase Spreadsheet Add-In on Windows 2000/NT and Unix environments.
• Heavy expertise in developing Hyperion Interactive Reporting , and BRIO Reports using Brio Designer/Explorer and translating functional requirements into technical specifications.
• Installed and setup Hyperion SQR Server for DDO to establish its connection with the Essbase Server to generate various financial reports.
• Commendable knowledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Designed and developed numerous cubes from conceptual stage, Essbase MDDB applications, OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions.
• Worked on financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and in building Financial Budgeting and Forecasting OLAP applications.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.
TECHNICAL SKILLS
OLAP Tools: Hyperion System 11/9,HFM,Hyperion Enterprise, Hyperion Essbase 9.x/7.x/6.x, Excel Add-In, Essbase Integration Services 7.1 / 6.x, ESSCMD, MaxL, Essbase Administration Services, Hyperion Planning, Hyperion Performance Suite 8.3.
Business Intelligence Tools: Hyperion Planning 11.x/9.x/4.x/3.x, H.A.L, FDM,DRM
Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP
Languages: SQL, PL/SQL, C, C++, HTML, DHTML, XML
Databases: Essbase, Oracle 8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5, MS Access 2000, DB2, Sybase.
Internet Technologies: ASP, Java Script, HTML, MS FrontPage, Dream Weaver, Macromedia Flash, DHTML and VB Script
GUI: Visual Basic 6.0/5.0, SAP GUI
Reporting Tools: Hyperion Analyzer 7.0, Hyperion Reports 7.0, Brio 6.5,SQR and Micro Strategy 8.2
Dimensional Modeling: Star-Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling, Erwin 4.0.
Professional Experience:
Hyperion developer /admin Nov 10 – Till date
JP Morgan Chase
JPMorgan Chase & Co. (NYSE: JPM) is an American global securities, investment banking and retail banking firm.
Project – Hyperion essbase migration 7.x to 11.x
Roles-
• Designed and supported the complete architecture, installation and configuration of the entire Hyperion system
• Held accountability for system maintenance, supporting and monitoring, capacity planning, resource management, evaluating and implementing upgrades and patches, performance tuning as well as security maintenance.
• Worked closely with business stakeholders to correctly identify their requirements and ensured the design satisfies the requirements.
• Created projects and interfaces to load metadata and data into the Hyperion Planning applications using both Planning and Essbase Knowledge Modules (KMs) in Oracle Data Integrator (ODI)
• Streamlined data movements/interfaces across different plan types and applications using XREFs and DATAEXPORT options
• Created and maintained interfaces to move data into and out of Hyperion cubes
• Built complex Business Rules, fine tuned them and attached to web forms
• Tuned and optimized Essbase outlines and cubes by setting the correct order of dimensions, dense sparse settings and compression method
• Created the existing Budget Book reports using Financial Reporting Studio and Web Analysis
• Created various Dashboards enabling a high-level view of performance success for the business units using Hyperion Web Analysis.
• Investigated the latest version of Oracle Essbase 11.1.1 and Essbase Studio
• Prepared training material and well designed documents covering both the functional and technical aspects of the project
SR.Hyperion Developer ( Plannig,HFM,ESSBASE) Aug 09- sep 10
PNM resources , Public Service Company of New Mexico (PNM ) New Maxico,
PNM resources is an energy holding company based in the U.S. state of New Mexico. The acronym PNM by itself usually refers to the PNM Resources subsidiary Public Service Company of New Mexico (described below). Headquartered in Albuquerque, PNM Resources supplies electricity to 725,000 homes and businesses in New Mexico and Texas and natural gas to 471,000 customers in New Mexico through its utility and energy service subsidiaries.
Usage of Hyperion Planning/Hyperion Essbase
• Designed and supported the complete architecture, installation and configuration of the entire Hyperion system
• Created the existing Budget Book reports using Financial Reporting Studio and Web Analysis
• Created various Dashboards enabling a high-level view of performance success for the business units using Hyperion Web Analysis.
• Investigated the latest version of Oracle Essbase 11.1.1 and Essbase Studio
• Prepared training material and well designed documents covering both the functional and technical aspects of the project
• As an Essbase Database Administrator 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 OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Loaded data using Essbase Integration Services (EIS).
• Worked extensively on Web forms and Planning cube development, EIS, DIM and partitioning according to user specifications. Developed OLAP models and meta-outlines using EIS from the Oracle Star schema.
• Develop security authentication for the users of Hyperion Planning and maintaining workflow management process.
• Implemented star schema and used EIS to interface with the company’s existing Oracle 9i data warehouse.
• Migrated Essbase server into newer versions and newer operating systems.
• Create account mapping and intergrade FDM with planning application.
• Build Dimension and data load in Application through FDM.
• Convert Hyperion Enterprise Model In to HFM Model For Detail data Analysis.
• Involve In Full Life Cycle OF Year end Closure In HFM Application .
• Maintain HFM Application User And Design Backup Process
• Write Vb cript For HFM Process.
• Created new DOS batch script to automate the transfer of Data from Data Server to Essbase Server.
• Developed many kinds of reports like tabular report, chart report, cross-tab report using web analysis.
• Provided seamless integration of historical, projected and derived data.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
• Involved in system installation, configuration and software upgrades from Essbase version 6.5 to 7.1.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
Environment: Clarity, Hyperion Essbase System 11/ 9,,Hyperion Reports 7.0, Hyperion Analyzer 6.5, Hyperion Planning 4.1perion Reports 7.0, Hyperion Performance Suite 8.3, Essbase Integration Services 7.1,Microsoft Excel 2000, Oracle 10g,Windows 2000 Advance Server, UNIX,.
Hyperion Admin/Developer/Consultant Jan 2008 – July 2009
UW Physician Seattle,WA
University of Washington Physicians (UWP) is the practice group for more than 1,500 physicians and health-care providers associated with UW Medicine. UW Medicine includes Harborview Medical Center, UW Medical Center, UW Medicine Neighborhood Clinics and the UW School of Medicine
Usage of Hyperion Planning/Hyperion Essbase
• Create new web form called Allocation Drivers to reduce the work load of the user thereby focusing on a single form rather than three different Forms namely Plan, Actual and Forecast.
• Hyperion Planning was used in testing of the new calculation scripts and to define business rules to match the needs of the users
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Design and optimized calc script and business rules for EPMA 11.1.2
• Hyperion Planning was used in testing of the new calculation scripts.
• Hyperion Planning 11.0 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion EPMA 11.0.
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
• Used to write MAXL script, S script, back up and automate monthly and yearly process.
Environment: Clarity, Hyperion Essbase System 11/ 9,HFM 9.x,Hyperion Reports 7.0, Hyperion Analyzer 6.5, Hyperion Planning 3.5.1, HFM, Hyperion Reports 7.0, Hyperion Performance Suite 8.3,SQR, Essbase Integration Services 7.1,BRIO 6.5, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server, UNIX.
Hyperion Admin/Developer/Administrator april2008-Dec 2008
DTCC,NYC ,NY
Revised and restructured the clients’ Essbase reporting cube to incorporate new bonus reporting activities associated with product initiatives at their 25 Product. Upon completion of database redesign, built and verified the content for 68 new Hyperion Reports.
Roles & Responsibilities:
• As an Essbase Database Administrator 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 OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Loaded data using Essbase Integration Services (EIS).
• Worked extensively on Web forms and Planning cube development, EIS, DIM and partitioning according to user specifications. Developed OLAP models and meta-outlines using EIS from the Oracle Star schema.
• Hyperion planning 9.3 release was used to create new web forms. The same was used to define business rules.
• Develop security authentication for the users of Hyperion Planning and maintaining workflow management process.
• Implemented star schema and used EIS to interface with the company’s existing Oracle 9i data warehouse.
• Migrated Essbase server into newer versions and newer operating systems.
• Convert Hyperion Enterprise Model In to HFM Model For Detail data Analysis.
Environment: Hyperion Essbase 7.0/6.5.1, Hyperion Planning, Hyperion Reports 7.0/ 6.5, BRIO, Hyperion Analyzer, MS-Excel 2000 Spreadsheet Add-In, Oracle 9i, Windows NT 4.0
Essbase Developer Mar 2007–march2008
Kaiser permanate,Pasadena ca
The database contained information about all the Customer Information, departments, regions, product information, billing information, etc. The main objective of this project is to develop a reporting system and scheduling of the Reports generation for the whole year, month, weekly and daily as per the requirement of the users and also maintenance of two projects developed on various platforms. The reporting tools for the generation of the reports are Brio Reports
.
Roles & Responsibilities:
• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
• Translated end user requirements into application design specifications
• Assured optimal match between cube design and report specifications
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing/validating scripts
• Developed OLAP models and meta-outlines designed through Essbase Integration Services
• Managed system upgrades and client installations based on users’ requirements
• Migrated database from version 6.2 to 6.5
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users
• Documented and issued procedures pertaining to Essbase applications
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage
• Involved in checking the status and progress of each planning unit so as to analyze variances in real time, revise, promote, reject and approve plans.
Environment: Hyperion Essbase 6.2/6.5, EAS 6.5.1, Excel Spreadsheet Add-In, EIS 6.5, Hyperion Analyzer 6.5, Hyperion Planning 3.3, Hyperion Reports, Windows 2000
Cognizant tech solution, India Mar2004 – july 2005
Jr. System Administrator
•
Role & Responsibilities:
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.
• Provided on-call production database support.
• Provided primary database support for application database systems such as Siebel CMS, Documentumn, MapInfo MapXtreme Spatial Application, PowerCurve System, Performance Monitoring Control System, etc.
• Tested and documented some Oracle8I new features, such as duplicate database using RMAN from both disk and tape, setup name server.
• Created materialized views.
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
Environment: Windows 98/2000, Oracle 7.0
EDUCATION:
• Bachelor’s in Mechatronics Engineering
Sardar Patel University, Gujarat , India
• Master in mechanical Engineering
Bridgeport university,CT,USA
REFERENCES: Provided upon request…
Contact this candidate