Ashwini Patel

Data Analyst Intern

BlackZora

Sep 2025 - Jun 2026

Analyzed business data across ERP modules including HRM, CRM, Sales, Purchase, Finance, Warehouse, Payroll, and Inventory to identify operational trends and improve decision-making. Developed interactive dashboards and reports using Power BI/Tableau to monitor KPIs such as sales performance, inventory turnover, employee attendance, payroll accuracy, and customer acquisition. Developed Python scripts to automate data cleaning and processing, wrote optimized SQL queries to extract, transform, and analyze large datasets from ERP databases for business reporting and ad-hoc analysis. Boosted reporting speed by 20% by designing 10+ interactive Power BI dashboards with advanced DAX, enabling real-time KPI tracking for leadership. Cut manual reporting workload by 35% by automating recurring reports using Excel VBA & Power BI Service, saving 20+ hours/month. Improved decision accuracy by 40% by cleaning and transforming large datasets (Python – Pandas, NumPy), eliminating inconsistencies across multiple sources. Accelerated data retrieval by 35% by optimizing complex SQL queries (CTEs, joins, window functions) across high-volume datasets. Ensured 100% compliance with data access policies by implementing Row-Level Security (RLS) across dashboards. Identified key performance gaps through EDA, directly influencing operational strategies and improving process efficiency. Delivered actionable insights to stakeholders, leading to faster decision cycles and measurable business improvements.