Vinyasa Kottapally Email & Phone Number

Troy, Michigan, United States

Michigan, United States

• Launched and managed a successful e-commerce business, specializing in luxury clothing and handmade jewelry, leveraging Instagram and Shopify to reach over 200K users.
• Gathered and integrated customer data from multiple sources, assessed the data for data quality and consistency by performing data audits and validation checks.
• Conducted detailed sales data (incremental sales, net profit) and social media engagement data analysis to identify trends, patterns and anomalies.
• Conducted customer analytics, including customer profiling and ad hoc exploratory analyses, for personalized marketing strategies, optimized inventory management, and resulted in a 50% increase in revenue in 2022.
• Conducted A/B tests to optimize marketing strategies, product offerings and performed hypothesis testing on website layouts impacting average order value to make informed decision on implementing new layouts.
• Generated insights to address key business challenges and reports, dashboards for clear business consumption insights that supported sales and business performance.

Ann Arbor, Michigan, United States

• Worked closely with stakeholders (University of Michigan Information and Technology Services) to identify analytic needs, focusing on understanding key business challenges and answering critical business questions.
• Conducted in-depth analysis of event log data from the Learning Management System (LMS - Canvas), delivering insights into student navigation patterns, identifying trends, popular pathways, and drop-off points.
• Extracted and manipulated over 10 million data points from Google Big Query (GCP) using SQL, ensuring data quality through cleaning and transformation processes, while automating workflows for efficient analysis.
• Developed a custom algorithm utilizing python programming to transform the data for visualizing user flow on LMS.
• Created detailed visualizations and interactive dashboards using Tableau, providing a comprehensive overview of user behavior and faculty module design.
• Illustrated student navigational patterns and user engagement metrics with Sankey diagrams using Power BI, offering clear insights into user flow and engagement across different modules.

Hyderabad Area, India

• Supervised team’s performance by auditing resolved ticket samples to achieve 98% process accuracy.
• Developed and maintained end to end workflows in Visio to integrate data from various in-house sources, Oracle and MYSQL databases for data storage, structuring, and management of over 2 million records in data.
• Executed intricate SQL queries, nested subqueries, aggregation, and window functions to optimize data processing.
• Designed Dynamic visualizations,dashboards and Ad Hoc reports with Tableau to facilitate efficient diagnosis of metrics including team utilization, turnaround time and accuracy.
• Collaborate with cross-functional teams to communicate process performance insights to Non- Technical Stakeholders.
• Led initiatives to optimize operational efficiency utilizing Pareto charts and root cause analysis which resulted in a 25% reduction in ticket resolution time in 2016 and 18% continuous improvement in team performance.

Hyderabad, Telangana, India

Hyderabad Area, India

• Worked closely with Top 15 FMCG Advertisers in Asia Pacific region for YouTube Advertising Campaigns Analytics.
• Coordinated with the Campaign Managers team and Advertisers for technical requirements elicitation and review, ensuring alignment with project plans and stakeholder expectations.
• Utilized Google Marketing Platform,Google Analytics and Excel for data collection, analysis, and monitoring, generating insights through dynamic dashboards and charts for optimization of campaign delivery strategies.
• Provided actionable insights into user engagement of campaigns and contributing to a 7% - 15% boost in ad engagement.
• Developed Ad-hoc reports for critical metrics analysis, providing stakeholders with actionable insights for decision-making.

Master'S Degree, Data Science

Bachelor'S Degree, Electrical, Electronics And Communications Engineering

Master'S Degree, Data Science