Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic
Ishwarchandra Deshmukh

Ishwarchandra Deshmukh

Pune

Summary

Consulting professional with proven track record in delivering impactful business solutions. Known for analytical mindset and results-driven approach, fostering team collaboration to meet project goals. Highly adaptable with strong problem-solving and communication skills, ensuring seamless project execution.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Sr. Data Engineer I

Codvo.AI
Remote
02.2025 - Current
  • Responsible for 2 crucial Data marts, namely Hubspot Mart to push 3 entity data to Hubspot CRM and Reporting Mart for daily reporting, by taking highly normalised data as a source and doing myriad of data transformations to create entity-level flat tables using DBT and Prefect.
  • Create tenant specific data-mart pipelines in a multi-tenant environment with cross-tenant data access using entity-level data sharing contracts.
  • Performance optimization on Postgresql using Partition Pruning, Indexing, Variable(as needed) working memory allocation, Predicate pushdown and efficient SQL writing using EXPLAIN.
  • Development of 4 other pipelines, namely Health and Engagement scoring for various channel entities(Phone, Email and Address), Channel selection for company and person entity and Attribute selection for 16 different entities using DBT macros.

Digital Solution Consultant Sr. Analyst

NTT DATA
08.2024 - 02.2025
  • Humana Inc.: HR Data warehouse migration
  • Designed and implemented end-to-end ETL/ELT pipeline in Databricks in the medallion architecture for 32 Service Now APIs and 8 Workday files with a scalable architecture to add more APIs, File, and other data sources.
  • 6 Layers in the pipeline: Ingestion, Cleaning, Casting, SCD II, Transformation, and SCD I (Consumption Ready).
  • Implemented an automated testing framework with more than 15 test cases, such as Primary Key, not NULL, Referential Integrity, SCD 2 integrity, and pattern matching using Regular Expression.
  • Reverse-engineered internal logic of 28 stored procs and 4 SSIS packages from the legacy system and developed the same logic in Azure Databricks.
  • Enforced data obfuscation on more than 30 columns using masking and tokenization for PII and PHI data for HIPAA compliance.

Digital Solution Consultant Sr. Analyst

NTT Data/Hashmap Inc
08.2021 - 07.2024
  • Data Migration team, Teradata to Snowflake Migration, Blue Cross Blue Shield North Carolina
  • Designed, Developed, Maintained & Documented Python Framework with more than 50 Python Applications aiding data migration activities with high Fault tolerance, Modularity, integrability, Scalability & Ease of Use.
  • Notable programs include Table and View DDL Migrator and Validator by integrating SnowConvert CLI, Table and View Data Validator using HashMD5, Teradata Object Change Detection, and Wrapper modules for in-house Data Migration tool 'Hashmap Data Migrator'.
  • Developed Metadata-driven Data observability, monitoring and validation framework using control tables and Python.
  • Developed Orchestration tool using Python to automate end-to-end Data Migration.
  • Helped design 'Centralised Inventory Trackers (CITs)' for managing data migration activity inventory of 47k+ migration objects.
  • Used Power Platform tools to create Dashboards and Pivot Tables from CITs data.
  • Set up manual intervention protocols for all automation process failures.

Education

Data Science Program -

Edyoda Digital University
05.2021

Bachelor's in Engineering -

Sinhgad College of Engineering
Pune
07.2019

Master of Science - Machine Learning specialization

Georgia Tech
Remote (Part Time)

Skills

  • Snowflake
  • Azure Databricks
  • Postgresql
  • PySpark
  • Spark SQL
  • DBT
  • Python
  • Matillion
  • Bash/Unix
  • Azure SQL
  • Power BI
  • Git
  • Prefect

Websites

Certification

  • Snowflake SnowPro Core Certification, 12/01/21, 12/31/23
  • Certificate of Excellence by Edyoda in Data Analysis(Numpy, Pandas, Scikit-learn), DSA, and Python., 05/01/20, 02/28/21
  • Hash-O-thon: Certificate of Outstanding Performance, 10/01/21

Projects

Data Engineering Project, Snowflake, DBT, MySQL, Airbyte, Airflow, Docker, Git, Data Modelling, End-to-End data engineering project with data ingestion from MySQL using Airbyte to Snowflake, modelling Star-flake data model in medallion architecture. DBT for data transformations and testing. Implemented CDC and SCD-II. Airflow for data orchestration, Git for version control. Power BI for Dashboarding.

Timeline

Sr. Data Engineer I

Codvo.AI
02.2025 - Current

Digital Solution Consultant Sr. Analyst

NTT DATA
08.2024 - 02.2025

Digital Solution Consultant Sr. Analyst

NTT Data/Hashmap Inc
08.2021 - 07.2024

Data Science Program -

Edyoda Digital University

Bachelor's in Engineering -

Sinhgad College of Engineering

Master of Science - Machine Learning specialization

Georgia Tech

Similar Profiles

CREATE PROFILE
Ishwarchandra Deshmukh