Howdy! I am

Karan Gupta

I'm

About Me

I am a passionate data enthusiast with a penchant to leverage the power of engineering and analytics to solve real-world business problems, and bolster decisions with a backing of logic and science.

Having a deep appreciation and interest in music, I also play the guitar and if not working on trending datasets to derive insights and contribute to the community in some way, that's what you'll find me doing in my leisure time!

  • Name: Karan Gupta
  • Date of birth: November 21, 1994
  • Address: Austin, TX
  • Zip code: 94303
  • Email: karan_mays@tamu.edu
  • Phone: +1-979-985-7541

Education

2019 - 2021

Master of Science in Management Information Systems

Texas A&M University

Relevant Coursework: Business Database Systems, Advanced Data Management, Data Warehousing, Engineering Data Analysis, Computational tools for Big Data, Statistical Foundations in Data Science, Data Mining and Analysis, Advanced System Analysis and Design, Business Information Security

CGPA: 4.0/4.0

View Unofficial Transcript

2012 - 2016

Bachelor of Technology in Electronics and Telecommunication

College of Engineering Pune

Relevant Coursework: Digital System Design, Data Structures & Algorithms, Micro-controllers & Applications, Information Systems, Programming Concepts and Tools, Computer Network

Experience

2020 - Present

Graduate Assistant - Associate Web Developer

Division of Research, Texas A&M University

As a Graduate Assistant in the Division of Research, I developed myriad data-driven dashboards using HTML5, CSS3, Javascript (d3)

I also managed content on > 10 internal websites of the University's Research Division

2016 - 2019

Data Analyst

HDFC Bank Ltd.

At HDFC Bank, I have worked extensively on the bank's Digital Loan Platform, being an active member of the team responsible for the go-live and maintenance of the product.

I have worked on the crude customer data of the bank, successfully interpreting metrics for deriving transactional summary from the loan data and have developed comprehensive reports using Advanced SQL, JavaScript, HTML5 and CSS3 for managerial action and strategy.

For the bank's primary website, I have extensively worked on analysis of the IIS access logs to compute operational KPI's which helped in faster identification and tracking of issues and led to a reduction of 80% in the technical case declines on the website.

I have performed data wrangling and transformation by developing many ETL workflows for customer data coming from varied financial data sources.

May 2015 - July 2015

Summer Analyst

Tata Consultancy Services

As an intern at TCS, I had contributed in developing data aggregation procedures for fusing sensor data for an autonomous car project

To increase efficiency of the database, I had initiated fine-tuning mechanisms for the database jobs & queries to complete tasks in optimal time

Skills

Programming

  • Python
  • R
  • SQL
  • NoSQL
  • HiveQL
  • HTML5
  • CSS3
  • JavaScript

Database and Frameworks

  • SQL Server
  • MySQL
  • Oracle 11g
  • MongoDB
  • Cassandra
  • Neo4J
  • MariaDB
  • Apache Hive
  • Apache Spark
  • Apache Kafka
  • Hadoop

Tools and IDE

  • Microsoft SSIS
  • Microsoft SSRS
  • Tableau 10.5
  • Power BI
  • Advanced Excel
  • Apache Pig
  • AWS
  • JIRA
  • Github
  • Eclipse

My Projects

Quantifying sentimentality of tracks by my favorite artists

Sentiment Analysis, ETL, Web Scraping, Python Dashboard

Predicting Rate of spread of COVID-19

Regression, Regularization, Trees, Ensemble Methods, Model Selection

Data Warehouse for Dominick's Fine Foods

Data Warehousing, Data Quality Maintenanace, ETL, Database design and Dimensional modeling, STAR Schema

Real time COVID-19 Dashboard

Data Visualization

Anomaly Detection in Machine Operation

Time Series Analysis and Anomaly detection

KPMG Data Analytics - Virtual Internship

Data Analysis & Visualization

Collaborative Filtering & Content-Based Movie Recommendation System

Recommender System

House Price Prediction

Feature Engineering, EDA, Regression

Equipment Failure Prediction

Feature Scaling, Classification Techniques

Flight Guru - Flight Recommendation Web App

Relational and Non-Relational Databases, Polyglot Persistence

I'm open to opportunities in Business Intelligence, Data Engineering, Data Analysis & Data Science

Reach out

Contact Me

Contact Number

+1 979 985-7541