Rohan Agrawal Email & Phone Number

United States

• Conducted A/B tests to optimize ecommerce shopping funnel and subscription plan designs leading to 8% decrease in customer churn.• Introduced ‘auto-stock’ purchase option to clients using time-series forecasting on Salesforce data, improving profit margins by $10k.• Performed market research in Qualtrics, identifying new target market that led to $200k increase in revenue and new service offerings.• Tracked and presented marketing KPI reports to stakeholders using Tableau to improve the decision-making process.

Chicago, Illinois, United States

Mentored 10 student-athletes to achieve A grade in Data Analysis (IDS237), Statistics (IDS 207) and Quantitative Marketing Skills (MKTG370).

Chicago, Illinois, United States

Collaborated with 2 instructors to guide 200 students on methods of statistical analysis in R, SPSS, and Tableau through lectures and workshops, increasing average class grade by 20%.

• Achieved 20% increase in cross-sell rates through market basket analysis by offering complementary products to a live customer base.• Performed KMeans customer segmentation on 1TB of POS data for Amazon India’s largest retailer, leading to $300k revenue increase.• Automated daily sales KPI reports to stakeholders using Azure Databricks, reducing time-to-insights by 30%.

- Developed Tableau dashboard to track logistics and financial KPIs, reducing annual shipping costs by $80k.- Automated and centralized procurement operations using R, SQL, and Excel, consolidating vendor and raw material data, improving operational efficiency by 15%.

- Performed ETL process using SQL on national healthcare data improving data accuracy by 25%.- Developed Tableau dashboard to track the rise and spread of COVID-19 in India, presenting KPIs to stakeholders facilitating government healthcare policies.- Researched and compared facial-recognition systems such as HoG, CNN, using Python achieving 80% accuracy.

International publication in Springer Series on developing a content-based music recommender with F1 score of 0.87.

- Developed and administered surveys to evaluate performance of 100+ field project managers using Qualtrics. - Presented survey and performance reports to stakeholders to implement and optimize project changes leading to empowerement of 1500+ rural women entrepreneurs Presented dashboards analyzing performance and impact of Govt. projects for effective evaluation of the field project managers

Secured funding of $150k, managed budgets, and logistics for international interns from 80+ countries

Master'S Degree, Management Information Systems, General

Activities and Societies: Flames Consulting Group Relevant Coursework: Advanced Database Management, Statistics for Management, Project.

Bachelor Of Technology - Btech, Information Technology

Activities and Societies: IAESTE- Head of Corporate TEDx- Event management team lead Organizing Committee- Technical workshops Relevant.

Master Of Science - Ms, Management Information Systems, General