DATA ANALYST MUMBAI, INDIA
Abdul Rehman Ansari
Data Analyst
SQL | Power BI | Excel | Python
I work with customer, financial and operational data to build analysis, dashboards and business reports.
Based in Mumbai, India
SELECTED WORK
Projects built around
business questions.
Each case study shows the question, data, analytical steps and key findings.
01Financial analytics / Internship
Bluestock Mutual Fund Analytics Platform
Compare mutual-fund performance, investor activity and portfolio allocation across schemes and benchmark data.
40 schemes10 fund houses217M SIP contributions
02Customer analytics
Customer Behaviour Analytics
Compare shopping behavior and customer segments by product category, age group and subscription status.
3.9K customers$59.76 average purchase3.75 average review rating
03Operational analytics / Internship
Airline Operations Analytics
Examine passenger demand, route activity, carrier performance and load-factor patterns across airline operations data.
187M passengers3M flights1,152 cities
04Business intelligence / Sales analytics
Sales Performance Analytics Dashboard
Review revenue, profit and product performance across customer segments, countries and time trends.
118.73M total sales16.89M total profit14% profit margin
05Sales and business analytics
Ferns & Petals Business Analytics
Compare order, revenue, profit and occasion patterns across months, products and cities.
1,000 orders3,521K revenue704K profit
EXPERIENCE
Analytics in
working contexts.
Internships across financial analytics and airline operations reporting.
01
Jun 2026 - Jul 2026 Remote
Financial Analyst
Bluestock
Analyzed mutual-fund and investor data to examine investment allocation, fund performance and behavior across segments.
- Cleaned and analyzed mutual-fund, NAV, transaction and scheme-performance data with Python/Pandas and SQL.
- Built a MySQL data layer for recurring analysis and reporting; compared fund performance with NIFTY 50 data.
- Analyzed 40 schemes across 10 fund houses and developed Power BI dashboards for fund performance, investor activity and portfolio allocation.
02
Apr 2026 - Jun 2026 Remote
Data Analyst
AiVariant
Analyzed airline passenger and flight data to examine demand, route activity, carrier performance and load-factor patterns.
- Worked with airline data covering 187M passengers and 3M flights across 1,152 cities and 6 operating regions.
- Used SQL and Advanced Excel to filter, aggregate, validate and compare carriers, regions, flight types and weekday/weekend periods.
- Built Power BI reports for passenger volume, flight activity, load factor, carrier performance and route trends.
ANALYTICS TOOLKIT
Tools I use
in the work.
Grouped by how the tools appear across my experience and project work.
Core analytics
Power BI and reporting
Analysis methods
Additional tools
LEADERSHIP & CAMPUS EXPERIENCE
Coordination and
event operations.
College roles alongside my Information Technology degree.
2024 - 2026
Technical & Logistics Head
KC College Organizing Committee
Led event operations and technical execution.
2025
Placement Cell Member
KC College
Managed on-campus hiring initiatives and coordinated communication between students and industry partners.
EDUCATION & CREDENTIALS
Study and
formal learning.
Degrees, certifications and additional analytics training.
Jul 2026 - Apr 2028
Master's Degree, Business Analytics
HSNC University, Mumbai
Jul 2023 - Apr 2026
BSc-IT, Information Technology
KC College
Grade: 9.18Certifications
Data Analyst
ExcelR Jun 2026
Certificate Program in Data Analyst
nasscom Jun 2026 Credential ID: FSP/2026/6/10305574
Data Analyst - Big 4 Ready
OneRoadmap Jun 2026 Certificate ID: CERT-003A0D99
ADDITIONAL TRAINING
AI-Augmented Data Analysis
Department of Data Science and Business Analytics, HSNC University 2-credit, 30-hour course covering Excel analysis, data preparation, prompt design, insight generation and AI-assisted dashboards.
WORKING APPROACH
Start with the
business question.
How I move from a question to a report.
My work spans mutual funds, customer behavior, sales and airline operations. At Bluestock, I analyzed scheme, NAV and investor data, built a MySQL data layer and developed Power BI reporting. At AiVariant, I used SQL and Excel to examine passenger and flight patterns and built operational reports. I start with the business question, inspect and validate the data, then compare patterns in SQL, Python or spreadsheets before presenting the result in a dashboard or report. I am seeking entry-level Data Analyst, BI Analyst, Business Data Analyst, Reporting Analyst or Business Analyst roles.
OPEN TO ANALYTICS ROLES
Hiring for an
analytics role?
Open to entry-level Data Analyst, BI Analyst, Business Data Analyst, Reporting Analyst and Business Analyst roles.