Home

Upendranath Gujarati - Senior Oracle Cloud Technical Consultant

[email protected]

Location: Minneapolis, Minnesota, USA

Relocation: REMOTE

Visa: H1B

Upendra Gujarati Summary: Over 15 years of experience as an Oracle Fusion Cloud/EBS applications developer, architect & consultant with functional exposure to Oracle general ledger, account payable, accounts receivable, cash management, procurement, service contracts and install base modules. Multiple full life cycle implementations, rollouts, support and upgrade projects from 11i to R12 and Oracle Fusion cloud. Hands on expertise in customization of Oracle Cloud Fusion applications, cloud BIP reports, OTBI reports and dashboard, Oracle integration cloud (OIC), process cloud service (PCS), EBS rice components and experience in Oracle SQL/PLSQL, Oracle developer suite (forms and reports), SQL*Loader, oracle XML BI publisher and oracle workflow, Unix shell scripts. Seasoned experience in business analysis, business requirements gathering, configuration mapping from non-Oracle-legacy and E-Business suite systems to fusion ERP cloud, solution design, development, testing, implementation, user training, documentation and support. Extensive hands-on experience in REST API & SOAP webservices to integrate oracle ERP system with external systems. Experienced in oracle financials, supply chain (SCM) and CRM functional areas, proficient in P2P & O2C business processes. Implemented the Oracle Cloud Procurement punch-out catalog functionality, performed all the configurations including configuring OBN (oracle business network) for cXML data transmission. Technical impact assessment and estimate proposals for Oracle Apps R12 Upgrade/re-implementation. Well versed with development and modelling tools like SQL-developer, toad, XML/BI publisher J-developer, kin tana, SVN, MS-Office and MS-Visio. Technical Skills: Primary Skills: Oracle BI Publisher/OTBI reports, data migration, sandbox customization, REST API s in oracle fusion, Integration Cloud Service (ICS / OIC), Oracle EBS technical development (RICEW components), conversion & interfaces (inbound and outbound), forms, reports, XML reports, workflow builder Packages: Oracle cloud application 22D, oracle EBS 12.2.3, 12.1.3, 12.0.6, 11.5.10 Modules: Order General Ledger (GL), Account Payables (AP), Account Receivables (AR), management (OM), inventory (INV), Purchasing (PO), HRMS, HCM, Projects, Fixed Assets. Operating Systems: Win 10, Win 8, UNIX Languages: SQL, PL/SQL, UNIX Development Tools: Toad, SQL * Plus, SQL developer, BI publisher, oracle forms 10g, oracle report 10g, putty, win-scp Database: oracle 11g, 10g Version Tools: SVN Education: Master of Computer Applications (MCA), Osmania University, Hyderabad, India - 2003 Bachelor of Science (B.Sc.) in Computer Science, 1999 Professional Experiences: Client: Daikin Applied Americas (DAA), Minneapolis, MN. Duration: Jun 2023 to Till Date Role: Senior Oracle EBS Technical Consultant Project: Data migration from Oracle EBS ERP to Microsoft Azure DataLake Description: Daikin Applied Americas (formerly McQuay International) is a corporation that designs, manufactures and sells heating, ventilation, and air conditioning (HVAC) products, systems, parts and services for commercial buildings with world headquarters located in Minneapolis, Minnesota, Products are sold by a global network of sales representatives and distributors. The current project assignment is data migration of Oracle EBS ERP to Microsoft Azure DataLake and Production Support of Oracle EBS R12 applications. Responsibilities: Analyzing the Datalake data structure requirements and develop export data export scripts in Oracle EBS using Oracle SQL in Oracle EBS R12 ERP applications GL, AP, AR, PO, OM, Service Contracts, Install base and facilitating development of Power BI reports for analytics Own production support tickets, perform requirement gathering for new enhancements, requirement analysis, create solution design documents, carry out technical customization development, BI report development and preparation of test cases. Migration of technical objects and setup configurations into the sign-off post CAB approval. Support the finance function teams (IT functional & Business users) to facilitate proper month-end period closing. Work with oracle support thru service requests (SRs) for critical product issues and data fixes. Environment: Oracle EBS R12, Oracle SQL, Oracle PL/SQL, TOAD and Oracle EBS GL, OM, AR modules, Microsoft Azure DataLake & Data Studio. Client: NOV Inc, Houston, TX. Duration: Aug 2023 to May 2024 Role: Senior Oracle Cloud Technical Consultant Project: Oracle Cloud Procurement Implementation & Support. Description: NOV Inc., formerly National Oilwell Varco, is an American multinational corporation based in Houston, Texas. It is a worldwide provider of equipment and components used in oil and gas drilling and production operations, oilfield services, and supply chain integration services to the upstream oil and gas industry. The project was implementation and supporting Oracle Cloud ERP applications ranging financials (GL. AR. AP), Procurement (P2P) and order management (OM), Oracle SQL, Oracle Fusion BI Publisher & OTBI reporting, FBDI. Responsibilities: Requirements Gathering, Analysis & Design: Working with business stake holders, gather requirements and create configuration, solution design documents, carry out BI report s development and preparation of technical specification documents in Oracle Modules viz (PO, INV, AP, AR, OM and GL). Data Conversion: Handled data migration activities using FBDI templates and Rapid implementation sheets, cut-over planning for Go-live, reconcile legacy data with the migrated data in cloud. 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. Configuration Data loads - Migration of configuration data across the cloud instances (DEV/TEST/UAT/PROD) using the configuration packages. Worked with the Primary Finance Lead consultant and business teams, prepared GL setup data and loaded using Rapid Implementation Spreadsheets Prepared, performed and managed configuration packages to migrate the setup data across the instance until production go-live & critical participation in cut-over planning Complex WIP Work Definition extract for work definitions migration Regular inventory item extract for periodic item attribute updates Reports Development: Develop data intensive BI Publisher reports & OTBI Dashboards for analytics and Customer/vendor & third-party facing document report layouts. OTBI Reports and Dashboard Order Management Dashboard Procurement Dashboard Receivable transaction Dashboard Payable Transaction and Payments Dashboard BI Publisher reports viz Project Schedules Report Print work order Traveler Report Payables Check printing format report Project Revenue Budget Sync Report Custom Print Commercial Invoice Report Custom Pick Release, Packing Slip Report & Bill of Lading report Custom Sales Order acknowledgement Report Support the finance function teams (IT functional & Business users) to facilitate proper month-end period closing. Monitor transactions and work with Oracle Integration Cloud (OIC) team to troubleshoot the failure and facilitate the reprocessing. Participate in mini-projects that include tasks like report development, mass updates to transactional data using REST API & SOAP webservices. Perform the regression testing of Oracle cloud quarterly patches and retrofit any customizations if required. Environment: Oracle Cloud ERP (GL, AP, AR, PO, OM), Oracle BI & OTBI reporting, Oracle GL, Oracle SQL, FBDI. Client: Martin Marietta Materials, Hyderabad, India. Duration: July 2022 to July 2023 Role: Senior Oracle Cloud Technical Consultant Project: Oracle Cloud Procurement Implementation & Support. Description: Martin Marietta Materials, Inc. is an American company and a member of the S&P 500 Index. The company is a supplier of aggregates and heavy building materials, with operations spanning 26 states, Canada and the Caribbean. The assignment was implementation of Oracle Cloud Procurement with Punch out catalog configuration and integration with oracle business network (OBN). Responsibilities: Own the vital activities in implementing the procurement cloud, shared service of general ledger & HCM modules. Performed requirement analysis, create configuration and solution design documents, carry out BI report s development and preparation of technical specification documents. Load configuration data in production and resolve business critical support issues in narrow SLAs. Configuration Data loads Worked with the Primary Procurement Lead consultant and business teams, prepared GL, Procurement, HCM setup data and loaded using HDL and FBDI Prepared, performed and managed configuration packages to migrate the setup data across the instance until production go-live & critical participation in cut-over planning Configure the punchout catalogs in Oracle procurement cloud and Oracle business network (OBN) to transmit the POs in cXML format. Reports Development: BI Publisher reports viz PO Requestor Charge Account Report PO Item SKU Details Report Custom eProcurement Receipt Report. Engage with Oracle product support as part of ISP (intensive support program) to resolve issues related to the standard functionality of financial & procurement modules. Own, maintain, monitor and reconcile the data integration activities between the JDE system & oracle cloud procurement. Participate in mini-projects that include tasks like report development, mass updates to transactional data using REST API & SOAP webservices. Perform the regression testing of oracle cloud quarterly patches and retrofit any customizations if required. Environment: Oracle Cloud Procurement, Oracle BI & OTBI reporting, Oracle GL, Oracle SQL, JD Edwards data mapping. Client: RPG Group, Hyderabad, India. Duration: July 2021 to June 2022 Role: Oracle Cloud Solution Architect Project: Oracle Fusion SaaS/PaaS Implementation. Description: The Rama Prasad Goenka Group, commonly known as RPG Group, is an Indian industrial and services conglomerate headquartered in Mumbai. The RPG Group currently consists of more than fifteen companies, mainly infrastructure, tires, and life sciences. Some of the companies it holds are CEAT Tyres, information technology firm Zensar Technologies, infrastructure company KEC International, pharmaceutical company RPG Life Sciences etc., The Project was upgrading the Oracle EBS R12 ERP to Oracle Fusion ERP Cloud applications implementing Oracle Financials, Procurement, Order Management, HRMS and PPM (Projects Portfolio Management). Responsibilities: Requirements Gathering, Analysis & Design: Conduct requirement gathering session with business stake holders, gather requirements and create configuration, solution design documents, carry out BI report s development and preparation of technical specification documents in Oracle Modules viz (PO, INV, AP, AR, OM GL, and PPM(Project Portfolio Management)). Data Conversion: Handling data migration activities using FBDI templates and Rapid implementation sheets, cut-over planning for Go-live, reconcile legacy data with the migrated data in cloud Master data: COA Hierarchies, BU & LE, Supplier, Customer, Banks, Inventory Items, Supplier Banks & Tax Registrations, 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. Configuration Data loads Worked with the Primary Finance Lead consultant and business teams, prepared GL setup data and loaded using Rapid Implementation Spreadsheets Prepared, performed and managed configuration packages to migrate the setup data across the instance until production go-live & critical participation in cut-over planning Regular inventory item extract for periodic item attribute updates Reports Development: OTBI Reports and Dashboard Order Management Dashboard Procurement Dashboard Receivable transaction Dashboard Payable Transaction and Payments Dashboard BI Publisher reports viz Receivable Invoice Report Customization Payables Check printing format report Customization of Account Analysis Report Custom Print Commercial Invoice Report Custom Pick Release, Packing Slip Report & Bill of Lading report Interface Development: Oracle IDR(Intelligent Document Recognition) for Payables Invoices Interface Sandbox Personalizations: Personlization using Sandox page composer on Supplier Page. Requirement was to restrict the DFF Metric_Date Field update by the external supplier via Supplier portal. Participated in CRP and SIT activities to demonstrate the cloud applications business flow to the business users and stake holders, developed BIP reports & integrations. Devise and execute test cases in the functional areas GL ad AP modules. Obtain sign-offs, preparation of system operating procedure documents and perform user training activities. Engage with Oracle as part of ISP (intensive support program) to resolve issues related to the standard functionality of financial modules. Handled the data migration activities from the existing ERP system EBS R12 to Fusion for finance and SCM functional areas as one of contact in the project. Environment: Oracle Cloud ERP applications, Oracle, GL, AP, AR, PO, OM, HRMS, Oracle PPM, Oracle SQL, BI Publisher reporting, FBDI and OTBI.s Client: DELL Technologies, Hyderabad, India. Duration: May 2020 to May 2021 Role: Principal Oracle Cloud Technical Consultant Project: Implementation Fusion ERP Cloud and Oracle EBS Support. Description: Dell Technologies Inc. is an American multinational technology company headquartered in Round Rock, TX. Dell's products include personal computers, servers, monitors, computer software, computer security and network security, as well as information security services. The project assignment is implementation of a Custom financial application using Oracle SQL, Oracle PL/SQL and Oracle EBS GL, OM, AR modules. Responsibilities: Playing an architect role in the team of the implementation of DELL DIReCT financial system. responsible for business analysis, requirement gathering, CRP, Design, test and cut-over planning for Go-live and lead for sustained support post go-live. Analyze business requirements in the custom revenue recognition module, design solutions to integrate Upstream/downstream systems with the DIReCT system. Performed extensive unit and integration testing, user training and documentation. Own the data migration activities for migration of Oracle EBS data to Fusion cloud along with other implementation tasks like configuration mapping, implementing, testing and functional demos to the business users and get the signoff, acceptance of business. Simultaneously supporting the oracle EBS 12 System and custom COGS and revenue applications. assist the business team in month-end period closure activities. Assisting business team in month-end period closure issues. Driving the biweekly stake holders meeting. Environment: Oracle EBS R12, Oracle SQL, Oracle PL/SQL and Oracle EBS GL, OM, AR modules. Client: Bilcare Research, Pune, India. Duration: May 2019 to May 2020 Role: Senior Oracle Cloud Technical Consultant Project: Implementation Fusion ERP Cloud Description: Bilcare is a company that specializes in pharmaceutical packaging, research, and innovation. Their work focuses on improving patient health outcomes by partnering with the pharmaceutical industry. Responsibilities: Participate in implementation of all Oracle cloud financials applications bill care India, US, UK and Italy operations. Performed the data migration specialist role. Developed queries to extract the masters and transactional data from oracle EBS to load the data in oracle cloud using FBDI templates and rapid implementation sheets. Developed the reconciliation scripts to perform the reconciliation of data between the legacy and cloud applications. Developed BI reports for the MIS activities of the business team. Environment: Oracle Cloud ERP applications, Oracle, GL, AP, AR, PO, OM, Oracle SQL, BI Publisher reporting, FBDI and OTBI.s Client: Emerson Network Power, Columbus, OH, USA. Duration: January 2015 to February 2019 Role: Lead Oracle EBS Financial Technical consultant. Project: Oracle Financials Implementation &Support. Description: Emerson Network Power (currently Vertiv) is a global leader in embedded in telecommunications and data network infrastructure. They deliver reliable power, precision cooling, connectivity, and embedded solutions for computer, communications, health care, and industrial systems. The project assignment was implementation of Oracle EBS R12 applications and Production system support. Responsibilities: Primary member of the implementation team for financial modules. Responsible business analysis, requirement gathering, CRP, design and cut-over planning for Go-live and lead for sustained support post go-live. Mapping the client's business processes in the financial modules of oracle payables, receivables, cash management, iExpense and EBTAX and integration with vertex O Series. Performed gap analysis and designed the solutions for configurations, conversion, interfaces, personalization s and XML reports. Owned the responsibilities of testing, user training and documentation. Transitioned into post-production support lead role, tracking support and enhancement tickets on daily basis and reporting to the delivery manager. Coordinating and managing the integration with external/legacy systems. Assisting business team in month-end period closure issues. Participation in oracle EBS to cloud migration project. Environment: Oracle EBS R12, Oracle GL, AR, AP, Cash Management, Oracle SQL, Oracle PL/SQL, Oracle BI Publisher reports. TOAD, SQL*Loader, Oracle Forms & Reports. Client: FedEx. Collierville, TN, USA. Duration: January 2014 to December 2014 Role: Lead Consultant Project: TechConnect EBS R12 Support and Rollout Description: FedEx Corporation is an American multinational conglomerate holding company focused on transportation, e-commerce and business services based in Memphis, Tennessee. Responsibilities: Played a key role in business analysis and resolving critical issues in oracle financials (GL, AR, AP, CE, iExpense) and CRM and performing RCA (root cause analysis) for repetitive defects / issues and providing a permanent solution. Tracking of support and enhancement tickets on daily basis and reporting to the delivery manager Coordination with other groups of FedEx for successful completion of the support tasks Understand requirements for enhancements in oracle financial modules and preparation of requirement and technical design and test script documents. Environment: Oracle CRM Service Contracts, Deport Repair, CRM Foundation, Oracle SQL, Oracle PL/SQL. Oracle GL, AR, AP, CE, iExpense. Client: Mastek Inc. Coral Gables, FL Duration: June 2013 to November 2013 Project: Oracle EBS Upgrade 11i to R12. Responsibilities: Leading the design and development/migration activities and retrofitting the solutions in oracle financial modules (GL, AR, AP, CE, I expense). Completely owned the responsibilities of complete testing, migration planning/strategy. Lead the offshore development team and report the status to the delivery manager. Client: Bensoussan Deutsch & Associates INC (BDA), Seattle, WA Duration: January 2012 to April 2013 Project: Oracle Applications R12 Implementation Responsibilities: As a lead consultant, had actively performed the hands-on activities in all the phases of project: Played a key role in the design and solution mapping, preparation of AIM documentation. Defined the strategy for data conversions, reports, personalization s and workflow customizations. Participation in solution review, code review, unit testing and system integration testing. Reporting the weekly status and driving the review calls. Client: Essilor of America, Dallas, TX Duration: September 2011 to December 2011 Project: Oracle Applications R12 Implementation and Support. Responsibilities: Played a key role in implementation, managing the enhancement and support issues. Preparation of action plans for migration of the approved code/objects to Test and PROD through RFCs with the help of oracle On-demand. Driving support team and working with oracle support and testing. Preparation of weekly status reports and driving the review calls. Clients: Managed Services for multiple US based Clients / Daz Systems Managed Services. Duration: October 2010 to July 2011 Responsibilities: Played a key role in managing the post-production support services for multiple clients. Monitoring the bug tracker for issues assigned to the support team and attending the business-critical issues instantly. Analysis of requirements for new developments/customizations and preparation of functional & technical specification. Performed solution design, code review, unit testing and system integration testing and code deployment. Client: Yamaha Corporation of America, Los Angeles, CA, USA. Duration: November 2008 to April 2010 Project: Oracle Applications Upgrade and support. Responsibilities: Performed a key role in upgrading the technical stack components from 11.5.4 to 11.5.10, ranging forms, reports, interfaces and Unix shell scripts. Retrofitting the CEMLIs and preparation of technical specification. Participated in CRP, UAT, Go live planning and post production support. Client: Remo Inc, Valencia, CA, USA. Duration: October 2007 to August 2008 Project: Oracle E-Business Suite Upgrade (11.0.3 to 11.5.10). Responsibilities: As a senior consultant, had actively performed the hands-on activities of all phases of the project. Designed the strategy for migration of forms, reports, interface and other customization from 11.0.3 to 11.5.10. Lead the support activities post go-live. Client: Jacobs Engineering, Pasadena, CA, USA. Duration: September 2007 to October 2007 Project: Oracle E-Business Suite Roll-out Mexico BU. Responsibilities: Customization of preprocessing and timecard manual check forms for Mexico BG. Customization of labor costing program for Mexico BG. Client: Shaw Communications, Calgary, Canada. Duration: July 2007 to September 2007 Project: Oracle E-Business suite 11iImplementation. Responsibilities: Played a key role in implementation and support of oracle applications 11i. Performed the role of senior consultant. Designed the technical specification and unit test documents. Keywords: business intelligence active directory information technology golang container edition purchase order logistics execution trade national microsoft procedural language Arkansas California Florida Minnesota Ohio South Carolina Tennessee Texas Washington