Supply Chain Management

Jia Guo

Email: ********@*****.*** Phone: 650-***-**** Location: Palo Alto, CA

PROFESSIONAL SUMMARY

A professional supply chain specialist with 2 years’ real-world experience in sourcing, project management, and data analysis. M.S. and B.A. degrees in Supply Chain Management. Trackable record of being an innovative and active team contributor. Passionate in applying data analysis and visualization technologies in solving real-life business problems. WORK EXPERIENCE

State Grid Corporation of China, Beijing

Sourcing Project Manager and Data Analyst July 2014 – April 2016

• Executed 12 electric equipment sourcing projects, with responsibilities including reviewing demand plans, defining purchasing batches, analyzing sourcing strategy, organizing bidding and purchasing conferences, overseeing project schedules, and preparing and maintaining legal documentations.

• Created Excel templates to facilitate classifying demand plans, defining purchasing batch, and generating supporting documents for bidding and purchasing conferences.

• Crafted an Excel dashboard with scatter charts and linear regression models for the relationships between batch sizes and percentage saving of 14 types of electric equipment.

• Collected, analyzed, and reported department's monthly sourcing data, interacting with ERP system.

• Coordinated a team of six in redesigning department’s data management processes and composing data management manual.

• Built a Microsoft Access application to automate table joining and data grouping, reduced data processing time by 25 folds.

• Implemented the changes in department’s data management in 3 months, boosted data reporting accuracy by 23%.

• Designed peer evaluation and work load tracking tools using Excel VBA to streamline department’s performance appraisal. World Trade Centers Association, New York City

Asian Pacific Strategy Analyst (Intern) August 2013 – April 2014

• Led a team of three analysts to develop and implement economic and expansion strategy research in the Asian Pacific region.

• Identified 73 target cities for expanding WTC network, composed comprehensive report to facilitate management decision.

• Built a web information system containing detailed data of top real estate developing companies in the researched areas with Oracle Application Express.

• Facilitate communication between Asian branches and the headquarter in New York. Adfaith Management Consulting Inc., Beijing

Industry Analyst (Intern) June 2010 – August 2010

• Collected the latest data on the management consulting industry by telephone interviewing 1,700 board of director secretaries from listed Chinese companies.

• Built up an effective project team and met scheduled deadline. Finished three rounds of interviews in six weeks.

• Delivered 100% improvement in the response rate of the survey. Achieved a rate of 32%, more than double the rate of the previous team.

• Generated a systematic way of making effective telephone interviews. Invited by the division head to share the experience with other research teams.

• Sorted and analyzed the data generated from interview and secondary sources. Prepared an in-depth analytic report. EDUCATION

New York University, New York September 2012 – May 2014 M.S. in Management and System

• GPA: 3.9

• Honor: Distinction award

Cranfield University, Bedford, UK September 2011 – August 2012 M.S. in Logistics and Supply Chain Management

• Grade: top 5% percentile

• Honor: Best Performance Prize of 2012, Chartered Institute of Purchasing and Supply Prize 2012 Chinese University of Hong Kong, HK September 2016 – December 2010 B.A. in Supply Chain Management

• Honor: Siu Che Kit Scholarship, 2010

SKILLS

• Data analysis: Microsoft Excel, Microsoft Access, SQL (Oracle Database SQL Certified Expert)

• Web technology: JavaScript, CSS, HTML, Node.js, Express, MongoDB, Git

Contact this candidate