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}