Summary
Overview
Work History
Education
Skills
Certification
Languages
Hobbies
Accomplishments
Educational Projects
Timeline
Generic

Nihal Choudhary

Bangalore

Summary

Experienced Data Analyst with advanced SQL skills, including extensive use of window functions and aggregations for complex data analysis—everyday, any day. Proficient in AWS services, database migration, and ETL pipeline creation.

Worked on Product analytics for funnel visualization, On boarded tools to increase retention leveraging push notification and opt-ins for re engagement or cart abandonment

Skilled in data visualization, utilizing tools like Tableau and Power BI to deliver actionable insights. Strong background in SQL and Snowflake for efficient data querying and storage. Adept at handling complex data sets, automating workflows, and enhancing data-driven decision-making processes.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst

Bobble AI
Gurugram
04.2023 - 08.2024
  • Performed UAT during database migration from AWS to GCP for customer, content DB.
  • Incorporated the customer data scraped for enrichment into cohort analysis for better accuracy in a complex query.
  • Built a sales tracker for advertising clients on the platform and segmented them based on frequency and recency.
  • Built a scraper for the AWS scripts of SageMaker and Glue to automate the tags and events captured, in order to decrease the turnaround time with the Insights team, with UAT and tests for every production release within the Bobble App.

Business Analyst

CommerceIQ
Bengaluru
12.2021 - 04.2023
  • Finding opportunities for clients for e-commerce business of Fortune 100 companies over Amazon Seller Central and other services within Amazon like shortages, chargebacks, and advertising.
  • Projecting growth of the client using time series techniques, growth rate being dependent on other opportunities and the value.
  • Performing audits for clients by helping them find opportunities in advertising practices to increase revenue.
  • Analysis of user behavior on the product to understand how the user is using the product and understanding user journey using Plotly and Seaborn, etc.
  • Managing the Business Analytics and Data requirements for the shortages pod including initiatives like managing MIS, Pre-sales and Revenue Recovery .[received Stakeholder and ownership quarterly award (Q2-2022)]

Data Analytics Associate

MSMEx
Mumbai
07.2021 - 12.2021
  • Working on a complete machine learning project to see the necessary dashboards for cohorts using Python Streamlit to deploy on AWS server [received employee of the month award August 2021]
  • Implementing Moengage for Web-Push and bringing necessary insights from the user data and understanding the behavior for better engagement.
  • RFM Modeling for customer segmentation using clustering techniques like K-means clustering to segment data for Marketing analytics over Recency, Frequency, and Monetary scores.
  • Built scrapper for scraping user data for business needs and the business(clients) details for better financing operations using beautiful soup and selenium.

Senior Executive - Data Analytics

The Indus Valley
Chennai
06.2020 - 07.2021
  • Handle MIS for cross-department analysis and use analytics for better understanding by building dashboards over Excel and Google Data Studio.
  • CLTV Modeling to identify and build Persona for potential customers using clustering and classification models.
  • Using Google Analytics and Hotjar, by analyzing potential pitfalls over UX engineering to bring more user interactions over the website (E-commerce) in return convert the given potential view/session to conversion using a data driven model.
  • Cohorts for retention rates, return rate, to bring in more value towards CAC costs, to get optimal value from a customer.
  • New Products vs Existing Products Analytics to understand cannibalism and protect sales, conserve the Ad cost value over a longer period.

Engineering Analyst

Goldman Sachs
Bengaluru
01.2019 - 02.2020

Engineering Analyst with one of the biggest companies in the financial banking domain. Working with several teams to actually proceed with engineering and multimedia requirements of the clients and employees i.e securing relevant ports on bridges according to the type of conference and mitigating the risk of overload and scarcity Apart from this managed several RCA and Disaster management reports for EMEA (Q2- 2019) region for a quarter and APAC (Q3-2019) for another quarter . Used empirical techniques to even out the workload among the onsite and remote technicians working with the hardware requirements like codec, laptops, projector, etc., based on time and location and the tech stack available.

Education

PGP - Data Science and Big Data Analytics -

International Institute of Engineering
Bengaluru
07.2020

B.Tech in Computer Science and Engineering -

SRM Institute of Science and Technology
Chennai
05.2018

CBSE-GED (XII) -

Chettinad Vidyashram
Chennai
03.2014

Skills

  • Data structures and Algorithms
  • amazon Web Services - Sagemaker, Kinesis, Athena, AWSGLue
  • Python (Flask, GUI, PyQt5)
  • Advance SQL - Window Functions, Performance Tuning, Aggregations, Advance Joins
  • Power BI, Tableau, Looker, VBA etc
  • CVA, Pre Sales Analytics,
  • Regression Analysis
  • Association Analysis
  • Cluster Analysis
  • Machine learning

Certification

Imperial College of London – Linear Algebra (98.2%) (Coursera)

Imperial College of London – Multivariate Calculus (93.5%) (Coursera)

Learning Path - Become a data scientist (January 2020) (LinkedIn Learning)

Languages

English
First Language
Hindi
Proficient (C2)
C2
Tamil
Proficient (C2)
C2
Bengali
Advanced (C1)
C1

Hobbies

Rescue Sea Animals - Turtles and Coconut crabs (SSTCN)

Crossfit and Weight Training

Travel Painting and Journaling

Accomplishments

1. Received Stakeholder and ownership quarterly award (Q2-2022) - CommerceIQ

2. Received employee of the month award August 2021 - MSMEx

Educational Projects

Effortless VR Game (FPS) — Unity 3d, CSS

This project comprises of a simple emulator (Unity 3d) an FPS game where the player had to move around to shoot at the target by just rotating their head in that direction. To align the dynamic pointer in the general direction of the prefab object build over Unity itself.

Image Retrieval Using Distance Matching Algorithm for Big Data— Big Data, Java, MATLAB

Distance matching algorithm /Euclidian distance is used to determine the relation of every image with each other. Distance matrix [package: Matplotlib on matlab] of an image gave set of characteristics values of image related to the predefined set of values used for classification. Recall time, and precision time values are found to be lesser than that of the traditional and previously used methods.

House price prediction using advanced regression techniques

Link: https://github.com/NihalChoudharycoder/Bengaluru-House-Price-Prediction 

Using random forest regression to train a regression model using kaggle dataset for Bengaluru house price prediction with end to end pipeline implementation including feature engineering, feature selection, data preprocessing and developed three regression models to evaluate the regression based on hyper parameters for each iteration with a Flask application

Mask detection for COVID-19

Link: https://github.com/NihalChoudharycoder/mask_detection

Using transfer learning techniques to train pre-trained Imagenet50 and LBPH algo models to detect mask by concentrating ROI over the face which is detected by using Haar-cascade filter to display a bounding box over real time live video feed alongside the accuracy by using augmented image dataset.

Timeline

Data Analyst

Bobble AI
04.2023 - 08.2024

Business Analyst

CommerceIQ
12.2021 - 04.2023

Data Analytics Associate

MSMEx
07.2021 - 12.2021

Senior Executive - Data Analytics

The Indus Valley
06.2020 - 07.2021

Engineering Analyst

Goldman Sachs
01.2019 - 02.2020

PGP - Data Science and Big Data Analytics -

International Institute of Engineering

B.Tech in Computer Science and Engineering -

SRM Institute of Science and Technology

CBSE-GED (XII) -

Chettinad Vidyashram
Nihal Choudhary