DEEPANRAJ ARUMUGAM

Data Analyst | Power BI | SQL | Excel | Python
Experienced Operations & Quality Professional Transitioning into Data Analytics

Karur, Tamil Nadu, India | +91 89409 91095 | deepanraj.a@outlook.com
LinkedIn: linkedin.com/in/deepanraj-a-data-analyst | GitHub: github.com/deeepanbe | Portfolio: deeepanbe.github.io

Professional Summary

Experienced operations and quality professional with approximately 9 years of experience across mechanical manufacturing QC, pharma QC, and textile export merchandising/QC. Currently transitioning into Data Analytics and BI after building hands-on skills in Power BI, SQL, Excel and Python over the past year. Experienced in operational reporting, data validation, reconciliation, KPI tracking, order/production coordination, quality analysis and cross-functional stakeholder communication. Built portfolio projects covering Power BI RFM analysis, Python exploratory analysis, Tableau dashboarding and Streamlit data visualization.

Core Skills

Power BI · DAX · Power Query · SQL · Excel · Python · Pandas · Data Cleaning · EDA · KPI/MIS Reporting · Data Visualization · RFM Analysis · Tableau · Streamlit · Jupyter Notebook · Business Reporting

Professional Experience

Atlas Export Enterprises — Operations / Quality Control / Textile Export Merchandising

July 2026 – Present · Karur, Tamil Nadu

• Manage purchase-order, quality, merchandising and shipment-coordination activities.
• Coordinate buyer communications, sample approvals, production, inspection and logistics follow-up.
• Maintain operational trackers and validate order, production, inspection and shipment information.

Dakshin Home Fashions — Quality Control / Export Merchandising

March 2021 – June 2026 · Karur, Tamil Nadu

• Supported textile export merchandising and quality-control activities across customer orders.
• Coordinated samples, inspections, production follow-up and shipment documentation.
• Maintained Excel-based operational trackers and status reports.

Lakshmi Life Sciences Ltd — Quality Analyst

February 2019 – January 2020 · Coimbatore, Tamil Nadu

• Tracked quality and compliance information using Excel-based reports.
• Supported data validation and investigated recurring quality issues through trend review.

Sundram Fasteners Limited — Process & Reporting Executive

May 2016 – October 2017 · Chennai, Tamil Nadu

• Compiled and validated production and quality information for reporting.
• Prepared Excel-based reports and supported root-cause/corrective-action follow-up.

Analytics Projects

Customer Segmentation — Power BI RFM

Approximately 235K transaction records analysed using Recency, Frequency and Monetary measures to create customer segments.

IBM HR Attrition Analysis — Python

1,470 employee records analysed. 237 attrition records; 16.1% overall attrition rate.

Digital Marketing Leads Performance — Tableau

2,399 leads analysed. Current documented figures include 995 WhatsApp leads and 446 Instagram leads.

GDP Dashboard — Python / Streamlit

World Bank GDP dashboard covering 1960–2022 with country/year filtering, time-series visualization and GDP metrics.

Hotel Booking Analysis — Python

119,390 bookings analysed. 44,224 cancellations, approximately 37.0%.

Certifications

Google Data Analytics Professional Certificate — Completed
Microsoft Azure Data Fundamentals (DP-900) — Completed
Microsoft Power BI Data Analyst (PL-300) — In Progress

Education

Bachelor of Engineering — Mechanical Engineering
Pavai College of Technology, Anna University | 2016

Target Roles

Data Analyst · MIS Analyst · BI Developer · Power BI Analyst · Operations Analyst · Manufacturing / Supply Chain Analyst

Preferred: Chennai · Bengaluru · Remote