GOUTHAM REDDY
Hyderabad
Summary
Analytical and insightful Data Analyst known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.
Overview
6
6
years of professional experience
Work History
Data Analyst
Google Operations Center
01.2025 - Current
- Set up automated end-to-end data pipeline with PLX scripts in Tangle to pull scheduled Google Ads data for Looker Studio dashboards, keeping reports current and saving 30 hours per week.
- Built store sales dashboard using Google Ads data to show weekly cost, store visits, store sales, and cost per store visit; automated process and saved team 134 hours per quarter.
- Analyzed Google Ads campaign performance across Search, Display, Video, Demand Gen, and Performance Max by monitoring CPC, CTR, cost, conversions, impressions, views, and ROAS to enhance campaign efficiency and ROI.
- Developed dashboard in Google Sheets to track MMM team tasks and metrics, including task volume, delivery timelines, regional TAT status, agent performance, and monthly trends, reducing manual reporting and saving 8 hours per quarter.
Data Analyst
Nxtwave
12.2022 - 01.2025
- As a Data Analyst in the Retention team, I played a vital role in driving customer retention and engagement strategies through data analysis. Working closely with Product Managers, I leverage my analytical skills and expertise to extract valuable insights, facilitate data-driven decision-making.
- Increased DAU by 3% by analyzing the users learning data using SQL and Looker Studio and suggesting product managers launch features which motivate users to come back daily and learn consistently.
- Developed key metrics dashboard to track daily KPIs including DAU, WAU, MAU, power users, churn rate, rolling retention, feature feedback, cohort analysis, and A/B testing.
- Analyzed gamification feature, revealing a significant increase in user engagement and learning during first 3 weeks post-launch, identifying areas for sustained improvement.
- Developed a predictive model using python to predict whether user will take a refund or not based based on user learning stats which helped in taking proactive actions for the users who are going to take refund by keeping them engaged thus decreasing the refund rate.
- Documented dashboard processes using Gmail API and OpenAI key, empowering stakeholders to independently access analytics.
Junior executive operations
Sudarshan Chemical Industries Limited
09.2020 - 11.2022
- Designed Excel dashboards to track yearly and monthly savings by product and business unit, enabling leadership to review performance against targets monthly
- Automated daily utility (water, steam, ice, power) tracking dashboards using Excel Power Query, transforming raw data into actionable insights and reducing manual effort by 30 hours per month
- Developed process order summarization report comparing actual vs. target raw material usage against Bill of Materials (BOM), facilitating root-cause analysis and corrective actions for variances
Education
BE/B.Tech/BS - Chemical Enginerring
VNIT
NAGPUR01-2020
Skills
- Languages & Databases: SQL, Python, BigQuery
- Visualization & BI Tools: Excel, Looker Studio, Metabase, Ad Performance Analysis, Dashboard Development, Metrics tracking, KPI Reporting, BI reporting, SQL querying
- Product & Growth Analytics: A/B Testing, Product Analysis, Statistics, Retention Analysis, Cohort Analysis, Data storytelling
- Analytics Programming & Libraries: Pandas, Data Visualization, Data Cleaning, Exploratory analysis, Predictive analytics, Workflow Automation, DBT, NumPy
Projects
Aerofit Case Study, Identified target audience characteristics to enhance customer recommendations, resulting in a 15% increase in personalized product suggestions.
Timeline
Data Analyst
Google Operations Center
01.2025 - Current
Data Analyst
Nxtwave
12.2022 - 01.2025
Junior executive operations
Sudarshan Chemical Industries Limited
09.2020 - 11.2022
BE/B.Tech/BS - Chemical Enginerring
VNIT