Luke Du Email & Phone Number

California, United States

Azure Key VaultAzure ARC Agents and Managed IDAzure Artifacts FeedSnowflake Development

Irvine, California, United States

Just got promotion.

6430 Oak Canyon, Irvine, Ca

My company changed name to Appriss Retail.• Establish Microsoft Azure PipeLines to centralize work scheduler for production workstations • Establish code control framework for existing SAS code files using Git • Developed XML/JSON parsing process using C/C++, SAS, Python, under both Windows and Linux • Established client data loading system based on clients’ specific data format (CSV/XML/JSON)• Developed stored procedure in Greenplum for parsing JSON/XML directly from database • Developed and maintained efficient and stable data loading process such that data can be loaded in every few minutes • Developed XML/JSON data parsing process in Python using multithreading computing approach• Developed Powershell script to automatically compress data files • Developed KSH script for process automation including parallel processing and daily process with recover capability...has become the go-to person in regard to figuring out new and effective programming methods for handling of complex client data. With many clients moving to XML and JSON based trickle feeds, we have needed to move beyond our normal SAS based methodologies to process data quickly and repetitively. Luke is very good at researching, testing, and implementing new coding techniques. In addition, Luke delivers high quality results, as well as putting in the extra time to meet deadlines of each project.

Irvine, Ca

• Successfully worked up to speed on maintaining client processing.• Provided enhancements to daily process scripts.• Strong ksh scripting capability, strongest in group.• Strong ability to take a problem with minimal understanding and derive successful solution with minimal supervision.• Works independently and very fast.• Luke has quickly become a key employee within the Data Operations team. He is very proficient as a programmer, a very quick learner, and has provided many ideas as to how to make our client processing more efficient. As we become more better at communicating with each other on all aspects, his value will only increase to the company.

18000 Devonshire Street, Northridge, Ca

• Created and validated SAS programs for statistical summary TFLs for regulatory submissions, conference presentations, and/or marketing publications• Modified existing and created new SAS programs using SAS/MACRO in different projects for code reusing and easy validation• Integrated data from different databases including Oracle, Access, and Excel • Developed safety and efficacy reports per study requirements• Produced Ad hoc reports of various tasks using Proc Report, Proc GPLOT etc.• Performed quality check (QC) extensively on tasks performed by other team members • Created analysis datasets based on the guidelines provided in the data definition tables (DDT) and the CDISC standards. • Used SDTM/ADAM for domain creation and CDISC compliant analysis datasets• Generated VB script and Powershell script to connect SAS with MS Office efficiently

1. Updating perinatal services system (SAS dataset) using Oracle tables2. Generating GeoCoding SAS dataset using Windows MapMarker software3. Running SAS and Integrity Linkage software in IBM MainFrame System4. Generating California Death Linkage file for member of Kaiser5. Generating California Birth Linkage file for member of Kaiser6. Migrating Distributed Data Model from Windows server to UNIX server7. Create README auto-generation system using UNIX and Windows script8. Create Vaccine Safety Datalink 2009 and 2010 cycle files9. Investigate DataFlux software for standardization, verification, and matching functions.

Implemented pre-process and post-process of the computational software in UNIX environment using Matlab

Developed software packages using C, FORTRAN and Matlab under UNIX/Linux environment

Assessed data for accuracy and consistency using SAS Designed SAS programs to generate tables, listings, and figures to summarize experimental results using SAS/BASE, SAS/SQL and SAS/MACROSPerformed statistical and inferential analysis using t test, F test, Chi-square test, Fisher's exact test, Wilcoxon Signed-Rank test, linear regression and ANOVA Developed software packages using C, FORTRAN and Matlab under UNIX/Linux environment

Developed a part of the Cadcity software (based on AutoCAD) using WinNT/C++Developed a driver training management system by writing SQL codes under the Oracle database system

Ph.D, Mechanical Engineering

Ph.D., Applied Mathematics