Venugopal G

Oracle EBS Developer

+1 (214) 892-7503 | email2gvg@[Link] | LinkedIn
PROFESSIONAL SUMMARY:

 Having 14+ years of experience on Oracle Applications E-business Suite Release 11i, R12 (12.1.3 & 12.2.3), Oracle
Integrated SOA Gateway, Oracle REST Data services(ORDS), Oracle Fusion Applications(R13) & Oracle Integration
Cloud(OIC), Oracle SQL, PL/SQL, Reports 6i & XML Reports (RDF & DATA Template).
 Involved in R12 up-gradation (from [Link] to 12.1.3) project on PO, AP GL and AR modules.
 Having Account Payables SR support experience on Oracle Applications E-business Suite Release 11i and R12.
 Extensively worked on Interfaces and conversions.
 Expertise in Oracle Tools SQL, PL/SQL, Reports, XML Publisher Reports.
 Having excellent technical and novice Functional knowledge of the Finance Modules ( AP, GL, AR & FA), Distribution
modules (PO, INV & OM) and HRMS Modules (Core HRMS & OTL)
 Good knowledge on Procure to Pay Cycle and Order to Cash cycle.
 Good exposure in AOL and SYSADMIN Activities.
 Having good experience with TOAD and SQL * Loader to load data from flat files.
 Having good experience on Creation of Value Sets, Lookups, DFF Context values, Alerts, Materialized views and
PL/SQL Stored Procedures.
 Having experience of using SOAP and REST services in PLSQL.
 Expertise in SOAP and REST APIs and FBDI Integrations for Oracle cloud ERP to integrate it with other third-party
applications
 Having good experience in Production support projects.
 Expertise in handling, coordinating and interacting with the client.
 Highly motivated, energetic individual and a team player with excellent communication, analytical and problem-
solving skills.

SOFTWARE SKILLS:
ERP : Oracle Applications E-Business suite 11i & R12, Oracle Fusion applications(R13)
Modules : GL, AP, FA, PO, INV, OM, AR, HRMS and OTL
Technical Modules : SYSADMIN, AOL.
Languages : PL/SQL, SQL.
OS : Windows NT, UNIX.
Database : Oracle 9i
GUI : Reports 6i, XML Publisher Reports
Other Tools : Toad, SQL *Loader
Packages & Utilities : MS-Office, Data Loader, FNDLOAD, UTL_HTTP&UTL_FILE

PROFESSIONAL EXPERIENCE:

Senior Oracle Application Developer, Client: Beachbody, El Segundo, CA July 2019

– Present
Modules: PO, AP, FA, AR, GL & Integrated SOA Gateway (Production Support & Enhancements)

 Involved in OCI migration project.

 Involved in SOX Compliance project identifying critical issues and configuring daily/hourly Alerts.
 Involved in development of Suppliers, Purchase orders & Payments extraction and sharing the file to IQBACKOFFICE
using SFTP.
 Involved in development of Payables Invoices (Supplier) interface from IQBACKOFFICE.
 Involved in development of VISA, MASTERCARD& AMEX Account updater process for credit cards (change or ex -
pired).
 Involved in development of Credit card tokens (Cyber source) conversion.
 Automated AR Receipt creation and reprocessing of errored Cash/Miscellaneous receipts to Cyber source.
 Involved in Configurations & Development of EDI810 Integration process.
 Involved in Configurations of AMEX BIP SFTP Transmission Protocol.
 Involved in development of VINDCIA process.
 Involved in development of Oracle Integrated SOA Gateway Integrations with AWS.
 Involved in development of invoking AWS API’s from PLSQL using UTL_HTTP utility.
 Automated critical AR weekly reconciliation improving operational efficiency adding savings of $100K
 Integrated Order Management with other EBS modules such as Inventory, Shipping Execution, and Accounts
Receivable.
 Involved in Account analysis XML report customization.
 Involved in creating periodic Alerts Production.
 Involved in development of FA location transfer process.
 Involved in development of AR Adjustments creation Interface for Refunds.
 Involved in development of Suppliers & Bank account details interface.
 Involved in development of AP Payables Invoices (Media) interface from Pioneer.
 Involved in development of sharing AP & Workday Positive Pay files to Wells Fargo and Bank of America using SFTP.
 Involved in development of GL interface (Employee Payroll) from Workday.
 Involved in development of GL interface (Employee Expenses) from Concur.
 Involved in development of Custom Royalty reports and other custom reports as per the client requirements.
 Involved in PRODUTION Maintenance Activities (Hold the scheduled Jobs in PROD, Sanity Testing After completing
PROD Maintenance & Releasing the Scheduled Jobs).
 Involved in offshore team code reviews, GitHub code migrations & weekly production code migrations.
 Customized and extended Order Management workflows to meet specific business requirements.
 Involved in creating SR’s with Oracle Support.
 Involved in Preparing XDF files for custom Tables migrations.
 Used Data loader for production activities.

ERP Cloud Developer, Client: Intercol, OSI Digital, Hyderabad, India Jan 2018 – Dec 2018
 Developed integration in Oracle ICS for Customer outbound from Fusion to Infor, Mirnah, and Ishipping and POS
systems.
 Developed integration solutions to extract supplier data from the Infor SaaS platform using available APIs or
integration tools provided by Infor.
 Implemented integration solutions enabling the seamless outbound transmission of item data from the Infor SaaS
platform, ensuring accurate and timely data exchanges with external systems.
 Configured and managed outbound transmission of sales order (SO) data from the Infor SaaS platform, ensuring
smooth and accurate data transfers to external systems.
 Developed and maintained integration solutions for outbound transmission of price list data from the Intercol
MIRNAH SaaS platform, ensuring accurate and timely updates to external systems.
 Implemented and managed outbound transmission of organizational hierarchy data from the Intercol SaaS platform
for point-of-sale (POS) systems.
 Developed custom inventory reports and transactions to optimize inventory control and management.
 Configured and maintained outbound transmission of purchase order (PO) receipt data from the Intercol SaaS
platform to external systems
 Implemented inbound integration for receiving shipping details data into the Intercol SaaS platform from external
systems.
 Developed and managed inbound integration for receiving accounts receivable (AR) invoice data into the Intercol
SaaS platform from external systems.
 Configured and maintained inbound integration for receiving load request data into the Intercol MIRNAH SaaS
platform from external systems.
 Implemented AP document sequence functionality within the Intercol SaaS platform, ensuring the accurate
generation and management of document sequences for accounts payable transactions.
 Developed and managed the functionality for generating document sequences for accounts payable transactions
within the Intercol SaaS platform.
 Implemented AR document sequence functionality within the Intercol SaaS platform, ensuring the accurate
generation and management of document sequences for accounts receivable transactions, enhancing process
efficiency and compliance.
 Implemented and managed the functionality for generating document sequences for accounts receivable
transactions within the Intercol SaaS platform, ensuring accurate sequencing and tracking of financial documents
for streamlined accounting processes.
 Configured and customized Purchase Orders and Approval workflows based on business rules and requirements.
 Implemented PO document sequence functionality within the Intercol SaaS platform, ensuring the accurate
generation and management of document sequences for purchase order transactions, facilitating efficient
procurement processes and compliance.
 Implemented and managed the functionality for generating document sequences for purchase order transactions
within the Intercol SaaS platform.

Oracle Application Developer, Client: ASM, OSI Digital, Hyderabad, India June 2017 – Dec 2017
 Involved in developing the Employee Outbound Interface.
 Involved in developing the Employee Roster Outbound Interface.
 Involved in development of Custom Reports.
 Involved in development OTL transfer to BEE custom process.
 Involved in analyzing the code and fixing the bugs (Code fixes) in EBS.
 Involved in preparation of the technical spec documents (MD070).
 Involved in preparation of the code migration (MD120) documents.

Oracle Application Developer, Client: RBC, OSI Digital, Hyderabad, India April 2016 – June 2017
 Involved in code remediation of the custom objects such as Procedures, Functions, Packages, Reports, Views,
Triggers, and Materialized Views & APIs from [Link] to 12.1.3.
 Involved in preparation of Unit test cases (UTC) & Technical analysis changes (TAC) documents.
 Involved in migration of the remediation code from once instance to another instance by using Serena software
(Version Control Software) and kintana tool (Project and Portfolio Management).

Oracle Application Developer, Client: Falken Tires, OSI Digital, Hyderabad, India Jan 2015 – March 2016
 Involved in development of sales order interface.
 Involved in development of price list interface.
 Involved in development of Customer Interface.
 Involved in development of Inventory Physical count interface.
 Involved in developing Materializes views on EBS base tables.
 Involved in developing PLSQL packages on Materialized views to send data form EBS to SOA services.
 Involved in creating custom triggers on EBS base tables.
 Involved in materialized views SQL queries performance tuning.
 Involved in developing data migration scripts to migrate the data from EBS materialized views to ADF tables.
 Involved in preparation of MD120 documents and unit test cases for fixed bugs.
 Involved in post-production support to fix the production issues.

Oracle Application Developer, Client: TMAG, OSI Digital, Hyderabad, India Jan 2013 – Dec 2014
 Involved in the development of inbound/ outbound Interfaces& conversions to upload the data from legacy system
in to Oracle applications Base tables.
 Involved in the development of new Reports using oracle reports Builder& XML Publisher reports.
 Involved in the Customization of existing standard oracle reports using oracle reports Builder.
 Involved in the Sys Admin Module for the registration of various front end objects and the database objects
(Tables, views, materialized views and Triggers)
 Involved in the Oracle applications Technical setup (AOL) for lookups, profiles, alerts, Flex field, Value sets,
Concurrent Programs& Request Sets.
 Involved in the client discussions and gathered information directly with client.
 Responsible for preparation of Technical Specifications (MD070) from the functional requirements document
(MD050) & Testing documents (TE20).
 Responsible for Identifying the Test Scenarios based on business requirements and Preparation of Test Cases in
Quality Center for different test scenarios.
 Involved in the Test Case Execution in Quality Center in System and Regression testing and Logging defects in
Quality Center.

Technical Consultant, Client: Oracle, BR RAYSOFT, Hyderabad, India Dec 2010 – Dec 2012
 Supporting all Release 11i critical Sev1, Sev2, Sev3 and Sev4 issues and providing the solutions to resolve the issues.
 Supporting all R12 Sev2, Sev3 and Sev4 issues and providing the solutions to resolve the issues.
 Handled critical technical requirements of the customer and provided the solution with work around and with
related data fixes.
 Handled the critical technical issues through Oracle Web Conference based on the priority.
 Reproducing the customer issues in Oracle Internal Instances and Logging defects with development team.
 Suggesting released patches related to Oracle Standard Errors.
 Having good knowledge on functionality of Payables application and elaborate the functionality and explain to the
customer for all consultative issues.
 Handled critical withholding tax issues and performance issues.
 Resolved many periods close, Trial Balance Report and Accounting issues.

Technical Consultant, Client: Qwest Communications, Magna InfoTech, Hyderabad, India March 2010 – Nov 2010
 Involved in the development of Interfaces& conversions to upload the data from legacy system in to Oracle
applications Base tables.
 Involved in the development of new Reports using oracle reports Builder& XML Publisher reports.
 Involved in the Customization of existing standard oracle reports using oracle reports Builder.
 Involved in the Sys Admin Module for the registration of various front end objects and the database objects.
 Involved in the Oracle applications Technical setup (AOL) for Flex field, Value sets, Concurrent Programs& Request
Sets.
 Involved in the client discussions and gathered information directly with client.
 Responsible for preparation of Technical Specifications (MD070) from the functional requirements document
(MD050) & Testing documents (TE20).
 Responsible for Identifying the Test Scenarios based on business requirements and Preparation of Test Cases in
Quality Center for different test scenarios.
 Involved in the Test Case Execution in Quality Center in System and Regression testing and Logging defects in
Quality Center.

EDUCATIONAL QUALIFICATIONS:
 Hold a Master Degree ([Link].) from Osmania University.
 Having OCA (Oracle Certified Associate) certification.
 Done with Oracle Cloud Support Specialist Assessment certification.