Skip to content

Uma Mahesh

Aspiring Data Analyst • linkedin.com/•••••

Career Objective

B.Tech Chemical Engineering graduate (CGPA 8.16) with hands-on project experience in SQL database design, Python-based EDA, web scraping, and Power BI dashboarding. Demonstrated ability to design normalized relational schemas, clean and analyze datasets (6K+ records), build interactive BI dashboards (8.5K+ items, ₹1.2M sales), and extract actionable business insights. Seeking an entry-level Data Analyst role to apply strong SQL, Python, Power BI and visualization skills to drive data-driven decisions.

Education

Chaitanya Bharathi Institute of Technology
Bachelor of Technology in Chemical Engineering • 2019 – 2023
Narayana College
TSBIE • 2019
TVR Model High School
SSC • 2017

Technical Skills

Programming Language: Python,SQL,Regex
Frontend Technologies: Requests
Backend Technologies: Beautiful Soup
Databases: MySQL,Relational Databases,Normalization
Data Warehousing: Star Schema
Data Analysis & Visualization: Pandas,NumPy,Matplotlib,Seaborn,Data Cleaning,Plotly,Power BI,Microsoft Excel,DAX,Dashboarding,Exploratory Data Analysis,Correlation Analysis
Data Integration & ETL: Referential Integrity

Projects

Employee Management System – SQL Project
Tools Used: MySQL, SQL, Relational database design, Normalization
  • Designed a relational database schema for employee, department, qualification and payroll modules enforcing 100% referential integrity to prevent orphaned records and ensure data accuracy.
  • Implemented a fully normalized schema to support scalable storage and efficient querying for 10,000+ personnel, reducing data redundancy and improving update performance.
  • Authored advanced SQL queries and stored procedures to compute payroll aggregates, employee tenure metrics and qualification-based filters for HR analytics.
  • Prepared data views and exportable result sets to enable integration with BI dashboards and downstream reporting tools for HR and payroll stakeholders.
Foodpanda Exploratory Data Analysis (EDA) using Python
Tools Used: Python, Pandas, NumPy, Matplotlib, Seaborn
  • Performed EDA on 6,000 Foodpanda order records across 20 features covering customer, restaurant and delivery variables to identify demand patterns and operational bottlenecks.
  • Executed data cleaning and preprocessing using Pandas and NumPy (missing value handling, type conversions, outlier detection) to ensure analysis reliability.
  • Created visualizations to reveal top food categories, peak order timings and city-level trends, supporting data-driven recommendations for marketing and logistics.
  • Delivered actionable insights on restaurant performance and user behavior that can inform menu promotions and delivery allocation strategies.
Power BI Project – Blinkit Sales Dashboard
Tools Used: Power BI, DAX, Star schema, Dashboarding, Excel
  • Designed and deployed an interactive Power BI dashboard analyzing 8.5K+ grocery items and ₹1.2M+ in sales to surface category and outlet performance.
  • Built a star schema (1 fact, 4 dimension tables) to optimize reporting performance and enable slice-and-dice analysis across time, category and store tiers.
  • Developed 10+ DAX measures and calculated columns (e.g., Sales per Kg, Years of Operation) to support custom KPIs and comparative analysis.
  • Delivered insights on top-performing categories, tier-wise outlet efficiency and health-conscious product trends to support merchandising and assortment decisions.
Electric Vehicle Data Analysis: From Web Scraping to Visualization
Tools Used: BeautifulSoup, Requests, Python, Pandas, Plotly, Matplotlib, Seaborn, Regex
  • Scraped 1,146 Electric Vehicle records from automotive websites using Requests and BeautifulSoup, transforming unstructured HTML into a structured dataset for analysis.
  • Performed extensive data cleaning with Pandas and Regex to standardize specifications and remove inconsistencies prior to analysis.
  • Conducted EDA to identify relationships between battery capacity, driving range, price efficiency and charging speed, observing a strong correlation (r ≈ 0.96) between battery capacity and range.
  • Built interactive visualizations with Plotly and static plots with Matplotlib/Seaborn to communicate insights on EV efficiency, cost per km and market trends.

Certifications

Introduction to MS Excel — Simplilearn
Python Programming Certification (Gold) — Innomatics Research Labs

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.