Khushboo Pandey

Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI for data extraction, transformation, analysis, and interactive dashboard development to deliver actionable business insights. Skilled in data cleaning, validation, ETL, data modeling (Star & Snowflake Schema), KPI reporting, and business analytics with a strong focus on data quality and process improvement. Experienced in collaborating with cross-functional teams to translate business requirements into analytical solutions, leveraging Pandas, NumPy, PostgreSQL, and modern data analytics practices in Agile environments.

Data Science Intern at Coerror

• Cleaned, validated, and analyzed 50,000+ records using Excel and Python, improving data quality and reducing inconsistencies by ~30%.
• Performed exploratory data analysis (EDA) to identify trends, anomalies, and business insights, presenting findings through reports and visualizations.
• Developed KPI dashboards and automated reporting workflows, reducing manual reporting effort and improving decision-making.
• Collaborated with cross-functional teams to validate data pipelines, define business metrics, and ensure accurate analytical outputs.
• Contributed to the development of the LogGuardian platform for real-time log anomaly detection and failure prediction using machine learning.

B.Tech in Computer Science & Engineering – Parul University (2022 – 2026)