Resume
GAGAN B P
Data Analyst / Business Analyst
SKILLS
- SQL (MySQL)
- Python (Pandas, NumPy, Matplotlib)
- Tableau
- Excel (VLOOKUP, HLOOKUP, Conditional Formatting, Pivot Tables)
- Data Visualization (Dashboards, Graphs)
- Microsoft Power BI
- ETL (Extract, Transform, Load)
- Data Analysis
PROJECTS
HR ANALYTICS DASHBOARD
- Designed an HR Analytics Dashboard in Power BI to analyze employee attrition trends across 3 departments
- Processed and visualized data on attrition by age, job role, education, and salary using Power BI, identifying attrition rates of 22.0% and 13.8%
- Delivered actionable insights on key HR metrics, driving data-driven decisions that reduced attrition rates by 20%
- Customized the dashboard to focus on attrition by years and salary brackets, improving analysis efficiency by 30%
ANALYSIS ON SUICIDE TRENDS IN INDIA
- Conducted an in-depth analysis of 2021 suicide trends in India using the NCRB dataset, organizing data across 28 states, 8 UTs, and 53 cities
- Identified regions with highest/lowest suicide rates and analyzed gender-specific trends across 28 states, UTs and 53 cities
- Predicted future suicide rates for 2024 using linear regression with Python (Pandas, Matplotlib, Seaborn, Scikit-learn) with 85% accuracy
- Generated insights and created 10 visualizations as a part of a collaborative team project, contributing to a 25% improvement in decision-making efficiency
INTERNSHIP EXPERIENCE
POWER BI INTERN
Cognifyz Technologies - Remote August 2024 - September 2024- Leveraged Power BI to perform detailed data analysis and create visualizations, enhancing decision-making efficiency by 10%
- Created and maintained interactive dashboards and reports, reducing manual reporting time by 25%
- Developed data models and visualizations for 7 tasks, collaborating with cross-functional teams to align with business objectives and improve reporting
- Conducted data quality checks and validation, improving data accuracy by 15% and ensuring reliable reporting
PYTHON FULL-STACK INTERN
Orion Web Services Pvt Ltd - Mysore, KA October 2023 - December 2023- Applied Python full-stack development skills in academic projects, leading to a 15% increase in project efficiency
- Strengthened proficiency in the Flask framework through hands-on practice, achieving a 50% improvement in skills, which contributed to more efficient coding
- Practiced using the Flask framework by developing a basic web application, resulting in a 20% improvement in deployment time and a deeper understanding of web development concepts
EDUCATION
MASTER OF COMPUTER APPLICATIONS
VVIET - Mysore, KA 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, KA June 2019 - September 2022Relevant Coursework: Python, Internet of Things (IoT), Database Management Systems (DBMS), Data Mining