BigQuery DBT - Cloud Data Platform

Developed and implemented a modern data platform to get actionable business insights from a fictional pizza store's day-to-day sales data. The project leverages an open-source modern data stack, incorporating tools like Apache Airflow for orchestration, dbt Core for data transformation, BigQuery as the data warehouse, Python-based jobs for data processing, and Lightdash for analytics and visualization. (more...)

Please note: This project is active and operates on a weekly batch cycle. It employs intelligent Python scripts to generate and insert synthetic daily transactions, simulating real-world activity in a pizza store.

MCP - LLM integration

In this project, I have integrated a Large Language Model (LLM) with a custom-built application to enhance its functionality. The LLM is used to process and analyze user inputs, providing intelligent responses and insights. The integration allows the application to leverage the power of natural language processing, enabling it to understand and generate human-like text. Link to Medium Article for more details on the project.

MockDataGen

MockDataGen is a Python-based utility (PyPi) designed to generate synthetic data for testing and development purposes. It allows users to create realistic datasets that mimic real-world data structures, enabling developers to test applications without relying on sensitive or proprietary information. The tool supports various data types and formats, making it versatile for different use cases. (more...)

DMA - Automation of Data Model's

Designing a robust data model is often a iterative process and is implemented in layers (Conceptual/Logical/Physical Data Model). The aim of this project is to cutdown on this effort and allow fast protyping, also allowing a Business user to create Data Models from scratch without understanding the knowhow of RDBMS systems (more...)

SCUP - Universal SQL Translator Utility

This utility allows user to run easy to remember SQL code's Ex- heck Database Online or Describe table and takes care of running complex queries for choosen RDBMS in the background.. (more...)