LAV KUMAR JOSHI
Manager ( Data analyst)
Kota,Rajsthan
Summary
I have a total of 11 years and 8 months of work experience. Out of this, 9 years and 1 month are in the data analysis field, including 3 years and 10 months working with Power BI and 5 years and 3 months working with Excel for reporting and analysis. I am a hardworking and detail-oriented professional who enjoys working with data. I specialize in turning complex information into simple, useful insights that help businesses make better decisions and grow. I have hands-on experience with tools like Excel, SQL, Power BI, and Python. I use these tools to build reports, analyse data trends, and create dashboards that are easy to understand. I also work closely with different teams to understand their needs and deliver the right data solutions. With strong problem-solving skills and clear communication, I am always looking for new ways to improve and help companies use data to succeed. Insightful Manager with experience directing and improving operations through effective employee motivational strategies and strong policy enforcement. Proficient in best practices, market trends and regulatory requirements of industry operations. Talented leader with analytical approach to business planning and day-to-day problem-solving.
Overview
12
12
years of professional experience
Work History
Manager (Data Analyst)
BYJU’S (Think & Learn Pvt. Ltd.)
Mumbai
02.2022 - 11.2023
- Project Title- Enhancing Student Performance and Institutional Efficiency through Data Analytics
- Tool &Platform-Power BI, SQL SERVER
- Project Summary: -
- This project leverages data analytics to enhance student outcomes and streamline academic operations.
- It involves collecting, analyzing, and visualizing data across academic, administrative, and engagement areas.
- The goal is to enable data-driven decisions that improve teaching, student support, and resource allocation.
- Key Responsibilities & Achievement
- Data Collection: Gather data from various sources such as student information systems (SIS), learning management systems (LMS), surveys, attendance records, and exam scores.
- Data Cleaning & Integration: Standardize and merge data from multiple departments and platforms.
- Exploratory Data Analysis (EDA): Discover patterns, anomalies, and trends in student behaviour, performance, and institutional operations.
- Predictive Modelling: Use machine learning models (e.g., regression, classification) to predict student dropout risks or academic success.
- Visualization & Reporting: Develop dashboards and reports to help faculty and administrators make informed decisions
- Key Performance Indicators (KPIs):
- Student retention rate
- Average GPA improvement
- Faculty workload balance
- Course completion rates
- Utilization of academic support service
- Expected Outcomes:
- Improved academic success rates and reduced dropout rates
- Better resource and schedule management
- Enhanced support for at-risk students
- Designation: -Manager (Data Analyst)
- BY JU’S (Think & Learn Pvt.Ltd) | Mumbai, India
- Feb 2022 – November-2023
Manager (Data Analyst) – Education Sector
Swami Vivekananda Sanskar Academy
01.2020 - 01.2022
- Project Title- Student Performance & Attendance Analytics Dashboard
- Tools & platform-Power BI, Excel
- Project Summary:
- Developed interactive Power BI dashboards to monitor student performance, attendance, and behavior at Swami Vivekananda Sanskar Academy. Automated reporting using DAX and Power Query, reducing manual effort by 60% and enabling real-time academic insights. Supported data-driven decisions to improve curriculum planning and student outcomes
- Key Responsibilities & Achievements:
- Collected and organized student data, including attendance, academic performance, and behavioural records, into structured formats suitable for analysis.
- Utilized Power BI to develop interactive dashboards and visual reports to track and present key education metrics, such as:
- Subject-wise and student-wise performance trends
- Attendance patterns over time
- Progress of students across terms
- Performance comparison between classes or batches
- Automated weekly and monthly reporting using Power BI’s DAX formulas and slicers, reducing manual reporting time by over 60%.
- Integrated data from multiple sources (Excel, Google Sheets) into Power BI, enabling real-time data updates and centralized track
- Designation-Manager (Data Analyst) – Education Sector
- Organization::Swami Vivekananda Sanskar Academy
- Dates of Employment (e.g., Jan 2020 – Jan 2022)
Business Development Executive
WI-FY Academy
Valsad
02.2017 - 12.2019
- Worked as a Business Development Executive at WI-FY Academy from Feb 2017 to Dec2019.
- 5 years and 3 months working extensively with Excel
Business Development Executive
Aspire Career Institute
10.2014 - 02.2017
- Worked as a Business Development Executive at Aspire Career Institute from October2014 to Feb 2017.
- 5 years and 3 months working extensively with Excel
Marketing Executive
Rise Academy Kota
07.2011 - 12.2013
- Worked as a Marketing Executive at Rise Academy Kota from July 2011 to Dec 2013
- Remaining Experience on Other Domain
Education
DIGITAL MARKETING
IIT Delhi
New Delhi11.2023
MBA - Finance And Marketing
D.A.V.V. Indore University
Indore, M.P01.2011
B. Com - undefined
M.D.S University
Ajmer, Rajasthan01.2002
Skills
- Database : MySQL, SQL Server, MongoDB
- Database Language : SQL, T-SQL
- Programming : Python (NumPy, Pandas, Matplotlib, Seaborn)
- BI Tools : Power BI, Tableau, Excel, Google Spreadsheet
- Power Platform : Power Query, Power Pivot, Power View, Power BI Service
Disclaimer
I Lav Kumar, hereby declare that all the above information furnished by me are true to the best of my knowledge and belief. (LAV KUMAR)
Timeline
Manager (Data Analyst)
BYJU’S (Think & Learn Pvt. Ltd.)
02.2022 - 11.2023
Manager (Data Analyst) – Education Sector
Swami Vivekananda Sanskar Academy
01.2020 - 01.2022
Business Development Executive
WI-FY Academy
02.2017 - 12.2019
Business Development Executive
Aspire Career Institute
10.2014 - 02.2017
Marketing Executive
Rise Academy Kota
07.2011 - 12.2013
B. Com - undefined
M.D.S University
DIGITAL MARKETING
IIT Delhi
MBA - Finance And Marketing
D.A.V.V. Indore University