Project Manager Oracle
Resume:
Akshay Nagoree
*******.******@*****.*** *** Meadowridge Dr
Aurora, IL 60504
Main Skill Areas:
> Hyperion System 9 Products
o FDM (Upstream Weblink DM), HFM, Planning, Essbase, BI+
Reporting Studio, HAL, SmarView and Essbase Excel Add-On,
Shared Service, Workspace, MDM.
> Oracle EBS
o Project Costing, Project Billing, General Ledger, Application
Desktop Integrator, Account Payable, Account Receivable, Fixed
Asset, Purchase Orders, Order Management, Inventory, Bill of
Material, Work In Progress, Cash Management, Oracle Alerts,
System Administrator.
Achievements:
> Enabled business to close Hyperion Operation book in 2 business days
and Hyperion Corporate book in 5 business days, from original close of
45 days by automating and enabling business users to load sub-ledger
data using FDM applications to nine Planning and HFM applications.
> Successfully led sixteen FDM, one HFM, nine Planning and three Essbase
applications upgrade to Hyperion System 9.
> Identified and Successfully led development of nine self-service web
enabled integration application using FDM application for business
users that enabled them to initiate or schedule data movement between
Hyperion HFM, Essbase/Planning, Oracle EBS and non-Oracle sub-ledgers.
> Represented on Hyperion FDM Advisory board to review future Hyperion
FDM enhancements and provide feedback before final release.
> Presented Hyperion self-service web Integration application at NCOAUG
Aug 2008.
Professional Experience:
CODESOFT Inc., Chicago, IL
Jul 2009 - Present
Hyperion Integration Lead
Led Integration solution for Hyperion Financial, Sales and Margin
applications for Abbott Labs.
> Re-design Integration architecture for four Sales planning and Six GL
planning applications using FDM integration solution.
> Brought FDM application to manageable level by reducing FDM locations
from 2554 to 198, data loads from 415 to 6, mappings from 25000+ to
few hundred and custom scripts from 15 to 3.
> Automated inbound and outbound FDM data loads.
> Coordinate data reconciliation with business users.
> Uploaded application metadata outline using HAL and load rules.
Hyatt Corporation
Sep 2000 - Jun 2009
Hyperion/Oracle EBS Manager
Maintained and supported Hyperion System 9 and Oracle EBS system.
> Installed and configured FDM application on four production and three
QA and three Development servers.
> Upgraded FDM application and databases from version 7.3 to 8.1 and
later from 8.1 to 9.3.1.
> Created and administered sixteen FDM applications and maintained HFM
and Essbase adaptors
> Maintained mapping, security access and report for FDM application.
> Updated FDM's load actions to embed Essbase's clear and consolidation
calc script. Also updated FDM's export action to optimize data load
file for Essbase data load. Also incorporated Load rules in FDM
application.
> Automated more then 125+ data stream flowing through FDM to HFM and
Essbase/Planning application.
> Improved Operation and Corporate's actual close, Budget/Forecast
process by identifying and converting manual process to auto data load
process for more then 125+ data stream; 41+ calculation, translation
and consolidation processes for HFM application.
> Created, managed and migrated Essbase/Planning dimensional security,
metadata, data, HFM and shared service provisioning between
production, QA and dev environment.
> Also maintained HFM Metadata, Securities, Member Lists, Load rules and
data.
> Implemented new integration processes for HFM and Essbase/Planning
applications using FDM, HAL, Report Script, Load rules and HFM APIs.
Maintained and enhanced 36 existing integration processes for HFM,
Essbase/Planning and Oracle EBS application.
KozyHome
Nov. 1999 - Sep 2000
Oracle ERP Lead
Implemented Oracle Financial and Oracle Distribution modules for B2C
Company.
> Configured Inventory, Order Management, Purchasing, EDI and Alert for
Multi-Org configuration to implement Drop-Shipment process.
> Integrated B2C Web application with Oracle ERP for back office order
processing and process cash receipt for customers by creating ASN, PO
and AR Lockbox interfaces.
> Configured ADI for end users to generate and publish FSG reports.
> Designed and developed FSG statements to help analyze business cash
flow.
Handleman Company
Jan. 1999 - Oct 1999
Oracle Financials Tech Lead.
Converted Legacy Financial system to Oracle Financials.
> Configured Multi-Org AR setups for Canadian and US operating unit.
> Converted more then two million historical Invoices from Legacy system
to Oracle AR.
> Converted historical receipts through Auto Lockbox process.
Drasser-Rand
Aug 1998 - Dec 1998
Oracle Financials Implementer
> Created Inbound and Outbound Interfaces for Account Payable and
Purchasing to interface with legacy system.
> Created check reconciliation process to reconcile checks with bank
statement.
> Developed Interfaces to convert Open AR Invoices.
> Created custom reports and form to correct AR Invoice during
conversion process.
GE Aircraft Engine.
Jul 1996 - Jun 1998
Oracle Manufacturing Implementer
> Converted legacy purchase orders, Receiving, inspection and
attachments into production tables of Oracle purchase orders.
> Created custom reports for Purchase orders and Receipts.
Education/Training:
> University of Mumbai - BS with Major in Computer Engineering
> Hyperion Report Training - Apr 2003
> Hyperion System Administrator Training - Nov 2003
> Hyperion MDM - Aug 2007
> OAUG Collaborate 2007 - Apr 2007
. IT specialist with more than 15 years of experience as Project Manager
and Tech Lead.
. Experienced in full life-cycle FDM project development including
Requirement gathering, Design, Development, Testing, production
migration and user Training.
. Experience in Hyperion System 9 installation, upgrade and migration to
hosting service provider.
. Specialized in leading development of end to end integration between
Planning/Essbase, HFM and Oracle EBS using FDM, HAL, report script,
load rules, and HFM SDK API's.
. Solid experience in supporting Actual Close in consolidation system
and facilitate Budgeting and Forecasting in Planning and Essbase
applications.
.
Contact this candidate