. Integrating enterprise data from 2 NetSuite ERP system to Adaptive Insight system, using API connecter, Pentaho, and JavaScript based CCDS ( Customized Cloud Data Source . . Processing and cleaning customer's financial data from Intacct, SalesForce, NetSuite and Oracle, utilizing complex SQL queries and table joins. . Integrating financial and sales data from 2 Intacct system to Adaptive Insight system. . Investigating integration failures with 3 NetSuite project and restoring the full connection. . Managing time usage and status updates for 15+ integration projects, using SmartSheet and Projector. . Designing and implementing sales planning model, including sales reps, capacity, top-down cost and commission calculations. . Developing visualization reports and analytical reports for 4 demand planning projects.

. Collected and processed sales and inventory data for 20 vendor routes and 200 Walgreen stores . Collaborated data from ERP and EDI to perform cross validation and analysis with Spreadsheet and Tableau . Analyzed data from 3 ERP platforms to create Tableau and Python reports to support daily operations, including ordering, production and shipping . Forecasted demands and trends to determine weekly shipment and production for over 200 Walgreen stores . Visualized and exanimated historical data from Miami headquarter to validate the similarity of markets behaviors to build statistic model for DFW area. . Programed 2 tailor-made python applications for data querying and for demand forecasting

. Developed vendor evaluation process by creating the Python routine program to monitor on-time delivery rate and chemical composition report for 14 suppliers . Forecasted demand for MRP purchase orders by implementing 12 machine learning models, including Logistic Regression, Support Vector Machines, Naive Bays and Random Forest Classifier . Maintained inventory accuracy by amending logical errors in the ERP system . Coordinated with 2 suppliers for POs and with brokers for incoming containers

. Secured 2% decrease on raw material by negotiating longer term contracts with India and China suppliers, reducing annual procurement budget by 28, 000 USD. . Improved cross-color contamination of finished yarns to under 0.16% by tracing defective material lots back to production line and reporting defect report to the Department of Demand Planning. . Maintained 97% customer'satisfaction rate through investigation and correction of defective lots

. Tutored over 10 students in preparation for English tests such as the GSAT and IELTS, resulting in a 2-3 ( out of 15 ) rank improvement for GSAT, and 1.5 to 2 rank improvement on the IELTS.