Lavanya Bogireddy

1. Fayetteville Public Works Commission (FPWC), Tristate (OIC, Oracle Object Storage, Oracle DB, SQL)

• Designed and implemented multiple Oracle Integration Cloud (OIC) integrations, including solutions for Oracle HCM (employee data management), E-Business Suite (EBS), and Oracle Field Service Cloud (OFSC), Enterprise resource planning (ERP) enabling seamless data exchange across enterprise applications.
• Leveraged SOAP and REST web services, database adapters, utility adapters, HCM Cloud, ERP, FTP,ATP to streamline data transactions and improve integration efficiency.
• Designed and developed integration interfaces for data exchange between ERP and WACS, covering financial modules like Fixed Assets, Accounts Payables (AP), and Accounts Receivables (AR), with robust data mapping, transformation, and error handling.
• Implemented bulk data import and reporting solutions using File-Based Data Import (FBDI), BI Publisher (BIP) Reports, ensuring accurate data processing, validation, and reconciliation across systems.
• Managed employee data integrations in HCM using ATOM Feeds, HCM Extracts, and HCM Data Loader (HDL), enabling efficient data synchronization, uploads, and maintenance with high data integrity.
• Developed and enhanced integrations by resolving defects, implementing change requests, and optimizing performance, while collaborating with cross-functional teams, performing testing and root cause analysis, and supporting successful production go-live with adherence to best practices.

2. Retail Integration (RIT) (OIC Gen3)

• Designed and developed multiple integrations to streamline data exchange between WMS, MFCS and SIOCS, OOCS, ensuring accuracy and consistency across business systems.
• Built and configured both scheduled and real-time integrations using REST adapters with OAuth-based authentication to enhance security and reliability.
• Led OIC Gen3 integrations, projects development using advanced Gen3 features and complex XSLT mappings, java scripts implementing retry mechanisms, reusable connections, standardized error handling, modular design, and publish-subscribe patterns for scalable, event-driven integrations.
• Performed regression testing and production support by optimizing performance, resolving defects, handling change requests, and conducting root cause analysis, while leveraging AI tools to automate and accelerate XSLT mapping development, and delivering reusable solutions as OIC recipes and accelerators in collaboration with cross-functional teams to ensure smooth production go-lives.
• Worked with OAuth and Basic Authentication mechanisms using service accounts, and performed Connectivity Agent installation and configuration to enable secure integration between cloud and on-premise systems.

3. Gas-South, EWA (OSB, SOA, MFT, Oracle Object Storage, Shell Script)

• Delivered OSB integration solutions that significantly improved data flow and interoperability between AGL and CCS applications.
• Designed and implemented a SOA-based Market Monitoring Tool to automate daily MTM transaction reporting and alert business teams to anomalies, while monitoring and debugging CCS market message transactions to provide analytics-driven insights and ensure reliable production service delivery.
• Worked extensively with File, Database, SOAP, and REST and JMS adapters to build and support robust integration solutions.
• Developed SOA and OSB solutions for EWA, building integrations between LGGS, IZARNET, SEP2W, and AMS, debugging issues including Java callouts, enhancing Java code, and utilizing File Adapter, Database Adapter, SOAP/REST web services for optimized data exchange.