Data Analyst Electrical

BAI LI

**-** ******* ***, **** Island City, NY **101 617-***-**** adcc06@r.postjobfree.com

PROFESSIONAL SUMMARY

Motivated and results-driven Analyst with proven track record in data analytics and process mapping. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency. Drives business effectiveness through making recommendations based on data and research findings. Proficiency in SQL, Python, R, MATLAB, Hadoop, MapReduce, Pig, MS Access, Tableau, Power BI, Git, and ArcGIS. WORK HISTORY

Data Analyst, 11/2018 to 09/2019

HiFu Services Inc. – Brooklyn, NY

• Streamlined merchant retail (fashion and luxury companies such as Tiffany, Cartier) transaction data collecting and retrieving procedures within MS Access by optimizing database schemas and designing custom queries, as well as created data dictionaries for automating data cleansing

• Created multi-dimensional Tableau and Excel charts (butterfly, waterfall, heat map) to identify customers' key purchasing patterns and demographic metrics

• Proposed and launched notification system based on customers' preference, merchant tier-level and geo- location matching on mobile device, receiving over 70% click-through rate on Black Friday event

• Implemented Google analytics tracker and Scanova on over 30 campaign websites to monitor real-time traffic flow to gather users' website browsing patterns

Researcher, 09/2016 to 09/2018

Institute for Sustainable Energy – Boston, MA

• Assisted Professor Peter Fox-Penner in a project funded by Boston city government and DOE

• Conducted transportation sector energy and emission forecast using Kaya Identify equation

• Applied Bass Diffusion Model under three different technology adoption scenarios for Electronic Vehicle sales projection

• Participated in the publication of Fox-Penner, P., Gorman, W., Hatch, J. (2018). Long-term U.S transportation electricity use considering the effect of autonomous-vehicles: Estimates & policy observations Data Analyst Intern, 07/2016 to 08/2016

Shanghai Electrical Apparatus Research Institute – Shanghai, CN

• Extracted geo-location road accident data in Shanghai via PL/SQL

• Performed time series predictive analysis, and exported the database to ArcGIS-ArcMap to visualize the result in heat map

• Analyzed correlations between road accidents and multiple factors including weather, temperature and driving behaviors, delivering the final reports within 1 week to Public Transport Division Intern, 03/2015 to 04/2015

Deloitte LLP – London, UK

• Assisted both Corporate Finance and Digital Consulting department

• Participated in WHSmith retail store site selection process by running customer segmentation analysis, k- means and linear regression model

• Participated in team case competition of proposing a ride sharing company expansion initiatives in Europe by analyzing key factors in taxation policy and revenue enhancement EDUCATION

Master of Science: Electrical and Computer Engineering, 09/2016 - 05/2018 Boston University - Boston, MA

Bachelor of Arts: Physics, 09/2013 - 06/2016

University of Oxford - Oxford, UK

Contact this candidate