Data Analyst (Internship / Entry-Level Role)
- Performed data cleaning and validation using Excel formulas (VLOOKUP, INDEX-MATCH, IF) to prepare datasets for analysis, ensuring 95%+ data accuracy
- Created interactive Tableau dashboards to visualize sales trends and KPIs, supporting business stakeholders in identifying performance patterns
- Wrote SQL queries (SELECT, JOIN, GROUP BY, aggregations) to extract and filter data from databases for reporting purposes
- Assisted in generating weekly and monthly reports using Excel Pivot Tables and Power Query for data transformation
- Supported data migration tasks by converting CSV files to structured formats using Python (Pandas) and Excel
- Collaborated with senior analysts to understand business requirements and translate them into analytical solutions
- Documented data workflows and analysis procedures for team reference and knowledge sharing
- Successfully created 5+ Tableau dashboards used by management for weekly performance reviews
- Reduced report generation time by 20% through Excel automation using formulas and basic scripting
- Identified and corrected 500+ data inconsistencies in legacy datasets, improving data quality for downstream analytics
