PROFESSIONAL SUMMARY:

• 7+ years of proficiency and experience in Fusion Cloud Applications and Hyperion products including Essbase, Hyperion Planning, Integration Services, Smart view, and Spreadsheet Add - In in Windows environments.
• 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.
• Experience in working through all phases of Software Development Life Cycle (SDLC) in implementation and maintenance of financial/budgeting applications.
• Maintain interfaces and packages to load metadata and data into Hyperion Planning Applications using Oracle Data Integrator (ODI) from external source systems.
• Developed/Maintained Fusion cloud outbound interfaces using BIP reporting.
• Thorough understanding of multidimensional and relational database architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Expertise in working in Cloud Environments.
• Exceptional skills in Agile and Kanban Methodologies.
• Worked with multiple Hyperion Products such as Oracle EPM Essbase System 11.X, Oracle EPM Hyperion Planning System 11.X, Hyperion Essbase System 11.X, Essbase 11.X, Essbase.
• Installation, configuration and maintenance of Oracle Hyperion DRM.
• Integration of Hyperion DRM with other Enterprise BI Systems.
• Expertise in Hyperion Financial Reporting and Data Relationship Management.
• Experience in handling/delivering support Services engagements including exposure to various AMS process, SLA definition and management.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Technologies: Fusion Financial Cloud Financials, Fusion Financial Cloud HCM, Oracle EPM Applications (Hyperion Public Sector Planning & Budgeting),Fusion Cloud, Oracle Sales Cloud, Oracle Project Portfolio Management(PPM),Oracle E-Business Suite Financials, EPM products, ERP products, PBCS (Planning and Budgeting Cloud Service products), Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS),Hyperion DRM, Hyperion financial Management(HFM)

Databases: Essbase 11/9.3.1, Oracle 8i/9i/11i

Reporting Tools: BIP, Financial Reporting, Hyperion Reports, Hyperion Interactive Reporting, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Smart View, OBIEE, FR Studio, Web Studio, OTBI, Reporting Dashboards and Rtf layouts.

Internet Tools: HTML, XML

Languages: SQL, PL/SQL, C/C++, Shell Scripting

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista/, AIX 5.1/5.3, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, KS

Sr. Fusion/Hyperion Developer

Responsibilities:

• Part of Fusion Cloud Financials Implementation core team at Confidential .
• In-depth knowledge of GL, AP, AR, Procurement, FA, Projects functionalities.
• DevelopedFinancial Reports in GLlike (Income statement, Dept. Expenses, Balance Sheet, Trial Balance, PO, checks, ACH etc.).
• Help users maintain various account hierarchies (Ex: Departments/Accounts/Class) for reporting.
• Supported month-end closing activities and finance team in completing post month-end tasks including preparation of financial statements.
• Fixed production support issues, helped finance team in accounts reconciliation and guided technical team to deliver quality fixes to avoid re-work.
• Coordinating with business user and guiding technical team on custom or standard development requirements.
• Followed up with Oracle Support team on SR to resolve various issues around Fusion Cloud R12 upgrades.
• Involve in training to end users on various areas where such need required.
• Supporting solving Day-to-Day End - User problems.
• Worked on 3 upgrades with Oracle in Financial Cloud since go live.
• Provide recommendations to Oracle for Future Enhancements
• Design and Develop Fusion cloud outbound interfaces as Scheduled BIP reports.

Environment: s: Fusion Financial Cloud Ver9/10/11/12, FR Studio, Web Studio, SmartView, BIP, OTBI, Reporting Dashboards and rtf templates.

Responsibilities:

• Executed yearly interfaces between Hyperion and various other applications within BPU
• Configure Hyperion Planning Application to setup yearly Budgets for Budget preparers.
• Export Hyperion Capital/Non-Capital Budgets to Cloud and Maximo applications.
• Create Ad-hoc reporting in Cloud as well Hyperion as per the User Requests.
• Train end-users on new reporting technologies and BPU reporting standards.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool.
• Prepared templates for achieving ad-hoc reporting and management reporting by working with the business users.
• Maintained Meta data information in Hyperion from Cloud Systems and Peoplesoft.
• Developed Excel Templates for user interface in Essbase database
• Create new Business rules as per user requirements.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Environment: s: Hyperion system 11.2.4, Hyperion Essbase 11.2.4, Microsoft Excel 2010, Essbase Excel-Add in 11.1.2.4, Smart View 11.1.2.4, FR Studio, Web Studio, Report Books, Report Batch jobs.

Confidential, Mellon, NY

Sr. Hyperion Developer

Responsibilities:

• Actively involved in Hyperion Essbase upgrade from 7.x to 11.1.3 and system migration from Windows to LINUX.
• Working on automating the OTL changes from Dev to Prod and vice versa.
• Worked through and created a Technical Specific Document for the migration team and for any future developments.
• Responsible for an Essbase application, providing support to Technology budgeting finance team.
• Involved in reporting and application Enhancements requested from business users.
• Involved in gathering requirements from business users and developing a project plan to work through enhancements.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool.
• Developed Reports for Business as a part of ongoing enhancement process using Excel VB Macro
• Prepared templates for achieving ad-hoc reporting and management reporting by working with the business users.
• Developed Allocation Business Rules using Hyperion Planning and created data entry web forms using Hyperion Planning.
• Created the planning application and Essbase ASO and BSO applications based on the business specifications.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI, DIM.
• Documenting the processes and installation steps for Essbase 11.1.3.
• Created batch jobs to automate the process of restatement as a part of enhancement
• Created multiple Calc scripts and Maxl scripts as to achieve the requested Enhancements and changes from the user end.
• Migrated applications and other artifacts from one environment to another using the Life Cycle Management (LCM) utility and maintained sync of Hyperion applications across environments.
• Setting up users and groups according business department and assigning security to users and groups using Shared Services.
• Developed Excel Templates for user interface in Essbase database
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Environment: s: Hyperion system 7 & 11, Hyperion Essbase 7.x & 11.1.3, Microsoft Excel 2010, Essbase Excel-Add in 7.x & 11.1.2, VB Macro, Windows 2007 OS, Tivoli, Remedy, Clear case, Smart View 11.1.2, Win Scp 5.5.3, PUTTY 0.62.

Confidential, Deerfield, IL

Sr. Hyperion Developer

Responsibilities:

• Involved in system installation, configuration and migration of Hyperion Essbase 11 from one server to a server at different location.
• Involved in gathering requirements from business users and developing a project plan for their Planning Cube.
• Involved in defining requirements, functional specifications, designing documentations and testing for creating forecasting tool
• Created Maxl and Batch scripts to load and update data from Data warehouse
• Maintenance and Support for Essbase Applications.
• Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application
• Defined and documented the steps to migrate applications in the Hyperion Essbase between Prod, QA, and Dev environments.
• Worked with Hyperion Support on a number of issue resolutions.
• Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas.
• Backup and Recovery of Hyperion applications. Scheduling daily backups.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Converted one ASO cube to BSO due to tweaks and changes requested by Business User.
• Monitoring the current Production environment servers for performance and stability.
• Involved in decision making functions for Environment Infrastructure needed while migrating to new server.
• Created the planning application and Essbase ASO and BSO applications based on the business specifications.
• Keeping all the environments in sync.
• Created and migrated ODBC connections within the servers.
• Performed Aggregate and Smoke Test for SQL in Teradata and AS/400.
• Trained and did KT to In-house person before rolling over the applications.
• Troubleshooting the Client install issues.
• Supported and Co-ordinate for VM patching over Informatica and Essbase Production servers.
• Carried out nightly updates for refreshing the cubes
• Documented migration of users and user groups in the standalone environment.
• Administered and knowledge on installation, configuration, and optimization of Hyperion System 11.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Monitor ETL Informatica Jobs and provided On-Call support in Trouble shooting and debugging.
• Worked with Informatica Power Center for running and managing related workflows.
• Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
• Specific role as Essbase Administrator involved Shared Services security development for Essbase.
• Setting up users and groups according business department and assigning security to users and groups using Shared Services.
• Documenting the processes and installation steps for Essbase 11.1.1.3.
• Implemented robust data-access security and user management
• Developed Excel Templates for user interface in Essbase database
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Environment: s: EPM System 11,Hyperion Essbase 11.1.1.3, Essbase Excel Add-in 11.1.1.3/11.1.1.4 , EIS 11.1.1.3, Hyperion Shared Services 11, Microsoft Excel 2007/2010, Microsoft Windows Server 2003 R2, Microsoft Visual Studio 2005, Microsoft SQL Server 2005, Teradata Client 14.0, Teradata SQL Assistant 14.0, AS/400 Client, iSeries Navigator, DB2 query, Informatica 9.1.0 (Power Center Client), Rally, Jira, GIT Hub.

Confidential, Cleveland, OH

Hyperion Developer

Responsibilities:

• Coordinating with technical team, functional team and users in designing the hierarchy for the dimensions to be used in planning application.
• Coordinating with the functional team to understand the Budgeting and Forecasting process
• Implemented Hyperion Planning and developed web-based forms for the various budgeting purposes and implemented whole security matrix in Hyperion Planning.
• Optimized and tuned Database outline to increaseretrieval speedof Hyperion Essbase BSO cube.
• Created Database backup for Hyperion OLAP Server.
• Creating Metadata Load files for Account, Entity and various other dimensions using the Columns present in the Data stores.
• Creating, provisioning, and maintaining user security across all Hyperion modules using Hyperion Shared Services.
• Creating dimension security in planning based on the user requirements and refreshing the database and security filters frequently to accommodate these changes in Essbase cubes.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
• Developed the Rule files to load the data from Excel and Relational sources.
• Developed the Excel templates for lock and send.
• Created Substitution Variables, Business Rules, Calculation Scripts and Report Scripts in Essbase.
• Automated the complete production process using Maxl scripts & batch scripts.
• Batch Scheduling using Window Scheduler.
• Created Technical Documentation and provided support for testing & knowledge transfer activities.
• Setting up users and groups according business department and assigning security to users and groups using Shared Services.
• Implemented robust data-access security and user management
• Developed Excel Templates for user interface in Essbase database
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Environment: s: EPM System 11,Hyperion Essbase 11.1.1.3, Essbase Excel Add-in 11.1.1.3/11.1.1.4 , EIS 11.1.1.3, Hyperion Shared Services 11, Microsoft Excel 2007/2010, Microsoft Windows Server 2003 R2, Microsoft Visual Studio 2005, Microsoft SQL Server 2005, Teradata Client 14.0, Teradata SQL Assistant 14.0, AS/400 Client, iSeries Navigator, DB2 query, Informatica 9.1.0 (Power Center Client), Rally, Jira, GIT Hub.

Confidential, Charlotte, NC

Hyperion Developer

Responsibilities:

• Involved in system installation, configuration and software upgrades from Essbase version 7.1 to 9.3, EIS upgrade from version 7.1 to 9.3.
• Involved in gathering requirements from business users and developing a project plan
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool
• Implemented star schema and used EIS to interface with the company’s existing Oracle data warehouse
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Loaded data using Essbase Integration Services (EIS)
• Carried out nightly updates for refreshing the cubes
• Hyperion planning was used to create new web forms. The same was used to define business rules.
• Used two different data sources; Essbase and planning to build reports.
• Developed new Planning Application Matrix from scratch as per business requirement.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Administered and knowledge on installation, configuration, and optimization of Hyperion System 9 Essbase, Planning, Financial Reporting and Web Analysis.
• Created, published and migrated a number of reports (BQYs) using Hyperion Interactive Reporting.
• Built several custom reports using Hyperion Financial Report V 9.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
• Created reports in web analysis 9.3.1 and administered those reports from Hyperion workspace.
• Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis & Hyperion Reporting Studio V 9.3.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
• Specific role as Essbase Administrator involved Shared Services security development for Essbase and Planning.
• Setting up users and groups according business department and assigning security to users and groups using Shared Services.
• Implemented robust data-access security and user management
• Developed Excel Templates for user interface in Essbase database
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Environment: s: Hyperion system 9, Hyperion Essbase 9.3/7.1/6.5, Essbase XTD Analytic, Microsoft DTS, Hyperion Analyzer 9.x/7.0/6.5, EIS 9.0/7.0/6.5, Hyperion Planning, Hyperion Interactive Reporting 9.3, Hyperion Reports 9.x, Microsoft Excel 2000, Oracle 11i,Business objects 5.0, Oracle SQL Loader, Windows 2000 Advanced Server

Confidential

Hyperion Developer

Responsibilities:

• Responsible for designing the database for improved ETL and building a new financial database, gather all user requirements, conduct interviews for offshore candidates, lead offshore team for future maintenance activities. Cut the run time from 6.5 hrs. To 1.5 hrs. With negligible impact for existing users' interaction.
• Performed consolidation and reporting duties. Created and executed new financial reports and procedures using Interactive Reporting, Web Analysis & Hyperion Reporting Studio V 9.3.
• Extensively worked on SQL drill through process to prepare the financial reports.
• 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.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube; develop MDX queries.
• Created and maintained multidimensional database (MDDB) financial applications to perform ad-hoc General Ledger analyses for accountants and financial analysts.
• MS Excel Report generation with VBA programming for Essbase. Created various test-data using SQL and excel to perform more DBA activities of performance tuning of developed Calc scripts and created mechanism to allow periodical Essbase backups.
• Involved in developing report scripts, formulas using ESSCMDs; tested and optimize their performance.
• Provided support to the Essbase and Planning applications after the production cutover.
• Used PL/SQL for extracting and transferring selected data into Oracle data warehouse and then wrote several load rules for smoothly loading the data into Essbase server.
• Built a new Essbase financial database for reporting Actuals, Budget, Flash and Forecast numbers. Designed the ETL process for data load into the new database from SQL tables. The key point for the project was 'maintenance', as the existing team didn’t yet have any Financial Systems analysts.
• Managed BSO and ASO cubes and improved their performance through tuning: recognizing design issues, eliminated fragmentation, sizing caches, grouped sparse dimensions together, optimized Essbase caches, fine tuning of cache settings usage of filters.
• Automated data loads using ESSCMDs and MaxL in both interactive and batch modes. Generated several MDX queries for ASO cubes.
• Built several custom reports using Hyperion Financial Report V 9.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.
• Responsible for month-end tie-out and provide related support to financial controllers.

Environment: s: Hyperion Essbase, Hyperion Planning, Hyperion Financial Reports Studio V9.3, Interactive Reporting, Web Analysis, Hyperion Integration Services, Web Logic, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX Shell scripts.