Skip to content

Vamsi Gajjala

Data Analyst • Rocky Hill, Connecticut, United States • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst with 0 years of experience building analytics, BI and ML solutions using Power BI, SQL Server and Python. Skilled at designing governed semantic layers and DAX measures to enable self-service reporting for business users and executives. Experienced in building retention and forecasting models with scikit-learn and time-series regression, operating on datasets up to 2M+ records. Delivered performant ETL pipelines and incremental loads using Azure Data Factory and Azure Databricks, and implemented partitioned PySpark transformations for reliable refreshes. Led data-quality and semantic model standardization projects that removed reporting discrepancies and streamlined audit-ready access controls. Comfortable working in Agile/Scrum teams to translate business questions into prioritized analytics deliverables.

Technical Skills

Programming Language: Python,SQL
Databases: MySQL
Cloud Platforms: Azure Blob Storage
Data Engineering & Processing: PySpark,Azure Databricks,Semantic Layer
Data Analysis & Visualization: Pandas,Power BI,Tableau,DAX
Machine Learning & AI: Regression,Classification,Clustering,scikit-learn
Data Integration & ETL: ADF,ETL,Incremental Loads
Identity & Access Management (IAM): RBAC,Data Quality

Work Experience

EXL
Data Analyst
Jan 2025
Analytics and BI work supporting executive reporting, retention modeling and ETL pipeline modernization for enterprise business users.
Tech Stack: Power BI, DAX, SQL Server, Python, scikit-learn, Azure Data Factory, Azure Databricks, PySpark, Role-Based Access Control
  • Rebuilt 12 Power BI dashboards on a governed SQL Server semantic layer using standardized DAX measures, enabling 40+ business users to self-serve revenue and retention KPIs.
  • Developed a Python classification model with scikit-learn on 2M+ customer records to prioritize weekly retention targets, contributing to an 18% reduction in churn among high-risk accounts.
  • Re-architected 20+ Azure Data Factory pipelines to implement incremental loads and parameterization, reducing end-to-end ETL runtime from 6 hours to 2.7 hours.
  • Implemented partitioned transformations in Azure Databricks using PySpark to scale record-level processing and improve downstream refresh reliability.
  • Consolidated ad-hoc reporting into a certified star-schema data model with documented KPI definitions and a shared data dictionary to eliminate recurring discrepancies.
  • Implemented role-based access control and row-level security across Power BI workspaces to streamline access reviews and meet audit and compliance requirements.
Tech Mahindra
Associate Data Analyst
Feb 2022 – Dec 2023
Data and forecasting analytics supporting demand planning, reporting performance, and data quality for cross-business unit reporting.
Tech Stack: Python, Pandas, scikit-learn, Azure Data Factory, SQL Server, MySQL, Tableau
  • Built time-series and regression models in Python using Pandas and scikit-learn on three years of transactional history, improving demand forecast accuracy by 22%.
  • Automated 15 recurring ETL workflows in Azure Data Factory and Databricks to ingest SQL Server, MySQL and flat-file sources into a consolidated reporting warehouse.
  • Reduced manual reporting effort by 35 hours monthly through scheduled ADF pipelines and parameterized workflow orchestration.
  • Optimized SQL queries and implemented covering indexes to cut dashboard load time and improve report responsiveness.
  • Established validation checks and lineage documentation across production feeds to raise data quality and reduce downstream exceptions.
  • Delivered deep-dive analyses using SQL and Tableau, translating insights into prioritized recommendations for finance and operations leadership.
Tech Mahindra
Data Analyst Intern
May 2021 – Jan 2022
Entry-level analytics work supporting regional sales/retention reporting and cloud migration of reporting datasets.
Tech Stack: MySQL, Power BI, Python, Pandas, Azure Data Factory, Azure Blob Storage, scikit-learn
  • Reduced manual report preparation effort by 25% by writing MySQL queries and reusable views to aggregate sales and retention datasets.
  • Built five Power BI dashboards tracking sales, retention, and service KPIs adopted by regional teams for weekly performance reviews.
  • Cleaned and standardized 500K+ customer records in Python using Pandas, resolving duplicates and null values to improve analysis reliability.
  • Supported Azure Data Factory pipeline setup and Azure Blob Storage ingestion to migrate reporting datasets to the cloud and improve refresh reliability.
  • Identified actionable customer segments using regression and k-means clustering in scikit-learn to inform targeted retention outreach.
  • Documented ETL steps and created dashboard specifications to standardize report handoffs between analysts and business users.

Education

Sacred Heart University
Master of Science, Computer Science • Mar 2025

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

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • 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
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ 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
  • Written by senior career writers

    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
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    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
  • Documentation

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

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

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

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.