aabhaas sethi
Business Analyst at Amazon
business analyst amazon
skill set includes : • analytical tool – r , python , sql , excel , quicksight • machine learning technique – linear/logistic regression , ridge lasso regression , decision tree , random forrest , boosting , cross validation , k-means clustering , knn , etc . • experience – transportation aggregation , customer segmentation take look academic project : • machine learning project – http : //rpubs.com/aabhaas • tableau public profile ( academic project ) – http : //public.tableau.com/profile/aabhaas.sethi # ! /
Amazon
https://www.linkedin.com/company/amazon
Provide analytics support to reduce seller friction

●	Reduced Over Enforcement: Identified automated rules that were over enforcing top-performing sellers. The proposed changes allowed these sellers to do business worth $1 million in quarterly sales.
●	Creating KPIs: Brainstormed with the program managers to measure business performance by creating metrics that are reviewed weekly by leadership. Used SQL, Python, and R for data extraction and wrangling that helped in reducing manual effort by 97% (reduction from 1.5 days to 1 hour per week).
●      Identified Low-Value Tasks: Performed analysis to identify non-value adding manual tasks that were being done in Amazon that saved a headcount of 10 personnel in Asia ($264,000 annually).
Greater Seattle Area
https://media-exp1.licdn.com/dms/image/C560BAQHTvZwCx4p2Qg/company-logo_100_100/0/1612205615891?e=1655942400&v=beta&t=AVKhS-aqZ8h_yaf-McQWAc1jIlHiawZrjoadhfnNFOM
Business Analyst
Cincinnati Bell
https://www.linkedin.com/company/cincinnatibell
Provided analytical support to the operations team at Cincinnati Bell. 
Tools: R, Excel, and Tableau 
Statistical Techniques Used: Chi-squared Test, Decision Trees

● Predicting Technician Dispatches: Captured trends through visualizations in Tableau and used statistical techniques such as Chi-squared tests and decision trees to analyze internet speed test data and predicted technician dispatches
Cincinnati Area, KY
https://media-exp1.licdn.com/dms/image/C560BAQEuH25VzGCw3w/company-logo_100_100/0/1645029902077?e=1655942400&v=beta&t=P_8NucBuEDB_hnsRCm0Rs8GJCfYEp9NiSJ1GHs4qw1s
Student Consultant (Academic)
Jugnoo
https://www.linkedin.com/company/jugnoo
Provided analytical and operational support for strengthening supply and demand of auto-rickshaw rides in more than 12 Indian cities. I primarily used SQL, R, and Excel for my work.

Major Projects:
o Fraud Detection
– Used techniques to narrow the search for suspicious drivers and saved ~4 man-days/week; potential financial savings> $10,000/year 

o Segmenting Users: Identified important parameters and clustered users (drivers) for providing different features in their apps based on their performance

o Improved Customer Care Employee Productivity
– Identified KPIs and created an Excel-based dashboard to present occupancy and productivity data of customer care employees; further, streamlined shifts of the employees after analyzing performance data that resulted in ~10% (avg) increase in productivity (W-o-W) 

o Measuring KPIs: Wrote SQL queries to measure KPI’s such as profit/city, debt per city, cancellations, etc. and presented the results biweekly to higher management to discuss business strategies 

o Ride Fare Analysis: Adjusted auto ride fares after analyzing competitor’s fares; prevented supply crisis in a city by negotiating new fares with the city driver union that lured drivers to reduce ride cancellations and increased the average number of daily rides in the city by ~23% M-o-M
Chandigarh Area, India
https://media-exp1.licdn.com/dms/image/C560BAQEs-1D8tod0sA/company-logo_100_100/0/1519913482402?e=1655942400&v=beta&t=EgxVn1g8UVKIOd1GEpc5Vtnit-RXIwmh3urP1LN4F0w
Data/Operations Analyst
The Smart Cube
https://www.linkedin.com/company/the-smart-cube
Provided business research and analytics support to Fortune 500 healthcare/pharma and Retail clients.
Major Projects: 
o Calibration Verification Linearity (CVL) Market Study: 
–Held consultation calls with US-based experts to understand the Calibration Verification industry, identified key parameters, and created an analytical methodology to estimate the market size; also provided qualitative analysis that included industry trends, opportunity areas, etc

o Spend Analysis: Analyzed conference expenditure of employees of a global pharmaceutical company in Excel; automated the process for generating report and visualizations for the travel spend data
Noida Area, India
https://media-exp1.licdn.com/dms/image/C4D0BAQGAUWkvaiIBPA/company-logo_100_100/0/1625116902465?e=1655942400&v=beta&t=tDkNxY51sJUQHaeMDqQeOKR-BI6apWRyFBOd_stuTsk
Senior Analyst
The Smart Cube
https://www.linkedin.com/company/the-smart-cube
Noida Area, India
https://media-exp1.licdn.com/dms/image/C4D0BAQGAUWkvaiIBPA/company-logo_100_100/0/1625116902465?e=1655942400&v=beta&t=tDkNxY51sJUQHaeMDqQeOKR-BI6apWRyFBOd_stuTsk
Analyst
Master of Science - MS
Academic Projects:    Link: http://rpubs.com/Aabhaas

● Predicting Employee Attrition: Predicted employee attrition using Logistic Regression, Classification Tree, and Random Forest. Additionally, used sampling techniques such as Over Sampling, SMOTE, etc. and compared model performance 

● Credit Risk Prediction: To predict if a customer poses a credit risk or not. Compared the performance of logistic regression and Decision Trees for this prediction 

● FAA Landing Distance Prediction: Studied the factors that impact the landing distance of a commercial flight and used linear regression to predict the landing distances
Business Analytics
https://media-exp1.licdn.com/dms/image/C4E0BAQE9Wc6eXl6Edg/company-logo_100_100/0/1519908500732?e=1655942400&v=beta&t=keNLR4mOyWbhn0U7q04Lwmq-k49pXEGoNAD7hoAzuz8
University of Cincinnati Carl H. Lindner College of Business
https://www.linkedin.com/school/university-of-cincinnati-college-of-business/
https://media-exp1.licdn.com/dms/image/C4E0BAQGFaEpL_pmvyQ/company-logo_100_100/0/1604685412914?e=1655942400&v=beta&t=xW9AjoPaBLTJCj9piWXVYhg3jiTbuo88kSXDe2sXeCI
Punjab Engineering College
https://www.linkedin.com/school/punjab-engineering-college/
Received a Certificate of Merit from Central Board of Secondary Education for being among top 0.1 % of successful candidates nationwide in Mathematics in 2009 All India Secondary School Examination. 
---------------------------------------------------------------------------------------------------------------------
Also qualified the pre-screening for selection of students to appear in Round 1 of Regional Mathematics Olympiad 2009 (organized by Centre of Advanced Studies in Mathematics, Panjab University, Chandigarh).
Central Board of Secondary Education
Certificate of Merit
Predicted employee attrition using Logistic Regression, Classification Tree, and Random Forest. Additionally, used different sampling techniques such as ROSE, SMOTE, Over Sampling, etc. and compared model performance.
Predicting Employee Attrition
http://rpubs.com/Aabhaas/employeeattrition
Identified the zip codes that would generate the most profit on short term rentals within New York City
AirBnB & Zillow Data Analysis
http://rpubs.com/Aabhaas/AirbnbZillow
Predicted if a customer posed a credit risk or not and compared the performance of logistic regression and decision trees for this prediction
Credit Risk Analysis
http://rpubs.com/Aabhaas/Credit_Risk_Analysis
Identified factors that impact the landing distance of a commercial flight and developed a linear model to predict the landing distance; also developed a logistic regression model to predict the flights with risky landing distances
FAA Landing Distance Prediction
http://rpubs.com/Aabhaas/462874
Developed a linear regression model in R to analyze factors affecting alumni donation and predicting donation for public and private universities
Predicting Alumni Donation
http://rpubs.com/Aabhaas/Predicting_Alumni_Donation
Performed sentiment analysis on Amazon Alexa reviews in R
Sentiment Analysis- Amazon Alexa Reviews
http://rpubs.com/Aabhaas/sent_analysis
We Initiate
o Organized events to promote financial inclusion: Collaborated with Bank of India, Hallomajra Branch, Chandigarh and helped in opening ‘zero balance accounts’ for more than 300 poor and uneducated people
o Organized free health check-up camps for the needy people in my city
Volunteer/Team Leader
https://www.linkedin.com/in/juno-li
Greater Seattle Area
Juno Li
Business Analyst at Amazon
https://www.linkedin.com/in/zhu-huang
Greater Seattle Area
Zhu Huang
Business Analyst II at Amazon
https://www.linkedin.com/in/yashshah05
Greater Seattle Area
Yash Shah
Business Analyst at Amazon
https://www.linkedin.com/in/sonammisra
Seattle, WA
Sonam Misra
Business Analyst at Amazon | MS in Business Analytics
https://www.linkedin.com/in/rathikhushbu
Seattle, WA
Khushbu Girish Rathi
Business Analyst at Amazon
https://www.linkedin.com/in/yesha-nagar
Austin, TX
Yesha Nagar
Business Analyst at Amazon
https://www.linkedin.com/in/harshitndesai
Seattle, WA
Harshit Desai
Business Analyst at Amazon
https://www.linkedin.com/in/parthmehta24
Seattle, WA
Parth Mehta
Business Analyst at Amazon | Data Analysis | Business Intelligence | Product Analysis
https://www.linkedin.com/in/trishul-gowda-a-91b96578
Seattle, WA
Trishul Gowda A
Senior Business Analyst at Amazon
https://www.linkedin.com/in/avneeshrekhi
Seattle, WA
Avneesh Rekhi
Business Analyst II at Amazon
https://www.linkedin.com/in/komalmahajan20
Seattle, WA
Komal Mahajan
Business Analyst at Amazon
https://www.linkedin.com/in/palashkhandekar
Seattle, WA
Palash Khandekar
Business Analyst at Amazon
https://www.linkedin.com/in/abineshsk
Nashville Metropolitan Area
Abinesh Senthil Kumar
Business Analyst at Amazon
https://www.linkedin.com/in/caoyuan-caylen-c-399651170
New York City Metropolitan Area
Caoyuan (Caylen) C.
Business Analyst II at Amazon
https://www.linkedin.com/in/shu-wang-65b1a557
Seattle, WA
Shu Wang
Business Analyst at Amazon
https://www.linkedin.com/in/wakaditya
Greater Seattle Area
Aditya Wakade
https://www.linkedin.com/in/rojaashok
Seattle, WA
Roja Ashok
Business Analyst at Amazon
https://www.linkedin.com/in/monalisa-swami
Greater Seattle Area
Monalisa Swami
Business Analyst at Amazon
https://www.linkedin.com/in/riddhikotian
Bellevue, WA
Riddhi Kotian
Business Analyst at Amazon
https://www.linkedin.com/in/mallikatiwari
Greater Seattle Area
Mallika Tiwari
Business Analyst II at Amazon
Brian Sweeney
      
          



            
              
        
              
  

    
        Aabhaas worked under me as a student consultant during his graduate studies at the University of Cincinnati.  He did an excellent job providing insights though visualizations in R and Tableau.  He was able to explain the results of the statistical techniques that he implemented in a clear and concise manner.  He displayed a good sense of ownership and professional behavior throughout the project.  I wish him the best in his future endeavors. 
University of Cincinnati Master of Science Business Analytics Alumni
https://media-exp1.licdn.com/dms/image/C5607AQEVIYoYbLcsQQ/group-logo_image-shrink_200x200/0/1631418045938?e=1647687600&v=beta&t=VBTJB7pJBRyHjODK9aZomBC4Xb9RZ64PKs5u3wOcG8k
https://www.linkedin.com/groups/8136768
The PEC Alumni Society (PALS)
https://media-exp1.licdn.com/dms/image/C4E07AQEJK0ENNSQj7g/group-logo_image-shrink_92x92/0/1631007328719?e=1647687600&v=beta&t=RxjsbkqbjbAiLP8YV6C5gFYlNwMHd44psrIn0Mfkjs4
https://www.linkedin.com/groups/40869
UC Center for Business Analytics
https://media-exp1.licdn.com/dms/image/C5607AQH9wPWsTbOqvg/group-logo_image-shrink_200x200/0/1631437837234?e=1647687600&v=beta&t=EL0-3w7xol5OgXq5JgXOp3WIoleOjqcELJFjXXJUAAI
https://www.linkedin.com/groups/8229883