Sayan Datta

Built scalable historical databases using SQL Server temporal tables. Developed data warehouses, ETL pipelines, and star-schema models for BI and analytics. Implemented serverless APIs with Azure Functions for data access and integration. Collaborated with analysts and stakeholders to improve data quality, governance, and data accessibility.

Maintained and enhanced a Power BI analytics platform for renewable energy projects. Designed data models and performed advanced ad-hoc analysis using SQL and Power BI to deliver actionable insights. Managed databases and optimized data pipelines for reliable reporting. Skills: SQL, Python, Power BI, DAX, Git, data modeling, Power Apps, Power Query (M), Databricks, ETL, data architecture.

Thesis: Data Quality Management for Data-Driven Decision Making in Renewable Energy. Developed a data quality framework for BayWa r.e. project databases, identifying inconsistencies in data architecture, reporting, and preparation. Defined key data quality metrics to improve integrity and trust. Built two scalable tools for error logging and real-time data quality monitoring.

- Analyzing user behavior data from Google Analytics for improving the UI and UX of company website - Collecting, reporting and crunching Customer, Marketing and Web behavioral data - Keeping track of Google Search Console & Google Analytics - Automation with Python - Web scraping with Python

- Keeping track of Google Search Console & Google Analytics - Performing competitor analysis & keyword research - Developing actionable insights from data collected through ad campaigns in Google and Facebook - Analyzing targeted audience from demographics and interests data for better ROI