☁️

> Hello, World! 👋

Jeevika M R

Discover. Analyze. Visualize. Deliver.

Data Analyst with 1.5+ years of experience transforming complex data into actionable business insights. Skilled in SQL, Power BI, Python, and Excel, with expertise in KPI reporting, dashboard development, data quality management, and end-to-end data warehousing. Currently pursuing an Executive PG Certification in Data Science & AI from iHub IIT Roorkee.

Jeevika M R pixel avatar

About Me

📊 Who I Am

I'm a Data Analyst based in Madurai, Tamil Nadu, with 1.5+ years of experience transforming data into actionable business insights. My background in Biotechnology sparked a curiosity for solving complex problems, which led me to pursue a career in data analytics.

At Regenesys Business School and Edunet Foundation, I have built KPI dashboards, improved CRM data quality, and analyzed operational performance to support informed business decisions. Using SQL, Power BI, Python, and Excel, I turn complex datasets into clear, meaningful insights for stakeholders.

🛠 My Toolkit

📂 Languages & Databases
SQL Python MS SQL Server MySQL
📊 BI & Visualization
Power BI DAX Power Query Looker Studio
📋 Spreadsheets & Reporting
Excel XLOOKUP Pivot Tables MIS Reporting KPI Dashboards
🔬 Analytics & Methods
EDA ETL / SSIS Data Modeling Star Schema Customer Segmentation Root Cause Analysis Data Governance Machine Learning
🐍 Python Libraries
pandas NumPy scikit-learn matplotlib seaborn

Projects

🏦
SQL · Python · Power BI

Banking Portfolio & Loan Risk Insights

End-to-end banking analytics on a $2.6B loan portfolio and $1.75B in deposits. Identified 482 high-risk customers, monitored a 148.4% loan-to-deposit ratio, and built customer segmentation insights for credit risk assessment.

🗄️
MS SQL Server · ETL · SSIS

End-to-End Sales Data Warehouse

Built a 3-layer Medallion Architecture (Bronze-Silver-Gold) SQL Server data warehouse processing 116K+ records across 6 ERP/CRM tables. Authored 10+ analytics queries with window functions and CTEs for YoY trends and segmentation.

🛍️
Python · scikit-learn · K-Means · PCA

Retail Customer Segmentation (EY × AICTE)

Segmented 10,000+ UK retailer customer records using K-Means clustering and PCA. Built RFM features, a product recommendation engine, and delivered insights contributing to 15% higher engagement and 12% better campaign conversion.

🖥️
MySQL · Power BI · DAX · Power Query

Sales Insights Dashboard — Atliq Hardware

Designed a sales insights dashboard for a pan-India hardware company using MySQL for data analysis and Power BI for visualization. Built a star schema data model, performed ETL using Power Query, and created DAX measures to monitor revenue, profit margins, and regional sales trends. The solution was designed to reduce manual reporting efforts and support faster, data-driven decision-making across sales operations.

🛒
Power BI · DAX

Blinkit Grocery Analytics Dashboard

Analyzed BlinkIT quick-commerce data across $1.20M in sales, 8,523 items, and an avg. rating of 3.9. Built a Power BI dashboard covering KPIs, fat-content trends, product category popularity, and outlet-level performance to optimize service strategy.

MySQL · Power BI · Market Research

CodeX Energy Drink — Consumer Survey Analysis

Analyzed a 10,000-respondent survey across 10 Indian cities for a German beverage brand entering India. Used MySQL for demographic and behavioral queries and Power BI for multi-page dashboards covering brand penetration, purchase behavior, competition analysis, and product development recommendations.

Work Experience

NOV 2024 – MAR 2026

Quality Analyst — CRM Analytics & Reporting

Regenesys Business School · Remote

  • Analyzed CRM and operational data using Looker Studio and Excel to develop MIS reports and track KPIs across cross-functional teams.
  • Built interactive dashboards for real-time monitoring of compliance metrics and operational performance.
  • Improved CRM data accuracy by 25% through systematic validation, quality audits, and root cause analysis.
  • Gathered requirements from Sales and Ops teams, translating business needs into reporting specifications under data governance standards.

FEB 2024 – APR 2024

Data Analyst Intern

Edunet Foundation – EY GDS & AICTE · Remote

  • Segmented 10,000+ customer records using Python (pandas, scikit-learn), PCA, and K-Means clustering.
  • Performed data cleaning, preprocessing, and feature engineering to improve model accuracy.
  • Delivered insights contributing to 15% higher customer engagement and 12% better campaign conversion.

Certifications

🐍

Python Certification

DataCamp

Jul 2025

▶ View Cert
🗃️

SQL Certification

HackerRank

Dec 2024

▶ View Cert
📊

Microsoft Power BI for Desktop Intelligence

Udemy

Nov 2023

▶ View Cert
🧮

Excel Skills for Business

Macquarie University Via Coursera

Nov 2023

▶ View Cert
📈

Google Data Analytics Professional Certificate

Google Via Coursera

Jul 2023

▶ View Cert
🎓

Executive PG — Data Science & AI

iHub IIT Roorkee

Nov 2025 – Present

⏳ In Progress

Blog

🗄️
SQL · Data Warehouse · Beginner Guide

I Built an End-to-End Data Warehouse Using SQL

A beginner-friendly walkthrough of building a Medallion Architecture (Bronze-Silver-Gold) data warehouse in SQL Server — from raw data ingestion to analytics-ready star schema.

▶ Read on Medium →
SQL · Power BI · EV Market

Electric Vehicles Insights India — A Data Analytics Case Study

Analyzed India's EV market across 10 cities using 30+ SQL queries and a multi-page Power BI dashboard — covering EV adoption by state, CAGR trends, penetration rates, and strategic recommendations for Atliq Motors.

▶ Read on Medium →
Excel · Dashboard · Power Query

Coffee Shop Sales Analysis: A Step-by-Step Guide to Creating a Data-Driven Dashboard Using Excel

A complete walkthrough — from Power Query data cleaning, pivot tables, slicers and DAX measures, to a fully customized dashboard tracking sales by hour, day, product category, and store location.

▶ Read on Medium →
🧹
Data Cleaning · Python · Excel · SQL

Mastering Data Cleaning: 8 Essential Steps Every Aspiring Data Analyst Should Know

A practical guide to the 8 non-negotiable data cleaning steps — removing duplicates, handling nulls, fixing structural errors, managing outliers, ensuring consistent types, and validating integrity across Excel, Python, and SQL.

▶ Read on Medium →

Resume

📄

Download My Resume

1.5+ years in SQL, Power BI, Python & CRM Analytics. Open to Data Analyst, Business Analyst & BI Analyst roles.

⬇ Download Resume

(PDF · Last updated Jun 2026)

Contact