Oracle E-Business Suite and Fusion Consultant

NAVEEN KUMAR PACHIMATLA

Oracle Technical Consultant

Butler, WI United States 414-***-**** *********************@*****.*** PROFESSIONAL SUMMARY

• Over 5+ years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i).

• Oracle Apps Technical Consultant with hands-on experience in Oracle E-Business Suite (R12) development, Oracle Fusion Cloud ERP, customization, and production support

• Strong foundation in SQL and PL/SQL, with practical experience building Oracle Forms, Reports, Interfaces, Fusion Cloud, and Extensions to support business operations.

• Experience with Oracle Fusion Cloud ERP modules including Financials, SCM, and HCM, with working knowledge of tools such as BI Publisher, OTBI, FBDI, and HDL.

• Experienced in building and consuming REST and SOAP web services and working with Oracle Integration Cloud (OIC) for end-to- end integrations.

• Extensive experience in implementation, Migration, Customization, Production and support of various modules including Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), BOM, Warehouse Management System (WMS), and IProcurement.

• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).

• Experience in Procure to Pay (P2P), Order to Cash (O2C) life cycles and Supply Chain business flows.

• Strong Knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and SDLC.

• Strong understanding of reporting and analytics in Fusion using OTBI and BI Publisher, along with experience in data extraction, transformation, and loading processes.

• Experience supporting UAT and production environments, ensuring timely issue resolution and system stability.

• Strong ability to analyze business processes and functional requirements and translate them into scalable technical solutions. TECHNICAL SKILLS

Programming & Scripting: SQL, PL/SQL, Python, PHP, HTML, CSS, Bootstrap Databases: Oracle 12g, MySQL

Oracle & ERP Applications: Oracle E-Business Suite (R12), Oracle Fusion Cloud ERP (Financials, SCM, HCM), Oracle Forms Builder, Oracle Reports Builder

Oracle Fusion Tools & Technologies: BI Publisher, OTBI, FBDI, HDL, REST/SOAP APIs, Oracle Integration Cloud (OIC) Database Technologies: Oracle 12g, MySQL – Tables, Views, Indexes, Joins, Stored Procedures, Functions, Packages Security & Compliance: Cybersecurity Fundamentals, Secure Coding Practices, Computer Ethics PROFESSIONAL EXPERIENCE

Oracle Apps Technical Consultant Jun 2024 – Present Argano Consulting Services Plano, TX United States

• Designed, developed, and customized Oracle E-Business Suite (R12) solutions to meet client-specific business requirements.

• Built and enhanced Oracle Forms, Reports, Interfaces, and Extensions using SQL and PL/SQL.

• Collaborated with functional consultants and project managers to translate functional specifications into technical designs.

• Developed, tested, and deployed new reports and forms, ensuring adherence to quality and performance standards.

• Provided production support and troubleshooting for Oracle EBS applications, resolving defects and system issues efficiently.

• Conducted end-user training sessions and prepared technical documentation to support application usage and maintenance.

• Worked with Oracle Fusion Cloud ERP modules (Financials/SCM/HCM), developing and customizing reports using BI Publisher and OTBI to support business reporting requirements.

• Developed and supported data integrations using FBDI, HDL, and REST/SOAP APIs, with exposure to Oracle Integration Cloud

(OIC) for seamless data exchange between Fusion and external systems.

• Worked on the development of interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash cycles touching various modules such as AR, PO, AP, and GL.

• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs.

• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

• Interacted with users, fixed the bugs, developed test plans and provided daily production support. Oracle Apps Technical Consultant Feb 2020 – Jun 2023 Depth Consulting Services Mumbai, MH, India

• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL Loader, UTL_FILE, and Oracle packaged APIs.

• Expert in developing technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

• Experience in customizing Oracle Workflows such as the PO approval process, Order/Line Flow to send user notifications based on business requirements.

• Strong in Performance Tuning, UNIX shell scripting.

• Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS, and STATSPACK.

• Implemented AP Invoice import through Payables Open Interface Import Program.

• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

• Developed AUTOLOCKBOX Interface to load data received from bank into interface tables (AR_PAYMENTS_INTERFACE_ALL), from interface table to Base Interim tables and finally to base tables.

• Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts from legacy system to Payables.

• Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos. Customizations of Requisition Approval, PO Approval & Auto Create Workflows.

• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

• Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables.

• Developed UNIX Shell scripts to FTP flat files from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving.

• Developed custom templates for invoice reports by calling sub templates in XML/BI Publisher. EDUCATION

Master’s in computer science and information technology, GPA 3.3 Aug 2023 - Dec 2025 Concordia University of Wisconsin Mequon, WI

Contact this candidate