Haritha Macharla
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
Work Experience
- 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
- 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.
- 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.
- 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.
- 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
Certifications
Powered by Drivetube · Create your own profile at drivetube.ai
Everything on Drivetube
Six products, two of them free forever. Start wherever you are.
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 BoardFree
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 - Resume Writing ServicesFrom $25.99
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 - Drivetube HireFree tier
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.