Shweta Dattatray Savant – Data Analyst Intern

نبذة عني

Highly motivated Data Analytics professional with hands-on experience in Excel automation, dashboard creation, and data visualization. Looking to contribute analytical thinking and problem-solving skills to help organiza…

الخبرة

Collected and maintained employee attendance data from biometric systems and Excel trackers.

Atomberg Pvt. Ltd.

Apr 2023 - Mar 2025 · 1 سنة 11 أشهر

Used advanced Excel functions (VLOOKUP, IF, COUNTIF, NETWORKDAYS) to calculate absences, late arrivals, and overtime hours., Created Pivot Tables, charts, and summary reports to track monthly and departmental attendance trends., Automated repetitive attendance calculations using Excel & Power Query, reducing manual work by 50%., Partnered with HR to prepare accurate monthly reports, improving data-driven decision-making and efficiency.

Atomberg Pvt. Ltd., Chakan, Pune

Apr 2023 - Mar 2024 · 11 أشهر

Collected and maintained employee attendance data from biometric systems and Excel trackers.
Used advanced Excel functions (VLOOKUP, IF, COUNTIF, NETWORKDAYS) to calculate absences, late arrivals, and overtime hours.
Created Pivot Tables, charts, and summary reports to track monthly and departmental attendance trends.
Automated repetitive attendance calculations using Excel & Power Query, reducing manual work by 50%.
Partnered with HR to prepare accurate monthly reports, improving data-driven decision-making and efficiency.

المهارات

Excel (Advanced): VLOOKUP XLOOKUP INDEX-MATCH SUMIFS COUNTIF IF NETWORKDAYS Pivot Tables Charts Conditional Formatting Slicers Power Query Dynamic Dashboards SQL (Advanced – MySQL & PostgreSQL): Joins CTEs Subqueries Window Functions Aggregations Indexing Query Optimization Stored Procedures and Data Extraction from Databases Power BI: Data Modeling Power Query for ETL DAX Calculations KPI Dashboards Drill-Through Reports Trend Analysis Python (for Data Analytics): Pandas NumPy Matplotlib Seaborn (Visualization) Data Cleaning & Automation Other Tools: MS Office Suite Google Sheets Tableau (Basic) PowerPoint Excel VLOOKUP XLOOKUP INDEX-MATCH SUMIFS COUNTIF IF NETWORKDAYS Pivot Tables Charts Conditional Formatting Slicers Power Query Dynamic Dashboards SQL MySQL PostgreSQL Joins CTE Subqueries Window Functions Aggregations Indexing Query Optimization Stored Procedures Power BI Data Modeling DAX KPI Dashboards Drill-Through Reports Trend Analysis Python Pandas NumPy Matplotlib Seaborn Data Cleaning Automation MS Office Suite Google Sheets Tableau PowerPoint