Project Data

SUVANKAR SAHA Phone: +1-647-***-****

Email: ********.****@*******.***

Experience Summary

Over all 9 years of experience in Information Technology with expertise in Oracle EPM and DWH / BI Products in various phases of the SDLC, presently associated with a role of Hyperion Consultant, Mainly concentrating on Essbase, Planning, FDMEE and reporting suites in the latest version – Hyperion 11.1.2.3.50x.

Have good exposure on HFM, Oracle Hyperion Tax Provisioning version 11.1..2.3.700

Excellent knowledge in system and process design, requirement analysis methodology and documentation.

Excellent problem solving skill, and good understanding of ITIL methodologies with hands-on experience on incident management, problem management, change management and system deployment methodologies.

Good team player with experience working with on-site and off-shore teams, and be able to work independently with minimal supervision from management.

Provides best solutions to clients, that includes, Project scoping, sizing, Requirement gathering, Architecture, Analysis, Design, Development, Implementation, Test, Migrate, Troubleshoot, Backup/Restore, Security, Automation, Upgrade, Maintenance and support.

Experience with training and mentoring stakeholders to understand the Hyperion EPM system and used of the product of system to support business processes.

I believe in precise and effective communication and strict adherence to business process guidelines and aspiring for a role of Solution Architect in Business Intelligence domain.

Techno Functional expertise

Oracle Hypérion Enterprise Performance Management suite (EPM):

oHyperion Essbase (Version 9.3 to 11.1.2.3)

oHyperion Planning Classic and EPMA (Ver. 9.3 to 11.1.2.3),

oEnterprise Performance Management Architect (EPMA)

oFinancial data Quality Management Enterprise Edition (FDMEE 11.1.2.3.530),

oHyperion Financial Management (HFM),

oOracle Hyperion Tax Provisioning (OHTP)

oData Relationship Management (DRM)

oFinancial data Quality Management (FDMEE)

oShared services roles and Responsibility, handling AD and ND users groups assigning access

oCalculation Scripts, Dimension build and Data Load Rules, Web Forms, Smart Lists, Menus.

oAd- hoc reporting using Excel Add-in and financial reporting studio.

Oracle EPM System Design, Migrations & Upgrades: Experience in Hyperion Planning (Classic and EPMA, Calculation Manager, Business Rules, Web Forms, Smart Lists, Menus.

Expertise in RDBMS (Oracle PL/SQ, MSSQL)

Best Practices in BI ETL and Data Warehouse technologies

Process Automation Unix shell and Windows batch scripting, Automation of Backup/recovery, Automation of ETL and Hyperion Processes in Windows / Unix environments

Data Warehousing and Data Integration ETL (Tools like SSIS, OWB)

Specialties: Certifications:

Oracle Hyperion Certified Essbase Consultant

Oracle Hyperion Certified Planning Consultant

Oracle Certified PL/SQL Developer

Sectors Served:

Banking

Financial

Insurance

Telecom

Project 9: Oracle Tax provisioning implementation

Customer: TD Bank (Canada March 2015 – Till date)

Role: Hyperion Consultant

Project description: This was the Hyperion Tax provisioning module implementation for TD business to automate the enterprise tax calculation. Worked as a technical lead with different vendor.

Project Responsibilities:

Designed the Hyperion application architecture selected tools as per the project requirement.

Project design and data flow planning

Validating Hyperion environment after the installation and configuration.

Install and upgrade patch (11.1.2.3.700) in various related product of Tax

Created data load rule to load data load files to FDMEE

Created automated data load scripts for FDMEE

Created security for Tax and FDMEE

Created some FR and Smart view ad-hoc reports

Created the test scripts test cases for SIT testing.

Migrating TAX application from lower environment to higher through LCM.

Copy data using the Application Copy utility

Project 8: Hyperion Upgrade Project (11.1.1.3 to 11.1.2.3.500)

Customer: TD Bank (Canada Jun 2014 – March 2015)

Role: Hyperion Consultant (Technical Lead)

Project Description: Hyperion Version 11.1.1.3 is getting de supported by oracle soon. So TD bank decided to upgrade EMRS environment to the latest Hyperion version 11.1.2.3.50x and migrate all the application to this environment.

Project Responsibilities:

Project Planning - selecting proper version of the product, hardware sizing

Involved in validating Hyperion environment after the Product installation and configuration

Migrating Essbase and planning application from old environment to new.

Validated and changed set up related files as and when required as per business needs.

Changes maxl data load script in order to incorporate the Essbase error login changes.

Migrated the Business rules into Calculation Manager.

Migrating of Security, FR reports from old version 11.1.1.3 to new 11.1.2.3

Smart View 11.1.2.5.210 packaging for business roll out.

Worked on the Hyperion performance issues and tuning application settings.

Testing of all the application functionality and validation

Creating the Planning workflow for Planning entity process management and approval cycle

Project 7: EMRS Consolidated Cube

Customer: TD Bank (Canada January 2014 – May 2014)

Role: Hyperion Consultant

Project description: In addition to its current reporting obligations, TD has new external reporting requirements which require data from across the all segments to provide Total Bank reporting. No current cube contains all required data. A centralized solution was required within Employee Management Reporting System to provide a consolidated total bank reporting cube.

Project Responsibilities:

Analyse business requirements and document them.

Create hierarchies metadata in Essbase cubes

Created rules files for metadata and data load to essbase cubes

Created custom metrics for the data mapping.

Created automated extraction of metadata (hierarchy, Alias) and fact by custom SSIS package and load them to Essbase cubes through rule files, create rules file, account formulae, Create MDX scripts for custom calculations

Created maintain users and groups security, assign security and added users to groups

Create and modify Financial Reports in HFR and Smart View as per end users’ reporting need

Automated data load from source to target system and created control reports to maintain the synchronization between Source and target system.

Project 6: Delaware Life Transition (DLT) system implementation

Customer: SunLife Financial (Jun 2013 – December 2013)

Role: Hyperion Consultant

Project description: The Delaware Life Transition (DLT) Project incorporates the pending sale of Sun Life US block of Business to Delaware Life Holdings. As part of the deal Sun Life Financial need to provide a managed service for the applications and infrastructure that currently support the sold block of business for a period of 18 months; thereby, allowing the new company time to incorporate this block of business into their own infrastructure. So a separate financial reporting system is being built for Delaware Set of Books reporting.

Project Responsibilities:

Hardware sizing and as per the requirement of business.

Installation of Hyperion essbase suite in a separate server (RDBMS, Foundation services, shared service, workspace, Essbase, Financial reporting, smart view)

Create 2 Essbase ASO applications.

Extraction of metadata (hierarchy, Alias) and fact by custom PL/SQL queries and load them to Essbase cubes through rule files, create rules file, account formulae, Create MDX scripts for custom calculations

Create users and groups security, assign security and added users to groups

Create Financial Reports in HFR and Smart View as per end users’ reporting need

Created and maintained automated data load from source to target system and created control reports to maintain the synchronization between Source and target system

Project 5b: Management Information Reporting (MIR)

Customer: SunLife Financial (October 2012 – May 2013)

Role: Hyperion Consultant

Project description: This was a full blown project after the POC. This application is to measure quarterly Key Performance Indicators (KPI) which is an important and significant internal management document that summarizes the financial performance of the overall organization along with its strategic business units. The information contains general ledger information along with key financial measures not captured in the general ledger (Sales, VNB, Staffing, Source of Earnings, etc.). The principle KPI report users include the Board of Directors, Senior Management, Financial Management, and External Auditors.

Project Responsibilities:

Analyse the business requirements and map them in the new product accordingly

Create data source and Classic planning application.

Created Planning data forms, Business rules, Smart Lists, assign security.

Load metadata (hierarchy, Alias), fact, create rules file, account formulae, Create calculation scripts to clear and aggregate data, report scripts to extract data files. Developed ETL process for fact data loading from GL to Essbase applications.

Historical data migration from old OFA system to new Hyperion essbase.

Create users and groups security filters, assign security filter to groups and added users to groups

Create Financial Reports in HFR and Smart View as per end users’ reporting need

Created and maintained automated data load from source to target system and created control reports to maintain the synchronization between Source and target system

Migration of the application through LCM and security to higher environment through the standard utility.

Created custom process of historical data restatement through ODI

Create custom Security in shared services.

Created custom ETL process for historical data restatement with slowly changing hierarchy.

Project 5a: POC for Management Information Reporting (MIR) through Hyperion Planning

Customer: SunLife Financial (August 2012 – Sep 2012)

Role: Hyperion Consultant

Project description: Client was using excel spreadsheet to complete their quarterly Key Performance Indicators (KPI) to present to the higher management. To perform this activity they were capturing the GL actuals, round them in millions and input the non-GL data (Sales, VNB, Staffing, Source of Earnings, etc.). As this was a very pain full process of accumulating these data manually finds out the KPI and storing them, this POC was initiated to show then the automated way to capture this process.

Project Responsibilities:

Gather and analyse the business requirements.

Created Hyperion Planning application

Load hierarchy, fact into the application

Created customized rules calculating KPIs.

Four smart View reports developed for presenting to business

Project 4: Financial Reporting System (FRS) implementation - Phase 2 FRS Rounded Planning application

Customer: SunLife Financial (January 2012 – July 2012)

Role: Hyperion Consultant

Project description: This is a rounded actual application for SunLife Financial, which contains a high level actual financial data (in rounded millions). This is a measure of overall company performance in a very high level to the senior management. It summarizes the financial performance of the overall organization along with its strategic business units. The information contains general ledger information along with key financial measures not captured in the general ledger. These reports are used by higher management as well as external auditors

Project Responsibilities:

Analyse the business requirements and map them in the new product accordingly

Created Classic planning application.

Created Planning data forms, Business rules assign custom security

Load metadata (hierarchy, Alias), fact, create rules file, account formulae, Create calculation scripts to clear and aggregate data, report scripts to extract data files. Developed customize codes for fact data loading from GL to Essbase applications.

Converted custom business rules to calculation scripts and automated process to run them once the data load is done.

Historical data extraction and migration from old OFA system to the new planning application

Created users and groups security filters, assign security filter to groups and added users to groups

Created Financial Reports in HFR and Smart View as per end users’ reporting need

Created and maintained automated data load from source to target system and created control reports to maintain the synchronization between Source and target system.

Involved in critical defect resolutions and change requests during the project life cycle

Project 3: Financial Reporting System (FRS) implementation - Phase 1 FRS GL Actual application(s)

Customer: SunLife Financial (January 2011 – Dec 2011)

Role: Hyperion Consultant

Project description: This is a Financial Reporting System implementation project for Canada based client Sun Life Financial. As OFA is de supported by Oracle Corporation Sun Life has decided to implement Hyperion as their new reporting tool. This migration is done in different phases. First the Un Rounded Actual data migration, then Rounded and KPI process, and the last one will be Budget and Expense. This part was building an application for reporting on unrounded actual data that comes from general ledger entry, through Oracle GL this actual data comes into Hyperion Essbase and end user's reports in a formatted way

Project Responsibilities:

Analyse the business requirements and map them in the new product accordingly

Developed 3 Essbase ASO applications and 1 classic planning application

Loaded metadata and fact, created custom formulae for accounts and comparatives

Create users and groups security filters, assign security filter to groups and added users to groups

Historical data migration from old system to essbase

Create Financial Reports in HFR and Smart View as per the business requirement

Developed customize codes for metadata and fact data loading from GL to Essbase applications.

Created and maintained the control reports to maintain the synchronization between OFA and Hyperion.

Involved in critical defect resolutions and change requests during the project life cycle

Project 2: SunLife SIRIS Support & Maintenance

Customer: SunLife Financial (Jun 2007 – December 2010)

Role: Developer

Project description: This was an Oracle GL maintenance and reporting project, through Oracle Apps with the creation of a financial data repository in the form of a data warehouse to be used for reporting purpose, OFA which is a graphical tool used as a front end to present formatted data in form of a report from a multidimensional database to the end users for the Canada based insurance client Sun life Financials. The application is designed to capture the GL Actual data 4 times a day for 15 different Set Of Books, analysis of data, planning budgeting and forecasting

Project Responsibilities:

Managing metadata and hierarchies in Oracle GL as a central metadata repository and control its flow towards the downstream systems.

Create and Maintain books in General Ledger.

Maintain metadata and data load from relational database EPM reporting cubes

Resolve defects and work on change Requests related to any data synchronization issues in GL and reporting system and maintain control reports

Create reports, Financial data items, Models etc for Defects and Change Requests

Performance tuning. Testing and improvement of data load and aggregation to all the cubes in order to meet the SLA time as per contract with client.

Provide production support and defect resolution on any client issues

Project 1: OBI_241_OPENREACH_OFF

Customer: British Telecom (Feb-2007 to May-2007)

Role: Developer

Project description: Data warehousing for the customer business data repository to be used for performance management and reporting purpose

Project Responsibilities:

Providing the production support for the client

Involved in critical defect resolutions

Career Profile

Dates

Organization

Designation

30-10-2006 to Till date

TATA Consultancy Services

Assistant Consultant

Qualification

Degree and Date

University

Major and Specialization

Bachelor in Engineering, (2002 – 2006)

West Bengal University of Technology, Kolkata, India

Electrical Engineering (includes Programming languages C, Data Structure, Operating Systems, RDBMS and Microprocessors)

Status in Canada: Permanent Resident

Contact this candidate