Oracle Techno-Functional Consultant
Tata Consultancy Services LTD.Dec, 2021 - May, 20231 yr 5 months
Created functional setups such as Descriptive Flex fields (DFF), Value Sets, Lookups, User-Defined Attributes (UDA), Pricelists, and Items. Performed sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend. Created test scripts for various finance and Supply Chain Management (SCM) user stories for Conference Room Pilot (CRP) and System Integration Testing (SIT). Successfully executed various user stories in the Oracle EBS applications frontend during CRP sessions. Designed Inventory (INV) components for the INV interface (both Inbound and Outbound) and Min-Max Planning, and documented them as MD60. Developed pseudocode for various project components and documented them as MD60. Created an APEX form for error handling by business users. Developed ISG packages for loading custom staging tables. Developed custom packages, PL/SQL stored procedures, and functions for validation, necessary operations, and loading interface tables. Created Oracle Forms for error handling using Oracle APEX builder. Experienced in using various Oracle standard APIs for loading Inventory (INV) and Order Management (OM) base tables from interface tables. Performed data conversion for modules such as Open Accounts Receivable (AR), Item Cost, and Sub-inventory using Web ADI. Created BR100 documents for the Order Management (OM), Inventory (INV), and Accounts Receivable (AR) modules. Experienced in raising and closing GE-IT ServiceNow change requests and incidents for project requirements.