Back to Developers
CHANDRU R

CHANDRU R

Data Analyst

Coimbatore, India 80 · Excellent

About

Data Analyst with hands-on experience building a 3-page Power BI dashboard analyzing 38,576 bank loan records using 31 DAX measures and 16 interactive visualizations, along with a Tableau HR analytics dashboard covering 1,470 employee records. Completed 100+ hours of structured training in SQL, Power BI, Tableau, and MS Excel, delivering 3 end-to-end data projects covering 40,000+ combined records, while currently expanding skills in Statistics and Python. Seeking an entry-level Data Analyst role to apply SQL, dashboard development, and data analysis skills to support data-driven business decisions.

Skills & Expertise (44)

Power BI Advanced
8.5/10
2
Years Exp
Data Visualization Advanced
8.5/10
3
Years Exp
Tableau Advanced
8.0/10
2
Years Exp
Excel Advanced
8.0/10
5
Years Exp
SQL Advanced
7.5/10
3
Years Exp
DAX Intermediate
7.5/10
2
Years Exp
Python Intermediate
6.0/10
2
Years Exp
Data Storytelling Charts Data Validation Excel formulas Data Cleaning Data Wrangling Data Modeling Exploratory data analysis Root-cause analysis Ad-Hoc Reporting Conditional Formatting KPI Reporting Business Intelligence GitHub VS Code Google Sheets MS Word Canva Dashboard Development NULL handling T-SQL Joins GROUP BY ORDER BY Aggregate Functions Subqueries CTEs Window Functions MS SQL Server Deduplication MySql Power Query Dashboards Time intelligence Pivot Tables VLOOKUP HLOOKUP

Work Experience

Data Analyst

Bank Loan Analysis Dashboard

Present - Present

Built a 3-page interactive Power BI dashboard analyzing 38,576 loan applications, featuring 5 KPI cards, 16 visualizations, and 7 interactive slicers to monitor Total Applications, Funded Amount, Amount Received, Interest Rate, and Debt-to-Income (DTI) Ratio. Created 31 DAX measures to support Month-to-Date (MTD), Month-over-Month (MoM), and KPI calculations for comprehensive loan portfolio analysis. Built interactive visualizations, including state-wise maps, loan purpose analysis, employment trends, and Good Loan vs. Bad Loan segmentation to uncover lending patterns and support data-driven decision-making. Implemented drill-down capabilities, cross-page navigation, and interactive filtering to enhance dashboard usability and enable efficient exploration of loan performance metrics. Identified Grade G loans as having the highest Bad Loan rate (31.3%), highlighting a high-risk borrower segment for underwriting review and portfolio risk assessment.

Data Analyst

HR Analytics Dashboard

Present - Present

Built an interactive Tableau dashboard analyzing 1,470 employee records, featuring 5 KPI cards to monitor Employee Count, Attrition Count, Attrition Rate, Active Employees, and Average Age. Created 8 interactive visualizations, including department-wise attrition, education field analysis, employee age distribution, job satisfaction matrix, gender-based attrition, and histogram analysis to identify workforce trends. Configured 3 interactive parameters/filters to enable user-driven analysis across education levels, age groups, and employee demographics. Identified the 25–34 age group as having the highest employee attrition, highlighting the need for targeted retention strategies, including mentorship and career development programs, to support workforce planning. Projected potential attrition-related hiring cost savings of ~15–20% if targeted retention actions were applied to the identified 25–34 age group, based on average replacement cost benchmarks.

Database Developer

Library Management System

Present - Present

Designed and implemented a normalized relational database with 6 interconnected tables using primary keys, foreign keys, and cascading deletes to maintain referential integrity. Developed 15+ SQL queries across 6 tables using JOINs, GROUP BY, HAVING, subqueries, and aggregate functions, reducing manual lookup time for borrowing/inventory reports by an estimated 70%. Extended the database schema by introducing branch relationships to support employee reporting without affecting existing data integrity. Analyzed branch-level operations using SQL JOINs and aggregation functions to generate reports on employee distribution and support library resource planning.

Education

B.E. — Computer Science and Engineering - Bannari Amman Institute of Technology

2021 - 2025 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
✅ Verified 5/5
Total Score 80/100

Profile Overview

Member sinceOct 2026

Availability Details

Relocation

Open to Relocation