Sep 2020 – Jan 2021 · 4 mos · United States

• FP&A Financial Reporting Project Implementation
• YTD Payroll Integration Implementation to drive efficient & accurate payroll planning.

May 2018 – Aug 2020 · 2 yrs 3 mos · Greater Detroit Area

• DCF Implementation for global treasury units as part of Finance Transformation.
• Cash pool End to End Implementation.
• Security Redesign & Management for Rolling DCF forecast and DCF2.0
• Managed critical FDMEE Integrations to DCF.
• Redesigned Rolling cash balance Business Rule calculation per company policy.
• POC on Metadata and Data loading on EPBCS, Knowledge on EPM Automate
• Delivered cross functional team coordination, Global treasury team support for Issue resolution
• Smartview report development for allied CF analysis between Global regions.
• Documentation of critical business rule execution steps and trained global business units.

Jan 2018 – May 2018 · 4 mos · Battle Creek, MI

• Support Period close process and resolved user issues/queries with in defined SLA
• Provided support & coordinated windows server maintenance and validated application components
• Ensure Hyperion application and Environment health are maintained 100%
• Created & updated process documentation - Archival activities, Performance tuning, Restructuring schedules
• Skills: Hyperion Planning, HAL, Excel Addin, Windows server.

Jun 2017 – Sep 2022 · 5 yrs 3 mos · United States

Jun 2017 – Jan 2018 · 7 mos · Charlotte, North Carolina Area

• Led special projects and provided critical support during patch installations and upgrades to impacted systems
• Handled controller’s helpdesk requests related to DRM, Essbase
• Supported OOB validation reports on Essbase vs OGL vs irisweb
• Executed Month end close activities
• Led testing of Primary Ledger Implementation for all WF companies
• Supported Hedge Accounting Entries testing
• Developed and updated user documentation and procedures
• Skills: Hyperion Essbase 11.1.2.4, Smartview, Dodeca, Hyperion DRM 11.1.2.4, Windows Server 2008, Action Scripts.

Nov 2015 – Jun 2017 · 1 yr 7 mos · Charlotte, North Carolina Area

• Administered Hyperion Environment and monitored the daily General Ledger, Fixed Assets and Non Merchandise critical Essbase (BSO cubes) data loads
• Supported GL Close, FA Roll report batches, books and scheduled reports
• Applied Hyperion patches and tested Smartview capabilities after patch for successful deployment.
• Designed and development of financial reports and successfully implemented FY16 spring enhancements.
• Analyzed Complex Stored Procedures logic impacting BI Publisher report
• Clarified FP&A group queries on backup, security and groups
• Tracked Business user requests in JIRA Kanban board and updated status/comments on routine
• Provided on-going maintenance and support to portfolio of Information Delivery systems utilized by 800 users globally
• Skills: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Financial Reporting, Essbase Excel Addin, Tableau 9.0.1, MAXL, Oracle BI Publisher 12c, Hyperion Smartview, JIRA KANBAN, SQL Server 2008, Windows 2008, SQL Server, Business Rules, Calculation Scripts

May 2013 – Oct 2015 · 2 yrs 5 mos · Pleasanton , California

• Responsible for all maintenance activates during critical Month End close, Forecast, LRP & Budgeting processes
• Resolved Incident tickets (Sev1 – Sev4) data discrepancies in Domestic, S&OP Essbase cubes and/or mapping issues with upstream systems
• Developed of Essbase cubes, created rule files, calc scripts. built dimensions, loaded data, restructured cubes, maintained regular backups of cube, outline, restored cube from backups etc
• Supported business owners queries related to system including actuals, forecasts, budgets, strategic plans, and other reported data
• Successful Month End Close process support to Consolidations Group
• Implemented Intl. Division for Cost center actuals project (Rule Dev. & copy to ASO cube)
• Manage integration of data into Hyperion from SAP source system
• Identify project risks, issues and avenues of mitigation on Hyperion Essbase, HFM, DRM
• Maintain, enhance and troubleshoot Hyperion business rules and calculation scripts
• Skills: Hyperion Essbase 11.1.2.4, Excel Addin, Hyperion Shared Services 11.1.2.4, HFM, FDM, Hyperion DRM, Extended Analytics, Oracle Exalytics, Windows 2008, MAXL, Calculation Scripts, Batch Scripting, Shell Scripting, Service Now (SNOW)

Apr 2013 – May 2013 · 1 mo · Charlotte, North Carolina Area

• Involved in fast paced knowledge transition to handle critical requests during incumbent resource absence
• Supported Hyperion environment and daily loads
• Manage integration of data into Hyperion from source system - Lawson
• Resolved business user Issues and shared root cause analysis (RCA)
• Skills: Hyperion Essbase 11.1.2.4, Excel Addin, Hyperion Shared Services 11.1.2.4, HFM, FDM, Hyperion DRM, Extended Analytics, Oracle Exalytics, Windows 2008, MAXL, Calculation Scripts, Batch Scripting, Shell Scripting, Maximo

Aug 2012 – Mar 2013 · 7 mos · Bentonville , AR

• Administration of both Hyperion Planning and Hyperion Financial Management applications.
• Monitored daily Essbase data loads and resolved process Issues
• Analyzed planning complex system issues and provide detailed analysis & resolution
• Meet Business users to gather and analyze requirements and provide solutions that fit within the Hyperion functionality
• Identify risks to the customer and/or Escalate to CP.
• Acknowledged/Resolved to Page, Incident, Ticket alerts, Client requests.
• End to end support of Hyperion customers through Incident, Problem and change management.
• Ensured Hyperion Product components HFM, Workspace & shared services are up and running
• Coordinate issue resolution with internal IT and external technical support providers

Feb 2011 – Aug 2012 · 1 yr 6 mos · Bengaluru Area, India

• Contributed in the development of Essbase cubes, created rule files, built dimensions, loaded data, restructured cubes, maintained regular backups of cube, outline, restored cube from backups etc
• Automated and scheduled the Meta data and data loads for all cubes (Management Reporting, etc)

Aug 2010 – Feb 2011 · 6 mos · Chennai Area, India

• Maintain user security group and role models, ensuring user access compliance
• Extensively involved in maintenance and modification of batch scripts and Meta data outline.
• Support team Incident and Problem resolution.
• Assist in Technical review and support transitions.
• Provide support on a 24x7 basis on a rotational basis.

Oct 2007 – Aug 2010 · 2 yrs 10 mos · Chennai Area, India

• The scope of GSSS applications supports many functions including Finance, Human Resources, Marketing, Sales support, Legal, Communications, Risk & Compliance and more. Also the applications of GSSS extend enterprise-wide support. The business purpose of these applications is to provide general services and support for BNYM employees who use them on a day-to-day basis for various internal operations.
•  • Led Requirements gathering, Development, Testing of Compliance-K, ILS, PQA application enhancements
• Prepare questionnaire & Understanding documents based on the requirements captured and share it with customer
• Facilitated user sessions for planning, requirements, design and testing
• Clarify the queries raised during customer connect discussions and share the minutes, document the clarifications received
•  Wrote Stored Procedures, Packages, Functions and Database Triggers.
•  Resolved defects on Compliance-K P I & P II, Invoice Logging System enhancements.
•  Deployment and go-live support.

Feb 2007 – Jun 2017 · 10 yrs 4 mos · India , USA · On-site