Oracle Fusion Cloud Financial Functional Consultant Resume
Phoenix, AZ
SUMMARY:
- Having Over 17 years of total experience in the field of Oracle ERP (Oracle Fusion Cloud Financials & PeopleSoft FSCM) Applications Design, Development and Upgrade / Implementation.
- Strong Oracle Fusion Cloud Financials Functional consultant with about 2 years of extensive experience in Oracle Fusion Cloud Financials Application Implementations & Support.
- Well experienced in 2 full life cycle Implementations of Oracle Fusion Cloud Financials.
- Strong PeopleSoft Senior FSCM Consultant with 15 years of Extensive experience in Implementations / Upgrades/Support.
- Very well experienced in 4 full life cycle Implementations and 8 Upgrades of People Soft FSCM modules.
- Subject matter expert within the Oracle finance applications Domain which includes GL, AP, AR, FA, PO and Cash Management.
- Well Experienced in Oracle cloud Enterprise structure design, chart of accounts design.
- Very Good Experience on Fusion Functional Setup Manager (FSM).
- Well Experienced in Oracle finance cloud system configurations, Data Conversions and testing covering GL, AP, AR, CM, FA and PO modules.
- Expert in integrating Oracle Cloud Services (interfaces, conversions and creating applications using FBDI).
- Good experience in Oracle Data Integrator (ODI) for data migrations from Legacy systems to Fusion finance interface tables.
- Having Good Experience on Oracle Fusion Cloud Data Conversion using File based Data Imports (FBDI) and Spreadsheet uploads.
- Well Experienced in creating reports using BI Publisher/ Smart View/ FRS/ OTBI.
- Experience in BPM activities like workflow approval rules and approval group configurations as per business specifications.
- Very Good Knowledge on Oracle Fusion Application security Console (IDM & APM).
- Expert in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
- Very good experience in Oracle Application Implementation Methodology (AIM).
- Ability to lead and articulate end - to-end business processes and the key integration.
- Excellent analytical and problem solving skills.
- Excellent customer interaction skills.
TECHNICAL SKILLS:
Applications: Oracle Fusion Financials Application R11, R12, R13, PeopleSoft FSCM 7.x, 8.0, 8.4, 8.8, 8.9, 9.1, 9.2 / HCOM9.1
Products Tools: People Tools, BI Publisher, OTBI, SQR, Crystal Reports, n Vision, SQL Loader, ODI, FRS, Smart View
Languages: Java, ASP, C, Peoplecode, PL/SQL,
Databases: Oracle 7/8/9i/10g/11i/12C, Essbase
Operating Systems: Windows NT/2000/XP, UNIX
Modules : General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CM) and Purchasing / Procurement.
Modules: Account Payables (AP), Account Receivables (AR), Billing (BI), Purchasing / Procurement (eProc /PO), Travel & Expense (T&E), AM, General Ledger (GL), Project Casting, Contracts, IN, OM, and Cash Management / Budgets.
PROFESSIONAL EXPERIENCE:
Confidential, Phoenix, AZ
Technology: Oracle Fusion cloud financials (GL, AP, AR, CE and FA) R12
Oracle Fusion Cloud Financial Functional Consultant
Responsibilities:
- Requirement gathering with the business owners and prepared the necessary documents.
- Understanding the existing Legacy system functionality.
- Configure Fusion Functional Setup Manager.
- Define Applications Configurations.
- Configuring Fusion Sub ledger Accounting (SLA)
- Configuring Fusion Payables - Supplier Model, Create Payment Term, manage invoice options and payment options
- Configuring fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request.
- Configuring Fusion Receivables - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class.
- Configuring fusion payments - Receivables - Payments for funds Capture Activities, Setting Up Funds Capture for Receivables
- Prepared BR100, MD50 and TE40 documents.
- Performed CRP1, CRP2 and UAT testing with business and get the signoff
- Tested all functionalities in financial modules.
- Troubleshooting Journal sub ledger transfer and journal import issues
Confidential
Technology: Oracle Fusion cloud financials and Purchasing (GL, AP, AR, FA and PO) R12
Oracle Fusion Cloud Financial Functional Consultant
Responsibilities:
- Requirement gathering with the business owners and prepared the necessary documents.
- Involved in Conducting the CRP sessions for PO, Accounts Payable
- Involved in documenting fit/gap sessions, and system configuration.
- Involved in Configuring the System for PO, AP, FA and GL.
- Configuring GL - Create Accounting Calendar, Create/Enable Currencies, Create Chart of Accounts, Create Primary Ledger, Setup Ledger Options, Create Legal Entity, Complete Primary Ledger Definition, Open GL Periods.
- Configuring Payables - Create Business Unit Locations, Create Business Units, Assign Business Unit Functions to Business Unit, Create Legislative Data Group, Create Procurement Agents, Invoice Options Configuration, Payment Options Configuration, Create Payment Terms, Create Distribution Sets, Create Supplier.
- Configuring FA - Create Value Sets for Category KFF, Create Value Sets for Location KFF, Create Value Sets for Asset Key KFF, Create Category KFF Structure, Create Asset Calendar, Create Asset Book, Create Asset Categories.
- Supporting the Business users to resolve Fusion Financial application related issues including data quality and system performance.
- Deliver Functional Design documents for the Customizations, Interfaces and Reports.
- Experience in writing and reviewing detailed test scripts for System, Integration, and User Acceptance Test Phases.
- Worked with several end-users to better understand and improve navigations through various forms using forms personalization.
- Working with Oracle support for Oracle functionality issues by raising Service requests
- Worked with business units to develop best practices and optimized processes.
Confidential
Technology: PeopleSoft FSCM (eProc, PO, AP, BI, AR, GL, CA, PC, EX, AM, IN, OM) 9.2, Windows NT, UNIX, Oracle11i, SQR, People Tools 8.53
PeopleSoft FSCM functional Consultant
Responsibilities:
- Provided the end user training to Confidential users on Contracts, PC, eProc and EX modules.
- Preparing Data conversion/SIT/EUT/UAT schedules, and planning the resource activities.
- Scenario Scripts preparation for each FSCM module based on Confidential affiliate business requirements.
- Handling the FSCM modules Data Conversion / Data Load activities for each affiliate.
- Handling the Confidential user’s production Issues after each affiliate go-live.
- Analyzing the Fit-Gap docs to implement the FSCM for Confidential APAC affiliates.
- Defining the processes for data extract from Legacy system to Confidential PeopleSoft system.
- Proposing the functional solutions for each affiliate
- Responsible to providing the solution & deliver all the Functional Objects.
Confidential
Technology: PeopleSoft FSCM (AP, AR, BI, GL, PC, PO, EX, AM) 9.1, Windows NT, UNIX, Oracle11i, SQR, STAT, People Tools 8.52
PeopleSoft Finance functional Consultant / coordinator
Responsibilities:
- Managing the KT sessions about the Client's FSCM modules from On-Shore to Off Shore.
- Manages specifications and developments for enhancements.
- Responsible to delegate the development tasks to the Off Shore support teams.
- Handled the Data Conversion activity from the Customer Legacy system (MTA) to PeopleSoft Accounting system.
- Responsible to take care of Support issues & development of change requests.
- De-customized the VERTEX tax integration & implemented the VAT.
- Works on almost all the important process & Programs in Purchase Module like PO AUTO SRC, PO POCALC, PO POCREATE, PO RECVLOAD, CS CNTRCT WF, and POPO005 Etc.
- Tested the functional issues related to EX TRAN PRCS process for the Employee payments.
- Develop and maintain Support activity's Weekly Dash boards
- Taking care of the US nightly jobs Monitoring activity.
- Fixing all the 3rd party data integration issues.
- Design the Customized PC marketing advisory budget functionality.
Confidential
Technology: PeopleSoft HCOM (WFA, Absence, Recruitment) 9.1, Windows NT, UNIX, Oracle10g, Phire
Delivery Group Manager
Responsibilities:
- Responsible to implement the PeopleSoft WFA, Absence modules for Mphasis
- Handle the production architecture
- Manage multiple environments & technical team size of 20+ work with business team in order to gather the requirements during requirement gathering phases
- Initiates the PAKB (Project Approval Kill Board) for any new projects within the CIO organization for all the PeopleSoft related projects
- Successfully initiated many new enhancement projects keeping the interest of the organization in order to simplify the business processes (BPR), Performance, stability & usability related works has been under taken.
- Coordinates, manages priorities, and challenges the request from business teams.
- Proposing the functional and technical solutions.
- Delegates’ development tasks to the development team.
- Manages customizations, enhancements and interfaces implementation.
- Managing the technical studies.
- Makes development and unit testing based upon Business team specifications
- Manages production migrations according to project plans.
- Develop and maintain Management Dash boards
- Manages the communication to end user and support comity.
- Centralize/perform first analysis of users’ requests/issues.
- Guiding the team to solve the technical Issues.
Confidential
Technology: PeopleSoft FSCM (PO, AP, GL) 8.9, Windows NT, UNIX, Oracle10g.
Senior PeopleSoft Finance Functional Consultant.
Responsibilities:
- Conducted the Functional testing for the physical Inventory data which comes to the GL allocations.
- Conducted the Functional testing for the static’s flow management data which comes into PS GL from the statistic Interfaces
- Performed the functional testing on Client PeopleSoft Invoice Management Application to manage all the Potential disputes between the Vendors & Confidential by sending all the necessary documents/data to the third Party Commercial System.
- Written the Test cases for the GL allocations Physical Inventory data.
- Written the test cases for the Static’s flow Management data which comes into PS GL from the statistic Interfaces
- Performed the Functional testing on Client's PeopleSoft Accounting system by supplying all the invoices which are ready to Pay.
- Performed the functional Testing on Indian TAX components in Client PeopleSoft Account system.
Confidential
Technology: PeopleSoft Expenses (EX, PO, AP, GL) 8SP3 - 8.9, Windows NT, Unix, Oracle 9i /10g, Sqr, and Crystal Reports 8, People Tools 8.19/8.47.01, ITE Soft.
PeopleSoft Finance Manager
Responsibilities:
- Manages specifications and developments for enhancements.
- Coordinates, manages priorities, and challenges the request from support teams.
- Proposes functional and technical solutions.
- Delegates some development tasks to the local support teams.
- Manages customizations, enhancements and interfaces implementation.
- Manages developments required for Expense projects.
- Manages technical studies when required.
- Makes development and unit testing based upon project team specifications
- Manages production migrations according to project plans.
- Develop and maintain local queries.
- Manages the communication to end user and support comity.
- Centralize/perform first analysis of users’ requests/issues.
- Guiding the team to solve the technical Issues.
- Manages the Team Work Load
- Handling the users.
- Taking care of the Support issues & development of change requests.
Confidential
Technology: PeopleSoft FSCM (AP, AR, BI, GL, PC, PO, EX, IN) 8.9 - 8SP3, Windows, NT, UNIX, Oracle9i, SQR, and Crystal Reports 8, VSS, People Tools 8.47.01.
PeopleSoft Financial Functional Consultant
Responsibilities:
- Designed the Retrofitting approach for all the On-line & Batch process objects.
- Guiding the team to solve the functional Issues.
- Done the Upgrade of PeopleSoft FSCM modules from PeopleSoft 8sp3 to PeopleSoft 8.9sp1.
- Identified the custom processes which can be de-customized in 8.8sp1
- Resolved the various functional issues and bugs at different stages of Upgrade process.
- Done the functional Testing for all On-line & Batch process objects.
Confidential
Technology: PeopleSoft FSCM (AP, AR, BI, GL, TR) 8.8, Windows NT, UNIX, Oracle9i, SQR, and Crystal Reports 8.
PeopleSoft Financials Functional Consultant
Responsibilities:
- Identified the custom processes which can be de-customized in 8.8sp1
- Done the Upgrade of Peoplesoft Financials and Billing from Peoplesoft 7.53 to Peoplesoft 8.8sp1.
- Tested the TR BSP LOAD process for the bank statement import functionality (MT940 file format)
- Prepared the user Navigation testing document for AR, BI, and CM modules.
- Resolved the setup related issues and bugs at different stages of Upgrade process.
- Designed the new Pages to run the processes from web.
Confidential
Technology: PeopleSoft FSCM (8.4), PeopleSoft CRM (8.8), Windows NT, UNIX, Oracle 8i, Sqr, Crystal Reports 8 & Stat
PeopleSoft FSCM functional Consultant.
Responsibilities:
- Involved in Preparing the Interface strategy document
- Designing Application Security
- Designing and setting up new Roles, Permission Lists, Process Groups and other security related Objects.
- Planning for setting up new users and attaching Roles based on requirement study.
- UAT Testing Support - Financials Security related issues
- Establishing Process for Security Change Requests, Enhancement Request after Go Live.
Confidential, Atlanta, GA
Technology: PeopleSoft Financials (8.4/7.5), PeopleSoft SCM (8.4/7.5), Windows NT, UNIX, Oracle 8i, Sqr & Crystal Reports 8.
PeopleSoft Techno/Functional Analyst
Responsibilities:
- Testing of various transactions and fixing of various issues and bugs at different stages of Upgrade process & re-designed a few custom process.
- Involved in doing the Upgrade of Peoplesoft Financials (GL, AP, and AR) and Purchasing from Peoplesoft 7.53 to Peoplesoft 8.4.
- Analysis and Testing for Excel Upload of Vouchers in Payables Module
- Tested the PeopleSoft GL, AP, PO Modules before Rollouts.
- User Acceptance Testing Support
- Discussed with the users & explained about the new functionality like CATEGORY CD field in the item category table and added that logic to related SQR program.
- Re-designed the EDI business document layout to map the inbound file data in to the target tables.
- Brought the customizations in to delivered SQRs like ECIN0001 & POPO005.
- Upgraded the customized crystal checks in to 8.4
- Upgraded all customized 7.5 SQRs in to 8.4 for all PeopleSoft FSCM modules.
- Identified the custom processes which can be de-customized in 8.4
- Did the Unit Test for all SQR & Crystal Reports.
- Created the Pages to run the processes from web.
Confidential
Technology: PeopleSoft Financials (8.x/7.x), PeopleSoft SCM (8.x/7.x), Windows NT, Oracle 8i, MS SQL Server and Clear Case Tool.
PeopleSoft Financials Functional Consultant
Responsibilities:
- Acted as single point of contact for all incidents related to FSCM.
- Worked as Financials Functional Lead, and was involved with analysis of the incidents, allocate the incidents for development
- As functional Consultant involved in understanding, analysis and development of Localisations.
- Incident Resolution:
- Replicated, analyzed, Tested and provided solutions for incidents received from PeopleSoft in General Ledger, Receivables, Payables, Purchasing modules which involved fixing, testing of errors in People Code, Application Engine SQR and Import Manager.
- Involved in Analyzing and Testing Various processes in various modules for Localizations Impact analysis for various critical processes like Pay cycle (AP), Payment Predictor (AR), AR Update, AGING, Budgetary control in PO/AP/AR, GLS9002 (GL), Budgetary control in PO/AP/AR, AP Posting Process, AP PO interfaces.
- Worked with functional committee and developers to know the business system requirements for the Confidential (TKM).
- Involved in PeopleSoft TKM India Localization bundling upgrade and maintenance.
- Analyzed compare reports for changes and omissions and making decisions for migration of customizations and code migration.
- Responsible for testing of various transactions and fixing of various issues and bugs at different stages of Upgrade process.
- Handled the GC components like Tax Calculation engine, which is an Application engine process is used for Tax Calculation on all modules.
Confidential, Princeton, NJ
Technology: PeopleSoft CRM (Sales & Marketing) 8.4, PeopleSoft Accounts Payable 8SP2/7.02, PeopleSoft Purchasing 8SP2/7.02, PeopleSoft General Ledger 8SP2/7.02, Windows NT, Oracle 8i.
PeopleSoft ERP Developer.
Responsibilities:
- Responsible for testing of various transactions and fixing of various issues and bugs at different stages of Upgrade process.
- Responsible for customization and modification of Purchase Order.
- Fixed issue PO copying two lines of distribution per line item for line item and sales tax and sum of distribution Qty. not equals scheduled qty.
- Resolved issue where in PO copy method was processing PO with a vendor that has vendor status Inactive and vendor unavailable for ordering.
- Resolved issues related to PO Cancel on PO form and PO work bench
- Issues related to PO change orders and receiving
- Issues related to express checks and system checks in AP
- Responsible for design and setup of custom match rules in AP and matching setup for three way, two way and open PO matching
Confidential, Sunnyvale, CA
Technology: PeopleSoft (GL, OM, BI), SQR, ASP, VB Script, MS SQL Server, Windows NT, Silk and Silk Performer.
PeopleSoft Programmer
Responsibilities:
- Involved in the Upgrade (from ver 6.0 to 7.0) and Customization of PeopleSoft Financials
- Carry out the customization and testing the same, which involves extensive usage of PeopleTools and PeopleCode.
- Customized Item Maintenance panel in Maintain Receivables, This involved extensive programming in PeopleCode.
Confidential
Technology: Oracle & Oracle Forms4.5
Developer
Responsibilities:
- The system is primarily concerned with the booking the orders from the customers and executing it. The system gives the full details of the inventory, while booking orders and updating the day-to-day transactions.
- Development of Order Entry Form, Inventory Update Form, Billing Process form, Dispatch Note using Forms 4.5.
- Developed reports for Packing Slip, Order consolidation Billing Etc. Using Reports 2.5.
- Developed various database triggers and procedures, thus ensuring data integrity. Involved in coding and testing.