Portfolio - SENTHAMILAN A

2

Excel
Projects

1

PowerBI
Project

1

SQL
Project

About

Hi! I'm an aspiring Data Analyst with a strong passion for turning data into meaningful insights. Though I come from a Mechanical Engineering background, I discovered my true calling in data analysis—where problem-solving, logic, and curiosity come together.

I may not have corporate experience yet, but I’ve built several business-focused projects using Excel, Power BI, SQL, and Python, all of which you’ll find in my portfolio below. These projects reflect how I think, how I solve problems, and how I turn raw data into real insights that can support better decisions.

I'm always learning, improving, and excited to bring data to life. If you're looking for someone who’s driven, analytical, and eager to grow in a real-world setting—I’d love to be that person. Let’s connect!

Key

Skills

Excel

Power BI

SQL

DAX

Power Query

Data Visulaization

Exploratory Data Analysis (EDA)

Forecast Accuracy & Error Analysis

P&L and Gross Margin Analysis

Ad-hoc Reporting

My

Projects

Atliq Hardware Financial Analytics

Domain/Function: Advanced Excel

Built an Excel dashboard analyzing $600M+ revenue across 23 markets. Identified GM% drop & $54.9M shortfall using conditional formatting, sparklines & P&L trends. Delivered insights on margin erosion & underperforming regions.

Atliq BI Insights 360 – End-to-End Business Performance Dashboard

Domain/Function: Power Bi

Built Power BI dashboard analyzing $3.74B sales, uncovering -13.98% Net Profit Margin. Identified freight/SG&A spikes, forecast errors, and market gaps using KPI visuals, drilldowns, and storytelling.

SQL Ad-Hoc Business Insights for Atliq Hardware

Domain/Function: Business Analytics / Sales Analytics

Solved 10 real-world business problems for a hardware company using SQL. Identified trends in sales, product growth, discount patterns, and channel performance, backed with insights and visuals for data-driven decision-making.

Business Strategy Toolkit: Prioritization Matrix & Financial Scenario Planner

Domain/Function: Strategic Planning /Financial Analysis

Built a dynamic Excel toolkit with two decision-making tools—one to prioritize strategic projects, and another to simulate profit impact under different cost/revenue scenarios.

My

Experience

📊 Technical Support Analyst – Data Operations (Banking Domain)

Hectadata, Bangalore – Jan 2024 – Jan 2025
Pointel, Chennai – Aug 2022 – Jan 2024

Created and automated daily, weekly, and monthly reports using SQL and Excel, supporting real-time analysis of trade settlements and payment flows across multiple legal entities.
Collaborated with cross-functional teams to gather business data and develop ad hoc data pipelines, improving turnaround time for reconciliation and accounting reports.
Performed data validation and reconciliation between systems to detect mismatches in trade and payment records — directly impacting compliance and reducing financial discrepancies.
Leveraged Oracle SQL to extract and analyze large volumes of transactional data, helping the business identify bottlenecks and improve the accuracy of MIS reporting.
Interpreted batch job logs and supported issue resolution by identifying root causes behind delayed or failed financial operations, ensuring minimum downtime and operational accuracy.
Delivered actionable insights to the operations team, contributing to a 20% reduction in incident resolution time and 99%+ system uptime through proactive support practices.