Brian Ramirez

Experience

• 

  UCR School of Business

  Mar 2014 - Jun 2016

  Lead Student Assistant

  • Counseled 30+ students a day on class schedules, course planning, and other undergraduate information• Volunteered in summer campus recruiting events to provide information about UCR’s business program to over 100 students and parents• Coordinated a team of 3 in the planning, facilitating, and completion of daily projects • Designed and revised worksheets, tables and flyers utilizing Microsoft Excel, Access and Publisher

• 

  Phi Chi Theta Business Fraternity

  May 2016 - Jun 2019

  • Increased organization membership from 8 to 50 (500% increase) through social media outreach, freshman orientation outreach events, and flyer distribution• Developed an effective new member process from scratch that strengthens professional development in new members • Collaborated with LinkedIn, various business professors, and other organizations to organize 5 professional events such as office tours, panels, and workshops• Organized multiple presentations speaking to over 50 students on topics like Excel, interviewing skills, and career advice• Created by-laws, membership process, and strong relationships with 5 other organizations and 10+ professors that built a strong foundation for the fraternity

  • Founding Pledge Educator

    May 2015 - Jun 2019

  • Vice President of Professionalism

    May 2016 - Jun 2017
• 

  GENTLE MONSTER

  Jan 2018 - Jun 2019

  • Constructed a master inventory spreadsheet to track over 1000 damaged or defective eyewear products with key metrics using over 10 Pivot tables and charts• Built Excel dashboard to analyze month-over-month lost sales, which indicated $2,000 in average monthly losses, and identified trends in defective products by combining Pivot charts with Excel formulas• Recorded and tracked all movements of products to maintain 100% inventory accuracy between e-commerce, retail stores, and wholesale operations totaling about 15,000 units• Transformed raw CSV sales data into KPIs by distribution channel, accounting for over $1,100 in weekly transactions• Analyzed sales of popular eyewear styles to create accurate monthly purchase orders of 10,000 products which increased profit margins by 5%• Created workflow diagrams and schedules to streamline e-commerce fulfillment resulting in a 15% decrease in fulfillment time• Trained 5 new employees on supply chain processes to maximize productivity Show less

  • Business Operations Associate

    Apr 2018 - Jun 2019

  • E-Commerce Associate

    Jan 2018 - Apr 2018
• 

  Applied Medical

  Apr 2021 - May 2022

  Access Management Coordinator

  • Optimized SAP Role master sheet utilizing a combination of formulas to auto-populate role information reducing ticket resolution time• Collaborated with the Business Analyst and Applied Learning teams to resolve over 100 weekly SAP system access requests• Conducted weekly meetings with the Business Analysts to maintain Software Change Requests (SCRs) procedure and ensure they are ready for the final stage of development• Designed Employment Training Panel dashboard to display metrics like total training hours, hours invoiced, and reimbursement totals of over $400,000 from the state of California Show less

• 

  Western Digital

  May 2022 - now

  Service Operations Specialist II

  • Developed new RMA backlog process reducing analysis time by 50% and ensuring turnaround time is being met• Analyze US and Canada inventory of over 10,000 WD models to plan for low inventory twice a week• Track over 100 daily inventory transactions in SAP to oversee SanDisk RMA process and write off weekly SCRAP inventory• Coordinate with 8 global service centers to address weekly fulfillment issues and achieve SLA shipping / receiving requirements• Organize ad-hoc training sessions to demonstrate Excel functions and shortcuts Show less