Sql Server Software Engineer

Ming Yu

Location: Plano, TX

Cell: 469-***-****

Email: **********@*****.***

A skilled SQL Server and application developer with nearly 16 years combined experience in SQL Server administration, data warehouse design and implementation, DTS / SSIS / SSRS package development, Oracle and MySQL stored package design and development, as well as application design, development and maintenance.

Technical Experience Summary:

11 years’ overall SQL DBA/Development experience on 30 SQL servers 2000 – 2012 and 50 databases

11 years’ experience with ETL / SSIS packages – has developed and automated packages for database maintenance as well as batch file processing

Completed design of 20 Data Warehouse databases

11 years’ experience with data modeling for both in-house and client data

Responsible for T-SQL stored procedures, view and trigger, update scripts, SSIS packages development, debugging, test and deployment

Used SSRS to develop monthly billing reports, usage reports

Migrated SQL Server 2000 to SQL Server 2008, and 2008 to 2012.

Education & Certification

Sep 2016 – Now Working on Microsoft Certified Solutions Expert Certification

MCSE Data Platform.

Jan 1996 – Dec 1997 The University of Texas at El Paso, M.S. in Statistics, Specialized in

Computer Sciences.

Sep 1982 – Jul 1986 Zhejiang University, Hangzhou, China, B.S. in Computer and

Mathematical Sciences.

Professional Experience

Consultant Sep 2016 – Now

Designed and developed a restaurant ordering system that allows client to store, retrieve and update customer and ordering info in SQL database.

Designed and developed a desktop parent control program.

Confi-Chek, Inc., Sacramento, CA Jan 2016 – Aug 2016

Senior Software Engineer, ETL/SSIS, Excel Reporting Services

Developed, maintained and upgraded, using MS Visual Studio 2013 C#, an automatic file processing system (ETL and information appending). The system includes ftp/ftps/sftp server (local and remote) download/upload, email account monitoring for specific files, batch-processing server, MS Exchange Web access API message and open source pdf report automation. It automatically loads multiple format files into MS SQL Server and MySQL Database (ETL) through DTS/SSIS package, stored package and other utilities.

Developed reporting services that reads configuration and reporting data from SQL server, populates dynamic data and formula using open source ClosedXML Excel API.

Automated file compression and encryption with Ionic Zip API and GnuPG gpg software.

Automated pdf report generation with PdfSharp API.

Automated messaging and email monitoring through MS Exchange Web access API.

Version control with development team using Git.

MasterFiles, Inc., Dallas, TX May 2005 – Nov 2015

SQL Server Administrator; SQL Server Developer; Software Engineer

Designed, implemented, administrated and maintained SQL Server 2000/2008/2012 transactional database and analytical data warehouse using dimensional modeling techniques, Star and Snowflakes schema at the enterprise data center as well as in the private cloud environment. Designed and developed replication, stored procedure, ETL/SSIS packages for instant and scheduled database update. Other duties included but not limited to database backup, restore and disaster recovery plan design and test; daily/weekly/monthly update; user management.

Developed business logic layer/encryption MS SQL server stored procedures to be accessed by middle ware as well as IIS. SQL Server database maintenance using MS SQL Server 2000/2008/2012, T–SQL, Enterprise Manager, ISQL/w. Developed DTS and SSIS packages for ETL and batch processing.

Upgraded / migrated existing DTS packages to SSIS package.

Designed and developed reports for management and customer using SSRS, Word and pdf.

Developed business logic layer Oracle server stored packages to be consumed by middle ware and IIS. The packages accept multiple queries in parameter array, iterate through the queries till a hit is generated, this saves lots of database connection round trips.

Designed, developed, maintained and upgraded, using MS Visual C++/C# 6.0/2008/2010/2012, .NET, SQL Server 2000/2008/2012 stored procedures, Oracle OO4O and stored packages, Web services, Web API, a TCP/IP search engine (windows application and service) that accesses in-house SQL Database, Oracle database for national telephone, real property, credit header data, USPS national address cleaning and standardization database as well as outside vendor cell phone, bankruptcy, caller ID, and credit report data. Designed and implemented a high efficient call protocol that server and client communicates.

Designed and developed many utility, monitoring to archive IIS, ftp server data and log files, monitor system resource, check data integrity, measure database update progress using C/C++/C#, .NET, ASP.NET, Oracle OO4O library, Oracle Stored Package.

Developed, maintained and upgraded MasterFiles search web sites and web service on IIS 6.0/7.0/7.5 (C++, MFC, ISAPI, HTML, CSS, JavaScript, ASP.Net) that allows registered users searching telephone (wire and wireless, NP/Non-Listed), real property, credit header, bankruptcy, caller ID data and address standardization.

Used software design patterns in all major projects.

Used team development, collaboration version control systems BitBucket and TortoiseSVC.

Experienced agile software development system like Kentico and Scrum.

MasterFiles, Inc., Dallas, TX Jan 1998 – Apr 2005

Lead Programmer

Designed, developed, maintained and upgraded, using MS Visual C++/C# 6.0, an automatic file processing system. The system includes ftp/sftp server (local and remote), email account monitoring for specific files, batch-processing server, batch processing client, Outlook message and MS Word report automation. It automatically loads multiple format files into MS SQL Server and Oracle Database (ETL) through DTS/SSIS package, Oracle stored package and other utilities.

Designed, developed, maintained and upgraded a batch WinForm application that fetches data from middle ware through TCP/IP connection and appends telephone, real property, credit header, national new home-owner and new-mover data to customer files. Developed a scoring system that measures the matching confidence in terms of last name, first name, street number, street name, city, state and zip code.

CISCO ASDA 5510 management through ASDM-IMD. Create access list / rules, IPsec VPN and SSL VPN. Network and system administration for a network of about 70 servers and 12 workstations.

Data communication programming with dial-up connection and leased line using modem and DSU through X.25 net under Eicon WAN services and Windows RAS. The communication libraries used are WSC4C from Marshallsoft and X.PAD from Eicon.

Server database backup using Seagate Exec Enterprise Version 7.0 and Open File Manager 5.1 from St. Bernard with Adic VLS 400.

System installation and configuration. Windows 95/98, Windows NT 4.0/2000 (workstation and Server), tape drive, Network adapter, SCSI controller, soundcard, modem and printer troubleshooting.

The University of Texas at El Paso, El Paso, TX Jan 96 - Dec 97

Teaching Assistant - BioStatistical Laboratory (NIH Funded),

Served as assistant statistical consultant. Provided service to El Paso region. SAS, SPLUS, FORTRAN, C/C++, Mathematica programmer.

Participated in “The Incidence of Diabetes Mellitus Among Young People Less Than 20 Years of Age in El Paso, Texas”. Diabetes data analysis.

Clinical trial data analysis and modeling. Longitudinal data, dose effect study.

Beijing Coal Design and Research Company, Beijing, China Aug 86 – Dec 95

Project Manager; Software Engineer

System engineer and chief programmer of “Civil Engineering Budget Package” which automatically makes the budget and can dynamically interface with user to access the database system and adjust the budget during the computer-aided design process. Written in C/C++ using WIN API, Microsoft Foundation Class Library and dBaseIII database under DOS and Windows 3.1 on PCs and workstations.

Chief designer and programmer of the package “Typical Design for Smoke, Wind and Coal Dust Pipe of Thermal Power Station”, users need only input parameters to finish designing and plotting the whole set. Written in GDDM, GDCM, and FORTRAN under VM/CMS on IBM4341 and CALCOM plotters.

Chief designer and programmer of “Standard Design for Narrow Rails of the Ministry of Coal Industry of China”. Written in MEDUSA and C/C++ under UNIX on SUN graphic workstations.

Chief programmer of “Underground Mining Calculating and Drawing Package” which enables users to finish complicated calculations and drawings by dialoging with the package through a very friendly interface. Written in GDCM and C under UNIX on VAX-II dual-screen graphic workstation and transplanted on PCs and other workstations.

Contact this candidate