Shuting Wang Email & Phone Number

Washington, DC, US

Washington, District Of Columbia, United States

Using NLP and text mining method to extract information from government economic documents.

Manhattan, New York, United States

Washington, District Of Columbia, United States

• Web-scraped over 35,000 LinkedIn employment records of alumni using Selenium in Python.
• Developed an R-based salary forecasting model (Random Forest) to predict graduate salary levels with 89% accuracy.
• Analyzed over 5000+ employment data points to identify the most frequently appearing cities, companies, and positions, customizing newsletters to align with student interests, resulting in a 117% increase in the weekly.
• Connected the Salesforce database with… Show more
• Connected the Salesforce database with Power BI, created dashboards to track the data collection performance of student groups with different demographics, enabling targeted survey distribution that increased response.
• Constructed an automated workflow for ETL (data extraction, transformation, and loading) using the Google API and Python, streamlining the process of summarizing survey results from a week-long endeavor to just one.

Shanghai, China

• Analyzed and visualized over 1.2 million data points using SQL and Qlik to track operating metrics and detect anomalies.
• Segmented 6,000+ vendors into 3 tiers based on supplier performance, analyzing and visualizing 180,000+ purchasing order records using SAP Analytics, Excel PivotTables, and VLOOKUP, achieving effective supplier.
• Developed a Python-based supplier mapping algorithm using Pandas and NumPy, resolving inconsistencies in supplier names across multiple… Show more
• Developed a Python-based supplier mapping algorithm using Pandas and NumPy, resolving inconsistencies in supplier names across multiple databases, which increased the accuracy of cost expenditure calculations by 13%.
• Designed dynamic Tableau dashboards linked to an online Excel file, featuring bar and donut charts to showcase key data (spending, cost avoidance, etc.), and reported to business managers and stakeholders to track.
• Prepared deliverables (presentation decks, business reports and data analysis & visualization) for market exploration and product improvement strategies by researching, collaborating with team members and communicating.

Master'S Degree, Data Science And Analytics, 4.0/4.0

Bachelor'S Degree, Economics, 3.52/4.0