Data Python

Peiqi Yang

**** ********** **** **, ********, GA 30071

Telephone 786-***-**** Email: adhnwy@r.postjobfree.com

Career Summary Experienced data professional with 6 years of solid data mining and analytical skills. Proficient in translating customer insights into business goals, leveraging both qualitative and quantitative data to improve customer experience.

Skills Database: BigQuery, MySQL, MS SQL, Access

Data Manipulation: Excel, R, Python

Data Visualization: Excel, Tableau

Digital Analytics: Adobe analytics, OpinionLab, Foresee, Clicktale, Qualtrics Experience

Jun 2018–Present Senior Analyst – Supply Chain

2 years The Home Depot Atlanta, GA

Write SQL queries to pull store inventory KPIs from BigQuery to track supply chain metrics

Automate Excel dashboards and reports using Tableau (with SQL queries)

Write Python scripts to clean up data formats, consolidate data from different data sources

Run daily/weekly inventory reports for 9000+ SKUs in 4 RDCs using JDE and Excel macro, provide support on running ad hoc reports and troubleshooting reports

Build purchase model in Excel that accounts demand forecast, safety stock, and lead time to help buyers decide when to replenish inventory in RDCs

Jul 2014–Jun 2018 Analyst – Online Customer Insights 4 years homedepot.com, The Home Depot Atlanta, GA

Pull online customer data from different data sources (Adobe analytics, Foresee, Qualtrics)

Provide ad hoc/deep dive data analysis on user experience issues, and utilize different tools

(MS SQL, Tableau, Excel, Python) to manipulate and visualize data

Research customer behaviors and insights based on both qualitative and quantitative channel inputs, come up with A/B test hypotheses and help evaluating test results

Gather business requests from other teams, understand their goals, and develop the best solutions to support their projects using feedback and recording tools May 2013–Dec 2013 Senior Design Project Team Leader 8 months project Gwinnett County Board of Registration and Elections Lawrenceville, GA

Summarize and validate the pros and cons of the queuing system using statistical analysis, stochastic processes and data mining

Lead the architecture and algorithm development on Python platform for the voting process

Optimize the system by bringing an annual saving of $36,000 and 58% less wait time for voters Education

Aug 2011–Dec 2013 Georgia Institute of Technology Atlanta, GA Bachelor of Science in Industrial Engineering

Aug 2008– Jul 2011 Miami Dade College Miami, FL

Associate Degree

Contact this candidate