Chirag Bisht

About Chirag Bisht

I am a seasoned Data Engineering & Software Development professional with around 8 years of experience architecting large-scale data solutions, building high-performance pipelines, and enabling organizations to unlock the true value of their data. My expertise lies in designing resilient data architectures, developing robust ETL/ELT frameworks, and leading teams to deliver scalable, efficient, and high-quality engineering solutions.Key Highlights: • Designed and implemented real-time data pipelines using Kafka, Apache Airflow, Delta Lake, and SQL-based warehouses to power real-time reporting and dashboards. • Built and optimized ETL processes with SSIS and Azure Data Factory for seamless data integration across multiple operational systems. • Architected microservice-based OLTP databases to handle large-scale, high-volume transactions with zero-downtime strategies and high availability via master-slave architecture. • Established Master Data Management (MDM) frameworks to ensure consistency, governance, and cross-platform usability of enterprise data. • Strong background in performance tuning, query optimization, and advanced partitioning strategies, ensuring scalable and efficient database operations. • Experienced in designing and developing database components (tables, views, triggers, stored procedures, UDFs) using Transact-SQL. • Programming foundation in C#, VB.Net, and Python with an ability to bridge software engineering best practices with data-driven architectures.I bring a unique blend of technical depth and business acumen, helping organizations build future-ready data platforms while aligning technology initiatives with company goals. Passionate about solving complex problems, optimizing systems for performance, and enabling data-driven decision-making at scale.

Experience

1. Lead Database Developer

   Vichara Technologies

   Apr 2024 — Present · Gurugram, IN

   Spearheading the development of vCMBS, a flagship loan-level analytics platform empowering CMBS traders, portfolio managers, risk teams, and analysts with automated underwriting, reporting, exposure management, and risk surveillance, enabling faster and smarter CRE market decisions.• Collaborating with stakeholders, product managers, and engineering teams to design and deliver scalable data solutions, integrating diverse datasets through ETL pipelines and Apache Airflow-driven workflows.• Leading database architecture and optimization using SQL Server and SSIS, ensuring robust ingestion, transformation, and real-time delivery of high-volume datasets.• Driving adoption of AI and automation: developed an AI chatbot to enhance user experience and implemented n8n-powered workflows that streamline critical business operations.• Leveraging Python scripting for data automation, risk modeling, and cloud-native processing—improving scalability and reducing manual effort in key workflows.•Enhancing SQL query performance to boost data retrieval efficiency and system responsiveness.•Partnering with clients to deliver actionable insights through data manipulation, ETL processes, and analytics visualization tools, maximizing decision-making impact.• Exploring and deploying Generative AI (GenAI) solutions for natural language query handling, dynamic summarizations, and automated report generation, driving productivity and innovation across teams.

Education

• Inderprastha Engineering College

  Bachelor of Technology, Computational Science

• INDERAPRASTHA ENGINEERING COLLEGE, GHAZIABAD

  Bachelor of Technology, Computer Science

  2014 — 2018