Data Quality Assurance

Grace Guo Stehlin

*** ******* ****** *****, *********, NC 27312

Phone: (H) 919-***-**** (Cell) 919-***-****

Email: **********@*******.*** ********@**.***.***

Professional Experience:

IBM IBM SmartCloud Managed Backup

June 2012 to Now

IBM SmartCloud Resiliency Services

. Data analysis/Database Support/data integration/data management

--Control center of Data backup billing system

--Manage data from 50,000 hosts, 600 Master servers over 400

Datacenters via tool SQL server

. Data analysis /clean

- Check the data collection and diagnose data backup issues related to

domain configure, server, host, data centers.

- Verify the data collection and loading correctly

- Update, insert, create data

. Quality Assurance (Software testing)

- Review the test cases about updating the data backup management and

new development

. Tools - SQL 2008,Unix, Putty, Toad, WinSCP, Excel and Access, Portal

and Lotus Notes

Duane Hall State House Election & Google Maps

January 2011 till now

Data Mining for Political campaign

. Data collection and Data Clean

- Collect the voter's information from media sources with

different data format

. Data integration the information gathered by using different tools

- SAS, SQL server 2008 T-SQL

- MySQL, MS Access/Excel, flat data source

-Import/Export with tools SQL, SAS, Excel (Access/Flat

source )

. Data analysis /Data mining

-SAS Enterprise Data Mining 4.2

- Clustering, Regression and Decision Tree nodes to analyze the

potential voters

-Make a report by reading output of data mining

Google Maps Accident Analysis In Greensboro

Tool used - SAS Enterprise

Chinese Community Networking (CCN)

August 2011 to Jan 2012

Data Integration and Collection (Internship)

. Design and implement Data Collection procedure

. Design the Table and Database structure using MS SQL2008R

. Analyze data using SQL 2008R2

University of North Carolina Greensboro

August 2011 to May 2012

Teaching Assistant

Provide instruction in the use of Microsoft Office, and in Website design

(CSS) for undergraduates

University of North Carolina at Chapel Hill

September 2006 to December 2009

Accounting Clerk III, Disbursement Service Department

. Work with Indepth and FRS databases for check requests, purchase

orders, accounts payable

. Investigate and resolve possible data errors in a collaborative

process with departments

. Process check requests, ensure data integrity between check and

invoice amounts

Infosystems Technology, Inc, Durham, NC July 2006

to September 2006

Technical Consultant

. Short-term contract to configure 900 Lenovo laptops for deployment at

a college in Raleigh

. Record and Track inventory using Excel

Beijing Jing Jia Run, Beijing, China

March 1996 to December 2005

Founder/President

Company provides data and voice network sales, installation, and support.

Beijing Sichuang Electronic Technology Company, Beijing, China

April 1994 to December 1995

Engineer & Sales Representative

. Testing, installing, and supporting of company manufactured phone

systems.

Education and Certification:

The University of North Carolina at Greensboro

Graduation: May 2012

Master of Science degree, Information Technology and Management

Concentration on Database Management, Data Warehouse and Data Mining,

Information Security

Tsinghua University (top technical university in China), Beijing China

Graduation: July 2002

Bachelor degree Telecommunications

. Project: Communication and Networking Project Budget Software

(Designed with Visual Basic & Access)Communication and Networking

Project Budget Programming was designed by individual by using tools

Microsoft Visual Basic and Database Access.

. Related Courses: Microsoft C ++ Programming, Programming In Fortran,

Microsoft Visual Basic

Additional Skills and Training:

. SAS Essential Program 1 competed (SAS foundation/ODS/Graph/Report)

. SAS Essential Program 2 in progress

. Java course in progress

. Experience with Oracle / SQL Database, (T-SQL,SSRS and Business

Intelligence Analysis )

. Experience with SAS 9.2 Enterprise Miner 4.2 Data Warehousing and Data

Mining, Data set two projects - traffic accident analysis by using

SAS Enterprise Miner 4.2

- Data Mining applied in political election

. Experience with writing code in PHP, CSS, Dreamweaver, ASP.net+VB.net

. Experience with system/web server (apache -XAMPP) configuration

. Experience with Microsoft Visual Basic,VB.net, Excel, Access, Visio

and Project, Adobe Photoshop and Illustrator

. Experience with creating Database, Table Schema and with designing

ER diagram, Logical Model

Community Activities:

North Carolina Chinese Business Association (NCCBA ) website) design team

Language Skills:

Fluent in English and Mandarin

Contact this candidate