Sql Server Data

Jim. J. Qi

**** ******** ***** **., *******, NC *7614

919-***-**** ***.*.**@*****.***

NATIONALITY

. US Citizen

EDUCATION

. BS in Computer Science - Idaho State Univ., Pocatello, ID, USA

Sept.1997 - Dec. 1999

. MS in Forest Resources - Univ. of Idaho, Moscow, ID, USA

Sept. 1991 - Feb. 1994

. MS in Plant Ecology - Chinese Academy of Sciences, Beijing, China

Sept. 1982 - Aug. 1985

. BS in Forestry - Agricultural Univ. of Anhui, Hefei, China

Sept. 1978 - Aug. 1982

EMPLOYMENT HISTORY

. Computer Programmer III, Duke University, Durham, NC

Dec. 2006 - current

* Primarily designed and implemented Urology Clinic, Teleform Scan,

and Research Databases in MS SQL Server 2005/2008R2.

* Served more than 30 Duke Urologists, fellows, residents and

medical staff; and over 500 patient users.

* Registered over 100K urology patients; recorded over 19.2 millions

of patient lab test results, 12K surgeries, 14K biopsies, 50K

patient surveys, and automatically generated over 10K electrical

medical records (EMRs).

* Played full Database Administration and Data Analyst roles, which

include database creation, data integration, indexing, data

mining, data warehouse, performance turning, database partition,

data repository and data dictionary, and documentation, security

planning and design, security implement and monitoring, backup and

disaster recovery.

* Created approx. 50 SSIS and ETL packages to upload and download

data from/to other Duke entities on a daily basis; 500 T-SQL

queries and views, 250 store procedures, and 80 functions and

triggers.

* Used Business Intelligence (BI) and other BusinessObject tools

such as SSRS and Crystal Report to create 120 reports, labels, and

PDF-formatted letters. I also have the good knowledge of QlikView

and .netChart third party applications though I did not use at my

current work.

* Used MS Visor to build the database ER Diagram, Data Flow Chart,

and Business Logical Flow Chart to communicate with business

analysts and end users.

* Managed and helped 40+ other ACCESS databases for Faculty and

Fellows' research projects.

* Provided and queried data for faculty, fellows, and residents'

clinical research and grant writing. We have published about 35

papers for past six years.

* Developed two .Net web applications (Clinic e-Note

https://uroClinic.surgery.duke.edu; Patient Portal

http://eUrology.surgery.duke.edu)

* Used MS Visual Studio 2005 and 2010 and technology including HTML

4/5, ASP.net, VB.net, C#.net, MS framework (migrated from 2.0 to

4.0), AJAX, XML, XLST, CSS, JavaScript, VB scripts, JQuery,

Crystal Report, Silver-light, Adobe Acrobat Pro.

* Developed the browser-independent "Check and Spell" web-based

module using Microsoft Silverlight to check EMR notes by applying

a variety of Medical, Legal, Scientific, and other 10+ Western

language dictionaries.

* Implemented three (3) Monogram models of faculty research results

into e-Urology and urology Patient-Portal.

* Created several web services to pull data from other Duke Websites

to auto-fill patient demographic data into our urology clinic

database.

* Voluntarily developed a web application for the National

Foundation of Caner Research to identify tissue samples from the

tissue bank and export results to any MS application

(http://nfcrbiorepository.org)

* Configured and maintained all three web applications I built on MS

IIS web servers, monitored the security logs, and applied security

patches as needed.

* Reviewed professional papers for faculty; assisted in analyzing

medical data for research using SPSS, STAT, MatLab, and SAS

programming as needed.

* Technical writing to document all application functional

specifications, metadata, processes, version release notes, user

manuals, and other technical documents.

. Sr. Programmer/Analyst, LabCorp Inc., Burlington, NC

Apr. 2001 - Sept. 2006

* Started at Rank 9, promoted to Rank 10 in Aug. 2003

* Primarily designed and developed LabCorp eFone (telephone) Bill

Payment Systems using VB 6.0 and MS SQL Server 2000 Database.

* Played key programmer role on the eFone Provisioning Systems using

Java/J2EE Programming, including JSP, Servlets, Beans, Forms,

Commands, Struts, Hibernate, Patterns, ANT, and XML, as well as

IBM WebSphere (5.0, 5.1, 5.1.1, and 5.1.2).

* Maintained LabCorp Human Resource Payroll System using ASP

(through Visual InterDev and VB 6.0), and MS IIS web Server 5.0,

and MS SQL Server 2000.

* Developed LabCorp eLCM Laboratory Web-based Excel-like data and

graphics reports using Java and Formula One Report Tool and MS SQL

Server 2000.

* Maintained existing LabCorp applications written in ColdFusion,

Visual Basic, and other languages

. Programmer/Analyst II, Affiliated Computer Services (ACS), London, KY

Mar. 2000 - Apr. 2001

* Provided B2B dynamic web solutions to clients using ADO, ActiveX,

ODBC, OLE, RDS to connect MS Access and SQL Server databases

* Participated in programming team developing internal software to

write OCR, Scanner's, and hand-input data from production machines

into database located in NT Server by using Delphi 4.0/5.0

EXPERIENCE PRIOR TO 2000

. 1997-1999 - Idaho State Univ., Web/Database Developer: WebCT, Visual

InterDev, ASP, FrontPage

. 1995-1997 - Advanced Business Computer (ABC) Inc., C/C++ Programmer:

C/C++, database operation

. 1994-1995 - Washington State Univ., Programmer/Analyst: C/C++, app.

software, research data, reports, models

. 1991-1994 - Univ. of Idaho, Programmer/Analyst: data collection and

analysis, C/C++/ SAS, UNIX, SigmaPlot, Quattro Pro, Excel, and Lotus

COMPUTER SKILLS

. Hardware: VMWare, IBM-PC, MAC-PC, HP 9000, SUN, AIX, and VAX, Windows,

LINUX.

. Operation Systems: MS-Window 7, Window 2003/2008R2 Servers, MS-WINDOWS

Windows XP/2000/98, NT 4.0/5.0, UNIX, MVS/TSO/JCL, VMS/DC.

. Computing Languages: Visual Studio 2005/2010, Visual InterDev,

ASP.Net, VB.Net, C#.Net, Visual Basic 6.0, VBA, J2EE/JAVA, Delphi,

ColdFusion, C#, C/C++, Visual C++, PASCAL, HTML/DHTML, XML, XLST, CGI-

Script, VB Script, Java Script, JQuery, Perl, and PHP.

. Database Applications: MS SQL Server 2008/2005/2000, DB2 7.0/7.2/8.0;

Sybase 12, MS Access 97 / 2000/2003/2007/2010.

. Application Software: MS Visio, MS Office Programs, IBM WebSphere,

Visual Studio 2005/2010, VPN, Adobe Pro Dreamweaver, Flash, Photoshop,

3D Design, Quarto Pro, Lotus, WP Presentation, and much more.

. IIS Web Hosting: Excellent skills in Win NT OS and IIS settings, and

configurations, security monitoring and logging.

. Other Technology-Related: Excellence in technical writing, new release

notes, manual, instructions, etc.; Familiar with MatLab, SAS, STAT and

other statistical applications; good knowledge of 5th Generation

Databases of Cach (the Object database), MongoDB; and newly released

MS SQL Server Database 2012.

CERTIFICATES

. MatLab for Data Processing and Visualization, MathWorks, Boston, MA

Jun. 2013

. JAVA/J2EE Programmer, IS University, Laboratory Corporation Inc.,

Burlington, NC Dec. 2003

. Leadership, Alamance Community College, Graham, NC

Dec. 2003

. Communication, Alamance Community College, Graham, NC

Dec. 2003

. Micro Computer Specialist, Idaho State University, Pocatello, ID

May 1999

LEADERSHIP

. Principal: Raleigh Academy of Chinese Language (www.racl.org)

. Board Chair: Raleigh Academy of Chinese Language.

. Board Director: Chinese American Friendship Assoc. of North Carolina

(CAFA, www.cafanc.org)

REFERENCES

. Available upon request.

Contact this candidate