About

Piyush Jain is a Senior Business Intelligence Developer at Dentsu International, with over 8 years of experience in data modeling and data analysis. He has worked in various domains including finance reporting, CPG, retail, pharma, and debt management. Piyush has a strong knowledge of data engineering, data modeling, and data visualization. He has worked with various ETL, OLAP, and reporting tools such as Azure (Power BI, Synapse Analytics, ADLS, ADF, Azure SQL Server), SSIS, SSAS (Tabular and multidimensional), SSRS, and Tableau. Recently, Piyush has started working on big data and advanced analytics using Spark, Scala, R, and Python. He is a quick learner and a very good team player with highly innovative thoughts. In his current role at Dentsu, he is responsible for developing ETL packages and pipelines using SSIS and ADF for data transformation, developing new data models and data marts in Synapse and Azure SQL Server for financial reporting, developing new finance reports for Accounts Payable, Accounts Receivable and General Ledger in Power BI and Tableau, and supporting and enhancing the already built reports in Tableau. Prior to Dentsu, Piyush worked as a Senior Engineer at Brilio and Harman Connected Services. He holds a Bachelor of Engineering degree in Information Technology from the Institute of Information Technology And Management, Gwalior. Piyush's tech stack includes SQL, Azure, ETL, data engineering, Spark, big data, Python, and Scala. With a relevant experience of 8.94 years, Piyush is a skilled business intelligence developer with a strong understanding of data modeling and analysis.