Phani Bhusan Sahu
- Oracle EBS Financials / Procurement Analyst
- Jersey City, NJ
- Member Since Apr 04, 2023
Candidates About
Phani Bhusan Sahu
Experience Summary
§ Over 13 years of Functional and Techno-Functional experience in Oracle EBS financial and Supply chain modules on Analysis, implementation, upgrade & supporting financial applications.
§ Experienced with Oracle Financials R12 in Procure to Pay & finance modules (PO, AP, Payments, SLA, eBTax, GL, Cash Management, FA, AR, INV, i-Expense, i-Supplier, AME, workflows & Project Accounting) on both functional and technical aspect.
§ Expertise in implementation & supporting Oracle Procure to Pay and Financial modules in PO, INV, AP, SLA, GL, Cash Management, i-Supplier, i-Expenses, AME, and eBTax. Worked on ERP SOX and user access controls to enforce segregation of duties and roles. Assisted audit teams with financial reports. Exposure to OBIEE reporting.
§ Expertise in customization and design of open inbound/outbound interfaces to Oracle EBS applications. Developed Business Process, Requirement Mapping, Setup, Design and Conversion Documents (BP80, BR30, BR100s, MD050s, and CV40 etc.). Worked with systems integration teams, DBAs & business leads to model, create functional documents and deploying customized solutions for Oracle applications. Experienced with financial reporting & reconciliation with exposure to GAAP & IFRS accounting.
§ Extensive experience on configuring Payment setups & design of payment templates, AME, Accounting flow, reconciliation, SLA setups, Data access sets, FSG Reports, Web ADI, GL Mass allocation, Cross validation rules, Data Loader Tools, Data Conversions &Migrations, trouble shooting workflows, user roles, SOX Controls, MOAC & HR Security profile setups.
§ Effectively handing Oracle EBS functional issues/enhancements and running diagnostics to work with Oracle SRs to identify patches or corrective solutions. Experienced with Period close/month-end activities and quick resolution of accounting related issues. Strong expertise in writing Queries on application tables.
§ Performed roles as financial analyst, Lead Production Support Analyst, Onsite Team Leader; extensive experience in supporting Oracle Applications 11i/R12 functionally and technically with sound knowledge of backend data tables, Oracle APIs, Oracle apps architecture & program modules. Exposure to Fusion Architecture.
§ Excellent Experience in leading implementation and testing teams, documenting Business Requirements, developing solution designs and prototypes, documenting functional specification of RICEW components, User training manuals and test cases.
§ Expertise in using Oracle AIM/OUM tools and Methodologies.
§ Completed end-to-end Oracle EBS implementation for Manufacturing, Pharmaceutical, Finance and Retail industries.
§ Trained in OBIEE and SOA/BPEL from Oracle University.
§ Worked with clients from different regions and geographies like Malaysia, Singapore, Japan, UK, Europe and USA.
§ Oracle R12 Purchasing Certified Professional.
JOB PROFILE AND PROFESSIONAL EXPERIENCE:
§ Working as a Senior EBS Analyst with Toys R Us Inc. from JUN 2015 to till Date
§ Worked as a Lead Consultant-Enterprise Package Solutions with Computer Sciences Corporation from SEP 2007 to JUN 2015.
§ Worked as a Senior Software Engineer with Patni Computer Systems (Now Capgemini) from DEC 2004 to SEP 2007.
EDUCATION:
§ Bachelor Engineering in Information technology - 2004 from GIET, BPUT Orissa, India (72%)
TECHNICAL AND FUNCTIONAL SKILLS:
· ERP Modules – Oracle EBS 11i and R12(Purchasing, Inventory, Internet Expenses, i-Procurement, i-Supplier, OSN, Oracle Exchange, Accounts Payables, Accounts Receivables, General Ledger, Cash Management, SLA, eBTax).
· PL/SQL Programming.
· Application development using Oracle Forms, Reports, Oracle workflow, XML publisher.
· Oracle Applications Technical Architecture.
· Oracle Apps Sys Admin and AOL
· Operating Systems: UNIX, LINUX, IBM AIX and Windows.
· Tools: VSS, PVCS, Stat, Toad, PL/SQL Developer, SOA, BPEL, OBIEE
· Ticketing Tracking Tool: Remedy, Service now
PROFESSIONAL EXPERIENCE:
Project Title : Toys R Us Global Oracle Implementation/Support/Enhancement
Organization : Toys R Us Inc
Application : Oracle EBS 11i and R12
Modules : PO, INV, i-Proc, i-Supplier, i-Expense, AP, GL, CE, FA, SLA, AR
Role : Oracle EBS Financials and Procurement Analyst
Duration : June 2015 – Till Date
Location : New Jersey, US
Project Description:
Toys R Us has Oracle R12 implemented for its global Financials operations. They use Oracle EBS for all their financial and supply chain needs. My role involves in implementation and production support of finance and Procure to pay modules.
Responsibilities:
§ Implementation and post production support of Oracle EBS R12 Procure to Pay and finance modules; analyzed requirement and implemented AP, SLA, GL, Cash Management, AME and iExpense modules for USA, Canada, Asia and European operating units.
§ Designed solution to handle EFT payments for ACH and Electronic Wire payments. Implemented credit card transactions for iExpenses module.
§ Analyzing production issues and working on Oracle SRs to resolve post production issues related to application functionality questions, investigating problems and providing workable solutions. Conducted – CRP, Unit testing, SIT, UAT Testing on the standard and custom components.
§ Enhancement, implementation and support of new Oracle EBS rollouts for other new countries. Involved in Data conversion and designed APIs to handle data migration and conversions.
§ Fit gap analysis, As-is and To-be process documentation for new implementations.
§ Implemented i-Supplier for Canada operations. Implemented i-Expenses for US operations.
§ Provided Solutions enhance operational efficiency of Shared Service centers in US and Europe
§ Co-ordination with onshore and Offshore team.
Project Title : NYSE Euronext Implementation/Support/Enhancement
Client : New York Stock Exchange
Organization : Computer Sciences Corporation.
Application : Oracle EBS R12
Modules : PO, INV, i-Proc, i-Supplier, i-Expense, AP, AR, GL, CE, FA
Role : Oracle Lead Consultant
Duration : Sep - 2009 – Jun-2015
Location : New York, US and Amsterdam, NL
Project Description:
NYSE and Euronext has Oracle EBS as their Financials System. They maintain all their financial transactions in Oracle. They have interfaces Oracle to different legacy systems to get HR and other master data. They have 33 operating units spread across Europe, UK and US.
Responsibilities:
§ Implemented i-Expenses for Multiple countries with different Policies and business Rules.
§ Delivered Automated Invoice scanning solutions for European and US shared service centers.
§ Designing and preparing of functional specs for new enhancements in the system.
§ Designed and developed many interfaces with Third party non ERP systems.
§ Designed Master data and Transaction data conversion as part of Mergers and demergers.
§ Worked on Automation of SEPA and Non SEPA payments interfaces with European Banks.
§ Managed Rollouts, Mergers demergers for NYSE Euronext.
§ Demonstrated Oracle Financial functional capabilities to the Client for each of their business scenarios.
§ Configuration of AP, i-Expense, PO, INV, CE
§ Prepared Application Setup Documents for New enhancements and acquisitions.
§ Prepared User Training Manuals and conduct End User training to the Client’s Business Users and IT team
§ Lead the functional and technical team, mentor the consultants and track the team’s deliverables for completion of Project activities on time.
§ Provided P2P Solution to Shared Service centers in US and Europe
§ Developed business scenarios (Test cases) for testing the standard application functionality of Oracle Financial modules (GL, AP, i-Expenses, AR, FA, CM, OM, PO and i-Procurement) and customizations
§ Prepared Presentation for weekly and monthly calls with Client and Business Users.
§ Assigned tasks and tickets to team members keeping the SLA on Green status for continuous 5 years.
§ Estimated enhancement requests, Lead the cut over activities.
§ Co-ordination with onshore and Offshore team
§ Reviewing codes for changes in the system.
Project Title : NetSpend Oracle Implementation
Client : NetSpend Corporation, US
Organization : Computer Sciences Corporation
Application : Oracle EBS R12
Modules : PO, INV, AP, AR, GL, CE, FA, HRMS
Role : Technical Designer
Duration : Nov - 2008 – July 2009
Project Description:
NetSpend is one of the leading providers of re-loadable prepaid debit cards and prepaid debit card services in the United States. This project involves design, development and Customization of all R.I.C.E components in FIN, SCM and HRMS
Responsibilities:
§ Functional and Technical Designer (PO Conversion, AP Open Invoices, Supplier Conversion, Item Conversion, Employee Special Information Types Conversion)
§ Lead the i-Procurement and i-Supplier implementation.
§ Prepared MD050 and MD070s.
§ Estimated Functional and Technical Components.
§ Co-ordination with Offshore Technical Team.
§ Mentoring offshore team to develop Technical R.I.C.E.W components.
§ Reviewing codes and deliverables.
Project Title : Celgene Enterprise System Initiative
Client : Celgene Corporation, US
Organization : Computer Sciences Corporation
Application : Oracle EBS R12
Modules : PO, INV, AP, AR, GL, CE, FA, HRMS, OM
Role : Techno Functional Consultant
Duration : APR - 2008 – Nov -2008
Location : New Jersey, US
Project Description:
Celgene Corporation is a pharmaceutical company. We have implemented Oracle apps R12. Celgene has different operations other than US. It has its business in Europe too.
Responsibilities:
§ Functional and Technical Designer (UPS FedEx Integration, RFID integration, Lockbox Interface, Open Invoices Conversion, Supplier conversion, PO Conversion and Item conversion)
§ Implemented i-Procurement and i-Supplier
§ Prepared MD050 and MD070s
§ Co-ordination with Offshore team for technical component delivery.
§ Reviewing codes and technical deliverables.
Project Title : Brooks Automation
Client : Brooks Automation, US
Organization : Computer Sciences Corporation.
Application : Oracle EBS 11i
Modules : PO, INV, AP, AR, GL, CE, FA, HRMS, OM
Role : Technical Designer
Duration : SEP - 2007 – APR -2008
Project Description:
Brooks Automation Inc. creates manufacturing efficiency for the semiconductor and other complex manufacturing industries, helping customers increase productivity, lower operating costs and improves return on investment. With headquarters in Chelmsford MA, the Company is ISO 9001:2000 certified and has direct operations or offices in the United States, France, Germany, China, Israel, Japan, Korea, Singapore, Taiwan, and the United Kingdom.
Responsibilities:
§ The Oracle 11i implementation project started in Sep 07 and includes Financial and Supply Chain modules
§ Technical Designer (Lockbox Interface, Positive Pay Interface, PO conversion)
§ Preparing MD070s
§ Co-ordination with Offshore team
§ Reviewing codes
§ Developing codes.
Project Title : Maintenance Repair and Overhaul
Client : GE - Aircraft Engines
Organization : Patni Computer Systems
Application : Oracle Applications
Modules : Inventory, Purchasing, BOM, WIP, SFR
Role : Team Lead
Duration : July - 2006 – Aug 2007
Location : Bangalore, India
Project Description:
GE - Aviation is the world's leading producer of large and small jet engines for commercial and military aircraft. Maintenance Repair and Overhaul is an application used by MRO units of GE – Aviation. Purchasing and Inventory functions for all ESS shops in US (Cincinnati, Strother, Dallas, McAllen, Ontario), Hungary, Malaysia, Singapore and Japan is performed using MRO.
The scope of this project was to implement the requests made for enhancements and changes to the application.
Responsibilities:
§ Performed a role of Team Lead for Purchasing
§ Prioritized requests for software changes and enhancements.
§ Developed many interfaces with non-Oracle Systems
§ Design, Coding and Unit Testing.
§ Presented the change to GE - Change Management Board for SOX controlled applications
§ Single point of contact for the customer for Purchasing related issues and enhancements.
§ Worked on a follow the sun model to support GE Asia, Europe and North America.
Project Title : Shared Sourcing Services
Client : GE Aircraft Engines
Organization : Patni Computer Systems
Application : Oracle Applications 11i
Modules : Purchasing, i-Procurement
Role : Team Member
Duration : Feb 2005 – Jul 2006
Location : Bangalore, India
Project Description:
Shared Sourcing Services (SSS) is the single largest installation of Oracle Purchasing and i-Procurement in the world. There are over 80 GE businesses and more than 275 GE organizations using this system for their indirect purchasing needs.
Responsibilities:
· Analyzed issues and coordinated with business users for the quick resolution of the tickets within SLA.
· Developed reports using D2K
· Developed interfaces with 3rd Party non ERP systems.
· Analysis, coding and testing for new enhancements.
· Testing of the application for the code changes.
TRAININGS:
· Oracle R12 Migration