I developed RESTful APIs and backend business logic at Klydar using .NET Core and C#. I also designed SQL Server database schemas and implemented data access with Entity Framework Core and LINQ.
For a healthcare patient records data warehouse project, I designed a Star Schema with fact and dimension tables for clinical reporting. I wrote SQL queries using window functions, CTEs, and aggregations for patient outcome analysis and data validation.
I built a retail ETL pipeline with SSIS to load data from an OLTP system into a Star Schema warehouse. It included Type 1 and Type 2 dimension handling and incremental fact loading across six SSIS packages orchestrated by a master package.
I also built a real-time property listings pipeline with Apache Kafka and Python, loading processed events into a SQL Server warehouse. For a Walmart retail data warehouse project, I worked with Databricks, Apache Airflow, and dbt on a medallion-architecture pipeline with Type 2 dimensions and automated tests.
