Mihir Dhakan

Data Enthusiast

My Elevator Pitch 👋🏽

My name is Mihir Dhakan and I am a Data engineer based in Toronto, Canada who loves to mingle with Data to achieve a positive business impact. My engagements involve end-to-end from requirements gathering, data modelling and data flow design, mapping document creation, Extract-Transform-Load (ETL) development, testing, Production deployment and support (bug fixes and/or enhancements). Specializes in Hadoop Eco-system components such as Hive, Sqoop, HDFS, Big Data, ETL, Data Analysis and Data Warehousing. Has a broad exposure in various industries such as Banking, Finance and Media.

Currently, I am working with Tata Consultancy Services, where I lead ETL & Data driven projects. I get a chance to use my superpowers to provide a better data insights and based on which customer-centric decisions can be taken.

When I am not trying to build a data-pipeline, you can find me exercising to maximize gains, playng lego with my champ, writing blogs, or escaping reality in another country.

What I'm good at 👨🏽‍💻

Languages

  • Scala
  • Python

Data Processing

  • Spark
  • Pandas

NoSQL

  • MongoDB
  • Cassandra

Storage

  • HDFS
  • Parquet
  • Avro
  • JSON

Cloud

  • Google Cloud
  • AWS

SQL

  • Teradata
  • Hive
  • Redshift

My 9-5 Experiences 💼

Below I have illustrated a timeline of my work experiences. For a brief overview of my most important tech-driven roles, check out my résumé.

Aug 2021 - Till Date
Analyst
Aug 2021 - Till Date

Lead various data projects involving HR, Finance, Customer Analytics domain.

Jun 2018 - Jul 2021
Assistant Vice President 5
Jun 2018 - Jul 2021

Lead various data warehouse projects with in-house as well as vendor driven pace involving (GCFR) Control Flow Framework (In-house Framework), Data Stage, Teradata, HDFS, Spark, Hive.

Mar 2018 - Jun 2018
Comtel Solutions Pte Ltd, Singapore
Senior Consultant
Mar 2018 - Jun 2018

Extensively using Teradata Database and various in-house built Frameworks for ELT, data analysis and data discovery across the projects involving Audit, Risk domains.

  • Teradata
  • SQL
  • Data Piplelines
  • Python
Dec 2017 - Mar 2018
Accion Labs Sdn Bhd, Malaysia
Business Intelligence Analyst
Dec 2017 - Mar 2018

Perform Data analysis & Data Mining using multiple RDBMS, Moreover, designing and implementing ETL Pipelines for Customer centric data driven projects.

  • SQL
  • Data Analysis
  • IBM Information Governance Catalog
  • Teradata
  • Hive
  • Leadership
  • Stakeholder Management
Jul 2016 - Dec 2017
The Optimum Solutions Sdn Bhd, Malaysia
ETL Developer
Jul 2016 - Dec 2017

Extensively used Teradata Database & GCFR Framework for ELT across the project for concluding the data mining results.Involved in data validation during UV - User Verification with Business Users.

  • SQL
  • Teradata
  • Scala
  • HDFS
  • Hive
  • Communication
  • Spark
  • Performance Tuning
Apr 2015 - Jul 2016
Techlink Infoware, India
Software Engineer
Apr 2015 - Jul 2016

Involved in building Enterprise Data warehouse for Media domain client based in Sydney, Australia. Involved in building Datastage Jobs, data model, testing phases.

  • IBM Datastage
  • SAP Business Objects Data Services
  • BMC Control-M
  • Linux
  • Logical Data Model
  • SQL
Jul 2013 - Apr 2015
Aventurine Technologies
Software Engineer
Jul 2013 - Apr 2015

Participate in preparing the application stages. Designing and developing Datastage Jobs. Application of Data warehousing concepts (Dimensions,SCD,Facts) in designing data model. Also, Providing System Test Support during System Test phase.

  • IBM Datastage
  • Production Support
  • Testing
  • Communication
  • Problem-Solving
  • SQL

Coded on a 🍕 diet

Coming Soon, Stay Tuned.

My adventures in focus 📷

@mihirdhakan93

Coming soon to a device near you!