Rajib Baro
Assistant Manager MIS
Gurugram
Summary
Data Analytics and MIS expert with 9+ years in IT, logistics, and electric vehicle sectors. Specializes in KPI tracking, process optimization, and automated reporting. Strong skills in Power BI, Excel VBA, Python, and App Script, enhancing team collaboration and delivering actionable insights for strategic decision-making.
Overview
10
10
years of professional experience
3
3
years of post-secondary education
Work History
Assistant Manager MIS
Hestbit Technologies
Noida, Uttar Pradesh
11.2024 - 12.2025
- Led the development of enterprise-grade Power BI dashboards for Sales, Finance, Operations, and HR, improving leadership visibility and enabling 25–35% faster decision-making.
- Designed and maintained scalable data models using Power Query and DAX, improving report performance by 40%+ while ensuring high data integrity and reliability.
- Wrote optimized SQL queries for data extraction, aggregation, and analytical modeling, reducing query execution time by 30–50%.
- Built and maintained automated data pipelines and reporting workflows using Python, Power Automate, n8n, and Google Apps Script, cutting manual reporting effort by 60–70%.
- Partnered closely with cross-functional stakeholders to translate business requirements into actionable KPIs, driving higher adoption of BI solutions across teams.
- Supported leadership with ad-hoc deep-dive analyses, business reviews, and strategic decision support, influencing operational and financial planning decisions.
- Co-owned digital transformation initiatives by standardizing data processes and strengthening BI infrastructure, improving reporting consistency and scalability.
- Experimented with Generative AI tools and APIs to build practical POCs (e.g., AI-assisted resume screening and workflow automation), reducing screening time by 40%+ in pilot use cases.
Sr. MIS Executive
Mooving
Gurugram , Haryana
02.2022 - 11.2024
- Built complex Power BI dashboards integrating operational, financial, and IoT data, enabling 20–30% faster decision-making for leadership and operations teams.
- Performed extensive data cleaning, transformation, and validation using Power Query, SQL, and scripting, improving data accuracy by ~99% and reducing reporting errors.
- Developed advanced DAX measures for utilization, YoY growth, trend analysis, and performance KPIs, supporting executive-level performance tracking.
- Automated recurring reports and workflows using Python, VBA, and Google Apps Script, reducing manual effort by 60–70% and improving reporting turnaround time.
- Analyzed large-scale operational datasets (millions of records) to identify revenue leakage and inefficiencies, contributing to 5–10% cost optimization.
- Collaborated with Finance, Operations, Product, and external vendors to align analytics with business processes, improving cross-functional reporting adoption.
- Implemented data quality checks, reconciliation logic, and QA processes, ensuring consistent and audit-ready reporting across teams.
MIS Coordinator
DHL Express India Pvt. Ltd.
New delhi, Delhi
09.2015 - 02.2022
- Managed MIS reporting, KPI tracking, and ad-hoc analysis for management, supporting 10–15 senior stakeholders with daily, weekly, and monthly performance reports.
- Built Excel-based automation and early BI reports (advanced formulas, VBA), reducing manual reporting effort by 30–40% and improving turnaround time for operational teams.
- Supported multiple operational teams (Sales, Operations, Finance) with recurring and on-demand insights, enabling faster issue resolution and performance tracking.
- Laid the foundation for transition into advanced analytics and BI roles by standardizing reporting formats, introducing KPI frameworks, and driving early data-driven decision-making.
Education
Bachelor of Computer Science - Computer Science
Dimoria College
Khetri Jul.2013 - Jun.2015
CBSE - Computer Science
Kendriya Vidyalaya
Digaru, Assam Apr.2011 - Mar.2012
Skills
Data Analysis & Visualization with Power BI, Looker, Excel, Google Sheet, SQL, VBA & Python
Data Cleaning & Preprocessing
Automation or RPA
Effective Communication skills
Problem-Solving
Attention to Details
Collaboration
Critical Thinking and Continuous Learning
Timeline
Assistant Manager MIS
Hestbit Technologies
11.2024 - 12.2025
Sr. MIS Executive
Mooving
02.2022 - 11.2024
MIS Coordinator
DHL Express India Pvt. Ltd.
09.2015 - 02.2022
Bachelor of Computer Science - Computer Science
Dimoria College
Jul.2013 - Jun.2015
CBSE - Computer Science
Kendriya Vidyalaya
Apr.2011 - Mar.2012