 Extracted data from SQL databases using Python and pyodbc for the employee utilization project. Manipulated and cleaned time spent data to convert it into work time, core time, and meeting time data. Predicted clients' employee work time and utilization by working on complex time series data. Conducted extensive modeling with Facebook Prophet, RNN, LSTM, and other time series forecasting models. Assisted managers in identifying trends among low-performance employees and developing improvement plans. Assisted in a remote detection project using CatBoost and Scikit-Learn in Python to identify employee network data based on a five-round labeling detection process, enhancing data accuracy by 98% for clients. Established hourly and daily data models from databases using SQL and ETL processes to extract employee data for reporting and dashboards. Validated results for data integrity using SQL. Assisted supervisors in presenting machine learning insights for the utilization forecasting project on Power BI and Sisense, enhancing the decision-making process for teams and departments. Deployed new data visualization features in Sisense, such as Tabber Switcher and Exploration Paths. Automated the formula setup process across different development environments (Dev/QA/Demo/Prod) and data models in Sisense by using Python API requests to eliminate repetitive tasks. Developed an automatic process using Python WebDriver to control Chrome for the customer success team, generating weekly time breakdown report emails to enhance the client user experience.

Built 6 dashboards in tableau for client to overview how each factors affect turnoverEstablished survival model, Cox proportional hazards model, logistics model and linear model in RCreate a shiny app in R for client future analysis related to turnover

Extracted JavaScript data in PowerBI and data cleaning, data transformation, and data analysis in RAnalyzed what attributes affect products through using text mining sentiment analysis and multi target regression in RPredicted successful products pattern through using Tableau and decision tree in Knime

Built quadratic model and linear-log model in Tableau and R and analyzed which models can maximize revenue betterMaximized revenue and set price based on the two quadratic models through Excel solverAnalyzed business insights through Tableau to find the best dealers and the best incentives that Lennox can leverage to increase revenue

Communicated with a local start-up client to identify future requirements for new markets and key stakeholders to pinpoint system development strategyCleansed, manipulated, and analyzed data provided by client in Alteryx, R, and Excel to extract business insightsBuilt dashboard for the client through using Tableau illustrating geospatial, customer, sales, and operation insights

Established linear regression of patient symptoms and principal components regression models in R, determining which patients are likely to have heart attackCleaned data in R and Python for building model and business insights that what main factors influenced heart attack

Designed R and Excel macro formulas that can automatically transfer historical manual calculationsSimplified Overall Equipment Effectiveness formula from five factors to two factors to make calculation effective

Developed a new automated formula to avoid errors that could have been generated by manual inputs Added over 3,000 goods from warehouse database, enabling over 100 goods sales per month through eCommerce

Created a comprehensive import file with over 5,000 data points through using SAS to build ecommerce websitesTransformed off-line store to on-line ecommerce through HTML, expanding clients’ marketing share nationwideEnhanced security for seven websites and database and designed ecommerce websites through using J2 and Joomla

• Provided advice to 70 international students, and counseled them with any problems to help them adapt in US and its culture as soon as possible.• Engaged students through events on campus and planned events related to volunteer activity and campus culture to help them adapt campus culture.• Been an Ambassador to students to give them advice about their academic and professional success such as choosing courses, using resources from NCSU, and so on.• Gave suggestion about academic success after they passed Language program

Led different multiple of workshops for 19 international students to encourage them to adapt this new environment.Assisted other events, and provided ideas

Assisted employees in documentation distribution to encourage timely deliveryAssisted staff in inspecting the seals from custom companies that wanted to sale or buy foreign currency, effectively preventing fraudulent transactionsIndependently completed credit card applications for 30 customers in a timely and efficient manner which effectively demonstrated attention detail and independent responsibility

• Completed independently credit card applications for 30 customers in a timely and efficient manner, which effectively demonstrated attention detail and independent responsibility.

Responsible for connecting international NCSU students to Raleigh non-profits.Scheduled 22 students for monthly volunteer activities for the 2013-2014 year.Promoted community service events and organized information sessions.Organized and led 4 teams of volunteers to Bug Fest at the Natural Science Museum.

Cooperated with president in running weekly council meetings.Acted as on-duty Resident Adviser for U.P.P students.Planned and attended all events to engage U.P.P. students with American culture.