Open to opportunities

Lightson Malli

@lightsonmalli

Message

Data-savvy MIS professional driving insights with Excel, Power BI and automation.

India

Message

What I'm looking for

I seek a data-focused role where I can build dashboards, automate workflows, train teams, and drive data-driven decisions in a collaborative, impact-oriented organization.

I am a results-oriented MIS and data analytics professional with 7+ years of experience in the non-profit and construction sectors, specializing in advanced Excel, Google Sheets, Power BI and process automation to improve program outcomes and operational efficiency. I have led teams, developed dashboards using DAX, and implemented tools and integrations (Google Sheets, WhatsApp API, IVR) that reduced manual work and improved follow-up and tracking.

I deliver actionable insights through cleaned datasets, interactive dashboards and training—having trained 200+ students and internal teams on Excel and data accountability. My background spans dashboard development, survey management, ERP monitoring and procurement/inventory support, enabling data-driven decision-making across projects serving thousands of beneficiaries.

Experience

Work history, roles, and key accomplishments

Sr. MIS Executive

Earthz Urban Spaces Pvt Ltd

Feb 2025 - Jul 2025 (5 months)

Created daily labour and site update reports by integrating Google Sheets with Forms and WhatsApp APIs, introduced IVR for contractor call tracking, and trained onsite teams on material management software to streamline PO tracking and payroll attendance monitoring.

Google Sheets IVR Material Management Reporting Automation)Excel Automation

Monitoring and Evaluation Coordinator

Hemkunt Foundation

Jul 2024 - Dec 2024 (5 months)

Led a 12+ person team managing healthcare data for 5,000+ beneficiaries using advanced Excel (Pivot, VLOOKUP, INDEX-MATCH, Power Query), managed MMU operations, inventory and purchase orders, and developed project assessment reports using KPI and group discussions.

Advanced Excel Power Query Index Match Team Leadership Inventory Management KPI Analysis

Advance Excel Trainer

Technoledge India

Jan 2024 - Mar 2024 (2 months)

Delivered Excel training (basic to advanced) to 200+ HIMT college students covering Power Query, Pivot functions, INDEX-MATCH, VLOOKUP, HLOOKUP and Macros to improve data literacy and practical spreadsheet skills.

Excel)Power Query Index Match HLOOKUP Macros Excel

Accountability and Impact Lead

Children International

Jul 2022 - Dec 2023 (1 year 5 months)

Led data collection and MIS development for 7 programs using Alchemer, SharePoint, Excel and Power BI; built interactive dashboards with DAX, trained teams on data accountability, and delivered actionable insights for program and global decision-making.

Power BI DAX SharePoint)Dashboard Development Data Cleaning Training Excel SharePoint

Information Coordinator

World Vision India

Jul 2017 - Jul 2022 (5 years)

Prepared semi-annual and annual reports for three projects, led baseline and endline surveys, developed five MIS tools for monthly tracking, managed ERP monitoring, and cleaned/analyzed survey data using Kobo Collect and Excel.

Survey Management MIS Quantitative Analysis Reporting