Guanglong Bao

Boston, MA (***) ***- **** adgoqb@r.postjobfree.com www.linkedin.com/in/guanglongbao

OBJECTIVE

Technically strong, detail-oriented business professional with over extensive experience of business analysis and data processing. Results - oriented with demonstrated expertise in business planning and analysis of statistical data to determine inadequacies in business processes, to forecast future risks, and establish strategies for positive change. EDUCATION

Northeastern University Boston, MA

Master in Analytics (GPA: 3.93/4) 01. 2018 - 04. 2019 Coursework: BI Visualization, Data Warehousing, Data Mining, Data Modeling, Advanced Statistics Oregon State University Corvallis, OR

Bachelor of Science in Finance 09. 2013 - 04. 2017 Coursework: Statistics, Micro/Macroeconomics, Applied Quantitative Methods, Finance, Accounting, Portfolio Management TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, Python, R

Database and ETL Tools: MySQL, Microsoft SQL Server, Microsoft Access, SSIS Business Intelligence/Reporting tools: Tableau, MS Excel (Pivot Tables, VBA, VLOOKUP), Power BI, SSRS, SSAS Other: Word, PowerPoint, Visio

EXPERIENCE

Midland Fortune Supply Chain Management Inc. Boston, MA Data Analyst 06. 2019 - Present

• Constructed SQL queries (self-joins, nested queries, udf) in SQL Server with optimized performance improvement.

• Utilized SQL and Python to analyze logistics data and recommended process improvements, reducing delivery time by 30% with an average on-time delivery rate of 90%.

• Utilized Tableau to created report/dashboard, and performed data analysis on large datasets to solve business issues.

• Collaborate with the business team to dene, automate, and validate the extraction of new metrics from various data sources for use in future analysis and reports.

• Automated data update process to avoid manual updates to the customer database, ensuring the accuracy of customer information records and reduce delivery error rates.

• Responsible for forecasting demand, managing inventory, and planning the replenishment cycles on a monthly basis to prevent product excess or shortfall/stock out situation.

• Develop communication and training plans and conduct formal training sessions to stakeholders for system upgrades, changes, and new functions as necessary.

PROJECTS

Viacom Inc. Boston, MA

Data Analyst 01. 2019 - 04. 2019

• Cleaned and prepared a demographic dataset with more than 20 million records by using in R.

• Developed a regression tree model to predict how much Facebook will charge from Viacom based on a certain time, certain website and certain demography.

• Generated report and presented result to project sponsor that their advertising efficiency could increase by 50%.

• Delivered actionable insights to drive marketing analytics and ad campaigns. Northeastern University Boston, MA

SQL Developer 09. 2018 - 12. 2018

• Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.

• Followed 2NF/3NF standards to create database for OLTP databases.

• Multiple views were created to reduce the complexity of writing procedures and increase database performance.

• Responsible for transforming data from OLTP to OLAP data sources using SSIS. Northeastern University Boston, MA

Data Analyst 09. 2018 - 12. 2018

• Preprocess over 50,000 rows of data in Python to eliminate duplicates, missing, outliers, etc. Performed the hypothesis test in Python proved the correlation between the variables.

• Created geographic heatmap in Python for data visualization by using gmaps and heatmap functions.

Contact this candidate