Mahesh Rekapalli

Data Analyst with 2 years of experience in data analytics, combining technical expertise in SQL, Python (Pandas, NUMPY), Power BI, and Advanced Excel (Power Query) with a solid foundation in business strategy. Completed a Master’s in International Business Management, enhancing both analytical and business decision-making skills. Proficient in data cleaning, ETL, EDA, KPI dashboards, and data visualization across large datasets in healthcare and e-commerce domains. Strong background in customer segmentation, cost optimization, scenario-based analysis, and financial analytics. Adept at communicating insights to cross-functional teams and contributing to data-driven strategies in Agile environments using Jira.

U.S. Healthcare Cost & Demographic Analysis Project

• Analyzed large-scale U.S. healthcare data using MySQL, Excel, and Power BI, applying EDA and statistical methods.
• Cleaned and standardized datasets, addressing missing values and outliers for accurate analysis.
• Uncovered demographic trends ( hypertension in middle-aged males, diabetes in females).
• Performed cost optimization and resource planning analyses to identify high-cost groups and improve operational efficiency.
• Built interactive dashboards to present insights for executive-level decision-making.

• Analyzed large e-commerce datasets (customers, orders, products) using MySQL, Excel, and Python.
• Performed data cleaning, EDA, and built Power BI dashboards to track sales, inventory, and customer behavior.
• Contributed to a 15% increase in sales by uncovering data-driven strategies through trend analysis and automation.

• Collaborated with data engineers to define and test data validation rules across multiple sources.
• Conducted data quality checks and created validation scenarios to ensure accurate reporting.
• Streamlined data comparison workflows, saving 2 hours daily, and supported ETL integrity.

Data Analytics Certification – Coding Ninjas