Data Analyst / Database Developer

Li Shu

South *th Av.

Arcadia, CA, ***** E-mail:

Cell: 626-***-**** (H)

*********@*****.*** (H)

Summary

Innovative Analyst/Developer with extensive knowledge and broad experience

in data analysis and database administration, relational database design,

development and implementation. Deep insight and efficiency in project

planning and administration, debug, problem solving, coordination with

cross-functional teams to meet deadlines

. Qualitative and quantitative data analysis, in the business or

scientific context; statistics, data modeling and trend

predicting, familiar with STATA, Excel

. Substantial experience in relational database design and application

development: SQL Server (2005), T-SQL and PL/SQL, ACCESS, Excel,

Oracle (Oracle Certified Application Developer 6/6i and R. 2)

. Data integration, well-versed in ETL, work knowledge of SSIS

. Database management and reporting, work knowledge of SSRS

. Programming Languages/Website Design: C, C++, Java, ShellScript,

HTML, CSS, XML

. Operating Systems: UNIX, Windows XP, Windows 2000

. Knowledge of SSAS, data mining and data warehousing concepts

Experience in Related Fields:

Avery Research Center, Pasadena, CA

2001 - 2013

Data Analyst / Database developer

. Designed and developed two database systems, one is for R & D, and

another is for management:

- Gathered the requirements, built the architecture of the database,

analyzed E-R diagram

- Physical implement of database, constructed tables, indexes,

constrains, triggers and stored procedures

- Built up some routine applications for searching and reporting

. Database administration and trouble-shooting: user access, backup,

performance tuning and all updates.

. Data integration: data ETL, bulk data transferring from one system to

another system, new data check and load

. Wrote queries and T-SQL for special requests and ad hoc report

. Created numerous small application programs to enhance the computer

techniques application in research and increase the efficiency of R &

D.

. Make work plans for experiments, data process and analysis, material

design, computer simulation, report writing, project coordination and

management

Working Language: SQL Server (2005), Lotus Notes, Access, MySQL, VB

embedded in Excel

Operating System: Windows

DataVentures Company, Los Alamos, NM 2000 -

2001

Analyst / Programmer

1) Accomplished a full cycle of sub-project for "Large Trading

System" project for New York Mercantile Exchange

. Fulfilled requirements analysis, design, programming, testing,

installation and maintenance

. Implemented data cleaning and standardizing: domain consistency,

disambiguation, enrichment and coding

. Performed data mining: market surveillance and report (internet

computing environment)

2) Key team member for "Customers Analysis and Sales Promotion"

project for one of "K-Mart" store

. Led data selection and data transformation

. Carried out customer analysis using query tools, statistical

techniques, and visualization techniques

Working Language: C, C++, Oracle, ShellScript, Java, Perl,

JavaScript

Operating System: UNIX, Windows

Los Alamos National Laboratory, Los Alamos, NM

1998 - 2000

Research Assistant

. Data processing and structure analysis of materials by using

software

. Ongoing DOE, statistical analysis on experimental data, experiment

results and trends

. Executed computer simulation of material experiments

Working Language: C, C++, Java, FORTRAN

Operating System: UNIX, Windows NT, Mac OS, DOS

Tsinghua University, Beijing, P.R. China

1995 - 1997

Research Assistant - Research Scientist

1) Directed project "Analysis of the Academic Journal Usage"

(for National Information Center of Engineering)

. Analyzed requirements, collected data, designed and

implemented database

. Built a brand-new database application to assist in the

library's investment decisions

2) Directed project "Establishment of the Information Database"

. Supervised graduate students to research and analyze the

scientific and technological information

. Created and maintained database to aid scientific research

3) As leading researcher created "Computer aided materials design

system" (National key project)

. Developed and applied expert knowledge to design and

implement material database

. Used mathematic physics method, numerical computing,

statistical techniques and optimization method to design

new material

4) Instructed course "Computer Aided Information Research and

Application"

Working Language: C, FOXBASE, FOXPRO, FORTRAN, VISUAL BASIC

Operating System: UNIX, Windows, DOS

Xi`an University of Technology, Xi'an, P.R. China

1986 - 1995

Lecturer - Research Assistant

1) Conceived, led and implemented database and application project:

"Computer aided design and optimization of materials and processes for

engineering applications", published three papers

2) Managed and accomplished database and application project: "Database of

testing questions of physical metallurgy and heat treatment" and this

project won "Second Place Award of the Province"

3) Taught advanced course in "Application of Computer in Materials

Science"

4) Won the "First Place Award" for excellent teaching and research

achievement, rewarded by Xi'an University of Technology

Working Language: C, DBASE III, FOXBASE, FORTRAN, Quick BASIC

Operating System: DOS

Education

MS Program, Computer Science, The University of New Mexico,

U.S.A.

M.S. Materials Science, Xi'an University of Technology, P.R. China

B.S. Materials Science, University of Science and Technology

Beijing, P.R. China

Contact this candidate