Expertise in SQL, Power BI, Excel, SCOPE, Business Intelligence and Microsoft Advertising Business. Working knowledge of Big Data, Azure Databricks, Azure data lake and ETL tool like Power Query.Collaborated with cross-functional teams to gather data requirements and design efficient pipelines. Managing data analytics and processing activities which assist in strategic decision making and planning.Converted major reports from Excel to Power BI resulting 95% manual effort saving. Developed custom scripts and tools to streamline data transformation and loading processes.Developed several reports tracking performance, performing forecasts and setting up benchmarks based on KPIs.Build, test and deploy queries to extract and manipulate data. Build complex calculations and functionalities within Power BI.Developed and maintained scalable data pipelines and delivered client requests with high quality and within SLA.Worked on SSMS platform using SQL Server.Designed and optimized data models to improve data accuracy and accessibility.Trusted with additional responsibilities in the project and helping hand to team members for brainstorming on issues, finding solutions and fixes.Implemented data validation and cleansing processes to enhance data integrity.