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 ongoing advisory services to transform businesses. Jonathan is building their NSPB system for Management Reporting, Budget Planning and C-Dashboard reporting.Consulted with a Global Non-profit Organization to enhance their workforce solution such that the loading of data from ADP into the Planning system via Data Management is automated, to create new Business rules in order to translate Salary amounts from the source currency into the Budget currency for each entity and then calculate the benefits, merits & total salary accordinglyConsulted with an organization that delivers access to training, content products, and certifications which serves over 900+ content-driven organizations across the globe. Jonathan implemented NSPB integrating NetSuite data with NSPB and configuring the out-of-the-box workforce module and the Income Statement and Balance Sheet statements. Templates were also provided so that the users can submit data and review their forecasted numbers. The required NSPB Guide, Integration guides, and SmartView guide were also provided.Consulted with a Clinical education firm to include new Business logic and enhance their NetSuite Planning and Budgeting (NSPB) solution while also addressing performance issues. Jonathan created new Rules for Programs & Class based planning which also involves new Saved Searches on NetSuite, creating and updating Data Management jobs to integrate and load the new Saved Searches, and creating new Drivers used in Calculation rules and webforms to calculate COGS using Gross Margin % and determine Forecasted Revenue more accurately based on pipeline.

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 Before Taxes (NIBT) and Need to make (NTM), Topside Allocations, Overrides, Currency Conversion, Triangulation, and Adjustments while also consulting on their existing Profitability and Cost Management (PCMCS) applications.

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 applications.Consulted with a hospitality company based in the UK architecting a NetSuite Planning & Budgeting (NSPB) Premium solution providing Weekly planning and forecasting capabilities for Revenue & Expense, Assets & Compensation planning. Reporting & dash boarding capabilities of Income Statement , Balance Sheet and Cash Flow are also being implemented.Consulted with a Smart Signage company based in Switzerland providing architecture & implementation expertise on a NetSuite Planning & Budgeting (NSPB) cloud solution for Revenue & Expense Planning delivering the business with required KPIs , Annual Recurring Revenue (ARR) & Predictive Planning features that come with Oracle's EPM NSPB Standard package

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 Enterprise Planning Solution using EPBCS for a large Gas and Energy company in New Jersey to replace several excel models producing an income statement , balance sheet , revenue requirement and building complex depreciation calculations using Business rules & Groovy as well while also managing offshore resources.Consulted with an athletic apparel company developing dynamic and higher management dashboards & visualizations using Oracle Analytic Cloud (OAC) - Data Visualizations (DV) sourced from EPBCS and OAC Essbase systems while providing training and resources for the same.Worked on a health check for a Life-Sciences firm on their EPBCS cloud systems to analyze and provide advice on their performance issues and integrations with AWS and Data Management. Deliverables were a presentation of Findings with Short term and Long term solutions.Worked with an insurance company in upstate New York. Migrating their Planning and HPCM application to cloud services PBCS and PCMCS respectively while also optimizing & enhancing the applications. Also converting the original PeopleSoft data extracts to now pull the source data from Oracle Cloud ERP GL using Data Management and BI publisher reports created from SQL data models to pull the latest journal entries tied to paid and unpaid data and integrate with PCMCS

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 using Data Management and REST to transfer data across disparate systemsConsulted at an American Payment Processing and Technology provider implementing new solutions on HPCM and relational systems using Agile methodologyConsulted at an American video game publisher in California creating new allocation rules and drivers for their existing profitability Models in their HPCM Standard Model and Planning system also working with ODI, Oracle SQL developer to create new packages, integrate and implement methodology changes and new requirements needed for specific categories of games. Consulted at a large bank in the Midwest enhancing their existing profitability Models in Hyperion Planning and HPCM Standard Model and also designing & implementing new methodologies for a scalable solution of their current models of HPCM and as well as on the latest version of HPCM Management ledger for a dynamic and more standardized modelConsulted at an American insurance company replacing their existing profit and loss and allocation models which is currently built in Excel and MS Access with Oracles' Cloud services PBCS and PCMCS. I was involved with the design and implementation of the PCMCS model which has complex many-to-many allocations, creating Driver Pooling in Data Management (FDMEE) and the building of PCMCS allocation Rules for an efficient allocation solution on the Cloud. This is possibly the first PCMCS solution implemented ever worldwide and I was privileged to be part of it.

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 analyze their revenue from a transactional currency to functional and reporting currency level incorporating additional dimensionality, building calculations & webforms and also automating their processes using PowerShell.Developed a POC for an American global corporation that sells business services and document technology products implementing a HPCM - Management Ledger to build a solution that will enable reporting & analysis for Operating Income P&L lines by contract & capability, with indirect costs fully loaded through meaningful allocations, attributions, and adjusting entries.Consulted at a leading Custodian Bank in Boston, implementing a HPCM - Standard Profitability Model to build a Driver based model and calculate client and product profitability, global operations cost per unit and a global operations charge out model to client and productConsulted at a multinational financial Service corporation used by the 25,000+ financial institutions that issue its branded Credit & Debit cards implementing HPCM to allocate Costs to Divisions and Geographies based on Operating Expense and Product Revenue.Consulted at a leading Investors services company, redesigning and rebuilding their current PandL & compensation model to improve system performance and also to build new desired functionality in their EPMA Hyperion Planning applications.Consulted for over a year at a Global professional services firm providing advice and solutions in risk, strategy and human capital. Working with Hyperion EPMA in creating eight applications comprising of workforce , allocations, and revenue & expense Planning applications.

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 enterprise community.Project Description: In this project we are focused on implementing a new Planning and Analytics solution. These will be delivered through a standardized budget process and enhanced sub-ledger analytics supporting global assumptions and driver-based, where applicable. The Project has three modules:1. Training2. Services & Employee3. SubscriptionThe client would like to implement a Planning & Analytics solution for the above three modules. Role: Module Lead & Developer (Subscription - Hyperion Planning & Analytic's via Essbase ASO)Responsibilities:• 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 Allocations, Planning and reporting of Revenue based on various percentages and margins that are planned monthly and Quarterly.• 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 reports built are Firm vs Risk revenue, Long term vs Short Term Revenue, a Flash report of all the Billings and key Revenue accounts for the higher management etc. I've created and designed the application and the MDX formula required.

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 application, Calc Scripts, Business rules and webforms for the following requirements: • 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 Responsibilities :• 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 to facilitate custom drivers, creating genealogy and driver templates.• 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; this involved creating Calc Scripts, Maxl scripts, and Batch scripts.• Created Webforms for submitting driver values which will be used for allocations• Created Rules file to load data into Essbase• Created tables in Oracle DB to Import staging tables into HPCM.• Migrated Global Artifacts such as HPCM metadata, HPCM application, Essbase allocation artifacts, Data forms from Dev to QA using Shared services and LCM.• Create Unitary Test scripts for all Allocations and analyzed the data using Lookups and pivots in MS Excel.• Provided suggestions and appropriate enhancements for the Allocation applications and prepared requirements for the same

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 following three Recharge Categories are implemented:1. Centralized Cost (Facilities and multi-function devices)2. Intra Business Unit Costs (Cost charged from one cost centre to another within a business unit)3. Inter Business Unit Costs (Costs charged between business units)Allocation’s involves distributing the costs to Product and Channel based on the Allocation ratio loaded for each Product and Channel combination.

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.• Raise Service requests (SRs) and RFCs on Oracle On Demand (OOD)• Created weekly reports through Shared Services.• Perform Monthly Cube Build Process :1. Take a Level Zero Export of the prior month’s data2. Extracting data from HFM using Extended Analytics to Oracle database3. Creating Start schemas to define Essbase Properties4. Deploying Essbase Cubes from Metaoutline5. Aggregating the Essbase Cube6. Validating the data from Essbase application

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 three Hyperion Planning solutions applicable to the scope (collectively, the “Planning Scope Components”):1. Local Cost Planning2. Group Planning (including Long Term Volume Forecasts & Cash flow)3. Capital PlanningThe fourth area of scope, (the “Actuals - HFM Component”) is Actuals Consolidation & Reporting.Responsibilities: • 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• Test Hyperion Planning Applications (Group, Local and Capital). Elements tested were:1. Business rules & Calc Scripts2. Webforms3. Tasklists4. Work flow and5. Security (Access control)• Client side (UK) UAT consultant for Planning Applications.• Post Production and end user support.

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 data. We designed traditional financial report formats such as cash management reports, profit and loss statement reports, Variance reports etc. Using HFM we entered data via data grids at the appropriate intersections which were used to test the reports for correctness. Detailed unitary test scripts were created to facilitate report testing.Responsibilities: • 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.• Check-in documents into RPM for verification• Check-out documents to edit/analyze required documents

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 data into one Data source. Hyperion is deemed as a business critical application. The Project involved administering the existing Hyperion system.Responsibilities: • 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.• Resolving helpdesk tickets – Handled Sev1, Sev2 and Sev3 tickets independently.• Ensuring critical reports are delivered by 11 am.• Adding new reporting databases.• Desktop ODBC and OCE support.• Hyperion Reports Optimization.• Created Dashboard in Hyperion Intelligence Designer for Hyperion Administrators.• Migration and Rehosting of Hyperion.• User training.• Preparing Application Information Document (AID) and Application Support Control Plan (ASCP) KT documents.• Gave KT to colleagues.

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 team. Information such as Employee utilization, Delinquency, Bench, Finance and other project related information to provide accurate information to the management. The leadership team can use this information to effectively manage business and to make vital business decisions.Responsibilities: • 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.• Gathering Client requirements.• Led the team in the implementation of SL/C Dashboard and took personal responsibility and Ownership in bringing it to completion. The OPAL methodology was used for this implementation.• Preparation of Employee Utilization Reports and Industry Billed Hours. • Preparation of various project work products such as BRS, WPI, WSRs, Estimates, MOMs, GDMIS User manual, ASCA and Internal Audit Documents.• Maintaining Documents and issues in RPM.• Developed various reports using “Arcplan” reporting tool.• Involved in Unit Testing.

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 of chemical or product present on the campus.• 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