Data Analyst Sales

Sisi Chen San Francisco Bay Area 303-***-****

*************@*****.*** linkedin.com/in/sisichenamanda SUMMARY

• Fast learner with a data-driven mindset, using Python and SQL to explore data for four years.

• A Master of Business Analytics and an MBA from the University of Denver coupled with practical experience in marketing/business/financial analytics make me a positive asset to any organization. SKILLS

Top skills: SQL, Python (Numpy, Pandas, Scikit-learn), Google Analytics, Tableau, Apache Airflow, More skills: R, Apache Cassandra, Spark, Google Ads, CRM, Excel (Pivot tables, VBA), Salesforce, Bash PROFESSIONAL EXPERIENCE

Udacity, San Jose, CA

SQL Nanodegree Mentor Mar. 2020 – present

• Reviewed the students’ projects, answered their questions about SQL Data Definition, Data Manipulation, and Relational and Non-relational Database. Helped students to design actionable study plans. Navajo Inc., Denver, CO

Business Analyst Dec. 2017 – Dec. 2019

• Prepared Daily / Weekly / Monthly sales analysis reports, using Pymssql to extract data from multiple data sources and utilizing Python-Docx, XlsxWriter, Matplotlib, and Tableau to present results to stakeholders.

• Used Apache Airflow to creating dynamic sales data pipelines. Created custom operators to perform tasks such as staging the data and filling the data warehouse. Ran tests against the datasets to catch any discrepancies after executing the ETL steps.

• Utilized Scikit-learn to apply Machine Learning models in predicting the sales of 3000+ Walmart stores and 200+ products. Collected stores’ trait data and the past 10 years’ sales to improve the model’s accuracy. The results enabled Navajo to manage the inventory efficiently, to explore the possibilities to increase the contribution margin, and to make an advanced business plan for each salespeople.

• Launched marketing analyses to help refine the online business strategy. Created online user segments based on their personalized experience data in Google Analytics. Helped the Marketing team to customize the remarketing campaigns for different user clusters. Meanwhile, planned A/B Tests about whether to launch new layouts on e-commerce websites. Lead on A/B testing design with the UX team. SambaSafety, Denver, CO

Advanced Data Analyst Intern Jun. 2017 – Nov.2017

• Applied models such as Logistic Regression, KNN, SVM, and Decision Tree to forecast a driver’s likelihood to cause an accident. Created a suite of predictive analytics that was integrated with SambaSafety’s current Risk Management Solution product. Presented the new function to the clients such as UPS freight.

• Extracted and normalized over 200 features from MongoDB and selected main features that may affect drivers’ accident risk with pandas and NumPy

• Helped SambaSafety to provide customer and channel-partner reports by conducting exploratory data analysis, data transformation, and data visualization of motor vehicle records data with Tableau. Hundsun Technologies (Alibaba’s payments affiliate), Shanghai, CN Financial Data Analyst Mar. 2011 – Dec. 2012

• Worked with the Hongkong Stock Data team and core business teams, such as Product, Sales, and Engineering to help develop, enhance, and manage the Hongkong Stock product.

• Daily updated and maintained data from various financial sources. Reconciled financial data and accounts, using SQL and Python to ensure the accuracy of the data. EDUCATION

University of Denver, Denver, Colorado Master of Business Analytics Sep.2016 – Nov.2017 University of Denver, Denver, Colorado Master of Business Administration Mar.2014 – Jun.2016 Shanghai University of Finance and Economics, Shanghai, CN Bachelor of Marketing Sep.2006 – Jun.2010

Contact this candidate