Yash Khandelwal

Worked on the Hershey's project.

• Executed migration of inbound WMS operations from RedPrairie to Blue Yonder WMS, encompassing ASN, receiving, putaway, LPN management, and inventory control.
• Applied generative AI tools in SDLC framework and requirement analysis while developing UAT test cases.
• Provided L2 support for BYWMS warehouses to ensure system reliability.
• Resolved Control-M job failures, which are under L2 level, through analysis and solution implementation.
• Documented technical designs and uploaded test results into the Q-test tool provided by the developer.

Currently working for Specsavers Pvt. Ltd. project.

• Designed and developed PL/SQL stored procedures, cursors, functions, and packages for Oracle SCM and PDH processes.
• Hands-on experience in writing SQL queries for AR and Oracle PDH module.
• Implemented the application-level security and created the views for controlled data.
• Performed code deployment using PLSQL language by gathering requirements, analyzing, developing, SIT (creating test cases as well), UAT, pre-production, production, and post-deployment sanity testing using JIRA tools.
• Implementing performance optimization in SQL queries, and in PL/SQL stored procedures and packages.
• Using Oracle 12c applications, the code that is developed provides support through incident management.

Worked on a project for the LinkedIn Corporation.

• Provided the technical and functional expertise related to the EBS AR module for supporting the daily operations in Oracle 12c applications.
• Analyzed the database objects for performance issues, and implemented performance tuning solutions in PL/SQL packages, cursors, and procedures.
• Designed and implemented customized solutions to address client-specific needs, including configurations, extensions, and integrations with third-party systems.
• Use of Oracle Standard APIs and through APIs designed the code fix, then tested and implemented in the Oracle database.
• Identified the bugs in existing PLSQL procedures and packages, did root cause analysis for the issue, designed appropriate code fixes, tested, and implemented the fixes through instances.