About Me

I am a diligent researcher with a passion in data science and ambition in business. A B.S. in Biomedical Engineering from UAB and industrial from research experience has geared me towards a data science career. I recently graduated with a M.S. in Data Science. On an average day, you will probably find me doing one, if not multiple, of the following: meeting clients for projects at work, 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.

Name: Ankur Patel

Phone: 251-447-6255

Email: p.ankur.715@gmail.com

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 - 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 - 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 - 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 - 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 - 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

My Skills

Python

90%

SQL

90%

R

80%

Tableau

90%

Excel

90%

PySpark

70%