Data Sql Server

HUIYUN WU

**** ** ****** **** **., Bentonville AR 72712 651-***-**** acsz8l@r.postjobfree.com www.linkedin.com/in/huiyun

PROFESSIONAL SUMMARY:

IT professional with over ten years of industry experience in systems development life cycle (SDLC) in an agile/Scum environment, practices e.g. stand up daily morning meeting, lunch and learn. Built static and dynamic web-based applications from concept to publication. For example, Lab Data Testing system – users scan inventory data samples, split pieces, tracking tests status, tracking lab samples testing results, accounting information, retailer data, and creating Business Intelligence reports, etc. Like Pursues Order system –load, filter Walmart Pursues Order Big-data to find required test samples import into test system for further processing.

Increased efficiency by adding functionalities and interfaces, which allow users in the same system to search records from across different systems, data sources, included the equipment tool testing data source, load, validate and save data into Lab Data Testing system. Extremely speed up lab users processing samples.

Finished price charges lookup dialog’s interface and database tasks, which allowed users to create, save charges groups for same type tests, so users could easily load them next time, make changes and commit multiple records at once.

Worked on cross-systems cleansing emails project from interface to backend coding, which allowed support team users to apply automated configuration updates for all of the users, clients and suppliers in different systems and different databases – including MySQL, MSSQL, and Maria DB.

Created, verified and delivered monthly accounting, testing statistic numbers reports for one VP for many years by ad hoc queries and later developed into Business Intelligence report using crystal report.

Performed Critical Legal Search to find testing evident for Walmart to avoid lawsuits (in 24 hours).

Maintained and developed new features for CTL websites, which supports Walmart, suppliers, buyers, factories users checking the status of products being testing and internal associates to search and work with data.

Created employees’ relationship phone chart using Tree Diagram D3.js. It displayed employees’ name, phone, and email and very easily find each of supervisors’ team members.

Experienced in graphic programming, interactive graphics, data visualization, and data analysis using Zing-Chart JavaScript Lib. (Bar, Pie, line, spline Area, word cloud, and animation chats, etc.)

TECHNICAL SKILLS:

HTML

JavaScript

EXTJS

D3.js

jQuery

Node.js

Bootstrap

CSS

Linux

SOAP

AJAX

PHP

SQL Server

My SQL

MongoDB

XML

Crystal Report

Zend Framework 2

Versions Control

REST / JSON

EDUCATION:

Master Degree in Software Systems, University of Saint Thomas, Minnesota USA, Sep 2003 – May 2005

PROFESSIONAL EXPERIENCE:

Sr. Systems Analyst (Developer) in Consumer Testing Laboratories, Inc., Bentonville AR, Sep 2005 – Oct 2015

RESPONSIBILITIES:

Built production Lab Testing system and Pursues Order (BIG DATA) system from scratch-to-end. Responsive to analysis requirements, design, write codes, debug, test and commit codes using JavaScript, PHP, HTML, CSS, MVC, Bootstrap, jQuery, JSON & ZF 2, also, browsers extensions and plugin tools. Upload, Drg & Drop files used Java, J2EE. MSSQL databases tasks: create tables, views, functions and stored procedures, add keys, rules. Additional experience creating and modifying reports using crystal reports. Also, maintained the systems, added new features, provided solutions for technical issues, customer services, problem-solving, etc.

Maintained and developed CTL websites to support Walmart, customers and internal associates to search, work with our data and print reports. Experienced in PHP, JavaScript coding, debugging, MSSQL databases changes and everything in My SQL, like creating users, databases, tables, views, triggers, stored procedures and adding roles, granting permissions, etc. Experienced using Adobe edit version to create and modify reports. Used codes to control page, fields properties and events. Wrote CURL Script to check website, security and database connections.

Expertise in Dependency Injection, MVC, JavaScript, EXTJS, LAMP, Zend, PhpStorm, SVN, VMware, SSDT, SQL Server, MySQL Workbench, Heidi SQL, Fiddler2, PUTTY, CVS, Git, VNC Viewer 4, SSAS, SSIS, SSRS, CDN

ENVIRONMENT:

JavaScript, D3.js, Node.js, JQuery, Bootstrap, MVC, REST/JSON, AJAX, PHP, Zend Server, Z-Ray, Zend Studio, HTML, CSS, SOAP/XML, Crystal Reports, Alpha. ERP, SQL Server 2008-2012, My SQL, Maria DB, Apache, VM, core Java, QLIKVIEW 11.

Contact this candidate