About

Rohan Patra is a Lead Data Analyst in Product Analytics at Airtel, with over 4 years of experience in solving complex business problems for companies in various sectors such as automotive, FMCG, and telecommunications. He is proficient in core skills such as Python, SQL, PySpark, Excel, and reporting tools such as Power BI and Tableau. Rohan is an enthusiastic team player with a knack for solving problems with proactive client engagement with the help of predictive, descriptive, and prescriptive analytics. In the past, Rohan has worked as a Senior Data Analyst at Airtel and as a Trainee Decision Scientist at Mu Sigma. He has worked with a Fortune 10 automobile giant, where he helped them solve various business and engineering problems. Rohan created a closed-loop learning framework using NLP, where he created a system to churn out learnings from historical issues in terms of design criteria and assessment. He also extracted meaningful information from unstructured textual data using NLP techniques like TF-IDF and then classified them using random forest. Rohan has also collaborated with clients to understand the complexity associated with stacking numerous incentives available in the market for pushing sales of vehicles and leveraged historical sales data to perform distribution analysis and showcased the top tactics driving the maximum sales. Rohan has also worked with a Fortune 100 confectionary giant to solve their business problems around supply chain management. He identified accurate data assets as per business KPIs and designed a well-performing architectural structure of having an automated extraction process. Rohan created a production-ready dashboard capturing the relevant KPIs for gauging the supply planning process, which helped in driving CSP meetings held on a periodic basis and provided the client additional insights on their company's performance in terms of various service levels such as cost and cash. Rohan holds a Bachelor of Technology in Mechanical Engineering from KIIT University. His tech stack includes SQL, Python, NLP, Research Scientist, and Random Forest. With 4.03 years of relevant experience, Rohan is a skilled professional who can help companies solve complex business problems with his expertise in analytics and data-driven insights.