Data & BI Analyst - Supply Chain Forecasting

Kaviya Venkateshbabu

********@***.*** • 602-***-**** • LinkedIn • Houston, TX

SUMMARY

Data & Business Intelligence Analyst with experience in supply chain forecasting, bridging business requirements with technical implementation, and communicating technical trade-offs to non-technical stakeholders. Skilled in SQL, Python, Power BI, Tableau, Databricks, and AI-assisted analytics, with a track record of improving operational visibility, forecast accuracy, and decision-making. SKILLS

Software & Tools: SQL, Python, Power BI (DAX, Power Query (M), Data Modeling), Tableau, Excel (Advanced, VBA), Azure Databricks, Snowflake, Airflow, SAS, R, Alteryx, NumPy, Pandas, Power Automate, BigQuery, Looker Studio, PowerPoint. Analytics & Business Insights: Business Intelligence, Dashboard Development, Data Visualization, Predictive Forecasting, Time Series Analysis, Statistical Analysis, A/B Testing, Root Cause Analysis, Decision Support, KPI Development, Data Modeling, Ad Hoc Analysis, Stakeholder Reporting, Machine Learning, Customer Analytics, Agile, Scrum. Data Engineering & Automation: ETL/ELT Pipeline Design, SQL Query Optimization, Forecast Performance Analysis, Data Warehousing, Domain Expertise: Report Automation, Supply Chain Data (Sales Transformation, & Operations Workflow Planning Orchestration, (S&OP), MRP, Data MPS, Validation, Capacity Dimensional Planning, Modeling, Inventory Management, Git, dbt. Supplier & Planner Collaboration), Consumer Packaged Goods (CPG), Semiconductor Operations, Manufacturing, Logistics Analytics. WORK EXPERIENCE

Data Analyst, Supply Chain (Co-Op)06/2025 - 12/2025 Skyworks Solutions, Inc., San Jose, CA, United States

● Developed Power BI dashboards with DAX and semantic data models (star schema), integrating SAP ERP data to monitor forecast performance, inventory positioning, and material readiness across global semiconductor manufacturing sites.

● Refactored legacy reporting into a unified SQL-based ETL pipeline powering a new Expiring Inventory dashboard, including expiry risk, scrap valuation, and multi-source risk segmentation.

● Performed deep-dive component-level analyses to identify root causes of inventory discrepancies, recommending process improvements that reduced stockouts by 10%.

● Reduced manual reporting effort by 40% by automating supply planning workflows using SAP ERP integrations, SQL, Python, Power Query, and Azure Databricks, improving data quality and decision-making across material planning cycles.

● Deployed Copilot-powered, AI-assisted self-service analytics, enabling non-technical planners to query material data via natural language without dashboard navigation or analyst support.

● Partnered cross-functionally with supply chain, sourcing, and planning stakeholders to identify operational risks, support S&OP activities, and translate business requirements into inventory visibility tools that accelerated replenishment decision-making. Data Analyst 09/2022 - 03/2024

LatentView Analytics, Chennai, India

● Built predictive demand forecasting models for PepsiCo using historical shipment data, SQL, Python, and causal inference to improve forecast accuracy by 14% (MAPE reduction) and support business planning tied to ~$1.2B in revenue.

● Automated an end-to-end enterprise forecasting pipeline processing 25M+ weekly records by managing 50+ SQL, SAS, and shell scripts for data ingestion, transformation, validation, and quality checks, ensuring reliable and scalable forecast cycles.

● Reduced forecast processing time from 10+ hours to 2.5 hours by optimizing ETL pipelines across Azure Data Lake, Snowflake, and Teradata through parallel execution and workflow optimization within Agile sprint cycles.

● Led a team of six in implementing the Global Template, using data mining and EDA to resolve data quality issues, standardize CPG datasets, and establish a single source of truth for improved data governance and data lineage.

● Delivered Power BI and Tableau dashboards tracking sales performance, demand variance, forecast accuracy, and business KPIs, providing executive-ready reporting and actionable insights during weekly business reviews.

● Analyzed large-scale forecasting, POS sales, and consumer demand data using Azure Databricks, SQL, and Python to improve demand forecasting and support customer analytics across 1,000+ retailers.

● Increased forecast coverage to 95%+ by developing automated logic to detect new products and backfill missing forecast segments, eliminating manual identification of demand-planning gaps.

● Identified drivers of forecast accuracy decline through A/B testing, ad hoc analysis, and data storytelling, collaborating with cross-functional stakeholders to implement a promotion lift factor across CPG sales and demand forecasting cycles. Supply Chain Analyst 06/2021 - 08/2022

Priya Petro Products, Chennai, India

● Built Tableau dashboards to monitor carrier performance and delivery KPIs, surfacing delay patterns through SQL and Excel analysis that reduced late deliveries by 12% and improved logistics visibility for planning leadership.

● Reduced production costs by 10% by auditing Bill of Materials (BOM) and Bill of Process (BOP) data, identifying cost inefficiencies and implementing process improvements that strengthened data quality across manufacturing workflows. PROJECTS

Demand Planning & Forecast Disaggregation: Built a demand forecast disaggregation pipeline to improve forecast accuracy and planning visibility. Component Punch List: Developed a Power BI dashboard integrating SAP ERP and Azure Databricks data to monitor material shortages and component readiness. Expiring Inventory Analytics: Built an inventory expiry dashboard to identify scrap risk and support inventory decisions. Analytics Portfolio: Built cross-industry analytics projects across retail, aviation, finance, and healthcare using BigQuery, Snowflake, SQL, Python, and Looker Studio. EDUCATION

Arizona State University 08/2024 - 05/2026

Master of Science in Data Science, Analytics & Engineering GPA: 3.67/4 Easwari Engineering College (Anna University) 08/2017 - 04/2021 Bachelor of Engineering in Electronics and Communication Engineering GPA: 3.49/4

Contact this candidate