Xiangyu Li
214-***-****; ac8sgb@r.postjobfree.com
BUSINESS EXPERIENCE
Goldwind USA, Inc. Chicago, IL
Data Analyst Mar 2017 – Present
Administrating, maintaining and customizing SharePoint sites and software solution
• Administration/Configuration of SharePoint sites and Web applications
• Creation of custom Web Parts pages, content types, and web templates
• Creating and customizing SharePoint designer workflows
• Solicit feedback, evaluates and monitors client or customer satisfaction to improve the quality of services Developing Ticketing System
• Created Information, Physical and Logical architect plan, budgetary estimates and workflow diagrams
• Developed system interface utilizing HTML, CSS and XML
• Developed custom web application, master pages, site templates, workflows using JavaScript and jQuery
• Developed automation for multiple applications on SharePoint using SharePoint designer workflow and Microsoft Flow
• Developed mobile version Ticketing System based on PowerApps
• Monitored user permission assignments and provided guidance and training for users in company
• Resolved technical problems and continuously improving system interface and performance Principle VBA developer and database management
• Communicated with staffs to analyze key requirements for application design
• Designed and built multiple solutions combining Excel, Access, and SharePoint for seamless communication within the business environment
• Assisted to maintain SCADA database, performed database backups, created and executed SQL Scripts for business needs of organization
Futurewei Technologies, Inc. Dallas, TX
System Data Analyst Jul 2016 – Dec 2016
• Generated sales volume summary report, customized pivot table for manager to review and analysis by using Excel VBA and Access
• Created dashboards and visualizations for risk assessments and risk analysis Goldwind Science & Technology Co., Ltd. Beijing, China Full-time trainee May 2015 – Sep 2015
• Used SAS to process wind turbine operation data and wind resource data
• Concluded the results that made contribution to long-term stable operation of wind turbines EDUCATION
The University of Texas at Dallas Dec 2016
M.S., Information System and management
Beijing University of Technology Jun 2014
B.S., Communication Engineering
CERTIFICATIONS & TECHNICAL SKILLS
Certifications: SAS certified Advanced programmer
Software: SharePoint, SharePoint Designer, Microsoft Flow, Microsoft Excel, Microsoft Access, Microsoft Visio, MS SQL Server, SAS, SAP, Tableau
Programming: HTML, CSS, JavaScript, jQuery, VBA