Portfolio - Mohan B | Codebasics

About Me

👋 Hello there!

I’m Mohan B, a Microsoft Certified Data Analyst and Azure Data Fundamentals professional on a mission to unlock the power of data. With over 5+ years of experience, I specialize in turning numbers into actionable insights using tools like Power BI, SQL, Excel, and Python.

I’ve worked on several impactful business projects, all proudly showcased in my portfolio. What sets me apart is my ability to find hidden stories in data and translate them into strategies for success.

Explore my portfolio below, and let’s connect! Together, we can bring data to life and make it work for you. 📊💡📈

Key Skills

Power BI

SQL

Advanced Excel

Python

DAX

Power Query

Power BI Service

MDM

GEN AI

GITHUB COPILOT

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales & Finance Analytics

AtliQ- Business Insights--360

Domain/Function: Business Insights 360 for AtliQ Hardwares

Ecommerce Sales Analysis Dashboard

Domain/Function: Ecommerce Sales Analysis

My Experience

Senior Data Analyst

Mahindra & Mahindra, Chennai

Feb 2025 - PRESENT

· Extract, clean, and standardize product data from Teamcenter to support migration to 3DExperience (3DS) platform as part of the enterprise MDM (Master Data Management) initiative.

· Manage and transform large datasets involving automobile part attributes (e.g., part nomenclature, classification, specs) to ensure quality and consistency across platforms.

· Utilize Advanced Excel, SQL, and Power BI for data profiling, validation, and reporting to streamline migration workflows and ensure data accuracy.

· Collaborate with cross-functional teams including engineering and IT to align data structures with manufacturing standards and business rules.

· Develop automated checks and data dashboards in Power BI to track data readiness, quality metrics, and project KPIs, improving visibility and decision-making.

· Contributed to a 25% reduction in data inconsistencies during migration through proactive data cleansing and validation efforts.

Data Analyst

Infosys, Bengaluru
Aug 2021 – Feb 2025

Designed, developed, and maintained 40+ Power BI reports and dashboards, driving data-driven business decisions.
Conducted data preparation, cleaning, transformation, and modelling using Power Query and SQL to ensure accuracy.
Created advanced calculated fields in Power BI with DAX, optimizing data models and improving report performance by 30%.
Collaborated with business users to gather requirements and develop dashboards aligned with organizational goals.
Communicated insights effectively to stakeholders, enhancing decision-making processes.
Integrated multiple data sources (SQL Server, MySQL, Excel) into Power BI and Tableau, enhancing data accessibility by 20%.
Conducted performance tuning for Power BI dashboards, reducing load times and improving responsiveness by 40%.
Published and maintained dashboards on Power BI Service, managing permissions, schedules, and data refreshes.