Sreyas Pillai

Sreyas Pillai

Summary

Sreyas Pillai is a Hyperion Technical Consultant with more than 2.5 years of experience in the Business Intelligence Domain. He has worked in the areas of Requirements Elicitation and Analysis, Design, Development and Testing of Planning and Budgeting applications. He has been part of complex implementation teams consisting of Hyperion / Oracle System 9x and 11x products: Planning, Analytic Services (Essbase), Web Analysis (Analyzer) & Financial Reporting.

Sreyas is also a trainer with Oracle/Hyperion and has delivered (500+ hrs) training on Hyperion Planning and Hyperion planning installation and configuration  and other oracle Hyperion suite of products in APAC region and  is rated well during all his training feedback

Work History

Work History
Aug 2007 - Present

Professional Services EPM/BI

Nouvasys

INDUSTRIAL EXPOSURE

Projects:

Project 1: Management Information System for Idea Cellular

The MIS reporting solution is based on prepaid systems to develop reports for more than 2500 users at Idea Cellular, India’s leading Telecom Company. The implementation involved development of Multidimensional database to collect data for all regions involving 100-120 GB of daily data upload. Reports and dashboards created were distributed across the organization based on Hyperion’s Integrated Platform. The project involved about 2 TB of reports generated every 3 month.

Job Responsibilities:

·Requirement gathering and Hyperion Essbase cube design

·ETL scripts creation(data extraction and transformation using in SQL and PL/SQL)

·Streamlining data load in Essbase cubes.

·Financial reports creation,

·Automation of jobs creation and Scheduling on Hyperion Workspace.

·CreatingProfitability management and corporate Dashboard in web analysis

Tools and Technology Used: Hyperion Essbase9.3.1, Hyperion Web Analysis, Oracle 10g, Hyperion BI+, PL/SQL and SQL.

      -----------------------------------------------------------------------------------------------------------------------------------------

Project 2: ASTAR – Financial Planning Management: Singapore

ASTAR has R&D operations in information, communications and media (ICM) technologies, wireless and optical communications and interactive digital media. It develops holistic solutions across the ICM value chain and has 13 entities under it. We were responsible for Implementation of a centralized budgeting solution that would stream line the budgeting procedure and help the finance department to budget and forecast their expenses as well as help the Human resource department in maintaining the headcounts, salary calculation, calculating leave encashment rate etc

Job Responsibility:

·Designing System Architecture and Installation of Hyperion Suite of Products

·Writing calc scripts, member formulas, business rules as per as the scope of project.

·Creating Data Input forms

·User provisioning and defining access securities

·UAT and migration to production environment.

·Creating Reports for the management level.

Tools and Technology used: Hyperion System 9.3.1 Planning, Hyperion financial reporting, SQL Server 2005, SAP, and Hyperion Essbase Add in.

            --------------------------------------------------------------------------------------------------------------------------------

Project 3:Planning and Budgeting Application |Carson’s agro sector| Srilanka|Indonesia

Carson Cumber batch PLC incorporated in Sri Lanka is the holding company of a diverse group of businesses, with main lines of business Interests in oil palm plantations, beverages, investments and financial services, real estate and leisure sectors. Its business interests span regionally across in Sri Lanka, Malaysia, and Indonesia. Theproject involved creating a centralized planning and budgeting application that would replace the existingexcel based budgeting .This centralized application is accessed across their entities facilitating there capital, human resource ,crop projection budgetingit also facilitated long range forecastingwith help of integration of strategic finance and Hyperion planning.

Job Responsibility:

·Requirement gathering and project scoping.

·Designing of a centralized Planning solution and Hardware architecture.

·Installing Hyperion Suite of products on distributed environment.

·Freezing the metadata and application layout as per as scope of the project.

·Creating moderate complexity Business rules,calcscripts that adheres to the project requirement

·Single handed responsibility of initial feasibility modules

·User provisioning and defining access securities

·UAT and migration to production environment.

Tools and Technology used: Hyperion System 9.3.1 Planning, Hyperion financial reporting, Oracle 10g, Hyperion Essbase Add in, Smart view, Hyperion strategic finance, IBM Web sphere Application server .

        --------------------------------------------------------------------------------------------------------------------------------

Project 4:Planning and Budgeting |Oman Refineries and Petrochemicals Company |Oman

The government-owned Oman Refineries and Petrochemicals Company (ORPC) produces liquefied petroleum gas, kerosene, diesel, bunker fuel oil, propylene, naphtha, low-sulfur gas oil and granulated sulfur. The company was established in September 2007 as a result of a merger between the Oman Refinery Company and the Sohar Refinery Company. We were responsible for creating a Planning and budgeting application that facilitates ORPC to do their production planning for all the products, calculate revenue from various profit centers, capture cost incurred at various cost centers, Operational and Capital Expenditure budgeting for Corporate, MAF, and SOHAR entities.

Job Responsibility:

·Offshore resource supporting the team onsite.

·Optimizing the design and application structure.

·Creating moderate complexity Business rules,calcscripts that adheres to the project requirement

·Creating Validation scripts on Hyperion Planning forms.

·User provisioning and defining access securities

Tools and Technology used: Hyperion System 11.1.1 Planning, Hyperion financial reporting, Oracle 10g, Hyperion Essbase Add in, Smart view, Weblogic, Java scripts

---------------------------------------------------------------------------------------------------------------------------------

Proof of Concept| Demos:

Proof of concept 1: Royal Jet Financial Management Application | Dubai:

Royal Jet is an aviation industry in Dubai. Royal jets planning and budgeting was based on traditional excel system and they spent lots of time in analysis and preparing budgets for the capital expenses and their workforce expenses. The Proof of concept for Royal jet involved creating a centralized planning and budgeting proof of concept which facilitates Royal Jet to maintain their inventory, finance as wells as deal with manpower expenses.

Job Responsibility:

·Interacted with client for information and requirement gathering.

·Designing the Proof of Concept from the existing supplied budgeting templates.

·Customizing Capex and Workforce Planning to cater clients requirements

·Loading data into planning.

·Creating data entry forms and complex business rules

·Creating Reports for the management level.

Tools and Technology used: Hyperion System 9.3.1 Capex and Workforce Planning, Hyperion Financial reporting, Ms Excel, Oracle 10g

----------------------------------------------------------------------------------------------------------------------------------------------------------

Proof of concept 2: Deyaar planning and Budgeting Application |Abu Dhabi

Deyaar is one of the largest developers at Dubai’s Business Bay, its real estate ventures span across major growth corridors and prime locations in Dubai, including Dubai Marina, The Waterfront, Jumeirah Lake Towers, IMPZ, TECOM, and Downtown Jebel Ali.Deyaar’s operations are divided across four key business units, namely, property development, lease management, asset management, and fund management. The proof of concept build for Deyaar involved demonstrating what if analysis on the amount allocated on their various projects. In addition to this the application facilitated Asset planning and budgeting on individual project levels along with the manpower involved in each project. The system generated balance sheets and cash flow on basis of budgeted figures.

Job Responsibility:

·Interacted with client for information and requirement gathering.

·Designing the Proof of Concept from the existing supplied budgeting templates.

·Customizing Capex and Workforce Planning to cater clients requirements

·Loading data into planning.

·Creating data entry forms and complex business rules

·Creating Reports for the management level.

·

Tools and Technology used: Hyperion System 9.3.1 Capex and Workforce Planning, Hyperion Financial reporting, Ms Excel, Oracle 10g

---------------------------------------------------------------------------------------------------------------

Proof of concept 3: Resource Management System: Full 360 PVT LTD: Mumbai:

The Resource Management System involved creating an application and customized data entry forms for the employees of various departments so that they can fill in their daily time sheets. Higher level managers can set timelines for employees working under them and analyze the performance of each employee.

Job Responsibility:

·Scoping and design with senior management.

·Presentation of the final solution.

·Creating and deploying the application.

·Creating and provisioning users and groups.

·Setting up access right to the application

Tools and Technology used: Hyperion System 9.3.1 Workforce Planning, Hyperion Essbase, Hyperion Financial reporting, Hyperion Web Analysis, Ms Excel, Oracle 10g

              -----------------------------------------------------------------------------------------------------------------------------

Trainings

Trainings conducted on behalf of Oracle University:

·Hyperion Planning 9.3.1: Create and Manage Application

·Hyperion 9.3.1 BI+ Installation and administration

·Hyperion Web Analysis 9.3.1 Design Reports and Dashboard

Trainings conducted in house for Nouvasys:

·Hyperion Essbase Analytics 9.3.1 calculates databases (Calc Scripts).

·Hyperion Planning Installation and Configuration 11.1.1.

·Hyperion planning 9.3.1 Installation and Configuration on IBM Web Sphere application server(Distributed architecture)

·Essbase administration.

Dec 2009 - Present

Assistant Manager EPM/BI Services and Delivery

Nouvasys

Education

Education
Aug 2005 - Aug 2007

Bachelor in Computer Science

SIES GST