top of page

Streamlined Investment Data Pipeline (Azure & SQL Server)

Designed and automated a data warehouse system for a leading investment firm.

My role: 

Senior DBA & Database Developer

This project involved:


  • Building a scalable SQL Server data warehouse for asset management data.

  • Implementing CI/CD in Azure DevOps for efficient deployment.

  • Developing ETL processes (T-SQL) to integrate new data sources.

  • Automating data workflows with VisualCron for streamlined operations.

  • Creating data export functionalities for regular reporting (PowerShell).


Skills and deliverables

bottom of page