Home

Sankar - Oracle Finance Functional Consultant (Cloud & EBS)

[email protected]

Location: Dallas, Texas, USA

Relocation: Any

Visa: H1B

Sankar Oracle Finance Functional Consultant (Cloud & EBS) 346 526 2968 [email protected] Dallas, TX Any H1B Linked In: https://www.linkedin.com/in/cma-sankar-adhikary-03958022 Seeking assignments in Oracle Cloud/EBS Financial Functional Competency with a growth-oriented organisation. Professional Synopsis: A dynamic professional with over 17 years of total experiences out of which 14 years of rich and extensive experience in Oracle Apps Financial Functional Consultancy in Cloud (R13, 23D), EBS R12 and EBS 11i for implementation, AMS, upgrade, and roll-out projects. Worked as Oracle Finance Functional Consultant (Cloud & EBS) with IBM Corporation ( October'2010 to September'2023 ) Worked as Oracle Finance Functional Consultant (EBS) with Genpact ( September'2008 to October'2010) Currently working in Houston, Texas United States as Could/EBS Finance Functional consultant. PROFESSIONAL PROFILE: 14 years of experience in design, development, testing, implementation and support of Oracle Applications Cloud/EBS Suite which includes Oracle Financial Molude like GL, AP, AR, CM, FA, PO, SLA, EB Tax, and P2P and O2C E2E, AOL, Vertex O series, AME and AGIS (Advanced Global Intercompany System System Administration and R2R. Worked in Oracle Cloud Financials Release 13 (23D). Worked in EBS Suite versions (11.5.4, 11.5.9, 11.5.10, R12.1.1, R12.1.3&12.2.1 R12.2.4). Worked as a Team Lead and handled projects which include implementation, Customizations development and Support. Worked as Lead in the functional and technical implementation of existing and new Oracle EBS /Fusion cloud financial modules and related third party applications. The role also assisted in providing functional and technical design, direction, and support to the corporate financial, billing and treasury functions Essential Duties/Responsibilities, Worked as Functional Lead for deployment of new and existing financial applications supporting the corporate finance and treasury functions. Well versed with the tools like Service Now& JIRA (Business Solutions Portal) Proven Skills as an efficient Team Lead in System Analysis, Designing, Development, Customization, Migration and Documentation. Involved in implementation, Upgrade and Support of Oracle Applications Cloud and E-Business Suite using SQL, with hands-on experience of various RICE components and Workflow. Experience managing functional quality deliverable/ resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology. Strong analytical, interpersonal and troubleshooting skills and ability to work in a fast-paced and team-oriented environment. Extensive experience in maintaining development plan, tasks allocation, task monitoring, establishing/monitoring quality process, study/audit of existing business process and preparation of issue logs, requirement gathering, user interaction, gap analysis, technical data mapping and analysis Worked with Oracle Support, using Metalink, to resolve issues using knowledge base, SR. Performed Unit testing, Integration testing & User Acceptance testing of the Applications. Developed the Documentation Process of the application with end-user training. Production Support experience in all Finance Processes for financial module like GL, AP, AR, CM,FA, EBTax, Procure-2-Pay(p2p). Supported Vertex O for O2C (Sales Order to Cash) & P2P (procure to Pay) cycles. Functionally proficient and possess excellent written and verbal communication skills. Have good team leadership skills and invariably meet client expectations. Well versed with complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle. Managed Planning and Stakeholder Communication for the Change Management Process. Strong analytical, design and problem solving skills. Result oriented, self-starter and able to work with minimum guidance. Proven ability to understand business problems and apply technology to formulate workable solutions. Ability to quickly adapt to different project environments and an excellent Team Lead/ Team member. Skilled in swiftly ramping up projects with competent skills and ensuring on time deliverables. Used to play a Key contributor role to technical aspects of annual planning process, ensuring application roadmaps and project cost estimates create aggressive, yet achievable plans Ability to Deliver approved IT Plan of Record with high quality, secure, on budget and exceeding business expectations. Ability to actively engage in business steering committees to identify opportunities to reduce business or IT cost, increase revenue, and align with regulatory compliance requirements. SOFTWARE SKILLS : Domain Financials, Banking, Industrial, Distribution, Health care ERP Oracle Applications EBS 11i [11.5.4, 11.5.9, 11.5.10], R12 [12.1.1, 12.1.3, R12.2.6, R12.2.8], Oracle Cloud Financials Release 23A (SaaS) Oracle Apps Modules General Ledger, Account Payables, Account Receivables, Cash Management, Fixed Assets, Purchase Order and AOL, Sysadmin, AME (Approval Management Enterprise), EB Tax, Vertex O Series, AGIS (Advanced Global Intercompany System ) Databases Oracle RDBMS 8.x, 9.X & 10G Software Tools Data Loader, WEB ADI, MS Office, HPQC, SQL, Service Now, Jira, Oracle Financial Reporting Studio(FRS), OTBI, FBDI etc Operating Systems Windows NT, UNIX Detailed of Project: Implementation and Support Project under IBM from Oct 2010 Project Name: NOV CLOUD SUPPORT PROJECT Client: NATIONAL OILWELL VERCO. (Houston, USA) Project Type: Oracle Cloud Financial Functional Production Support (Cloud Support and Implementation) Role-1: Oracle Cloud Finance Functional Lead (Sep-2020 to Sep'2023) Version: Release 13, 23D (SaaS) Project Modules: GL, AP, AR, CM, EBTax, Cost Management Responsibilities: Overall Status Reporting, Issue Resolution and handling of escalations Handling all Support related issues of financial modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Actively participated in SaaS cloud implementation project of National Oilwell Varco both for United States and Canada. Specially helping implementation team to configure Oracle Could Receivables and Cloud Cash Management module both for CAPS ISE US BU and for all the BUs of Canada SaaS cloud implementation. Now preparing for in SaaS cloud implementation project for United Kingdom and helping implementation team to configure Oracle Could General Ledger and Cloud Payables module in test instance for unit test and UAT. Worked as a functional consultant in Application integration activities for oracle with third party application like Basware, Concur, Biztalk, Vertex, VT. Worked actively on different enhancements project. Discussing issues daily with the client on status review (Daily Scram Call). Environment: Oracle Cloud Application Release 13, 23D (SaaS) Role-2: Sr. Finance Functional Lead - EBS Support and Enhancement (Sep-19 to Aug-20) Version:R12.2.8 Project Modules: GL, AP, AR, CM, EBTax Responsibilities: Overall Status Reporting, Issue Resolution and handling of escalations Handling all Support related issues of financial modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Assist the user in Month End close activities related to Financial modules. Inbound/Outbound interfaces Basware to AP AP Invoice integration with SAP Concur AP Payments H2H integration Worked actively on different enhancements project. Discussing issues daily with the client on status review. Environment: Oracle Applications 12.2.8 Project Name: UBM ALLWORLD ROLLOUT PROJECT (Apr 18 Aug 19) Client: United Business Media INC. Project Type: Oracle Financial Functional Production Support (Oracle R-12) Role:Lead Consultant Version:R12.2.6 Project Modules: GL, AP, AR, CM,FA & EBTax Responsibilities: Provide solution for Worldwide Rollout for different countries for acquisition of New business and their merger with Implementation of Oracle ERP for financial module, with high level of customization and localization for specific country for oracle financials module. Mapping the client requirement and providing them the best possible solution Understand the new requirements & document the same. Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs. Configuration of all the financial modules based on BR-100 prepared for each and every financial module. Involved in development/modification/bug-fixing of different RICE components. Worked actively on different enhancements projects. Discussing issues daily with the client on status review. Environment: Oracle Applications 12.2.6, Oracle 11g Project Name: WFS ORACLE PRODUCTION SUPPORT PROJECT (Aug'16 - Mar'18) Client: World Fuel Services INC. Project Type: Oracle Financial Functional Production Support (Oracle 11i) Role:Oracle EBS Support Project (Lead) Version:11.5.10 Project Modules: Financials Modules (GL, AP, AR, CM, SLA & AME) Responsibilities: Overall Status Reporting, Issue Resolution and handling of escalations Handling all Support related issues of financial modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Assist the user in Month End close activities related to Financial modules. Worked actively on different enhancements project. Discussing issues daily with the client on status review. Worked with the Oracle Support Team for SR (Service Requests) for some issues on the Financial Module. Worked on EBTAX. Unit testing and System testing (with various other systems deployed in the organization) for the applications built and customization performed. Worked O2C (Sales Order to Cash) and P2P (Procure to Pay) Cycles and support. Worked on defining SLA for financial modules for US region Responsible for writing Functional (MD050) and Test Scripts. Performed mentoring juniors in the team. Prepared functional specifications for Auto Lock Box interface in Oracle Receivables using proper validation and loaded the data. Logging/following up Service Requests with Oracle Support. Worked on AR Statement Cycle Process. Worked on SLA setups. Prepared functional specifications for EB-Tax reports Development/Customization Worked on Month End Activities to close the periods in time. Prepared functional specifications for Development/ Customizations of reports, interfaces, enhancements. Handling all Support related issues of financial modules. Worked on AP Invoice approval workflow (AME) in routing of Invoices/Payments approval User problem resolution and query handling. Discussing issues week-wise with the client on status review Involved in development/modification/bug-fixing of different RICE components Planning & Estimation of new developments and customizations from functional point of view. Understanding the new requirements, documenting the same. . Environment: Oracle Applications 11.5.10 (AP GL, AP, AR, CM, PO, AME) , Oracle 10g Project Name: COOK COUNTY IMPLEMENTATION PROJECT (May'16 - July'16) Client: COOK COUNTY. Role:Senior Oracle Applications EBS Financial Consultant Version:R12.2.4 Project Modules: GL, AP, AR, CM, & FA Responsibilities: Worked on Oracle EBS Financial End to End Implementations, including requirement gathering, configuration, CRP / Prototype, Training, Data Migration and Documentation. Provided insight of Cook County system and provided the solution to the defects. Worked on custom process for Cook County system Worked on fortnight/monthly release management activities to deploy objects into UAT/Production. Mapping the client requirement and providing them the best possible solution Understand the new requirements & documenting the same. Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs. Involved in development/modification/bug-fixing of different RICE components Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections Overall Status Reporting, Issue Resolution and handling of escalations Handling all Support related issues of financial modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testingand resolve production issues. Discussing issues daily with the client on status review. Environment: Oracle Applications 12.2.4 (GL, AP, AR, EBTAX, CM & FA) Oracle 10g, Oracle Developer Suite 10g Project Name: NEW PORT IMPLEMENTATION PROJECT- DOHA QATAR (Apr'16-May'16) Client: QATAR PORT MANAGEMENT COMPANY. Role:Oracle EBS R12 Finance Functional Version:R12.2.4 Project Modules: GL, AP, AR, CM, SLA, EBTAX, AGIS Responsibilities: Gathering, refining, and documentation of the business rules, functional and technical requirements. Worked on EBTAX regime, taxes, tax statuses and tax rates setups. Worked on SLA & AGIS setups. Creation of functional specification document (MD-50) for the development of new & customization of reports for Payment Voucher, Expense Voucher, Check Printing with printer installation in AP module, Setting the Printers and Print Styles for Check Printing process and Reports. Mapping the client requirement and providing them the best possible solution Mapping of Data template columns with legacy systems Involved in development/modification/bug-fixing of different RICE components Discussing issues week-wise with the client on status review. Understand the new requirements & document the same. Environment: Oracle Applications 12.2.4 (GL, AP, AR, CM, EBTAX) , Oracle 10g, Oracle Developer Suite 10g Project Name: GLOBAL SUB LEDGER IMPLEMENTATION PROJECT (Jan'12-Dec-12) Client: AMERICAN EXPRESS INDIA PVT LTD. Project Type: Functional Testing Lead (Oracle R12) Financial Functional Consultant, worked as Team lead for the following Module: General Ledger, Payables, Receivables, Cash Management for testing for finance test cases in SIT, UAT and regression cycle after application of oracle patch. Team lead role includes coordination with client to prepare the activity test plan for each SIT, UAT, & Regression Testing, E2E Testing, to prepare test cases to be uploaded in test plan in HPQC, to modify test cases as and when required, to create instance in test Lab in HPQC for a particular regression cycle, to understand the task of a particular cycle and offload them to team members to execute the test run in HPQC, to log defects in HPQC in case of any test case fails during test run, to co-ordinate with the tech team to resolve the test cases in time, to hold daily calls with the team members to know the actual status of the test cycle, Reporting results of test cases by way of graph analysis and regular participation in meeting with Client to discuss on the daily status of the testing at different stages like SIT UAT and regression. Support Projects: Project Name: ANSELL ORACLE AMS PROJECT (Oct'15-Mar-16) Client: ANSELL INC. Project Type: Oracle Financial Functional AMS (Oracle R12) Role:Oracle EBS Finance Functional Consultant Version: R12 Upgrade & Support. Project Modules: GL, AP, AR, CM, PO, OM& AME Responsibilities: Overall Status Reporting, Issue Resolution and handling of escalations Handling all Support related issues of financial modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Assist the user in Month End close activities related to Financial modules. Worked actively on different enhancements project. Discussing issues daily with the client on status review. Worked with the Oracle Support Team for SR (Service Requests) for some issues on the Financial Module. Created test scripts for every level of testing from unit testing stage to integration testing. Implementation involves data from different sources to flow to Oracle Applications through a series of custom and standard programs. Worked P2P (Procure to Pay) Cycle and support. Worked on EBTAX regime, taxes, tax statuses and tax rates setups. Worked on defining SLA for financial modules for US region & Canada Worked on Financial Specifications of EB-Tax reports Development/Customizations. Worked on Financial Specifications of Integration of custom forms with standard PO and AR modules. Worked actively to trouble shoot defects and problem during the string and user acceptance testing and resolve production issues. Implemented the AP Invoice approval workflow (AME) to handle the routing of Invoices/Payments Worked on Preparation of BR-100, MD50, documents for the deliverables using Application Implementation Methodology (AIM). Responsible for delivery interfaces, customizations, developments and setup issues. Mapping the client requirement and providing them the best possible solution Involved in development/modification/bug-fixing of different RICE components Scheduling of multiple tasks (Daily Interfaces/Month End Process) and handling the errors/rejections Discussing issues week-wise with the client on status review. Understand the new requirements& document the same. Raising SR with Oracle Metalink, priority based on severity of the problem and follow up of SR, updating of same if required, and expediting User/DBA action on receipt of solution Environment: Oracle Applications 11.5.9/R12.1.1 (AP GL, AP, AR, CM, PO & AME) , Oracle 10g, ProjectName: GLOBAL SUB ORACLE AMS PROJECT (Feb'14-Sep'15) Client: GLOBAL FOUNDRIES INC. Project Type: Oracle Financial Functional AMS (Oracle R12) and Patch Management Team Version: Oracle EBS R-12.2.4 Role:Sr. Consultant Project Modules: GL, AP, AR, CM,FA & AME Responsibilities: Financial Analysis of different patches recommended by oracle SR team and testing of functional scenarios. Analyze and provide resolution for the tickets of the day-to-day issue in relation to oracle financials. Analyze and provide resolution for the tickets of the day-to-day issue in relation to oracle financials. Provide insight of Global Foundries system and provide the solution to the defects Handling all Support related issues of financial modules. Extensively developed the RICE components in the major financial modules like GL, AP, AR Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Assist the user in Month End close activities related to Financial modules. Worked actively on different enhancements project. Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70 using Application Implementation Methodology (AIM). Interactions with users Functional Specification for Development/ Customizations of reports Registering of Report with Oracle Applications Testing the Developed components with Front end Forms Environment: Oracle Applications 12.2.4 (GL, AP, AR, CM, FA & AME) , Oracle 10g, Project Name:GLOBAL SUB ORACLE AMS PROJECT (Dec'12 Jan'14) Client: SEADRILL INC. Project Type: Oracle Financial Functional AMS (Oracle R12) Version: Oracle EBS R-12.2.1 Role:Sr. Consultant Project Modules: GL, AP, AR, CM,FA & AME Responsibilities: Analyze and provide resolution for the tickets of the day-to-day issue in relation to oracle financials. Provide insight of Seadrill system and provide the solution to the defects Handling all Support related issues of financial modules. Extensively developed the RICE components in the major financial modules like GL, AP, AR Worked actively to trouble shoot defects and problem during the string and user acceptance testing. Assist the user in Month End close activities related to Financial modules. Worked actively on different enhancements project. Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70 using Application Implementation Methodology (AIM). Interactions with users Functional Specification for Development/ Customizations of reports Registering of Report with Oracle Applications Testing the Developed components with Front end Forms Environment: Oracle Applications 12.2.1 (GL, AP, AR, CM, FA & AME) , Oracle 10g, Project Name: GLOBAL BUSINESS TRANSFORMATION PROJECT (Oct'10-Dec-11) Client: KINETIC CONCEPTS, INC. Project Type: Finance Functional Lead -Regression Testing Version: Oracle EBS R-12.2.1 Role:Sr. Consultant (Lead) Project Modules: GL, AP, AR, CM,FA Responsibilities: Worked as a Team lead for Regression testing for finance test cases in monthly regression cycle after application of oracle patches. Coordination with client to prepare the activity test plan for each regression cycle, to prepare test cases to be uploaded in test plan in HPQC, to modify test cases as and when required. To create instance in test Lab in HPQC for a particular regression cycle, to understand the task of a particular regression cycle and offload them to team members to execute the test run in HPQC To log defects in HPQC in case of any test case fails during test run, To co-ordinate with the production team to resolve the test cases in time, To arrange daily calls with the team members to know the actual status of the regression test cycle, To Report the results of test cases by way of graph analysis and regular participation in meeting Worked actively on different enhancements project. Interactions with users Testing the Developed components with Front end Forms Environment: Oracle Applications 12.2.1 (GL, AP, AR, CM, FA) , Oracle 10g, Since Sep 2008 to Sep 2010 with M/s. Genpact worked as Oracle Finance Functional Consultant Key Deliverables Responsible for executing Oracle Applications implementation projects. Configuring the entire set up of GL, AP, AR, OLM,CE and FA. Establishing the new instance for after marker service. Handling multiple customers for Oracle Applications customizations in GL, AP, AR & OLM. Projects Handled Project Name: BAPL ERP Implementation Project (R-12) Duration: Mar 10 to Sep 10 Module: GL, AP, AR & CE Scope: The project was executed for the implementation of ERP oracle R-12 for Bengal Aerotropolis Project Ltd for GL, AP, PO, AR, CE & HRMS. Full cycle implementation exposure for CE & AR. Special contribution for Bank Reconciliation custom report design. Design of integration mapping of AR transaction data and cash forecasting data interfacing from non-oracle system (In4suite ERP). Project Name: GE-Comm fin GL Consolidation & conversion Project Duration : Dec 09 Feb 10 Module : GL Project Name: Genworth GL Conversion Duration : Jan 09 Nov 09 Module : GL Project Name: AMS Duration : Nov 08 Dec 08 Module : GL, AR & AP Project Name: DLL Oracle Lease Management Implementation Duration : Jun 08 Oct 08 Module : OLM, AR, AP, FA, Inventory, GL & Work Flow Project Name: Hindustan Motors Limited (Component Business) Duration : May 04 Aug 08 Scope : Complete supervision of finance & costing activities in component business. EDUCATIONAL QUALIFICATION: Qualifications: Master s Degree in commerce (M.Com.) Bachelor s Degree in commerce (B.Com.) Hons. CMA From The Institute of Cost Accountant of India Certifications: Oracle Cloud Certification on the Finance Modules like Oracle Financials Cloud: General Ledger 2019 Certified Implementation Specialist Oracle Financials Cloud: Receivables 2019 Certified Implementation Specialist Oracle Financials Cloud: Payables 2020 Certified Implementation Specialist Oracle Financials Cloud: Accounting Hub 2021 Certified Implementation Specialis Oracle Financials Cloud: Payables 2022 Implementation Professional (1Z0-1055-22) Keywords: rlang information technology container edition purchase order microsoft Arkansas Colorado Maryland Texas Vermont