Vunna Praveen kumar

About

I am a Strategic Operations Architect with a background in the Flipkart Group (ANS Commerce) and an Executive PG in Data Science from IIIT Bangalore. I specialize in building automated Google Sheets 'Command Centers' that transform fragmented data into high-efficiency business intelligence, such as the ₹1.08Cr tracking systems I engineered for premium enterprise brands. My approach combines advanced logic—using QUERY, ARRAYFORMULA, and REGEX—with a deep understanding of operational bottlenecks to identify revenue-at-risk and optimize team capacity. When I’m not architecting data pipelines, I’m exploring new ways to bridge the gap between complex technical insights and real-world business strategy.

Experience

• Independent Data Operations Consultant · Self-Employed03-01-2025

  ➢ SME Operational Architecture: Engineered automated, interconnected Google Sheets ecosystems for SMEs transitioning from manual record-keeping; reduced reporting overhead by 40% via "Single Source of Truth" data pipelines. ➢ Performance Audit & SLA Engine: Architected a high-performance audit system processing 9,800+ records. Deployed synchronized data pipelines using ARRAYFORMULA, QUERY, and IMPORTRANGE to maintain real-time data integrity while identifying global SLA breach rates and revenue-at-risk. ➢ Operational Capacity Framework: Established a multi-stage data pipeline using MAP, LAMBDA, and REGEX to normalize complex workflow data. Leveraged Nested QUERY matrices and INDEX-driven logic to generate prescriptive insights into WIP saturation and departmental bottlenecks. ➢ Workflow Optimization & Recovery: Constructed a real-time Global Operations Hub using FILTER and XLOOKUP to quantify operational leakage. Automated an operational "Rescue Hour" recovery system using INDEX logic to synchronize capacity audits and liquidate backlogs without increasing headcount.

• Senior Marketing Associate (Data & Operations) · ANS Commerce (Flipkart Group)04-01-2023 – 12-01-2023

  ➢ Operational Bridge & "Client Champion" (Q3 2023): Acted as the central technical lead for premium enterprise accounts (Aldo, Bath & Body Works, Onitsuka Tiger). Honored with the "Client Champion" award for engineering automated dashboards that ensured 100% stakeholder visibility and real-time operational reliability across tech and marketing teams. ➢ Interconnected Infrastructure & Budget Ops: Synchronized disparate data from Meta, Google Ads, and GA4 into unified "Single Source of Truth" workbooks. Automated a ₹1.08Cr campaign tracking system, surpassing planned reach by 46% while achieving a 10% lower CPM through real-time pacing logic. ➢ Workflow Automation & Performance Engineering: Optimized complex reporting pipelines using REGEX and FILTER logic for enterprise accounts. Revamped Google Merchant Center (GMC) feeds via bulk Data Cleaning, resulting in a 15% reduction in CPC and a 20% increase in ROAS.

• Marketing Associate (Data & Operations) · ANS Commerce (Flipkart Group)03-01-2022 – 03-01-2023

  ➢ Revenue Scaling & Precision Tracking: Successfully scaled high-profile global accounts (Aldo, Bath & Body Works, Onitsuka Tiger) boosting quarterly revenue via meticulously planned campaign structures. Maintained a consistent 10x+ ROAS (peaking at 16x) by architecting ARRAYFORMULA and Nested QUERY trackers to monitor and optimize daily performance shifts. ➢ Portfolio Management (Growth Phase): Managed ₹50L/month aggregate budgets with 100% pacing accuracy. Built the initial automated tracking systems using IMPORTRANGE to consolidate data across 10+ accounts, which laid the foundation for the team's standardized reporting. ➢ Conversion Optimization: Leveraged data-driven landing page sorting and creative prioritization to support a 282% conversion increase. Developed automated dashboards that identified high-priority inventory, resulting in a 10% uplift in site-wide conversion via granular product-level audits.

• Marketing Intern (Data & Operations) · ANS Commerce (Flipkart Group)01-01-2022 – 02-01-2022

  ➢ Media Modeling & Financial Projections: Developed complex one-year media plans and financial models in Google Sheets. Utilized spreadsheet modeling to forecast budget allocations across platforms to hit brand-specific KPIs and project future growth. ➢ Technical Audit & Sales Support: Conducted granular audits of Facebook and Google Ad accounts to identify "Creative Fatigue" and Budget Leakage. Translated technical findings into strategic presentations used by the Sales department to successfully pitch and close new enterprise clients. ➢ Data-Driven Keyword Research: Scaled brand visibility for apparel clients by using advanced FILTER and SORT logic to identify high-performing search terms while negating irrelevant data to increase ROI.

• Research Assistant · Indian Institute of Corporate Affairs12-01-2019 – 01-01-2020

  ➢ Primary Data Lifecycle Management: Executed a large-scale field survey, personally conducting 700+ stakeholder interviews. Transformed fragmented field observations into a structured, high-integrity database used for government-level policy reporting. ➢ Quantitative Impact Analysis: Collaborated with the IICA research team to process complex socio-economic datasets. Measured improvements in tribal household income and evaluated the impact of financial assistance schemes through structured quantitative research workflows. ➢ Data Integrity: Ensured 100% accuracy in data entry and qualitative analysis, demonstrating early proficiency in handling large-scale datasets for high-stakes reporting.

Education

• International Institute of Information Technology BangaloreExecutive PG Programme in Data Science & AI
• Lovely Professional UniversityB.Sc. Economics (Hons)

Similar talent on Pangea

Hitesh S.Looking for opportunitiesKasol, Himachal Pradesh 175105Ishaan P.Technology Consultant | Bachelor of TechnologyBhopal, Madhya PradeshAndy L.Data Analyst | Ecommerce Owner | Empowering Brands with Data-Driven InsightsNew York, NYHarshal P.Marketing Analytics, Growth Strategy & Product