poonam. chettiar

poonam. chettiar

Data Analyst | MIS Analyst
India

نبذة عني

**Profile Summary**

Data Analyst with over 4 years of experience in Management Information Systems (MIS), data analysis, reporting, and business intelligence. Skilled in transforming raw data into meaningful insights us…

الخبرة

MIS Analyst (Data Analysis & Reporting)

Trontek Electronics Ltd. · Noida , Uttar Pradesh , India
Jun 2025 - حتى الآن · 1 سنة 4 أشهر

<p>5+ interactive Power BI dashboards developed and maintained to analyze Channel Sales, OEM Sales, Inventory, Procurement, and Business KPIs, enabling management to monitor performance and make data-driven decisions through real-time reporting.</p><p> 7+ recurring MIS reports (Daily, Weekly, and Monthly) delivered by extracting and transforming Channel Sales, OEM Sales, Inventory, and Procurement data from SAP for management performance tracking.</p><p> ~40% reduction in manual reporting time achieved by designing and automating recurring business reports using Advanced Excel, Pivot Tables, XLOOKUP, INDEX-MATCH, and Power Query.</p><p> Performed comprehensive analysis of Sales Performance, Inventory Movement, Procurement Status, and Order Fulfilment, identifying business trends and providing actionable insights to support strategic planning.</p><p> Partnered with Sales, Procurement, Finance, Warehouse, and Operations teams to gather business requirements, develop analytical reports, resolve reporting issues, and deliver accurate management dashboards.</p>

MIS Analyst

Ganga Roller Flour Mills Pvt. Ltd.
Mar 2024 - May 2025 · 1 سنة 2 أشهر

<p>3–4 manufacturing units/plants monitored through interactive Power BI and Advanced Excel dashboards tracking Production, Dispatch, and Inventory KPIs, improving operational visibility.<br>
Collected, validated, and analyzed production, dispatch, inventory, and warehouse data from multiple sources to prepare accurate daily, weekly, and monthly MIS reports for operational and management review.<br>
Designed and automated production and operational MIS reports using Pivot Tables, Power Query, INDEX-MATCH, and dynamic templates to streamline reporting workflows and improve accuracy.<br>
Performed detailed analysis of Production Output, Dispatch Performance, Inventory Utilization, and Operational KPIs, collaborating with Production, Warehouse, Purchase, and Quality teams for operational improvement.</p>

MIS Executive

East Bound Ventures
Jul 2022 - Feb 2024 · 1 سنة 7 أشهر

<p>Prepared and maintained daily, weekly, and monthly MIS reports using Advanced Excel and Google Sheets, providing accurate business reports and performance summaries for management review.<br>
Designed and automated business reporting processes using Google Sheets, Google Apps Script, Pivot Tables, XLOOKUP, INDEX-MATCH, and advanced Excel formulas, reducing manual effort and improving reporting efficiency.<br>
Performed data cleansing, validation, reconciliation, and analysis to maintain data accuracy and support reliable business reporting across multiple operational functions.</p>

المهارات

Advanced Excel Macros Data Cleaning Data Visualization MySQL Joins Window Functions Aggregate Functions Power BI DAX Power Query Data Validation Python Tableau MIS Reporting Google Sheets Google Apps Script SAP Automation Business Intelligence ETL Pivot Tables XLOOKUP INDEX-MATCH
الإبلاغ عن هذا الملف الشخصي؟