Hanish Kumar

Senior Solution Consultant with over 10 years of experience in architecting end-to-end system solutions. Subject Matter Expert (SME) and Certified Prompt Engineer leveraging GenAI, Python, and Oracle PL/SQL to drive digital transformation and program excellence in complex enterprise environments.

Lead Consultant - Supply Chain (Demand) at HCL Technologies (2023-11 – Present)

Lead end-to-end forecasting workflows and translate complex international business needs into robust technical architectures using GenAI and Oracle PL/SQL.

• Act as the primary SME to lead end-to-end forecasting workflows, translating complex international business needs into robust technical architectures
• Leveraged Certified Prompt Engineering to optimize Oracle PL/SQL procedures and shell scripts, reducing reporting effort by 40%
• Utilized Vibe Coding and Python to architect an automation suite for data validation and rapid prototyping of audit scripts
• Drive delivery excellence by ensuring defect-free implementation of custom workflows for seasonality and promotions

Senior Consultant - Supply Chain Planning at Capgemini (2022-10 – 2023-10)

Architected batch process enhancements and managed large-scale heritage data migrations while delivering end-to-end JDA solutions.

• Architected batch process enhancements and managed large-scale heritage data migrations with high integrity
• Delivered end-to-end JDA Demand and Fulfillment solutions, coordinating order synchronization across business units
• Mentored junior consultants on functional concepts and technical implementation best practices

Technical Consultant - Cloud Services at Blue Yonder (2020-10 – 2022-09)

Configured secure application integrations and provided high-level production support for global SCPO and reporting solutions.

• Configured secure application integrations (SSL, SSO, SAML) and resolved complex Azure-based deployment issues
• Provided high-level production support for global SCPO and reporting solutions

Associate Consultant at Virtusa Consulting Services (2020-05 – 2020-10)

Managed Oracle database migration and utilized agile development tools for version control.

• Managed Oracle DB migration (11g to 19c), optimizing scripts and replacing unsupported packages
• Utilized Git/Bitbucket and JIRA for agile development and version control

System Engineer at Tata Consultancy Services (2015-10 – 2020-03)

Developed high-performance Oracle PL/SQL solutions for banking ETL processes with significant performance optimization.

• Developed high-performance Oracle PL/SQL solutions for banking ETL processes
• Engineered automated data pivoting solutions for banking ETL processes, reducing runtime by 85% (from 40 to 5 minutes)

B.Tech in Computer Science Engineering – WBUT (2015)