Summary
Overview
Work History
Education
Skills
Timeline
Generic

Manthan Surti

Brampton,ON

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

13
13
years of professional experience

Work History

Senior Data Engineer

Equitable Bank
06.2022 - Current
  • Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
  • Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
  • Reduced operational costs by automating manual processes and improving overall data management efficiency.
  • Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
  • Spearheaded efforts to migrate legacy systems onto cloud-based platforms, resulting in improved scalability and costefficiency.
  • Designed and implemented effective database solutions and models to store and retrieve data.

Data Engineer - Specialist

IMAX Corp.
03.2021 - 06.2022
  • Develop, construct, test and maintain Data system Architectures
  • Data acquisition and management from third party
  • Ensure data pipelines are modernized, developed and maintained as per the business requirements
  • Clean, consolidate and transform data
  • Improve data reliability, scalability, and quality
  • Work with vendors to coordinate data migration
  • Decouple application for modernizing infrastructure
  • Create and maintain technical documentations

Data & API Developer

InvestorCOM Inc.
01.2017 - 02.2021
  • Lead Architect for large scale Clients and oversaw Data warehouse implementations
  • Responsible for designing data warehouse, data mapping, data migration and conducting data analysis
  • Design, implement, and continuously expand data pipelines for Canadas top 10 Financial companies such as CIBC, RBC, HSBC, ING by performing extraction, transformation, and loading activities
  • Managed and developed ETL & ELT tools like SSIS, ADF, Azure functions and wrote custom executables and scripts to connect heterogeneous data
  • Collecting, modelling, cleaning, wrangling data for migrations that includes large scale Customer Address, Mutual Funds, Investment Account Data sets Scripting languages: Python, PowerShell, VB
  • Built complex tables, functions, stored-procedures, defined data relationships and constraints in SQL Server
  • Develop Microservice APIs, Web applications for various financial institutions that require sub millisecond response performance
  • Conduct client requirements gathering for preparation of Functional Requirement Document, technical flow and scrum stories
  • Involved in the preparation of Technical Documentation such as Traceability Matrix, Unit Test Cases/Scripts & System Impact Analysis Documents
  • Involved in ITIL Change and Release Management process
  • Part of 24 x 7 on call support team

Application Support Specialist

InvestorCOM Inc.
04.2015 - 01.2017
  • Maintain data pipeline and improve performance for SaaS products serving clients such as BMO, TD, HSBC etc.
  • Investigated and addressed system and data quality issues to enhance usability and improve functionality
  • Setup strong monitoring & alerting using Application Insight and Uptrends
  • Configure and create workflows to automate task/process using VisualCron and Stonebranch
  • Conduct data Load testing & Unit Testing
  • Setup CI/CD pipelines for complex data pipelines that integrates with SaaS applications

Application Development Technologist

City of Hamilton (contract)
01.2014 - 08.2014

Web Developer and Content Editor

Mohawk College (contract)
09.2013 - 12.2013

Intern

Cadila Pharmaceuticals Ltd
07.2011 - 06.2012

Education

Data Science: Computer Engineering -

University of Toronto
04.2020

Computer System Technician - Software Support: Computer Engineering -

Mohawk College of Applied Arts And Technology
12.2014

Bachelor of Computer Applications: Computer Engineering -

Gujarat University
05.2012

Skills

  • Boomi Essentials, Snowflake Cloud Data, Modern Data Warehouse, Hands-on Hadoop, Artificial Intelligence, Azure Data Warehousing and Data Lake
  • Python, SQL, C#, ASPNET & ASPNET CORE, VBNET, HTML 5, JavaScript, JQuery
  • SQL Server, MySQL, Access, Mogo DB, Snowflake
  • Uptrends, Application Insights, Nlogs
  • Datawarehouse, MuleSoft, C, Java, SharePoint, Azure, IIS, Apache Spark, Machine learning, Artificial intelligence, Statistics, NoSQL, Hadoop, Hive, HDFS, MapReduce, Pig, Data Bricks, Cassandra, Kafka, Data modeling, Data Visualization, Agile & Waterfall methodology, Scrum, Azure DevOps pipeline, ITIL, GIT, VSTS, SendGrid, Hortonworks, Ambari

Timeline

Senior Data Engineer

Equitable Bank
06.2022 - Current

Data Engineer - Specialist

IMAX Corp.
03.2021 - 06.2022

Data & API Developer

InvestorCOM Inc.
01.2017 - 02.2021

Application Support Specialist

InvestorCOM Inc.
04.2015 - 01.2017

Application Development Technologist

City of Hamilton (contract)
01.2014 - 08.2014

Web Developer and Content Editor

Mohawk College (contract)
09.2013 - 12.2013

Intern

Cadila Pharmaceuticals Ltd
07.2011 - 06.2012

Data Science: Computer Engineering -

University of Toronto

Computer System Technician - Software Support: Computer Engineering -

Mohawk College of Applied Arts And Technology

Bachelor of Computer Applications: Computer Engineering -

Gujarat University
Manthan Surti