Mahendra Kumar Ponnapalli

A Seasoned Data Analyst with over two years of industry experience, specializing in data cleaning, transformation, visualization, and ETL pipelines. Proficient in Excel, including advanced functions like VLOOKUP, pivot tables, and macros, for data analysis and report creation. Experience in developing dashboards using Excel, Tableau, and PowerBI to visualize key performance indicators (KPIs) and support data-driven decision-making. Demonstrated proficiency in writing and executing SQL queries using MySQL Workbench and SQL Server Management Studio for data extraction and manipulation.

With expertise in Python programming, this analyst leverages libraries such as NumPy and Pandas for data manipulation and visualization. Certified in AWS cloud platforms, they have experience translating business requirements into technical specifications, working with cross-functional teams, and presenting analytical insights to both technical and non-technical stakeholders. Their strong time management and communication skills enable them to manage multiple projects, meet deadlines, and provide actionable insights.

I have over three years of experience as a Data Analyst, specializing in data cleaning, transformation, visualization, and ETL pipelines. At Tetra Computing LLC, I leveraged MS SQL, Python, and Power BI to develop interactive dashboards, optimize SQL queries, and implement Azure-based data workflows for large-scale analytics. Prior to that, at Sodexo (UMKC), I utilized Excel, MySQL, and Power BI to enhance customer retention, track key performance indicators (KPIs), and provide actionable insights through dynamic reporting. During my internship at Kutumbh, I worked with MS SQL, Excel, and Tableau, creating dashboards and automating data processes to support strategic decision-making. My expertise spans SQL, Python, Power BI, Tableau, Azure, and Excel, enabling me to drive data-driven business solutions effectively.

I completed my Bachelor of Science in Computer Science from the University of Missouri – Kansas City (UMKC) between July 2019 and May 2024, achieving a CGPA of 3.65. Throughout my studies, I built a strong foundation in computer science, focusing on software development, data structures, algorithms, and database management. Additionally, I worked on projects involving data analytics, cloud computing, and automation, enhancing my technical and problem-solving skills. Prior to that, I completed my Secondary School of Education at Sasi Educational Institute in Andhra Pradesh, India, from June 2017 to May 2019, with a perfect CGPA of 10.0. My coursework emphasized mathematics, science, and logical reasoning, providing me with a solid academic background that laid the groundwork for my higher education in computer science.