Business Analyst Intern

SAI CHARAN REDDY METHUKU

+1-413-***-**** ****************@*****.*** www.linkedin.com/in/charan-methuku Education

University of Massachusetts Amherst, MA

Master of Science in Business Analytics(GPA: 4.0) Jan 2024 – May 2025

• Relevant coursework : Datascience, Applications of Artificial Intelligence(AI) for Business, Statistics and Machine Learning, Project Management, Business Intelligence and Analytics, Marketing Strategy. Mahatma Gandhi Institute of Technology Hyderabad, India Bachelor of Technology in Mechatronics Engineering Aug 2018 – July 2022 Experience

Business Analyst Intern May 2023 – Dec 2023

Wild Thirsty Farmer Pvt. Ltd Hyderabad, India

• Enhanced marketing strategy through market trend analysis, boosting lead conversion rates by 15%.

• Conducted data cleaning and analysis, reducing processing time by 40% using advanced Excel techniques, SQL.

• Developed interactive dashboards in Power BI, leading to a 25% improvement in stakeholder decision-making. Professional Freelancer Nov 2022 – April 2023

Singularium Technologies Bengaluru, India

• Managed customer invoicing, reducing invoice errors by 15% through process enhancements.

• Resolved discrepancies, improving client satisfaction and retention by 10%.

• Implemented a tracking system to monitor performance metrics, leading to faster issue resolution. Business Analyst Intern Sep 2022 – Nov 2022

Abhyaz Chennai, India

• Automated data scraping using Power Query, cutting down processing time by 40%.

• Utilized pivot tables and Excel functions to create decision-support dashboards, leading to a 15% increase in operational efficiency.

• Conducted in-depth trend analysis on historical data, enabling more accurate forecasting and improving business strategy alignment by 10%.

Projects

Sales Report Power BI

• Developed an interactive dashboard by automating filters and slicers, enabling users to drill down into specific data points for enhanced decision-making and detailed insights.

• Utilized a variety of visualizations to present complex data in a user-friendly format, improving the clarity of trends and patterns for stakeholders.

USA Accidents Analysis Python, Pandas, Numpy, Seaborn

• Processed and analyzed accidents data using Python (pandas, NumPy, seaborn) to clean, manipulate, and visualize datasets, uncovering key accident patterns, locations, and contributing factors.

• Developed heatmaps, time-series graphs, and distribution plots, revealing trends in accident frequency and severity, leading to data-driven safety recommendations while optimizing workflows to reduce computation time by 30%. Marketing Mix Modeling for Maximizing ROI Python, Pandas, Numpy, Scikit-Learn, Seaborn

• Developed and deployed a Bayesian Regression-based Marketing Mix Model (MMM) with 90% R and 10% MAPE, identifying inefficiencies in channels like Discovery Plus Video Spend and recommending a 20–30% budget reallocation to high-impact platforms (Facebook Remarketing, Google Brand Search) to optimize ROI.

• Analyzed customer trends (37% new vs. 63% returning buyers) and seasonal peaks (summer, holidays) to refine targeted marketing strategies, while applying the Hill-Adstock transformation to model advertising lag and diminishing returns, improving predictive accuracy and model performance. Technical Skills and Certifications

Languages: Python, C, SQL, R Libraries: pandas, NumPy, Seaborn, Scikit-learn Tools: MS Excel, Power BI, Tableau Certifications: Data Descriptors, Statistical Distributions, and Application to Business Decisions; Linear Regression for Business Statistics; Business Applications of Hypothesis Testing and Confidence Interval Estimation

Contact this candidate