Ram Sam Email & Phone Number

Client is an integrated natural gas company, produces, gathers processes and transports clean burning natural gas to heat homes and power electric generation. Strategic Reporting Environment (SRE) is a reporting environment where BAC (Business Area Controller) will review financial data in order to support workflow process needed to prepare Profit & Loss (PnL), Balance Sheet (BS) & Financial Spread (FS) reporting & reconcile on daily & monthly basis. This portal encapsulates all the business related performance in a user-friendly manner and helps the user to make the decisions required for the growth. This application operates in a larger framework of strategic planning, decision support system and management information.

Environment : Hyperion System 11.1.1.2, Hyperion Financial Reporting 9.3.Planning11.1.1. Client is an integrated natural gas company, produces, gathers processes and transports clean burning natural gas to heat homes and power electric generation. Strategic Reporting Environment (SRE) is a reporting environment where BAC (Business Area Controller) will review financial data in order to support workflow process needed to prepare Profit & Loss (PnL), Balance Sheet (BS) & Financial Spread (FS) reporting & reconcile on daily & monthly basis. This portal encapsulates all the business related performance in a user-friendly manner and helps the user to make the decisions required for the growth. This application operates in a larger framework of strategic planning, decision support system and management information.Responsibilities:Designed Security setup based on user requirement.Involved in designing, modifying and building of cubes and assigning member properties. Also worked on Enterprise Performance Management (EPM).Involved in creating, modifying calc scripts as per the business requirements to solve production issues.Involved in optimization of outline and calc scripts. Involved in using HFM for audit trials and other controls like reporting template.Written many report scripts for exporting of subset of data to flat files.Involved in designing the load rule files for loading data from Excel sheets and flat files.Involved in implementation a template of generating reports monthly, quarterly and year-end financial management using HFM reportingInvolved in designing security filters and assigning them to end users.Involved in deploying of cubes from testing to production, restoring database from back up after database corrupt or server crash.Involved in writing scripts for automation of Essbase jobs.

Environment : Hyperion System 11.1.1.2, Hyperion Financial Reporting 9.3.Planning11.1.1. John Hancock is a market leader in key insurance and investment product lines.The company provides traditional commercial and retail banking services and other financial services in the fields of investment banking. The objective of this Financial Data warehouse is to ease information access and summarize information in order to better serve the administrative and business power users. Power users can respond to the changing market by providing customer-oriented, market driven, low-cost products and services. Responsibilities:Built new hierarchies and definedcalculation rules accordinglyInvolved in performance tuning and troubleshooting applications by using the Enterprise Performance Management solutions.Managed user security using shared services and Essbase filtersDeveloped Calc Scripts, Rule files for data loads and dimension buildsOptimized database settings, data loads and Calc ScriptsAutomated the data load process by using Maxl Scripts.Analyzed all dimensions and members in the Essbase outline.Produced reports using Essbase Excel Spreadsheet add-in to retrieve and drill down on relevant information.Provided Production support to existing cubes.Involved in Hyperion Applications Development and Production Support.Project # 3; Project : Analytical Reporting System Role : Hyperion Essbase developerEnvironment : Hyperion System 9 BI+ Analytic Services 9.3.1, Essbase Administration Services 9.3.1, Hyperion System 9 BI+ 9.2.0.2, Hyperion Financial Reporting 9.3, Hyperion Shared Services 9.3, Hyperion Application Link 9.

Project : Business Management System Role : Hyperion Essbase developerEnvironment : Hyperion Essbase 9.3.1/6.5, Essbase Administration Services7.1.2, Financial reporting 9+, Hyperion Reports 7.0, Essbase Excel Add-In, Oracle 8i, Windows 2000 NT; This Project is involved in the development of data warehouse for BMO based on different kinds of functional areas such as accounts and loans. In loans it has loan amounts for various purposes like: personal loan, educational loan, vehicle loan, housing loan, customer durable loans, interest rates, defaulter a list and the penal interest calculations, etc. They needed a data warehouse so they could maintain historical data and central location for integration, analyze business in different locations.Responsibilities:Developed Hyperion Essbase application for corporate finance which included developing outline & data load rules, calculation scripts, and Maxl scripts for automated outline and data loading.Optimized outline, data load rules and calculation scripts, Manipulated data columns to suite dimension builds, tested data load rules, fixed errors from the error log files, resolved issues of data retrieve from excel. Analyzed all dimensions and members in the Essbase outline.Involved in performance tuning, backup and recovery of cubes.Maintained cubes and took regular backups.Created users and user groups and applied security in Essbase.Involved in Hyperion Applications Development, Performance Managementand Production Support.Involved in Migration of Reports from development and Production Server