Post Job Free

Resume

Sign in

Sales Software Engineer

Location:
West Covina, CA
Posted:
December 17, 2018

Contact this candidate

Resume:

Dong D. Tu, BS, MS

West Covina, CA *****626-***-**** • ac7zr7@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/dong-d-tu-bs-ms-8876a7167/

SQL Development Supervisor

Technically sophisticated with a proven history of effective database design, coding, testing, and support.

AREAS OF EXPERTISE

Broad knowledge and achievement in next-generation database solutions.

Driven and detail-oriented professional with proven success in advancing business operations.

Ability to learn new procedures quickly and obtain new complex information with ease.

Adept at analyzing data to design and develop matching/mapping logic.

Proficient in complex SQL queries, various joins, sub-queries, stored procedures, functions, views, indexes, partition, pivot, cross apply, outer apply, CTE, temp tables, automation, schedule tasks, triggers, backup/backup log, restore/restore log, compress tables, and shrink databases.

Skilled team leader and trainer with a track record of directing direct multiple tasks effectively to ensure on target completion of all deliverables.

TECHNICAL APTITUDES

Platforms:

Windows 7/8/10

Tools:

SQL, T-SQL, ETL/ELT, DTS, SSIS, SSRS, DOS, Assess, VB, VBA, VB Script, XML, C#, .Net, Visual Studio 2012, 2017

Server:

MS SQL Server 2008/R2, 2012, 2014, 2017

Professional Experience

Black Knight, Inc./Formerly Lender Processing Services Inc., Glendale, CA

Development Supervisor/SQL Developer (07/2000 – 07/2018)

Coached new and existing Team Members in procedural accuracy and ensured the timely performance of a team of 5 staff. Routinely debugged and improved codes for matching logic between various data sets. Executed data entry and backup functions to maintain log-ship servers. Defined storage procedures, and restored production and client facing servers as necessary. I worked for a period of 18 years at the company's entire satisfaction receiving frequent promotions.

Key Achievements:

Successfully transformed scripts from Visual Basic to SQL/T-SQL, which sped up the process runtime three times faster than the initial process.

Formulated and automated the extraction and transformation process for loading assessment data into SQL servers, so monitoring was not necessarily freeing staff time for other duties.

Designed and developed processes to extract, transform, and load the data into SQL Server.

Creating, maintaining, debugging, and modifying the codes for matching logic between different data sets for multiple processes which included [a) Assessment, b) Deed, c) SAM (Stand Alon Mortgage), d) Addendum, e) Tax, f) Phone, g) TBM (Thomas Brother Maps), h) Phone, i) DNC (Do Not Call List), j) Flood, etc. data] as business required modification.

Developing and supporting stored procedures, functions, views, tables, indexes, SSIS, SSRS, etc.

Loading data into log-ship servers, then backup and restore to the production and client facing servers.

Creating custom Match-and-Append processes to fulfill clients’ business needs.

Automating of multiple processes to load data.

Monthly update GeoCode Datasets program to run against the new coming data to correct and standardly the addresses correctly and Latitude and Longitude coordinates accurately showing the addresses on the company map website.

Creating diagrams using Visio to document each and every one of the ETL processes and matching logics.

Generating monthly reports using the information from customers accessing our website, based on that report, the invoices were issued for our clients.

Training the new onboard team member(s), as well as to the current team members in regards to understand how the processes work.

Computer for Tract Inc., Anaheim, CA

Software Engineer/Programmer (10/1995 – 07/2000)

Designed and developed Contract Creator, Maintenance, Security, Set Permissions programs using Visual Basic. Involved in a team project to help create Visual Sales Tract program.

Key Achievements:

Successfully create a Contract Creator/Generator program which produced input forms using Visual Basic and Crystal Reports that eliminated the necessity of drafting basic codes.

Designed and develop the following programs:

Visual Sales Tract program for new home builders using Visual Basic, ODBC, ADO, Access and SQL server.

Contract Creator program to create and generate input form for the Contract program using Visual Basic and Crystal Report.

Maintenance program to repair and compact the Access database.

Security program to generate serial numbers and password, which allow user to gain customers’ access to Visual Sales Tract.

Set permissions program to allow user to view specific tables in the database.

Made installations for Visual Sales Tract using Install Shield, including DCOM and MDAC.

Education and Training

California State University, Fullerton, CA

Master of Science in Computer Science

Master’s Project: Applying Data-Driven Method in Visual Basic Programming

California State Polytechnic University, Pomona, CA

Bachelor of Science in Computer Science, Minor: Mathematics



Contact this candidate