Skip to content
View avanit-singh's full-sized avatar

Block or report avanit-singh

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
avanit-singh/README.md

Hi, I'm Avanit

Data Nerd | Engineer | Azure | Databricks | PySpark | SQL | Fintech & Banking Domain

📫 Let's Connect!

LinkedIn Email


About Me

I am a data-first professional specializing in enterprise-grade cloud architectures, pipeline orchestration, and compute optimization. I build highly reliable reporting systems that accelerate downstream analytics while keeping infrastructure costs lean.

What I do:

  • 🚀 Building Pipelines: Developed and maintained ETL pipelines using PySpark and Apache Airflow, reliably processing 250GB+ of daily financial and transaction data while consistently meeting upstream and downstream SLAs.
  • 🛡️ Ensuring Reliability: Decreased pipeline failures by 25% by writing rigorous data quality checks with Great Expectations, ensuring data integrity for critical KYC/AML and merchant analytics reporting.
  • 💡 Optimizing Compute: Optimized complex PySpark jobs and implemented efficient table partitioning, reducing daily batch processing times by 20% and lowering cluster compute costs.
  • 🌱 Currently Exploring: Deepening my knowledge in Databricks Unity Catalog for enhanced data governance and exploring streaming data architectures with Apache Kafka.


🛠️ My Tech Stack & Domain Expertise

Languages & Libraries
Python Pandas NumPy SQL

Big Data & Data Processing
Apache Spark PySpark Databricks

Cloud Infrastructure
Azure Data Lake Storage Azure Data Factory Azure Databricks AWS Databricks

Visualization
Power BI Advanced Excel

Domain Knowledge
Fintech Payments BFSI Merchant Analytics KYC/AML


💻 Featured Projects

Project Tools Description
💳 Azure Card Transaction ETL Pipeline ADF ADLS Databricks PySpark End-to-end ETL pipeline for Master/Visa transaction data
🏦 Customer Churn Analysis SQL Python Power BI Churn driver analysis for banking customers
🛒 Merchant Analytics Dashboard SQL Python Power BI Payment gateway and settlement performance tracking
📈 Banking KPI Dashboard SQL Power BI Excel Executive CASA and loan disbursement reporting

Pinned Loading

  1. azure-card-transaction-etl-pipeline azure-card-transaction-etl-pipeline Public

    Cloud-based ETL pipeline that ingests credit Master/Visa transaction records, processes them using PySpark on Azure Databricks, and stores cleaned data in Azure Data Lake Storage (ADLS Gen2)

    Python

  2. merchant-transaction-analytics merchant-transaction-analytics Public

    Merchant Transaction Analytics Dashboard

    Python

  3. banking-kpi-dashboard banking-kpi-dashboard Public

    Python

  4. Customer-Churn-Analysis-for-Banking-Customers Customer-Churn-Analysis-for-Banking-Customers Public

    Analyse banking customer data to identify factors contributing to customer churn and account inactivity. Perform data cleaning, segmentation, and trend analysis using SQL and Python. Develop Power …

    Python