QA Analyst, ORACLE/ACCESS database, GIS, coding program

Resume

Name: Jing Wang Address: **** Olde Hickory Road

Lancaster, PA 17601

Visa Status: US Permanent Resident Phone: 850-***-**** (cell)

Gender: Female E-mail: *****@*****.***

Job Goal: Computer Programmer, Computer Programming Analyst, Computer Database Administrator, Computer Software Tester. GIS analysis.

Expertise and skills:

• Database programming using Microsoft SQL and Oracle

Create a database, create a table, insert records, delete a table, filter records base on Numbers/Text/Dates, change the order of records, Modify data in a table, Undo DML Transactions, make data available to others, edit prior commands, customize the SQL*Plus environment, produce more readable output, spool output to disk, create indexes, create constraints, outer joins, create queries, create functions using SQL, create a stored procedures and triggers using PL/SQL, call stored procedures and functions, create crystal reports, create forms based on database. Import data from Access database to Oracle database by using SQL Loader, export dataset from Oracle database to Excel file or Access database.

• Code programming by several object oriented programming languages

Design and develop web/window applications using programming languages: Java 2, Visual Basic 6.0, and C++; test application using Visual Machine in different environment. Have knowledge on other programming languages, such as Javascript, HTML, C# ASP.Net, VB.net, and XML.

• Good skills on ArcGIS

Symbolizing and labeling maps, classifying data, querying maps, analyzing spatial relationships, setting map projections, building spatial database, editing data, geocoding addresses, and making map layouts.

Professional experience

12/2007 – 6/10/2011

Data Specialist II in Department of Environmental Protection (DEP), State of Florida, Tallahassee, FL

Responsibility: Assist with springs and ground water quality and quantity evaluations and assessments. Assist with data projects for reports producing GIS maps, tables and trend plots to support findings. Assist with the State’s Ground Water Protection and Springs Initiative Program involving data management, quality assurance/control analyses, and data manipulation; reviews springs monitoring data for QA/QC issues and completeness, coordinate data corrections with other agencies. Contributes to the data assessments that lead to ground water/springs protection actions. Assist with ground water and springs data requests and retrievals for agency staff and the general public.

Create maps on ArcMap: create a map to display spring stations/well stations, join county or WBID etc to spring/well stations, export spring/well stations as shapefile, clip some spring/well stations in specific county, wbid or basin. Create new layer from selected spring/well stations, export a layout view map, create a geodatabase, export shapefile into Access table. Draw a polygon for spring WBID. Change text label to annonation, manipulate label showing up.

Collect, manage and analysis data: collect ground water and spring data from different agencies, such as SWFWMD, SFWMD, SJRWMD, USGS, FGS, STORET etc., combine the collected data into Access database. By requesting, retrieving specific data from combined Access database, do chart and trend line for these retrieved data in order to know which spring station need to be cleared up.

Take data request job: retrieve spring or well data from OGWIS database or my own-made combined Access database based on the requests from some related agencies, make data trimmed, and send data to the users. Set up an ftp site for the users to get a huge amount of data.

Maintain HYDROPORT program: HYDROPORT is a program for customers to retrieve spring and well data from OGWIS database. Fix the problems reported from the customers. Add/input more functions for this program. Update HYDROPORT by changing the source code and updating HYDROPORT database tables.

QA/Check springs and initiative spring data: retrieve spring initiative data from DEP ADM tool, save them to Excel files, check field data and lab data by comparing field sheets and LIMs system data, report errors to the database administrator, verify corrected data, release provisional data.

10/2005-08/2007

Software test engineer in the Datamaxx Company, Tallahassee, FL

Job on duty: write test plan for web/window applications, deploy web/window applications in guest operation system on Visual Machine, test applications, report bugs to developer, verify defects, and deliver software to customers.

09/1996 – 04/2001

Teacher in a middle school in Hebei Province, China

Teaching area: Chinese Literature

Education

01/2004 – 08/2005

Business Computer Programming, Lively Technical Center, Tallahassee, FL

Courses: ArcGIS, C++, Java 2, Visual Basic 6.0, Microsoft SQL Server 2000, Microsoft Access.

09/1993 – 07/1996

Associate in Chinese, Hebei Teachers’ University, Shijiazhuang, Hebei Province, China.

09/1990 – 07/1993

Baoding Teachers’ School, Baoding City, Hebei Province, China

Contact this candidate