aman bajaj

aman bajaj

Mentor
Rising Codementor
US$5.00
For every 15 mins
ABOUT ME
Data Scientist with 6 years of experience in Analytics industry
Data Scientist with 6 years of experience in Analytics industry

Data Scientist with 6 years of experience working in the analytics industry.
Hands-on experience in SQL, Advance Excel, Python, R, Power BI, Tableau, Hive, Big Query, and Data studio. Good exposure to Market Research, SEO, e-commerce, Hospitality, and Ed-tech industries.

Pacific Time (US & Canada) (-07:00)
Joined May 2021
EXPERTISE
6 years experience
I have 6 years of experience in writing SQL queries and fetching data to analyze business performance.
I have 6 years of experience in writing SQL queries and fetching data to analyze business performance.
5 years experience
I have about 5 years of experience in developing supervised and unsupervised machine learning models in R/Python. Hands-on experience in ...
I have about 5 years of experience in developing supervised and unsupervised machine learning models in R/Python. Hands-on experience in working with clustering techniques(KNN, Kmeans), Regression Models(Linear, Multilinear, Logistic), Classification models( Decision Tree, Naive Bayes, Neural Network). Comfortable with Market Basket, RFM and Sentiment analysis techniques
6 years experience
Proficient in creating a story out of numbers. Skilled in creating detailed and interactive dashboards to provide data summaries and trends.
Proficient in creating a story out of numbers. Skilled in creating detailed and interactive dashboards to provide data summaries and trends.
6 years experience
Have extensive experience in data manipulation and insights generation using Excel, R/Python.
Have extensive experience in data manipulation and insights generation using Excel, R/Python.
6 years experience
Expertise in creating smart sheets using VBA, Pivots, Graphs, and Cell Logics
Expertise in creating smart sheets using VBA, Pivots, Graphs, and Cell Logics

REVIEWS FROM CLIENTS

aman's profile has been carefully vetted and approved as a Codementor. Connect with aman now, and leave a review for them once you're done!
EMPLOYMENTS
Team Lead- Growth Analytics
Paytm
2020-06-01-Present
• Leading the team of analysts and merchandisers to boost the traffic coming to fashion category (Apparel, Footwear and Fashion Accessori...
• Leading the team of analysts and merchandisers to boost the traffic coming to fashion category (Apparel, Footwear and Fashion Accessories) by running multiple experiments and campaigns on Paytm and Paytm Mall app • Responsible for driving the overall grid page to product description page conversion rate by providing the consumer relevant products and best deals • To track the hourly performance of various discounted sales (Festive season, Payday, Weekend bazar, End of season, Flash Sale) and provide real time insights to category teams in order to maximize the overall revenue • Developing the overall data pipeline for the upcoming new social commerce product (Paytm Bang) to help CXOs and category teams understand the business performance
Python
SQL
Excel
View more
Python
SQL
Excel
Google BigQuery
Tableau
Google Data Studio
View more
Business Analyst
OYO Rooms
2019-11-01-2020-06-01
• Developed Daily/Weekly/Monthly business summary reports to enable property level performance management for United States, Canada, Braz...
• Developed Daily/Weekly/Monthly business summary reports to enable property level performance management for United States, Canada, Brazil and Mexico region • Built multiple web scrapers to fetch property level platform and funnel metrics from Booking.com and Expedia.com to enable property level performance comparison against the competitors in the same region • Developed Organic placement Index as a metric to comprehend property rank over multiple online travel agent listings and its use to boost the ranking • Created multiple triggers/alerts at booking level to minimize revenue loss coming through low pricing of hotels • Developed Booking window/Cancellation window analysis tools to understand consumer behavior difference among different types of properties
Python
SQL
R
View more
Python
SQL
R
Excel
Machine Learning
Apache Hive
View more
Operations Analyst
Great Learning
2018-01-01-2019-11-01
Developed operational metrics derived from raw company data to track improvements in business efficiency in terms of student grades, prog...
Developed operational metrics derived from raw company data to track improvements in business efficiency in terms of student grades, program completion status, student defer/dropout rate, student feedback, in-class attendance, faculty feedback, faculty occupancy index and batch sentiment analysis • Created 100+ practice assessments for the students to emphasis more hands-on learning to get learning outcomes, developed a weekly report to track batch level adoption of the tests along with student improvement area • Defined end to end processes which resulted in: o Reducing student queries resolution time by 70% o Reducing assessment errors by 95% o Enhanced grading quality of the assessments to provide detailed feedback to the students to increase performance transparency
Python
SQL
R
View more
Python
SQL
R
Excel
Automation
Tableau
Microsoft Power BI
View more
PROJECTS
Sales Portfolio Optimization
2015
Created a portfolio for the sales account managers using the Efficient Frontier Theory by optimizing and identifying key areas of risk an...
Created a portfolio for the sales account managers using the Efficient Frontier Theory by optimizing and identifying key areas of risk and returns with different customers
SQL
R
Excel
View more
SQL
R
Excel
Microsoft Power BI
View more
Sales Forecasting using Time Series
2017
Developed prediction tool for the sales for Coca-Cola in Caribbean region for the upcoming 4 weeks using Holt-Winters method and other mo...
Developed prediction tool for the sales for Coca-Cola in Caribbean region for the upcoming 4 weeks using Holt-Winters method and other modeling techniques
SQL
R
Excel
View more
SQL
R
Excel
Machine Learning
Microsoft Power BI
View more