About
Actively looking for Data scientist or Data analyst roles
Contributions
Activity
-
From raw data to actionable insights, #dataengineering is key to unlocking the full potential of analytics. Explore why it’s a game-changer for…
From raw data to actionable insights, #dataengineering is key to unlocking the full potential of analytics. Explore why it’s a game-changer for…
Liked by Shikhar Nigam
-
Hello Everyone, Immediate openings for Azure Data Engineer/Data Bricks Developer with 4 to 6 years of experience for Bengaluru/Kochi location, if…
Hello Everyone, Immediate openings for Azure Data Engineer/Data Bricks Developer with 4 to 6 years of experience for Bengaluru/Kochi location, if…
Liked by Shikhar Nigam
-
Tired of the same old #BI routines with #MicroStrategy and #PowerBI? So are we... We at Nice Software Solutions Pvt. Ltd. are searching for someone…
Tired of the same old #BI routines with #MicroStrategy and #PowerBI? So are we... We at Nice Software Solutions Pvt. Ltd. are searching for someone…
Liked by Shikhar Nigam
Experience
Education
Licenses & Certifications
-
-
-
-
-
-
-
Infrastructure and Application Modernization with Google Cloud
Google Cloud Skills Boost
-
-
-
-
-
-
-
-
-
-
-
Projects
-
Amazon product review analysis
-
Performed EDA on Amazon customer data and reviews given by them, build Tableau dashboards to visualise top customers, customers who are likely to churn, top-rated products, least-rated products and the trends in the sales of the products.
Made a classification machine learning model using NLP feature extraction techniques like TF-IDF which segregated reviews into positive, negative or neutral reviews based on the sentiment of the review.
By using unsupervised machine learning…Performed EDA on Amazon customer data and reviews given by them, build Tableau dashboards to visualise top customers, customers who are likely to churn, top-rated products, least-rated products and the trends in the sales of the products.
Made a classification machine learning model using NLP feature extraction techniques like TF-IDF which segregated reviews into positive, negative or neutral reviews based on the sentiment of the review.
By using unsupervised machine learning clustering techniques like K-means and Hierarchical clustering, identified 3 groups of customers (highly satisfied- around 28% of customers, satisfied - 52% and dissatisfied - 20%) based on the reviews given by them to prevent the churn of dissatisfied customers.
Also identified 3 groups of products( best - 32% of products, good - around 41% and average - 27%) based on the reviews given to them to improve the satisfaction level of products with lower ratings by giving necessary inputs from feedback.
Predicted the future sales of Amazon products to properly maintain the inventory using time-series analysis. -
Danny's diner SQL project ( skills - SQL )
-
Analyze customer visiting patterns, how much money they’ve spent, and which menu items are their favorite. This will help deliver a better and more personalized experience for loyal customers, whether he should expand the existing customer loyalty program
-
HOUSE GRADE PREDICTION ( skills - python, machine learning)
-
Predicted Grade of houses using various supervised machine learning classification models(logistic Regression, Gaussian Naive Bayes, Decision Tree Classifier, and Random Forest Classifier using Bagging, Boosting, Stacking) with highest accuracy of 89%, to simplify house search for prospective buyers and help agents quickly narrow down the house according to customer needs.
-
MALL CUSTOMER SEGMENTATION ( skills - python, machine learning)
-
Applied unsupervised clustering algorithms (Kmeans,DBSCAN,Hierarchical) with highest silhouette score of 0.40 and clustered customers into four categories. Target customers having high income as well as high spending scores, Careful with high income and low spending scores, Careless having less income and high spending scores and Sensible with less income and low spending scores.
-
MOTION PICTURE DATA ANALYSIS ( skills - SQL )
-
Using MySQL estimated the overall profit gained by each movie along with popular actors so that store can stock their inventory to increase profits.
-
SHOPPING CART PROGRAM ( skills - python )
-
Created a shopping cart program in Python which accepts items from user and display the total bill of shopping along with an updated inventory of the shop.
-
STORE SALES PREDICTION ( skills - python, machine learning)
-
Used various Supervised Machine Learning Regression Models (Linear Regression, Ridge CV, Decision Tree Regressor, and Random Forest using Bagging, Boosting, and Stacking) with highest r2 scire of 0.55 to predict the sales of the store to boost the sales and expand the business.
Honors & Awards
-
State Level Cricket Player
-
More activity by Shikhar
-
🚀 Unlock Your Next Career Move with Bacancy! 🚀 Hello, LinkedIn Network! Are you ready to take your career to the next level? Bacancy is on the…
🚀 Unlock Your Next Career Move with Bacancy! 🚀 Hello, LinkedIn Network! Are you ready to take your career to the next level? Bacancy is on the…
Liked by Shikhar Nigam
-
Merck Sharp & Dohme LLC (MSD) is hiring for a fresher entry level Data Analyst / Data Scientist! Experience: 0-3 years Position: Analyst Company:…
Merck Sharp & Dohme LLC (MSD) is hiring for a fresher entry level Data Analyst / Data Scientist! Experience: 0-3 years Position: Analyst Company:…
Liked by Shikhar Nigam
-
Exciting opportunities at NewVision Software! We're expanding our data and AI team with key roles: Generative AI Lead/Architect: Shape our AI…
Exciting opportunities at NewVision Software! We're expanding our data and AI team with key roles: Generative AI Lead/Architect: Shape our AI…
Liked by Shikhar Nigam
-
🌟 At Jivi, we believe in the perfect blend of productivity and fun! That's why we never miss out on celebrating our weekly TGIFs with enthusiasm and…
🌟 At Jivi, we believe in the perfect blend of productivity and fun! That's why we never miss out on celebrating our weekly TGIFs with enthusiasm and…
Liked by Shikhar Nigam
-
"🎉 𝗖𝗲𝗹𝗲𝗯𝗿𝗮𝘁𝗶𝗻𝗴 𝗢𝗻𝗲 𝗬𝗲𝗮𝗿 𝗮𝘁 AQe Digital (Formerly AQe Group)! 🎉 Time really flies when you’re part of an awesome team! This…
"🎉 𝗖𝗲𝗹𝗲𝗯𝗿𝗮𝘁𝗶𝗻𝗴 𝗢𝗻𝗲 𝗬𝗲𝗮𝗿 𝗮𝘁 AQe Digital (Formerly AQe Group)! 🎉 Time really flies when you’re part of an awesome team! This…
Liked by Shikhar Nigam
-
🐍🎧 The Real Python Podcast — Exploring the New Features of Python 3.12
🐍🎧 The Real Python Podcast — Exploring the New Features of Python 3.12
Liked by Shikhar Nigam
-
Day 24 of SQL Challenge: Card Launch Success [#JPMorganChase SQL Interview Question] Problem Statement: Your team at JPMorgan Chase is soon…
Day 24 of SQL Challenge: Card Launch Success [#JPMorganChase SQL Interview Question] Problem Statement: Your team at JPMorgan Chase is soon…
Liked by Shikhar Nigam
-
Best practices for writing SQL queries: 1- Filter Early, Aggregate Late: Apply filtering conditions in the WHERE clause early in the query, and…
Best practices for writing SQL queries: 1- Filter Early, Aggregate Late: Apply filtering conditions in the WHERE clause early in the query, and…
Liked by Shikhar Nigam
-
Databricks' AI/BI Dashboards enable dashboard sharing across your organization, even for users without access to a Workspace. Now available to all…
Databricks' AI/BI Dashboards enable dashboard sharing across your organization, even for users without access to a Workspace. Now available to all…
Liked by Shikhar Nigam
-
So this is a very common SQL interview question and it was recently asked in a Zepto interview. The first thing that comes to mind is using…
So this is a very common SQL interview question and it was recently asked in a Zepto interview. The first thing that comes to mind is using…
Liked by Shikhar Nigam
-
#Hiring #DataEngineers #PysparkDeveloper #Python #AWS #Hadoop #Hive #Scala We are looking for experienced Data Engineers for…
#Hiring #DataEngineers #PysparkDeveloper #Python #AWS #Hadoop #Hive #Scala We are looking for experienced Data Engineers for…
Liked by Shikhar Nigam
-
Hey folks !!!! We have an urgent opening for the role- AI Engineer Exp- 2-6 years Loc - Hyderabad Requirements: ● Proficient with Computer…
Hey folks !!!! We have an urgent opening for the role- AI Engineer Exp- 2-6 years Loc - Hyderabad Requirements: ● Proficient with Computer…
Liked by Shikhar Nigam
-
Now GA: Looping for Tasks in #DatabricksWorkflows with “For Each”! It’s now easier than ever to automate repetitive tasks by looping over a dynamic…
Now GA: Looping for Tasks in #DatabricksWorkflows with “For Each”! It’s now easier than ever to automate repetitive tasks by looping over a dynamic…
Liked by Shikhar Nigam
-
🚀 Exciting Career Opportunities Await! 🚀 Motadata is expanding and looking for talented individuals to join our dynamic team. If you're passionate…
🚀 Exciting Career Opportunities Await! 🚀 Motadata is expanding and looking for talented individuals to join our dynamic team. If you're passionate…
Liked by Shikhar Nigam
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore MoreOthers named Shikhar Nigam in India
-
Shikhar Nigam
-
Shikhar Nigam
-
Shikhar Nigam
In-house Counsel
-
Shikhar Nigam
Intraday/Scalping || Amazon || Automation || Analytics || Athlete
-
Shikhar Nigam
Operations Manager/ PSM/Vendor Manager at AT&T
36 others named Shikhar Nigam in India are on LinkedIn
See others named Shikhar Nigam