Summary of various assignments with Saturn e-Solutions
1. Kuwait Gulf Oil Company (KGOC), Kuwait
Roles & Responsibilities:
- Oracle Planning and Budgeting Cloud Service (PBCS) implementation at KGOC.
- Gathered requirements by understanding the budgeting and forecasting process of client and then prepared a requirements document for the implementation of PBCS application and Financial Reporting
- Prepared the high level design document.
- Designed, developed, as well as coordinated with offshore development team for developing the
application artifacts, workflow processes, calculation scripts, access provisioning.
- Designed monthly and yearly reports using Financial Reporting Studio.
- Integrated the PBCS metadata as well as data with Fusion (GL, Payroll) and external systems.
- Conducted training and User Acceptance Test (UAT)
- Migrated the planning application from Dev to Prod Environment.
Environment: PBCS, Financial Reporting Studio, Smart-View, Financial Data Management Enterprise Edition (FDMEE)
2. Telecommunications Regulatory Authority of UAE
Roles & Responsibilities:
- Understood the budgeting process of organisation, gathered the requirements, and documented it
- Based on the analysis of the organisations working process, prepared a high level Design Document
- Created EPMA application designed and developed the metadata by integrating it with Oracle EBS, GL
system, FA module and HRMS via FDMEE and rule files in Essbase.
- Designed Planning Artifacts such as Task List, Data Forms according to Client's Requirement
- Identified the workflow and approval processes problem in the organization and the new business
requirements related to the workflow process, and then automated these processes using Hyperion
Planning
- Worked upon the calculations scripts and optimization of Essbase cube
- Extensively worked with Shared Services in provisioning access permissions to users for Hyperion
Planning, Essbase and Financial Reporting.
- Developed Financial and Management Reports using Hyperion Financial Reporting Studio and Smart-View
for Essbase and Hyperion Planning. Built various reports like the Project wise Budget Utilization, Various
Expenses and Revenue Reports, Manpower Budgeting Report, Income Statement, Balance Sheet, etc.
- Prepared the training and User Acceptance Test(UAT) documents.
- Trained the business users on Hyperion Planning.
- Performed UAT on the planning application, validated the business rules and documented the end results.
- Migrated the planning application from Dev to Prod Environment.
Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Financial Reporting Studio 11.1.2.3, Hyperion Shared Services, Smart-View, FDMEE
3. Application for Oracle Planning and Budgeting Cloud Service
Roles & Responsibilities:
- Developing a technical solutions to common business problems
- Created a generic classic application which can be restructured as per business requirement.
- Created web forms and excel templates to extract information from the system
- Interpreted business rules and requirements for technical systems
- Designed calculation scripts, grids, task lists, business rules and consolidation reports
- Developed Financial and Management Reports using Hyperion Financial Reporting Studio and Smart-View PBCS. Built various reports like the Income Statement, Balance Sheet, Variance analysis reports.
Environment: PBCS, Hyperion Financial Reporting Studio, Smart-View, FDMEE
4. Cronos, A Leading Container Leasing Company
Roles & Responsibilities:
- Analyzed the organizations working process and designed its processes and systems, assessing the business model and its integration with technology
- Designed and developed Aggregate Storage Option (ASO) cube
- Developed load rules for dimension build and data load
- Loaded data by using automation techniques using MaxL Scripts into the outline developed for data cube
- Retrieved reports using Smart View and generated reports in Hyperion Financial Reporting Studio
- Involved in dynamic dimension building and modifying outlines. Assured optimal match between cube
design and report specifications
Environment: Hyperion Essbase and Hyperion Financial Reporting Studio 11.1.2.2, Microsoft Excel 2007 Smart-View, MS SQL Server, Windows 2007
5. Central Bank of Nigeria, Africa
Roles & Responsibilities:
- Requirement gathering by understanding the budgeting and forecasting process of client and then preparing a requirements document for the implementation of Hyperion Planning and Financial Reporting
- Prepared the high level design document
- Created EPMA application, web forms and excel templates to extract information from the system
- Designed Planning Artifacts such as Task List, Data Forms according to Client's Requirement
- Migrated Planning Applications, Data forms and Business Rules from Dev to Prod Environment
- Identified the workflow and approval processes problem in the organization and the new business
requirements related to the workflow process, and then automated these processes using Hyperion
Planning
- Performed unit tests on the planning application, validated the business rules and documented the end
results
- Developed Financial and Management Reports using Hyperion Financial Reporting Studio and Smart-View
for Essbase and Hyperion Planning. Built various reports like the Income Statement, Balance Sheet, Run-
rate analysis and other region specific reports
- Extensively worked with Shared Services in provisioning access permissions to users for Hyperion Planning,
Essbase and Financial Reporting
- Designed Training document for Smart View and Reporting
Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Financial Reporting Studio 11.1.2.1, Hyperion Essbase Administrative Services, Hyperion Shared Services, Smart-View
Adding to the above projects, I have also helped pre-sales team with building request for proposal, consisting of cost estimation, time estimation, team requirement, functional solution and technical solution.
- Responsible for end to end implementation of Oracle Hyperion Planning, Essbase, and Financial Reporting Studio.
- Common tasks included requirements gathering, solution design, business rule definition, building metadata and dataforms, provisioning profiles, development of planning unit, hierarchy, tasklists, and business reports along with end to end security setup.