SUMMARY

• Around 7 years of experience in Implementing Hyperion Essbase and Planning applications and providing 24x7production support.
• Work with clients to integrate various Hyperion software products into an overall business solution dat provides TEMPeffective and efficient business reporting and financial analysis.
• Meet with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques
• Strong noledge on Hyperion 11.1.2.2 and 11.1.2.4 versions.
• Experience in multiplatform Unix and Linux environments, with hands - on expertise in networking, scripting, and systems integration.
• Extensive Hands-On experience Hyperion Essbase Database, Hyperion Planning, Hyperion Financial Reporting, Hyperion Smartview, EPMA, Oracle Data Integrator (ODI), Financial Data Quality Management Enterprise Edition (FDMEE).
• Demonstrable track record of managing delivery of at least over two Hyperion Planning and Budgeting full project lifecycles (me.e. Define, Design, Develop, Deploy).
• Solid noledge and delivery experience for Hyperion Public Sector Planning and budgeting.
• Mentor team members and orchestrate teh efforts of teh project team to map out planned tasks and ensure dat work efforts are optimized .
• Developed Batch Scripts and Rules files for dynamically uploading dimensions and data to Essbase Cubes.
• Develop Rule Files, Outlines, Calc Scripts, and Automation Scripts
• Validate and troubleshoot Hyperion integrations in ODI and FDMEE
• Extensive Hands-On experience in design, Development and tuning Essbase database. Also well versed in Essbase Architecture, building cubes, designing and developing Essbase Applications, Essbase Studio, Optimizations, Report Scripts writing, PartitionsCalculation Scripts, Aggregate Storage Option (ASO), Block Storage Options (BSO), MDX Member calculations, ESSCMD, MAXL for Batch scripting and also familiar with Hyperion FDMEE 11.1.2.4 and noledge of Jython Scripts Essbase APIs.
• Used teh OBIEE add-ins to insert and analyze reports in Word, Excel and PowerPoint.
• Integration of OBIEE Server with Hyperion EPM Server.
• Building OBIEE Dashboards and reports for Hyperion Planning and Essbase Cubes.
• Involved inanalyzing, designing, updating, testing and migrating Essbase Cubes in different environments including performance tuning and optimization of Essbase applications
• Involved in planning application creation, metadata loading through ODI, Outlineload.cmd utility, web forms development, business rules association with forms and security.
• Familiar with Relational Databases, SQL Server and Oracle.
• Involving in programming languages like Jython, Perl, MS SQL and windows script
• Involved in DRM Installation, configuration, DRM process monitoring and work closely with Oracle support team to resolve DRM bugs.
• Hands on BA/QA experience and DW/ETL test experience.
• Ensure all business requirements are being met and/or exceeding expectations
• Translating business problems and opportunities into plans of action including scope and delivery strategy
• Functional noledge of financial statements, budgeting, forecasting, planning and FRreporting processes dat facilitate creation of powerful Hyperion solutions.
• Security using Shared Services to createUsers & giving Provisions and restricting permissions.
• Proficient in Designing and developing Essbase applications with excellent balance ofdense and sparse dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Part of teh campaign for teh end-users to provide noledge on how to work with Webforms, smart views, business rules to analyze teh data or entering teh actual values
• Extensive experience in Essbaseload rules, report scripts, integration tools and overall system architecture.
• Expertise noledge in building partitions and resolving teh calculation issues between teh partitions.
• Troubleshoot issues with both client and server systems, me.e. Smart View clients, connectivity, HFR connections and performance, workspace issues, Web logic/web services issues, FDMEE performance, HFM applications services, and other general users support related to navigating teh client tool.
• Dedicated, Confident individual with strong sense of responsibility, work flexibly and quickly adapt to changing environments professionally and personally.
• Highly experienced in resolving analytical issues, enormous under pressure work capabilities and a good trouble shooter, good inter-person skills and a very friendly in nature.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Planning 11.x/9.x Hyperion Essbase 11.x/9.x/7.x, Essbase Administration Services (EAS), Analytic Integration Services (AIS /EIS), Workspace, Smart View, MS Excel Add-In Essbase query designer, Integration Services, Performance ManagementReporting Tools Web Analysis, Smart View, Hyperion Financial Reporting (FR)

MS Office Tools: MS Office Suite 2013/2010/2003

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, Shell Script.

Data Integration: Hyperion Financial Data Quality Manager, Data Relationship Manager, Oracle Data Integrator

Databases: Oracle 12/11i/10g/9i/8i, MS SQL Server, MS Access.

Operating Systems: Windows NT/2000 /XP/2007/Server 2008/2012, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Hyperion Essbase Support/Developer

Responsibilities:

• Responsible for end to end Production environment support for Essbase & planning applications
• Responsible for teh health and availability of teh PROD environment
• Responsible for meeting SLA’s as per agreement with business for all incidents & change requests
• Ability to clearly articulate messages to a variety of audiences and teh ability to establish and maintain strong relationships
• Business acumen and understanding of organizational issues and challenges with teh ability to advice implement and apply teh right tools/processes to meet these challenges
• Strong noledge on different types of Essbase Applications like ASO/BSO and using them according to requirement and good understanding on performance tuning for teh cube
• Manage substitute variables in Essbase Administration Services (EAS) for each month-end, forecast and annual budget planning cycles
• Manage Hyperion EAS outline and cost center structure
• Provide user technical and business support including ideas and recommendations regarding teh use of systems as well as their further development
• Conduct research and analysis into teh nature, TEMPeffect and results of system problems
• Review and approve requested system changes and develop detailed specifications for implementation
• Experience on Application creation (Classic and EPMA) in Planning, and having good understanding on web forms Smart list, task list
• Very good functional understanding of business and finance viz Budget, Forecast, planning and Data management

Confidential, Hoboken, NJ

Hyperion Developer/Support

Responsibilities:

• Worked with teh Hyperion Suite of products including HFM, DRM, Planning, FDM/FDMEE
• As a part of production support, look after Hyperion applications; make sure teh system is up and running, available for all users.
• Working on daily tickets from users, application Owners on various Hyperion issues, change requests, enhancements.
• Maintained Hyperion Financial Management system and assisted in administration consolidation of monthly financial information.
• Oracle Hyperion Planning to Oracle HFM Integration Management for Rolling Forecasts & Budgets using FDMEE/FDM for All Legal Entities.
• Managing data and metadata load processes and assist teh business with maintaining mappings within FDMEE; periodically updating FDMEE individual user roles
• Implementing HFM & FDM for newly acquired Legal Entities/Subsidiaries and FDM Integrations.
• Testing Financials & Applications Integrations for all Legal Entities in General Ledger, Staging Tables, FDMEE, HFM and Global Financial Data Warehouse (Essbase Cubes) and Design Documentations.
• Providing support for teh Hyperion Financial Systems and users
• Managing Business Rules in Oracle Hyperion Financial Management (HFM) to meet consolidated Financial Reporting Requirements.
• Enhancing and improving Business rule performance.
• Loading exchange rates to various applications on a monthly basis, quarterly basis as per cycle.
• Designing and developing Hyperion Essbase & Planning applications.
• Preparing documentation requirements, for budgeting, planning and forecasting projects, other enhancements and projects, and reports.
• Responsible for creating, documenting, and implementing scalable solution design and implementation plans.
• Implemented full life cycle of Oracle Hyperion products, including Cloud Services (PBCS/EPBCS).
• Developing and maintaining Oracle PBCS applications
• Automating PBCS operations using EPM-Automate
• Developed, Supported and Maintained ETL (Extract, Transform and Load) processes using Oracle Data Integrator (ODI).
• Experienced in provisioning users (Security Manager) and setting up/ manage source and target system connections in ODI.
• Develop building Dimensions, Attributes, Shared Member using Rule Files in an outline by means of several build methods such as Generation, Level and Parent-Child s.
• Involved and interacted regularly with teh finance, IT, business users and other application administrators.

Confidential, Virginia VA

Hyperion Developer/Support

Responsibilities:

• Building and troubleshooting Financial and Smart View Reports
• Working with teh Hyperion Suite of products including HFM, DRM, Planning, FDM/FDMEE
• Building DRM components on a DRM project
• Providing support for teh Hyperion Financial Systems and users
• Conducting system requirement analysis, including documenting current and future state business processes, and analyzing their interaction and inter-dependencies to support process design.
• Assisting in teh design and creation of financial reports based on teh Planning application(s).
• Documenting ODI Installation and Configuration process, Design and Technical documentation for teh developed ETL processes.
• Responsible for establishing, managing and maintaining relationships with customers and users of assigned systems
• Worked on generating Cognos reports for reconciliation process, and tracking and managing cost and effort and report on variances.
• Working as a liaison between teh business/finance and IT/developers sides of teh business.
• Designing and developing Hyperion Planning application including teh Planning model, data forms, business rules, process management, application security, MaxL scripts (if necessary).
• Worked with Jython (.py) and Visual Basic (.vbs) based scripting in order to extend and customize teh solution to best fit for user requirements.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Involved in production support and maintenance of existing (ASO & BSO) cubes. Worked as a team member in Hyperion Essbase & Planning migration activity.
• Setup PBCS environment for new instances, creating planning application and setup reporting cubes.
• Creating reports using Hyperion financial reporting, Financial reporting web (PBCS & EPBCS) and smart view.
• Implementing full life cycle of Oracle Hyperion products, including Cloud Services (PBCS/EPBCS).
• Ensure all business requirements are being met and/or exceeding expectations Initiate and drive post product Go-Live support and sustainment planning activities
• Onshore-Offshore co-ordination
• Proposing enhancements and new solutions. Performing optimization techniques in planning applications.
• Aiding VMware employees and customers to resolve application issues, code bugs and user errors in Hyperion Track
• Providing product post go-live war room support
• Defining and reinforcing standard methods and processes dat eliminate errors and avoid re-work.
• Task allocation and reporting
• Ensure progress, issues and agreements are properly documented and acted upon
• Analyze user requirements, procedures, and problems to automate and improve existing systems.

Confidential, Maryland Heights, MO

Hyperion Consultant

Responsibilities:

• 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.
• Developed accurate budgets and performed and analysis faster with hyperion public sector planning and budgeting.
• Applied HFM to create Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Maintained of Hyperion System like Essbase, Planning or HFM from service perspective.
• Optimized and tuned Database outline to increaseretrieval speedof Hyperion Essbase BSO cube.
• Created Database backup for Hyperion OLAP Server.
• Performed tuning and debuggingas well as enhancements.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Develop building Dimensions, Attributes, Shared Member using Rule Files in an outline by means of several build methods such as Generation, Level and Parent-Child s
• Validated all teh databases for data using standard Excel retrievals and Essbase reports.
• Acted as teh 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 tohourglass modelto has optimum database block size.
• Optimized several databases based on business needs and user interaction, to improve calc script run times and retrieval times. dis includes optimizing outlines, dimension orders, member storage type, etc.
• Involved and interacted regularly with teh finance, IT, business users and other application administrators.

Confidential, Houston

Hyperion Essbase & Planning Consultant

Responsibilities:

• Involved in user requirements, Identifying Dimensions and identifying data sources.
• Worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data.
• Optimizing Aggregate Storage Option and Block Storage Option outline
• Giving source specification required for flat file format.
• Writing Rule file for Dimension building & Data Loading.
• Created reports using Hyperion Financial Reports & Hyperion Web Analysis Studio.
• Creating reports using Hyperion Smart view.
• Designed and developed web forms as per teh business requirements using Hyperion Planning.
• Preparing materials and deliver end user . Prepare UAT/SIT Test Scripts, User cases
• Develop complex financial reports
• Develop Business Rules, Web Forms and maintenance of Metadata using Hyperion Planning
• Extracted data manually from different sources to combine different sources into one business report.
• Performed performance tuning and database optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.
• Developed web forms using Hyperion Planning for teh users to input data.
• Designed Task lists for teh Planning applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.