Open to opportunities

Jay Gohel

@jaygohel

Message

Lead Consultant specializing in data engineering and automation solutions.

India

Message

What I'm looking for

I am looking for a role that challenges my data engineering skills and offers opportunities for growth in cloud technologies.

As a Lead Consultant at Genpact, I have successfully devised Python scripts that transformed data extraction processes, significantly reducing manual entry time by 80% and minimizing errors. My expertise in developing and optimizing complex SQL queries has led to a 40% reduction in processing time, showcasing my ability to align technical solutions with business requirements.

Previously, as a Senior Data Engineer at SpringML, I spearheaded the implementation of a Jupyter Notebook automation framework on GCP, which reduced manual work by 75% and accelerated execution times by 90%. My experience in architecting end-to-end ETL pipelines using Python, Spark, and GCP services has equipped me with the skills to handle scalable data processing challenges effectively.

With a strong foundation in data warehousing and ETL processes, I have consistently delivered high-quality outputs throughout my career. My role as a Senior Product Consultant at Fintellix Solutions involved managing the complete development and deployment of critical applications, demonstrating my ability to lead projects from inception to completion while optimizing performance and efficiency.

Experience

Work history, roles, and key accomplishments

Current

Lead Consultant

Current

Genpact

Apr 2023 - Present (2 years 3 months)

Devised Python scripts to extract and transform data from 50+ Excel files into database tables, cutting manual data entry time by 80% and eliminating errors. Developed and optimized complex SQL queries to extract and transform data, aligning with BRD specifications, reduced processing time by 40%.

Python SQL Pyspark ETL Database Management Troubleshooting Data Analysis

Senior Data Engineer

SpringML

Jan 2022 - Apr 2023 (1 year 3 months)

Spearheaded implementation of Jupyter Notebook automation framework on GCP, reducing manual work by 75% and accelerating execution times by 90%. Transformed labor-intensive data extraction by automating Excel-to-BigQuery process using Python and SQL, ensuring accuracy and efficiency.

Jupyter Notebooks GCP Python SQL ETL BigQuery Spark Terraform Data Engineering

Senior Product Consultant

Fintellix Solutions

Jul 2017 - Sep 2021 (4 years 2 months)

Spearheaded the complete development and production deployment of an NPA application for a respected small finance bank in India within 90 days. Designed and executed intricate database components, including procedures, and views, aligned with project requirements.

Pyspark ETL Pl SQL Data Warehousing SDLC Troubleshooting Apache Spark Python

Education

Degrees, certifications, and relevant coursework

John Moores University

MSc, Data Science

2019 - 2022

Completed a Master of Science in Data Science, focusing on advanced data analysis and machine learning techniques. Gained expertise in various data science methodologies and tools.

RGIT, Mumbai University

B.E, Electronics & Telecomm

2013 - 2017

Obtained a Bachelor of Engineering in Electronics & Telecommunications, building a strong foundation in engineering principles. Developed skills in telecommunications and electronic systems.