Data Analyst, Sa

YUE YAN (CONNY) NG

Santa Clara - 279-***-**** - **********@*****.*** - http://www.linkedin.com/in/connyng

I am a trilingual MBA candidate with 2 and more years of operations and supply chain experience. Perform data structuring and data mining, responsible for monitor the data accuracy. And strong data analyst skill with Excel, SQL, Python and SAP. Seeking to utilize a deep understanding of business distribution needs and analysis within a business operations role.

Technical Skills

Proficiency in MS Office Suite: Word / Excel (Macros, Pivot Table, lookup, VBA)/ PowerPoint/ Access/ Outlook Knowledge: Supply Chain Management/ Six Sigma/ 6S/ Inventory Management/ Logistics Management/ Vendor Management/ Problem Solving/ Communication Skill/ Project Management/ GMP/ GSP Software: SAP/ Database Management Systems/ SQL/ Python/ Tableau/ Salesforce/ SPSS statistics/ Photoshop

Education

William Jessup University, San Jose, CA Aug 2019 – May 2022 Master of Business Administration

Hang Seng University of Hong Kong Sep 2017 – May 2019 Bachelor of Science (Hon) majoring in Supply Chain Management Degree Hong Kong Community College Sep 2015 – May 2017

Associate in Business (Human Resources Management) Work Experiences

William Jessup University Oct 2020- Present

Salesforce Data Technician

• Assist with the registry department to develop and map data, while managing and completing configurations.

• Perform data structuring and data mining, responsible for monitor the data accuracy.

• Demonstrate Strong Salesforce design, implementation and configuration knowledge in the Lighting module.

• Configure standard objects and modules including validation rules, formulas, record types, and page layouts.

• Leverage analytical and problem-solving skills in a fast-paced environment. Guangzhou Pharmaceuticals Corporation June 2018 - July 2018 Quality Management Intern

• Identified, organized & entered supplier and part trade compliance data into database management system.

• Collaborated with quality management and logistics department to demonstrate administrative support.

• Utilized database management system, performed data analysis on product defects, and data mining.

• Conducted high level business analysis involving complex business requirements and processes. And to ensure compliance with GMP and GSP regulatory requirements.

• Involved in project management activities include organization, resource allocation, task assignment and issue resolution.

• Recommend the improvement on the database management system. GN Logistics June 2017 – June 2018

Supply Chain Specialist

• Prepared and provided progress & analytic reports to Senior Management regarding open cases.

• Used Tableau to present the logistics performance to the project manager, included the operation efficiency and the cost.

• Performed planning and scheduling functions involved with coordinating products and materials through various production phases.

• Compiled and analyzed inventory and customers data by the SQL in order to estimate the customer behavior.

• Strictly controlled the inventory discrepancy, while performing the cycle-counting.

• Perform various SAP transactions to support the kitting effort and other supporting logistics activities.

• Oversaw a group of 10 people to manage the warehouse operations, performing leadership management. Joint Publishing June 2016 – Dec 2016

Warehouse Operations Assistant

• Utilized Excel’s function, like Macros, Pivot Table and VLOOKUP to analyses the sales and cost weekly.

• Reviewed schedules to determine materials requirements to ensure products are available according to schedules.

• Supported warehouse operations and corporate communications across the organization.

• Monitored the inventory flow with the warehouse by SAP SCM module.

• Maintained good relationship with the vendors, manufacturers and with the air freight import carriers.

• Used SAP to create purchase order, and demand forecasting based on the make to order planning strategy.

• Work closely with others in the assigned area to recognize opportunities for improvement and drive change through the use of Quality Systems. Monitored and measured the process performance. A-1 Bakery Co., (HK) Limited Aug 2015 – Jan 2016

Part-time Bakery Shop Assistant

• Provided customer service and maintained shop organization and cleanness.

• Built and maintained effective relationships with peers and management.

• Work well with the team to ensure that shifts run smoothly. Project

A Study of Green Supply Chain Management and Information Technology on economic performance under the effect of legitimization – Team Lead Feb 2018 – Oct 2018

• Used SPSS Statistics to analyze the raw data which collected from a Taiwan company

• Conducted data screening; Assigned Null Hypothesis of mediators

• Presented the Statistics results with Tableau dashboards. Language

Cantonese (Native), English (Fluent), Mandarin (Fluent)

(Putonghua Shuiping Ceshi, Level 3A, Issued Date: 05/03/2019)

Contact this candidate