R
ResumeBuilderAI Career Studio
Home/Resume Examples/Data Analyst / Business Intelligence

Data Analyst Resume Example & SQL Project Highlights

Proven Data Analyst resume template with SQL window functions, Python data wrangling, Tableau dashboard metrics, and ATS-tested layout.

A4 Document Preview100% ATS Verified

Ananya Deshmukh

Data Analyst & BI Specialist
+91 98989 12345ananya.deshmukh@example.comPune, Maharashtra, Indialinkedin.com/in/ananya-deshmukhgithub.com/ananya-data

Career Objective / Summary

Data Analyst with 3 years extracting actionable insights from multi-terabyte datasets using Advanced SQL, Python, and Tableau. Proven track record reducing reporting overhead by 12 hrs/week and uncovering retention opportunities that lowered churn by 14%.

Professional Experience

Data Analyst2021-08 – Present
Razorpay FinancialPune, India
  • Engineered automated SQL pipelines on Snowflake and BigQuery, saving 12 manual analyst hours every week.
  • Conducted customer churn cohort analysis identifying 3 key friction points, lowering churn rate by 14%.
  • Designed 8 interactive executive Tableau dashboards monitoring ₹60+ Crores in annual merchant settlements.
  • Collaborated with product teams to design and evaluate 25+ statistical A/B tests on user onboarding.

Academic Qualifications

Course / DegreeCollege / InstitutionBoard / UniversityYearScore / CGPA
B.Sc in Statistics & Computer Science
  • Coursework in Applied Multivariate Statistics, Econometrics, and SQL
Pune University (SPPU)Pune, India2021-0684%

Technical Skills & Competencies

SQL & Databases:PostgreSQL, Snowflake, BigQuery, Window Functions, CTEs, Data Modeling
Python & Analytics:Python (Pandas, NumPy), Tableau, Power BI, A/B Testing, Excel (Power Query)

Key Academic & Professional Projects

Customer Lifetime Value (CLV) Segmentation Engine
Technologies: Python, Pandas, Scikit-learn, Tableau
  • Categorized 150,000 active customer accounts into high-value cohorts, increasing target campaign repeat purchase velocity by 19%.
Declaration: I hereby solemnly declare that all the information provided in this curriculum vitae is true, complete, and correct to the best of my knowledge and belief.
Date: ____________________
Place: ____________________
(Ananya Deshmukh)
Signature
Recommended Template: TRADITIONAL

This layout preserves critical ATS section tags while maintaining ideal visual hierarchy for human recruiters.

Recruiter Analysis

Why This Resume Shortlists for Data Analyst / Business Intelligence Roles

Business Metric & Revenue Attribution

Connects data analysis directly to commercial outcomes: ₹45 Lakhs in cost savings and 14% improvement in customer churn.

Advanced SQL & Data Modeling

Explicitly mentions complex SQL constructs (CTEs, Window Functions, Stored Procedures, Partitioning) that data engineering managers evaluate.

Dual Capability: Visual + Scripting

Demonstrates end-to-end expertise spanning automated Python scripts (Pandas, NumPy) and executive-ready Tableau / PowerBI dashboards.

Keywords Taxonomy

Top ATS Keywords for Data Analyst / Business Intelligence

Database & Querying
Advanced SQLPostgreSQLMySQLSnowflakeBigQuery
Programming & Scripting
Python (Pandas, NumPy, Scikit-learn)RBash
BI & Visualization
TableauPower BIGoogle Looker StudioExcel (Power Query, VBA)
Analytics & Statistics
A/B TestingHypothesis TestingCohort AnalysisETL PipelinesData Cleansing
Google X-Y-Z Formula

Battle-Tested Experience Bullet Points

Click the copy icon on any bullet point to add it directly into your own resume.

• Engineered automated SQL pipelines on Snowflake and BigQuery, updating revenue dashboards daily and saving 12 manual reporting hours per week.

• Conducted customer churn cohort analysis identifying 3 key churn indicators, driving product changes that boosted retention by 14%.

• Designed 8 interactive executive Tableau dashboards monitoring ₹60+ Crores in annual transaction volume for leadership review.

• Partnered with product managers to design and evaluate 25+ statistical A/B tests on landing page conversion.

Common Application Pitfalls

Mistakes Candidates Make When Applying for Data Analyst / Business Intelligence

  • ×Only listing "Excel and SQL" without detailing the complexity (window functions, indexing, automated data pipelines).
  • ×Describing charts and graphs without stating the business decision or revenue impact that resulted from the insight.
  • ×Missing mentions of A/B testing methodologies and statistical significance.
Technical Interview Preparation

Key Interview Questions for Data Analyst / Business Intelligence

Q: Can you write a SQL query to find the 2nd highest salary in each department using Window Functions?
Recruiter Tip: Use DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) in a Common Table Expression (CTE).
Q: How do you determine if an A/B test has reached statistical significance?
Recruiter Tip: Discuss p-values, alpha levels (usually 0.05), sample size calculation prior to test launch, and avoiding false positives from early stopping.

Ready to Build Your Data Analyst / Business Intelligence Resume?

Pre-load this exact layout and bullet points into the editor and tailor it in under 5 minutes.

Explore More Career Resume Examples

Software Engineer
Recruiter-approved Software Engineer resume example with microservices scale, cloud architecture metrics, ATS keywords, and 1-click vector A4 template.
View Example
B.Tech Fresher (CS / IT / ECE)
Strict 1-page B.Tech fresher resume format approved by college Training & Placement (TPO) cells. Standard CGPA tables, SIH hackathons, and LeetCode profile integration.
View Example
Frontend Developer
High-converting Frontend Developer resume with Next.js, React, Core Web Vitals, performance optimization metrics, and ATS-friendly two-column layout.
View Example