Open to opportunities

Darshan Lodhari

@darshanlodhari

Message

Oracle EBS technical consultant building APEX, integrations, and automation to fix production issues.

India

Message

What I'm looking for

I’m looking for an Oracle EBS-focused team where I can own end-to-end technical development and integrations—using APEX/PL-SQL and reliable SOA/EDI/SFTP/REST—to reduce manual work, improve production stability, and deliver measurable efficiency gains.

I’m an Oracle EBS (R12) technical consultant with 4+ years of experience across Order Management, Inventory, Manufacturing, and Accounts Payable. I specialize in custom APEX/PL-SQL development, third-party integrations, SQL performance tuning, and BI Publisher reporting.

As a Senior Consultant at Buchanan Technologies (January 2022–Present), I independently handle Oracle EBS R12 technical development—covering custom solutions, data integrations, and automation. I also prepare detailed technical documentation, including sanity testing plans, implementation guides, and validation reports.

I build production-ready applications that reduce manual work and improve reliability. For example, I designed an Oracle APEX solution for WIP Move Transactions, integrating with Oracle WIP interface tables and adding validations, error handling, and transaction status tracking.

I also created a Resource Capacity Planning & WIP Shortage Dashboard in Oracle APEX, integrating WIP/BOM/Inventory/Routing to deliver real-time visibility with custom SQL/PL-SQL calculations, automated shortage flagging, and interactive reporting. I’ve delivered multiple EBS integrations (EDI/SFTP/REST/SOAP) and AP invoice automation with minimal post-production issues, improving efficiency and accuracy through automated workflows.

Experience

Work history, roles, and key accomplishments

Current

Senior Consultant

Current

Buchanan Technologies

Jan 2022 - Present (4 years 6 months)

Delivered Oracle EBS (R12) technical developments including custom solutions, data integrations, and automation. Prepared technical documentation (sanity testing plans, implementation guides, and validation reports) and implemented multiple APEX/PL-SQL and integration initiatives.

Apex Pl SQL SQL Oracle Integration Cloud OAF Oracle Forms Oracle Reports WIP BOM Inventory Order Management Accounts Payable EDI SFTP Data Validation Error Handling

WIP Move Transaction

Oracle APEX

Designed and developed a custom Oracle APEX application for WIP move transactions between operations and work centers. Integrated with Oracle WIP interface tables and automated transaction processing with PL/SQL validations and error handling.

Apex Pl SQL Oracle WIP Interface Tables Data Validation Error Handling Transaction Processing

OMA Automation

Conexiom

Automated sales order integration between Oracle EBS and Conexiom using SFTP to reduce manual effort. Used PL/SQL programs/concurrent processes to validate, transform, and load order data, including EDI 850 inbound processing to create sales orders in Oracle.

SFTP Pl SQL Concurrent data transformation

Resource Capacity Planning

Oracle APEX

Built an Oracle APEX dashboard for production capacity planning and manufacturing resource utilization. Integrated Oracle EBS R12 modules and implemented custom SQL/PL-SQL logic for utilization and WIP component shortage analysis with interactive reporting.

Apex SQL Pl SQL WIP BOM Inventory Routing Interactive Reports Conditional Formatting

AP Invoice Automation

Esker

Integrated Oracle EBS Accounts Payable with Esker via SFTP-based file exchange for invoice processing automation. Exported master/transaction data in CSV, posted invoice XML into Oracle, and automated invoice creation and acknowledgement updates throughout the invoice lifecycle.

Esker SFTP CSV XML Acknowledgement Handling Payment Approval Confirmations