System Analyst Help Desk

Li Zhang

Phone: 615-***-**** Email: ******@*****.***

Address: **** ***** ***** **, ********, TX 77584 Legal Status: U.S. Citizen

OBJECTIVE

Challenging analyst/developer position requiring strong application and database design, programming, analytical thinking, problem solving skills and project managing

PROFESSIONAL SUMMARY

8+ years working experience in Software Development Life Cycle (SDLC) including analysis, design, implementation, testing, deployment, maintenance and end user support in a Fortune Global 500 manufacturing company

Proficient in C#, C++, SQL Server database design and integration, complex queries in large data sets, stored procedures

Lead and participate in internal and cross functional teams on various projects

Self-motivated, adaptable, strong quick leaning and troubleshooting skill

Expertise in creating SSRS, Ad-hoc and automated reports

Experienced with weekly internal BRD meeting on project prioritization and data source and requirement collection

TECHNICAL SKILLS

●Languages: C#, C++, C, SSRS, .Net Framework, Python

●Database: SQL Server 2000/2008/2012

●Software: Visual Studio 2005-2019, SQL Server Management Studio, Visio

WORK EXPERIENCE

System Analyst III Quanta Computer - La Vergne, TN 03/2021 – 05/2022

Led and supported Physics Inventory (PI) solutions for multiple clients, including design, configuration, and integration with SAP and other applications. It helps Quanta prevent inventory discrepancies and identify potential issues such as theft, damage, or spoilage.

Designed and developed a customer high quality Swap List Reporting for the CEO, responsible for designing database schema, algorithm logic and report format in SSRS. The reporting system provided a suggestion on a daily base for in server swap process. It greatly speeded up the repair and testing process for Amazon and Facebook products, and ensured the products to be shipped out within tight deadlines. CEO was extremely satisfied with the quality and efficiency of the project delivery. Here is the original email from CEO: “I am so lucky to have you as part of the team. You have been absolutely superb all week, and I am so grateful. I can honestly tell you that many of the things we accomplished this week would not have been possible without you.”

System Analyst II Quanta Computer - La Vergne, TN 02/2016 – 03/2021

Led the design, development and deployment of Defect Material Return (DMR) Management System. The program classifies the defect materials, manages inventory in FIFO method, transfers materials from plant to plant and reduces the amount of 2nd failure part for quality control. This Windows application with 50 UI pages was developed in C#, .Net Framework and SQL Server database. It was used by 200 plus users from teams across the company including Operation team, Ware House, Quality, Engineering and Management team. The utilization of DMR system in inventory management and quality control improved the efficiency of defecting part process, increased the accuracy of identifying part failure and saved estimated $1.5M annually for the company.

Responsible for data integration of Training DB project, converted and integrated data from the MS Access to SQL Server database, built Reporting Services RDL reports into application to provide employee training records for different departments. The interactive UI pages allowed supervisors, Quality team and HR department to effectively create employee profiles and training documents, enter training logs, export data and upload documents.

System Analyst I Quanta Computer - La Vergne, TN 10/2013 – 02/2016

Created a customized Rework process system using C# and SQL server. It allows users to test different scenarios of the physical rework process including Receiving, QC, Testing, Box Labeling, Packing and Shipping. It also provided automated daily Rework SLA reporting to make it easier for managers to track the rework process.

Developed customized Metrics reports in SSRS and MS SQL Server. The report monitors the daily output of each station in the service lines, including Receiving, Disassembly, Reassembly, QC, packing, and shipping. It provided senior managers with real-time insights into the repair process and helped them identify process gaps and potential issues, leading to improved efficiency and reduced downtime.

Supported a Help Desk Web application using JavaScript and VB.Net to let user upload and manage images of issued products. After the utilization of the application, the production time was saved by over 20%.

Physics Teacher Harbin No 3 High School, Harbin, China 07/2002 – 07/2006

EDUCATION

●Master of Science in Computer Science 08/2008 – 05/2011

Middle Tennessee State University, Murfreesboro, TN

●Bachelor in Electrical and Electronics Engineering 09/1998 – 07/2002

Northeast Normal University, Changchun, China

Contact this candidate