Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Projects
Timeline
Generic

Mohit Kapoor

Halifax,NS

Summary

Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Engineer

Royal Bank of Canada
06.2022 - Current
  • Led design and implementation of ETL pipeline, reducing data processing time by 25%
  • Reduced redundant activities of 3 departments by Building Data Warehouse, Data modelling and Data Ingestion
  • Improved data accuracy by 15% by implemented data quality checks
  • Conducted performance tuning on SQL queries, optimizing data retrieval by 20%
  • Migrated On prem Data Distribution to Azure Cloud Distribution using PYSPARK in less than 1 week.
  • Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.

Software Engineer

Tech Mahindra
05.2018 - 12.2020
  • Facilitated in POCs for Data Migration to Azure delivering 100% efficiency
  • Accomplished 100% consistency in team of 4 members for driving POCs on ETL flows in AWS Glue
  • Attained 100% consistency in team of 4 members towards driving POCs on Data workflow in Azure Data Factory
  • Achieved proficiency in Azure Data Factory, Databricks, ADLS Gen2, Delta Lake and other azure services
  • Mastered in Hive queries for creating and querying HIVE tables to retrieve useful analytical information with 100% consistency.
  • Collaborated with cross-functional teams to deliver high-quality software products on schedule.
  • Estimated work hours and tracked progress using Scrum methodology.

Education

Masters in Applied Computer Science -

St. Francis Xavier University
Noca Scotia
05.2022

Skills

  • Azure
  • Apache Spark
  • Javascript
  • Python
  • SQL
  • Hadoop
  • Cloud-based data platforms
  • Hive
  • Spark-SQL
  • PLSQL
  • Azure Data Factory
  • API
  • Unix
  • Mapreduce
  • Azure Synapse
  • Pyspark
  • Data Ingestion
  • GraphQL
  • Data Mining
  • Big Data Processing
  • Data Analysis
  • Hadoop Ecosystem
  • Data Governance
  • Data Warehousing
  • Data Security
  • SQL Programming
  • Data Migration
  • SQL and Databases
  • Data Analytics
  • Data Pipeline Design
  • Performance Tuning

Certification

Microsoft Certified: Azure Data Engineer Associate DP203, 02/2024, 02/2025, 996197296

Accomplishments

  • Finos BMO Hackathon, 05/2023, Awarded 2nd prize amongst 66 participants by working on LCR Morphir use case
  • Tech Mahindra Best Team Innovation Award, 02/2019, Worked in a Team of 4 to come up with a solution on generating regulatory reports by building algorithms.
  • Technical Event Organizer, 03/2017, Successfully conducted 1st ever Technical Event named Debugging at College Technical Fest with gathering of 20,000 people.

Projects

Customer 360 Analytics, Executed data-driven analysis using Azure Databricks and Data Factory to uncover customer order patterns. Providing valuable insights that enhanced customer engagement strategies, resulting in increasing repeat orders count by 30%., Led a comprehensive analysis of customer spending, utilizing SQL queries and data aggregation, resulting in actionable insights for targeted marketing efforts and a notable 20% increase in campaign effectiveness.

Timeline

Data Engineer

Royal Bank of Canada
06.2022 - Current

Software Engineer

Tech Mahindra
05.2018 - 12.2020

Masters in Applied Computer Science -

St. Francis Xavier University
Mohit Kapoor