Sayantani Chatterjee
Kolkata
Summary
Data Analyst with over 2 years of experience leveraging MySQL, PgSQL, and Power BI to transform complex data into meaningful insights. Skilled in data modeling, ETL processes, and large-scale data analysis, with strong proficiency in DAX, Power Query. Adept at designing KPIs and building interactive dashboards that support strategic decision-making. Proven ability to integrate data from multiple sources and collaborate with cross-functional teams to deliver impactful, data-driven solutions.
Overview
5
5
years of professional experience
1
1
Certificate
Work History
Jr Data Engineer
Sundew Solutions Private Limited
06.2024 - 03.2026
- Designed 12+ Power BI dashboards and developed data models to improve data visualization and reporting.
- Implemented data validation techniques in Excel, Power BI, MySQL, and Tableau, ensuring high levels of data accuracy.
- Utilized SQL skills to optimize queries, improving data retrieval speed and reducing processing time.
- Analyzed data and identifying top-performing lead funnels which in thus resulted in increasing token amounts by 15%.
- Conducted root cause analysis of sales drops, implementing process improvements that boosted monthly sales by 22%.
- Acquired knowledge of data flow and its application in insurance and hospitality industries.
Data Analyst
K12 Techno Services Private Limited
03.2024 - 06.2024
- Developed Power BI reports that streamlined insights across schools and departments, leading to financial savings through data-driven decisions that enhanced employee performance.
- Analyzed educational data to identify trends and insights for curriculum development.
- Collaborated with teams to design dashboards for real-time data visualization.
- Created reports to support decision-making in educational initiatives and programs.
Subject Matter Expert
Tutopia Private Limited
04.2021 - 07.2022
- Developed instructional materials to support educational programs and resources.
- Collaborated with cross-functional teams to enhance curriculum design and delivery.
Education
Certification - Data Analytics
Ivy Professional school
11-2023
B.Sc. and M.Sc. - Zoology
Calcutta University (CU)
07-2019
Certification - Class XII & Class X
Tarasundari Balika Vidyabhaban
Skills
- Power BI
- MySQL and PostgreSQL
- Data integration with Talend
- Advanced Excel
- Python programming
- Pivot tables and slicers
- Dashboard design
- DAX calculations
- Jira project management
- Data visualization
Certification
- Data Analytics & Visualization Certificate
- HackerRank SQL Certificate
Timeline
Jr Data Engineer
Sundew Solutions Private Limited
06.2024 - 03.2026
Data Analyst
K12 Techno Services Private Limited
03.2024 - 06.2024
Subject Matter Expert
Tutopia Private Limited
04.2021 - 07.2022
Certification - Data Analytics
Ivy Professional school
B.Sc. and M.Sc. - Zoology
Calcutta University (CU)
Certification - Class XII & Class X
Tarasundari Balika Vidyabhaban
Languages
- English
- Bengali
- Hindi
Soft Skills
- Team management
- Strong written and verbal communication skill
- Collaborating with cross functional teams
Projects
- Claims Dashboard maintain, Maintained an analytical dashboard for an American insurance company's claims process, including integrating data from various sources. The dashboard used as consolidated claims data providing insights on various business dimensions related to claims.
- Data Migration for a Tourism company, Established a data warehouse and operational data source for a tourism company by identifying dimension tables within the operational data and creating a fact table to support various reporting needs and created a Power Bi report for company's operational business insight.
- Performance Metrics Dashboard, Created an Excel dashboard for team reporting on weekly, quarterly, and annual process KPI metrics, featuring slicers and lookups to monitor target percentages.
- Stored Procedure creation, Created 50+ stored procedures for Healthcare domain in SQL which is used frontend API integration.
Languages
- English
- Bengali
- Hindi
Soft Skills
- Team management
- Strong written and verbal communication skill
- Collaborating with cross functional teams