Roger Tran

adb3me@r.postjobfree.com ** Elm Avenue Unit 2

626-***-**** Long Beach, CA 90802

Linkedin: https://www.linkedin.com/in/roger-tran-80a2091a/

Summary

Well versed in database technologies. Experienced in engineering scalable data solutions.

Work Experience

simplehuman Sep 2018—Jan 2020

MIS Manager Torrance, CA

Managed and configured XML file exchange between databases on distributed systems

Designed Python programs to integrate data with an international carrier enabling all Canadian shipping. Trained users how to execute data transfer

Updated EDI database view configuration mitigating chargebacks from retailers.

Built data pipeline with 3rd party solution to automate chargeback dispute process on Amazon’s vendor portals

Developed ETL jobs and reporting to optimize processes for Logistics and Accounting departments by leveraging 3rd party supply chain software API

Created inventory and fulfillment data pipeline between ERP database and Shopify by passing JSON data to a custom middleware API

Administered IT tasks such as employee onboarding/offboarding and managing permissions

UBTECH Robotics Corp Sep 2017—Sep 2018

Sales Operations Analyst LA, CA

Set up data warehouse on AWS, supporting sales analytics functions

Developed ETL processes to load data from Netsuite, FTP server, and CSVs into data warehouse

Created a web scraping app in Python to automate over 5000 CSV and PDF file downloads from our supply chain partner’s web portal

Managed EDI configuration and communication from our ERP system to our warehouse and retailers

Dolls Kill Jan 2016 – Aug 2017

Operations Analyst SF, CA

Optimized product setup operation for launching products on site. Reduced operating cycle time by over 70% from 33 days down to 9 days through process optimization, employee training and reporting

Wrote SQL queries to extract data from customer and internal ops database tables to generate reporting insights

Used business intelligence tools to visualize data for analysis to service merchandising and creative operations teams

Translate operations data into dashboards and auditing tools for non-technical departments

Automated sales reporting, eliminating user error and 3 hours of manual report building daily

Education

University of Southern California, Viterbi Data Bootcamp LA, CA

Executive Education, Data Analytics Certification Jan 2018 – July 2018

University of Southern California, Marshall School of Business LA, CA

Bachelor of Science, Business Administration Graduated May 2014

Skills

Programming Languages – Python, SQL, VBA

Database Technologies – SQL Server/T-SQL, MySQL, MongoDB/NoSQL, AWS Redshift & RDS, SSIS, Apache Spark

Cloud Infrastructure – Azure, AWS

Data Management – ETL, Web Scraping, FTP Server Requests, API Requests, Database Views and Stored Procedure Management

Microsoft Office Suite

Data visualization – Tableau, Mode Analytics