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 Scotia05.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