Lochan Kumar

I’m a detail-oriented Data Analyst who loves turning messy, large datasets into clear, actionable insights. I combine strong expertise in SQL, Microsoft Power BI, Python, and Machine Learning with a problem-solving mindset built in fast-paced environments.

Before analytics-focused work, I worked as a Trainee Test Engineer at Pole To Win (PTW). I tested 10+ AAA and mobile games, documented 200+ bugs with advanced tracking tools, and contributed to a 15% reduction in post-release issues—while collaborating closely with cross-functional QA teams and helping shape test cases based on user behavior and gameplay data.

In projects, I’ve applied SQL and Power BI to deliver business-ready dashboards and analysis—like leading Retail Sales Analysis on 100,000+ transactions and identifying trends that supported a proposed 10% optimization of product placements. I also built predictive and recommendation systems in Python, including calorie prediction (feature engineering with R² up to 0.9878) and a Netflix content recommender using TF-IDF and Cosine Similarity to rank top matches from a text-based input.