Sign in

Oracle Project

Stamford, Connecticut, United States
September 20, 2018

Contact this candidate


Umar Ayoob

Manager BI Architect



+ 11 years experienced Manager/Architect

Analytical, collaborative professional proven in planning and managing complex projects. Well versed in leading and managing teams and designing solutions. Experienced in providing timely and quality delivery against aggressive deadlines and cost requirements. Worked in Manufacturing, Retail, Supply Chain and Hospitality Domains with top Fortune 500 - customers. Performed significant roles in projects ranging from Support/Enhancement, Development, Business Discovery, and Installation/Migration. Involved in all phases of a project from Requirement gathering. Analysis, Design, Development, Testing, Implementation and Maintenance.

Areas of Expertise:-

Troubleshooting and problem solving skills.

Major Oracle EPM Hyperion Tools with good experience in Database tools like SQL Server and Oracle.

Hands on experience in top BI tools.

SQL Scripting.

Migration to Cloud Virtual servers (PaaS and IaaS) and developing Oracle PBCS/EPBCS application (SaaS).

Installation, upgrade or migration of Oracle EPM products.

Experience in setting up SSL on EPM products to satisfy compliance and address security concerns.

Function and technical documentation skills.

Understanding company SOX Change management and ticketing process.

Agile, Scrum, or Waterfall project Methodologies.



Oracle Hyperion Essbase 6, 7, 9.3.1,,,

Oracle Hyperion Essbase Studio,,

Hyperion Integration Service 7

Oracle Hyperion Planning 7, 99.3.1,,,

Oracle Hyperion Shared Service 9.3.1,,,

Oracle Hyperion LCM,,

Oracle Hyperion EPMA 9.3.1,,,

Oracle Smart View

Oracle EPM Hyperion Financial Reporting 9.3.1,,,

Oracle OBIEE 12 g

Oracle EPM Hyperion HFM,,

Oracle Hyperion FDMEE,

Hyperion DRM 9.3.3

Oracle Cloud PBCS

Oracle Cloud Essbase

Microsoft SSIS 2005, 2008, 2012, 2016

Microsoft SSRS 2008

Programing Languages:-







Unix Shell Scripting



Oracle 9i, Oracle 11g

SQL server 2005, SQL server 2008, SQL server 2012, SQL Server 2016

Hardware / Platforms:-

Microsoft Windows Server 2016, 2012,2008, 2003,2000,98

Oracle Exalytics In-Memory Machine

Linux 6


Nestlé Waters North America

Oct-2016 - Present

Role:-Manager/BI Consultant


Oracle Smart View, Oracle Essbase, Oracle Exalytics Machine, OBIEE 12g, SQL server 2012, SQL server 2016, Microsoft SSIS, SAP, Power shell, Oracle Hyperion FDMEE, Oracle Hyperion Essbase Studio,

Project Description:-

Nestlé Waters North America, Inc. is a business unit of Nestlé Waters that produces and distributes numerous brands of bottled water across North America. Continent-wide brands include Perrier and San Pellegrino.

There are critical Essbase applications, which require supporting/maintaining the existing Business processes and perform enhancements so that the users can use the applications in an optimized manner and without interruption. NWNA Business were in need of a dedicated Essbase team to work on the support activities and critical development projects. NWNA were also moving towards migrating applications to Oracle Exalytics Box, which is powerful in-memory analytics machine. Along with the migration, the project scope included to redesign the existing Essbase applications to simplify and improve performance. In addition, business user had a requirement to retrieve backend details for relevant intersections in Essbase.


Worked on building a new team for development and support projects; understood the requirements and involved in the negotiation, finally submitted proposal defining the team structure and hourly rate for each of the resources.

Discussed and defined the SLAs for handling and resolving support issues and project deliverable. Created a definite set of Project Measures or KPIs to measure the team performance.

Attended weekly project status meetings and share updates on tasks and projects worked by the team.

Engaged in Stake Holder management, quality management, project audits, Support and Enhancement of Financials processes and project management.

Engaged with the Client IT business and System analysts to understand the Business processes, systems, Landscape and Data. Transition the knowledge to the team via Knowledge transfer sessions and documentation.

Using expertise in Oracle Hyperion EPM tools, provided consultation for applications and processes on Oracle EPM Suite of Products mainly Essbase.

Completed the project to Install Oracle EPM Components on Oracle Exalytics Linux box. Migrated critical Hyperion applications to Oracle Exalytics box.

Worked with security team to request SSL certificate and use the certificate to set up secured (HTTPS) URL to the EPM products thru Oracle HTTP server.

Created Disaster recovery process for critical Hyperion Financial Application from on premise Oracle Exalytics Machine to Cloud (Microsoft Azure) Window server, which involved automating the Essbase cube data/artifacts backup, and Essbase cube restore process. Documented and communicated the disaster recovery plan and defined the disaster recovery strategies.

Completed installation of Oracle EPM Components on the latest release of Microsoft Windows server and migrated the applications to the upgraded platform using Oracle Hyperion LCM process.

Performed Hyperion Infrastructure Administrator activities from troubleshooting performance issues, managing multi-environment Oracle EPM systems.

Applied periodic patches on Hyperion system based on Oracle recommendation to fix reported bugs.

Sustained and enhanced Financial Hyperion applications and associated source/interfaces SQL Server databases.

Create interfaces to Essbase and designed ETL process to load files/tables using Microsoft SSIS.

Worked on designing Essbase Load or Build rules files and Calculation Scripts as per Business requirements.

Successfully completed project to design and create new Essbase applications for Business critical Flash Reporting. Conducted requirement-gathering session. Defined the project requirement and Project Scope. Proposed the design of the solution and provided the time/effort estimate to complete the project. Finally deployed the final solution to production and supported any user reported issues on the application.

Responsible for defining and maintaining Essbase security filters and groups in Shared service.

Perform batch, integration, and scripting using MAXL scripting and power shell.

Schedule and run SQL server agent Jobs to call Essbase build and load process.

Created Essbase report script to provide Adhoc reports to user and automated the report extraction for Business users.

Manage all technical tickets both with the internal ticketing system, and externally (Oracle or other vendors).

Helped Business users to complete their Activities especially during Period End Close, Planning Cycles .Troubleshoot issues reported by the users during these crucial business cycles and communicate the resolutions or updates.

Identify the periodic/Adhoc activities – Period End Close, End of Year, Adhoc Business requests, Server patching, Compliance activities etc. Document them as standard routines and maintain/update these documents in a timely manner.

Trained Business users on OBIEE to create Analysis reports and Dashboards pulling data from Essbase and SQL Server data warehouse.

Migrated and perform testing to move SQL Server Data ware houses from SQL Server 2008 to SQL server 2016. Point all the Microsoft SSIS packages to the new SQL Server 2016 connection.

Create process to move Essbase extract to Microsoft Azure as part of major Data Lake project.

Set up an Essbase application Essbase studio to suffice Business user Drill Through functionality.

Wyndham Worldwide Corporation

May-2016 to Sep-2016

Role: - Oracle EPM consultant


Oracle Smart View, Oracle Essbase, Oracle Hyperion Planning, Oracle HFM, Oracle FDMEE, Oracle Financial Reporting, Oracle

Project Description

Wyndham Worldwide Corporation is the holding company for Wyndham Hotels & Resorts, RCI and other lodging brands. Wyndham Worldwide, headquartered in Parsippany-Troy Hills, New Jersey, operates several hotel brands across the world.

Several departments within Wyndham have their own set of Hyperion Applications and Wyndham wanted migrate these Hyperion Applications to Oracle EPM Latest offering i.e. version The project objective was to perform the migration and troubleshoot the issues faced during the migration.


Successfully completed the migration of Oracle Hyperion Financial Applications (Hyperion Essbase, Hyperion Planning, FDMEE, and HFM) from version to . Provided consultation on the best practices for migrating the Hyperion Applications. Researching new release features, addressing and troubleshooting issues, monitoring project team progress.

Involved in preparing effort estimation, Risk and Gap Analysis, User Testing and Technical documentation.

Involved in status meeting with the VP of technology to provide project status and discuss outstanding issues.

Worked with the infrastructure team to resolve Load balancer issues.

Worked on converting low performance Hyperion Planning/Essbase cubes to ASO and Hybrid mode. Discuss the design and challenges in session, finalized the design .Demonstrated proof of concept, and finally converted the applications to ASO and Hybrid mode.

Working with Oracle support on the issues, applied fixes to the configuration to environment or application. Also escalated show stopping issues with Oracle support to obtain the necessary patches.

Designed and developed Planning and budgeting application on Oracle PBCS .Trained the users on how to access the application and load their forecast or budgeting numbers and how to access them using Oracle Smart view.

Hanes Brands Inc

Jul-2014 to Jan-2016

Role: - Lead System Analyst and Oracle EPM Consultant


Oracle Smart View, Oracle Essbase, Oracle Hyperion BI Plus (Financial reports/Hyperion Workspace/Web Analysis), Oracle Hyperion Planning, SQL server 2012, SQL server 2008

Project Description

Hanes Brands Inc is one of the Fortune 500 US based companies. The Company designs, manufactures, sources and sells a range of apparel essentials, such as t-shirts, bras, panties, men's underwear, kids' underwear, socks, hosiery, casual wear and active wear. In addition to designing and marketing apparel essentials, the Company operates a global supply chain that incorporates a mix of self-manufacturing, third-party contractors and third party sourcing.

Hanes Brands were focusing on expanding the business globally. Hanes were acquiring businesses in Europe and need an experienced consultant to integrate the financial and sales data from the acquired Company into Hanes Financial application thus hired back for second term to provide consultation and work on the projects. Hanes had HFM application as a consolidation tool and it was imperative they include the financial numbers (Income statement and Balance sheet) from the acquired business. The project include to work with Business Analyst understand the new data and integrate it with the existing process and system. In addition, they had a Workforce out-of-box Oracle Hyperion Planning application, and HR generalist requested for enhancement to the application to improve budgeting process and reporting. There was a development project for a new Hyperion Planning application to be used cooperate wide Budgeting and planning application. Provide consultation to the migration of Hyperion Planning and Essbase applications to Cloud virtual server (IaaS).


Based on requirement build Financial Hyperion Planning application

Optimize and enhanced the Hyperion Workforce Planning Application. This involved conducting extensive user testing and user requirement gathering sessions, then advising the best solutions for the issues and requirements that surfaced.

Created Financials reports as per user requirements for Financial Statements and Data Validation.

Create Business rules for Advertisement and Media Expense allocation in the financial Hyperion Planning Application.

Involved in the integration project as part of Client’s Acquisitions. Design and set up process for pulling the financial data from the Acquired Company Legacy Hyperion Enterprise Application to Hanes Brand’s Data warehouse and HFM/Essbase.

Created custom SSRS reports which pulls the data from Hyperion Workforce planning application sufficing Headcount and Employee Roster information.

Completed migration of Hyperion Planning and Essbase application to cloud virtual server.

Xerox Corporation US

Dec-2012 to June-2014

Role: - Lead Support Analyst and Oracle Hyperion Administrator


Oracle Smart View, Oracle Essbase 9, Oracle Essbase, Oracle Hyperion BI Plus (Financial reports/Hyperion Workspace/Web Analysis) 9.3.X, Oracle Hyperion DRM 9.3.3, SQL server 2012, SQL server 2005, Java, Microsoft SSIS 2012, SQL Sentry

Project Description

Xerox Corporation is the global leader in document management, offering the widest range of technology, consulting services and solutions in the industry. Xerox provides the document industry's broadest portfolio of offerings. Digital systems include color and black-and-white printing and publishing systems, digital presses and "book factories," multifunction devices, laser and solid ink network printers, copiers and fax machines.

Enterprise Financials Information application is set of Mission critical Business and Financial applications and processes for storing and processing Xerox financial data. Xerox will be receiving financial data feeds from around 500 sources across the globe, which load to SQL server database and finally into Essbase. The users will extract the required information using either Smart View or Financial Reports. The project scope was to maintain the critical processes, administrator and maintain the Hyperion Environments so that the users not affected by any unforeseen disruptions. Install and configure Oracle Hyperion on Windows server, and migrate the Hyperion Applications to the newer version.


Perform Lead role, coordinate tasks with offshore team, and provide updates to reporting manager.

Point of contact for the applications for Business users approach in case of issues or any new requests.

Attended weekly project meeting with Business and IT managers to prioritize tasks and projects. Also, provide updates on the outstanding Business raised or system issues.

Working with QA team to test the fixes or new functionalities applied to the applications.

Involved in installation of Hyperion DRM 9.3.3 and troubleshooting the issues during the installation.

Helped migrating the Hyperion DRM artifacts from the old server to the upgraded server.

Recommended setting changes to Microsoft IIS (Web Server for DRM) to prevent issues and obtain better performance.

Documentation of the installation process for Hyperion DRM and related troubleshooting steps during the installation process.

Creating and managing Essbase security (Users/groups/Filters) in both Essbase native security mode and Shared service authentication. Work with End users to fix Essbase security issues and analyze data issues.

Create data load SQL jobs and execute them. Fix issues with data loading and keep the warehouse up and running without any outage to end users.

Write custom Essbase Calculations Scripts; automate the Essbase administrative activities using MaxL, ESSCMD and Batch Scripts. Create reports scripts as per user requirements.

Created Financials reports as per user requirements. Prepare Excel add-in retrieval and submission templates. Worked with end users in fixing data retrieval/submission sheet issues and financial report templates.

Build rules files for building outlines though different dimension build methods and loading data. Edit and set member properties in outline cubes.

Completed the installation and configuration of Oracle Hyperion on Windows servers. Fixed the errors occurring the process .Documented the installation process and errors, in a well-defined and formatted document for future reference.

Planned, tested and completed the Oracle Hyperion EPM upgrade and migration project. Successfully Upgraded Hyperion products (Hyperion Essbase/Hyperion AAS/ Hyperion Shared Service/Workspace/Web analysis/FR studio/ Excel Add-in/Smart view) from 9.3.3 to Migrated Hyperion applications to the new version of Hyperion and Windows server. Assisted the user to transition to the new Essbase server, communicating the roll over plan and providing user guide for necessary connection change and other setting changes.

Run Monthly Close process of the applications. Setup and maintain Feed file accepting system (SFTP/ Web upload), maintain ETL operations through Abinitio/SSIS, Load Essbase cubes through SQL jobs/MaxL scripts, Validate users access to data through Financial reports/ Excel add in and Smart View.

Create custom Java program to automate Security Maintenance in Shared service and validating the filter set up in Essbase.

Involved in the project for implementing SSL on Oracle EPM

Performed extensive Oracle Hyperion Administrative activities to maintain the environments and provide solutions to the Oracle EPM related configuration issues. Applied periodic patches to the Oracle Essbase, Oracle Analytics Provider service and shared services.

Hanes Brands Inc

Feb-2007 to Oct-2012

Role: - System Analyst and Onsite Essbase Lead


Essbase Excel Add in, Hyperion Essbase 6,Hyperion Essbase 7, Hyperion Essbase 9,Oracle Essbase, Hyperion BI Plus (Financial reports/Hyperion Workspace/Web Analysis) 9.3,Oracle Hyperion BI Plus (Financial reports/Hyperion Workspace/Web Analysis), Oracle Hyperion Planning, Oracle Hyperion EPMA 11.1.2,SQL server 2005, SQL server 2008, Oracle 9i,Oracle 10g, DTS, SQL/PLSQL, TOAD, UNIX

Project Description

Hanes Brands Inc is one of the Fortune 500 US based companies. The Company designs, manufactures, sources and sells a range of apparel essentials, such as t-shirts, bras, panties, men's underwear, kids' underwear, socks, hosiery, casual wear and active wear. In addition to designing and marketing apparel essentials, the Company operates a global supply chain that incorporates a mix of self-manufacturing, third-party contractors and third party sourcing.

Hanes Brands had multitude of application Essbase and supporting data warehouse, each pertaining to different subjects like Supply Chain, Marketing, Sales, and Finance. These application required constant app support to avert user impact and also changes or enhancements in case of business process change or application upgrade.


Coordinate activities with onsite manager and rely to offshore.

Performed essential support and maintenance activities on Hyperion Planning and Essbase applications.

Performed Subject matter expert role for a Finance critical SQL server data warehouse. Running jobs to pull data from Lawson ERP GL and HR system into the SQL Server DWH. Worked with offshore to address data issues and technical issues.

Maintain Hierarchies in BPMA/EPMA and ran Task flow to execute Oracle Hyperion BPMA/EPMA deployment.

Designed Business Rules for Workforce Planning app like Fringe and Head count calculation.

Set up Menu with intuitive options in Hyperion Planning Web forms so that HR Generalist can easily change the status of an employee in the cube.

Designed Financial Reports and supported users in case of any issues.

Migrated the applications to Hyperion (Version 11.1.2) from Hyperion version 9.

Converted the Hyperion Planning application from EPMA mode to Classic mode so that we can avoid the delay when running the EPMA deployment.

Designed and developed Essbase Finance application, designing ETL to pull GL data from Lawson ERP and rules files to build/load the cube. Analyzed the reporting requirements and designed Financial reports for Balance Sheet, income statement, Cash flow pulls from the newly build cube

Designed User Essbase load templates using Essbase VBA API and Marco functions.

Supported all the Informatica/DTS/SSIS ETL jobs loading to Essbase source table/files and pulling data from Essbase.

Created interface from Essbase cube to Microsoft SSAS cube using Export calc script and informatica ETL

Research the new feature of EPMA and used EPMA batch client to automate the deployment of the EPMA mode Hyperion Planning application.

Completed a project to convert slow performing Marketing and Media BSO cube to ASO cube, giving user both report and aggregation performance.


Bachelor Degree on Electronic and Communication May-2002 to June-2006


Oracle Certified Associate(OCA) certification

Oracle - Hyperion Certified - Hyperion BI+ 9.3 Developer

MCITP(Microsoft Certified IT Professional) for Database Developer 2008

Contact this candidate