Rajesh Kumar Behera

Lead Supply Chain Analytics professional with 10+ years of experience in Supply Chain Analytics, Business Intelligence, and Data Transformation, with expertise in Power BI, SQL, Python, and Snowflake. At Hudson's Bay Services Pvt Ltd, developed BI dashboards and automated data pipelines, reducing stockouts by 20%, improving inventory turnover by 22%, and delivering $2M in annual cost savings through advanced analytics and process automation.

At Tesco Bengaluru

Pvt. Ltd., optimized SQL workflows and automated reporting systems, reducing manual effort by 90%+, improving data accuracy by 40%, and enabling faster decision-making through scalable BI and data engineering solutions.

Lead Supply Chain Analytics at Hudson's Bay Services Pvt Ltd (2025-04 – 2026-02)

Led analytics initiatives and developed automation solutions for supply chain optimization

• Developed an automated web analytics tool using Python Scripting and AppScript, replacing manual processes and a third-party platform to save $2M annually; enhanced inventory accuracy via real-time dashboards and exception reporting.
• Led cross-functional teams of 30+ stakeholders, optimizing workflows and project delivery for 35+ complex, data-intensive initiatives over 1-year period, resulting in a 40% reduction in project completion time and a 50% improvement in data accuracy.
• Developed a custom Power BI dashboard by integrating data from 4 systems, reducing stockouts by 20% and increasing inventory turnover by 15% through stakeholder collaboration and data pipeline management.
• Resolved slow query challenges by optimizing Snowflake data models and SQL queries, boosting performance by 50%; automated legacy reporting with Python ETL from VBA, cutting generation time by 90% and inventory stockouts by 5%.
• Built self-service Tableau dashboards and standardized data models to break down data silos between teams, reducing ad-hoc reporting requests by 60%.

Senior Analyst Supply Chain Analytics at Hudson's Bay Services Pvt Ltd (2022-05 – 2025-03)

Led cross-functional analytics initiatives and automated inventory reporting processes

• Led cross-functional analytics initiatives with Finance and operations teams to deliver enterprise solutions, overcoming siloed insights and improving decision-making across departments.
• Automated daily, weekly and monthly inventory reporting by developing VBA macros, reducing process time by 90% and saving 36 hours of analyst effort per month.
• Developed a VBA tool to automate supply chain disruption analysis, reducing scenario planning time from days to minutes and enabling proactive contingency planning.
• Automated data consolidation from disparate ERP/WMS systems, reducing weekly report generation from 2 days to 2 hours and eliminating 5 hours of monthly error correction using Advanced Excel (Power Query, Pivot Tables).

Senior Associate - MIS Reporting at Tesco Bengaluru Pvt. Ltd. (2019-11 – 2022-05)

Automated reporting systems and managed data pipelines for enterprise insights

• Automated manual daily, weekly, and monthly reports using Alteryx, Excel, and VBA, saving 1040 hours annually and enhancing accuracy.
• Automated time-consuming ad hoc reporting by developing an all-in-one VBA macro, enabling end-users to self-serve and eliminating report request delays.
• Executed 5+ disparate data sources into a single SQL Server database using SSIS, decreasing data retrieval time by 50% and boosting project efficiency by 20%.
• Automated data pipelines using SQL and VBA, reducing manual reporting by 90% and enabling near real-time insights, which accelerated leadership decision-making.
• Standardized KPI definitions by establishing data dictionary governance frameworks, resolving inconsistent metrics across teams and improving data consistency in enterprise reporting.
• Delivered daily and weekly database reports, completing 100% of internal quality checks on time for over 100 stakeholders using Excel.
• Supported and Coordinated Buying Admin team by verifying and ensuring accurate loading of pricing and promotion data for 5+ categories using Excel, reducing data entry errors by 50% and saving an estimated £100K in potential revenue loss.
• Streamlined Data Reporting by developing SOPs for 90+ reports, enhancing data accuracy by 40%.
• Managed 100+ ad hoc data requests quarterly, delivering critical business insights to 15 departments through efficient SQL query execution and stakeholder communication.

Data Analyst at Tesco Bengaluru Pvt. Ltd. (2017-04 – 2019-10)

Resolved supplier queries and managed data reporting for corporate teams

• Resolved an average of 10 + supplier queries daily regarding GBP and non-GBP post-debit payments via Zendesk tickets, ensuring timely resolution and minimizing payment discrepancies.
• Resolved 100 daily supplier queries via KANA, improving response time by 30% and maintaining 75% customer satisfaction over 12 months; utilized Data Reporting to track performance.

Officer Customer Operations at Tesco Bengaluru Pvt. Ltd. (2013-09 – 2017-03)

Enhanced report generation and financial analysis for corporate teams

• Enhanced report generation for 100+ corporate credit professionals by optimizing financial statement analysis for public companies, increasing efficiency by 30%.

Junior Executive Customer Support at Genisys Information Systems India Pvt. Ltd. (2012-05 – 2013-04)

Provided customer support services

Bachelors of Technology – Biju Patnaik University of Technology Odisha (2006-08 – 2010-07)