Neha Mer

Detail-oriented MIS Executive / Data Analyst with 9+ years of experience in MIS reporting, data management, dashboard creation, automation, and business analytics. Skilled in Advanced Excel, Google Sheets, Power BI, Power Query, Pivot Tables, Looker Studio, and Python. Experienced in preparing daily, weekly, and monthly MIS reports, data validation, cleaning, reconciliation, and providing actionable insights for management decision-making.

Hands-on experience using ChatGPT and Claude AI for dashboard planning, formula optimization, and reporting workflow improvements.

MIS Executive - Rainbow Group of Companies

(2026-05)

• Data Management & Accuracy: Maintain and update master databases, validate raw data, perform data cleaning, and ensure accuracy and consistency across departments.
• MIS Reporting: Prepare and circulate daily, weekly, and monthly MIS reports for management review with accurate insights and timely distribution.
• Dashboard & MIS Report Automation: Generate and automate dashboards and MIS reports using Excel, Google Sheets, Power BI, and Looker Studio as per management requirements.
• Data Analysis & Visualization: Analyze business data using Pivot Tables, Charts, Power Query, and create interactive dashboards for decision-making.
• Report Management & Documentation: Maintain MIS formats, trackers, documentation, and version control for reporting processes.
• Department Coordination: Coordinate with teams for data collection, follow-ups, validation, and timely submission of reports.
• AI-Assisted Reporting: Utilize ChatGPT and Claude AI for dashboard planning, formula optimization, data analysis support, and improving reporting workflows.

Data Analyst - Terminal Technology (I) Pvt. Ltd. - Vasai

(2025-06 - 2026-04)

• Dashboard & MIS Report Automation: Generate and automate dashboards and MIS reports as per management requirements.
• Performance Monitoring of Products and Revenue: Monitor and update performance of supplied of product and revenue, business metrics.
• Data Support for Management Decision-Making: Support management in decision-making with regular data summaries.
• Trend and Pattern Analysis from Collected Data: Collect and analyze data to identify trends, patterns, and insights.
• Advanced Excel-Based Data Summarization: Use Excel functions, Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, charts, and basic formulas to summarize data.
• Visual Data Representation & Dashboard Creation: Create visual reports (bar charts, graphs, dashboards) to present analysis.
• RM-wise Costing Analysis Linked to LME Prices: Perform raw material–wise costing by mapping LME prices and exchange rates to evaluate cost impact and support pricing decisions.
• Maintenance of Google Sheets for Product Costing: Maintain product-wise Google Sheets with multiple parameters to calculate and track net RMC for each product.

Backend Developer - Mobavenue Media Pvt. Ltd. - Borivali

(2024-05 - 2025-05)

• Developed backend systems using CodeIgniter 3 and PHP 8.0, ensuring efficient data handling and processing.
• Wrote clean, high-quality, and maintainable code with a strong focus on performance optimization.
• Actively contributed to continuous improvement initiatives by suggesting and implementing enhancements.
• Designed and implemented automation for various test suites, improving testing efficiency.
• Improved the code integration process by effectively managing Git repositories.
• Successfully deployed a small website on AWS using LAMP stack server management commands.
• Utilized AJAX to implement smooth server-side pagination for enhanced user experience.
• Managed data import and export operations from Google Drive files, streamlining data workflows.
• Wrote clean, efficient, and well-documented front-end code using HTML, CSS, Bootstrap, JavaScript, and jQuery.
• Collaborated closely with designers and senior developers to implement user-friendly interfaces.
• Troubleshot and debugged issues to ensure smooth functionality across various browsers and devices.
• Performed website updates and ongoing maintenance to ensure optimal performance.
• Optimized web pages for maximum speed, responsiveness, and scalability.
• Continuously learned and adapted to new technologies, frameworks, and tools to stay updated with industry trends.
• Actively participated in code reviews and team meetings to foster collaboration and continuous development improvements.

Front Desk Executive - Rishabh Gems - BKC

(2015-11 - 2023-07)

• Managed high-volume client calls and front-desk operations.
• Handled and organized lakhs of records using Excel and Google Sheets.
• Created MIS reports for inventory, sales, and daily operations.
• Matched and cleaned large datasets across multiple files.
• Coordinated with internal teams and clients for updates and follow-ups.
• Maintained digital documentation and supported administrative tasks.

Bachelor of Commerce - Commerce - A. E. Kalsekar Degree College (2013 - 2014)

12th - Higher Secondary Certificate - Smt. K. G. Mittal College (2010 - 2011)

10th - Secondary School Certificate - Our Lady of Vailankanni High School (2008 - 2009)