• Over 7+ years of IT experience with 6+ years’ experience as a Hyperion Consultant, extensive h...
• Over 7+ years of IT experience with 6+ years’ experience as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software system design and implementation • Extensive experience in the development, design, analysis, and implementation of various applications using Hyperion Essbase 220.127.116.11/18.104.22.168/9.x/7.x, Hyperion Planning, Hyperion Reports, Hyperion Application Link (HAL), and Solution Architecture with Planning. • Adept in dynamically building dimensions, attributes, and shared members using the rules files in an Essbase Outline by means of several build methods such as generation, level, and parent/child references. • Strong knowledge of data loading using the rules files or free form, and debugging a load data. • Developed numerous cubes from conceptual stage, designed OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions. • Expertise in dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel and loaded data from various database to cubes. • Extensive experience on the installation and configuration of Hyperion products such as Essbase, Essbase integration services, analyzer and reports on both Windows and UNIX environments, experience in Essbase integration server and cube analysis, performed database backups. • Experienced in creating, maintaining and supporting financial application using system 9 BI+. • Extensive experience in creating Hyperion Reports using Financial Reporting, Web Analysis and Smart View against relational database and multidimensional database. • Involved in writing Essbase Calculations Scripts, and automated the Essbase Cubes using MaxL and Batch Scripts. • Built interfaces and packages to load metadata and data into Hyperion Planning Applications using Oracle Data Integrator (ODI) and Essbase Studio from external source systems. • Skilled in Automation, Optimization, and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment. • Hands-on expertise creating reports using Essbase Excel Add-In and Hyperion Reports. • Possess a broad understanding of database calculations such as implementing formulas on dimension members, order of calculations in terms of dense and sparse dimensions, dynamic calculations, and developing calculation scripts. • Created and managed Meta Data Management (MDM) in databases, with Hyperion Planning. • Able to effectively apply PL/SQL knowledge to retrieve, manipulate, and control data by creating efficient queries, functions, procedures, packages, and triggers. • Proficient in Data Modeling Techniques using Star Schema, Snowflake Schema, Fact and Dimension tables, RDBMS, and Physical and Logical data modeling for Data Warehousing and Data Mart. • Worked with multiple Hyperion Products such as Oracle EPM Essbase System 11, Oracle EPM Hyperion Planning System 11, Hyperion Essbase System 9, and Essbase 7.X. • Deep understanding of multidimensional data analysis, modeling and schema optimizations. • Extensive work experience in building and modifying financial reports and web analysis. Closely worked on Financial, Budgeting and Forecasting application with Hyperion Essbase and Planning. • Designed and developed numerous Essbase applications and databases cubes structure, with ASO & BSO techniques, and dense and sparse dimensionalities. • Working experience in maintaining Hyperion Planning and Essbase applications including the metadata, web forms, smart list, task list user variables, excel add-in, smart view, user based security and business rules. • Developed numerous Essbase multi-dimensional database (MDDB) cubes and various OLAP application models using Hyperion Essbase 7.x and 9.xBI+ and 22.214.171.124 • Good understanding of Object Oriented Analysis and Design (OOAD), Joint Application Development (JAD) and Software Development Life Cycle (SDLC). • Managed and administered the use of numerous Essbase applications and cubes (both block storage and aggregate storage), forms, reports, and books. • Extensive experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension builds and data loads, transparent partitions, and security objects through both Essbase Administration Services (EAS) and MaxL scripts. Also involved in automation of these procedures using batch scripts • Skilled in performance monitoring, tuning, and optimization and have played an active role in debugging procedures by developing and implementing test cases. • Involved in HFM application development and possess high level understanding of HFM product and have broader understanding of General Ledger accounting system and their financial reporting requirements per GAAP. • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies. Key Skills and Knowledge: • OLAP Tools: Hyperion Essbase 11.x/9.x/7.x, Excel Add-In, Essbase Integration Services ESSCMD, MaxL, Essbase Administration Services, Hyperion Planning, Hyperion Performance Suite. • Reporting Tools: Hyperion Analyzer/Web Analyzer, Hyperion Interactive Reporting, Hyperion Financial Reporting. • Dimensional Modeling: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimensions Tables, Physical and Logical data modeling. • Internet Technologies: ASP, HTML, MS FrontPage, Dream Weaver, Macromedia Flash, DHTML • Languages: PL/SQL, C, C++, HTML, DHTML, XML. • Databases: Essbase system 9, Oracle 10g/9i, MS SQL Server 2000/7.0/6.5, DB2. • Operating Systems: MS Windows NT 4.0/XP/2000/98/95, UNIX AIX, Sun Solaris Sparc 10.
* Click the button to send an offerSend offer