Onsite Project Lead And Sme Resume
PhoeniX
SUMMARY:
- Overall 16+ years of experience of which 13+ years of E - Business Suite 11i & R12 and Fusion Applications Release 8 (On Premise) and 11.1.12(Cloud) Financials (AP, AR, GL, FA, CE & EXP), Supply Chain (OM, INV & PO), Fusion Projects (Costing, Billing & Foundation), Procurement (Supplier Portal, Purchasing & Sourcing) modules as Solution Architect/Subject Matter expert, he was involved in different types of projects such as Implementations, Support, Upgrades and enhancement projects in United States, United Arab Emirates, Belgium, Netherlands, Korea, Japan, Singapore, Malaysia and India Localizations.
- He was involved in all the aspects SDLC such as Project Planning, Scheduling, Analysis, Design, Fit-Gap, Functional Configuration and Setup, Data Conversions, Interfaces, Functional Testing, End-user Training, Go-Live, Documentation, Post-Production Support, He was also Involved in Pre-Sales Demonstration, Project proposals and RFQ replies. He has implemented projects in industries such as Finance, Manufacturing, Service, Farming, Information Technology, Media, Advertising & Hi-Tech, He has 3 years of Domain experience in Accounting, Finance, Taxation and Auditing.
- Implemented Oracle Cloud Financials, Projects and Procurement (Release 11 & 12), release readiness for R13.
- Implemented Oracle Fusion Accounting Hub (Release 8) to PSFT GL Integration Solution
- Solutions for Fusion Financials Cloud and Fusion Accounting Hub Reporting Cloud(FAHRC)
- Implemented Oracle Cloud SSP, Purchasing, Inventory and Core HCM for Release 12
- Involved in developing Solution offerings: Fusion Rapid Implementation packs, R12.1.3 Packet offering, R12 COA Conversion Packs and E-Bus R12 SME Startup Pack offerings,
- Expertise in setting up oracle financials 11i (11.5.10.2) and R12(R12.1.3, R12.2.5) of standard feature and customizations in General Ledger, Account Receivable, Accounts Payable Modules, Payments, Fixed Assets, Cash Management, Order Management, Purchasing, Inventory etc.,
- Worked on EAPM, In-Track, AIM (prepared BP080, RD020, BR100, MD50, CV40 and TE40), OUM (AN100, CV027, DS030/MC050) and documented for Financials, Procurement & Distributions modules
- Providing support, solutions to US companies in designing Multi-Org structure for organization having global presence in multiple jurisdictions and its transfer pricing issues
- Trained by Oracle consulting on Fusion Applications (Financials, SCM, PPM & PRC), Proficient in Fusion General Ledger, Payables, Receivables, Cash Management, Assets, Inventory, Payments, Purchasing & Distributed Order Orchestration & OIM.
- Trained by Oracle Consulting on Fusion ERP Cloud Express Implementation, Data migration, Customizations, Personalization, Extensions & Business Analytics such as OBIA, OTBI, BI Publisher & FR on Rel 1.6 thru 1.9
PROFESSIONAL EXPERIENCE:
Confidential, Phoenix
Onsite Project Lead and SME
Responsibilities:
- High level and detail solution for Transactions and Accounting flows
- Solution of Integration such as Sales portal to Project to Project Billing to AR to GL flow, Vehicle DB and IMS (Legacy system) to Purchasing and Payables
- Solution for PaaS forms to SaaS writing functional spec for development of PaaS forms for Requisitions, Inventory, Project Costing and Billing
- Solution for automation of interfaces for Customers, Suppliers, Purchase orders, Receiving, Workday to Payables, Pro-Lease to Payables and GL.
- Implementation of OCR, Cross Validation Rules, Fixed Assets Tax books and Approvals setup across Requisitions, PO, AP, Payments & GL
- Single Sign Implementation with OKTA and Oracle Cloud.
- SSP vendors punch-out with and custom TAB rules Implementation
- Purchasing integration to Payables, Project Costing and Inventory.
- Configuring Inventory, SSP, purchasing applications and Creating Test Scripts
Confidential, Los Angeles
Onsite Functional Lead for Financials and Supply Chain
Responsibilities:
- Provided solution for Consolidation of two chart of accounts with multiple legal entities and Ledgers, using Smart View and FAHRCS.
- Consolidation of Ledgers with Revaluation, historical translation for 60 months, Reporting currencies, Currency exchange automation with Oanda, Eliminations, intercompany reconciliations
- Implementation of Payment Manager and Cash Management integration with Wells Fargo bank for multiple payment methods
- Automation of Schedule of orders, setting up of modifiers and qualifies and employee approval rules, EB Tax post 11i to R12 upgrade setup
- Validation of FR Studio report, reconciliation of 60 month’s balances between EBS R12 and FAHRCS
Confidential, Texas
Onsite Account Lead
Responsibilities:
- Automation Bank Reconciliation process for Payables, Receivables and External Transactions
- Development of SmartView reports for Financial reporting and HO Reporting
- Review and validation of custom OTBI reports developed by technical team
- Managing user role matrix with R12 upgrade changes and fixing upgrade issues
Confidential, Burbank
Functional Consultant
Responsibilities:
- Requirement Gathering, Design, Proof of Concepts and Solutions
- Data Conversion for Sub-Ledger and GL.
- Configuring Common Financials, AP, AR, GL, FA & CE, TAX IDM user roles matrix, Project Foundation and Billing.
- Complex AP Approval Workflow, AP Image scanning.
- Complex Cross validation rules, Revenue Recognition Rules, Designing Chart of Accounts, FR Studio Reports development, Smart View queries,
- Developing test scripts, handling CRP1 and UAT, 1099 Reporting for conversion and post go-live guidance.
- Specific solution for Air Cargo business to address accounting and billing solutions using PaaS custom forms integration to Project Billing and AR
- Handling external integrations for Banks, third party integrations for Payment manager and Positive pay. Project Billing integration for revenue and receivables custom SLA rules. Balance forward billing and recurring billing.
- Post Production support and issue resolutions
- User Training documentations and Test Scripts development.
Confidential, Phoenix
Functional Consultant
Responsibilities:
- Requirement Gathering, Design, Proof of Concepts and Solutions
- Data Conversion for Sub-Ledger and GL
- Configuring Common Financials, AP, AR, GL, FA & CE, IDM user roles matrix, Project foundation and Project costing, developing test scripts, handling CRP1 and UAT
- Specific solution for retail car Sales industry such as trade in’s, Loan sales etc.,
- Handling external integrations for Banks for Payment Manager and Positive pay
- Revenue recognition Rules and custom solution for Loans and warranty, Designing smart view queries, FR Studio Reports development.
- Migrating configurations between Cloud POD’s
- Post Production support and issue resolutions
Confidential, San Diego
Functional Consultant
Responsibilities:
- Resolving Project, Costing and Financials productions issues
- Projects and tasks conversion handling
- Designing key reports required immediately after Go-live
- Fixing user roles, access and security issues
- User Training on Finance Reporting Center (Smart View, OTBI, BI, Account Monitor & Account Inspector)
Confidential, Los Angeles
Functional Consultant
Responsibilities:
- Demonstration of Reporting tools such as OTBI, Smart View.
- Design and development of FR Studio Reports, Fusion Budgets
- Configuring the integration in EBS and Fusion resolving configuration incompatibilities.
- Reconciling historical & current balances between FAHRCS and EBS R12
- Ongoing Support and Maintenance in EBS R12 and FAHRCS
Confidential, Los Angeles
Functional Consultant
Responsibilities:
- Post upgrade Configuration for (AP, AR, GL, FA, IBY, OM & PO) Modules
- Post upgrade validation of Reports, Interfaces and Extensions, Customization and Workflows and fixing them.
- End to End testing for Procure to Pay, Order to Cash, acquire to Retire and Record to Report cycles
- Preparation of training documents for the new functionalities.
Confidential, San Jose
Solution Architect/SME
Responsibilities:
- Fusion Accounting Hub Reporting Cloud (FAHRC).
- Fusion Financials Cloud Modules/On Premise
- Fusion Advance Collections, Fusion Revenue MEA arrangements
- Prepare the system architecture diagrams, presentations and suggest best alternatives
- PaaS Applications design for Revenue Applications, MEA rules and Project Billing scenarios for Implementation, Warranty support and peripherals sales.
- Demonstrate fusion application functionalities on Fusion financials Cloud
- Prepare and present 11i/R12 data migration, integration and Interface solutions for sub-ledgers (AP, AR, GL, FA, CE & PO)
- Analyze the requirements, suggest fusion financial reporting capabilities
Confidential, Schaumburg
Business Analyst
Responsibilities:
- Preparing the Business process understanding documents by reverse engineering and going through the PL/SQL code, comparing it in each instance
- Configuration and Testing of Cyber Source credit card integration with MOL, Depot Repair and Projects.
- Analysis of AR Interface preprocessor programs
- Analysis of Available Credit limits and Overall limit calculations coming up with new process for Greenfield
- Preparing test cases and test scripts for Unit and integration testing.
Confidential, Glenview
Lead Consultant and Onsite Project Lead
Responsibilities:
- Configuration of Dev & System Test Instances
- IT application testing, System Integration Testing
- Reviewing team deliverables for Functional, Installation & Technical Tracks
- Reviewing Requirement Specs, Test Scripts, BR100’s, Migration Documents, Functional Design documents
- Conducting CRP, SIT1 with Business users and resolving the issues
- Managing project deliverables such as Implementation Checklist, MOSCOW list, Project Plan etc.,
Confidential, Denver
Functional Consultant
Responsibilities:
- Managing & Resolving SIT, CRP, UAT Issues
- Configuration of CRP, UAT and Gold Instances
- Solution for Contract Life Cycle Management (CLM), I-Procurement, Purchasing UDA Personalization
- Preparing solution documents for CEML’s, testing the developed CEMLi’s
- UAT/Gold Instance preparation, Handling new Enhancements
Confidential, Foster City
Functional Lead
Responsibilities:
- Managed UAT and Go-live Schedule for All tracks (O2C, P2P, A2R, R2R, D2D etc.,)
- Requirement Gathering for unique business process flows in O2C, A2R & EB Tax
- Implemented Business flows such as Order to Cash Cycle with Modifiers, Qualifiers, Trade Discounts and Deductions, Multiple Receivables and Customer Deductions Scenario’s.
- Functional Solutions for Deduction/Up-charges Management
- Preparing POC’s for unique business flows and getting business acceptance
- Instance preparation for TC1, UAT and Production setup
- Handling Cutover tasks for all tracks such as P2P, D2D, R2R & A2R etc.,
- Project Documentation such as (BR100, TE040, MD 050 etc.,)
- Periodic status update and reporting
- Post production support along with documentation recommendation for closing procedure and processes
Confidential
Offshore Functional Lead
Responsibilities:
- Support/Configure AP, AR, GL, OM, FA, PO, CM, Adv Collections, I-Procurement.
- Configuring and Testing CEMLI’s like Auto lock box, Advance Collections Dispute workflow, Final Demand Letter, BOLT Customer and invoice interfaces etc.,
- Offshore Functional Lead for supporting Benelux objects
- IBIS Interface Changes
- Items unique configurations for RevRec purpose
- Offshore Functional lead for solution-ing the critical requirements such as
- Customer Profile Class Update through Interface
- Service Tax Exemptions Process
- Revenue recognition solution for Negative usages
- Functional Lead for O2C Cycle (AR, OM & Localization)
- Requirement Gathering for unique business process flows in O2C
- Implemented unique Business flows such as Balance Forward billing.
- Functional Solutions for manual Fulfillment in the bill only line workflow and logically deriving the invoice date and grouping based on fulfillment date, COPS Interface functional analysis for various scenarios, Customer Interface functional analysis
- Preparing POC’s for unique business flows and getting business acceptance
- Instance preparation for SIT, CRP1, CRP2, UAT and Production setup
- Project Documentation such as (RD 020, BR100, Test Scripts, MD 050)
- Periodic status update and reporting
- Post production support along with documentation recommendation for closing procedure and processes
Confidential
Project Lead
Responsibilities:
- Project Planning includes estimation of time lines, Scoping, IT requirements, Security, Risk Assessment and Mitigation etc.,
- Project Staffing, Scheduling and Delivery as per the timelines
- Preparing POC’s for Business flows and getting business acceptance
- Project Documentation (Process Flows, AS-IS, TO-Be, Gap & Fitment analysis, BP 080, RD 050, MD 050, BR100 & TE040)
- Preparing Test cases and Test Scripts for End User Training
- Instance preparation for CRP, SIT and UAT and Production setup
- Timely status update across the teams
- Post production Support
- Account lead for AMS, Enhancements, Upgrade and Internal projects for Finance and Distribution Modules(Techno-Functional)
- GL Consolidation & FA migration, Internal Project (includes Fixed Assets loading from legacy systems, GL Consolidation)
- Writing the SQL queries for balances extracts to reconcile Inter-company Accounts, Reconcile between instances.
- Writing SQL queries for migrating CV rules, Account Hierarchies from one instance to other instance, FSG Transfer etc.,
- Preparing MD 50’s for GL Balances Interfaces.
- Consolidation setup and rules
- FA Tax interface setup and Fixed Asset conversion.
- Managing the BMC(Production) Helpdesk ticket for Q2O, P2P and Finance Processes
- Managing the HP Quality Center (Upgrade Queue) Enhancements for Q2O, O2C, P2P and Finance Processes
- Helping the Internal Project team on 11.5.10.2 upgrade
- Managing the Offshore team and onsite team and giving the KT to the team and Timely status update across the team and Maintaining Internal SLA’s
