Skip to content

Kolluri Venkata Ganesh

Data Analyst • Bengaluru, Karnataka • k***************@gmail.com • +91*******299 • drivetube.ai/•••••

Career Objective

Data Analyst with 0 years of experience building end-to-end analytics and BI solutions using Power BI, SQL, Snowflake and Microsoft Fabric. Experienced in designing star-schema data models, semantic models and KPI frameworks for supply chain and e-commerce analytics, and in implementing ETL pipelines and dataflows to consolidate large cross-market datasets. Proficient with Python (Pandas) and PySpark for exploratory analysis and transformations, and with DAX for production reporting. Delivered interactive dashboards, automated alerts and reusable SQL views that improved operational visibility and surfaced delivery and fraud-related risks in supply chain data (180K+ transactions). Strong foundation in data validation, data cleaning, data modeling and stakeholder reporting to translate complex datasets into actionable business insights.

Education

Centurion University of Technology and Management
Bachelor of Technology (B.Tech) in Computer Science Engineering • Vizianagaram, Andhra Pradesh • 2022 – 2026

Technical Skills

Programming Language: Python,SQL
Databases: Snowflake,MySQL,Microsoft Fabric
Cloud Platforms: Amazon Web Services,S3
Version Control & Development Tools: GitHub,Jupyter Notebook
Data Engineering & Processing: PySpark
Data Warehousing: Lakehouse
Data Analysis & Visualization: Pandas,Matplotlib,Power BI,DAX,Tableau,Exploratory Data Analysis
Data Integration & ETL: Azure Data Factory,Google Cloud Dataflow,ETL

Projects

DataCo Supply Chain Analytics
Tools Used: Microsoft Fabric, Data Factory, Dataflow Gen2, Lakehouse, SQL, Power BI, DAX, Data Activator, PySpark, AWS S3
  • Architected and implemented data ingestion pipelines using Microsoft Fabric components (Data Factory, Dataflow Gen2) to consolidate 180K+ supply chain transactions into a Lakehouse for analytics.
  • Configured connectors to ingest structured files from AWS S3 and registered tables in the Lakehouse for downstream consumption.
  • Designed a star-schema data model and built a semantic model to enable executive reporting on revenue, profitability and delivery KPIs.
  • Developed interactive Power BI reports and authored DAX measures to track delivery performance and operational metrics for supply chain stakeholders.
  • Implemented PySpark transformations in the Lakehouse to standardize, denormalize and enrich event data for analytical queries.
Brazil E-Commerce Business Intelligence Dashboard
Tools Used: Snowflake, SQL, Power BI, DAX, Python, Pandas, Matplotlib, Jupyter Notebook, GitHub
  • Built a scalable analytical model in Snowflake and implemented a Snowflake schema to consolidate multichannel e-commerce datasets for BI consumption.
  • Implemented SQL transformations and created reusable Snowflake views to standardize seller and order data across sources.
  • Developed Power BI dashboards with DAX measures and drill-through reports exposing 10+ KPIs on revenue, profitability, seller performance and delivery.
  • Conducted exploratory data analysis using Python and Pandas to validate delivery timelines and data quality.
  • Documented analysis and visualizations in Jupyter Notebook, version-controlled queries and scripts in GitHub, and produced visual summaries using Matplotlib to support operational decisions (94% on-time delivery rate identified).
Flipkart Sales Data Analysis using SQL
Tools Used: MySQL, SQL, Window Functions, CTEs, SQL Views, Excel, Tableau
  • Analyzed 10K+ product records using MySQL and SQL window functions to evaluate sales performance, inventory movement and seller efficiency.
  • Implemented reusable SQL views and CTEs to automate recurring sales reports and improve reporting consistency.
  • Performed data cleansing and validation using SQL and Excel to resolve missing values and duplicates, improving reporting accuracy.
  • Created ad-hoc interactive visualizations in Tableau to summarize seller-level KPIs and inform inventory rebalancing decisions.

Certifications

Data Science — NPTEL
SQL (Advanced) — HackerRank

Powered by Drivetube · Create your own profile at drivetube.ai

Explore Drivetube

  • Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
  • Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
  • Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
  • Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
  • Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
  • Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.

Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.