Home

Das Pakanati - sr Oracle cloud techno functional consultant

[email protected]

Location: Houston, Texas, USA

Relocation:

Visa: GC

Resume file: Das-Sr.Oracle-Cloud-Techno-Functional-Analyst_1772653876499.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Das Pakanati Sr. Oracle Cloud Techno-Functional Analyst & BIP Developer PROFESSIONAL SUMMARY 18+ Years of total IT experience in Oracle ERP (Fusion (Cloud)/EBS (R12)/11i) applications. 8 Years of experience with Oracle Fusion (SAAS/PAAS) Applications and Oracle Integration Cloud (ICS/OIC). Working on Oracle Integration cloud (ICS/OIC) with SOAP services, REST API s and Agents. Worked on Adapters like REST/SOAP/File/FTP/Database/Oracle ERP Cloud/EBS/Salesforce in OIC. Integrated REST API s with Python scripting on AWS environment with lambda functions Oracle Fusion (Cloud) Financials as Techno Functional consultant involving in implementations and support as Financial/SCM/Procurement/PPM cloud consultant in the BI reports/OTBI reports/OTBI Analysis/ FBDI/ADF DI. Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/Purchase Orders/GL Journals/Fixed Assets data) through FBDI/ ADF DI Templates. Experienced Procurement Cloud offering (Purchasing, Supplier Portal, Self Service Procurement) Involved troubleshoot procurement functional issues in Production and provide quick resolution Guide the users for any navigational and training issues in Oracle Procurement Cloud Excellent Knowledge on defining ESS jobs for custom BI Publisher Reports in various modules. Having well exposure on code migration from one instance to another instance by using ARCHIVE and UNARCHIVE the files in Oracle Fusion. Experience in SmartView and FRS (financial reporting studio) Reports. Knowledge on WebCenter for Image Processing through OCR/ODR Worked (EBS) on BPEL process activities, Decision Service, Partner Links and Adapters (File/FTP/Database/AQ/JMS Adapters) for developing custom business processes to integrating with different systems. Good experience on Fusion Middle products APM, IDM, BPM. Defining Chart of Accounts, Ledgers, Data Access Sets, Business unit. Created users and assign appropriate roles to user and Custom roles creation in fusion. Define Value sets and creation of data models. Responsible for day-to-day issues related to accounting, schedule process, Transactions. 10+ Years of experience in EBS(R12),11i applications and Oracle SQL/PLSql. With specific exposure to Implementation, R12 Upgrade, enhancement, testing and support projects in Oracle Application(11i/R12). Expertise in preparing a Technical Design documents and Unit Test Plan documents for RICE and WebADI s. Expertise in BI Publisher (XML Reports) with Barcoding and registered FONT in the application. Developed BI reports for Oracle Projects with XML Data definition file and template in the .xls file. Expertise in development of interfaces (Inbound and Outbound), Conversions, Reports Development and Customization and Alerts and I have good knowledge of Oracle SQL/PL-SQL. Expertise in generating outbound files in XML standard format with UTL Utilities. Expertise in creating Event Alert and Periodic Alert to send mails, submit programs etc. Good knowledge of AOL (System Administrator, Application Developer) components and creating AOL components like value sets, lookups, concurrent programs etc. Experience with Oracle Utilities: TOAD, SQL-Developer, SQL*Plus & SQL*Loader and other tracking tools like BMC Remedy, BMC, PPM, SNOW, WINSCR3, MAXIMO, RAT, RPM, PVCS and Service Now. Created PO s, Invoices, Payments and posted to GL (P2P Cycle) for testing the new reports and outbound interface data and good knowledge on Order to Cash(O2C) Cycle. Download/Upload ldt files using fndload for Reports, Alerts, Interfaces programs & AOL components. Technical expertise in RICE objects for Financials & Procurement modules using Oracle s AIM/OUM methodology. TECHNICAL SKILLS ERP Fusion (Oracle Cloud SAAS/PAAS) & ICS/OIC/VBCS, R12(EBS) Functional Modules Fusion (AP, AR, GL) and Procurement, GL, AP, AR, Pricing, CM, OM,PPM Database Oracle 9i, Oracle 10g ,11g and 12C Programming Languages SQL, PL/SQL and Shell Scripting Development Tools Oracle Reports Builder 6i/9i and 10g, SOA 11g Oracle Forms Builder 6i/9i and 10g, OAF, Oracle Alerts, Toad, SQL*Plus, IBM Maximo, IBM Rational Portfolio Manager, Alfresco, PPM, BMC Remedy, Reflections X, Reflections FTP, XML Publisher Reports, ALM, Service Now and Web ADI Python script, Lambda functions, AWS environment. Operating System Windows XP and UNIX EDUCATION M.B.A (Regular Course, Specialization in HRMS and Marketing) from S.V.U, Tirupati, Passed May-2004. B.Sc (Computers) from Sri Venkateshwara University, Tirupati, Passed Apr-2002 PROFESSIONAL EXPERIENCE ABM, Houston, USA. Mar 2022 till Date (Oracle Cloud ERP Implementations (SAAS)) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion Financials, SCM, PPM Cloud, Azure ADF, BI Reports, OTBI Reports and AdHoc reports. ABM Industries is undertaking a strategic digital transformation by implementing Oracle Fusion Finance, SCM, and Project Accounting modules, replacing legacy systems such as Anaplan, Corrigo, Coupa, and Chrome River. This initiative aims to establish an integrated cloud-based ecosystem, leveraging Oracle Fusion s advanced capabilities to streamline financial operations, optimize supply chain workflows, and enhance project accounting precision. The implementation includes migrating complex datasets, reengineering legacy processes, and integrating with existing enterprise applications to ensure seamless data flow and operational continuity. Key features such as real-time analytics, automated workflows, and AI-driven insights will empower ABM with improved financial visibility, procurement efficiency, and project cost management while fostering scalability and compliance across its business operations. ABM UK Coupa COA & Payment Confirmation Integrations US Implementation Task Creation and Invoice Creation Bill Plan creation Contract Line creation and implementation Billing Event creation Ad-Hoc reports to reconciliation of the Billing against the Task. Integrated and automated the Task creation, Bill Plan creation, Contract Line creation and Billing Event creation interfaces between the CORRIGO third party system and Logic app with OCF. Corrigo Redesign for MND&BNI - post Prod support Coupa BNI & MND Integrations - post Prod support Anaplan BNI & MND Integrations - post Prod support Dropbox, CA, USA. Dec 2021 Mar 2022 (Oracle Cloud ERP Implementations (SAAS)) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion Financials, SCM, PPM Cloud, OIC Integration (SaaS), BI Reports, OTBI Reports and AdHoc reports. Dropbox is a file hosting service operated by the American company Dropbox, Inc., headquartered in San Francisco, California, U.S. that offers cloud storage, file synchronization, personal cloud, and client software. Responsibilities Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support. Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools. Worked on OTBI reports on Financials and Project modules. Enhancements for existing OTBI and BIP reports. Developed OIC outbound OIC Integration to Chrome River/Anaplan external system. Actively engage with Architects and functional staff to ensure ideal design of systems. SFTP setup done for OIC outbound/Integrations. AP ACH file customization for PNC bank and payment file setup done for the same PNC ACH file processing Work with third party systems and vendors that require integration with Oracle ERP Cloud. Developed Supplier and Supplier Bank outbound integration from OCF to external systems. Developed GL Balances report Developed Project Cost and Revenue report. Accenture (Diebold Nixdorf), North Canton, OH, USA. Apr 2021 Dec 2021 (Oracle Cloud ERP Implementations (SAAS/PAAS)) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion Financials, Procurement, SCM, PPM modules, OIC Integration (SaaS/PaaS), BI Reports, OTBI Reports and AdHoc reports. Diebold Nixdorf is an American multinational financial and retail technology company that specializes in the sale, manufacture, installation and service of self-service transaction systems (such as ATMs and currency processing systems), point-of-sale terminals, physical security products, and software and related services for global financial, retail, and commercial markets. Currently Diebold Nixdorf is headquartered in the Akron-Canton area with a presence in around 130 countries, and the company employs approximately 23,000 people.https://en.wikipedia.org/wiki/Diebold_Nixdorf - cite_note-PR-9 Founded in 1859 in Cincinnati, Ohio as the Diebold Bahmann Safe Company, the company eventually changed its name to Diebold Safe & Lock Company.https://en.wikipedia.org/wiki/Diebold_Nixdorf - cite_note-zdiehistory-11 In 1921, Diebold Safe & Lock Company sold the world's largest commercial bank vault to Detroit National Bank. Diebold has since branched into diverse markets and is currently the largest provider of ATMs in the United States. Diebold Nixdorf was founded when Diebold Inc. acquired Germany's Wincor Nixdorf in 2016. It is estimated that Wincor Nixdorf controls about 35 percent of the global ATM market. Oracle Cloud ERP implementing to replace the existing NAV system owned by Chewy to handle the client business with financial module for Chewy financial transactions & business plans. Responsibilities Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support. Work with third party systems and vendors that require integration with Oracle ERP Cloud. Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools. Determine when and how to use the different tools for integrations, reporting, and data conversions. Resolve technical problems of supported applications. Engage Oracle Support and other technical resources to research and resolve issues. Worked on OTBI reports on Financials and Procurement modules. Enhancements for existing OTBI and BIP reports. Developed OIC outbound OIC Integration to external system. Developed OIC Inbound OIC Integration to Oracle Fusion Application. Actively engage with Architects and functional staff to ensure ideal design of systems. Created procedures, functions & packages to validate the data in PAAS environment to support OIC integrations. Chewy, Inc. Dania Beach, FL, USA. Jun 2020 Apr 2021 (Oracle Cloud ERP Implementations (SAAS/PAAS)) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion, Procurement, SCM & HCM modules, BI Reports, OTBI Reports and AdHoc reports. Python, Lambda functions and AWS. Chewy, Inc. is an American online retailer of pet food and other pet-related products based in Dania Beach, Florida. In 2017, Chewy was acquired by PetSmart for $3.35 billion, which was the largest ever acquisition of an e-commerce business at the time. The company completed its initial public offering in 2019, raising $1 billion. Oracle Cloud ERP implementing to replace the existing NAV system owned by Chewy to handle the client business with financial module for Chewy financial transactions & business plans. Responsibilities Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support. Work with third party systems and vendors that require integration with Oracle ERP Cloud. Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools. Determine when and how to use the different tools for integrations, reporting, and data conversions. Resolve technical problems of supported applications. Engage Oracle Support and other technical resources to research and resolve issues. Worked on OTBI reports on Financials and Procurement modules. Enhancements for existing OTBI and BIP reports. Developed purchase orders OIC outbound Integration to HighJum external system. Created Inventory Transfer Orders OIC inbound service which is receiving data from Mercury external system. Actively engage with Architects and functional staff to ensure ideal design of systems. Python scripting to integrate Sale Shipments through REST API on AWS with Lambda functions into Oracle Cloud. Python scripting to integrate Transfer Orders through REST API on AWS with Lambda functions into Oracle Cloud. Export Invoice and AR Transaction Business Data in Visual Builder Cloud Service (VBCS). Created custom On-hand Quantity web application with REST service in Visual Builder Cloud Service (VBCS). Choctaw Nation of Oklahoma, Durant, OK, USA. Aug 2019 Jun 2020 Implementation Partner: ORACLE (Oracle Cloud ERP Implementations) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion, Procurement, HCM modules, BI Reports, OTBI Reports and AdHoc reports. Choctaw Nation of Oklahoma is an existing JD Edwards Oracle client. They are embarking on several projects to upgrade their current JD Edwards Financial\s and move to Oracle Cloud including Talent Management, Human Capital Management and Enterprise Resource Planning. This project is for Enterprise Resource Planning. Responsibilities Worked on AP Payment check print customization Worked on AP ACH file customization Customized PO document/BPA/CPA reports FBDI: Suppliers/Journal Imports/Import Supplier Bank Accounts/FA Mass Additions Loaded Created AdHoc report to show the Suppliers/Journal Import interface errors & Created AdHoc report. Created ICS service through REST API to load purchase orders from JD Edwards to Oracle Cloud. Loaded Requisitions REST through REST API from JD Edwards to Oracle in Dev instance Imported historic data for Journal through ICS with REST API services. CH Robinson, Eden Prairie, MN, USA. Sept 2018 Jul 2019 Implementation Partner: ORACLE (Oracle Fusion Implementations) Role: Oracle Cloud Technical & Integration Consultant & BIP Developer Environments: Oracle Fusion, Procurement & SCM modules, BI Reports, OTBI Reports & ICS/OIC. C.H. Robinson is a Fortune 500 provider of multimodal transportation services and third-party logistics (3PL). The company offers freight transportation, transportation management, brokerage and warehousing. It offers truckload, less than truckload, air freight, intermodal, and ocean transportation. Responsibilities Created Integration service to create AP Invoice Installments through REST API Created ICS service through REST API to load AR Transactions from Navisphere to Oracle in Dev instance Loaded Payable Invoices through REST API from Navisphere to Oracle in Dev instance Imported historic data for Payable Invoices through ICS with SOAP services. Imported historic data for Journals through ICS with csv file. Created Integration service to load Receivables Invoice through SOAP Services. Created Integration service to Create/Update supplier with SOAP Adaptor. Update Installments using Payables Invoice Management SOAP service. Created Oracle Integration service to submit custom ESS Job. Placed report output files in the UCM through Oracle Integration service. Integration issues resolved and updated JSON code and Added parameters in the XXSUBMIT_ORACLE_ESS_JOB integration. Base64 issue resolved while uploading sample files to UCM Worked on Data Migration (AP Invoices/Suppliers/Customers/AR Transactions data) through FBDI Templates. Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement. Developed the AP Invoice aging report with as of date. Lock Down Fields After Record Creation with Groovy Scripts Querying Custom Object Records Using RESTful Web Service Calls In Groovy Scripts Created users and assign appropriate roles to user and Custom roles creation in fusion. Define Value sets and creation of data models. Requirement gathering of this project and act as a technical and functional resource. Sherwin Williams, Cleveland, OHIO, USA. Jun 2017 Aug 2018 (Oracle Fusion Finance Implementations) Role: Oracle Fusion Techno-Functional Consultant & BIP Developer Environments: Oracle Cloud Finance, Procurement, SCM & HCM modules, BI Reports and OTBI Reports. Responsibilities Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/Purchase Orders/GL Journals/Fixed Assets data) through FBDI Templates. Imported historic data for Payable Invoices and Journals. Requirement gathering of this project and act as a technical and functional resource. Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement. Developed XXSW AP Payments Extract and busted the output to the respective emails Developed XXSW AR Cash Applied Extract and busted the output to the respective emails Created XXSW GL Flexi Trial Balance ESS job for the Trial Balance BIP report in Dev instance Developed sales order details report and created ESS job as per requirement. Customize the Receivable Transaction report Developed the Purchase Order Document Template. Developed the Supplier list reports. Developed the AP Invoice aging report with as of date. Developed the Unpaid check report. Created users and assign appropriate roles to user and Custom roles creation in fusion. Define Value sets and creation of data models. Responsible for day to day issues related to accounting, schedule process, Transactions. Inoapps, Kuala Lumpur, Malaysia Mar 2016 May 2017 (Oracle Fusion Finance Implementations) Role: Oracle Fusion Techno-Functional Consultant & BIP Developer Environments: Oracle Fusion Finance, Procurement, SCM & HCM modules, BI Reports and OTBI Reports. End Client Details: (GVC Projects, CUCKOO and Silterra) Inoapps is a leading, global Oracle Reseller and Platinum Partner, with operations across Europe, the Middle East, Asia Pacific and the Americas, and dedicated offices in Malaysia, Singapore, the US and the UK. We are Oracle UKI, EMEA & Global Specialized Partner of the Year for SaaS Cloud Transformation 2016. We specialize in Oracle Cloud SaaS applications. As an early adopter of Oracle Cloud, the Inoapps team has deep experience across multiple pillars including: Financial Management, Procurement, Project Portfolio Management, Planning and Budgeting, Business Intelligence, HR & Talent. Responsibilities Involved setups in the Oracle Financials Cloud modules and prepared documents for the further support. Developed data extracts in BI Publisher and setup FTP Connections with third party systems. On call Support end to end business within Oracle Financials Cloud. Followed Oracle Unified Methodology for all the documents in the implementation. Customized AP Check format to cater business requirement. Customized ACH File format to cater business needs. Worked on FBDI template Load for Suppliers and invoice data. Worked on ADF DI Spreadsheet loads for Journal, invoices, Daily rates. Custom DFF and Value Sets Creation. Worked on IDM and APM modules for creation of roles, user maintenance. Raising SR to Oracle to get support on specific issues. Configuring test and production environments using FSM. Production support on Fusion Financial Applications. Developed a custom form in SAAS environment using application composer with Groovy Script. Making Fields Conditionally Required/ Updatable with Groovy Script Using Println Function and adding Validations to Fields with Groovy Script PM Customer Statement Report Print Receivables Transactions_MD070_v1.0 Perform - Further AR Invoice Changes & Bug fixes FBDL-Payable Invoice Import FBDL-Fixed Asset Mass Additions Import Silterra_PO_Receipt_History Req PO report from 11i to Fusion Provide support for issues encountered by end users such as period close issues and provided clarifications of user queries. Sherwin Williams, Kuala Lumpur, Malaysia Apr 2013 - Mar 2016 (R12 Implementation-APAC, New country opening, Enhancement and Support) Role: Oracle EBS Technical Lead & BIP Developer Environments: EBS (R12.2.5), Procurement, AP, AR, CM, GL, INV, OM, Service Contract, Pricing, SOA 11g, PL/SQL and Reports XML publisher. Responsibilities Expertise with the following RICEW objects. Prepared R12 GAP analysis doc for the RICE objects in the R12 upgradation projects. Discussion with the Client to understand their technical needs. Design and development of Outbound and Inbound interfaces using SOA 11g and PLSQL. Design and development of Order Details, Order Line Details and Order Ship Confirm web services using SOA apps adapter. Integrated PAUP application with SOA services which fetches Order information and Saves data back to custom tables on ship confirm. Created PLSQL APIs to support webservice calls Design and development of Order Details and Order Process web services using SOA apps adapter. Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues. Validated the code as per the naming standards which is developed by the other team members. Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend. Developing New Conversions and Interfaces for upgradation of R12. Development of New Reports and Customization of Existing Reports and Peer code reviews. Developed in the Sales Order Lines WEB ADI. Creating Event Alert and Periodic Alert to send mails, submit programs and etc. Creation of Technical Specifications, Unit Test Plan Documents. Created various PL/SQL procedures/packages according to the Client requirements. Worked for enhancements and support cases/incidents for the RICE Objects. Preparing data fix scripts for data manipulation and delete the Orfhan records. Helping to the BI team to make them understand the apps data modeling and functionality. KT and training on BMC Remedy, PPM Migration tools and application to the new joiners. Herbalife, Bangalore, India. Apr 2011 - Mar 2013 (Migration to R12 and Development, Enhancement, Support for 11i) Role: Oracle EBS Technical Lead & BIP Developer Environments: Oracle Applications R12, PO, AP, AR, GL, Service Contract, Pricing, INV, OM and PL/SQL, BIP Reports. Responsibilities Expertise with the following RICEW objects. Review / Analysis / Creation of Technical Specifications, Unit Test Plan Documents. Discussion with the Client to understand their technical needs. Developing New Conversions & Interfaces. Developing Conversions and Interfaces for up gradation of R12. Development of New Reports and Customization of Existing Reports. Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend. Creating Event Alert and Periodic Alert to send mails, submit programs & etc. Created various PL/SQL procedures/packages according to the Client requirements. Managing and delivering the Change Requests (CR) and Incident Records (IR) within the time of SLA. Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues. Trained on BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter) for developing custom business processes to integrating with different systems using OSB Designed and developed a Payable Invoice Interfaces to the BPEL Process Manager utilizing the Oracle SOA. IBM, Bangalore, India Dec 2005 - Mar 2011 Hertz Financials European System, Estero, FL, USA Sep 2009 - Mar 2011 (Development, Enhancement, Support and Migration to R12) Role: Oracle Apps Technical Consultant Environments: Oracle Applications 11.5.10, R12, PO, AP, AR, GL, INV, OM and PL/SQL, XML Reports. Responsibilities Review / Analysis / Creation of Functional Specifications, Technical Specifications, Unit Test Plan Documents Discussion with the Client to understand their technical needs. Developing conversions for up gradation of R12. Developing, supporting, and enhancing Inbound/Outbound interfaces, RDF reports, PL/SQL components of almost all modules implemented in the project. Southern Company, Atlanta, Georgia , USA Jun 2008 - Aug 2009 (End to End Implementation Project) Role: Oracle Apps Technical Consultant Environments: Oracle Applications 11i, PO, AP, INV and PL/SQL, D2K Reports. Responsibilities Expertise with the following RICE objects. Development of Technical Specifications. Interaction with Functional Specification owners on various functional issues during development. Developed Conversion, Interface, Report and Alerts. Design, Development and Testing of Database Packages and different Pl/SQL components. Sandals Project, Miami, Florida, US. Dec 2005 - May 2008 (11i Enhancements and Support Project) Role: Oracle Developer Environments: Oracle Applications 11i, PO, AP, GL and PL/SQL, D2K Reports. Responsibilities Developed Conversions and Interfaces to upload the various details into the apps base tables from legacy system. Developed outbound interface to extract the data from the Oracle tables into flat file. Writing Packages, Procedures and Functions for developing conversions and Interfaces. Keywords: artificial intelligence business intelligence active directory information technology purchase order procedural language bay area Arkansas California Florida Minnesota Ohio South Carolina