Home

Utkarsh Kumar Singh - Senior Oracle EBS SCM Technical

[email protected]

Location: Plano, Texas, USA

Relocation:

Visa: H1B

Utkarsh Singh Summary: Over 8+ years of software development experience in design, development, customization, operation support, upgrade, implementation of oracle ERP application (11i, R12) & Oracle fusion Cloud as Senior IT Application Developer. In-depth knowledge in various Oracle modules such as WMS, INV, OPM, OM, GL, AP, AR, FA, WIP, Shop Floor Management (OSFM). Expertise in Oracle Integration Cloud (OIC) and Fusion BI Reports, File Based Data import, PL/SQL, RESTful APIs and Web Services, Oracle Application Framework (OAF) and data conversion specialist, Oracle tools like Reports, Forms, Workflows, BI publisher reports. As a senior technical developer, involved designing and implementing the solutions, worked closely with the development team on different RICEW components. Worked on the new Custom Development and Personalization of the seeded OAF pages as per the requirements. Implemented integrations among different cloud applications and on-premises applications using Oracle Integration Cloud. Extensive experience in data conversions from legacy to oracle cloud - includes identifying business rules/requirements, data extraction, cleansing, pre-validation and loading/transforming to oracle cloud environment. Worked in analysis, design and Development and Implementation Phases of complete software Development Life cycle. Developed MD70 and MD 120. Worked in the development of many Cloud accelerators & differentiators in Oracle Cloud space - Cloud configurators leveraging Robotic process automations and Data Migrations. Experienced in participating in multiple CRP(s), SIT, UAT and Go-live phases of the projects. Provided support during and post Go-Live activities. Worked both independently and in a team environment to achieve the team goals. Trained new college graduates with Oracle technical components. Also, part of Internal Code Quality as an Auditor and involved in Project Management Plan documentation and Oracle practice Interview Panel. Apart from the project deliverables, represented Hitachi for CMMI Level 3 Audits and is an Auditee for multiple projects. Education & Certifications: Bachelor of Technology in Computer Science & Engineering from Jawaharlal Nehru Technological University, India (2011-2015) Oracle Certified Cloud Platform Application Integration 2021 Specialist Oracle Certified Professional JAVA SE6 Programmer. Oracle Cloud Infrastructure 2024 Generative AI Professional Technical Skills: Technologies: OIC, BI Publisher, OTBI, Oracle R12 Version, Oracle Forms 10g, XML Publisher Report, Oracle Reports 10g, Workflows, Oracle OA Framework (OAF), Shell Scripting, JDeveloper 10g, PL/SQL, REST Services, POSTMAN, TOAD, PuTTY, SQL*Loader, JIRA, JavaScript Professional Experience: Client: Seagen Biotechnology Company, Seattle, WA Duration: August 2022 Till Date Role: Senior Technical Developer & Data Migration expert Description: Seagen is a global biotechnology company that develops and commercializes transformative cancer therapies. Seagen extensively uses Oracle R12 modules SCM, GL, OM, AP for Drug manufacturing process. Responsibilities: Work on multiple assignments providing technical expertise and responsible for deliverables, as Seagen is drug manufacturing company, worked with different module of Oracle EBS R12(OPM, OM, WMS, Advance Pricing and AME Approvals) Developed Inbound (SO, WO Inbound) & Outbound (SO, WO Outbound) Oracle Integrations - As part of supply chain planning these Inbound and Outbound extracts are overly critical and must be completed in a time bound manner. Led North Creek project for implementing enhancements for inventory including labels, Power BI Reports, and additional customizations. Delivered various custom solutions including XML Reports, Alerts, Third party Interfaces, form personalization and AME approvals. Worked on various integrations like CLIN pay for AP Invoices, HRIS for Employees & FND User, 3PL for inventory transactions, and Veeva for Lot Status update. Created migration scripts for migrating the components to higher environments initially then supported GitHub implementation for code migration, defined the processes and coordinated the migration activities with other team members and DBA team. Being Part of the technical team during User Acceptance Testing (UAT) and Go Live occasions. addressed the critical Bugs and object assigned to me. Created Technical Design documents (MD 70) based on the functional specification documents for the new enhancements. Prepared MD 120, CV. 40, CV.60 documents. Participated in CRP/SIT/UAT problem solving sessions with essential team members. Worked on investigating and fixing production issues in Oracle. It was possible to fix some of the issues using OAF personalization and for the remaining ones to work on the Controller Extensions. Created a process to validate and load diverse types of orders using APIs into Order Management from external systems. Customization of Back-order tracking, approval process in I-procurement and handling customizations required. OAF extension to default the user specific data on Non-Catalog Request, Return Item in I-procurement. Environment: Oracle R12 OPM, INV, OM, AP, GL, PLSQL, I-procurement, OAF, Workflow, BI Publisher Reports, Oracle Forms, Shell Scripting, JDeveloper, GitHub. Client: CalAmp UK Ltd, London, United Kingdom Duration: December 2019 July 2022 Role: OIC Developer and Cloud resource Description: Largest fleet operations company which enable transportation and logistics, government, industrial and vehicle manufacturers to improve efficiency, safety, visibility and compliance using Oracle s SAAS solutions, It Realtime integrates (OIC) the data from various fleets using Oracle applications and as per customer requirement displays in dashboard and reports (BIP & OTBI). Responsibilities: As part of the development and support team worked across the different modules, enhancements, and customizations. Designed, developed, and deployed integration solutions using Oracle Integration Cloud (OIC) to streamline business processes and enhance data exchange between various applications. Collaborated with cross-functional teams to gather integration requirements and translate them into effective integration designs. Implemented RESTful APIs web services and orchestrated integrations using OIC s visual designer. Leveraged OIC s adapters to connect with on-premises and cloud applications, enabling seamless data flow. Conducted performance testing and optimization of integrations to ensure smooth and efficient data transfer. Integrated security best practices into OIC implementations, ensuring data confidentiality and integrity. Troubleshot and resolved integration issues, working closely with stakeholders to ensure timely resolution. Provided technical guidance and mentoring to junior team members, facilitating their understanding of OIC concepts and best practices. Designed and implemented data mappings and transformations using OIC s mapping components. Implemented monitoring and logging strategies to proactively identify and address integration issues. Worked on OTBI reports and BIP Reports as part of the business requirements. Environment: OIC, REST Services, JSON, BI Publisher Reports, OTBI reports, POSTMAN Client: Black & Veatch, Overland Park, KS Duration: June 2019 December 2019 Role: Sr. Fusion Technical Developer Project: B&V Fusion Rollout Description: With more than $4 Billion revenue, Black &Veatch is one of the largest is a global engineering, procurement, consulting and construction companies. As part of Oracle Fusion implementation, integrated on-premises applications using OIC and several businesses critical BIP reports were created to achieve business requirements. Responsibilities: Implemented Oracle Fusion Cloud and Integrate with Third-Party systems. As part of the development and support team worked across the different modules, enhancements, and customizations. Customized the Cloud Fusion page to add a Text on the Supplier page, also embedded the VBCS page application in the Supplier Definition Fusion Screen. Developed Oracle Integration to Call BI Report Data to insert data from Cloud to custom tables in DBCS, which is used by other critical BI reports. Developed generic scripts for Customer Master, Accounts Receivables Transactions, Customer Item for extraction of data from legacy system to load into Fusion using FBDI templates. Worked on Implementing and Testing Oracle Fusion applications Procurement, SCM and Supply Chain Financial Orchestration modules on Cloud. Development/Unit testing of BI Publisher reports. Includes developing Data models from SQLs, developing rtf/excel templates, developing style sheets etc. Developed OIC utilities for migration of OIC artifacts to UAT and Production. Environment: Fusion O2C, OIC, REST Services, JSON, FBDI, BI Publisher Reports, OTBI reports, POSTMAN Client: PPG Industries, Pittsburgh, PA Duration: October 2016 May 2019 Role: Sr. Technical Developer Project: Lotus Project Description: Pittsburgh Plate Glass (PPG) Company is American Fortune 500 company and global supplier of paints, coatings, and specialty materials. In PPG Industries Oracle EBS is used in Process Manufacturing, Order Management, Warehouse Management and several 3rd party systems like Esker used to integrate with Oracle. Various customization and extension of OAF pages were made as part of requirement. Responsibilities: As part of the development and support team worked across the different modules, enhancements, and customizations. As per the requirement worked across various modules such as), Oracle Process Manufacturing (OPM), Oracle Warehouse Management (WMS), Oracle Order Management (OM), GL and AR. Implemented new Preassembly process for Cleavland and Delaware manufacturing sites, which includes custom interface development and various reports and MSCA application to perform pick and transfer process. Developed batch ticket report to help the shop floor worker to display the real time information of an OPM batch and reservations against the material in the Inventory. Worked on challenging extensions and customization of Oracle application and delivered on time. Part of the technical team during User Acceptance Testing (UAT) and Go Live support addressed the critical bugs and object assigned to me. Followed all processes and adherences of the client and completed the assigned development tasks with proper documentation and delivered on time. Led the data Conversion activity to load the OPM, INV and BOM data into Oracle system from the legacy systems. Build complex custom applications in Oracle Application Framework and interfaces (PLSQL, SQL) which enables a two-way exchange of data from Oracle EBS to Third party system to process Work Order Parts Issues, and from Third party system to Oracle EBS for Parts Returns. These Interfaces reduce manual entry and increase data Integrity. Worked on the Mobile Supply Chain Application and delivered the assigned task on time. Worked on Esker interface to create Orders in Oracle received from outside systems. Customized the existing programs as part of the new requirements. Led the support project activity from the Offshore to deliver the assigned ticket with in the defined SLA. Worked on Oracle Forms, Reports, BI publisher, Workflow, Shell scripting. Conduct peer reviews at each phase of the development (TD review, Code Review, Test Case review) Led Daily meetings with the Team for the updates on the progress Preparation of unit test case and migration documents. Environment: Oracle R12 OPM, BOM, WIP, OM, WMS, FIN, Oracle Mobile Supply Chain Application (MSCA), OAF, Workflow, BI Publisher Reports, Oracle Forms, Shell Scripting, JDeveloper, Putty, WINSCP, TOAD Client: Clopay Corporation, Oh Duration: July 2016 September 2016 Role: Techno-Functional Expert Project: RPA EBS Developer Responsibilities: Design, development and customization of RICE components. Migration of vendor data from bill.com legacy system to Oracle EBS R12.1.3 in AP. Development of supplier interface in AP so that new suppliers and sites get imported from Legacy into EBS. Migration of new assets to Oracle in Fixed assets FA. Worked on Form Personalization to restrict Asset books based on responsibility in FA. Worked on Payables open interface for creating pre-note invoices as a part of Broker channel project in AP. Worked on investigating and fixing production issues in Oracle EBS 12.2.6. It was possible to fix some of the issues using OAF personalization and for the remaining ones to work on the Controller Extensions. Analyzing and pin-pointing the root cause was the tough part as it involved decompiling and figuring Oracle code aided by screen logs and trace files. Environment: Oracle R12 P2P Cycle, OAF, iProcurement, Workflow, BI Publisher Reports, Oracle Forms, Shell Scripting, JDeveloper, Putty, WINSCP, TOAD Keywords: artificial intelligence business intelligence information technology golang procedural language Arkansas Kansas Maryland Ohio Pennsylvania Washington