Job Title

Job Title: BY-Enterprise Supply Planning ConsultantJob Description:We are seeking a highly skilled and experienced BY Consultant with a strong background in Oracle PL/SQL development and Oracle Cloud infrastructure. The ideal candidate will have significant expertise in the BY Supply Planning platform, with hands-on experience in ESP and SNOP modules. This role will focus on the development, implementation, enhancement, and support of the BY Supply Planning platform, with a deep focus on Oracle PL/SQL and database design.Responsibilities:Lead the BY Supply Planning platform initiatives, including ESP (Enterprise Supply Planning) and SNOP (Sales and Operations Planning) modules, providing expertise in development, implementation, enhancement, and ongoing support.Collaborate with cross-functional teams to design and develop complex database objects such as Stored Procedures, Functions, Triggers, and Packages using Oracle PL/SQL.Perform PL/SQL coding and development tasks for data migration, integration, and system enhancements.Oversee BY ESP Migration projects, ensuring smooth transition and system optimization during migration, as well as providing post-migration support.Create and maintain complex PL/SQL functions, stored procedures, cursors, and packages to support business requirements and application logic.Engage with stakeholders to troubleshoot, resolve, and provide technical support for issues related to BY Supply Planning, with a focus on continuous improvement.Provide subject matter expertise in Oracle Cloud infrastructure related to the BY platform and assist with platform scalability and performance tuning.Document and maintain clear records of development activities, designs, and technical specifications.Stay updated with the latest developments in Oracle PL/SQL and BY Supply Planning platforms to provide innovative solutions and ensure best practices are followed.