Mehul J.

About Mehul J.

Experienced software consultant with proven experience in Python programming, JavaScript,…

Experience

1. Senior Software Engineer

   Consultadd Inc

   Nov 2022 — Present · New York, NY, US

   Deployed ML models into production using Flask, FastAPI, and AWS Lambda, exposing real-time API endpoints for seamless integration into enterprise billing and claim processing systems- Built Streamlit-based SPA frontend for database updates, securing data with AWS Secrets Manager, IAM roles, and Python-automated access controls- Designed Python and DBT data pipelines for efficient ETL processes into Amazon Redshift and other storage solutions- Implemented Amazon Redshift data warehouse for efficient storage, complex querying, and data management- Created S3 data lakes with lifecycle policies for cost optimization, partitioning, versioning, and archival- Developed Python-based ETL/ELT pipelines with DBT for schema management, transformations, and dimensional modeling in Redshift for analytics- Orchestrated data workflows using Apache Airflow with Python for scheduling, retries, logging, and monitoring; used SQLAlchemy for optimized database interactions with SQL window functions and CTEs- Enabled real-time data ingestion with Kafka for low-latency streaming into Redshift- Built Python-based monitoring tools with CloudWatch metrics, alerts, and Slack notifications for pipeline health- Automated backups and data integrity checks with Python; managed Dynamodb for Redshift sync operations- Optimized SQL queries and automated performance tuning with Python.**Tech Stack**: AWS Redshift, SageMaker, Lambda, Python, ETL/ELT, AWS Secrets Manager, IAM, CloudWatch, SNS, Kafka, Machine Learning, Streamlit, FastAPI.

Education

• Medicaps University

  Bachelor of Engineering - BE

  2015 — 2019