Personal details

aman B. - Remote

aman B.

Timezone: Pacific Time (US & Canada) (UTC-7)

Summary

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.

Work Experience

Team Lead- Growth Analytics
Paytm | Jun 2020 - Present
Python
SQL
Excel
Google BigQuery
Tableau
Google Data Studio
• 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
Business Analyst
OYO Rooms | Nov 2019 - Jun 2020
Python
SQL
R
Excel
Machine Learning
Apache Hive
• 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

Personal Projects

Sales Portfolio Optimization
2015
SQL
R
Excel
Microsoft Power BI
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
Sales Forecasting using Time Series
2017
SQL
R
Excel
Machine Learning
Microsoft Power BI
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