Home

Sandeep Kulkarni - Senior Oracle Cloud Technical Consultant

[email protected]

Location: Woburn, Massachusetts, USA

Relocation:

Visa: H1B

Sandeep Kulkarni Summary: Over 20+ Years of IT Professional, experienced in analysis, design, development, implementation and support of Oracle ERP applications and technologies, namely on-premises E-Business Suite (EBS) and Oracle Cloud / Fusion ERP Cloud. Proven Fusion Cloud data migration and integration specialist with over 4 Oracle Cloud / Fusion implementations. Having good functional knowledge of SCM (PO, INV, OM) FINANCE (GL, AP, AR, FA, CM), MFG and CMRO Modules. Experience in oracle OIC Integration Cloud platform. Experience in GUI development using Oracle Forms, OAF, CSI Framework and VBCS Experience in Report development using RDF, XML publisher, BI Publisher, OTBI and FRS reporting tools. Experience in data migrations/conversions using FBDI, More4Apps, ADF di, SQL Loader utilities. Good Knowledge of Dell Boomi (iPaas) integration platform. Good knowledge of Oracle SOA Suite using Oracle Fusion Middleware Stack 11g, 12c. Integration Experience with SOAP/RESTFUL and JSON services. Experience in BPM Workflow customizations and Approval management. Good knowledge of Application composer, Custom Objects and Custom Subject Areas. Areas of Expertise: Business IT Strategy, Application Architect/Lead, Oracle EBS Techno-functional, Oracle Fusion ERP technical, Integration Lead, Application development, Business analysis & Technical Evaluations, Experience in SaaS enablement like Fusion ERP, SCM, Order Orchestration and Oracle BI Cloud Services, Lead teams for Oracle ERP and Fusion Implementations. Expertise on Oracle BI Services, Oracle Apps, SOA & RICEW. Technical Skills: Data Conversion utilities/Tools: FBDI, HDL, SQL Loader, Webservices, More4Apps, Data Loader. GUI: Oracle Forms, OAF, ADF and VBCS Integration platforms: Oracle OIC and Boomi RDBMS: Oracle, SQL Server, MS-Access Reporting tools: BI Publisher, FRS, OTBI, RDF and XML Publisher Version Maintenance Tool: Tortoise SVN, Kintana Programming Skills: PL/SQL, Java, exposure to java script and FoxPro IDE: SOAP UI, SQL Developer, Toad, WinSCP, Putty, NetBeans and JDeveloper Application Servers: WebLogic, Tomcat (Apache) Operating Systems: Unix/Linux/Windows 2000/NT Education: B.E, Mechanical, KLE college of Engineering and Technology, Belgaum,1999 Awards and Certifications: Received Rising Star Award by the Employer (Oracle SSI) Quality champion Award by the Employer (Oracle SSI) Certified Oracle Cloud Infrastructure 2023 AI Foundations Associate Foundations Associate Certified Oracle Cloud Infrastructure 2020 Foundations Associate Certified Oracle Procurement Fundamentals Professional Experience: Client: Itron, United States, Liberty Lake, WA Duration: November 2021 Till Date Role: Senior Oracle Cloud / Fusion Technical lead (IT Operations) Description: Oracle Fusion PDH/Supply chain planning, IT Problem Management, Production support Oracle EBS 12.2.9, Oracle EBS on OCI and Oracle EBS upgrade to 12.2.13 Responsibilities: Data Conversion Items and suppliers data migration from MFG-Pro application using FBDI templates in Oracle Fusion for Encore India rollout implementation project. Employee data Conversion into Oracle Fusion from MFG-Pro Application using HDL import. Integrations (OIC) Developed SCP planning outbound integrations using BICC and OIC. Developed user creation and roles via HDL file integration using OIC. (SOAP services and ERP Adapters) Oracle GOP integration with Oracle EBS using OIC to populate schedule details On Sales order Using REST API. Reports Development OTBI Dashboards viz Finished Goods and Service Item dashboard. Dangers Goods Analysis Change Order Inquiry Report BI Publisher reports viz Supplier Schedule Report (Visibility of supply for different buckets) Dropship and back-to-back Sales order report ASCP Detail Report Supported day to day activities of Oracle Supply Chain and PDH modules. Created VBCS dashboard to display Supply chain planning integration process used by critical business users to review if any errors in the integration process flow IT problem management: - Identified repetitive tickets and provided permanent fixes/Automations. Developed the common data fix script concurrent request can be used to apply the data fixes for critical issues. Developed OAF page to purge the credit card and expense transactions. Developed the Oracle Form to simplify the Printer setups for business users. Provided the Production Support for Oracle EBS on SCM and Fin Modules (INV, PO, OM, AP, AR, GL and FA) Prepared resource plan for Month end Period closure activities. Handled Quarterly upgrade activities of Oracle Fusion Cloud applications (SCP, PD, PDH) Migration of oracle EBS on OCI infrastructure and upgradation Oracle EBS from 12.2.9 to 12.2.13 projects. Worked with Procure to Pay teams to test cross modules customization/Interfaces. End to End testing of integration between Supply chain cloud module with oracle EBS Purchase requisition, work orders and internal sales order custom functionalities. Testing of Salesforce interface for employee timecard interface. Worked with Business users to test Customizations CRP test cycles including UAT and SIT. Worked with technical team to deploy the customizations including personalization, workflow, lookups, concurrent programs and Custom OAF pages. Facilitated in issue resolution and meetings with users to fix and close the issues. Mentored Interns on Oracle EBS modules/technical skills and enabled them on the projects. Environment: Oracle EBS, Oracle Fusion Cloud (24B), PL/SQL, XML publisher, SQL, OAF and Oracle Forms, Oracle EBS R12.2.9 and Oracle Cloud Supply chain planning, SQL Developer, OIC, VBCS, BI Publishers, FBDI, HDL, JDeveloper. Client: Panda Retail, Saudi Arabia Duration: April 2020 to November 2021 Role: Oracle Cloud / Fusion -Technical Lead (Oracle Fusion Application Implementation) Description: Panda Retail is running Oracle EBS and Oracle Retail Merchandising System on premises applications for daily business transactions. As part of digital transformation Oracle Fusion cloud and Oracle Retail Merchandising Cloud would replace current on-Premises oracle EBS and RMS applications. Responsibilities: Worked as technical lead for implementing Oracle Fusion R20D Responsible all Data migration, Integration and Custom Report Development activities Interacted with Client and Functional consultants and coordinating with technical team. Contributed to cutover plan for Go Live. Data Gathering and Transformation: Interacted with business users and extracted the master and open transaction data from oracle EBS into FBDI format for data migrations. Modules viz (PO, INV, AP, AR, FA and GL). Data Conversion: Master data: Supplier, Customer, Banks, Employee(Worker), Job, Position, Grades using FBDI and HDL import process. Open Transaction Data: PO, INV, AP, AR, FA and GL (five years) using FBDI process. Integrations (OIC) Oracle fusion cash management and legacy systems (Bank statements and Merchandise statements) Designed and Developed OIC Integration Import Bank statements into Oracle Fusion Application Cash Management (MT940 Format). Using (SOAP services, FTP and ERP Adapters) Designed and Developed OIC Integration Import Bank statements into DBAAS DB via BIP Report service from Oracle Fusion application. Using (SOAP services, ERP Adapters and DB adapters) Designed and Developed OIC Integration Import Merchandise statements into DBAAS DB. (SOAP services, FTP and DB adapters) Developed PL/SQL code to reconcile the Bank statements and Merchandise statements into DBAAS DB Designed to integration to upload the reconciled bank statements and merchandise statements into Oracle EPM cloud Application .(Rest API) Reports Development: OTBI Reports and Dashboard Payable Invoices Dashboard Receivable transaction Dashboard General Ledger Balances Dashboard Expense Transaction Dashboard BI Publisher reports viz AP Invoice Hold Register Report AR Invoice Arabic report Asset Register Report Supplier Master Report Visual Builder (VBCS) Bank Holiday setup page which is used during reconciliation process. Using (Business objects and SDP) Retention of Bank and MD statements setup page Using (Business objects and SDP) Customized Purchase Approval BPM workflow to meet customer requirement Environment: Oracle Fusion Rel20D, OIC, VBCS, BI Publisher, SQL, Rest Services, OIC, DBCS, Oracle Fusion Financials, Procurement and HCM modules, SQL Developer, BI Publishers, Postman, SOAPUI Client: OLA India Duration: September 2019 to March 2020 Role: Oracle Cloud / Fusion - Technical Lead Description: Lift and Shift from Oracle EBS to Oracle Fusion Applications Responsibilities: Worked as technical lead for implementing Oracle Fusion R19D Responsible all Data migration, Integration and Custom Report Development activities Interacted with Client and Functional consultants and coordinating with technical team. Data Conversion: Data extraction from oracle EBS into FBDI format and migrated to Oracle Fusion for below modules. Master data: Supplier, Customer, Banks, Employee, Job, Position, Grades using FBDI and HDL import process. Open Transaction Data: PO, INV, AP, AR, FA and GL (five years) using FBDI process. Integrations: Involved in File based integrations using Java framework (Oracle in house development tool) for following objects PO, GRN(RCV), GL Interface and Bank Statement Import. Developed custom solution for bank payment acknowledgment process (GAP in Oracle Fusion). Involved in Employee integration from Success factor application with Oracle fusion using Java framework tool (HDL file integration) Involved in Cutover plan, Integration design and technical solutions. Outbound integration: Developed Bank payment integrations for the various banks viz HDFC, ICICI, AXIS, ANZ and CITI Banks. BI Publisher reports P2P PR PO GRN Report P2P PO GRN Invoice and Payment Report GL Journal Approval Status Report AP Invoice Interface Error Report Payment advice (Remittance report) OTBI Dashboards User Dashboard (User last update and roles) Item Assignment Report Environment: Oracle Fusion Rel19D, Technology: BI Publisher, SQL, JAVA webservices, Rest Services, Modules: Oracle Fusion Financials and Procurement, Tools: SQL Developer, BI Publishers, Postman, SOAPUI. Client: SWEP International SWEDEN (Onsite Landskrona, Skane) Duration: April 2018 to September 2019 Role: Oracle EBS Technical Lead Description: SWEP International Oracle EBS implementation project which replaced existing legacy system and integrated with Salesforce cloud application. Responsibilities: Working as technical lead for implementing Oracle ERP EBS R 12.2.6 Responsible for all Data Conversion, Extension and Integrations for several components Interacted with Client and Functional consultants and coordinating with offshore technical team. Worked on data conversions activities for the objects Items, Categories, Approved Supplier List conversion, User creation etc. Helped technical team members to resolve technical issues. Created API and invoked from Salesforce applications via Dell Boomi Bartender Integrations using Rest and SOAP services with Oracle EBS Customized Standard Oracle RDF reports like 1. Min max Planning Report 2. Standard Purchase order report 3. Receiving Transaction register report Involved in Cutover plan, Integration design and technical solutions with Customer. Environment: Oracle E-Business Suite Rel 12.2.6, SQL/PLSQL, OAF, BI Publisher, SOAP webservices, Rest Services, Dell Boomi, Supply chain Manufacturing, Financials, Order Management, Salesforce, Tools: JDeveloper, SQL Developer, Oracle RDF Reports, XML Publishers, Dell Boomi, Oracle Forms Client: UASG, Abu Dhabi Duration: November 2017 to February 2018 Role: Oracle Cloud / Fusion Technical Consultant Description: Implementation of Oracle Fusion cloud application Responsibilities: Integration: Developed Supplier integration via FBDI file import process using ICS(OIC) (SOAP Services, FTP and ERP Adapters) Data Conversion: Involved in Supplier and Purchase order data migrations using FBDI files. BI Publisher Reports: Customized seeded BI Publisher Purchase order report in oracle fusion application. Developed custom BI Publisher Purchase requisition report. Developed BI Publisher Custom Air Ticket Information report (Flows employee Information from HCM, Purchasing and Payables) HCM Module Payroll related Employee Settlement Report Absence Status Report Overtime Report New Joinee Report Developed Profit and Loss FRS reports. Environment: Oracle Fusion Cloud R12(19D), SQL, BI Publisher, ICS(OIC), Procurement, Sourcing Payroll and Financials, SQL, BI Publishers and Fusion Reporting Studio Client: Viva Telecom, Kuwait Duration: February 2017 to February 2018 Role: Oracle EBS Technical Lead Description: Viva Telecom wants development of complete custom application to track the assets using oracle EBS 12.1.3 applications. Responsibilities: Gathering requirements and designing solutions. Data Conversions: Worked on Data conversion of Item, Suppliers, Purchase order, Fixed Assets and General Ledgers objects. Getting design reviewed by Solution Architect. Development as per the design. Developed Custom OAF Screens developed to capture the Site, Item, Material Transaction and Asset Capturing data through XL uploads. Developed Approval Workflow Mechanism for each custom screen. Involved in integrating Custom Data with EBS Inventory Items, EAM, OAT, Fixed Asstes, General Ledger modules. Environment: Oracle Apps R12.1.3, Technology: Workflow, SQL, PL SQL, OAF, Interface, Modules: Purchasing, Inventory, EAM, OAT and Fixed Assets, Tools: Toad, SQL Developer, JDeveloper, Workflow Builder Client: B2X, Germany Duration: August 2016 to February 2017 Role: Oracle Cloud / Fusion Data Migration Lead Description: Migration from Microsoft dynamics application to Oracle Fusion cloud Application and rollout different entities. Responsibilities: Data Conversion: Master data: Items, Categories, Costing, Supplier, Customer and Pricing related information s into Fusion Applications using FBDI templates Open Transaction data: Purchase order, Payable invoices, Sales orders, Receivable invoices using FBDI templates. Creation of Custom Value sets in Fusion applications. Developed Custom reports related to Order Management and Receivables Modules Environment: Oracle Fusion R11, Oracle Fusion PDH and Order Managements, FBDI templates and BI Publisher. Client: Royal London Group UK Duration: June 2016 to February 2017 Role: Senior Oracle Apps/Fusion Technical Consultant Description: Implementation Oracle EBS R 12.1.3 and Oracle Fusion cloud Responsibilities: Gathering requirements and designing solutions. Getting design reviewed by Solution Architect. Development as per the design. Developed the Custom FAH program to interface them to fetch data from various sources. Developed Reports to Extract the data from Fusion Application from Financials and Project budgeting Modules. Environment: Oracle EBS 12.1.3, Oracle Fusion R11 and BI Publisher and SQL/PLSQL Client: National Trust, UK Duration: April 2012 to June 2016 Role: Oracle EBS Technical Lead Responsibilities: Meetings with Client and OCS Project Manager on Project status Interacted with client and gathering requirements. Diligently work with Client Team and understand the problem areas. Coordinated with Offshore team to deliver the objects to client. Understand Client Business Process. Design and develop the solution as per the requirement. Arranged demo sessions. Priesting Monthly Review call with Client. Prepared MD 70. Prepared MD 120. Developed XML publisher reports - Custom Purchase order, Supplier Aging report, Purchase requisition status report. Environment: Oracle Apps R12, Modules: Order management, Configurator, Account Receivables, Cash Management, Technology: SQL, PL SQL, Form Personalization and Customization, OAF, XML Publisher Workflow, BPEL-SOA, WebCenter, Tools: Toad, SQL Developer, JAVA, JDeveloper and UCM Client: Lloyds Register United Kingdom Duration: June 2010 to March 2012 Role: Technical Lead (Oracle Applications CMRO) Environment: Oracle Apps R12, Modules: Oracle CMRO, Technology: Java, JSP, OAF, SQL, PL/SQL, XML Publisher, XML, Oracle Reports, CSI Framework, Tools: JDeveloper, Toad, SQL Developer, BI Publisher Desktop, Oracle Reports Builder, SVN Client: Korean Airlines, Seoul Duration: August 2008 to June 2010 Role: Senior Oracle Apps Technical Consultant Environment: Oracle Apps R12, Module: Oracle CMRO, Technology: OAF, CSI Framework, JSP, SQL, PL/SQL, Application Object Library, workflow, Tools, JDeveloper, Toad, SQL Developer, Putty, WinSCP Client: Shaw Cables, Canada Duration: November 2007 to May 2008 Role: Oracle Apps Technical Consultant Environment: Windows XP, Oracle Apps R11i, Technology: SQL, PL/SQL, Application Object Library, Tools: SQL Developer, Toad Client: Cendant Corporation, USA (New York) Duration: May 2007 to November 2007 Role: Oracle Apps Technical Consultant Offshore Environment: Oracle Apps R12 Modules: GL, Fixed Assets, Technology: SQL, PL/SQL, Application Object Library, Oracle Reports, Tools: Toad, Oracle Reports 6i Client: De Lage Landen, USA (Wayne, Pennsylvania) Duration: July 2006 to May 2007 Role: Oracle Apps Technical Consultant Environment: Windows XP, Oracle Apps R11i, Module: AP, AR, Lease Management, Technology: SQL, PL/SQL, Application Object Library, Oracle Forms, Reports, Tools: Oracle Forms, Toad. Client: LGCNS Global South Korea (Seoul, Gyeonggi Province) Duration: May 2005 to June 2006 Role: Oracle Apps Technical Consultant Client: L&T Infotech (Komatsu) India (Bengaluru, Karnataka) Duration: March 2004 to April 2005 Role: Oracle Apps Technical Consultant Client: Dubai Dry Docks, Dubai Duration: October 2003 to March 2004 Role: Software Developer Keywords: artificial intelligence user interface business intelligence database rlang information technology golang purchase order microsoft procedural language Arkansas Delaware Maryland Washington