Ravikumar Chennupati Email & Phone Number

Albany, NY, US

Dallas, Texas, United States

• Responsible for providing data analysis that focused on improving user experience and optimizing user retention.
• Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions and common table expressions to track user activity metrics such as retention rate and daily active user. Optimized existing queries.
• Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.
• Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift.
• Spotted and analyze trends in user activity data, identify underperformed user segmentation report insight to stakeholders.
• Designed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results, interpret and give recommendations to stakeholders.

Austin, Texas, United States

• Developed a customer churn prediction model using Python, achieving an 84% accuracy rate with logistic regression, SVM, Decision Trees, and Naïve Bayes algorithms.
• Managed, updated, and manipulated report structures using advanced Excel functions such as Pivot Tables and V-Lookups.
• Utilized DAX functions to create measures and calculated fields for logical data visualization and used Power Query to transform data.
• Implemented Tableau for visualizations including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, and reference lines.
• Created T-SQL Stored Procedures, User-Defined Functions, Indexes, Views, and Triggers; wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived Tables, and Common Table Expressions (CTEs).
• Experienced in an Agile environment, participating in daily standups, weekly sprints, backlog grooming, and defining test scenarios and strategies.

Noida, Uttar Pradesh, India

• Participated in various stages of data handling, including collection, cleaning, and preprocessing, to facilitate analysis and modeling endeavors.
• Performed statistical analysis and hypothesis testing to assess business performance and pinpoint potential areas for enhancement. Engineered Python scripts to automate data processing operations, enhancing overall.
• Contributed to crafting and executing data visualization dashboards using Power BI for internal reporting objectives.
• Aided in crafting presentations and reports that encapsulated critical insights and recommendations derived from data analysis initiatives.
• Communicated key findings from data to multiple stakeholders to facilitate data-driven decisions using tools MS PowerPoint Tableau and Jupyter Notebook.
• Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and NumPy.

Master'S Degree, Computer Science, 3.6

Activities and Societies: AI workshop, voluntary services Texas Tech University is a public research university in Lubbock, Texas..

Bachelor'S Degree, Computer Science, 3.7

Activities and Societies: Student organizations, cricket, badminton, voluntary services Lovely Professional University (LPU) is a private.