ANIKET PATURKAR

• Accomplished cloud architect with 13 years of comprehensive experience in designing and managing Oracle Fusion Cloud ERP-based solutions.
• Led the design and implementation of end-to-end Oracle Cloud ERP implementation projects.
• Strong experience in designing and implementing Oracle Fusion data conversions using FBDI for financials, supply chain management, project portfolio management, and manufacturing.
• Designed and developed Oracle Fusion data conversions using ADFdi.
• Strong knowledge of designing and developing data conversions using import management for various components, like PPM contracts, application composer custom objects, etc.
• String knowledge on import and export functionality to import and export data from Oracle Fusion, like lookups, value sets, etc.
• Designed and implemented a data extraction script from Oracle EBS to migrate data to Oracle Fusion.
• Strong experience in end-to-end data conversion from design and implementation, from various source systems to reconciliation, and handling errors.
• Working knowledge of data migrations for HCM objects using HDL, including workforce structure and employees.
• Strong Experience on UCM and content server managements for uploading and downloading files.
• Delivered complex business solutions by extending Oracle Fusion applications using Sandbox with Page Composer, Application Composer, structure, and page integrations.
• Strong knowledge of Application Composer custom objects and page design, including web service calls and server-side scripting using Groovy.
• Worked on integrating application composer pages with external systems using Oracle Integration Cloud.
• Strong knowledge of using Oracle Fusion REST and SOAP APIs for complex business requirements.
• Strong experience in using tools like Postman and SOAP UI for working with REST and SOAP APIs.
• I worked on fusion page extensions using Page Composer with EL expressions.
• Strong functional and technical knowledge of Oracle Fusion security using various roles, such as employee, job, duty, data role, and data access, auto-provisioning, implementation user, employee user, etc.
• Experience in importing banks and branches using the Rapid Implementation sheet.
• Experience in implementing and customizing Oracle Fusion approvals for AP Invoices, GL Journals, using complex business logic with dynamic SQL, skip rules, approval groups, and serial and parallel approvals.
• Experience in building bank integration setups with transmission configuration and PGP encryptions.
• Strong experience in the customization of bank documents for ACH, Positive Pay, and checks for various banks using E-Text Templates.
• End-to-end design and development experience on BIP reports for new development and customization of seeded reports, including RTF, Excel, and E-text templates.
• Strong knowledge of Oracle Fusion BIP report scheduling and bursting, with various delivery channels, such as printer, fax, email, etc.
• Strong experience in integrating BIP reports with external systems like OIC, VBCS, and APEX using report SOAP services.
• Strong experience in building inbound and outbound integrations using Oracle Integration Cloud with various third-party systems.
• Built integrations using FTP adapters, ERP Cloud adapter, and ATP DB adapter.
• Built bank integrations for importing bank statements using the BAI2 format.
• Worked on purchase orders, AP invoices, and GL journals inbound integrations using ERP cloud adapters with callback functionality.
• Experience integrating Oracle Fusion applications with Salesforce, CPQ, and various other third-party systems using OIC.
• Working knowledge of EDI integrations.
• Very well-versed in various OIC components, including adapters, connections, REST, SOAP, XSLT, XML, lookups, libraries, projects, agents, etc.
• Experience in customizing Oracle Fusion Redwood pages using VB Studio.
• Successfully developed various customizations on the supplier's self-service registration page using VB Studio.
• Experience in building custom applications using VBCS.
• Very well-versed in various VBCS components, like web apps, flows, pages, fragments, shell pages, business objects, service connections, and backend.
• Successfully built Oracle Fusion extensions using VBCS, and embedded the VBCS application in Oracle Fusion applications using Structure and Page Composer, with SSO enabled.
• Strong knowledge of OIC/VBCS security, including SAML, OA.ML, OAUTH2, JWT tokens, SSO, etc.
• Built a complex business logic process automation with multi-level approvals using Oracle Process Automation (OPA).
• Experience in building integrations with OIC, VBCS, and OPA for Oracle Fusion applications.
• Strong experience in building custom applications using Oracle APEX.
• Built a data conversions automation tool using Oracle APEX.
• Strong knowledge of building Oracle Fusion extensions with Oracle APEX.
• Built a supplier one-time payment application using Oracle APEX with Fusion SSO for automating the supplier one-time payment process.
• Strong, proven experience in SQL and PLSQL for building complex solutions.
• Strong experience in EBS for implementation, upgrade, and support projects with RICEW components and OAF.
• Involved in multiple proofs of concept, IPs, and innovations for providing various complex business solutions to clients.
• Experience working on pre-sales activities, such as RFPs and proposals, for various public sector K-12 and county customers.

IP and innovations built by me:

• QUAD: Quick User Data access is a tool built by me for accessing Oracle Fusion Application data. It is an installable desktop tool that connects to Oracle Fusion and can show or download data from Oracle Fusion based on SQL queries.
• Attachment utility: I built this Java-based attachment utility for uploading bulk Oracle Fusion attachments for various objects, like PO, suppliers, AP, and AR Invoice attachments, using the Oracle Fusion Attachment SOAP API.
• Transcend: I built this Oracle APEX cloud-based tool for automating data conversions for all financial, SCM, PPM, and HCM objects, from uploading files to reconciliation with a few clicks.

• I worked as an Oracle Apps Senior Technical Consultant.
• To understand the business requirements by doing a complete analysis of the clients' requirements.
• Creation of the Technical Design Document, coding, and Unit Test Plan (UTP document) according to the Business Requirement Document (Functional Design Document).
• I worked on RICEW+OAF components with the team.
• Creation of executable, concurrent programs, and different types of value sets, lookups, profile options, and request sets.
• Developed a complete workflow and custom form from scratch in order to gather credit check information of the customer, and launched the workflow based on the customer's credit limit to send to the approver before booking the sales order against the customer.
• Developed XML publisher reports as part of the AMU Power rollout for Purchasing and Accounts Payable modules.
• Worked on the customization of the seeded Oracle XML Publisher report as per the client’s requirements.
• Developed a new custom XML Publisher report as per the client’s requirements.
• Worked on conversions to import AP/AR invoice data, along with GST, from the legacy system to Oracle.
• I worked on GST AP/AR conversions.
• Worked on the OAF customization as per client requirements for I Expense OAF pages (Extension and Personalization).
• Worked on the data load activity for Oracle item load and price list from the Excel sheet to Oracle.
• 
  

• Involved in the understanding and resolution of the runtime issues occurring on the production instance.
• Involved in the day-to-day activities of production support for Oracle Financials modules.
• Involved in the analysis of the assigned support tickets, including replicating the issue, analyzing the custom processes, APIs, reports, forms, and interfaces, and updating the ticket with the appropriate information.
• Involved in the resolution of complex interface issues for purchase orders, receipts, and invoices from various third-party systems to CORE, with millions of records of live data on a daily basis.
• Involved in the analysis of a recurring issue with RCA and providing a fixed resolution.
• Work on the development activities as part of issue resolution. Perform unit testing, migrate to the next environments, assist with user testing, and close the tickets.
• Strong working experience with Purchase Orders (STANDARD and BLANKET PO), receipts, and invoices interfaces to move large volumes of production data into the CORE instance on a daily basis.
• Involved in clearing daily rejections occurring for purchase orders, receipts, and invoice interfaces.
• Strong knowledge of the Payable Open Interface Import program to validate and load credit memos, debit memos, and standard invoices from a third-party system to core.
• Closely worked with users to understand business needs and objectives.
• Closely involved with users in month-end activity completion occurring every month for accounts payables.

• To understand the business flow in Oracle 11i and provide a solution for the same as per the changed functionality of Oracle R12.
• Retrofit of the Oracle 11i code, including packages, triggers, indexes, concurrent programs, forms, and reports, as per Oracle R12.
• Worked on the creation of an executable, concurrent program, different types of value sets, lookups, profile options, and request sets.
• Strong knowledge of Oracle Application Object Library (AOL).
• Written PL/SQL procedures, functions, triggers, views, cursors, and data fix scripts for the new functionality of R12.
• Written PL/SQL and SQL scripts in order to debug the issues occurring during retrofitting.
• Worked on MOAC and TCA architecture as part of retrofitting for the upgrade.
• Used FNDLOAD to migrate concurrent programs and data definitions in various instances.
• Involved in the retrofitting of custom forms, reports, interfaces, and extensions used in Oracle 11i as per the new functionality of R12.
• Worked as a technical team member (developer).
• To understand the business requirements by doing a complete analysis of the clients' requirements.
• Creation of the Technical Design Document, coding, and Unit Test Plan (UTP document) according to the Business Requirement Document (Functional Design Document).
• I worked on RICE components with the team.
• Creation of executable, concurrent programs, and different types of value sets, lookups, profile options, and request sets.
• Used FNDLOAD to migrate concurrent programs and data definitions in various instances.
• Strong knowledge in development, and inbound and outbound interfaces, with a sound understanding of the Application Object Library (AOL).
• Strong knowledge of UTL_FILE for developing inbound and outbound interfaces.
• Expertise in System Administrator responsibilities to create users, responsibility values sets, and request sets.
• Developed UNIX shell scripts to FTP the flat file from the external server to the Oracle UNIX server location.
• Developed custom XML Publisher reports with template and data definitions.
• Developed custom XML Publisher reports with different country-specific logos (using OA_MEDIA) and different languages using .XLF files.
• Developed a custom XML Publisher report with bursting functionality in order to burst the shipping data of the customer.
• Hands-on experience with Oracle Form personalization.
• Written PL/SQL procedures, functions, triggers, views, and cursors.
• I worked on the MOAC and TCA architecture of Oracle R12.
• Used version control (Tortoise Subversion) to maintain code changes.
• Proactively tuned SQL queries and views using Explain Plan, hints, indexes, and SQL trace.
• Working knowledge of SQL Loader.