Collaborated with stakeholders to understand their data requirements and translated them into interactive and visually appealing Power BI dashboards catering 30-40 users on daily basis.Developed and optimized SQL queries to extract, transform, and load data from the data warehouse, fulfilling both automated and ADHOC requests for various business teams.Collaborated with cross-functional teams to understand data requirements and deliver accurate, timely reports for decision-making and analysis.Performed data validation, indexing and performance tuning of SQL queries to ensure efficient data retrieval and reduced query execution time by 20%, significantly improving the speed of report generation for business stakeholders.Managed and contributed to the development of a system for delivering Management Information Systems (MIS) across the organization.Designed and improved complex queries and data models to support the generation of detailed paginated reports.

Designed and implemented a robust ELT process using Azure Data Factory to handle daily data transfers of 20 GB for the microfinance department. Collaborated with cross-functional teams to gather requirements, ensuring the ETL process met business needs and compliance standards. Utilized Azure services such as Azure Data Lake, Azure Data Factory, Synapse and Azure Blob Storage to support the ETL process.Collaborated with different teams to define requirements and translate business needs into technical specifications for stored procedures.