Ayush Anand
Business Analyst
Bangalore
Summary
Experienced Business Data Analyst specializing in automating manual tasks and optimizing processes to enhance efficiency and reduce stakeholder effort. Proficient in using analytical skills to deep dive into issues and resolve them, while collaborating with various stakeholders to develop effective solutions and facilitate faster, more informed decision-making.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Business Analyst
Amazon
12.2022 - Current
- WBR Automation: Automated the Weekly Business Review (WBR) report for logistics and customer support related metrics, significantly reducing preparation time for the team.
- Fraud Detection Flash: Developed a daily fraud detection flash using multiple data inputs to identify suspicious sellers, resellers, and buyers, helping reduce the reject rate from 7-8%.
- Day 1 Logistics Cost Automation: Streamlined the month-end closure (MEC) process by automating approximately 10 shipping cost reports, enabling faster month-end closures and reducing the report publication time from a week to a single day.
- Applied a supervised machine learning model to predict the reject percentage prior to the Diwali sale, utilizing multiple input variables that are the primary drivers of the reject rate in the e-commerce company. Based on this model, the contribution of various input fields was predetermined for the Diwali sale. Additionally, calculated the R-squared value to evaluate the model's accuracy and visualized the results using a graph created with Matplotlib.
- Report Automation & Dashboarding: Automated key reports for the logistics, customer support, and seller support teams. Created dashboards for stakeholders to access insights efficiently.
- High Return Rate Analysis: Developed and published a return dashboard with multiple data views, which facilitated the identification of high return fraud in Rajasthan during the Diwali sale, resulting in a 2% reduction in return rates.
Assistant System Engineer
TCS
8 2020 - 12.2022
- Extracted and analyzed data using SQL queries for jira tickets based on stakeholder requirements and generated detailed reports in excel.
- Automated web page testing and data scraping using selenium in python.
Data Analyst Intern
Capstem
05.2020 - 08.2020
- Developed a fully automated pipeline for downloading, merging, and processing daily CSV files from the NSE website, performing data analysis using Python (Pandas, NumPy, DateTime) and visualized results with Matplotlib.
- Improved process efficiency by enabling stakeholders to calculate market volatility, leading to faster, data-driven decisions on stock options and reducing manual effort.
Data Analyst Intern
366 Pi
05.2019 - 07.2019
- Implemented extendible hashing and converted it into a library so that API's can be written onto it and shared it onto a project shareable folder through which different users can access it.
Education
B.Tech -
KIIT University
07.2016 - 05.2020
Skills
SQL
Certification
Complete python bootcamp : Go from zero to hero in python 3, 02/2019 - 04/2019
Languages
English
Hindi
Personal Projects
Color game using python's tkinter module - In this game different colors are there and interface will display name of different colors in different colors. Player has to identify the color and enter the correct color name to win the game. Registration form using python's tkinter module - User has to fill up the required information, and that information is automatically written into an excel file.
Timeline
Business Analyst
Amazon
12.2022 - Current
Data Analyst Intern
Capstem
05.2020 - 08.2020
Data Analyst Intern
366 Pi
05.2019 - 07.2019
B.Tech -
KIIT University
07.2016 - 05.2020
Assistant System Engineer
TCS
8 2020 - 12.2022
Similar Profiles
Lieszel WolfgrammLieszel Wolfgramm
Fulfillment Center Associate at AmazonFulfillment Center Associate at Amazon
Ethan AlcornEthan Alcorn
Transportation Manager II at AmazonTransportation Manager II at Amazon
Morena ArandaMorena Aranda
Learning at AmazonLearning at Amazon