Post Job Free

Resume

Sign in

Sas Programmer Oracle Database

Location:
East Lyme, CT
Salary:
$150K
Posted:
December 13, 2023

Contact this candidate

Resume:

DI LI

email: ad1xrx@r.postjobfree.com

COMPUTER SKILLS

Operation System : UNIX, Windows 95/98/2000/10, Windows NT Language : SAS, Visual Basic, and Unix Shell Script SUMMARY OF EXPERIENCE

**** — 2023: SAS Programmer. Eliassen Group. Reading, Massachusetts. 2002 — 2014: SAS Programmer. Synectechs Inc. New London, Connecticut.

Implemented SAS programs to generate reports (data table and figure), calculate statistics and edit their format satisfying requests.

Modified and improved SAS programs to convert data table from PCL to Rich Text Format.

Verified data reports accuracy with QC SAS programs and Unix shell scripts.

Created QC documents (MS Word format).

Wrote shell scripts to run reports, to check output and logs, to copy and modify files, to search and count files, to find reports information (table number, title and creation time), and etc. 2001 — 2002: Software Analyst – QA (Contractor). Oxford Health Plan. Trumbull, Connecticut.

Tested functionality of the new Oracle database interface forms and new SQL scripts, verified the installations and structures of the forms and database tables.

Created SQL scripts to select data from Oracle database tables, to insert or update records in tables for test purpose.

Wrote UNIX (AIX 4.3) shell scripts to generate SQL scripts then execute them automatically

(on SQLPLUS).

Implemented SAS programs to create reports (data table, chart or plot) and calculate statistics.

Established VB scripts (on MS Office 2000) to verify the test results.

Wrote QA documents: test plans, test scenarios, test cases and test report.

Reported bugs found in the software and verified them fixed in the new version. 1998 — 2001: SQA ENGINEER. TIBCO Financial Technology Inc. Palo Alto, California.

Tested new functions, identified and verified bugs on TIBCO market data products that perform real time data transfer for financial markets on several platforms - UNIX (SunOS, Solaris, AIX and HP) and Windows NT (3.51, 4.0).

Created test plans, test procedures, test scripts, and test cases. Verified, analyzed, and reported test results.

Utilized Windows NT (3.51, 4.0) environment to test software with different registrations and configurations.

Assisted developers in reproducing and eliminating bugs. Trained new employees in software testing.

1997 — 1998: ENGINEER. Inko Industrial Corp. Sunnyvale, California.

Designed and implemented an embedded system to control a mechanical device. Provided technical support for production.

Implemented a program and script on Excel with Visual Basic for statistical data analysis.

Developed and set up a PC system to control an X-Y-Z moving table improving the accuracy of material distribution.

Actively involved in project cycle, plan phase, design phase, implementation phase, SQA

(installation, function, error, and boundary tests), maintenance and technical support. Di Li, page 2

1992 — 1996: TECHNICIAN. Department of Physics, University of Utah.

Maintained and operated a photomultiplier tube calibration laboratory. Designed and machined mechanical parts.

Modified and developed programs to control an X-Y moving table and laser/UV sources for experimental data collection and analysis with C and C++ on MAC and UNIX environment. 1984 — 1991: ENGINEER. Beijing Energy Conservation Technology Service Center. Beijing, P. R. China.

Designed steam pipe systems with a heat accumulator device.

Developed computer programs to calculate the intensity of pressure vessels and drew construction blueprints.

EDUCATION

B.S. in Engineering, Tsinghua University, Beijing, P.R. China CITIZENSHIP STATUS

Permanent resident of the USA.



Contact this candidate