Resume

Sign in

Data Financial

Location:
New York City, New York, United States
Posted:
May 08, 2019

Contact this candidate

Resume:

Sachin Desai U.S.Citizen ac9bvj@r.postjobfree.com B.S. in comp science 732-***-****

Hyperion functional lead with 15+ years of experience in Hyperion Cloud implementation, Data Warehousing and Business Intelligence application Requirement gathering, development and support

Managed implemented in accordance with the strategy using established budget, work plans and quality standards including project plans, test plans, training and support.

Provided functional knowledge and expertise in the core EPM processes including Planning and Analysis, Consolidation and Reporting and Account Reconciliations to translate into system solutions.

Ensures that the Hyperion functional business analysts are adequately prepared to support new initiatives as they move from development to production, providing production support when necessary

Oversees correct posting of budgets to the University's financial system also designed and modified Hyperion forms and Business rules calculations to meet new planning and reporting approaches, and supports their deployment and trained additional planners

Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion Essbase 11.1.1.3, 9.X, Essbase Administration Services, ASO/BSO cube, EPMA, Hyperion Financial Reporting (HFR), Web Analysis Studio, Oracle BI Publisher, Hyperion Planning and budgeting, Hyperion Performance scorecard (HPS), HFM, FDM, Hyperion Smart View for Office, and Essbase Spreadsheet Add-In, Brio on Windows environments.

Skilled in Developing Financial report, data validation, Import, Export, Insert, Upload, Check, spreadsheet in excel-add INS and SmartView, web analysis report, OBIEE report, FDM, Oracle BI Publisher and Build/publish report to web.

Designed and developed report logic on sales analysis, planning, forecasting, and Variance analysis and income statement.

Strong background in building Financial Budgeting and Forecasting OLAP applications with Essbase and Planning

Strong background on the installation, configuration, server settings, backups, client and server installations of Hyperion products such as Essbase, Essbase Analyzer, Essbase analytics and Hyperion Reports on Windows environments

O/S

Windows XP, Window 2000,windows 2003, MS-Dos, OS/400, UNIX,MVS

Database

Oracle, DB2, Teradata

Domains

Public, Non-Profit, Banking, Financial, Brokerage, Telecom services

Others

MS Project, Visio, MS Office, MS-Word, Excel, PowerPoint

BI Tools

Hyperion Essbase 11.1.1.x/9.x/7.x/6.x,Hyperion planning 9.x/4.x, Hyperion System 9 BI+ Analytic Services, Financial Reporting, 9.x/8.x/6.x, Brio Insight, Brio Server 9.x/6.x,Brio Explorer, Oracle BI Publisher, OBIEE 11.1.1.1, Hyperion pillar, Smart View, Essbase Administration services, Hyperion shared services, Hyperion DIM Hyperion web Analyzer 9.x,7.x/6.x/5.x, Hyperion Reports 11.1.1.x/9.x/7.x/2.x, Hyperion Financial data management (HFM) 11.1.1.2, Excel Add- in, Brio 8.5.

Tools

Erwin 3.5.2, PVCS, Rational Clear Case

EXPERIENCE

NYUMC - Hyperion Project Manager – NJ (Jul 2015 thru Present)

Client is a Hyperion Essbase cloud based reporting application that primarily serves the School and Hospital finance organizations with more than 800 users.

Technology used: FCCS, Cloud Hyperion 11.2.2.4, Essbase, planning, HSF, PeopleSoft GL and HCM, Oracle 11g, Excel, Word, PowerPoint, Smartview, HFR

Implemented and manage HSF, Essbase and planning enhancement for planning, budgeting and forecasting application, and HSF application

Worked with the School of management and hospital finance Budget Office, Controller Office to identify the overall multi-year, multi-phased strategy, implementation and continuous improvement roadmap for Oracle Hyperion EPM Cloud-based products

Provided functional knowledge and expertise in the core EPM processes including Planning and Analysis

Managed implementated in accordance with the strategy using established budget, work plans and quality standards including project plans, test plans, training and support

Coordinated and integrated NYUMC budget planning processes with Peoplesoft GL and Human capital management (HCM) Payroll and IT systems

Worked with and managed outside consulting partners (Huron, Accenture, Delotte) engaged with the University to implement the Oracle Hyperion Cloud-based EPM applications

Identifies and escalated issues critical to the strategic and operational success of the implementations.

Developed and presented conclusions and recommendations to project executive and other stakeholders.

Worked closely and coordinated with PMO Training staff on development, execution and evaluation of training and change management communication programs.

Ensured the completeness and accuracy of data imported from the Peoplesoft GL and HCM into Hyperion,

Oversees correct posting of budgets to the University's financial system also designed and modified Hyperion forms and Business rules calculations to meet new planning and reporting approaches, and supports their deployment and trained additional planners

Created End to end UAT, with test cases, test plan, Test scripts with alternate flow, Data sheet, and traceability matrix on functions.

Inventive Health - Hyperion Consultant – NJ (Jun 2014 thru Jun 2015)

Client is a HFM, and Essbase based reporting application that primarily serves the finance organizations with more than 100 users.

Technology used: Hyperion 11.2.1.X, BSO cubes, Calc-Script, Forms, Business rules, Task list, MAXL, HFM, Oracle 11g, Excel, Word, PowerPoint, Smartview, OBIEE

Develops functional specifications and BRD’s related to integration with other systems to create reconciliation process of between Hyperion and GL (General Ledger) and intercompany for all internal metrics/reports

Created End to end UAT, with test cases, test plan, Test scripts with alternate flow, Data sheet, and traceability matrix on functions.

Coordinated and integrated corporation budget planning processes with PeopleSoft GL and IT systems

Ensured the completeness and accuracy of data imported from the PeopleSoft GL into Hyperion,

Oversees correct posting of budgets to the financial system also designed and modified Hyperion forms and Business rules calculations to meet new planning and reporting approaches, and supports their deployment and trained additional planners

Created End to end UAT, with test cases, test plan, Test scripts with alternate flow, Data sheet, and traceability matrix on functions.

Reduced processing of application time from 12 hours to 20 minutes by eliminating non-required dimension, optimizing load rules and calculation scripts

Participated in the upgrade project – created load rules and MaxL scripts to replace the EIS component which is no longer in the new version (dim builds and data loads)

Estee Lauder - Hyperion Consultant – NJ (Jan 2013 thru Jun 2014)

Client is a HFM, Hyperion planning and Essbase based reporting application that primarily serves the finance organizations with more than 1000 users.

Technology used: Hyperion 11.2.1.X, Planning and Budgeting, ASO/BSO cubes, Calc-Script, Forms, Business rules, Task list, MAXL, FDM, HFM, DRM, ODI, SAP BI, SAP COPA, Excel, Word, PowerPoint, Smartview, FR

Gather requirements, to developed DoorPnL (Profit and loss application for Door (POS)) for affiliates/country and Implemented Hyperion financial report (HFR) application and for Finance organization

Responsible for production support of HFM, FDM, Planning, and essbase application ( DoorPnL) application

ODI routines used to build Essbase metadata, load data, and launch calculation scripts.

3 BSO cubes by region (UK, APAC, EMEA) which calculated the allocations, and one ASO reporting cube which was fed by the 3 BSO cubes.

Participated in international onsite UAT and Go Live Support

Calculation script tuning reduced overall calculation time from 14 hours to 1.25 hours

Update essbase Outline, add member, Closed, Change rollup of member within dimension

Update actual and forecast using Smartview, Essbase lock & send, and creating file to load data.

Supporting end user support including errors, discrepancies, validations and corrections

Data loading including templates, web forms, grids and journals

Daily management of HFM for reporting and consolidations including metadata, rules and security

Migration of changes between environments using Life Cycle Management (LCM)

Support user with their Queries, Smartview, excel-add in load and Hyperion reports

Provided access to planning account and department dimension member

Added new user and group using shared services

Developed reconciliation template and update daily to reconcile planning and PeopleSoft financial system

Analysis of data for accuracy of financial measures and compliance with financial systems

Updated and create new Hyperion financial reports and provided access to user

Deployment of upgrades and patches across all environments

Vanguard - Hyperion Consultant – NJ (Jan 2012 thru Dec 2012)

Client is a Hyperion planning and Essbase based reporting application that primarily serves the finance organizations with more than 100 users. Planning provides the user with the ability to forecast next quarter revenue and expenses.

Technology used: Hyperion 11.2.1.X, Planning and Budgeting, DRM, PeopleSoft G/L, Excel, Word, PowerPoint, SmartView, FR

Gather requirements, developed data model and Implemented Hyperion financial report (HFR) application and for Finance and planning organization

Responsible for production support of Planning, International planning and essbase application consist of 3 plan types (P&L, ProjCap, Salaries) within 1 planning application

Update essbase Outline, add member, Closed, Change rollup of member within dimension

Update actual and forecast using Smartview, Essbase lock & send, and creating file to load data.

Support user with their Queries, Smartview, excel-addin load and Hyperion reports

Updated Planning outline by add, modify and remove member within dimension

Provided access to planning account and department dimension member

Added new user and group using shared services

Developed reconciliation template and update daily to reconcile planning and PeopleSoft financial system

Analysis of data for accuracy of financial measures and compliance with financial systems

Updated and create new Hyperion financial reports and provided access to user

Created PeopleSoft report using nVision

Created End to end UAT, with test cases, test plan, Test scripts with alternate flow, Data sheet, and traceability matrix on functions.

Responsible for training users on basic use of the system, new functionality, etc.

Hyperion Consultant – DC (Aug 2010 thru Dec 2011) - Client – Metropolitan Washington Airport Authority is a Hyperion planning and HPS based reporting application that primarily serves the finance organizations with more than 100 users. Planning provides the user with the ability to forecast next quarter revenue and expenses.

Technology used: Hyperion 11.1.1.3, EPMA, Planning and Budgeting, ASO/BSO cubes, Calc-Script, Forms, Business rules, Task list, MAXL, FDM, Brio, Excel, Word, PowerPoint, SmartView, FR, IR

Gather requirements, developed data model and Implemented Hyperion planning application and Hyperion performance scorecard for Finance and planning organization

Develops functional specifications and BRD’s related to integration with other systems such as interfaces, extracts, for all internal metrics/reports

Coordinates technology changes with business, Internet technology and Corporate Systems technology and other support areas, ensuring their participation where appropriate.

Analysis of data for accuracy of financial measures and compliance with financial systems

Developed SQL queries to analyze underlying data and do Data mapping for ETL using Oracle 10g

Reconciliation of Financial calculation with oracle GL and Essbase members.

Responsible for calculation account dimension measure using calculation scripts

Analysis of data for accuracy of financial measures and compliance with financial systems

Retrieve data using Brio/SQL from oracle 10g to reconciliation oracle financial calculation and retrieve data using SmartView for Essbase data.

Played major role in user requirement analysis, development and implementation of finalized dimensions and members of the ASO and BSO cubes

Automated process to dimension build rule and load data into cubes using scripts

Developed several ad-hoc report, Dashboard using Smart-view, and Brio query to analyze sales pipeline, target, revenue, budget and actual

Designed and developed report logic on GL ledger, planning, forecasting, and Variance analysis.

Simplify financial data collection, transformation and verification process

Created several ad-hoc reports using Smart view, to show performance, sales analysis, profit and loss analysis etc.

Supported Users to resolve database and security related issues

Designed and built a corporate based Hyperion Planning application.

Built Web forms for data entry, and read only forms for data retrieval.

Hyperion Consultant – NJ (April 2009 thru July 2010) - Client – Glaxo Smith Kline is a Hyperion based reporting application that primarily serves the finance organizations with more than 1500 users. Essbase (Intranet) provides the user with the ability to slice and dice data to create financial reports and drill down to detail information if the need arises.

Technology used: OBIEE 11.1.1.1, HFM, excel, Word, PowerPoint, Financial reporting (FR), IR

Gather requirements, developed data model and Implemented Hyperion planning application for Finance and planning organization

Created several reports to show actual vs. budget using BI Publisher, SmartView and Brio

Conversion of hyperion/Brio report into OBIEE financial reports.

Responsible for calculation account dimension measure using calculation scripts

Designed and developed report logic on GL ledger, planning, and rolling-forecasting.

Developed scripts to build outline and load data into cubes

Simplify financial data collection, transformation and verification process

Wrote Load rules to load the data from data mart to the Essbase cube

Created web enabled reports using Hyperion Analytics and publish it using Oracle BI Publisher.

Involved in performance tuning of cubes by implementing partitioning to reduce calc and retrieval time

Designed and built a corporate based Hyperion Planning application.

Experience in data integration between eBS GL and Hyperion, and manage data conversion process

Follow up on issues or action items identified during implementation and provide fixes

Designing and developing OBIEE Reports.

Created Business Rules with run time prompts for planning web forms (consolidation, and currency conversion).

Provided Planning/Essbase application support



Contact this candidate