Learn Data Skills
William Tran

William Tran


Business Analyst

The Lab Consulting


My Portfolio Highlights

My New Course

Introduction to SQL

Analytical superhero, saving the world from data chaos.

My Work

Take a look at my latest work.


Project: Analyzing Students' Mental Health in SQL


Introduction to SQL


Intermediate SQL


Joining Data in SQL


Course notes: Exploratory Data Analysis in SQL

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Analyst Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Buck Mason | Mar 2023 - Present

Assistant Store Manager


Buck Mason | Jun 2022 - Mar 2023

Sales Team Lead


Buck Mason | May 2022 - Jun 2022

Sales Associate


Au Lac Fountain Valley | Jul 2020 - May 2022


Comprehensive coordination of a restaurant front of house (FOH) team with 10+ team members to ensure smooth flowing operations and an outstanding guest experience during lunch and dinner services Set and meet ambitious sales goals through targeted marketing & promotional strategies, upselling, and leveraging strong customer relationships Enforce and expand upon restaurant policy and procedure to constantly improve guest experience, establish high standards of cleanliness and organization, streamline operations, and adhere to food safety regulations Formulate smart and fair solutions to resolve conflicts between employees as well as with dissatisfied guests Produce high performing team members through intelligent hiring and training Assist in menu development taking into account the voice of the customer (VOC), pricing and other sound marketing principles Manage restaurant inventory, including disposable goods, fresh produce, and cleaning supplies
Show More

Motiva Enterprises LLC | Jun 2019 - Sep 2019

Sales Support Analyst

Support the sales team with all necessary data & analytics to drive sales and achieve quarterly goals Create customer accounts using MSAP, RA, and facilitating the E2E completion of setup working at with OSP's and Equity terminals (TMS) and other teams who play a role in the setup process Prepare sales activity reports and other reports/analyses as necessary or requested by sales team Serve as focal point for US Fuels Sales Support during regular meetings and forums specifically focused on the CS&A processes

Smith & Associates | Mar 2019 - Jun 2019

Trading Coordinator

Coordinate the accurate and efficient fulfillment of transactions for the North American region using strong communication and on the fly problem solving Collaborate with sales, purchasing, operations and finance departments to manage the proper movement of materials between 3 warehouses globally

Smith & Associates | May 2018 - Mar 2019

Purchase Price Variance Analyst

Analyze Smith's wide array of supply/demand channels against customer requirements for electronic components to best determine high-yield trading opportunities Promote cost-saving solutions to multi-billion dollar electronics manufacturers and foster long-term, two-way trading relationships Strong utilization of ERP and MS Excel for data analysis

Smith & Associates | Jan 2018 - May 2018

International Account Representative

Tailor top-notch supply chain strategies encompassing shortage sourcing, vendor managed inventory (VMI), consignment, and excess inventory disposition considering each customer's unique opportunities and problem areas Independently generated sales leads through various tools and methods while executing 70-80 cold calls per day to the world's largest electronics manufacturers

The Lab Consulting | Mar 2016 - Aug 2016

Marketing Intern

Maximized sales leads by creating industry-specific collateral packages for sales presentations and collaborated with public relations on direct mail & e- mail campaigns Conducted market research on Fortune 500 companies and executives to enable sales managers to drive growth through targeting best potential clients Organized and updated vast client database containing crucial data on thousands of clients

Prosperity Bank | Jun 2013 - Aug 2013

IT Intern

Consulted 20-30 Prosperity Bank employees per day to solve unique technical issues Collaborated with team of technicians to troubleshoot diverse issues concerning programs such as Citrix, SAP, and Microsoft Office Suite

J.Crew | Apr 2013 - Aug 2013

Sales Associate

Performed consultative sales with 30-50 customers daily to reach and surpass sales goals Operated POS system to process thousands of dollars in transactions per day

Life Time - Healthy Way of Life | May 2011 - Aug 2011


CPR & American Red Cross Certified Lifeguard Ensure safety for 100+ patrons daily, including children and disabled, across entire aquatics facilities

My Education

Take a look at my formal education

Bachelor of Business Administration (B.B.A.), Marketing, Magna Cum Laude, 3.8 University of Houston | 2017

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free