Skip to content

Vegesna Srilekha

Data Analyst • Visakhapatnam, India • •••••

Professional Summary

Results-oriented Data Analyst with internship experience in SQL, Python, Power BI, Advanced Excel and Tableau. Experienced in ETL, data cleaning, data modeling, dashboard development (DAX, Power Query), and statistical analysis. Proven ability to turn 50,000+ record datasets into actionable BI dashboards and operational improvements (reduced manual reporting effort by 40%, cut supply lead times by 15%, improved delivery accuracy by 20%). Seeking an entry-level Data Analyst role to apply analytics and visualization skills to drive business insights and measurable outcomes.

Technical Skills

Programming Language: Python,VBA,SQL
Databases: MySQL,PostgreSQL,Joins,Common Table Expressions,Window Functions,Stored Procedures
Version Control & Development Tools: Jupyter Notebook,Git
Data Warehousing: Star Schema,Data Modeling
Data Analysis & Visualization: Pandas,NumPy,Matplotlib,Power BI,DAX,Power Query,Tableau,Data Visualization,Microsoft Excel,Data Cleaning,Statistical Analysis,KPI Reporting,Business Intelligence,Data-driven Decision Making,Pivot Tables,Power Pivot,Macros,XLOOKUP,RFM Analysis
Machine Learning & AI: K-Means,Clustering,scikit-learn
Data Integration & ETL: ETL,Data Validation
Compliance & Governance: Data Governance
Enterprise Platforms: Power Automate

Work Experience

Vijayasri Organics
Visakhapatnam, India
Data Analyst Intern
Sep 2024 – Feb 2025
Tech Stack: Power BI, DAX, Power Query, SQL, Python, Excel, Power Automate
  • Designed and deployed interactive Power BI dashboards (Power BI, DAX, Power Query) from a 50,000+ record sales and operations dataset to monitor inventory, sales, dispatch and delivery KPIs for daily operational tracking.
  • Analyzed 50,000+ records using SQL and Advanced Excel to identify demand and fulfillment bottlenecks; recommended supply chain changes that reduced lead time by 15% and improved delivery accuracy by 20%.
  • Automated recurring business reports and scheduled refreshes using Power Automate and Power BI, reducing manual reporting effort by 40% and improving timeliness of insights.
  • Performed end-to-end data cleaning, validation and transformation with SQL, Python (Pandas) and Excel to improve data quality and reporting accuracy across dashboards.
  • Implemented star-schema data modeling and optimized Power BI data model to improve query performance and maintainability of reports for cross-functional teams.
  • Collaborated with business stakeholders to translate requirements into measurable KPIs and interactive visualizations, enabling stakeholders to make data-driven decisions and prioritize operational improvements.
KPMG (Forage)
Data Analytics Virtual Intern
Tech Stack: Python, Pandas, scikit-learn, Matplotlib, Power BI, Excel
  • Conducted data quality assessments to identify inconsistencies and missing values, documenting issues and proposing remediation steps to improve dataset reliability.
  • Cleaned and transformed datasets using Python (Pandas) and Excel, applying validation rules to produce analysis-ready tables and reduce downstream errors.
  • Performed customer segmentation using RFM analysis and K-Means clustering with scikit-learn, deriving four distinct customer segments and actionable targeting recommendations.
  • Created visualizations and business reports using Matplotlib and Power BI to communicate segment characteristics, revenue distribution and retention opportunities.
  • Prepared and presented a consulting-style case study summarizing analytical findings and strategic recommendations to stakeholders.
  • Documented methodology, assumptions and reproducible code artifacts to ensure clear handover and reproducibility of analyses.
Analytics

Projects

Sales Performance Dashboard
Tools Used: Power BI, SQL, Excel, DAX, Star-schema design
  • Designed an interactive Power BI sales dashboard with 12+ KPIs using 50,000+ sales records to monitor revenue, conversion and product performance.
  • Developed DAX measures and calculated columns and built a star-schema data model to enable efficient slicing, filtering and automated refreshes that supported sales performance analysis.
Customer Segmentation Analysis
Tools Used: Python, SQL, scikit-learn, Matplotlib, RFM Analysis
  • Cleaned and analyzed customer transaction data using Python and SQL; applied RFM analysis and K-Means clustering to segment customers into four groups based on value and engagement.
  • Visualized segment behavior with Matplotlib and produced actionable recommendations for targeted marketing and retention strategies.
HR Analytics Dashboard
Tools Used: Power BI, Excel, SQL, Data Visualization
  • Built HR dashboards to monitor attrition, attendance and workforce KPIs; analyzed demographic and performance trends to surface retention risks.
  • Implemented interactive filters and drill-through reports to enable HR managers to explore drivers of turnover and prioritize interventions.
COVID-19 Global Data Analysis
Tools Used: Python, Pandas, Matplotlib, Statistical Analysis
  • Processed and analyzed 100,000+ COVID-19 records performing exploratory data analysis to identify trends in cases, recoveries and mortality across countries.
  • Built comparative visualizations and produced a statistical summary report that highlighted key temporal and geographic patterns.

Education

Miracle Educational Institutions and Society
MBA • 2025

Certifications

Google Professional Data Engineer — Google
Cloudera Data Analyst — Cloudera
IBM Data Analysis with Python — IBM
Introduction to SQL — Coursera

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.