Back to Developers
Karthik Kannan

Karthik Kannan

Junior Analyst

Bengaluru, Karnataka, India
85
Profile Score

About

Junior Analyst with nearly 2 years of experience collecting, organizing, and analyzing data from multiple sources to support business decision-making and performance reporting. Demonstrated expertise in Advanced Excel (Pivot Tables, VLOOKUP, Charts), SQL, and Tableau to prepare dashboards, identify trends and patterns, and deliver structured business insights to stakeholders. Achieved 99.7% data accuracy across high-volume datasets, reduced manual reporting effort by 40%, and improved query performance by 60% through systematic data validation, quality checks, and analytical reporting. Adept at collaborating with cross-functional teams, maintaining documentation, and presenting findings in a clear, structured manner aligned to business objectives.

Skills & Expertise (30)

Advanced Excel Intermediate
7.4/10
2
Years Exp
SQL Server Intermediate
7.1/10
2
Years Exp
Python Intermediate
6.9/10
1
Years Exp
T-SQL Intermediate
6.8/10
2
Years Exp
Tableau Intermediate
6.6/10
1
Years Exp
n8n Automation MS Office Suite MS Excel Documentation Stakeholder Reporting Julius AI Business Insights Performance Metrics KPI development Data Profiling Data Quality ETL Pipelines Data Transformation Data Cleaning Predictive Modeling Trend Analysis Statistical Analysis NumPy Pandas Dashboard Development Charts VLOOKUP Pivot Tables Query Optimization Data Validation

Work Experience

Junior Data Analyst

Data Corp Traffic Private Limited

Mar 2024 - Oct 2025

Collected, organized, and analyzed data from multiple sources including SQL Server databases and Excel-based datasets, processing 500+ records weekly and achieving 99.7% data accuracy across all reporting outputs. Prepared 12+ performance dashboards and reports using Advanced Excel (Pivot Tables, VLOOKUP, Charts) and Tableau, reducing manual reporting time by 40% and improving stakeholder visibility into operational KPIs. Identified trends, patterns, and early warning insights from high-volume traffic datasets using SQL and Python (Pandas, NumPy), contributing to a 20% reduction in reported operational incidents. Performed systematic data validation and quality checks across 1,200+ dataset entries, detecting and resolving data inconsistencies to maintain 99.7% accuracy and eliminate weekly manual verification tasks. Supported senior analysts in research and analysis tasks by optimizing SQL Server queries using T-SQL, improving query execution time by 60% and accelerating data delivery for business decision-making. Maintained proper documentation and reporting processes across 6+ concurrent data workflows, ensuring consistent record-keeping and structured reporting aligned to business requirements. Collaborated with internal teams to understand data requirements, delivering clear analytical findings and structured presentations that influenced operational decisions across 3+ business units.

Data Science Intern

Mach IT

Aug 2023 - Jan 2024

Collected and organized 8+ structured datasets from multiple internal sources, applying data cleaning and transformation techniques to achieve 99% data accuracy across all analytical outputs. Prepared analytical reports and performance metrics using Python (Pandas, NumPy) and Excel, supporting senior analysts in research tasks and delivering business insights to 5+ stakeholders. Identified trends and patterns across 50,000+ records through exploratory data analysis (EDA), generating findings that improved forecast accuracy by 12% for marketing and product planning teams.

Education

Bachelor of Computer Applications - Bharathiar University

- 2023 · Afghanistan

Certifications

IBM DA0101EN: Data Analysis with Python

IBM · 2023

Google Analytics Certification

Google · 2023

Introduction to Data Analytics

SkillUp · 2023

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 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (30)

Advanced Excel SQL Server Python T-SQL Tableau n8n Automation MS Office Suite MS Excel Documentation Stakeholder Reporting +20 more