About

Experienced data professional specializing in data warehousing, analytical, and transactional solutions. Skilled in Python, SQL & ETL/ELT with a strong focus on problem-solving and delivering robust data-driven solutions for Supply Chain and banking sectors.

Work Experience

Tata Consultancy Services
Toronto, Canada
Hybrid

2022 - Pres.

Data Engineer

Part of Enterprise Risk & Basel reporting team. Collaborated across technical and business units to ensure seamless data flow for critical BASEL 3.1 reforms and OSFI BCAR Reporting.

Leveraged python’s data libraries (pandas, numpy, pyodbc) to establish a framework of data quality and validation. Achieved a 90% reduction in technical debt, inaccuracy, and manual efforts. Crafted effective end-to-end data quality test strategies.

Performed data profiling and analysis to identify patterns, anomalies, and data quality issues. Designed and executed SQL & Python test cases within internal frameworks. Designed creative methods to enhance data pipeline testing efficiency.

Tata Consultancy Services
Mumbai, India

2019 - 2022

Technical Consultant

Technical & functional consultant for the Oracle Business Suite of an F500 MFG company, provided contextual solutions & developed reports, dashboards, interfaces, extensions, and automation.

Engineered an analytics tool utilizing decision matrices derived from patterns in past order data to classify the cause of order misses, eliminating manual reporting.

Improved order processing by 5x by implementing an event-driven system and addressing system integration issues.

Designed a Data Adjustment utility that streamlined critical data issue resolution from 4 hours to 15 minutes.

Developed dynamic billing & repricing transactional flows, contributing to increase revenue growth and minimizing customer claims.

Education

Toronto Metropolitan University
Toronto, Canada

2023 - Pres.

Master of Science - Data Science and Analytics

JSS Academy of Technical Education
Noida, India

2015 - 2019

Bachelor of Technology - Electronics and Communication

Skills

Python
Numpy/Pandas
Pyspark
SQL
PLSQL
Git
Linux
Azure
Docker
DBT
Airflow
Large Language Models

Projects

world energy statistics

World Energy Statistics using various data tools.

Spark
Docker
Hive
Airflow

cinemattr

Search movies using AI and vector databases.

LangChain
SvelteKit

server compose

A collection of sample docker compose files for self-hosted applications.

Docker
Linux

recomovi

Movie Recommender & IMDb Dataset Generator.

Python
Streamlit

microHMS

Hotel Management System to track bookings and generate invoices.

Flask
PostgreSQL

vizima.in

Website for a hospitality company.

Next.js
Firebase

carteakey.dev

Personal Blog and Website

Eleventy
Tailwind

Certifications