AKASH GHUGE

• Led the architecture and delivery of scalable ELT pipelines using Azure Data Factory, Synapse Analytics, Azure SQL, and ADLS, integrating sources like Dynamics 365 into a centralized data platform.
• Improved data quality and reporting latency by over 30%, enabling real-time insights for inventory, pricing, and customer behavior analysis.
• Partnered with business stakeholders, analysts, and data scientists to translate requirements into governed, production-grade data models supporting enterprise analytics.
• Established standards and controls for data quality, lineage, and security, ensuring scalable and trusted analytics solutions.
• Defined and enforced data governance practices to maintain compliance and data integrity across business-critical systems.
• Optimized cloud spend by applying dynamic scaling techniques to Azure Analysis Services and Synapse pools, saving $5,000/month.
• Mentored junior engineers and led sprint planning, design reviews, and peer code reviews to ensure delivery excellence and continuous improvement.
• Fostered a collaborative, inclusive, and high-performance team culture aligned with agile practices and business goals.

Client : OTIS

• Designed and implemented scalable ETL solutions using ADF, Databricks, SQL Server, and ADLS, delivering reliable data pipelines across 17+ countries and supporting 56+ KPI reports critical for business decisions.
• Integrated data from diverse sources like Azure SQL DB, On-Prem SQL Server, Oracle, ADLS, SFTP, and CRM systems, transforming complex datasets with Azure Databricks and SQL to enhance usability and analytics readiness.
• Built and implemented Azure SQL Server, Data Warehouse, and BI solutions, enhancing data management, strategic insights, and visualization capabilities.
• Managed and mentored a team of three, providing technical guidance, reviewing deliverables, and fostering a high-performance environment while leveraging domain expertise to resolve issues and ensure timely, consistent project success.

Client : Chevron , Cipla

• Designed and implemented ADF pipelines for data transformation, developed DataMarts with data modeling for seamless integration, and built scalable Azure SQL Server and Data Warehouse solutions to optimize analytics and reporting.
• Collaborated with stakeholders to gather requirements, integrated diverse data sources, and provided tailored client-side support, ensuring effective adoption of Azure-based platforms and solutions.
• Streamlined deployment processes with CI/CD pipelines in Azure DevOps and created dynamic Power BI dashboards with comprehensive data models, delivering actionable insights from on-premises SQL and Azure SQL DW sources.

Client : Microsoft [Cloud and Enterprise (CnE)]

• Designed and built ADF pipelines to automate data ingestion and transformation from diverse sources, improving data accuracy and streamlining recurring operations.
• Integrated structured and semi-structured data using Azure Cosmos DB, Data Lake, and SQL DW external tables, enabling advanced analytics at scale.
• Developed Power BI dashboards with optimized data models from SQL on-premises and Azure SQL DW, delivering actionable insights for business users.
• Modernized legacy data architecture and authored technical documentation, improving processing efficiency, ensuring data integrity, and reducing query resolution time.