Overview
Skills
Work History
Education
Certification
Languages
Quantitative Lab Experience
Quantitative Lab Experience
Generic

Oliver Tung

Business Intelligence
San Diego,CA

Overview

7
7
years of professional experience
1
1
Certificate

Skills

  • SQL (PostgreSQL, MySQL)
  • Microsoft Excel (VLOOKUP, Pivot Tables, Conditional Formatting)
  • Tableau (Parameters, Calculated Fields, Filters, Dashboards)
  • R Statistical Programming (dplyr, plyr, ggplot)
  • Shopify (Web Development, A/B Testing)
  • Custom Reporting
  • Trend Analysis
  • Data Analysis
  • Pattern Recognition
  • KPI Monitoring
  • Systems Analysis

Work History

Business Intelligence Analyst

Texas Instruments
03.2023 - Current
  • Collaborated with upper management to drive strategy and implement new operation processes.
  • Collected buying data across 1000+ vendors and designed a simple visualization for team.
  • Improved systems with addition of new inventory management system and infrastructure.
  • Investigated system issues and implemented resolutions to reduce production downtime.
  • Developed diagrams to describe and lay out logical operational steps.
  • Captured projected cost and revenue synergies and move combined organization forward.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Defined and documented scope of projects for distribution to the team.
  • Researched and adopted new technologies to add value to existing offerings.
  • Optimized core processes to improve business performance and operational agility.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Director of Operations

Bixby & Ball
02.2022 - 09.2022
  • Directed the daily operations of a boutique interior design store and upheld a prestigious level of customer care
  • Analyzed and optimized the allocation of inventory between 3 storefronts using Lightspeed's quantitative analysis
  • Managed the operational workload calendar and delivered a predictive and cadenced workflow for the operational assistant and the sales team
  • Oversaw the daily operation of the inventory warehouse by minimizing vendor errors to ensure a solid and accurate inventory pipeline for the company
  • Troubleshooted operational errors and damage claims by communicating with vendors and supply chain managers, reducing company liabilities.

Director of Operations

Rolling Up Delivery
03.2018 - 01.2022
  • Directed the operations of a delivery startup and increased company revenue from $500K to $3M between 2018 & 2020
  • Analyzed customer retention data and orchestrated a strategic marketing campaign which led to an increase of 10,000+ customers and $2+ million in sales revenue within 2 years
  • Cleaned web customer data using Excel conditional formatting for email and text marketing campaigns
  • Devised a streamlined operation for dispatchers, drivers, regional managers, and inventory managers to communicate cohesively, which increased customer retention rate by 45% and doubled sales revenue to $2M in 2019
  • Oversaw the optimization of supply chain and inventory allocation among 3 branches using Shopify's live data analysis to diminish obsolete inventory and product line cycles, minimizing company overhead by 10%.

Pharmaceutical Account Executive

Pharmaceutica North America
07.2016 - 01.2018
  • Closed $100K in sales within the first 3 months representing 5% of the sales team's revenue
  • Operated the Salesforce CRM and maintained a steady pipeline of 300 pharmacies and developed rapport through consistent follow up
  • Maximized the ROI of marketing campaigns with the marketing manager by using quantitative analysis on Salesforce.

Education

B.S. in Biochemistry, Medical Emphasis -

University of California, Riverside
Riverside, CA
06.2014

Certification

Google Data Analytics Certification, 09/2022 - 03/2023

  • Performed SQL queries, sorted and filtered data using SQL queries, converted data types using SQL syntaxes.
  • Created pivot tables and cleaned data for analysis using Excel functions.
  • Developed data visualizations using Tableau from data analysis results for data presentation.
  • Utilized R programming for data visualization with ggplot and tidyverse.
  • Used R Markdown to execute code and generate shareable reports.

Languages

English
Native or Bilingual
Chinese (Mandarin)
Full Professional
French
Professional Working
Spanish
Professional Working

Quantitative Lab Experience

Biochemical Protein Separation Lab, Riverside, CA, Lab Assistant under Dr. Anthony Norman, 09/2012 - 06/2014

  • Extracted the molecular weight data of protein samples using SDS-polyacrylamide gel electrophoresis.
  • Extrapolated nonlinear data for statistical forecast after data cleaning using Excel's conditional formatting.
  • Performed regression analysis between forecasted and actual data then created relational graphs for data visualization.

Quantitative Lab Experience

Biochemical Protein Separation Lab, Riverside, CA, Lab Assistant under Dr. Anthony Norman, 09/2012 - 06/2014

  • Extracted the molecular weight data of protein samples using SDS-polyacrylamide gel electrophoresis.
  • Extrapolated nonlinear data for statistical forecast after data cleaning using Excel's conditional formatting.
  • Performed regression analysis between forecasted and actual data then created relational graphs for data visualization.

Similar Profiles

CREATE PROFILE
Oliver TungBusiness Intelligence