Rakesh kumar sahoo

Data Analyst Intern

AWS Solutions (Formerly ALA Pvt. Ltd.)

Dec 2025 - May 2026

Executed end-to-end data extraction, cleansing, transformation, and validation activities on large-scale retail merchandising datasets by integrating multiple data sources, ensured high data integrity while supporting weekly, quarterly, and seasonal business reporting requirements. Engineered interactive Power BI dashboards and executive scorecards to monitor merchandising KPIs including SCO, Style Efficiency, inventory health, category performance, and execution metrics, enabled business leaders and field teams to make informed, data-driven decisions. Performed advanced analytical assessments using SQL, Python (Pandas, NumPy), and statistical techniques to identify business trends, conduct root cause investigations, evaluate merchandising performance & uncover opportunities for assortment optimization and space utilization improvements. Collaborated with regional and global merchandising stakeholders to translate business objectives into analytical reporting solutions, while driving reporting process optimization and partial workflow automation that enhanced reporting efficiency, consistency, and data quality. Analyzed datasets exceeding 1 million records using SQL and Python, resolved 20+ data quality issues, achieved 99% reporting accuracy, and generated actionable insights supporting merchandising execution, category planning, and strategic business performance.