Mansi Makkar
Delhi
Summary
Data Analyst with 1.5+ years of experience in data cleaning, validation, analysis, reporting, and research across diverse datasets and live projects. Skilled in Excel, SQL, Python, Power BI, Tableau, and Google Sheets, with hands-on experience working with company and product data, identifying data inconsistencies, and generating accurate, actionable insights. Experienced in handling live transactional and operational data, building reports and dashboards, and supporting data-driven business decisions. Strong analytical mindset with a focus on data accuracy, problem-solving, and delivering meaningful business insights.
Overview
2
2
years of professional experience
Work History
Data Analyst
Collar Check Private Limited
Delhi, India
06.2026 - Current
- Performing data cleaning and validation on company data to maintain data accuracy and quality.
- Analysing company data to identify relevant information, patterns, and insights as per daily business requirements.
- Working on live product-related data and updating/maintaining data as required.
- Conducting research work using online sources to collect, verify, and organise relevant information.
- Preparing and updating small reports and data summaries based on daily tasks and business requirements.
- Using Excel and Google Sheets for data management, organisation, analysis, and regular updates.
Data Analyst
Fastlane Automotive Private Limited
Gurugram, India
12.2024 - 11.2025
- Worked with a wide range of vehicle data (2W, 3W, 4W, LMV, and commercial vehicles) to provide valuable insights.
- Cleaned and prepared data by fixing errors, handling missing information, and removing duplicates to ensure accuracy.
- Created clear and easy-to-understand reports and dashboards to help teams track vehicle performance and make data-driven decisions.
- Used tools like Python, Excel, and SQL to analyse data, create visual reports, and automate regular updates, saving time and increasing efficiency.
Data Analyst Intern
Areness
Gurugram, India
06.2024 - 12.2024
- Worked with live credit card transaction data from banks, performing data cleaning and analysis to ensure accuracy and completeness for reporting purposes.
- Cleaned, processed, and validated large datasets, removing inconsistencies and handling missing data to improve data quality.
- Contributed to a live project by analysing real-time data, providing insights into user behaviour and transaction patterns.
- Conducted market research by gathering data from online sources (e.g., Airbnb, restaurants, cafes) to support business strategies and competitive analysis.
- Developed strong data analysis skills using tools such as Excel, Python, and SQL to process and visualise data effectively.
Education
Comm-IT Career Academy
Lal Bahadur Shastri Institute of Management
Skills
- Proficiency in python
- Python libraries
- SQL programming
- SQL queries
- Data cleaning
- Excel reporting
- Strong Excel
- Power BI
- Tableau reporting
- Machine learning
- Data science
Timeline
Data Analyst
Collar Check Private Limited
06.2026 - Current
Data Analyst
Fastlane Automotive Private Limited
12.2024 - 11.2025
Data Analyst Intern
Areness
06.2024 - 12.2024
Comm-IT Career Academy
Lal Bahadur Shastri Institute of Management