Pranav Mekala

As a volunteer for STL Startup Week, I was responsible for ensuring a smooth experience for attendees by managing registration check-ins, overseeing event logistics, and promptly resolving on-site issues. I also coordinated with teams to monitor food arrangements and maintain an organized flow throughout the event. This role required strong attention to detail, quick problem-solving, and excellent communication to keep everything running seamlessly.

Actively contributed to the planning and execution of bi-weekly networking events and monthly large-scale gatherings, aimed at enhancing student exposure to marketing trends and professional connections. Participated in multiple events and provided hands-on support during organizational activities, helping foster a collaborative and professionally enriching environment.

Led initiatives to bridge academic learning with real-world business insights. Organized a Discussion Panel on Emerging AI Technologies, featuring a guest speaker from Edward Jones, and facilitated interactive sessions for students.

Represented Indian heritage through Sangam, a cultural organization, as Joint Social Media Director. Spearheaded digital outreach and event promotion for major Indian festivals including Holi, Vinayaka Chavithi, Navratri, Diwali, and an annual DJ Night, fostering cross-cultural engagement and community spirit on campus. Promoted cultural diversity and unity by curating vibrant celebrations that showcased traditional attire, music, dance, and cuisine.

Analyzed large-scale user and product datasets using SQL(BigQuery) and Excel, handling datasets exceeding 100M+ records. Built dynamic dashboards using Power BI and DAX to track KPIs such as user engagement, retention, and feature performance. Designed and analyzed A/B experiments, providing actionable insights to improve product features. Partnered with product managers and engineering teams to define metrics and drive data-informed decisions. Optimized SQL queries and workflows, improving data processing efficiency and reducing compute costs. Utilized Azure and basic Databricks workflows for data transformation and scalable analytics.

Analyzed internal supply chain and operational data using SQL, Excel, and Power BI to support inventory and logistics decisions. Built predictive models in Python for demand forecasting and inventory optimization. Developed executive dashboards using Power BI(DAX) to monitor KPIs such as inventory turnover, demand variability, and service levels. Integrated and transformed large datasets using Azure and Databricks(basic) for scalable analytics. Conducted root cause analysis to identify inefficiencies in procurement and distribution processes. Collaborated with internal stakeholders, including supply chain, procurement, and operations teams.

Led end-to-end analytics and reporting solutions using SQL Server, Power BI, DAX, and Excel for global clients, including Unilever and Coca-Cola. Designed and developed KPI dashboards for sales performance, customer segmentation, and campaign analytics. Built and maintained data pipelines using SQL Server and Azure Data Factory, ensuring reliable data flow. Conducted A/B testing and cohort analysis to support marketing and business strategies. Worked closely with client stakeholders to gather requirements and deliver actionable insights. Mentored junior analysts and improved team delivery quality.

Supported analytics projects for a leading retail client, Walmart, using SQL Server and Excel for data extraction and analysis. Developed interactive dashboards in Power BI, tracking KPIs such as sales trends, revenue, and inventory performance. Performed data cleaning, validation, and transformation to ensure high-quality reporting datasets. Automated recurring reports using Excel and DAX, reducing manual reporting efforts. Assisted stakeholders with ad-hoc analysis and business reporting needs.