Gnanasekar G.
Data Analyst · Portfolio
Portfolio — Data Analyst

GnanasekarG.

Data Analyst  ·  SQL  ·  Power BI  ·  Excel  ·  Python

Analytical professional specialising in transforming raw data into business intelligence. Experienced in customer churn modelling, sales performance analytics, and interactive dashboard development.

GG
Open to Opportunities
7K+
Customer Records
Analysed
26.6%
Churn Rate
Identified
₹13M
Sales Data
Modelled
4+
Professional
Certifications
01.

Skills & Competencies

SQL — Joins, Group By, Aggregations 85%
Microsoft Excel — Pivot, XLOOKUP, Cleaning 88%
Power BI — Dashboard Development 75%
Python — Pandas & NumPy 65%
Statistics — Descriptive & Correlation 78%
Data Cleaning & Transformation 82%
SQL Excel Power BI Power Query Python Pandas NumPy Pivot Tables XLOOKUP Joins Aggregations Descriptive Stats Data Modelling CLV Analysis Churn Analysis
🔍
SQL Analytics
Complex joins, aggregations, GROUP BY, subqueries for data extraction
📊
Dashboard Design
Interactive Power BI & Excel dashboards with dynamic filtering
🧹
Data Wrangling
Cleaning, transforming and preparing large datasets for analysis
📈
Business Insight
Translating data patterns into actionable business recommendations
🐍
Python Analysis
Exploratory data analysis using Pandas and NumPy libraries
📐
Statistics
Descriptive statistics, correlation analysis and trend identification
02.

Professional Experience

01
Data Analyst Intern
Cybernaut EdTech
2025 — Present  ·  Karur, Tamil Nadu
  • Cleaned and transformed real-world datasets using Excel and SQL, ensuring data integrity for downstream analysis
  • Authored SQL queries incorporating JOIN, GROUP BY, and aggregation functions to extract meaningful business insights from structured databases
  • Developed interactive dashboards in Excel and Power BI to track and visualise key business performance indicators
  • Identified statistically significant trends within customer and sales datasets to support evidence-based decision making
  • Collaborated on analytical workflows producing reports that informed stakeholder strategy and retention planning
SQL Excel Power BI Data Cleaning Dashboard Development Trend Analysis Stakeholder Reporting
03.

Analytical Projects

Customer Analytics · SQL & Excel
Customer Churn Analysis & Retention Insights

"High churn is driven by low-tenure, month-to-month customers — indicating weak commitment and elevated switching behaviour."

7,000+
Records Analysed
26.6%
Churn Rate
0–1yr
High-Risk Tenure

Conducted end-to-end analysis of 7,000+ customer records to identify a 26.6% churn rate — highest among month-to-month contract holders. Identified primary drivers including low tenure and specific payment methods. Designed an interactive dashboard to visualise risk-level segmentation, supporting CLV improvement and targeted retention campaigns.

SQLExcel JoinsAggregations DashboardCLV Analysis
Sales Analytics · Power BI
Global Retail Sales Performance Dashboard

"Profitability is undermined by loss-making sub-categories despite strong headline sales — revealing inefficiencies in pricing and cost management."

₹13M
Total Sales
₹1.47M
Profit
12%
Margin

Engineered a comprehensive Power BI dashboard analysing ₹13M in global retail sales across multiple regions. Applied Power Query for data cleaning and relationship modelling. Surfaced top-performing products alongside loss-making sub-categories, enabling dynamic regional filtering and facilitating data-driven pricing and inventory decisions.

Power BIPower Query Data ModellingKPIs Regional Analysis
04.

Education & Certifications

🎓
Bachelor of Science — Mathematics
Government Arts College (Autonomous), Karur
2022 – 2025  ·  Tamil Nadu
CGPA: 7.28 / 10
📚
Higher Secondary Certificate (HSC)
Municipal Boys Higher Secondary School, Karur
2019 – 2020  ·  Tamil Nadu
64.5%
🏅
Professional Data Analytics Program
Cybernaut EdTech
🏆
Data Analytics Job Simulation
Deloitte · Forage
💻
SQL Basics Certification
HackerRank
🐍
Python Basics Certification
HackerRank
05.

Contact & Connect

Open to full-time Data Analyst roles and freelance analytics projects. I am available immediately and happy to discuss how I can contribute to your team.

GG
Gnanasekar G
Data Analyst · Cybernaut EdTech
Open to Opportunities
7K+
Records
2
Projects
4+
Certs