Resume
GAGAN B P
Data Analyst / Business Analyst
PROFESSIONAL SUMMARY
Data Analyst with practical experience in creating interactive Power BI dashboards, automated data workflows, and uncovering insights using Python and SQL to drive informed business decisions.
SKILLS
Tools & Platforms:
Power BI, Excel (Pivot Tables, Power Query, XLOOKUP, VBA, Macros), Git, GitHub
Programming & Query Languages:
Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (MySQL)
Data & Analytics:
Data Cleaning, EDA, Data Modeling, DAX, Business Intelligence, Statistical Analysis, Predictive Modeling, Data Visualization
PROJECTS
REAL-TIME WEATHER DASHBOARD
- Developed a responsive Power BI dashboard to monitor real-time weather and air quality across 9 Indian cities, integrating GitHub Actions and Weather API for continuous data updates
- Designed a scheduled data pipeline with GitHub Actions fetching data every 3 hours and enabling 8x daily refresh in Power BI Service without manual intervention
- Visualized 14-day forecasts, temperature trends, UV index, and pollutant levels (PM2.5, PM10, O₃, NO₂) through interactive visuals, enabling data-driven decisions for health, travel, and logistics
ANALYSIS ON SUICIDE TRENDS IN INDIA
- Conducted comprehensive statistical analysis and implemented data processing workflows on 2021 suicide trends using NCRB dataset, organizing and standardizing data across 28 states, 8 Union Territories, and 53 cities
- Pinpointed geographical clusters exhibiting the highest and lowest suicide incidence using NCRB data, charting gender-specific trends to devise a focused data collection blueprint for comparative inquiries
- Executed predictive analytics using linear regression with Python libraries (Pandas, Matplotlib, Seaborn, Scikit-learn) to forecast suicide rates for 2024 with 85% accuracy
- Generated actionable insights through data analysis, creating 10 detailed visualizations that clarified complex data sets, leading to a 25% increase in decision-making speed and a clearer understanding of market trends
- Shared insights through peer-reviewed academic presentation, illustrating key findings via compelling charts and fostering 30% more audience engagement during review sessions
INTERNSHIP EXPERIENCE
POWER BI INTERN
Cognifyz Technologies - Remote August 2024 - September 2024- Leveraged Power BI to perform data analysis and create visualizations, enhancing decision-making efficiency by 10%
- Created interactive dashboards and self-updating reports, reducing manual reporting time by 25%
- Conducted rigorous data quality checks and validation, improving data accuracy by 15%
- Constructed data models for 7 tasks, collaborating with cross-functional teams to align with business objectives
EDUCATION
MASTER OF COMPUTER APPLICATIONS
VVIET - Mysore, Karnataka February 2022 - September 2024Relevant Coursework: Data Analysis in Python, Internet of Things (IoT), Database Management Systems (DBMS), Data Structures and Algorithms
BACHELOR OF COMPUTER APPLICATIONS
SDM College - Ujire, Karnataka June 2019 - September 2022Relevant Coursework: Python, Internet of Things (IoT), Database Management Systems (DBMS), Data Mining