Mayank Kumar Singh

Jamshedpur

Summary

BCA graduate specializing in data analysis with practical experience in Python for data cleaning, visualization, and interpretation. Proficient in utilizing libraries to derive insights and enhance decision-making processes. Knowledgeable in basic statistics and Excel for effective data management and reporting. Recognized for strong communication, teamwork, and problem-solving skills, with a proactive approach to learning and adapting to new technologies.

Overview

Certification

Work History

Data Analyst Trainee

MedTourEasy

New Delhi

07.2024 - 08.2024

Project Contributions: Successfully assisted in multiple data analysis projects, providing valuable insights for business decisions.
Effective Communication: Developed and presented data visualizations that effectively communicated complex data findings to non-technical stakeholders.
Tool Proficiency: Gained hands-on experience with industry-standard data analysis tools and techniques, enhancing overall proficiency.
Teamwork: Supported the roll-out of new data management software, contributing to smoother operations and enhanced analytical capabilities.

Education

Bachelor in Computer Application - Computer Science

Arka Jain University

Jharkhand

07-2025

Skills

Data analysis and visualization
Proficient in Python
Problem solving

Team collaboration
Effective communication
Relationship building

Projects

Business 360 - Brick & mortar and ecommerce [Power BI | SQL | Excel | Dax Studio]

● Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).

● Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the report by 5%.

● Developed a dashboard that enabled Atliq Hardware to analyze department sales trends, driving a projected 10% revenue acceleration and a 20% reduction in data-related expenses.

P&L Report - [Excel | Pivot Table | Power Query]

● Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories.

● Automated data cleaning using Power Query, which can rescue around four hours of repeated manual work.

● Deployed DAX-based calculation models, resulting in a 30% increase in report accuracy and providing users with more nuanced, flexible data insights.