# Faris Hussain (@farishussain.eurosky.social)

Profile: https://sifa.id/p/farishussain.eurosky.social
Headline: Energy @AI | Data & AI Engineer |  Sr. Data Vault Arch | M.Sc Artificial Intelligence of Autonomous Systems

## About

Hey Faris Here :D

A Data & AI Engineer at the intersection of modern data engineering and agentic AI currently building production-grade data platforms and autonomous trading systems at enmacc, a leading OTC energy trading marketplace in Munich.

My work spans the full data stack: designing scalable Medallion architectures on AWS (Glue, S3, Lake Formation, Lambda), orchestrating pipelines with Apache Airflow, and provisioning cloud infrastructure via Terraform and AWS CloudFormation. 
I've also led an analytics transformation from Power BI/Tableau to ThoughtSpot, enabling natural language search analytics for trading decisions.
On the AI side, I'm deep in agentic R\&D designing goal-oriented trading agents using Google ADK and Amazon Bedrock, and completed my M.Sc. thesis on LLM Multi-Agent Systems in OTC energy liquidity simulation (benchmarking Gemini 2.5 Flash agents against deterministic rule-based agents in RFQ dynamics).

Before enmacc, I spent 5+ years in enterprise data engineering:

• At Royal Cyber, I migrated legacy insurance and finance systems to Snowflake using Data Vault 2.0, with Talend, Kafka, and Airflow.

• At Astera Software, I was a core contributor to their Data Warehouse Builder a low-code, metadata-driven DWH creation platform with automated Data Vault generation.

My technical toolkit: Python, SQL, PySpark, Snowflake, AWS, Azure, Databricks, Apache Kafka, Spark, Data Vault 2.0, Kimball, Medallion Architecture, LLMOps, PyTorch, TensorFlow, ThoughtSpot, Terraform, Docker, GitHub Copilot, Cursor.I believe the best data architecture is the one that actually works and I build data systems that scale with business reality, not just technical ambition.

## Experience

- **Platform Data Engineer at enmacc** (2025 – present)
  • Modern Data Architecture: Engineered end-to-end data solutions for high-velocity trading environments.
  • Cloud Infrastructure (IaC): Provisioned and managed robust cloud environments using Terraform and AWS CloudFormation.
  • Data Engineering & ETL: Developed production-grade data pipelines using AWS Glue, S3, Lake Formation, and Lambda to handle complex, real-time datasets.
  • Observability & Orchestration: Implemented Apache Airflow to automate workflows and provide deep observability into data pipeline health and performance.
  • AI-Augmented Development: Accelerated the software development lifecycle (SDLC) by integrating AI pair-programming tools like Cursor, GitHub Copilot, and Gemini to deliver production-ready code with increased velocity.
  • Agentic AI & R&D For Master Thesis: Spearheaded R&D for an Agentic Energy Trading Marketplace, leveraging Google Agentic SDK (ADK) to build autonomous, goal-oriented trading agents.
- **Senior Data Vault Engineer at Royal Cyber Inc.** (2023 – 2024)
  • Designed and implemented ETL pipelines, resulting in improvement in data accuracy across multiple business units.
  • Migration of legacy systems to modern architecture Snowflake with Data Vault 2.0 methodology.
  • Streamlined workflow processes by developing advanced SQL queries for batch processing with Talend.
  • Automated data orchestration using Airflow and optimized data modeling with VaultSpeed.
  • Delivered scalable cloud architectures on Snowflake, SAP Hana, and SAP BODI, showcasing adaptability in diverse platforms.
  • CI/CD deployments using Azure DevOps in an agile environment and handled client requests via ServiceNow.
  • Managed version control and collaboration through Git repositories, ensuring smooth team collaboration and production readiness.
- **Senior Data Engineer at Royal Cyber Inc.** (2023 – 2024)
  • Migrated legacy insurance and finance systems to modern data warehouse architecture on Snowflake using Data Vault 2.0 methodology, supporting multiple source systems and enterprise DWH setup.
  • Designed and implemented ETL pipelines with advanced SQL query logic for batch processing (Talend) and streaming (Kafka), resulting in measurable improvement in data accuracy across business units.
  • Automated data orchestration using Airflow and optimised data modelling with VaultSpeed; integrated SAP Hana and SAP BODI platforms.
  • Managed development & production deployments in an agile environment with CI/CD via Azure DevOps; handled client requests through ServiceNow and version control via Git.
- **Senior Data Warehouse Engineer at Astera Software** (2022 – 2023)
  • Data Vault Automation Product Development R&D.
  • Designed and implemented data pipelines for data science projects.
  • Constructed data warehouses using Azure Synapse Analytics.
  • Proficient in implementing Data Vault 2.0 methodologies.
  • Familiarity with data orchestration and monitoring systems such as Airflow.
  • Expertise in tools -> Informatica, Talend, Centerprise, TimeXtender, Erwin, Data Factory.
- **Data Integration Engineer at Astera Software** (2020 – 2022)
  • Experience in designing and maintaining efficient data pipelines and data warehouses, including experience with various database providers such as Snowflake, Redshift, Oracle, SQL Server, and Azure.
  • Familiarity with various database architectures and best practices for data warehouse implementation.
  • Skilled in report mining and building report models, including experience with professional tools such as Talend, Informatica, WhereScape, Erwin, and TimeXtender.
  • Proficiency in API integration, including REST API and Postman testing, as well as experience with EDI integration including EDI 856, 850, 837, and others.
  • Experience in analyzing current software systems and identifying changes for product improvement, as well as proficiency in designing, automating, monitoring, scheduling, and tuning ETL batch processes and creating technical documentation for ETL mapping.
  • Proficiency in SSMS, SSIS, and SSAS, and hands-on experience with cloud platforms Azure Synapse Analytics and Azure Data Factory.
  • Experience in building Data Vault 2.0 for business agility, scalability, and adaptability.
  • Ability to handle customer issues and respond to customer queries.
- **Data Integration Intern at Astera Software** (2020 – 2020)
  • Test Centerprise ETL Tool Build Quality.
  • Run test cases of ETL for performance testing.
  • Interact with customers to overcome the issues they faced while using the ETL tool, Centerprise.
  • Compare market tools like Talend, Informatica, Wherescape, and Erwin with Centerprise
- **Network Engineer at qordata** (2020 – 2020)
  Proven ability to manage and maintain IT assets; development of Excel graphs to demonstrate cost and savings. Adept in network monitoring systems, Office 365, Windows Server 2012, and automation using Python, Selenium, and Excel VBA.

## Education

- **St. Patrick's High School, Karachi** — S.Sc (2006 – 2014)
- **Institute of Business Administration** — Postgraduate Diploma (2023 – 2023)
- **Technische Hochschule Ingolstadt** — Master of Engineering - MEng (2024 – 2026)
- **NED University of Engineering and Technology** — Bachelor of Engineering - BE (2016 – 2020)

## Skills

- Data Processing
- MapReduce
- Data Marts
- Data Mining
- Data Science
- Apache Kafka
- SAP
- Amazon Web Services (AWS)
- AWS
- Data Loading
- Data Transformation
- DataStage
- Data Services
- PySpark
- Python
- Docker
- Machine Learning
- Generative AI
- Git
- Extract, Transform, Load (ETL)
- Fivetran ETL Tool
- Autonomous Vehicles
- Thoughtspot
- VaultSpeed
- Reinforcement Learning
- Microsoft Power BI
- SQL Server Analysis Services (SSAS)
- erwin Data Governance
- Database Design
- PyTorch
- Oracle Database
- Transact-SQL (T-SQL)
- Python (Programming Language)
- Continuous Integration and Continuous Delivery (CI/CD)
- SQL
- Kimball
- Azure DevOps
- Terraform
- Data Operations
- Data Vault
- Pandas (Software)
- Technical Architecture
- Artificial Intelligence (AI)
- Search Analytics
- SQL Azure
- Data Governance
- SQL Server Reporting Services (SSRS)
- ETL Tools
- Relational Databases
- ISEB Diploma in Business Analysis
- TensorFlow
- Data Engineering
- Data Architecture
- Prompt Engineering
- Transformer Models
- Large Language Models (LLM)
- Data Warehousing
- Amazon Bedrock
- Apache Spark
- Large Language Model Operations (LLMOps)
- Azure Data Factory
- Snowflake
- Enterprise Data
- Big Data Analytics
- Amazon Redshift
- Data Profiling
- API Testing
- Azure Data Lake
- Enterprise Data Modeling
- Hadoop
- Pipelines
- Data Warehouse Architecture
- Apache Airflow
- Business Knowledge
- Data Modeling
- Informatica PowerCenter
- Modeling
- Dimensional Modeling
- SQL Server Integration Services (SSIS)
- Agentc AI
- Cloud-Native Architecture
- Learning Analytics
- Microsoft Excel
- Microsoft SQL Server
- Talend
- Data Visualization
- Databases
- Microsoft Azure

## Certifications

- Corporate Regulatory and Compliance Training — enmacc
- Data Science Foundations - Level 1 — IBM (https://www.youracclaim.com/badges/4c196d12-eb76-43d2-8b70-9c2d94f54026/linked_in_profile)
- CCNA R&S: Introduction to Networks — Cisco (https://tinyurl.com/CCNA-R-S-Intro-to-Networks)
- Introduction to SQL — DataCamp (https://www.datacamp.com/statement-of-accomplishment/course/61f17bf337160e14a24df18d7543e9f804e5b4cf)
- Data Warehousing — Udemy (http://ude.my/UC-ba52a7df-e898-46d7-905e-4c74cbd086cd)
- SQL (Advance) — HackerRank
- Hands On Essentials - Data Warehouse — Snowflake (https://www.credly.com/badges/6aae486a-9f66-4dba-a28d-a3919221a59e/linked_in_profile)
- Fortinet's Network Security Expert NSE 2 — Fortinet
- Get Connected — Cisco (http://tiny.cc/cisco-getconnected)
- Fortinet's Network Security Expert NSE 1 — Fortinet

## Projects

- **Data Warehouse Modernization**
  Technologies: Snowflake, Kafka, Data Vault 2.0, VaultSpeed, Talend, SAP, Mainframe, DB2, Python  Worked on multiple modernization initiatives to transition legacy insurance and finance data systems to a scalable, cloud-based Data Warehouse architecture using Data Vault 2.0 methodology:  Mainframe
- Life 70 Insurance Policy Migration: Ingested insurance data from Mainframe to Snowflake via Kafka, implementing Data Vault 2.0 principles for real-time and historical data handling.

SAP Finance Integration: Designed Data Vault 2.0 architecture for multiple SAP sources using VaultSpeed. Implemented models in Snowflake and managed historical incremental loads via Talend.

FARTDB Integration: Incorporated the FARTDB system into the Enterprise Data Warehouse using a unified Data Vault model.

SAP BODI Decommissioning: Migrated ETL logic from SAP BODI to Talend, with destination transition from DB2 to Snowflake. Automated ETL processes using Python to ensure seamless and maintainable operations.
- **Data Warehouse Builder (DWB) – Product Development** — https://www.astera.com/products/data-warehouse-builder/
  Contributed to the development of Astera DW Builder, an end-to-end data warehousing product that enables users to design, build, and automate data warehouses using industry best practices and metadata-driven architecture.

Played a key role in implementing out-of-the-box support for Data Vault methodologies and ETL orchestration.

Helped shape the platform’s capabilities to enable non-technical users to design and deploy scalable, modern data warehouses.

Collaborated with product teams to improve usability, performance, and automation features.
- **REST API Browser – Feature Development** — https://www.astera.com/type/blog/we-welcome-2021-with-the-release-of-astera-centerprise-8-5/
  Designed and implemented the REST API Browser feature in Astera Centerprise, enabling users to seamlessly connect to supported APIs via import sources or file paths.

Developed functionality to auto-discover and expose HTTP methods (GET, POST, PUT, PATCH, DELETE) from API clients.

Enabled easy integration of external APIs into the data pipeline workflow with minimal configuration.

Improved user experience for building API-based dataflows and automated data extraction.
- **Data Engineering Technical Challenge**
  This project presents a data pipeline developed to ingest, transform, and store energy data from the Energy-Charts API. The pipeline supports BI/ML use cases, ensures data quality, and uses Change Data Capture (CDC) for consistent data updates. Data is stored in Delta tables and processed with PySpark.

## Volunteering

- Event Coordinator at Usman Institute of Technology
- Event Planner at Character Building Society
- Fundraiser at National Accountability Bureau
- Basic First Aid & Fire Fighting at Federal Civil Defence Training School

## Languages

- German (elementary)
- English (native)
- Urdu (native)

## Other profiles

- linkedin: https://www.linkedin.com/in/farishussain
- github: https://github.com/farishussain
- instagram: https://www.instagram.com/waymorefar_is