Jonathan Singh Email & Phone Number

Consulting for a Hospitality organization building out their NSPB solution for planning and budgeting their Revenue and Expenses by respective Hotels, Rooms, Theater etc., while leveraging workforce and productivity data information as drivers to plan and forecast for future periods.Consulted for a global firm that leverages the best in AV technology and.

Offering implementation expertise on an agile project for a Global professional services, insurance and risk management firm creating an FX Planning & Budgeting (EPBCS) application for planning at different rates by various categories of the company's entities, creating Groovy Business rules for forecasting complex Driver based Calculations for Net Income.

Austin, Texas, US

EPM Architect with Oracle Global Services Center (GSC).Led Architecture and conducted Familiarization sessions for a large healthcare services company on EPBCS out-of-the-box modules (Financials, Capital & Workforce) to facilitate the design and build approach to implement a full-stack EPM solution that replaces their existing On-Prem Hyperion EPM.

Chicago, IL, US

Designed and Built Integrations using Data Management for a large Insurance company to move data and build the corresponding dimensionality from several source systems such as Workday, Peoplesoft, Ariba, Planview, PCMCS etc. to EPBCS with multiple plan types. Also implementing Drill back capability where needed. Completed Architecting and building an.

Chicago, IL, US

Senior Consulting Associate within the Profitability Analytics group, specializing in Enterprise Performance Management (EPM) implementations. Helped architect with a company in the Bay Area that operates an online marketplace and hospitality service, managing and architecting their Tax Transfer Pricing PCMCS solution while also developing integrations.

Montréal, Québec, CA

Consulted at a leading Home Services company to build a new revenue detail planning application to support renewals & acquisitions of policies at a more granular level using Classic Hyperion Planning,providing visibility to up to 5 future yearsConsulted at a leading Global Credit Card company enhancing their Hyperion Planning model to enable them to.

Worldwide, OO

• Industry: Computer SoftwareHyperion consultant – Module lead & Developer Client Description: The client is an american multinational software company that is engaged in providing open-source software products to the.
• I’ve Designed and currently building the Planning application, Calc Scripts, Business rules and Webforms for the Subscription's model. This model involves Revenue planning based on Bookings, it involves Revenue.
• I am also the architect and functional SPOC for the Subscription's Analytic's & Reporting which is done via an Essbase ASO application. Here we report actual and planned Revenue using a waterfall logic. Some of the.

Worldwide, OO

• Project Role: Lead & Developer-Finance-Working with Hyperion Planning & Essbase 11.1.2.1Project Name: Variable Contribution Margin (VCM) –Planning Project Project Responsibilities:Worked on optimization of the Planning.
• Planning, Budgeting & Forecasting for sales based on volumes
• Allocate dollars to base level customers based on production, volumes and labor
• Allocating and recharging costs based on Inter and Intra company transactions
• Created Integration Test scripts and Shakedown document for Migration
• Created automation Shell scripts to export data for back up and import scripts to import on batch run.

Worldwide, OO

• Project Name: Future State Expense StrategyPast Project Role: Lead & Developer-Working with Hyperion Profitability and Cost Management (HPCM) and Allocations, Hyperion EPM 11.1.2.1Industry: HealthcarePast Project.
• Module lead & Developer–Allocations & HPCM, Developer–SIC (Workforce)
• Design & Create HPCM application, which involves creating the metadata using ads files in shared library, deploying it, creating the HPCM model, Stages, Assignment rules, Drivers, custom drivers, complex calc scripts.
• Built the Sales Incentive Compensation (SIC) model for Workforce. The SIC model consists of Transactional compensation and Bonus compensation. This involved creating webforms and Business rules for this model.
• Allocations had to be done over 5 Business dimensions and since HPCM (version 11.1.2.1) can have a max of 3 dimensions per stage, the remaining allocations had to be done through Essbase for the remaining 2 dimensions.
• Created Webforms for submitting driver values which will be used for allocations

Mumbai, Maharashtra, IN

My main role as a Module lead & Developer is to Design and build the Recharges & Allocations modules for Aviva Expense FPC Application. It relates to dimensionality (Creating the Planning application/Essbase Database), calculations (Calc Scripts & Business rules), web forms, reports, data sources integration, data loading, ADS preparation and security. The.

Armonk, New York, NY, US

• Project Description: The Project involves supporting Business Users in various technical issues they may be facing in Hyperion Financial management, Hyperion Planning, Essbase & FDM.Responsibilities:
• Provide enhancements, maintenance and support to the Hyperion application in MF Global
• Worked on Clarify eFrontoffice
• Worked on Maximo 6.2.1 tickets
• Administered users access (Creation / Deletion / Update) to various applications and groups using Shared Services
• Assisted users when they face issues with Smartview, webforms or Reports.

Armonk, New York, NY, US

• Project Description: The objective of the project was to develop and implement a coherent financial information strategy to create a more efficient process for gathering and reporting performance information.There are.
• Create specifications document for Hyperion reports following the latest Data model
• Create and manage 84 Hyperion financial reports
• Load Data into Planning/Essbase via webforms/excel add-in or smartview and analyze the same.
• Create Unitary Test scripts for all 84 reports and validate them for correctness.
• Migrate HFR reports and Saved objects from Dev to MT

Armonk, New York, NY, US

• Project Description: - In this project, we developed 29 reports in a short span of time. The reporting tool used was Oracle's Hyperion Financial Reporting, which is a powerful tool for designing and presenting analytic.
• Create and maintain Hyperion Financial Reports as per the Design Document.
• Create data grids in HFM and input data in appropriate intersections so as to facilitate testing and analysis.
• Create unitary test scripts for reports created by other developers.
• Test the reports created by other developers.
• Reports quality review and defects resolution.

Armonk, New York, NY, US

• Project Description: - Hyperion Performance Suite 8.3.2.4 is a Business Intelligence and Reporting tool used throughout all client locations. Hyperion currently reports out of thirteen different Data source and feeds.
• My main responsibility in this assignment was to take the KT of the entire Hyperion module of the Legacy Systems onsite from the United Kingdom and implement the same system in India.
• User Administration in Hyperion & Actuate– Creating Users and Groups based on role.
• System Administration – Creating ODBC, Output folders/directories, DAS configuration, Calendar configuration, Publishing jobs and running them.
• Report Failure resolution.
• Server Support – Administer Hyperion Core Services.

Armonk, New York, NY, US

• Project Description: - Main scope of Global Delivery Management of Information System (GD MIS) is to integrate all information from various data sources and present in the form of a single dashboard to the leadership.
• Hyperion Administration- Creating and maintaining Users and Groups based on role.
• Hyperion Essbase- Dimension Building, Loading & Maxl Scripts
• User Query Analysis using MS Excel and QMF.
• Analysis of Queries used and tables accessed.
• MS Excel Template preparation as required by customer for Data retrieval using Hyperion Essbase Excel Add-in.

Tulsa, OK, US

• Worked on Vertere Inventory Management tool for materials management at the Environment, Health and Safety Department, University of Tulsa; Maintained the population of Chemical Inventory Database with each container.
• Installed the Database and configured it with appropriate set-up procedures
• Involved in preparation of analytical and statistical reports on a weekly and monthly basis and providing the same to the various department Heads.
• Assisted Professors and Department heads in collation & maintenance of Chemical and project information; also participated in meetings conducted by them..

(Ms) Master Of Science In Computer Science, Databases, Mis & Computer Security

(Be) Bachelor Of Engineering, Computer Science

Education record