Sai Srujan Vanama

About Sai Srujan Vanama

Marketing Data Analyst with 5 years of experience driving measurable growth through data…

Experience

1. Senior Data Analyst

   VIAVI Solutions

   Sep 2024 — Present

   Engineered the foundational data pipeline that became the backbone for all product analysis, unifying over 10 disparate data sources (Oracle, SQL Server, sensor logs) and establishing a single source of truth that cut the analytics team\'s data prep time by 30%.Architected the division\'s first centralized analytics platform, deploying 5+ executive Power BI dashboards that provided a unified view of manufacturing KPIs, reducing leadership\'s manual data analysis time by 40%.Engineered a library of 15+ reusable SQL scripts (MySQL, SQL Server) to automate data extraction for recurring supply chain and production analyses, reducing manual reporting hours by 40% and improving data delivery speed.Facilitated weekly requirements workshops with stakeholders, defining data-driven success criteria that ensured delivered dashboards achieved 95% alignment with executive and operational needs.Pioneered a new cross-functional Root Cause Analysis (RCA) methodology by correlating software error logs with hardware performance data, identifying critical failure points that influenced a product redesign projected to boost device reliability by 20%.Executed 20+ deep-dive analyses using Python (Pandas, Scikit-learn) for anomaly detection in production data and performance benchmarking of PNT devices, uncovering key insights that directly led to a 15% reduction in product defects.Delivered a strategic analysis of software feature usage from over active devices, presenting actionable insights that directly shaped the product development roadmap and reprioritized two major features for the next release cycle.Partnered with Sales and Marketing to translate complex device performance benchmarks into data-driven competitive collateral, a key asset used in a campaign that generated a 5% increase in qualified leads.

Education

• Illinois Institute of Technology

  Master's degree, Information Technology Project Management

• GITAM Deemed University

  Bachelor of Technology, Computer Science

  2016 — 2020