Skilled in SQL, EXCEL(eg formula, pivot table);Presented automatic regular reports through Oracle Business Intelligence(OBI) way;Extensive knowledge about products related analysing, produced product related regular weekly and monthly reports;Responsible for analysing different products' customer profile, from different customer dimensions.Responsible for monitoring new products' performance after launching and related risk data check;Responsible for assisting in the analysis of current processes and recommended solutions(marketing research and product)；Able to meet deadlines while also presenting accurate work

• Responsible for analyzing large data sets using MS Excel, Access to find out the cost of products. Results are used to save the cost of whole IFE product’s line, working closely with Product Cost Manager• Updated and maintain product's part price and description in the database and keep record of new part numbers associated with engineering product components • Captured data from database • Used advanced MS Excel formula techniques (IF statements, VLookup, etc.) to create a spreadsheet • Created and modified SQL statements in MS Access to manage large data sets • Assisted in developing workarounds by working with various internal groups• Coordinated Product Management department with Material Management department for pricing project

DATA MANAGEMENT • Worked extensively with Microsoft Excel on price study project, using formulas and pivot table • Provided forecasting and financial analysis support to all sales channels • Provided logistics support for the inventory control by maintaining and modifying the products and financial database• Managed the bi-weekly financial and products data consolidation providing timely and accurate financial standing analysis to management.CUSTOMER SERVICE • Provided comprehensive technical support for products• Processed product recommendations, discussed product performance and confirmed availability• Followed up with customers on product inquiries as well as sample and quotation requests ADMINISTRATION / ORGANIZATION / REPORTING • Prepared and processed sample requests and generated quotations• Managed sample inventory• Generated quarterly sale commission reports, working in close cooperation with Accounts Department • Assisted in preparation of annual budgets, forecasts, and variance analysis

• Scored assignments, midterm, and final • Prepared and collected 89 Harvard Case study materials for Marketing Management discussion

• Analyzed key financial statements to provide financial performance indicators to sale manager• Identified and reported schedule performance variances related to labor and overhead expense• Analyzed current and expected future market conditions internationally for retail industry, especially super market