| Summary: | • Over seven (8+) years of diverse experience in Information Technology with emphasis on Data warehousing OLAP tools and BI.
• Over seven (8+) 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, Essbase Integration Services, Hyperion Workspace, Hyperion Reports, Hyperion web Analyzer, Essbase Spread Sheet Add-in/Smart-view, Essbase Query designer under Windows and Unix environments.
• Over 5+ years of Proficiency and experience in a range of Hyperion products including Essbase, Hyperion Financial Management, Hyperion Planning, Web Analysis, Integration Services, Smart view and Spreadsheet Add-In, in both Windows and UNIX environments.
• Expertise in administrative tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, MDX Querying, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework.
• Experience in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).
• Proven track record of successful implementation of all project lifecycle stages from requirements gathering implementation and enhancements.
• Installation, Configuration, Troubleshooting and application demo presentation of Hyperion 9 & 11 on Windows and Linux version to clients.
• Experienced Hyperion System 11 and 9.3.0 modules (Hyperion System 9+Analytic Services, Hyperion System 9 planning, Interactive Reporting, Financial Reporting, Production Reporting and Dashboards).
• Published BQY in Hyperion Workspace and grant the access of the reports to the user in Workspace.
• Extensive knowledge in Hyperion Business Rules (HBR), Hyperion Application Link (HAL), Essbase Calculation Scripts, Essbase commands and Essbase functions.
• Served as a Senior Oracle Data Integrator (ODI) Developer in the development of the company's budget, forecast, and capital planning reporting system in order to improve the cycle time of the current planning process.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Using the Oracle Data Integrator 10g (ODI) to update the Hyperion Planning and several Hyperion Essbase 11 applications including updates to meta data for various dimensions and loading of raw data.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Used VBA for the creation of a reporting system that cranks out hundreds of pages of reports that gets published to the web or file share.
• Used VBA for the creation of a template system where the field actually inputs data into an excel workbook that then sends the numbers to Essbase and initiates a calc script via VBA automations resulting in consolidated financials.
• Used VBA for the creation of controlled templates to send out to the field for data entry.
• Used VBA as a very powerful spreadsheet toolkit for automating Essbase/Excel retrieval task.
• Involved in Database portioning and handled user accounts creation and security assignment functions.
• Created OLAP Models and Meta Outlines using Essbase Integration Services (EIS) to populate database.
• Performed dense/sparse setting, Optimization of Data Load, and Optimization of Calculation Scripts Business rules.
• Expert level knowledge and understanding of ESSCMD and MAXL scripts used for automation and partitioning.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing, and migration from development to production.
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables.
• Excellent communication and interpersonal skills and outstanding team player with an aptitude to learn.
Environment: Hyperion Essbase 7.1.3, Hyperion Essbase 11.1.2.1, Hyperion Workspace system 11, Essbase Shared Service 11, Oracle Data Integrator (ODI), Hyperion Planning 7, Hyperion Reports 7, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Windows NT/2003,Unix / AIX Shell scripts.
Environment: Hyperion Planning system 11 and 9.3, Oracle Data Integrator (ODI), Hyperion Shared Services 9.3, Hyperion Workspace system 11 and 9,Essbase 11 and 9.3, HAL 9.3, Hyperion Interactive Reporting Studio 9.3, Hyperion Financial Management(HFM), Essbase Excel Add-in 7.X, Oracle 11g/10g, Ms Excel 2003/2007, Windows XP. |
No comments:
Post a Comment