ASWANI GOPINATH
Abudhabi
Summary
Lead data warehouse engineer with extensive experience at Silal, specializing in scalable data architecture and AI integration. Proficient in Microsoft Fabric and data governance, optimizing data frameworks to enhance operational efficiency. Demonstrated ability to foster collaboration across teams, improving decision-making processes.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Lead Data Warehouse Engineer
Silal (Part of ADQ)
Abu Dhabi
01.2023 - 12.2026
- Architectural Leadership: Spearheaded the enterprise-wide transition to Microsoft Fabric, designing and deploying a robust Medallion Architecture that acts as the foundation for the organization’s Data & AI initiatives.
- Modern Data Frameworks: Architected highly scalable, metadata-driven ingestion frameworks (utilizing PySpark, Fabric Notebooks, and Data Pipelines) capable of handling massive volumes of structured and unstructured data with dynamic schema evolution and error handling.
- Orchestrated robust data pipelines incorporating dependency handling, parameterization, logging, and monitoring to ensure reliable and accurate data loads.
- AI-Driven Analytics: Designed the data backbone for "Intellifood" (a smart farming initiative) and enterprise Demand Planning, integrating predictive machine learning models for yield forecasting and supply chain optimization.
- Enterprise Governance: Established the organizational data governance and security framework leveraging Microsoft Purview, defining policies for data quality, lineage, and compliance across hybrid environments.
- Strategic Cloud Migration: Advised and contributed to the strategic migration of G42 cloud infrastructure to Microsoft Azure, optimizing compute resources, security protocols, and maximizing ROI.
Lead Azure Data Engineer
Van Oord
Dubai
11.2022 - 12.2023
- Led team in developing data warehousing and analytics solutions with Azure Synapse Analytics and ADLS Gen2, enhancing data accessibility for critical marine operations.
- Architected highly scalable, metadata-driven ingestion frameworks (utilizing PySpark, Databricks Notebooks, and Data Pipelines) capable of handling massive volumes of structured and unstructured data with dynamic schema evolution and error handling.
- Defined semantic layer strategy using SSAS Tabular and Power BI, establishing DAX optimization standards to enable effective executive-level reporting.
Lead Data Engineer
Relevence Lab
12.2019 - 10.2022
- Directed cloud migration from legacy on-premises SSIS to Azure Data Factory and Databricks, maintaining zero downtime for critical workflows.
- Built scalable data processing architectures using Azure Databricks (PySpark), allowing data science teams to efficiently train, deploy, and scale ML models.
- Designed data pipelines for seamless data integration and processing.
- Led team in implementing data governance and quality control measures.
- Collaborated with stakeholders to define data requirements and specifications.
Senior Software Engineer
CGI
Bangalore
02.2014 - 11.2019
- Led architectural design of global financial reporting dashboards, integrating complex backend SQL systems and SSAS tabular models with modern BI tools (Power BI, Spotfire) to enhance data visibility and reporting accuracy.
- Designed and developed interactive dashboards and BI reports using Actuate, Power BI, Excel Reporting, and SpotFire with backend SQL and SSAS tabular model, facilitating data-driven decision-making across teams.
- Global Integration: Standardized data integration workflows globally across ADF, Informatica, and SSIS, ensuring strict regulatory compliance, data masking, and high integrity for the banking sector.
Application Support Engineer
Infosys
Bangalore
08.2011 - 01.2014
- Engineered and integrated customized backend data modules for FINACLE banking software, enhancing data retrieval efficiency through advanced SQL and PL/SQL.
- Collaborated with data team to develop and customize banking software, ensuring alignment with client needs and improving user experience.
- Supported application users by resolving technical issues and inquiries.
- Collaborated with development teams to implement software updates and enhancements.
- Monitored system performance and identified potential areas for improvement.
Education
B-Tech -
Anna University
Skills
- SQL Server
- Microsoft Fabric
- Data Governance
- Microsoft Purview
- Azure Data Factory
- SSAS & DAX
- Synapse Analytics
- Azure Data Bricks
- Power BI
- Azure Logic Apps
- Power Apps
- Power Automate
- Python-PySpark
- Azure Functions
- Microsoft Copilot
- Data modeling
- AI & Machine Learning Integration
- Generative AI Use Cases
- AI-Ready Data Platforms
- Metadata-Driven ETL / ELT Frameworks
Certification
- AZ-900
- DP-203
- DP-700
Accomplishments
Contributed to the adoption of AI-enabled analytics and Copilot-driven productivity use cases, helping shape data platforms that support AI, machine learning, and generative AI initiatives.
• Established and strengthened data governance, data quality, lineage, and security frameworks using Microsoft Purview and Fabric governance capabilities.
• Received client recognition for delivering impactful digital solutions, including Power Apps-based business process automation and data-driven operational improvements.
• Designed and delivered enterprise-grade data platforms using Azure Databricks, Microsoft Fabric, Azure Data Factory, Synapse Analytics, and Data Lake Storage to support advanced analytics and business intelligence. • Received client appreciation for the Power App developed for the safety induction.
• Architected and implemented Microsoft Fabric as a scalable and cost-optimized enterprise data platform for modern data integration, analytics, governance, and AI-ready workloads.
• Led the modernization of ETL/ELT frameworks by migrating data pipelines from on-premises systems to Azure cloud platforms, improving scalability, reliability, and maintainability.
• Built and standardized metadata-driven ingestion and transformation frameworks, enabling reusable, governed, and automated pipelines across multiple source systems.
• Established and strengthened data governance, data quality, lineage, and security frameworks using Microsoft Purview and Fabric governance capabilities.
• Received client recognition for delivering impactful digital solutions, including Power Apps-based business process automation and data-driven operational improvements.
• Designed and delivered enterprise-grade data platforms using Azure Databricks, Microsoft Fabric, Azure Data Factory, Synapse Analytics, and Data Lake Storage to support advanced analytics and business intelligence. • Received client appreciation for the Power App developed for the safety induction.
• Architected and implemented Microsoft Fabric as a scalable and cost-optimized enterprise data platform for modern data integration, analytics, governance, and AI-ready workloads.
• Led the modernization of ETL/ELT frameworks by migrating data pipelines from on-premises systems to Azure cloud platforms, improving scalability, reliability, and maintainability.
• Built and standardized metadata-driven ingestion and transformation frameworks, enabling reusable, governed, and automated pipelines across multiple source systems.
Projects
- Palm Jumeirah, Dubai
- Intellifood, tool for farmers, Audhabi
- Demand planning and forecasting
- Philscan - BCD flight Info
- Deutsche Bank Reporting
- Royal Bank of Scotland - Finacle Banking Software
- Hudson Properties
Domain History
- Marine - Van Oord
- Aviation - BCD - Philscan
- Banking - Infosys
- Capital-marketing - Deutsche Bank
- Real Estate - Hudson
- Food & Farming - Silal
Timeline
Lead Data Warehouse Engineer
Silal (Part of ADQ)
01.2023 - 12.2026
Lead Azure Data Engineer
Van Oord
11.2022 - 12.2023
Lead Data Engineer
Relevence Lab
12.2019 - 10.2022
Senior Software Engineer
CGI
02.2014 - 11.2019
Application Support Engineer
Infosys
08.2011 - 01.2014
B-Tech -
Anna University