Haritha Macharla
Data Analyst • Hyderabad, India • h****************@gmail.com • +91*******136 • drivetube.ai/•••••
Professional Summary
Data Analyst with 0 years of experience in data cleaning, exploratory analysis, dashboarding and reporting using Python, SQL, Excel and Power BI. Experienced through hands-on academic projects and a Deloitte virtual internship building ETL-ready datasets, customer RFM segmentation dashboards and sales/inventory reports. Strong applied knowledge of Pandas, NumPy and Matplotlib for analysis, MySQL/PostgreSQL for query design, and Power Query for automating data ingestion. Skilled in KPI design, hypothesis testing and building reproducible analysis in Jupyter Notebook and Git. Comfortable translating business questions into analytic pipelines, delivering interactive Power BI/Tableau dashboards and providing actionable recommendations to improve retention and revenue.
Technical Skills
Programming Language: Python,SQL
Databases: MySQL,PostgreSQL
Version Control & Development Tools: Jupyter Notebook,Git
Data Warehousing: Data Modeling
Data Analysis & Visualization: Pandas,NumPy,Matplotlib,Power BI,Tableau,Microsoft Excel,Power Query,Data Cleaning,KPI Reporting,Hypothesis Testing,A
Machine Learning & AI: Supervised Learning,Unsupervised Learning
Data Integration & ETL: ETL
Work Experience
Deloitte (Forage)
Data Analytics Virtual Internship
2025 – 2025
Virtual analytics internship with Deloitte via Forage; delivered data-preparation, ETL and dashboarding work to support professional-services reporting and client analytics use-cases.
Tech Stack: Python, Pandas, Power Query, Power BI, SQL, Jupyter Notebook, Git
- Cleaned and standardized multiple client CSV datasets using Python and Pandas to resolve schema inconsistencies and improve downstream data accuracy by 30%.
- Engineered repeatable ETL workflows with Power Query to ingest and transform weekly sales and transaction files for reporting consumption.
- Built interactive Power BI dashboards to visualize retention and revenue KPIs and enable stakeholder self-service reporting.
- Wrote optimized SQL queries to aggregate customer and transaction data for cohort analysis and dashboard sources.
- Conducted hypothesis testing using Python to evaluate drivers of churn and produce prioritised recommendations for retention.
- Documented analysis pipelines and data dictionaries in Jupyter Notebook and versioned artifacts using Git to improve reproducibility.
Projects
E-Commerce Customer Churn & RFM Analysis
Tools Used: Power BI, SQL, Python, Pandas, Unsupervised Learning, Supervised Learning
- Developed an interactive Power BI dashboard that segments customers using RFM analysis to highlight high-value and at-risk cohorts.
- Applied K-means clustering for RFM segmentation using Python and Pandas to create actionable customer groups for targeted campaigns.
- Built a prototype churn scoring model with logistic regression to prioritise retention candidates and output model scores to dashboard.
Blinkit Sales & Inventory Analytics
Tools Used: Python, SQL, Excel, Tableau, KPI Reporting
- Analyzed sales and inventory datasets using SQL and Python to identify SKU-level stockouts and supply gaps.
- Created KPI reports in Excel and Tableau to track revenue, profit margins and stock availability across outlets.
- Designed visualizations and dashboards to surface high-velocity SKUs and inform restocking priorities.
Retail Store Sales Analysis
Tools Used: Python, Pandas, NumPy, Matplotlib, Hypothesis Testing
- Performed data cleaning and EDA with Python, Pandas and NumPy to uncover sales trends and seasonal patterns.
- Created Matplotlib visual reports to communicate daily and weekly sales fluctuations to non-technical stakeholders.
- Executed hypothesis tests to validate promotional lift and support decisions on campaign continuation.
Bookstore Database Analytics
Tools Used: SQL, MySQL, PostgreSQL, Data Modeling
- Developed complex SQL queries using JOINs, CTEs and window functions in MySQL to produce sales and inventory reports.
- Designed normalized schema elements and documented data model conventions to support reliable reporting.
- Generated executive reports on bestselling books, inventory status and customer purchase trends for merchandising decisions.
Education
ACE Engineering College
B.Tech in Computer Science • 2023 – 2026
Megha Institute of Engineering and Technology
Diploma in Computer Science • 2019 – 2022
Certifications
Getting Started with Microsoft Data Analytics — Microsoft
Data Analysis with Python — IBM Cognitive Class
Master Microsoft Excel — LinkedIn Learning
Data Science and Analytics — HP Life
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.