SUMANTH KOLLIMARLA

Passionate about data analytics with a degree in COMPUTER SCIENCE. Seeking opportunities where I can utilize my analytical and technical skills to solve real life data analytics problems.

Zomato Restaurant:- 

• Data Analysis, Downloaded restaurant data from zomato website for more than 10000 restaurants across india. Ingested this data in MySQL database and performed ETL to remove outliers, clean up bad records, normalize revenue numbers to standard format using python, jupyter notebook and two standard deviation along with some other statistical techniques.
• For analysis of ahmedabad restaurants, used Excel, VBA macros and pivot table. Figured out best restaurants for punjabi and south indian cuisine based on reviews.
• Used Power Bi to build various BI dashboards that can show revenue growth in different restaurants based on cuisine, how people's preferences have changed over a period of 5 years.
• Prepared a data story and presented that in our annual data analytics festo.

 Business Insights 360 - Data Analyst Student At Codebasics

• Learned how data transparency is brought to big organizations enabling users to make data informed decisions.
• Connected Power BI with MySQL, Excel to import ~4 million records. Performed data transformation in Power Query.
• Built a dashboard in Power BI from scratch for finance, sales, marketing, supply chain and executives which will support the organization in gross margin improvement.
• Learnt project management skills: Project charter (using Mural), stakeholder mapping analysis, Kanban board for task assignment to improve productivity.