SUMMARY

• Having 14+ Years of Techno - Functional Experience with Oracle Applications EBS 11i/ R12(12.1, 12.2) including 5+ years of Oracle Fusion Cloud SaaS (Financials) and PaaS Applications with below modules.
• Hands on experience with the EBS RICEW Components and Tools like Forms, Reports, Oracle Workflows, Interfaces, Conversions, Unix Shell Script and BI Publisher Reports.
• Having experience in Oracle SaaS and PaaS. Worked on PaaS offerings - ICS, VBCS, JCS-SX,DBCS.
• Developed and modified Fusion ERP BI Publisher/ OTBI Analysis Reports as per the Requirement.
• Hands on Integrations experience with Oracle PaaS offerings like Oracle Integration Cloud (OIC) and VBCS (Visual Builder Cloud Service) to automate ERP Cloud FBDI Integrations.
• Hands on experience working with REST/SOAP API’s and good exposure to Fusion ERP seeded API’s.
• Have exposure to Java and scripting languages like Groovy Scripting and Java Script.
• Good Techno-Functional exposure with Procure to Pay and Order to Cash Cycles.
• Implemented OIC Integration Best Practices in terms of efficiency, performance and reusability.
• Have working knowledge with all design patterns of Oracle Integration Cloud.

TECHNICAL SKILLS

Platform: Window Server 2008/2003, Windows XP, Linux, Unix

Languages: Oracle, Java, jQuery, JavaScript, Json.net, XML, SOAP/REST WCF Web Services, XSLT, VSTS 2010

Applications/Modules: Oracle EBS 11i/R12, Oracle EBS Financials, EBS SCM, Projects, Manufacturing and HRMS, Oracle Cloud GRC Security, Oracle Fusion Cloud SaaS, Cloud PaaS

RDBMS: Oracle SQL, SQL Server, MS Access

Development Tools: Toad, SQL Developer, UTL File, Forms, Reports, JDeveloper, APEX, SOAP UI, Postman

Integration Tools: Informatica, Oracle Integration Cloud (OIC)

Source Control Tool: Visual Source Safe, SVN, CVS

PROFESSIONAL EXPERIENCE

Confidential

Oracle ERP Cloud Consultant

Responsibilities:

• Developed Integration Using OIC to import Legacy (Mainframes) System Customer Master Data into ERP Cloud using Bulk Load Utility from ERP Cloud Adapter.
• Involved in development of new pages and extending the Seeded Pages using VBCS.
• Developed GL Journal/AP Invoice Integrations to push data from external systems to ERP Cloud through FBDI Automation by using PaaS OIC (Oracle Integration Cloud) and DBaaS/ATP DB.
• Developed Interface Code to Integrate Legacy Financials systems to convert Customer Invoice data into Cloud AR Invoices.
• Developed Conversion Scripts to load data from EBS to Cloud SaaS.
• Developed Validation Utility to pull SaaS Configuration data into PaaS ATP using Oracle Integration Cloud OIC to perform pre validations against Legacy Source data.
• Developed OIC VBCS Page and Integrated with SaaS application to correct and reprocess the failed Interface data.
• Developed PLSQL Java Programs to pull BI Publisher Report data into ATP DB from SaaS Cloud applications.
• Customized Cloud GL Journal approval workflow to display the Accounting descriptions.
• Developed Supplier/Customer BIP Incremental Data Extractions to sync up Master Data with all Legacy systems using OIC.

Confidential

Oracle Cloud Consultant

Responsibilities:

• Involved in ERP Cloud Finance configurations.
• Developed OIC Integrations to push Purchase Orders from Legacy EBS to Oracle ERP Cloud.
• Developed OIC Outbound Integration to sync Customer Master/Supplier Master data from ERP Cloud to EBS using BI Publisher report Webservice method.
• Involved in loading master data and transactional data using FBDI spreadsheets.
• Developed Financials Integrations to share information between Legacy and ERP cloud applications.
• Developed GL COA tree reports with suggested format from client.
• Developed eText templates for the modules AP/GL and AR.
• Developed and modified Fusion ERP Cloud BI Publisher/ OTBI Analysis Reports as per the Requirement.

Confidential

Senior Principal Consultant

Responsibilities:

• Involved in loading master data and transactional data using FBDI spreadsheets.
• Involved in integrating External system with ERP Cloud using PaaS OIC and DB.
• Involved in Supplier Portal Cloud Setups and Configurations.
• Developed AP/AR/GL Integrations to push data from external systems to ERP Cloud by using PaaS Oracle Integration Cloud (OIC) and DBaaS/ATP DB.
• Developed and modified Fusion ERP Cloud BI Publisher/ OTBI Analysis Reports as per the Requirement.
• Developed GL BIP Reports to Show Balances by Account and Income Statements.
• Developed Integration between Oracle Sales Cloud and EBS Order management to convert Sales Cloud Opportunities into EBS Sales Orders.
• Have Developed Outbound Integration to bring EBS Data to Sales Cloud using OIC Polling functionalities.
• Developed Custom Pages in Sales Cloud using Application Composer and used Groovy Scripts to invoke OIC Integrations.
• Extended SaaS Pages using VBCS (Visual Builder Cloud Service).
• Customized Oracle SaaS Pages using Sandbox.

Confidential

Technical Lead

Responsibilities:

• Developed AP and AP Aging Reports for the client, which shows all account information, and currency information that helps the customers to tally the data easily.
• Developed new workflows on PA and PO modules.
• Created Business events on AR module to customize the accounting code combinations.
• Developed OAF Page to display customer and supplier related information.
• Defined setups for AACG and TCG configurations as part of Oracle GRC Implementation.

Confidential

Technical Lead

Responsibilities:

• Developed an interface for min-max planning from legacy to standard Oracle standard base tables of Inventory.
• Developed PO ASL (Approved Supplier List) interface by using standard API’s.
• Developed custom workflows from scratch and customized the standard workflows.
• Created control files for SQL loader to load data from text files.
• Defined the AOL objects like concurrent programs, executables and value sets etc.,
• Involved in defining Approval Groups in PCG.
• Involved in Defining setups like Audit and Change Control in PCG.

Confidential

Team Lead

Responsibilities:

• Extraction and migration of Items data, supplier’s data, employee’s data, projects & tasks data and supplier bank details from 11i to R12 using standard API’s
• Migrated custom reports, packages and host files from 11i to R12 by customizing necessary changes as per R12.
• Developed an interface for min-max planning from legacy to standard Oracle standard base tables of Inventory.

Confidential

Team Lead

Responsibilities:

• Developed configuration control governor (CCG) content for the 12.1.3 Version.
• Developed code for creating the product family, product family version, suite, application, tables, columns, objects etc. from backend without Meta builder.
• Involved in Defining setups like Audit and Change Control in PCG.
• Involved in Defining setups and Configurations with regards to AACG and TCG

Confidential

Team Lead

Responsibilities:

• Involved in the Migration of Data from 11i to R12.
• Involved in Data validations part to compare both 11i and R12 data.
• Developed custom ACH Nacha, positive pay and Separate Remittance report by using e-Text templates.
• Extended the standard package on part of customization of standard e-Text templates.
• Defined oracle payment administrator setups like payment process profiles, payments formats etc.,

Confidential

Team Lead

Responsibilities:

• Developed plsql package to customize IPV and PPV accounts.
• Developed PL/SQL packages, procedures, and functions.
• Developed and customized discoverer reports.
• Creation of value sets in various modules of the application.
• Developed outbound interface to extract back orders data from base tables to flat file using the UTL FILE utilities in order management module.

Confidential

Senior Consultant

Responsibilities:

• Developed PL/SQL packages, procedures, and functions.
• Developed and customized discoverer reports.
• Creation of value sets in various modules of the application.
• Developed outbound interface to extract back orders data from base tables to flat file using the UTL FILE utilities in order management module.
• Development of various interfaces and reports in INV, AP, OM, AP, GL.

Confidential

Trainee Consultant

Responsibilities:

• Working as an Oracle Apps Developer mainly involved in developing technical deliverables-XML Publisher Reports, Interfaces and conversions.
• Developed packages, procedures for Interface/conversion programs and sql scripts for reports as per business requirement.
• Customization of reports and Development of new reports.