Kumar Vishwajit
Bengaluru
Summary
Experienced Full-Stack Data Professional with over 16 years in building and optimizing enterprise data solutions, including data warehouses and lakes on AWS, Snowflake, and Teradata. Specializes in high-volume OLTP, near real-time analytics, and scalable ELT pipelines. Led data modernization initiatives that enhance performance and scalability, integrating data engineering and analytics to drive measurable business outcomes.
Overview
19
19
years of professional experience
Work History
Data Architect
bigbasket
11.2024 - Current
- Project: Re-Architecting Data Platform for Quick Commerce at Hyper-Scale
- Project Overview: Designed and implemented a modern Lakehouse architecture to transform a legacy batch-processing data platform into a real-time, scalable analytics ecosystem supporting hyper-scale quick commerce operations. The platform was engineered to process nearly one million daily orders across 2,000+ cities while meeting stringent 10-minute delivery service-level agreements (SLAs) across grocery, electronics, and pharmaceutical categories
- Analyzed existing batch-processing data warehouse limitations and defined the target-state architecture for scalable, low-latency data processing.
- Analyzed batch-processing data warehouse limitations; defined target-state architecture for scalable, low-latency data processing.
- Reconciled data between Redshift legacy reports and DBT-generated datasets to ensure accuracy.
- Created data models and analytical datasets supporting delivery SLA monitoring, stock availability, rider productivity, picker performance, and recommendation systems.
- Converted Redshift transformations SQL scripts into modular, reusable DBT models
- Developed data models and analytical datasets for delivery SLA monitoring, stock availability, rider productivity, picker performance, and recommendation systems.
- Participated in architecture reviews, performance tuning, troubleshooting, and production support activities.
- Collaborated with business stakeholders, product teams, operations teams, and data consumers to gather requirements and deliver analytical solutions.
- Designed, developed, and supported enterprise reporting solutions for PSR vs GST compliance, promo, and financial reconciliation reporting.
- Organization
- Tata Enterprise
- Team Size
- 12
- Tech Stack
- AWS (S3, redshift ), Apache Iceberg, Apache Spark, DBT, Trino, StarRocks, Apache Airflow, OpenMetadata, CDC Pipelines, Data Lakehouse Architecture, SQL, Data Governance, Real-Time Analytics.
Database Architect
FedEx
11.2022 - 10.2024
- Project Description: The objective of this project is to merge data from multiple source systems (Manhattan and Flare) into a single, integrated enterprise data platform for FedEx. The initiative delivers a consolidated view of supply chain and logistics data, rebuilds legacy reports on the new data model to ensure full functional parity, and cleanses and harmonises master data to support accurate decision-making and improve overall database efficiency.
- Delivered functional and technical solutions to data engineers and data modelers, enabling development of effective, scalable data solutions.
- Provided functional and technical solutions to data engineers and data modelers to deliver effective, scalable data solutions.
- Led performance monitoring, query optimization, and database design reviews, establishing developer guidelines and standards.
- Replicated reporting functionality of legacy systems (Manhattan, Flare) within the new unified data model.
- Managed metadata and spearheaded master data cleansing and harmonisation initiatives, ensuring data accuracy and consistency.
- Created test strategies and script writing standards for business reports and ETL data loads.
- Owned client sign-off process for business reports through demo and validation sessions.
- Organization
- Mphasis
- Team Size
- 15
- Tech Stack
- Oracle Cloud, Analytical SQL, PL/SQL, ER/Studio
Technical Lead / Technical Manager
BigBasket/ Norstella
04.2016 - 09.2022
- Project Description: Big basket is India’s largest online food and grocery store where customers can place orders through website and mobile app. We maintain data warehouse for data analytics, forecasting and predictive analysis, big data analytics.
- Led team of data engineers in delivering data solutions, ensuring alignment with project goals.
- Designed and implemented a scalable Snowflake-based Data Warehouse to integrate data from multiple recently acquired companies for Norstella
- Implementation of data lake and micro services and reporting solution .
- Database modeling and creating ETL pipelines and ETL mappings
- Design and implemented development best practices ,review code and artifacts
- Data base scripting and creating data pipeline.
- Performance Tuning, optimization with varies databases
- Creating base data for power bi reporting creating DAX function logic Point to connect for web analytics data (clickstream, snowplow).
- Led third project phase to enhance data analytics.
- BigBasket Data Analytics
- Organization
- Mindtree Ltd
- Team Size
- 15
- Tech Stack
- AWS Redshift, SQL, Python, PowerBI ,Unix sell , Snowplow,EMR,S3,Data modeling , Toad data modeler
Team Member
Bed Bath & Beyond
02.2014 - 04.2015
- Project Description: The objective of this project was to make supply chain foundation data — spanning claims and supply chain modules — available on an in-memory database platform. The project focused on logical and physical data modeling, ETL mapping design, and building analytical SQL layers to support the data analyst team with reliable, validated data.
- Designed logical and physical data models for supply chain foundation data, enhancing data accessibility.
- Developed ETL mapping logic and analytical SQL, supporting data analysts with reliable insights.
- Executed database scripting, data validation, and quality checks to ensure data integrity and accuracy.
- Data Analytics for In-Memory DB
- Compact Solutions
- Team Size
- 10
- Tech Stack
- SQL, Analytical SQL, Teradata, Erwin 9.5, Embarcadero ER/Studio
Team Member
Barclays Bank PLC
01.2012 - 09.2014
- Project Description: Barclays is a global financial services provider serving over 48 million customers across 50+ countries, engaged in retail and commercial banking, credit cards, investment banking, and wealth management. This project involved building and supporting the Prime Card Information Warehouse for Western Europe — a critical data warehousing initiative focused on LDM/PDM implementation, semantic layer development, and Teradata performance tuning.
- Developed semantic layers integrating physical data models with reporting cubes, enhancing data accessibility and reporting accuracy.
- Performed dependency analysis and target data validation.
- Created and modified MLOAD and BTEQ scripts for efficient data loading and transformation processes.
- Optimized Teradata SQL performance through targeted tuning and query refinement.
- Prime Card Information Warehouse
- Organization
- Mahindra Satyam Computer Services Ltd
- 10
- Tech Stack
- SQL, PL/SQL, Shell Script, Oracle 10g, PL/SQL Developer
Team Member
American Express
05.2012 - 07.2013
- Project Description: American Express is a global financial services leader, accounting for approximately 24% of total US credit card transaction volume. This engagement involved a large-scale database transformation project migrating stored procedures and data structures from Sybase to Teradata, along with ETL data analysis, semantic layer development, and data validation to support the reporting and analytics infrastructure.
- Analysed stored procedure dependencies, migrating procedures from Sybase to Teradata to enhance database performance.
- Reviewed operational data structures, recommending optimisations and reconfigurations to improve ETL processes.
- Developed semantic layers to support integration between physical data models and reporting cubes using Teradata Window functions and analytical SQL.
- Validated data quality across migrated objects, ensuring accuracy and reliability for reporting and analytics.
- Amex IDN Transformation
- Organization
- Cognizant Technology Solutions
- 30
- Tech Stack
- SQL, Analytical SQL, Teradata, Erwin 9.5, Embarcadero ER/Studio, Teradata Window Functions
Team Member
Punjab & Sind Bank
11.2007 - 03.2012
- Project Description: Punjab & Sind Bank is a strong nationalized bank in India that implemented Oracle Flexcube — a leading core banking solution trusted by over 330 financial institutions across 115 countries. The implementation covered Retail, Corporate, and Internet Banking modules and is recognised as one of the fastest CBS implementations for a public sector bank in India.
- Developed and customised SQL, PL/SQL, and UTL_FILE scripts to enhance database functionality.
- Created FCR, migration, and statistical reports using Oracle 10g analytical functions for Retail Banking.
- Conducted Root Cause Analysis (RCA) to identify and resolve functional and technical issues, improving system reliability.
- Prepared mapping and transformation logic to align with requirement specifications, ensuring accurate data integration.
- Prepared mapping and transformation logic per requirement specifications.
- Performed SQL tuning, troubleshooting, and database performance optimization.
- PSB Core Banking Implementation
- Organization
- Satyam Computer Services
- 5
- Tech Stack
- SQL, PL/SQL, Shell Script, Oracle 10g, PL/SQL Developer, Oracle Flexcube (FRS, FCC, FCR)
Education
A' Level / PGDCA -
C-DAC / C-EDTI
Mohali01-2001
B.A. - Economics (Hons)
Magadh University
Patna, India01-1999
Intermediate (10+2) -
B.I.E.C
An College 01-1995
High School (10th) -
B.S.E.B
Patna, India01-1993
Skills
Data Engineering & Analytics
Data Lake & Lakehouse Architecture
Warehouse design
ETL/ELT Pipeline Development (DBT, CDC, SQL, Python)
Data Modeling (Dimensional, Physical & Logical)
Big Data Technologies
Cloud Data Platforms (AWS, Snowflake, Redshift, Trino)
Advanced SQL Development & Query Performance
Data quality assurance
Data migration
Data Pipeline Optimization
Business Intelligence & Reporting
Data Visualization Techniques
Accomplishments
- Recognized by FedEx client in 2021 for outstanding delivery and technical contributions.
- Awarded ‘Most Dedicated Employee of the Year’ at Mindtree for three consecutive years (2018–2020).
- Part of the team that executed one of the fastest CBS (Core Banking System) implementations in India for a public sector bank (Punjab & Sind Bank).
- Appreciated by Barclays for completing the Prime Card Information Warehouse project ahead of schedule.
Timeline
Data Architect
bigbasket
11.2024 - Current
Database Architect
FedEx
11.2022 - 10.2024
Technical Lead / Technical Manager
BigBasket/ Norstella
04.2016 - 09.2022
Team Member
Bed Bath & Beyond
02.2014 - 04.2015
Team Member
American Express
05.2012 - 07.2013
Team Member
Barclays Bank PLC
01.2012 - 09.2014
Team Member
Punjab & Sind Bank
11.2007 - 03.2012
A' Level / PGDCA -
C-DAC / C-EDTI
B.A. - Economics (Hons)
Magadh University
Intermediate (10+2) -
B.I.E.C
High School (10th) -
B.S.E.B