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)
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.
Similar Profiles
Pankaj NathPankaj Nath
Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)
Adibus SholehAdibus Sholeh
Solution Architect at PT NTT Indonesia Technology (NTT DATA)Solution Architect at PT NTT Indonesia Technology (NTT DATA)
GAZI MAMOONUR ALAMGAZI MAMOONUR ALAM
SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)
Yashika SureshbabuYashika Sureshbabu
Service Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT DataService Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT Data
Vishnu Priyan CVishnu Priyan C
Assistant Lead Engineer - R&D at Vestas Technology R&D LtdAssistant Lead Engineer - R&D at Vestas Technology R&D Ltd