Piyali Saha
Data Analyst – Trainee Engineer
About
No bio added yet
Skills & Expertise (16)
Work Experience
Data Analyst – Trainee Engineer
Novartis
Jul 2025 - Present
Designed interactive Power BI dashboards (Desktop & Service) using star schema data models and optimized relationships, improving reporting performance and management review efficiency by 25%. Collaborated with business stakeholders to gather reporting requirements and translate them into technical dashboard specifications and data models, accelerating decision-making by 20%. Wrote and optimized complex SQL queries for data extraction and backend performance tuning, enabling faster analysis and improving report refresh times by 20%. Implemented Row-Level Security (RLS) in Power BI to control access to sensitive reporting data across business units, reducing unauthorized access risks by 40%.
Business Analyst
Stryker
Jul 2024 - Jun 2025
Gathered requirements from cross-functional stakeholders and translated them into technical specifications for BI dashboards and reporting workflows, improving reporting adoption across teams by 25%. Developed a star schema data model for inventory analytics using fact and dimension tables in SQL server, improving dashboard query performance by 28%. Built ETL workflows in Power Query to extract and transform data from SQL Server and Excel sources for Power BI dashboards, reducing manual data preparation by 30%. Implemented role-based access and Row-Level Security (RLS) in Power BI for enterprise reporting dashboards, enabling department-level data visibility and improving governance compliance by 35%.
Education
MTech in Computer Science Engineering Specialization in Business Analytics - Vellore Institute of Technology
2020 - 2025 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (16)
Click a skill to find developers with the same skill
