Lakshmi Prasanna Thota
Toronto,Canada
Summary
Oracle EBS Technical Developer with 3+ years of experience in designing, customizing, and integrating ERP solutions. Proven expertise in RICE components (Reports, Interfaces, Conversions, Extensions), Oracle Apex web development, and Oracle Integration Cloud (OIC) integrations. Skilled in optimizing SQL performance, automating financial processes, and delivering high-quality technical solutions that improve efficiency and accuracy.
Overview
4
4
years of professional experience
Work History
Systems Engineer
Tata Consultancy Services (TCS)
Hyderabad
08.2021 - 02.2025
- Designed and developed PL/SQL packages, procedures, functions, triggers, and cursors to meet complex business requirements for Oracle E-Business Suite R12.2.5.
- Created and optimized RICE components (Reports, Interfaces, Conversions, Extensions) to support Accounts Payable (AP) and Inventory modules.
- Built Oracle Apex applications to enable faster and user-friendly data management.
- Automated payment and inventory data uploads using control files, PL/SQL, and Unix shell scripting, reducing manual work by 40%.
- Developed interface programs to securely transmit payment data to banking systems, ensuring regulatory compliance.
- Performed SQL performance tuning, improving query execution times by up to 50%.
- Integrated Oracle Fusion applications (SAAS & PAAS) with EBS using OIC, streamlining data flows and scheduling automated jobs.
- Developed BI Publisher reports in Oracle Fusion to improve financial reconciliation accuracy.
- Provided L2/L3 production support, diagnosing issues, replicating scenarios, and implementing fixes.
- Led daily status calls for an 80-member cross-functional team and conducted peer code reviews.
- Trained 5+ new hires on XML Reports, Interfaces, Conversions, and Oracle Apex development.
Education
Bachelor of Technology (B.Tech) - Information Technology
Vignan's Lara Institute of Technology and Sciences
Vadlamudi, India01.2021
Skills
- Oracle E-Business Suite (R1225) - AP and Inventory modules
- Oracle Apex web development
- SQL and PL/SQL programming
- RICE components development
- Oracle Fusion integrations via OIC
- BI Publisher and XML reports
- Unix shell scripting
- SQL performance tuning
- Database management: Oracle R1225
- Development tools: SQL Developer, WinSCP, PuTTY
- Operating systems: Linux and Unix
Languages
- Languages: English, Telugu
Awards
- Certified in Linux Administration, SQL Performance Tuning, and Oracle Apex Development (Udemy).
- Recognized within TCS for delivering complex AP module customizations ahead of schedule.
- Received multiple internal badges for active participation in corporate initiatives.
ADDITIONAL INFORMATION
- Canadian PR - Eligible to work without sponsorship.
Timeline
Systems Engineer
Tata Consultancy Services (TCS)
08.2021 - 02.2025
Bachelor of Technology (B.Tech) - Information Technology
Vignan's Lara Institute of Technology and Sciences
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Gyata JainGyata Jain
Senior SQL Server DBA at Tata Consultancy Services (TCS)Senior SQL Server DBA at Tata Consultancy Services (TCS)
Praveen Kumar GorantlaPraveen Kumar Gorantla
Test Lead at Tata Consultancy Services (TCS)Test Lead at Tata Consultancy Services (TCS)
Jenny Cheng LYUJenny Cheng LYU
Salad Prep Cook (Cold Station) at Cafe on the SquareSalad Prep Cook (Cold Station) at Cafe on the Square