×
0 followers0 following
Kartik Anand
Delhi, India0 followers0 following
- About
- Bachelor's
- Target
- TOEFL
- GRE
Male
Delhi, India
Work ExperienceData Engineer Intern
Invygo - Internship
Jan 10, 2022 - Jul 6, 2022 · 6 mos
Dubai, United Arab Emirates
● Responsible for development and maintenance of web scraping scripts for competitor analysis using python.
● Building dashboards for various products on metabase (BI Tool) using MySQL . Analysed data and identified patters,
anomalies and risks for different products to give useful insights to acquisition and retention squads.
● Maintenance of Databases on MySQL, normalizing tables and fine tuning SQL queries for better performance.
● Created stored procedures for big queries which involved multiple joins and did indexing in MySQL for improving query
performance.
● Responsible for Datawarehouse and Database management and maintenance.
● Responsible for developing and maintaining Data migration tasks using AWS DMS from MongoDB to AWS Redshift and
connect it to Metabase (BI Tool). AWS Services used(EC2 , IAM Roles, VPC, DMS , Redshift, Aurora)
● Created various funnels using mix panel for app tracking and analysing drop off rates and reasons.
● Created Excel pivot tables for customer segmentation using demographics data.
Front End Engineer Intern
DesignKraft Solutions - Internship
Jun 5, 2020 - Aug 6, 2020 · 2 mos
Delhi, India
● Responsible for designing and updating layouts to meet usability and performance requirements.
● Worked in an agile driven environment to effectively maintain project timelines.
● Conceived and built optimized landing pages in HTML and CSS for integration and cross browser compatibility.
● Responsible for choosing best design practices with the product team.
ProjectsGender Prediction Using NLP and LSTM
Role - Machine Learning
for Industrial
May 10, 2022 - May 21, 2022
● Used Google clouds Big Query Dataset called USA_NAMES containing names for all social security card applications for births.
● Used data pre-processing techniques to lowercase, split, pad and encode to convert the names into numeric representation.
● Applied Simple bidirectional LSTM model using TensorFlow keras API.
YouTube Data Analysis using AWS
Role - Data Ingestion and transformation
for Academic
Sep 15, 2021 - Nov 1, 2021
This works aims to understand how to categorize videos, based on their comments and statistics and what factors
affect how popular a YouTube video will be.
Used the CAvideos dataset available on Kaggle for the project work.
Used AWS S3 Bucket to store data in AWS cloud using AWS CLI. And used AWS Glue Data CatLog to create a central
repository for the data and used AWS lambda for ETL job (json to table format) and cleaning data.
Explored the data using Amazon Athena using queries.
Used Quicksight to build dashboards for the data
Research PapersHow do hand gestures in video impact social media engagement- Insights based on deep learning
Nov 11, 2021 - International Journal of Information Management Data Insights - Elsevier
This research work aims at recognizing hand gestures performed in TEDx videos and analyse the relationship between
gestures and user engagement.
Two experimental studies were carried out to analyse viewer engagement: one, the effect of suitable gestures on the
viewer count, and secondly, suitable gestures on the sentiment of the viewer.
Here we propose a technique based on deep learning, Convolutional Neural Network (CNN) and ResNeXt-101 to
recognize hand gestures from a video or image input and to classify the same into various categories.
Interesting results are observed that suitable gestures from talkers have an impact on increasing positive review and
viewer count.
DOCX
12.Research_Paper.Updated_wecompress.com.docx
VolunteeringKartik Anand has not added any volunteering detail yet.