Md Pandian

Results-driven Data Analyst with 10+ years of experience in business intelligence, dashboard development, reporting automation and process analytics. Specialized in building scalable reporting solutions using Microsoft Power BI, SQL, Python and Microsoft Excel. Experienced in transforming business requirements into actionable insights through advanced analytics and BI solutions.

Quality Analyst | Data Analyst - Business Excellence - Infosys BPM

(2024-07)

• Designed and deployed interactive dashboards in Microsoft Power BI for SLA, productivity and quality metrics, improving decision turnaround by 40%.
• Built end-to-end ETL pipelines using SQL, Power Query and Python to automate multi-source data integration.
• Developed DAX measures, calculated columns and custom KPIs to track operational performance across business units.
• Performed exploratory data analysis and trend analysis to identify productivity gaps and risk patterns.
• Automated recurring reporting workflows, reducing manual effort by 60% and improving data freshness.
• Implemented row-level security, validation logic and governance standards for secure reporting.
• Partnered with stakeholders to translate business requirements into scalable BI solutions.

Quality Specialist | Data Analyst & Business Excellence - Infosys BPM

(2022-10 - 2024-06)

• Built reporting automation frameworks using Power BI, SQL, Python and Excel.
• Automated data cleaning and transformation workflows using Python Pandas.
• Improved dashboard performance through query tuning and optimized datasets.
• Created business performance scorecards for process monitoring.
• Developed predictive indicators for performance risk identification.
• Improved productivity from 80% to 93% using data-driven process improvements.
• Supported stakeholders with analytics reports, trend analysis and operational insights.

Team Lead | Business Intelligence Analyst - Avon Solution & Logistics Pvt. Ltd.

(2018-01 - 2022-09)

• Built logistics and finance dashboards using Power BI and Excel.
• Designed SLA monitoring dashboards for shipment tracking and delivery analysis.
• Automated reporting processes reducing turnaround time by 25%.
• Created trend reports and analytical dashboards for cost optimization.
• Performed operational data analysis to improve service quality.
• Reduced operational costs by 15% through analytics-based recommendations.
• Developed centralized reporting structures integrating Excel and SQL datasets.

MIS Analyst - Avon Solution & Logistics Pvt. Ltd.

(2016-01 - 2017-12)

• Managed business reporting using advanced Excel and SQL.
• Automated MIS reports and reduced reporting errors.
• Created analytical reports for inventory, service quality and planning.
• Conducted data audits, reconciliation and validation processes.

M.Sc. - Computer Science & Information Technology - Madurai Kamaraj University