Sahana D G
Data Analyst • Bangalore • s*****************@gmail.com • 636****238 • linkedin.com/••••• • drivetube.ai/•••••
Professional Summary
Data Analyst with 6 months of experience performing data cleaning, exploratory data analysis, SQL querying, and Power BI dashboarding to deliver actionable business insights. Skilled in Python (pandas, NumPy), MySQL, Excel and report automation.
Technical Skills
Programming Languages: Python
Frameworks and Libraries: Pandas,NumPy,Matplotlib,Exploratory Data Analysis,Data Cleaning
Databases: SQL,MySQL,Relational Databases
Data and Analytics: Power BI,Power Query,DAX,Data Visualization
Tools and Methodologies: Jupyter Notebook,Google Colab
Spreadsheets & Reporting: Microsoft Excel,Pivot Tables,VLOOKUP
Work Experience
BDreamz Global Solution Pvt. Ltd.
Bangalore
Data Analyst Intern
Internship at BDreamz Global Solution Pvt. Ltd.; supported business data analysis, reporting, and dashboarding using SQL, Excel, Python, and Power BI.
Tech Stack: Python, pandas, Matplotlib, MySQL, SQL, Microsoft Excel, Power BI, Power Query
- Performed data cleaning, transformation, and validation on business datasets using Excel and Python (pandas), improving dataset readiness for analysis and reporting.
- Authored SQL queries in MySQL to extract, join, and aggregate data for weekly business reports and ad-hoc stakeholder requests.
- Developed interactive Power BI dashboards to visualize key business metrics and trends, enabling stakeholders to monitor performance and make data-driven decisions.
- Built automated data transformation flows using Power Query and Excel (PivotTables) to standardize inputs and reduce manual preprocessing steps.
- Conducted exploratory data analysis with Python and Matplotlib to identify trends, seasonality, and anomalies that informed reporting and recommendations.
- Collaborated with business stakeholders to gather requirements, translate them into dashboard specifications, and present insights to non-technical audiences.
Projects
HR Analytics Dashboard
Tools Used: Power BI, Excel, Data Cleaning, DAX
- Built interactive Power BI dashboards to analyze employee attrition and performance metrics, enabling HR to filter and explore trends by department and tenure.
- Performed data cleaning and transformation in Excel and Power Query to merge and standardize HR datasets for accurate reporting.
- Generated actionable insights and visualizations that supported HR decision-making around retention and performance interventions.
Sales Data Analysis
Tools Used: SQL, Excel, Exploratory Data Analysis
- Analyzed sales datasets using MySQL and Excel to identify temporal trends and top-performing products.
- Conducted EDA and cleansing to correct inconsistencies, aggregate sales by region and period, and prepare data for reporting.
- Created summary reports to highlight sales patterns and support inventory and merchandising decisions.
Dairy Farm Shop Management System
Tools Used: Python, MySQL, Excel
- Designed a management application to record products, customers, sales, purchases, stock, and billing to streamline daily dairy shop operations.
- Implemented backend data storage and retrieval using MySQL and Python for basic CRUD operations and reporting.
- Prepared sample reports and stock summaries to help track inventory levels and daily sales.
Education
JSS College of Arts, Commerce and Science, Mysore
MCA • Mysore, India • 2024 – 2026
Certifications
C Programming — Q-Spiders
Python Programming — Hope Foundation
Data Science Internship Program
Data Science & Visualization — Besant Technologies
Powered by Drivetube · Create your own profile at drivetube.ai