Venkataratnamma G.
Senior Oracle Application Technical Developer
Open to offersNew to PlatformAbout
Ratna G. is a seasoned Oracle Application Technical Developer with over 7 years of comprehensive experience specializing in the Oracle e-Business Suite (R12) implementation, upgrades, and customization. Currently working with S&V Tek Systems LLC, Ratna brings expertise in Order Management (OM), Inventory (INV), General Ledger (GL), and more. Proficient in the development of RICE components, Ratna is skilled in leveraging SQL*Plus, PL/SQL, and SQL*Loader for data migrations and report generation. Throughout projects for prominent clients such as Cisco, Sherwin-Williams, Smiths Group, and Skechers, Ratna has delivered solutions involving complex data conversion and migration tasks, technical design documentations, and system administration. With a solid grounding in Application Implementation Methodology and performance tuning, Ratna has actively participated in SCRUM methodologies to ensure efficient project execution and high-quality deliverables. A graduate of Sri Venkateswara University with an M.Sc. in Computers, Ratna is adept at collaborating with cross-functional teams to achieve seamless integration and optimal system performance.
Experience
Technical Consultant
Cisco Systems, Inc. · 2023 — PresentEngaged in the development of reports while customizing Oracle BIP Reports for the Order to Cash cycles, interacting with various modules such as Inventory and Order Management. Implemented specific reports including the SONS Scrap Order Report and New buy RTO Report to present customer information along with start and end date destruction. Created diverse order types including RMA, Allocation, Repair, and SONs Orders. Participated in enhancements for standard APIs and custom packages, including the enhancement of 4B2(Receiving) through new procedure development. Developed custom logic for Form Personalization using ZOOM Functionality and engaged in Scrum QA testing by designing and executing test scenarios alongside cross-functional teams to secure quality deliverables.Technical Consultant
Sherwin-Williams · 2022 — 2023Focused on developing interfaces, data conversions, and customizing Oracle Reports for the Order to Cash cycles that involved modules like AR, PO, AP, and GL. Implemented the AP Invoice import through the Payables Open Interface Import Program while partaking in customer conversions to integrate customer details into HZ tables via staging tables and TCA APIs. Created an outbound interface for journals and migrated vendor information from legacy systems to Oracle Purchasing. Developed custom forms using Forms 10g to manage lookup cross-reference values and executed various tasks involving FNDLOAD to transition concurrent programs and data definitions.Technical Consultant
Smiths Group · 2020 — 2022Participated in daily production support activities within the Oracle applications environment, primarily across AP, PO, OM, INV, AR, and GL modules. Analyzed support tickets by replicating issues and examining the corresponding custom processes, APIs, reports, and forms. Developed solutions for issue resolution, including unit testing and facilitating user testing while closing tickets. Engaged closely with users to understand their business needs, ensuring responsive application support. Customized Oracle standard and custom forms based on client specifications and developed AR Invoice Report Customization with print capabilities utilizing Reports 10g and XML Publisher.Technical Consultant
Skechers · 2019 — 2020Worked as an Oracle Apps Data Migration Consultant specializing in modules such as AP, AR, OM, PO, and INV. Engaged in design reviews, coding, and testing following the Oracle AIM methodology. Developed triggers to implement complex business rules and utilized SQL*Loader scripts for migrating invoice data from flat files to staging tables before executing the auto invoice interface. Created PL/SQL procedures for validating invoice data prior to importing it into the Account Receivables interface tables and developed an outbound interface for GL Balances as required by the extract specifications.
Skills & Expertise
Education
- M.Sc. (Computers)Sri Venkateswara University · 2010 — Present
Interested in this professional?
Sign in as an employer to save this profile or invite Venkataratnamma G. to a job.
Sign in as an employer