Hello! I'm

Ankur Patel

I'm a

Data Engineer

Checkout my

Resume & Fun Activities

About

Hey there, I'm Ankur Patel

I am a diligent researcher with a passion in data science, motivation in healthcare, and ambition in business. A B.S. in Biomedical Engineering from UAB and industrial research experience has geared me towards a data science career. On an average day, you will probably find me doing one, if not multiple, of the following: meeting clients for consulting projects, attending meetups, or participating in hackathons. Other than that, I enjoy exploring new cities, tasting new flavors and dishes from different cuisines, and watching an assortment of movies. I believe the best way to grow is to open the mind to learn and understand every part of the seen and unseen world. The key is to stay curious.

Checkout my resume

Activities besides tech

Contact me here!

Email: p.ankur.715@gmail.com

Phone: 917-721-1355

Experience

Data Engineer - Sky I.T. Group

  • Designed and maintained automated ETL pipelines for multi-source retail POS, sales, inventory, and product data using Python, SQL, QlikView, IBI Data Migrator and BigQuery.
  • Developed Python parsers to normalize raw client data into standardized schemas for downstream analytics.
  • Implemented automated data validation, reconciliation, and monitoring that improved production data quality.
  • Investigated production pipeline failures through root cause analysis and implemented preventative validation checks.
  • Developed backend Python services that supplied an LLM-powered analytics chatbot with trusted sales and inventory data, enabling natural language queries across brands, retailers, and products.
  • Partnered with business analysts and leadership to define warehouse architecture and analytics delivery strategy.

Jan 2024 - Jul 2026

Data Analytics Engineer - Greater New York Insurance Companies

  • Designed and optimized end-to-end ETL pipelines for insurance claims, policy, underwriting, violations, customer, and geographic data, delivering trusted datasets for BI reporting, predictive analytics, and executive decision-making using Python, SQL, Snowflake, Tableau, and SQL Server.
  • Improved data quality, consistency, and performance through validation, documentation, monitoring, and optimization of production data workflows.
  • Partnered with business stakeholders to develop analytics products and data solutions supporting underwriting, claims analysis, pricing, and executive reporting.
  • Collaborated with data scientists by preparing feature-engineered datasets and supporting predictive models using DataRobot, SparkBeyond, and internal machine learning workflows.

Aug 2020 - Oct 2023

Data Engineer - Executive Business Solutions Corp, NYC

  • Developed cloud-based ETL pipelines that integrated real estate, U.S. Census, and public health datasets from external APIs into AWS-hosted SQL databases for analytics and reporting.
  • Built SQL Server data warehouse solutions for retail clients, performing customer segmentation, purchasing analytics, and supply chain KPI reporting.
  • Automated legacy VBA- and SQL Server-based financial reporting processes by converting them into scalable Python workflows deployed on AWS EC2.
  • Built predictive analytics solutions using time-series forecasting for financial and business datasets.
  • Delivered technical training in Python, SQL, Tableau, R, Excel, data analytics, and introductory machine learning.

Oct 2018 - Mar 2020

Independent Study – Business Assessment Scores Using Yelp Reviews - Verisk Analytics, NJ

  • Developed an assessment score using business and reviews json files from Yelp challenge dataset.
  • Created LDA model for topic modeling and stars after inspecting topics using pyLDAvis, and a domain specific lexicon for scores that were normalized across NAICS Codes and social networking sites.
  • Deployed model for user interaction using Flask API.

Sept 2019 - Feb 2020

Forecasting & Business Analysis Intern - Novo Nordisk, NJ

  • In a Financial Planning & Analysis team, processed and analyzed big data of pharmaceutical products’ volume with forecasting software and model, and visualize in Tableau.
  • Developed ETL program in Python to map and integrate databases and execute with a model.
  • Developed a Tableau dashboard to demonstrate Anchor Budget and Rolling Estimate forecasts.

Jun 2019 - Aug 2019

Data Analyst - InSpirAVE, NYC

  • Analyzed e-commerce data of products and prices of selected merchant partners, compared with competitors, and collaborated with other e-commerce businesses.

Jan 2019 - Feb 2019

Researcher II - UAB Medicine, AL

  • Assisted in scientific research in diabetes to identify roles of bodyweight, genotypes, glucose/insulin/pyruvate tolerances, and proteins in insulin secretion.
  • Analyzed the data using Excel, VBA, and Python, and analyzed big genomic data using R.

May 2017 - Aug 2018

Research Assistant - Dynamic Biosciences LLC, AL

  • Performed analytical testing procedures for breweries and reported results to customers.
  • Managed the company’s sales of laboratory equipment.
  • Assisted in column chromatography and performed a mass spectrometry assay to measure purity.
  • Created graphs of the data in Graphical Analysis software.

Aug 2016 - Dec 2016, Jan 2015 - May 2015

Training

ELCHackathon 2019 - ELC Recycle Rewards Kiosk

Group won first place for developing an Amazon Echo app to interact with customers to offer rewards and an option to donate for recycling ELC products, by using an infrared sensor and LED display to identify the item. The software used were Vision API, Cloud SQL, and Python.

Sep 2019

Redline Hackathon 2019 - Seeker

Group won 2nd place for developing a SaaS app called Seeker that uses Google Cloud Video Intelligence API for object detection and time intervals, and Yuuvis for storage and Search Service API to jump to time of searched object.

Apr 2019

HackFest 2019 - SaferWay

The first routing app that provides the safest routes by using ArcGIS API and city wide traffic statistics. The app works by predicting the probability of vehicle crashes at a certain location given several inputs like precipitation chance and amount, temperature, time of day, past crashes, and sinuosity of the road.

Apr 2019

Global Legal Hackathon 2019 - Violence Reporter

Competing against 6000 participants from 24 countries, team created an audio and image classification app to notify users of real-time and location-based crimes for evacuation and for lawyers’ use during claim cases.

Feb 2019

NYC Grand Hack 2018 - MobileAI

MobileAI phone app of image or video classification to assist visually impaired users in independent mobility through real-time navigation by capturing location from the pre-trained model.

Nov 2018

Education

Bachelor of Science in Biomedical Engineering - University of Alabama at Birmingham

Birmingham, Alabama

Aug 2012 - May 2015

Master of Science in Data Science - Saint Peter's University

Jersey City, New Jersey

Sep 2018 - Feb 2020

Portfolio

Checkout a few of my projects

Mar 2020

Finance Analytics

Analyzed time-series data of stocks for stock returns, volatility calculations, OLS, back testing, predictive, along with quantopian research.

Python

View Project

Apr 2019

AWS Redshift Cluster Analysis

Extracted data from ZAGI database in PostgreSQL server, load into AWS S3, then Redshift using Python

Program: PostgreSQL, Python, S3, Redshift

View Project

Oct 2019

Heart Disease Risk Factors

Employed machine learning, ensemble, and statistical analysis for feature selection and tuned models for predicting heart disease with 93% accuracy

Program: R

View Project

May 2019

Twitter Sentiment Analysis

Analyzed tweets of 2020 Democratic Presidential Candidates from Apr 4-11 uniformly by state, and tweets from the candidates' personal Twitter accounts from Nov 1 - Mar 31

Program: R

View Project

Feb 2019

Neural Networks

Multilayer perceptron (feed forward neural network) with hidden layers on iris dataset; CNN for image classification in MNIST, SVHN, and pet dataset

Program: Python

View Project

The Truth

A day in the life of a data scientist

Hours awake 0
Hours asleep 0
Cups of coffee 0