Accounts Payable Receivable

Name: Nagasai(Sai) Pagadala

Contact Information:

Phone: 205-***-****

Email: ******@*****.***

Professional Summary

** + Oracle Techno-Functional SME experience in Accounts Receivable (AR), Accounts Payable (AP), Inventory (INV), Order Management (OM), Procurement, Purchasing (PO), Oracle Cash Management (OCM), Advance Collections, Credit Management, Credit Management (AME), Projects and General Ledger (GL). Expertise in Oracle E-Business Suite (11i thru R12) and Oracle Cloud Infrastructure (OCI - IaaS). Skilled in PL/SQL, Oracle Application Framework (OAF), RICE, Workflow, Shell Scripting, Python, and advanced API integrations. Demonstrated ability to handle complex bank integrations for payment processing, statement reconciliation, and receipt automation. Proven track record of migrating on-premises systems to OCI and optimizing business processes, ITN filing and trading partner screening. Successfully automated receipts processing implemented multi-currency in Receivables and developed multi-currency wire payments processes in AR and AP. Experienced in creating and managing Service Requests (SRs) with Oracle Support to deploy patches, upgrades and data fixed. Automated AR credit card processes, including capturing credit card information, handling preauthorization, and executing final settlement. Designed and developed a custom Oracle APEX application to track chemical usage, cartridge consumption, and returns across multiple laboratories, enhancing material accountability and operational transparency. Enabled dynamic QR code label generation for chemicals and cartridges, allowing users to scan and update stock movements (issue, return, disposal) using mobile or desktop interfaces. Developed workflows to track cartridge lifecycle, including issuance, usage tracking, and return, aligned with safety and reuse protocols. Integrated APEX with Oracle Inventory module to pull Quality-approved receipt transactions into sub inventories, ensuring only QA-cleared materials are available for lab use.Configured bank accounts and document types for multiple payment methods across different accounts and branches local/global banks. Worked on multiple Oracle application upgrades and legacy system migrations, successfully integrating and converting external interfaces, as well as performing Oracle setups and configurations. Configured and installed Advanced Collections and Credit Management. Conducted discovery sessions for various projects, gathered business requirements from business users, and performed requirement analysis to design and translate them into functional and technical requirements for development. Actively involved in the implementation of Oracle Cash Management (OCM) to improve reconciliation with bank statements. Used API to upload shipping documents from Oracle Application Server to SharePoint, Automated loading BAI2 files from banks into Oracle, creating receipts, and applying them to invoices to streamline cash application and reconciliation processes. Successfully implemented and integrated Concur Expense System with Oracle Accounts Payable and General Ledger, interfacing multiple expense types. Worked actively in implementing the India Operating Unit for Oracle Applications and setting up multiple GL Ledgers for accounting. Developed and implemented a bulk procurement system for purchasing based on forecasting, optimizing inventory management and procurement planning. Successfully implemented Multi-Org and Multiple Ledgers in Oracle Applications, ensuring streamlined operations and compliance across multiple business units. Migrated Accounts Payable from 11i to R12 in less than 3 weeks, including all bank, multiple payments setups, code changes, ensuring a smooth transition with minimal business disruption. Created an international currency exchange daily rate process using API to get files from the OANDA, automating the fetching of currency exchange rates and loading them into the General Ledger.

Expert in the full development lifecycle of RICE components:

Reports: Designed and developed custom Oracle Reports and BI Publisher templates for AR, AP, and GL reporting needs.

Interfaces: Built and integrated inbound/outbound interfaces with third-party systems (banks, Concur, OANDA, Pega, CBP) using REST/SOAP APIs and SFTP.

Conversions: Led data migration projects converting legacy system data (customers, suppliers, invoices, payments) into Oracle EBS using validated conversion scripts.

Extensions: Customized seeded forms and workflows; developed custom workflows for ITN filing, trading partner screening, and credit card preauthorization/final settlement.

Strong expertise in Oracle Application Framework (OAF):

Developed custom OAF pages to support project-specific functionality.

Personalized seeded OAF pages to improve user experience and streamline business workflows.

Integrated OAF forms with backend APIs for seamless data processing and real-time updates.

Education & Certifications

•Master of Business Administration (MBA) – Delaware State University

•Bachelor of Science – Osmania University, India

•Oracle E-Business Suite R12 Financials Certified (AR) – Oracle Certified Specialist (Accounts Receivables)

Professional Experience

Oracle EBS Financials Techno Functional Specialist

US Pharmacopeia March 2008 – March 2025

•Led successful migration from on-premises Oracle EBS to Oracle Cloud Infrastructure (OCI - IaaS), ensuring minimal downtime and operational continuity.

•Executed the 11.5.10 to R12 migration across AR, AP, INV, OM, PO, OCM and GL modules, enhancing functionality and performance.

•Designed and implemented API-based integrations with multiple banks for processing Checks, ACH, wire transfers, and virtual card payments in Accounts Payables

•Automated receipt creation and application using Oracle APIs from lockbox, BAI2, and EDI files, reducing manual effort by 70% and improving efficiency.

•Implemented multi-currency functionality in Receivables to support international operations to accept receipts in EUR, CAD and GBP.

•Developed and automated multi-currency wire, ACH payment processes in Payables, ensuring to purchase and pay in the vendor currency.

•Automated AR credit card processes, including capturing credit card information, handling preauthorization, and executing final settlements after invoicing.

•Configured bank accounts and document types for multiple payment methods across different bank accounts and branches for Accounts Payables.

•Configured and installed Advanced Collections and Credit Management to setup strategies and approval management(AME) for improving collections and risk mitigation.

•Developed automated workflows for ITN filing with Customs and Border Patrol (CBP) to streamline international export processes.

•Created advanced processes for trading partner screening (customers, suppliers, and employees) to ensure compliance with regulatory guidelines.

•Created and managed Service Requests (SRs) with Oracle Support to resolve critical production issues, deploy patches, and implement data fix scripts.

•Worked on multiple Oracle application upgrades and legacy system migrations, successfully integrating and converting external interfaces, and performing Oracle setups and configurations.

•Developed RICE, Oracle Reports, created custom Oracle Forms, Conversion and Enhancement, personalized seeded forms to enhance user experience and reporting functionality on multiple projects.

•Developed new Custom OAF forms for Specific Project needs and personalized seeded OAF Forms.

•Used REST API to upload shipping documents from Oracle Application Server to SharePoint, improving accessibility and streamlining document management.

•Designed and implemented API-based integrations with multiple banks for processing ACH, wire transfers, and virtual card payments.

•Migrated Accounts Payable from 11i to R12 in less than 3 weeks, including all bank setups and code changes, ensuring a seamless transition.

•Developed and implemented a bulk procurement system for forecast-based purchasing, improving inventory management and procurement planning.

•Created an international currency exchange daily rate process, integrating real-time API data into the General Ledger.

•Configured bank accounts and document types for multiple payment methods across different accounts and branches.

•Oracle APEX – Laboratory Inventory and Quality Integration System

Designed and developed a custom Oracle APEX application to track chemical usage, cartridge consumption, and returns across multiple laboratories, enhancing material accountability and operational transparency.

Enabled dynamic QR code label generation for chemicals and cartridges, allowing users to scan and update stock movements (issue, return, disposal) using mobile or desktop interfaces.

Developed APEX Forms to track cartridge lifecycle, including issuance, usage tracking, and return, aligned with safety and reuse protocols.

Integrated APEX with Oracle Inventory module to pull Quality-approved receipt transactions into sub inventories, ensuring only QA-cleared materials are available for lab use.

Built real-time dashboards and reports to:

oMonitor stock levels and usage trends across labs

oTrigger alerts for low inventory thresholds

oTrack QA release status for received inventory

•Improved inventory visibility, reduced manual errors, and ensured regulatory compliance by automating lab material tracking and integrating Oracle backend systems.

•Configured and installed Advanced Collections and Credit Management to improve collection strategies and risk mitigation.

•Successfully implemented Multi-Org and Multiple Ledgers to support business expansion across different geographies.

•Automated loading BAI2 files into Oracle, creating receipts, and applying them to invoices, ensuring seamless cash application and reconciliation. Implemented API integration from Oracle EBS to Pega for inventory data, ensuring real-time data synchronization and process automation.

•User Training and Post-Go-Live Support

•

Oracle Applications Consultant

BellSouth, Birmingham, AL

2008

Worked on Oracle Applications 11.5.1 in Accounts Receivable (AR) for loading CLEC invoicing details into AR from flat files.

Developed processes for creation of invoices for 7 states, managing multi-million billing lines per invoice.

Integrated receipt creation with multiple clients, ensuring accurate capture of invoice details.

Designed and automated 22 billing cycles for 12 interfaces, processing billing data for 22 days per month.

Led enhancements and performance tuning of mass invoice creation and revenue processing.

Technical Skills

•ERP Systems: Oracle E-Business Suite (11i, R12.1.x, R12.2.x), Oracle Cloud Infrastructure (OCI - IaaS)

•Languages: SQL, PL/SQL, Python, Shell Scripting

•Frameworks & Tools: OAF, BI Publisher, FSG, TOAD, Workflow, Oracle Forms, Oracle Reports, Conversions and Integration (RICE).

•Integration: REST, SOAP, SFTP

Contact this candidate