SUMMARY:

Over 12 years of referable IT experience in design, analysis, development, and more than 10 On - Prem implementations and 5+ cloud implementations of various applications in different environments.

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Principal Oracle Planning /ePBCS Architect

Responsibilities:

• Develop workforce module for clients global consulting operations.
• Develop Multi-Currency translation for EUR and USD reporting.
• Implement Data management loads for FCCS and PBCS.
• Implement Budget allocation, Top down and Consolidation Models as per client requirement.
• Developed Forms and Business rules in PBCS.
• Develop Automation using EPM Automate utility.
• Develop direct integration Between EBS and Hyperion Cloud applications.

Environment: Essbase/Planning/PBCS, Hyperion EPMA, E-Business Suite, Excel VBA

Confidential, Boston, MA

Principal Oracle Planning /PBCS Architect

Responsibilities:

• Gather requirements from Business Coordinate Build PBCS Model.
• Gather user requirements on existing excel reports and converted them to FR Studio.
• Implement Data management loads for FCCS and PBCS.
• Implement Budget allocation, Top down and Consolidation Models as per client requirement.
• Develop direct integration Between EBS and Hyperion Cloud applications.

Environment: Essbase/Planning/PBCS/FCCS, Hyperion Reporting Studio, Data Management, E-Business Suite, Excel VBA

Confidential, Philadelphia, PA

Principal Oracle Planning Architect

Responsibilities:

• Implemented an End-to-End Zero-Based Budgeting (ZBB) Planning model to Replace the existing VBA based Excel model.
• Implemented a Drive Based Budgeting Planning application with top down Allocations Business rules.
• Developed Smart Push/ Mapped Reporting automation to Transfer data from Planning to ASO reporting.
• Evaluated EPBCS migration road map for the current On-Premise environment.
• Evaluated Workforce planning with the current in-house Excel based budgeting application.

Environment: Essbase/Planning/EPBCS, Cron Scheduling, Oracle 11g, E-Business Suite, Excel VBA

Confidential, NY

Lead Oracle Planning/DRM Consultant

Responsibilities:

• Developed an End to End Hyperion Planning driver based budgeting model for Patient cost by Hospital.
• Developed workforce business rule to calculate Annual Average Patient cost.
• Developed Oracle SQL interfaces to support PeopleSoft using DRM dimension build.
• Developed automation Shell scripts for FDMEE Data loads and DRM loads in windows batch.
• Work with user groups to built a shared service security model to restrict data to meet privacy standards.

Environment: Essbase/Planning/DRM/FDMEE/FR 11.1.2.3, UNIX, Cron Scheduling, Oracle 11g, PeopleSoft

Confidential

Lead Oracle Essbase/HFM/FDMEE Consultant

Responsibilities:

• Upgrade FDQM to FDMEE 11.1.2.4 for existing data loads.
• Developed FDMEE with ODI on open Interface table to transform source data in to Hyperion environment.
• Developed Jython scripts to transform data during import.
• Developed Maxl /PowerShell automation scripts with AutoSys Job scheduling.
• Developed integrations to load data from Planning to HFM and ASO to Planning applications.
• Developed power shell scripts to automate clear load and consolidate HFM on a monthly basis.

Environment: Essbase/Planning/HFM/FDMEE/FR/Smartview 11.1.2.4, ODI 11.1.1, Windows 2008 R2, AutoSys, SQL server 2005, Oracle 11g

Confidential, Miami, FL

Lead Oracle Planning PBCS /HFM Consultant

Responsibilities:

• Developed metadata and integrations to support 6 Hybrid Planning Applications and HFM.
• Developed Hyperion Planning model to Support Franchise and ZBB budgeting process.
• Developed a Rent and Royalty model to calculate Franchise Revenue by restaurant profit center.
• Developed and trained users on FR Studio on HFM and ASO Applications
• Created ASO target reporting application with procedural MDX calculations for Multi-Currency translation
• Converted 1 application into PBCS for international user community.
• PBCS job scheduling using EPM Automate utility.
• Integrated SAP GL for PBCS data and metadata synchronization.
• Maintained Metadata using EPMA later converted to DRM.

Environment: Essbase/Planning/HFM/FDMEE/FR/Smartview 11.1.2.4, ODI 11.1.1, Windows 2008 R2, AutoSys, SQL server 2005, Oracle 11g

Confidential, Mahwah, NJ

Senior Oracle Planning/FDQM/ODI Consultant

Responsibilities:

• Developed a long term incentive planning model (LTIP) to calculate employee earning based on vested dates.
• Used Financial Data Quality Management (FDQM) in building Workflows, Mappings, Locations, Import Formats, Import scripts, Control tables to load Monthly data in Planning Applications.
• Used ODI to transform Morgan Stanley LTIP data feed into FDQM and EPMA dimension libraries.
• Configuring ODI 10.1.3.5 with MS SQL server master and working repositories with local scheduling agents.
• Created automation scripts to load data and metadata using ODI, FDM and EPMA using MAXL batch scripts.
• Created Calculation Manger Business rules and calc scripts to support budgeting and forecasting models.

Environment: Essbase/Planning/HFM/Smartview 11.1.2.2, ODI 10.1.3.5, Windows 2008 R2, Oracle General Leger release 12.

Confidential, Manhattan, NY

Senior Oracle Planning/FDMEE Consultant

Responsibilities:

• Install and configure FDMEE sourcing SAP ECC 6.0 to a Planning target application on Linux.
• Configure ODI knowledge modules to configure open interface with FDMEE
• Metadata management using EPMA interface tables and ADS files.
• Configure ODI Open Interface adaptor to source Exadata in FDMEE
• Create and maintain automation using MAXL and shell scripts.
• Develop SQL interfaces to source Exadata in to Exalytics cubes.
• Performance tuning with Exalytics configuration properties.
• Migrate application objects between DEV,QA, and PROD environments

Environment: Hyperion Essbase 11.1.2.3, Planning 11.1.2.3, ODI 11.1.3 Hyperion Financial Reports 11.1.2.3, Smartview Add-in, MS Office 2010, Shared Services, EPMA 11.1.2.3, ODI 11..1, FDMEE 11.1.2.3, Redhat Linux 5.0, Bristlecone Adaptor with SAP JCo 3.0.x

Confidential, Manhattan, NY

Lead Hyperion Consultant

Responsibilities:

• Administer day to day activities maintain shared services security and LCM migrations
• Rebuild Essbase studio schemas to support changes and additions to the data warehouse.
• Design and architecture of EPM 11.1.2.x Environment, hardware requirement scoping, Installation and configuration
• Developed ASO and XOLAP cubes to consolidate actuals and Plan data for reporting.
• Developed Hyperion Planning applications to forecast Same Store Sales and comparable sales.
• Developed SQL queries to import data and metadata from data warehouse into Essbase ASO/BSO.
• Developed Business rules to calculate forecast based on user assumptions.
• Facilitated the offshore team during close and month end activities.
• Performed root cause analysis to the team on data and metadata discrepancies.

Environment: Essbase BSO 7.1.5, Essbase Calculation script 7.1.5, Excel VBA 2003 repots, Visual Basic 6.0, VB Scripts, SQL 2005, Oracle 9, Essbase 11.1.2.2 XOLAP, Oracle Essbase Studio 11.1.2.2, Hyperion Planning 11.1.2.2

Confidential, Secaucus, NJ

Sr. Hyperion Administrator/ Essbase Developer

Responsibilities:

• Created ASO cubes using Analytic Integration Services from SQL stage.
• Wrote MDX member formulas to calculate measures on ASO cubes.
• Created load rules to load flat files and SQL tables.
• Modified existing calc scripts and Business rules on the planning cubes.
• Loaded Members to planning using HAL integrations.
• Exported data from planning to PeopleSoft using report scripts and JExport function.
• Created dashboard using Hyperion Reports and Web Analysis.
• Configured MSAD using LDAP for external authentication
• Migrated planning /HFM application and synced them with all environments on a monthly basis.
• Execution of monthly reporting, quarterly forecast and annual planning processes ensuring key deliverables are submitted
• Installed software patches when available.
• Provided technical support 24/7 and responsible for end-user training with dashboards.
• Monitored and troubleshoot overnight data refresh jobs. Also created jobs using MAXL and windows batch scripts.

Environment: Hyperion Essbase 9.3.0, Hyperion Web Analysis 9.3, Essbase 9.3, Hyperion Reports 9.3, HFM 9.3, SmartView Add-in, Excel Add-in, MS Office 2003/2007, Visual Explorer, Analytic Integration Services 9.3, MS SQL Server 2005, and Windows 2003 Server, Planning 9.3, Interactive Reporting 9.3, Shared Services, ODI 11.1.3