Onsite Project Lead Resume
SUMMARY
- 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 Confidential 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
Onsite Project LeadResponsibilities:
- Onsite Project Lead and SME for PaaS to SaaS Integrations and Implementation of Procurement, Inventory, Project Billing, Costing & Core HCM
- 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
Onsite Project Lead
Responsibilities:
- Onsite Functional Lead for Financials and Supply Chain
- 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
- 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
Onsite Project Lead
Responsibilities:
- Onsite Account Lead for Ongoing support and Enhancements
- 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
Onsite Project Lead
Responsibilities:
- Functional Consultant for Implementing Fusion financial modules using rapid implementation approach
- 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
Onsite Project Lead
Responsibilities:
- Functional Consultant for Implementing Fusion financial modules using rapid implementation approach.
- 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
Onsite Project Lead
Responsibilities:
- Functional Consultant for Go-Live support covering areas such as Projects, Supply chain and Financials
- 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
Functional ConsultantResponsibilities:
- Functional Consultant for implementing EBS GL to FAHRCS Integration and configurations.
- 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
Functional ConsultantResponsibilities:
- Functional Consultant for implementing Financial and Supply chain modules
- 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
Solution ArchitectResponsibilities:
- As a Solution Architect/SME analyze the system architecture and propose solutions for
- 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
Business AnalystResponsibilities:
- Business Analyst for Order to Cash cycles in 11i & R12 Applications
- 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
Lead ConsultantResponsibilities:
- Lead Consultant and Onsite Project Lead for Solution of FAH to PSFT GL Integration and customizations
- 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
Functional ConsultantResponsibilities:
- Functional Consultant for implementing Purchasing, I-Procurement & CLM
- 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
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
Functional LeadResponsibilities:
- 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
Functional LeadResponsibilities:
- Project Lead for Finance and Distribution modules (AP, AR, GL, FA, CE, PO & INV)
- 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
Confidential
Functional LeadResponsibilities:
- 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
Confidential
Functional LeadResponsibilities:
- Finance & Distribution Lead for Rollout, Major Customizations & Regionalization handling
- Planning the schedules of project and the due dates of deliverables
- Planning and acquiring the human resources for the project and staffing the project
- Changing the Accounting Flexfield and adding, modifying the segments in the chart of account to meet the inter-company functionality and new reporting requirements.
- Global Inter-company System Setup and Global Consolidation Setups
- Data cleanup like Customer Master Cleanup and maintaining Data Quality Management rules
- IR/ISO Cycle, Internal and External Drop shipment setup, Back order setup with Inter-company accounting complexities between Operating units, Inventory Orgs and sub inventories etc.,
- Mapping the Revenue recognition rules to meet all the case of recognizing the revenue and revenue accounting
- HSBC I-File setup for Electronic payment & Receipts
- Providing the Solution for Complex Inter-company and transfer pricing benefits
- Based on the Client requirements gathered mapping the Business scenarios in the Oracle by preparing Proof of Concept (POC) Documents to demonstrate the client on the solution design.
- Preparing BR 100’s, MD050’s for customization and TE 40 for testing the requirements
- Setting instance for all the phases of UAT, SIT1, SIT3 and Production etc.,
- Delivery of the Final product and Sign-off the project
- Post production Support
Confidential
Functional Lead
Responsibilities:
- Functional Lead for Financial Modules (AP, AR, GL, FA & CM)
- Understanding the client’s business requirement and preparing the business blue print.
- Advising the client on industry best practices to take the appropriate decision for implementation considerations
- Mapping the software to suit the operating requirements like Strategic Operational reports, India Local requirement and India Tax laws like Central Excise, customs duty, Service tax, Income tax and Cenvat credit
- Implementing for Payables, General Ledger, Purchasing (P 2 P) Cycle and Order Management (O 2 C) Cycle, Receivables.
- AP/AR Netting Setup, I-Expenses Setup
- Implementing Procure to pay, Order to Cash, Accounting to Financial Reports, FA for the Acquire to retire flow including tax books and India localization
- Involved in Development, Testing, Production instance for Multi-org setup, System Admin setup, AP, AR, GL, FA, CE, I-Expenses and purchasing, OM (O2C cycle setup), Inventory org setup with India Localization.
- End user Training and Postproduction support
Confidential
Functional LeadResponsibilities:
- Support Consultant for Financial Modules
- Understanding the client’s business requirement and mapping the system setups accordingly
- Support for Purchasing, Payables, General Ledger (P 2 P) Cycle and Order Management, Receivables (O 2 C) Cycle. Day to day tickets raised by the end users
- Reconciliation reports and detailed analysis of the reconciliation reports
- End user Training and support of 8 weeks with Financial and Supply Chain modules
Confidential
Functional LeadResponsibilities:
- Functional lead for Pre-sales demonstration
- Understanding the client’s business requirement and mapping the Oracle to suit the client’s business.
- Creating the Multi-Org Structure with Seven Legal entities and seven operating units as per the client business scenario
- Creating Responsibilities, Users and setting up the system profile options for each responsibility.
- Generic Setups for General Ledger, Account Payables, Accounts Receivable, Purchasing and Fixed Assets, Enterprise Asset Management, Sourcing etc.,
- Coordinated with Oracle Pre-Sales People to understand the clients Business requirement and prepare the business scenario accordingly.
- Prepared Business flow for Purchasing and Oracle Sourcing
- Prepared Business flow for Oracle Enterprise Asset Management
- Involved in Pre-Sales Demo Delivery at the client place and clearing their queries.
Confidential
Functional LeadResponsibilities:
- Team Lead for HRMS, SCM and Financials team.
- Understanding the client’s business needs and requirements
- Allocated the work among the team members based on their expertise
- Mapping the Oracle application Indian localization to suit the business with regards to Indian legal reporting requirements.
- Creating the Single-Org Structure with Legal entity and operating unit as per the client business scenario.
- Created the Responsibilities, users and setting up the system profile options for each responsibility.
- Defined generic Setups for General Ledger, Account Payables, Purchasing, Receivables and cash management including India Localization setups for Service tax, Sales tax and Fixed Assets.
- End use training for the module Purchasing, Payable and Fixed Assets and solved the client’s queries
- Got introduced in the project in critical situation and tight deadlines and supported the project to execute it smoothly till the project came to normal situation.
- Data migration from front end using Data loader tool into the database
Confidential
Functional LeadResponsibilities:
- Finance offshore support consultant for P2P and O2C cycles
- Resolving the end user tickets on day-to-day basis
- Worked on receipt accrual in both ways i.e., period end and at receipt and explained the client’s pros and cons of both methods and helped the client to take the better method to suit the business.
- Complete P 2 P cycle reconciliation process and reconciled the entries which are getting transferred to GL.
- Solved the ticked related to closed prior periods and omitted entries in each module.
Confidential
Functional LeadResponsibilities:
- Functional Consultant for Financials Modules for large organizations
- Understanding the requirement based on Business blue prints and preparing RD 050’s
- Identifying the Customization needs and preparing MD 050’s and helping the technical team in understanding the requirements and doing the functional testing for the technical developments
- Preparing the Proof of Concepts (POC’s) documents for different business scenario’s and getting the acceptance to migrate into production
- Defining General Ledger, Payables, Receivables and Assets and Cash management setup in SIT, UAT and Production and preparing the BR 100’s
- Helping the Technical team in developing the interfaces and Conversions.
- Involved in analyzing user requirements, design, preparing test plans and test cases, preparing TE 040’s, User training manuals and functional testing.
Confidential
Audit Assistant / Audit managerResponsibilities:
- Audit Assistant / Audit manager in a chartered accountant firm
- Handling statutory audits for Private Limited companies, Limited Companies and Banks
- Concurrent Audits of Banks, Stock Audits and Information Systems audits etc.,
- Engagements to compile Financial Statements and finalization of accounts
- Preparing of periodic Sales tax monthly returns & Annual Assessment, Service Tax Returns & Assessments
- Involved in Tax audits and preparing E-TDS returns etc.,
- Preparing Individual Tax Returns, Partnerships, companies and Charitable trusts.
- Closely involved with CA in preparing Project appraisal reports for the purpose of Working capital loans and terms loans
- Thoroughly verifying Visa documentation and preparing CA certificate based on the facts and supporting.
- Digitization of Manual accounts to computerized accounts and return preparation.