Oracle EBS Techno-Functional Consultant - City of Richmond
(2021-11)
Designed Oracle Financials (GL/AP/AR/FA) technical solutions and cloud migration strategies.
- Designed and implemented high-performance PL/SQL interfaces to transfer data from DPU systems to Oracle ERP, reducing manual processing by 20+ hours per week and improving data accuracy through automated validation and exception handling.
- Designed, developed, and supported PL/SQL-based customer interface programs to integrate customer data from Oracle APEX into Oracle EBS using Trading Community Architecture (TCA) APIs.
- Developed Customer/Invoice APIs, AutoInvoice, Cash Receipt interfaces, and built BI Publisher, Oracle APEX, and reconciliation reports.
- Developed and customized DSO (Debt Set-Off), TACS, and VRW (Vehicle Registration Withholding) collection letters for delinquent utility customers using Oracle BI Publisher and Oracle APEX Office Print (AOP), supporting automated generation and email distribution of personalized customer notices.
- Customized Oracle Advanced Collections (IEX) dunning letters and Collector Workbench enhancements; provided Tier-3 production support, Workflow/AME, and OAF customizations.
- Supported implementation and configuration of Oracle EBS Advanced Collections (IEX), including Strategies, Scoring Engines, Dunning Plans, Aging Buckets, and Collector Work Queues.
- Developed Oracle Reports (6i/10g), BI Publisher reports, FRS reports, and Oracle APEX Office Print (AOP) reports supporting financial, operational, and compliance reporting.
Oracle Cloud Techno-Functional Consultant - Leco Corporation
(2021-01 - 2021-10)
Led technical design and development activities supporting Oracle EBS R12.2 Supply Chain and Manufacturing applications across multiple business units.
- Partnered with business stakeholders to analyze warehouse, manufacturing, procurement, and order fulfillment requirements and deliver scalable Oracle EBS solutions.
- Supported Oracle modules including Inventory (INV), Order Management (OM), Purchasing (PO), Bills of Material (BOM), Work in Process (WIP), Warehouse Management (WMS), Cost Management, and Shipping Execution.
- Designed and developed complex SQL, PL/SQL packages, custom APIs, interfaces, conversions, reports, and workflows (RICEW objects) supporting end-to-end supply chain operations.
- Developed Item Master, Supplier, Purchase Order, Sales Order, Inventory Transaction, Receipt, and Shipping interfaces using Oracle Open Interface Tables and public APIs.
- Built automated inventory reconciliation and exception reports using Oracle BI Publisher to improve inventory accuracy and warehouse visibility.
- Customized Oracle Forms, OAF pages, and Workflow processes to support business-specific warehouse and manufacturing requirements.
- Developed interfaces integrating Oracle EBS with third-party Warehouse Management Systems (WMS), transportation systems, and external manufacturing applications.
- Performed root cause analysis for production incidents, reducing recurring supply chain issues through proactive monitoring and process improvements.
- Prepared functional design documents (MD050), technical design documents (MD070), unit test documents (TE020), deployment plans, and knowledge transfer documentation.
- Supported change management activities, production releases, code migrations, and continuous process improvements following Agile delivery methodologies.
Senior Software Engineer - Nevada Energy
(2020-02 - 2020-12)
Developed and supported Oracle HCM interfaces that integrate employee and HR-related data between Oracle EBS and external systems using PL/SQL and XML.
- Developed PL/SQL programs to extract, parse, and process XML data received from external applications.
- Designed and implemented exception handling and error logging frameworks to improve data quality and interface reliability.
- Developed PL/SQL packages, stored procedures, functions, and database objects to validate, transform, and load data into Oracle EBS.
- Prepared TE020 test documentation, including test scenarios, test cases, and execution outcomes for SIT and UAT.
- Part of the R12 upgradation project and responsible for migration of 11i RICEW objects to R12, including re-development of a complex interface between Oracle EBS r12 and third-party legacy applications.
- Created an Oracle Apex dashboard for WIP job monitoring and resource management for each Order.
- Worked on Oracle Apex conversion project, which includes conversion of Discoverer reports and Oracle custom forms into Oracle Apex applications and dashboards.
- Customized OAF pages as per user security, which includes personalization and customization of Oracle EBS OAF pages across P2P and financials.
Oracle EBS Consultant - Timex Group USA
(2019-02 - 2020-01)
Worked closely with Supply Chain, Manufacturing, Warehouse, and Order Management business users to gather requirements and translate them into scalable Oracle EBS R12.2 solutions.
- Supported Oracle EBS Supply Chain modules including Inventory (INV), Purchasing (PO), Order Management (OM), Bills of Material (BOM), Work in Process (WIP), Warehouse Management (WMS), and Shipping Execution.
- Designed and developed custom PL/SQL packages, procedures, functions, and concurrent programs supporting inventory transactions, production orders, purchasing, and order fulfillment.
- Customized Oracle Order Management workflows to support order booking, scheduling, pick release, shipping confirmation, and invoicing processes.
- Developed BI Publisher and Oracle Reports for Inventory Aging, On-Hand Quantity, Open Purchase Orders, Back Orders, Shipping Status, and Sales Order Summary.
- Supported manufacturing business processes including Bills of Material (BOM), Routings, Work Orders, Material Transactions, Resource Transactions, and WIP Job processing.
- Worked extensively with Oracle standard APIs for Customer, Item, Inventory, Sales Order, and Purchasing integrations.
- Resolved production support issues related to Inventory Transactions, Pick Release, Move Orders, Shipping Execution, Purchase Order approvals, and Manufacturing transactions.
- Collaborated with cross-functional teams during SIT, UAT, production deployment, and hyper-care support.
- Performed SQL and PL/SQL performance tuning to improve concurrent program execution and interface processing times by over 30%.
- Participated in Agile ceremonies including Sprint Planning, Daily Standups, Sprint Reviews, and Retrospectives while managing incidents through Jira.
Senior Software Engineer - Foremost Farms USA
(2018-03 - 2019-01)
Collaborated with business users and functional consultants to gather, analyze, and document business requirements, translating them into technical solutions.
- Developed PL/SQL packages to create and update Oracle Advanced Pricing Modifiers using Oracle standard public APIs.
- Customized and enhanced Order Summary and Invoice Summary reports using Oracle Reports and Oracle BI Publisher, including Direct Shipment, Pricing, and Sales Order reports.
- Designed and optimized complex SQL and PL/SQL scripts for data extraction, reconciliation, and validation.
- Developed data conversion programs using SQL*Loader to load legacy data into Oracle EBS, including customer conversion programs using TCA APIs.
- Customized Oracle EBS behavior using Forms Personalization for business validations and UI enhancements.
- Participated in full SDLC including requirements analysis, design, development, testing, and deployment.
Senior Software Engineer - Accenture Services Private Limited
(2014-12 - 2016-08)
- Developed customer and invoice interfaces using SQL and advanced PL/SQL to integrate Oracle EBS with external systems for JP Morgan Chase.
- Designed and deployed reports using Oracle Reports 10g and BI Publisher to support financial and operational reporting requirements.
- Developed training tutorials using User Productivity Kit (UPK) for the Australian Department of Defense to support Oracle EBS end-user adoption.
I.T. Analyst - Tata Consultancy Services
(2010-08 - 2014-11)
- Developed supplier, customer, AP Invoice, and AR Invoice interfaces using SQL and PL/SQL to integrate Oracle EBS with external systems for client Stolt Nielsen.
- Developed HCM interfaces and reports to integrate Oracle EBS with external systems for client Huntington National Bank.
- Customized Oracle Forms and personalized OAF pages based on business user requirements.
