Sign in

Data Engineer

Chicago, IL
90,000 USD
March 03, 2019

Contact this candidate


**** * ********* **. ********* Kothari

Chicago IL, 60613 312-***-**** EDUCATION

Masters in Management Information Systems (3.68/4.00) Aug 2014 - May 2016 University of Illinois at Chicago

Bachelors in Electronics and Communication (3.75/4.00) Aug 2010 - May 2014 Rajiv Gandhi Technical University, Bhopal India


Data Operation Engineer VillageMD – Chicago, IL May2018 – Present

• Design and implement data processing solutions, enabling clean data flow directly to the data model using different technologies such as Python, Talend, Java, Postgres, SQL Server

• Engineered, supported and addressed the proprietary process of loading and validating highly specialized medical claims from 10s of payers into a proprietary system

• Built dashboards and alerts to support production operations and automate manual and time-based checks to increase operational efficiency and accuracy

• Built Python apps to send data anomalies to operations team Data Operation Engineer Uptake – Chicago, IL Feb 2017 – May 2018

• Validated the data stream, dependencies, and provenance in the big data pipelines and performed data quality check through Postgres, Docker, Elastic Search and Kafka to continuously improve the availability, timeliness and quality of data

• Developed python scripts and Grafana dashboards to automate the monitoring tasks and fire alerts if data anomalies are detected

• Partnered with Data Science, Engineering, Product, and Operations to manage complex requests and solve daily production issues and streamlining multiple data pipelines

• Involved with data pipeline validation process by identifying validation gaps, testing new iterations and changes, configuring and troubleshooting data pipeline and adapting the process with incremental feedback Data Implementation Analyst Uptake – Chicago, IL July 2016 – Feb 2017

• Led a team of 2 to on-board 40 dealerships across the world on Uptake's platform provided them with analytical services and streamlining the onboarding process

• Visited dealerships in several countries and created detailed field-by-field data mapping of customer ERP systems including identifying complex functions and queries to map the data to Uptake’s target schemas Grad IT Consultant Center for Literacy, Chicago, IL April 2015 – May 2016

• Used agile software development methodology in defining the problem, gathering requirements, development of sprints and established communication with the technical team for development of a reporting system

• Developed patron sign-in system on MS Access using VBA and wrote SQL queries to prepare quarterly and monthly reports Software Developer Intern Abhudaya Multimedia, India Sep 2012 – Jan 2013

• Created the project plan using MS Project while analyzing application needs and delivered the following artifacts as needed: (Project Charter, Business Requirements Document, Use Cases, cost analysis)

• Worked as Python programmer in a team dedicated to developing a membership management app for the city library TECHNICAL SKILLS

Programming Languages : C, C++, JAVA, Python

Statistical Analysis : R, SAS, TABLEAU, SPSS

Database Management : MongoDB, Elastic Search, SQL Server, Cassandra, Kafka, PostgreSQL, InfluxDB Data Reporting : SSRS, Crystal reports, Tableau

Contact this candidate