Ravali Tatikonda

Data Analyst
Hyderabad, IN.

About

Results-driven Data Analyst with practical experience in SQL, Excel, and Python, gained through impactful internships focused on real-world data challenges. Adept at transforming complex datasets into actionable business insights and developing insightful dashboards. Passionate about leveraging data visualization, cleaning, and statistical analysis to solve critical business problems and drive informed decision-making.

Work

Future Interns
|

Social Media Trends Analysis

Hyderabad, Telangana, India

Summary

Conducted in-depth social media analysis at Future Interns, leveraging Python to identify trends, classify content performance, and deliver strategic insights.

Highlights

Analyzed over 5,000 social media posts using Python to extract key trend and engagement insights, informing content strategy.

Classified content performance based on view metrics, accurately identifying high-impact content for optimization.

Identified top-performing content types and analyzed audience sentiment, providing actionable recommendations for content creation.

Delivered comprehensive insights through clear visual summaries, facilitating strategic decision-making and content planning.

Coding Ninjas
|

Retail Analytics

Hyderabad, Telangana, India

Summary

Directed comprehensive retail data analysis at Coding Ninjas, enhancing data accuracy and extracting key insights to inform strategic marketing and inventory decisions.

Highlights

Streamlined data preprocessing by performing deduplication, handling missing values, and correcting inconsistent pricing, ensuring 100% data accuracy for analysis.

Utilized SQL to extract key insights on sales behavior, product categories, and customer segments, informing targeted marketing strategies.

Identified high and low-performing products and analyzed customer loyalty indicators to optimize product portfolios and enhance customer retention.

Calculated critical retail metrics including purchase frequency, repeat purchases, and sales growth trends, providing a robust evaluation of performance.

Presented actionable findings to support strategic decisions in marketing and inventory planning, contributing to improved business outcomes.

Coding Ninjas
|

CPI Inflation Analysis

Hyderabad, Telangana, India

Summary

Led data analysis for CPI trends at Coding Ninjas, providing crucial economic insights through detailed comparisons and impact assessments.

Highlights

Analyzed CPI data spanning 2017-2023 to identify and report key urban/rural inflation trends, enhancing economic understanding.

Executed comprehensive Year-on-Year and Month-on-Month inflation comparisons using Excel, revealing critical shifts in economic indicators.

Assessed the impact of macro-economic factors, including crude oil prices and COVID-19, on inflation, providing deeper contextual insights.

Developed clear and impactful visual charts to effectively communicate complex economic insights to stakeholders.

Education

Government City College (Osmania University)
Hyderabad, Telangana, India

M.Sc.

Biotechnology

Grade: CGPA: 7.6

Loyola Degree & PG College, Alwal
Alwal, Telangana, India

B.Sc.

Biotechnology, Chemistry, Genetics

Grade: CGPA: 8.2

Languages

Telugu
Hindi
English

Certificates

Python for Data Analytics
SQL & Excel Hackathon

Skills

Data Analysis Tools

Excel, SQL, Power BI.

Programming Languages

Python.

Data Management & Analytics

Data Visualization, Data Cleaning, Statistical Analysis, Trend Analysis, KPI Reporting.