Skills & Expertise (19)
Work Experience
Data Analyst
Caplix Technologies
Sep 2023 - Present
Analyzed operational datasets containing 700K+ records using SQL to generate recurring performance reports and uncover trends used in weekly business reviews. Cleaned and validated 500K+ data entries by correcting inconsistent formats and removing duplicate records, resolving data quality issues affecting ~12% of the dataset. Developed Power BI dashboards tracking 15+ operational KPIs, providing stakeholders with centralized visibility into performance metrics previously distributed across multiple reports. Consolidated 8 source files using Excel (Power Query and Pivot Tables) to streamline reporting workflows and improve consistency in monthly performance reporting. Optimized complex SQL queries and implemented indexing, reducing average data retrieval time by 30% and improving report generation efficiency. Performed exploratory data analysis using Python (Pandas) on 300K+ records to identify anomalies and patterns influencing operational metrics. Investigated KPI fluctuations through trend analysis and historical data comparison, identifying three recurring patterns impacting periodic performance reporting.
Education
Bachelor's of Technology in Electronics and Telecommunication - Punyashlok Ahilyadevi Holkar Solapur University
2019 - 2023 · India
