About
I am DEVI LAL, an MIS Analyst with around 3+ years of experience in data analysis, reporting, and business intelligence. My expertise includes: Advanced Excel reporting and automation SQL data extraction and analysis Power BI dashboard development Sales & Inventory Analysis Store Performance and Market Expansion Analysis KPI tracking and business reporting I have worked on projects for retail and digital media clients such as: Retail analytics for supermarkets and sweet shops Sales and inventory optimization Product performance and stock analysis Promotion effectiveness reporting Vendor and payment data analysis Some key achievements from my projects: Reduced stock-out issues by around 25% Improved sales performance by 15–17% Increased average bill value by 10% through data-driven insights
Skills & Expertise (32)
Work Experience
Executive – MIS
Monika Alcobev Ltd.
Aug 2025 - Apr 2026
Managed MIS reporting and sales analytics for Global Travel Retail (GTR) airport channels across multiple premium liquor brands. Monitored brand-wise sales trends, outlet performance, stock movement, and revenue contribution across airport retail locations. Analyzed primary and secondary sales data to identify fast-moving products, slow-moving inventory, and demand gaps. Developed automated Excel and Power Query dashboards for real-time KPI tracking, sales monitoring, and inventory visibility. Conducted inventory and stock reconciliation analysis to reduce stock shortages and improve product availability. Collaborated closely with sales, operations, and supply chain teams to align reporting insights with business targets. Delivered data-driven brand performance recommendations that contributed to a 15–20% increase in airport channel sales. Improved reporting accuracy and operational efficiency by streamlining data consolidation and validation processes. Prepared weekly and monthly management reports highlighting sales growth, stock ageing, and brand performance trends.
MIS Analyst
Aranya Consultancy
Dec 2022 - Aug 2025
Developed and maintained automated Excel dashboards and Power BI reports for business performance tracking and management reporting. Wrote optimized SQL queries using SELECT, JOIN, UPDATE, DELETE, and Subqueries for data extraction and manipulation. Built interactive Power BI dashboards using Power Query transformation and data modelling techniques. Automated data cleansing and validation routines using SQL constraints, stored procedures, and Excel formulas. Collaborated with cross-functional stakeholders to gather reporting requirements and deliver actionable analytical solutions. Integrated SQL, Excel, and Power BI into a centralized reporting environment for faster and more accurate business insights. Improved operational reporting efficiency by reducing manual reporting efforts through dashboard automation. Supported strategic business decisions through sales analysis, market trend analysis, and KPI monitoring.
Education
B.Sc. Chemistry (Hons.) - Magadh University
- 2014 · Afghanistan
Senior Secondary (12th) - Patna High School
- 2010 · Afghanistan
Matriculation (10th) - BSEB Board
- 2008 · Afghanistan
Certifications
Data Analytics Job Simulation
Deloitte Australia · 2025
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (32)
Click a skill to find developers with the same skill
