Yash Joshi

I’m a Data Analyst and Power BI Developer with 3+ years of experience at Tata Consultancy Services, delivering Business Intelligence and analytics solutions for pharmaceutical clients. I focus on turning multi-source data into reliable, actionable dashboards that teams can use for self-service reporting.

At TCS, I designed and maintained interactive Power BI dashboards using DAX and Power Query, partnering with business stakeholders to gather requirements and deliver enhancements aligned with evolving reporting needs. I also wrote and optimized SQL queries in SQL Server and MySQL to support ETL processes, improving query performance and data accuracy.

I integrate data from SQL Server, Excel files, and Dremio Data Lake using Azure Data Factory (ADF), enabling unified cross-functional reporting. I automate recurring manual reports with Power BI and ADF workflows and manage the Power BI Data Gateway to ensure scheduled data refreshes, secure connectivity, and data quality through validation checks.

My background also includes Linux administration work, where I supported Linux servers hosting the Posit (RStudio) analytics platform—handling access management, security compliance, monitoring, and troubleshooting. With Microsoft PL-300 and AWS Certified Solutions Architect Associate credentials, I bring a practical, end-to-end mindset to BI, ETL, and dependable analytics delivery.