SUMMARY

• Over 8 years of comprehensive experience in IT including 5+ years of experience in efficient, dynamic, result-oriented, design & development of OLAP and decision support systems with focus on Oracle Hyperion Suite of Technology.
• Proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, Smart View and Excel Add-In.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase.
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Proficiency in maintaining Essbase, Managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, attributes, Essbase Cache settings, optimizing calculations and reports.
• Experience in creation and maintenance of finance, ledger, planning, and reporting cubes across BSO and ASO.
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications.
• Expertise in administrative tasks of Essbase: Managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, Business Rules, MaxL, MDX Querying, Report Scripting, User security and Performance tuning.
• Experience and expertise in managing and administering numerous Essbase applications, cubes (Block Storage and Aggregate Storage) and reports.
• Applied in-depth understanding of STAR and SNOWFLAKE SCHEMA modeling techniques to develop optimized OLAP models.
• Substantial experience in creating, maintaining, and supporting all application objects including outlines, Calculation scripts, Business rules, rules files for dimension building and data loading, security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Knowledge and experience in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Thorough understanding of multidimensional architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Extensive experience with migrations of Essbase cubes from BSO to ASO and from development to production.
• Experience in upgrading of Essbase cubes from version 6x to 7x and from 9x to 11x.
• Knowledge on using Oracle Data Integrator (ODI) and Financial Data Quality Management (FDM)
• Proficient in Hyperion Essbase Application Manager modules; Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor.
• Assisted end-users with developing complex reports using Essbase to meet analytical requirements and effective forecasting.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes.
• Strong problem-solving, communication, interpersonal, training, and presentation skills.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL EXPERTISE

OLAP: Hyperion Essbase System 11.1.1.3/ 9.3.1/7.1.6/6.5.4.2
Reporting Tools: Hyperion Financial Reporting 11x, 9.3, Smart View, Excel Add In, Visual Explorer.
Languages: MDX, MaxL, Calculation Script, XML
Databases: Essbase, Oracle 10g, MS SQL Server 2008, 2005, 2000
Operating System: Windows 2000/XP/NT 4.0/98
MS Office Tools: MS Word, Excel, PowerPoint and Visio

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA
Oracle Hyperion Developer/Analyst Jun 2011 – Current

Responsibilities:

• Involved in discussions with business users to derive requirements. Held design sessions and created functional and technical design documents using Microsoft Visio and Power Point.
• Involved in design and development of ASO and BSO cubes to support Planning, Forecasting and Reporting.
• Key involvement in editing Calc Scripts, developing MaxL scripts for automation, MDX for advanced queries. Worked extensively on data loads, load rules, Calc scripts and UDAs.
• Responsible for the design, development, enhancement, and maintenance of the various BSO cubes used for forecasting and strategic decision-making.
• Involved in development, performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations and changing buffer size.
• Troubles shooting critical issues in timely manner to- ensure the SLAs (Service level agreement) are met.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Responsible for security provisioning using shared services across the entire Hyperion environment.
• On time completion of all assigned tasks and meeting the business expectations and timelines.
• Involved in Knowledge transfer and development transition to the other team members and to production team.
• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, testing, rollout into production environment, implementation and end-user training.
• Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Worked Extensively on Shared Services, Essbase applications 11.1.1.3. Performed weekly, monthly, and quarterly data loads and verifications.
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly budget data.
• Responsible for month-end tie-out and provide related support to financial controllers.

Environment: Essbase Administration Services 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Shared Services 11.1.1.3, Hyperion WorkSpace, MAXL, MDX, HFR, Smart View, Essbase Excel Add-In, Microsoft Word and Power Point.

Confidential, Newark, NJ
Oracle Hyperion Consultant Feb 2010– May 2011

Responsibilities:

• Conducted several What-if analyses using MS Excel, ran advanced MDX queries using MaxL.
• Developed Load Rules, for data load in to Essbase OLAP server using Essbase Application Manager.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Involved in development of rules files – for performing operations on records, fields, data, dimension building.
• Applied Intelligent Calculation – for calc scripts, partial calculations, calculating data blocks, turned OFF Intelligent Calculation where it was not necessary and affected performance.
• Applied HFM to create Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Optimized and tuned Database outline to increase retrieval speed of Hyperion Essbase BSO cube.
• Created Database backup for Hyperion OLAP Server.
• Performed Essbase Calc script tuning and debugging as well as enhancements.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Validated all the databases for data using standard Excel retrievals and Essbase reports.
• Acted as the technical lead for Hyperion Essbase related issues including providing technical support for users and supervisors.
• Optimization of BSO cubes: Custom setting type of compression, data cache, calculator cache settings, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size.
• Optimized several databases based on business needs and user interaction, to improve calc script run times and retrieval times. This includes optimizing outlines, dimension orders, member storage type, etc.
• Responsible for migration of cubes from version 9.3.1 to 11.1.1.3.
• Involved and interacted regularly with the finance, IT, business users and other application administrators.
• Worked on month-end procedures on Essbase cubes for Expense, Budget, Metrics, etc. related tasks and reporting.
• Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.

Environment: Hyperion Essbase 11.1.1.3,9.3.1, Hyperion Financial Reporting 11.1.1.3,9.3.1, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, SQL Server 2008, Windows NT/2003,.

Confidential, Dallas, TX
Oracle Hyperion Developer Jan 2008 – Dec 2009

Responsibilities:

• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed batch scripts and rules files to upload dimensions and data to Essbase cubes.
• Optimized Data Loads and Calc Scripts by applying various techniques.
• Involved in developing web forms applications, Assigning Security, Workflow procedures and developed several Essbase Planning applications which suit the business and for best performance.
• Analyzed, designed and optimized the load rules to improve the Dynamic database updates and to optimize the Essbase database cubes performing the calculation scripts in order to calculate the data present in the Essbase cubes, Smart view, Forecasting and to calculate Dynamic Time Series data.
• Developed MaxL scripts to automate daily backup and consolidations of monthly data.
• Created MaxL scripts to update outlines in batch, load data and execute calc scripts, during maintenance.
• Technical support for existing cubes, problem identification, resolution and documentation.
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Developed reports using Hyperion Financial Reporting.
• Involved in administrative activities such as setting up users, security groups and access filters to set the security policy and to ensure maximum security.
  

Environment: Hyperion Essbase 9.x, Hyperion Planning 9.x, Hyperion Financial reporting9.x, Hyperion Application Link, MS Excel Add-in.

Confidential, Dubai, UAE
Hyperion Developer/Analyst Nov 2006 – Oct 2007

Responsibilities:

• Involved in implementation, migration and validation for Hyperion Essbase upgrade from V6.5.4.2 to V7.1.6.
• 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 business knowledge.
• Assess new Business needs, initiatives and translate them into detailed business requirements specifications.
• Worked closely with IT and finance teams to resolve issues, upgrade, develop, test, and implement financial systems.
• Develop, derive, clarify and review functional specifications and User cases.
• Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase cubes.
• Developed Batch and Rules files to load data from financial system’s database to Essbase cube. Created and scheduled batch jobs for complete automation processes for nights and weekends application backup.
• Responsible for functions such as users/groups creation, security profiles and application access to different groups.
• Developed Calc scripts and optimized it according to the Essbase outline.
• Developed Aggregate Storage Cubes (A.S.O). Optimized applications to bring down runtime and database size considerably.
• Modified the existing outline according to the requirements for Hyperion Planning application.
• Hyperion planning 3.5.1 release was used to create new web forms. The same was used to define business rules.
• Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process.
• Involved in unit test plans / system test plans, UAT plans, quality assurance test plans and test strategies.

Environment:, Hyperion Essbase 7.1.6, 6.5.4.2, Hyperion Planning 3.5.1, Hyperion Reports7.0, Hyperion Administration Services, ESSCMD, MAXL, Excel Add-In, MS Project, Windows NT/2000, Visio 2003.

Confidential, Dubai, UAE
Software Developer/Support Jan 2006 to Sep 2006

Responsibilities:

• Interacting with the client to understand the project and finalize its scope.
• Estimation, design and development of various modules.
• Onsite visit to client’s location to solve technical issues.
• Bug fixing and maintenance of the project and product.
• Coordinating with other teams working on the same project
• Coordinating with the testing team regarding fixing bugs.
• Involved in pre-sales activity such as product demo, prototyping etc.

Environment: Visual Basic 6, Crystal reports 8, MS SQL 2000, Windows Server 2000

Confidential, Chennai, India
Software Developer Feb 2004 - Dec 2005

Responsibilities:

• Developed, tested and deployed custom applications based on the requirements from new and existing clients.
• Involved in implementation and customization of the financial accounting and payroll software as per the client’s requirements.
• Held responsibility for onsite support for multiple projects.
• Transmitted the accomplished works to the customers on time.
• Provided assistance to the technical support staff, as per the requirements.
• Performed hardware and software installations and upgrades.
• Maintained a good rapport with the all employees and provided excellent service to the customers.

Environment: Visual Basic 6, MS SQL 2000, Crystal reports 8, Windows Server 2000

EDUCATION

Master of Computer Applications (MCA)
Bachelor of Commerce (B.com)