Mallemula Prachethan
Business Analyst
About
No bio added yet
Skills & Expertise (15)
Work Experience
Business Analyst
Right Milk
Feb 2026 - Present
Defined and tracked key business metrics, including order fulfilment rate, sales velocity, and logistics. Developed automated Power BI dashboards to display real-time trends for expedited operational decision-making, reducing long manual hours and optimizing the whole process. Engineered a Python & SQL data pipeline to clean and restructure over 10,000 transactional records into analyst-ready formats, reducing manual data preparation time by nearly 40%. Converted business questions into data-driven analyses using SQL, Python, and Power BI, providing actionable insights on demand, operational performance, and business KPIs to aid in strategic decision-making. Evaluated customer demand, purchasing trends, and operational performance to uncover business opportunities, inventory risks, and supply bottlenecks. Utilized tools such as Claude, and Co-Pilots to enhance workflow efficiency.
Business Analyst Intern
Milky-Mist
Jan 2025 - Jul 2025
Collected primary data from 260 individuals through in-store surveys and secondary data using web scraping; cleaned and analyzed data to uncover trends in customer sentiment and behavior. Applied K-Means techniques to segment customers into distinct groups, to know their perspective and target each uniquely, and NLP techniques resulting in a positive sentiment score of +0.65. Transformed findings into a structured stakeholder presentation featuring data visualization charts and prioritized recommendations that directly informed product and marketing decisions.
Business Analyst Intern
Tata Communication Limited
May 2024 - Jul 2022
Developed and deployed an inbound campaign and monitored CTR, Reach, and Engagement metrics; identified underperforming content formats and recommended strategy adjustments that improved click-through rates by 17%. Identified audience gaps and built targeted content campaigns that grew online reach by 23% and generated 50+ qualified leads, directly contributing to the sales pipeline. Designed and executed a LinkedIn campaign strategy for a regional advocacy program, tracking engagement metrics week-on-week to optimize content achieving 33% engagement growth and 1,000 new followers in 3 months.
Education
Bachelor in Business Analytics - PES University
2022 - 2026 · Afghanistan
Class 12, MPC - Sri Chaitanya junior college
2020 - 2022 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
Skills (15)
Click a skill to find developers with the same skill
