ATHILAKSHMI G

• Developed custom PL/SQL packages to validate, transform, and load sales order data into PaaS staging tables, facilitating seamless Oracle Fusion SaaS sales order creation.
• Enhanced PL/SQL performance for SaaS-to-PaaS sync by optimizing SQL queries, processing logic, and database operations, leading to improved data processing efficiency.
• Supported Oracle Integration Cloud integrations with third-party systems and Oracle Fusion through REST APIs for sales order creation and data synchronization.
• Supported 3PL ship confirmation integration with Oracle Fusion through REST APIs and OIC by mapping payloads, validating data, and resolving errors..
• Generated BI Publisher reports for commercial invoice output, sales order extraction, and synchronization of sales agreements between Oracle Fusion SaaS and PaaS, enhancing reporting accuracy.
• Built OTBI reports and analyses in the Order Lines Real-Time subject area for sales agreement and order management details.
• Developed Oracle Order Management extensions in Groovy to add custom insurance calculation logic for sales orders.

• Created OIC integration to automate sales order generation in SaaS from third-party system through REST API.
• Developed custom package to load sales order cart details into PaaS table, streamlining sales order creation.
• Improved performance of SaaS-to-PaaS custom package process.
• Assisted in the development of an OM extension for insurance calculations in sales orders. for insurance calculation in sales orders using a Groovy script.
• Built BI Publisher reports for commercial invoice print, sales order extract SaaS-to-PaaS sync, and sales agreement sync.
• Created OTBI reports for Order Management with real-time order line data and sales agreement details.
• Supported ship confirmation integration from 3PL to Fusion through REST API.
• Tested REST API calls through Postman.

• Supported development of sales order acknowledgment and intercompany AR invoice print reports for Vietnam and US operating units using Oracle XML Publisher and Report Builder.
• Built and maintained intercompany trade (ICBT) invoice print reports, including XML data extraction, report layouts, and business-specific formatting requirements.
• Coordinated technical design and architecture for Oracle EBS reporting and customization requests by reviewing standard functionality and mapping technical solutions.
• Created wrapper concurrent program for ICBT SOA invoice print report to remove operating unit restrictions and enable execution across multiple OUs.
• Performed SQL and PL/SQL tuning for ICBT SOA report by reviewing queries, joins, data retrieval, and report performance.
• Gathered requirements and conducted technical analysis by translating functional needs into Oracle EBS technical solutions and implementation recommendations.
• Delivered UAT and post-development support through defect analysis, troubleshooting, root-cause identification, fixes, retesting, and coordination with functional and business teams.
• Provided UAT and post-development support through defect analysis, troubleshooting, root-cause identification, fixes, retesting, and coordination with functional/business teams.

• Customized Oracle APEX for credit memo process, implementing page enhancements, validations, and meeting specific business requirements.
• Built and maintained Oracle Receivables customizations for tax adjustments during claims process and project billing extensions, adding required validations and processing logic.
• Contributed to technical design and architecture for Oracle EBS by analyzing functional specifications and developing solutions using standard EBS functionality and custom RICE components.
• Customized Oracle Forms, including enhancements to XXINT custom event form with validations, event-based logic, and required business functionality.
• Worked with Oracle AR lockbox functionality for automated processing of customer payment and remittance information, and assisted with related technical troubleshooting.
• Automated unit testing for various RICE components using utPLSQL test packages, enhancing test coverage and validation of custom Oracle EBS developments.
• Handled XML and JSON payloads for inbound and outbound integrations, including payload validation, data mapping, transformation, and troubleshooting of integration issues.
• Built and supported custom project billing extensions using Oracle EBS technical components, including PL/SQL-based processing, validations, and integration with standard project billing functionality.
• Developed and supported custom project billing extensions using Oracle EBS technical components, including PL/SQL-based processing, validations, and integration with standard project billing functionality.

Oracle EBS Technical Consultant – IBM.

• Supported Oracle E-Business Suite (EBS) custom development, data conversion, interfaces, and reporting across Procurement and Inventory modules.
• Built supplier master data conversion solution using PL/SQL packages, procedures, and validation rules to migrate supplier records into Oracle EBS.
• Aligned source data with Oracle EBS business and technical requirements by creating data validation and transformation routines before loading into target supplier tables and interfaces.
• Developed Oracle XML Publisher (BI Publisher) reports for Purchase Order (PO) module, focusing on XML data generation, report templates, formatting, and integration with Oracle EBS concurrent processing.
• Built custom PL/SQL inventory interface to move inventory-related data from SAP source systems into Oracle EBS.
• Created interface logic for extraction, validation, transformation, error handling, and loading, facilitating integration between SAP and Oracle EBS.
• Performed technical analysis, unit testing, defect resolution, and troubleshooting for custom Oracle EBS programs and interfaces.
• Performed technical analysis, unit testing, defect resolution, and troubleshooting of custom Oracle EBS programs and interfaces.

• Supported conversion track activities.
• Built conversion program for GL BOM and item conversion.
• Managed performance tuning tasks for conversion objects such as approved supplier list and sourcing rule.
• Prepared MD070 test case documents and fixed defects.
• Created technical design documents (MD70) for conversion objects.
• Project:
• Role:
• Role:

• Supported customization of existing reports and interfaces for OM conversions.
• Created custom reports using XML Publisher.
• Assisted with document preparation tasks, including MD070 and unit testing.
• Resolved high-priority tickets from production and delivered permanent fixes.

• Built and maintained SQL queries, PL/SQL stored procedures, functions, packages, triggers, cursors, and database scripts based on business and application needs.
• Reviewed code, ran unit tests, fixed defects, and supported code quality, accuracy, maintainability, and development standards.
• Troubleshot production issues, performed root-cause analysis for SQL/PLSQL errors, and applied timely fixes with minimal business disruption.
• Optimized SQL and PL/SQL code for performance and scalability, including query optimization, efficient joins, indexing considerations, and improved data-processing logic.