Shweta Dattatray Savant – Data Analyst Intern

About Me

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…

Experience

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

Atomberg Pvt. Ltd.

Apr 2023 - Mar 2025 · 1 year 11 months

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 months

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.

Skills

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