Summary
Overview
Work History
Education
Skills
Websites
Business Analytics
Timeline
Generic

Mohit Shrestha

Fayetteville,Arkansas

Summary

Focused Sales Analyst with comprehensive experience evaluating and predicting sales trends. Expertise in inside sales management, new business development and tracking and sales analytics. Proficient in various job-related software. Reliable team player possessing first-rate organizational, time management, and communication skills.

Overview

4
4
years of professional experience

Work History

Administrative Assistant

Ralph E. Martin Department of Chemical Engineering, University of Arkansas
Fayetteville
2021.12 - 2024.08
  • Led cross-functional teams to streamline procurement processes using Quartzy and MS Project, overseeing the requisition of over 80 items weekly, and ensuring alignment with supply chain, sales, and research teams on material needs and project timelines.
  • Implemented a new invoice verification system for 11 staff members, reducing processing time by 22%.
  • Spearheaded data-driven initiatives, coordinating large-scale events with 200+ attendees, leveraging strong project management skills to manage schedules, allocate resources, and report on progress to the supervisor.

Greenhouse Lab Assistant

Crop, Soil, and Environmental Science Department, University of Arkansas
Fayetteville
2020.08 - 2021.09
  • Coordinated and managed research projects, including data analysis through SAS on 500+ crop specimens weekly, improving hydration strategies that resulted in a 12% yield increase.
  • Assisted researchers with designing protocols for experiments.
  • Oversaw the daily management of genotype registration and analysis for 7 genotypes, improving accuracy and data reliability.
  • Streamlined greenhouse production scheduling, maintaining records for over 3,000 crops.
  • Conducted data analysis to identify trends in experiments.

Education

Master of Applied Business Analytics -

University of Arkansas, Walton College of Business
08.2024

Bachelor of Science in Business Administration -

University of Arkansas, Walton College of Business
05.2022

Skills

  • Business Intelligence: SAS EM, SAS EG
  • Performance Improvement
  • Data querying: SQL, SSAS, SSIS
  • Data Visualization: Tableau, Power BI, Excel, Visual Studio
  • Dashboard Development & Automation
  • Project Management: MS Project, Agile Methodologies, Resource Allocation
  • Cross-Functional Collaboration
  • Data Governance and Compliance
  • Data Entry
  • Database Management
  • Presentation Design
  • Office Administration

Business Analytics

Interactive Dashboard for Kenvue's Listerine Products in Sam's Clubs, 07/24

  • Developed a Tableau dashboard to track sales, volume, and SKU performance, automating data prep through Excel and Tableau Prep Builder for real-time insights on pricing and promotions. Enabled self-service reporting for shareholders and delivered actionable insights through weekly reviews.

School Shooting Database Management, 03/24 - 05/24

  • Designed and implemented a SQL Server database to analyze school shootings, focusing on weapon types and casualty correlations. Used complex SQL queries and ETL processes via SSIS and SSRS to extract, transform, and report data, generating insights that supported policy recommendations.

Arizona Housing Market Analysis, 01/24 - 03/24

  • Analyzed 7,000+ housing records using SAS to predict the closest sold price for properties; developed predictive models including Linear Regression, Decision Trees, and KNN, achieving the lowest RASE of $96,227.92 by optimizing 80 key variables, focusing on critical factors such as property size, location, and school districts.

Timeline

Administrative Assistant

Ralph E. Martin Department of Chemical Engineering, University of Arkansas
2021.12 - 2024.08

Greenhouse Lab Assistant

Crop, Soil, and Environmental Science Department, University of Arkansas
2020.08 - 2021.09

Master of Applied Business Analytics -

University of Arkansas, Walton College of Business

Bachelor of Science in Business Administration -

University of Arkansas, Walton College of Business
Mohit Shrestha