Resume Structure: What to Include
Your resume should follow this structure (in order):
1. Header (Contact Information)
[Your Name]
Data Analyst | Python, SQL, Power BI
Email: yourname@email.com | Phone: +91-XXXXXXXXXX
LinkedIn: linkedin.com/in/yourprofile | Portfolio: yourportfolio.com | GitHub: github.com/yourusername
Location: Bangalore, India
What NOT to include:
- ❌ Photo (ATS can't read images, takes space)
- ❌ Full address (city is enough)
- ❌ Date of birth, marital status (illegal to ask in many countries, unprofessional)
- ❌ "Objective" section (waste of space — everyone wants "challenging role with growth")
2. Skills Section (ATS Keywords)
Why first? ATS scans for keywords. If skills are buried at bottom, you might get rejected.
Format:
TECHNICAL SKILLS
Languages: SQL, Python, R, DAX
Tools: Power BI, Tableau, Excel (Pivot Tables, VLOOKUP, Power Query), Looker Studio
Databases: MySQL, PostgreSQL, BigQuery, MongoDB
Libraries: pandas, NumPy, matplotlib, seaborn, scikit-learn
Statistics: A/B Testing, Hypothesis Testing, Regression, Cohort Analysis, Time Series
Pro tip: Match keywords from job description (if JD mentions "BigQuery" and "Looker," add both even if you've only used BigQuery).
ATS trick: Copy job description → Paste into WordCloud tool → Identify top 10 keywords → Add all to your Skills section (if true). Example: JD mentions "stakeholder management" 5 times → Add "Cross-functional collaboration with stakeholders" to a project bullet.
3. Work Experience (or Projects if fresher)
Format (use STAR method: Situation, Task, Action, Result):
Data Analyst | Flipkart, Bangalore | Jul 2023 – Present
• Reduced cart abandonment by 12% (from 45% → 33%) by analyzing checkout funnel using SQL cohort analysis, identifying payment gateway timeout as #1 drop-off reason, and collaborating with engineering to implement auto-retry — impacting 2M+ monthly users and increasing revenue by ₹8 crore annually
• Built automated sales dashboard in Power BI tracking 50+ KPIs across 6 business units, replacing 20 hours/week of manual Excel reporting, enabling real-time decision-making for C-suite executives
• Performed A/B test on free shipping threshold (₹499 vs ₹399) using statistical significance calculator (95% confidence, n=100K users), achieving 19% conversion lift and ₹3.5 crore incremental revenue in Q4 2024
Formula for each bullet:
[Action Verb] + [What you did] + [How you did it (tools/methods)] + [Quantified impact (%, ₹, time saved)]
Good action verbs: Analyzed, Built, Optimized, Reduced, Increased, Automated, Identified, Collaborated, Forecasted, Segmented
Bad bullets (vague, no impact):
- ❌ "Worked on data analysis projects"
- ❌ "Used SQL to query databases"
- ❌ "Created dashboards for stakeholders"
Good bullets (specific, quantified):
- ✅ "Analyzed 2M+ transactions using SQL window functions to identify top 10% high-value customers (RFM analysis), enabling targeted email campaigns that increased repeat purchase rate from 18% → 24% (+₹1.2 crore revenue)"
4. Education
Bachelor of Technology in Computer Science | XYZ University, Mumbai | 2020-2024
CGPA: 8.5/10 | Relevant Coursework: Statistics, Database Management, Machine Learning
Certifications:
• Google Data Analytics Professional Certificate (Coursera, 2024)
• Microsoft Power BI Data Analyst Associate (PL-300, 2024)
If fresher: Put Education before Work Experience. If experienced (2+ years): Put Experience first, Education second.
5. Projects (Critical for freshers)
See data-analyst-portfolio-projects for detailed project ideas.
Format:
E-commerce Sales Analysis (Python, SQL, Tableau) | GitHub Link | Live Dashboard
• Analyzed 50K+ Zomato orders dataset to identify top-performing restaurants and peak delivery hours, uncovering that 60% of orders occur 7-9 PM on weekends, enabling targeted marketing campaigns
• Built interactive Tableau dashboard with filters for city, cuisine, and time period, allowing stakeholders to explore trends independently — viewed 500+ times on Tableau Public
• Forecasted next quarter's demand using ARIMA time series model (85% accuracy), helping optimize delivery partner allocation
3-5 projects is ideal (more = dilutes quality, fewer = looks inexperienced).
ATS (Applicant Tracking System) Optimization
What is ATS?
Applicant Tracking System = Software that screens resumes before humans see them. 75% of resumes are rejected by ATS.
How ATS works:
- Scans resume for keywords from job description
- Parses resume into sections (Education, Experience, Skills)
- Scores resume (0-100) based on keyword match
- Only top 25% reach human recruiter
ATS-Friendly Formatting Rules
✅ DO:
- Use standard section headers: "Work Experience" (not "Where I've Worked"), "Skills" (not "Technical Toolkit")
- Use reverse chronological order (most recent first)
- Use standard fonts: Arial, Calibri, Times New Roman (not handwriting fonts)
- Save as
.docxor.pdf(PDF preferred for formatting preservation) - Use bullet points, not paragraphs
- Spell out acronyms first time: "Customer Relationship Management (CRM)"
❌ DON'T:
- Use tables, text boxes, headers/footers (ATS can't read them)
- Use images, logos, charts (ATS skips visual content)
- Use fancy fonts, colors, graphics (might break parsing)
- Use columns (ATS reads left-to-right, top-to-bottom — columns confuse it)
- Put important info in header/footer (ATS often ignores these)
Keyword Optimization Strategy
Step 1: Identify required keywords from job description
Example JD snippet:
"We're looking for a Data Analyst with 2+ years experience in SQL, Python, and Tableau.
Must have experience with A/B testing, funnel analysis, and stakeholder management.
BigQuery and Looker Studio experience preferred."
Keywords identified:
- Required: SQL, Python, Tableau, A/B testing, funnel analysis, stakeholder management
- Preferred: BigQuery, Looker Studio
Step 2: Add keywords to resume (if true)
- Skills section: Add "BigQuery, Looker Studio" if you've used them
- Experience bullets: "Performed A/B testing..." (not just "Ran experiments")
- Experience bullets: "Collaborated with cross-functional stakeholders including Marketing, Product, and Engineering teams" (uses exact phrase from JD)
Step 3: Test ATS compatibility
Use free tools:
- Jobscan.co: Upload resume + job description → Get ATS match score (aim for 80%+)
- Resume Worded: AI-powered feedback on keyword optimization
Warning: Don't keyword-stuff (adding random keywords in white text at bottom). ATS detects this and auto-rejects. Only add keywords that truthfully describe your experience.
Common ATS Mistakes
| Mistake | Why it fails | Fix | |---------|--------------|-----| | Skills section at bottom | ATS might truncate resume at 1 page, miss skills | Put Skills near top (after header) | | "Proficient in Excel" (vague) | ATS looks for specific Excel skills | "Excel (Pivot Tables, VLOOKUP, Power Query, Macros)" | | "Analyzed data" (generic) | Every analyst says this, no keyword match | "Analyzed customer churn using cohort analysis and logistic regression in Python" | | Mixing fonts/font sizes | Breaks ATS parsing | Use single font, max 2 sizes (name=14pt, body=11pt) | | Spelling mistakes | "Python" vs "Pyton" — ATS won't match | Use spell-check, have 3 people review |
⚠️ CheckpointQuiz error: Missing or invalid options array
Resume Examples by Experience Level
Fresher Resume (0-1 year experience)
Structure:
- Header
- Skills
- Projects (most important section — compensates for lack of work experience)
- Internships (if any)
- Education
- Certifications
Example project bullet (demonstrates work-level skills):
IPL Analytics Dashboard (Python, SQL, Power BI) | GitHub | Live Dashboard
• Scraped 15K+ IPL match records (2008-2024) using Python BeautifulSoup, cleaned data with pandas (handled missing values, outliers), and loaded into PostgreSQL database for analysis
• Performed exploratory data analysis to identify winning patterns: Teams batting first won 52% vs 48% batting second; venues with dew factor (Bangalore, Mohali) favor chasing teams by 8% margin
• Built interactive Power BI dashboard with DAX measures (Win Rate, Average Score, Strike Rate by Player) and slicers for Season, Team, Venue — published on LinkedIn with 2,000+ views
• Key insight: Spinners with economy <7.0 in powerplay overs increase team win probability by 15% — shared analysis with cricket analytics community on Reddit (50+ upvotes)
Why this works:
- ✅ Shows data pipeline (scraping → cleaning → storage → analysis → visualization)
- ✅ Demonstrates SQL, Python, Power BI (keywords)
- ✅ Quantifies impact (even though it's a practice project: "2,000+ views," "15% win probability")
- ✅ Shows business thinking ("Key insight: Spinners with economy <7.0...")
Mid-Level Resume (2-5 years experience)
Structure:
- Header
- Skills
- Work Experience (highlight promotions, cross-functional impact)
- Projects (optional — only if impressive side projects)
- Education
Example work bullet (demonstrates business impact):
Senior Data Analyst | Swiggy, Bangalore | Jan 2023 – Present
• Led churn reduction initiative by building predictive model (logistic regression, 78% accuracy) to identify at-risk customers, enabling proactive retention campaigns (personalized discounts, win-back emails) that reduced monthly churn from 8% → 5.5%, saving ₹4 crore annually in customer acquisition costs
• Designed A/B testing framework for pricing experiments, running 15+ tests in 2024 (delivery fee, surge pricing, subscription plans), achieving cumulative 12% revenue lift (₹18 crore incremental revenue) while maintaining 4.2/5 customer satisfaction score
• Automated weekly executive dashboard in Tableau with 80+ KPIs (GMV, orders, NPS, delivery time) using Tableau Hyper extracts and Python scripts, reducing manual reporting time from 10 hours → 30 minutes and enabling real-time decision-making for C-suite
• Mentored 3 junior analysts on SQL optimization, Python best practices, and stakeholder communication, improving team's query performance by 40% (avg query time 8s → 4.8s) and presentation quality (feedback score 3.2 → 4.5/5)
Why this works:
- ✅ Shows leadership ("Led initiative," "Mentored 3 analysts")
- ✅ Quantifies business impact (₹4 crore saved, ₹18 crore revenue, 40% performance improvement)
- ✅ Demonstrates cross-functional collaboration (C-suite dashboards, retention campaigns)
- ✅ Shows technical depth (predictive modeling, A/B testing, automation)
Senior/Lead Resume (5+ years experience)
Structure:
- Header + Summary (2-3 sentence value proposition)
- Skills (focus on strategic skills: A/B testing, experimentation, stakeholder management)
- Work Experience (highlight team leadership, strategy, executive influence)
- Education
Example summary:
Data Analytics Leader with 7+ years driving revenue growth and operational efficiency at scale (Flipkart, Amazon). Expert in experimentation (200+ A/B tests), predictive modeling, and executive communication. Led 5-person analytics team supporting Product, Marketing, and Operations, delivering ₹50+ crore annual impact.
Example work bullet (demonstrates strategic thinking):
Lead Data Analyst | Flipkart, Bangalore | Apr 2021 – Present
• Defined analytics strategy for ₹5,000 crore Grocery vertical, partnering with VP Product to prioritize experimentation roadmap (20+ initiatives/quarter) focused on conversion optimization, resulting in 18% YoY GMV growth (₹900 crore incremental revenue) and 4.5/5 NPS improvement
• Built end-to-end data infrastructure for personalization engine (collaborative filtering + content-based recommendation), processing 50M+ daily events via BigQuery + Apache Kafka, delivering personalized homepage to 10M+ users with <50ms latency and increasing CTR from 2.1% → 6.8% (+224% lift)
• Established analytics best practices (SQL style guide, A/B testing playbook, dashboard design principles) adopted across 30-person Data Science org, reducing onboarding time for new hires from 4 weeks → 1.5 weeks and improving code review quality (bug rate 12% → 3%)
• Presented quarterly business reviews to C-suite (CEO, CFO, CPO) with data-driven recommendations on pricing strategy, inventory allocation, and marketing spend, directly influencing ₹200 crore budget allocation decisions
Why this works:
- ✅ Shows strategic ownership ("Defined analytics strategy," "Partnering with VP")
- ✅ Quantifies scale (₹5,000 crore vertical, 50M+ events/day, 10M+ users)
- ✅ Demonstrates executive influence ("Presented to C-suite," "₹200 crore budget decisions")
- ✅ Shows team leadership ("Established best practices," "30-person org")
Common Resume Mistakes to Avoid
1. Vague Impact Statements
❌ Bad: "Improved sales using data analysis"
- No method (how did you analyze?), no quantification (how much improvement?), no context (which department/product?)
✅ Good: "Increased Flipkart Grocery sales by 12% (₹60 crore incremental revenue) by analyzing customer purchase patterns using RFM segmentation, identifying that 20% of users drive 65% of revenue, and launching targeted email campaigns for high-value segments"
2. Skill Inflation
❌ Bad: Listing "Machine Learning" but only watched YouTube tutorials (recruiter will test you in interview → credibility destroyed)
✅ Good: List skills at appropriate level:
- Proficient (2+ years, used in production): SQL, Python, Power BI
- Intermediate (6-12 months, side projects): Tableau, R, A/B testing
- Beginner (learning, not production-ready): Machine Learning (scikit-learn), Apache Spark
3. Ignoring Job Description
Mistake: Using same resume for every job (data analyst at bank vs e-commerce vs consulting require different skills)
Fix: Customize resume for each application
- Bank job (risk, compliance): Highlight "Regulatory reporting," "Fraud detection," "SQL"
- E-commerce (growth, product): Highlight "A/B testing," "Funnel analysis," "Personalization"
- Consulting (client-facing): Highlight "Stakeholder management," "Executive presentations," "PowerPoint"
Takes 10 minutes to customize, increases interview rate from 5% → 15%+.
4. Typos and Grammar Mistakes
Why it matters: Data analysts must be detail-oriented. Typo = "Can't pay attention to details" → Auto-reject.
Common mistakes:
- "Analized data" (spell-check misses this — should be "Analyzed")
- "Increased sales by 12" (missing unit — 12%? 12 lakhs?)
- Inconsistent tense ("Analyzed... Building... Improved" — use past tense for previous jobs, present for current)
Fix: Use Grammarly (free version catches 90% of errors), have 3 people proofread.
5. Resume Length Mistakes
Fresher (0-2 years): 1 page (no exceptions)
- If resume is 1.2 pages, cut less important projects/bullets (quality > quantity)
Mid-level (2-5 years): 1 page preferred, 2 pages acceptable if every bullet is high-impact
- If 2 pages, make sure page 2 isn't just "filler" (Education, Certifications) — put strongest bullets on page 1
Senior (5+ years): 2 pages acceptable
- Don't exceed 2 pages (recruiters won't read page 3+)
6. Buzzword Overload
❌ Bad: "Synergized cross-functional stakeholder engagement to leverage data-driven insights for paradigm-shifting business outcomes"
- Sounds like ChatGPT wrote it, says nothing concrete
✅ Good: "Collaborated with Marketing and Product teams to analyze A/B test results, identifying that free shipping increases conversion by 19%, leading to ₹3.5 crore revenue lift"
- Clear, specific, quantified
Rule: If you can't explain a bullet to your grandmother, it's too jargon-heavy.
Resume Checklist: Before You Apply
Use this checklist for every application:
ATS Optimization
- [ ] Resume saved as
.pdf(or.docxif JD specifies) - [ ] Standard section headers (Work Experience, Skills, Education)
- [ ] No tables, text boxes, headers/footers
- [ ] Single column layout (no multi-column)
- [ ] Standard font (Arial, Calibri, Times New Roman)
- [ ] Keywords from job description in Skills section (exact matches)
- [ ] Keywords in Experience bullets (tools, methods, domains)
- [ ] Spell-checked (Grammarly + human review)
Content Quality
- [ ] Every bullet uses STAR format (Situation, Task, Action, Result)
- [ ] Every bullet quantifies impact (%, ₹, time saved, users impacted)
- [ ] Action verbs (Analyzed, Built, Reduced, Increased — not "Responsible for")
- [ ] No vague statements ("Improved sales" → "Increased sales by 12%, ₹60 crore")
- [ ] 3-5 bullets per job (not 8+ bullets — recruiter won't read all)
- [ ] Most impressive bullets at top of each section (recruiter reads top → bottom)
Formatting
- [ ] Name at top in largest font (14pt)
- [ ] Contact info on one line (email, phone, LinkedIn, GitHub)
- [ ] Consistent date format (Jul 2023 – Present, not July 2023 - now)
- [ ] Consistent bullet style (all • or all -, not mixed)
- [ ] No orphaned lines (don't split a bullet across pages)
- [ ] Length: 1 page (fresher), 1-2 pages (mid-level), 2 pages (senior)
Final Checks
- [ ] Ran through Jobscan.co → 80%+ match score
- [ ] No typos (read out loud, have 3 people review)
- [ ] File named professionally:
FirstName_LastName_DataAnalyst.pdf(notresume_final_v3.pdf) - [ ] LinkedIn matches resume (recruiters cross-check)
- [ ] GitHub/portfolio linked (if projects mentioned)
Before Applying: Score Your Resume
Use this scoring system (out of 100):
| Criteria | Points | Your Score | |----------|--------|------------| | ATS-friendly format (no tables, standard fonts) | 20 | | | Keywords from JD in Skills section (80%+ match) | 20 | | | Quantified impact in every bullet (%, ₹, time saved) | 20 | | | Specific tools/methods mentioned (SQL, Python, A/B testing) | 15 | | | No typos or grammar mistakes | 10 | | | Professional formatting (consistent dates, bullets, fonts) | 10 | | | File named professionally, saved as PDF | 5 | |
Target: 85%+ (if below, fix weak areas before applying)
⚠️ FinalQuiz error: Missing or invalid questions array
⚠️ SummarySection error: Missing or invalid items array
Received: {"hasItems":false,"isArray":false}