Mayank Kumar Singh

Final-year Bachelor of Computer Applications (BCA) student with strong academic background in computer science and hands-on experience in programming, data analysis, and software tools. Proficient in Python, SQL, Power BI, Excel, and database management systems like MySQL and Microsoft SQL Server. Completed a data analysis internship and led multiple academic projects involving data visualization, performance reporting, and automation. Skilled in problem-solving, teamwork, and communication. Seeking an entry-level role in software development, IT operations, or data-driven roles to contribute technical and analytical expertise in a dynamic organization.

• Get Job Ready: Power BI Data Analytics for All Levels 2.0
• Google Data Analytics
• Excel | Codebasics
• Udemy Communication Planning

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.