Logeshwaran A — Data Analyst

analyst_db — query.sql

CONNECTED

›

Executing query against analysts table... 0%

result set

column	value	type
name	Logeshwaran A	VARCHAR
role	'Data Analyst'	VARCHAR
location	'Chennai, India'	VARCHAR
experience_yr	1.25	DECIMAL
reports_automated	8+	INT
time_saved_pct	60%	INT
status	'open_to_roles'	ENUM

7 rows returned · analysts table ⚡ 0.003 sec

›

SQL · Python · Power BI 1+ yr experience Open to roles

View my work logesh17799@gmail.com

01 / WHO I AM

Analyst. Builder. Communicator.

bio

I'm a data analyst based in Chennai with over a year of experience building analytics pipelines, KPI dashboards, and segmentation models that actually get used. I've worked across e-commerce, OTT, and financial domains — writing SQL against production databases, building Power BI dashboards that cross-functional teams open every morning, and automating reports that used to eat hours every week. I care about accuracy, stakeholder communication, and making analysis that drives decisions — not just fills slide decks.

live stats

reporting time saved at Greensoft

recurring reports automated

Power BI dashboards in daily use

max records in a single analysis

github.com/Log-ware

SQL · Python · Power BI projects

02 / TECH STACK

Skills schema

What I've shipped

PROJECT_001 · Jan 2025 COMPLETE

Retail Sales Performance Dashboard

Cleaned and transformed 30,000+ sales records across 6 regional sources using Power Query. Built dynamic dashboards tracking revenue trends, product performance, and regional KPIs. Identified the bottom 15% of underperforming segments — recommendations adopted into the next planning cycle.

30K+

records processed

regional sources

15%

segments flagged

ExcelPower QueryPivot TablesINDEX-MATCHSUMIFS

PROJECT_002 · Mar 2025 COMPLETE

E-Commerce Sales Analysis

Optimised SQL queries across a 6-table database with 50,000+ order records. Surfaced a 12% MoM AOV decline — flagged immediately for marketing action. Cohort analysis revealed the top 20% of users drove 65%+ of revenue, directly shaping retention strategy.

50K+

order records

−12%

AOV decline caught

65%+

revenue from top 20%

SQLCTEsWindow FunctionsCohort Analysis

PROJECT_003 · Jun 2025 COMPLETE

Credit Risk & CLV Analysis

End-to-end pipeline integrating SQL, Python, and Power BI to evaluate credit risk and model CLV across 5,000+ customer records. RFM-based segmentation classified customers into 4 value-risk tiers — enabling 30%+ more targeted outreach than prior rule-based methods.

5K+

customer records

value-risk tiers

30%+

outreach improvement

PythonSQLPower BIDAXRFMCLV

04 / EXPERIENCE

Where I've worked

Nov 2024
— Feb 2026

Trichy, TN

Data Analyst

Greensoft Groups

Automated 8+ recurring business reports using Python and SQL, cutting manual reporting time by ~60% and removing a critical bottleneck from weekly operations.
Built and maintained 3 Power BI dashboards and data models used daily by cross-functional teams; documented all pipelines, reducing analyst onboarding time by ~50%.
Translated requirements from 4+ business departments into data-driven dashboards and analyses, directly informing resource allocation and operational decisions.

05 / BACKGROUND

Education & certifications

education

B.E. Computer Science and Engineering

SRM Valliammai Engineering College

Aug 2021 – Jun 2025 · CGPA 8.0 / 10

XII Standard

Sri Ramakrishna Matric Higher Secondary School

Mar 2021 · Score: 95%

certifications

Advanced SQL

Besant Technologies · 2025

Power BI

Besant Technologies · 2025

Data Analysis with Python

Besant Technologies · 2025

Advanced Excel

Besant Technologies · 2025

Analyst. Builder. Communicator.

Skills schema

What I've shipped

Where I've worked

Education & certifications

Let's make datado somethinguseful.

Let's make data
do something
useful.