Roshan Kumar Uttam

I am a Data Engineer with around 4 years of experience in data validation, analytics, and automated reporting. Skilled in Python, SQL, PySpark, Databricks, and Microsoft Azure, I specialize in building ETL pipelines, data warehouses, and dashboards that turn raw data into actionable insights. I have worked on both structured and unstructured data, optimized workflows, and delivered solutions that improved business growth and efficiency.

My projects include developing SQL-based data warehouses and implementing Azure Data Factory pipelines using the Medallion Architecture. With a strong problem-solving mindset and a passion for scalable data solutions, I aim to help organizations drive smarter, data-driven decisions.

RR Traders — Business Data Analyst

Sep 2024 – Aug 2025

• Orchestrated end-to-end management of the company’s Meesho e-commerce operations, boosting monthly sales from 50,000 to over 4,15,000 within just six weeks.
• Conducted detailed e-commerce sales analysis using Python (Pandas, NumPy, Matplotlib) to clean, transform, and merge datasets, and built interactive dashboards and visual reports to track revenue growth, product demand, and seasonal trends.
• Performed competitor benchmarking and customer behavior analysis, leveraging data insights to optimize product positioning and pricing strategies.
• Coordinated end-to-end project workflows, including task allocation, progress tracking, and structured documentation.
• Supervised and mentored a team, ensuring alignment with client requirements, fostering collaboration, and maintaining adherence to quality benchmarks.

Scorium Learning — Project Associate

Oct 2022 – Aug 2024

• Conducted rigorous data validation and quality assurance of AI-generated outputs, ensuring reliability and consistency across deliverables.
• Automated and generated performance analytics reports, providing insights into accuracy, efficiency, and productivity trends.
• Streamlined reporting pipelines and review mechanisms, significantly reducing turnaround time and enhancing operational throughput
• Designed and automated weekly and monthly sales reports using Python, reducing manual reporting effort and enabling faster decision-making.
• Collaborated with leadership to translate analytical findings into data-driven strategies for promotions, product placement, and inventory planning.
• Applied ETL pipelines, data warehousing, and data modeling practices to streamline reporting, automation, and cloud-based workflows.