Anwar M
Data Analyst
Chennai
Summary
Data Analyst with 1+ year of experience in data-driven decision-making, automation, and ML-based insights. Skilled in Python (Pandas, scikit-learn), SQL, Power BI, and Excel. Enthusiastic about AI applications in real-world business and operations.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
1
1
Certificate
Work History
HC & Insurance Operations Associate
NTT Data
07.2024 - 07.2025
- Automated ETL pipelines using Python (Pandas, NumPy) and SQL, reducing manual data processing effort by 95% , and boosting operational throughput and data availability.
- Developed and deployed Power BI dashboards for real-time monitoring of production metrics , error rates, and resource utilization, enabling data-driven decisions across 5 projects.
- Conducted financial data analysis , ensuring 100% data integrity in P&L reports and budget tracking for multi-project environments.
- Performed descriptive and exploratory data analysis (EDA) on production data to identify bottlenecks and inefficiencies, reducing error rates and improving SLA adherence — using Pandas , Matplotlib , and Seaborn for visualization and trend analysis.
- Designed and maintained relational databases for team demographics, production KPIs, and compliance metrics using SQL, ensuring scalable and query-optimized data storage.
- Implemented data validation workflows for time entry and attendance tracking systems , improving accuracy using statistical anomaly detection logic built with Python.
- Created custom reporting solutions and actionable business insights using DAX, and Power Query for leadership and client stakeholders.
Data Analyst Internship
Ashik Lights
02.2022 - 07.2022
- Designed and implemented an end-to-end data pipeline by integrating data from Tally ERP , Excel spreadsheets, and local retail software into a centralized relational database , ensuring consistency and enabling unified analytics.
- Utilized pandas and NumPy to clean, transform, and merge multi-source datasets (sales, purchases, returns, and product catalogs), significantly enhancing data quality and reliability for analysis.
- Performed exploratory data analysis (EDA) using matplotlib and seaborn to uncover trends in: Best-selling and underperforming products. Seasonal and regional sales patterns. Return rates and pricing strategies
- Engineered new features from raw data (e.g. product lifecycle status, discount frequency, sales velocity) to enrich insights and improve reporting granularity .
- Applied RFM (Recency, Frequency, Monetary) analysis to score customer purchasing behavior and used K-Means clustering from scikit-learn to segment customers into actionable cohorts (e.g. loyal, at-risk, high-value).
- Developed data-driven dashboards and summary reports to guide inventory planning, marketing targeting, and vendor negotiations — increasing visibility for non-technical stakeholders.
- Conducted correlation analysis and hypothesis testing to validate pricing strategies, return drivers, and product bundling effectiveness.
- Collaborated cross-functionally with sales, marketing, and accounts teams to translate analytical insights into business decisions, contributing to:
10–15% increase in cross-sell effectiveness
Reduced stock-outs by aligning inventory with demand patterns - Documented the project end-to-end in a well-structured Jupyter Notebook , combining code, visuals, and interpretations — aiding reproducibility and stakeholder review.
Accounts Executive Cum Sales
LEDLUM Lighting Solutions LLP
04.2017 - 04.2019
- Managed and analyzed sales, inventory, and operations data across departments, preparing detailed reports that influenced purchasing, logistics, and customer strategies.
- Developed and maintained Excel-based dashboards and financial models to track sales performance, client payments, inventory turnover, and return rates.
- Analyzed accounts receivable data , identified overdue payments, and implemented data-driven strategies that improved collections and client retention.
- Designed structured reporting workflows for returns, order processing, and logistics using tools like Excel PivotTables , formulas, and macros to improve efficiency and reduce errors.
- Generated monthly performance reports using structured datasets from ERP systems and delivered insights that helped improve supply chain coordination and order accuracy.
- Conducted root cause analysis on sales returns and documented patterns to support data-backed inventory decisions and reduce recurring issues.
Accounts Executive
Abba Lighting Solution
05.2016 - 03.2017
- Analyzed financial transactions and monthly ledgers using Excel to identify spending trends, laying the foundation for data-driven budgeting and reporting practices.
Education
Master of Science - Data Science
Loyola College
Chennai, India 04.2020 - 07.2022
Bachelor of Science - Mathematics
Hindustan College of Arts & Science
Chennai, India 04.2013 - 04.2016
Skills
Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn)
SQL
Excel
Power BI
Data Cleaning & Preprocessing
ETL & Data Engineering
Exploratory Data Analysis (EDA)
Statistical & Predictive Analytics
Timeline
Mastering Power BI from NTT Skillsoft
09-2024
HC & Insurance Operations Associate
NTT Data
07.2024 - 07.2025
Data Analyst Internship
Ashik Lights
02.2022 - 07.2022
Master of Science - Data Science
Loyola College
04.2020 - 07.2022
Accounts Executive Cum Sales
LEDLUM Lighting Solutions LLP
04.2017 - 04.2019
Accounts Executive
Abba Lighting Solution
05.2016 - 03.2017
Bachelor of Science - Mathematics
Hindustan College of Arts & Science
04.2013 - 04.2016
Certification
Mastering Power BI from NTT Skillsoft
Declaration
I hereby declare that the above information is true to the best of my knowledge. I am currently seeking suitable opportunities and would sincerely appreciate any referrals.