Somya Vats Email & Phone Number

Noida, Up, In

Noida, Uttar Pradesh, India

1.Derived actionable insights using BigQuery to refine the Subscription Model of GaanaApp using Conversion Funnels. Evaluated 400+ product Id’s and business-specific KPIs (Renewals, churn rate,NetAdds etc) Trends.Utilized complex SQL logics converted to Automated Google SpreadSheet Reports and Real Time Looker Studio dashboard for customer growth 2.Enhanced the Top Charts logic for song selection based on search, popularity, and age, and enriched user experience with curated playlists using… Show more 1.Derived actionable insights using BigQuery to refine the Subscription Model of GaanaApp using Conversion Funnels. Evaluated 400+ product Id’s and business-specific KPIs (Renewals, churn rate,NetAdds etc) Trends.Utilized complex SQL logics converted to Automated Google SpreadSheet Reports and Real Time Looker Studio dashboard for customer growth 2.Enhanced the Top Charts logic for song selection based on search, popularity, and age, and enriched user experience with curated playlists using the Index Ranking System, facilitating daily frontend release updates for 15+ Languages.3.Identified gaps in Auto-renewal processes for different payment gateways for new purchases and renewals, presenting insights that led to improved subscription conversion rates by 35% and contributed directly to revenue growth.4.Implemented Primary Payments Dashboard on Looker Studio Dashboard to track Day0 to Day30 transactions revenue trends over time, success and failure rates across different payment instruments and gateways.HighlightedMonitored reasons for failure rates across gateways to track real time dips on Day to Day Basis.5.Collaborated with Cross-functional teams and stakeholders (Product, Content, Growth, Partnership, Digital Marketing) to deliver DataDriven Insights tailored to Business requirements and Board meetings for StoryTelling.6.Led an A/B tests and experiments on the Onboarding page, which resulted in a 20% increase in onboarding completion rates, user Signup conversions upgraded from 15% to 25%, representing a 66.7% increase rate with dropping bounce. 7.Developed and Automated Data Engineering Pipeline Design for a centralized Google Cloud Platform data lake(Big Query), sourcing data from MySQL servers, Google Analytics, and third-party APIs using Python Scripting. Show less

Bengaluru, Karnataka, India

1.Automated & Designed ETL Data Pipelines for smooth Data flow required for WBRs, MBRs and Key Business Metrics.2.Collaborated with Project Managers,Clients and Stakeholders to understand Business Requirements and accordingly converted 15+ Manually Generated Reports to Automation saving headcount of up to 1.2 and bandwidth of 5 hours/week.3.Led the Design and Implementation of Real-time Business Intelligence Dashboards using Quicksight providing actionable insights that reduced Merchant… Show more 1.Automated & Designed ETL Data Pipelines for smooth Data flow required for WBRs, MBRs and Key Business Metrics.2.Collaborated with Project Managers,Clients and Stakeholders to understand Business Requirements and accordingly converted 15+ Manually Generated Reports to Automation saving headcount of up to 1.2 and bandwidth of 5 hours/week.3.Led the Design and Implementation of Real-time Business Intelligence Dashboards using Quicksight providing actionable insights that reduced Merchant Order Cancellation rate to 2.5 % from 6.7-8% basis on PreandPost cancellations and boosted OnTimeDeliveries metrics by 2.7% which also impacted Profit Margins and Customer satisfaction Levels.4.Leveraged time series analysis, automation, and data wrangling to transform large, complex datasets into strategic insights, predicting outcomes.Crafted compelling storylines driving customer business objectives and informed client decisions.5.Conducted SQL sessions for the Business team which helped them being self-sufficient to understand and modify Minor SQL queries without being dependent on BI team. Show less

Hyderabad, Telangana, India