Mohammad Navaid Akhtar

• Developed and optimized ETL/ELT processes using Azure Data Factory, Azure Data lake, Azure Databricks, and Synapse Analytics to ingest, transform, and process large-scale data.

• Integrated data from multiple sources, including on-premises and cloud-based systems, ensuring data quality, consistency, and standardization.

• Diagnosed performance bottlenecks and optimized data load processes in Power BI reports backed by Azure Analysis Services, resulting in faster report rendering and significant reductions in monthly Azure subscription costs.

• Redesigned Azure ELT pipeline to replace Azure SQL with DataBricks Unity Catalog and ADLS as the final storage layer, optimizing performance and reducing subscription cost.

• Documented data lineage for 50+ ETL pipelines using Azure Data Factory and Databricks, mapping data flows from source to target to provide a clear overview of transformations, enabling 30% faster debugging and issue resolution for data quality incidents.

• Optimized resource allocation by effectively prioritizing tasks based on business needs and project timelines.

• Established coding standards to ensure consistent quality across the development team's output.

• Mentored junior developers, fostering a culture of continuous learning and skill improvement.

• Optimized database queries and old code to enhanced performance, enabling faster data retrieval and processing.

• Used ColdFusion, JavaScript, HTML, MySQL and SQL Server to develop/maintain applications.

• Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.