Application proggrammer, .Net, SQL Server Experience Data

ANDREW C. MILLS

** ****** ****** 215-***-**** (h)

Lower Gwynedd, PA 19002 ********@*******.***

215-***-**** (c)

OBJECTIVE: Part / Full Time or Contract Programmer / Analyst Position

QUALIFICATIONS:

. Experienced Engineer with extensive background in computer programming

. Computer skills include:

Fortran77 VB.NET C#.NET Microsoft Visual Studio 2010

ASP.NET C++ SQL SQL Server 2008

EDUCATION:

Pennsylvania State University - Abington, Abington, PA

Microsoft Visual Studio 2010 (programming in VB.NET and C#.NET - GPA

4.0)

Montgomery County Community College, Blue Bell, PA (GPA 4.0)

Courses included:

Computer Science (C Language) Web Page Development (HTML)

Data Structures and Algorithms Database Management

(SQL/Oracle/SQL Server)

Object Oriented Programming (C++) Advanced Database Management

Systems

Programming in Visual Basic Server-Side Web Development

(ASP.NET)

University of Michigan, Ann Arbor, MI

Completed advanced course in Assembler and Fortran.

M.S.E. Engineering, University of Michigan, Ann Arbor, MI

B.S. Forestry, Pennsylvania State University, State College, PA

EXPERIENCE:

Consulting Engineer / Lower Gwynedd, PA Nov 2011 -

Present

. Work with corporate clients analyzing site problems and providing

statistical analysis and groundwater modeling

. Develop computer applications in environmental statistics and groundwater

model calibration.

Principal Engineer / MACTEC Engineering and Consulting, Blue Bell, PA

Jan 2001 - Oct 2011

. Served as project manager and principal investigator on hydrologic

projects.

. Developed and tested numerous computer applications based on analytical

equations for multiple-well pumping, tidal fluctuations, slug-test

analysis, pumping-test analysis, contaminant migration, and data

screening and manipulation.

. Wrote and utilized programs that perform statistical tests required by

regulatory agencies for evaluation of water-quality data.

. Concentrated on groundwater quantitative analysis and assessments,

including groundwater numerical modeling using the graphical-user-

interface software Visual Modflow and Groundwater Vistas.

. Created and maintained substantial project databases in Microsoft ACCESS,

including developing numerous SQL queries.

ANDREW C. MILLS 2

_

Analyst/Programmer / Marketing Systems Group, Fort Washington, PA Apr

1998 - Jan 2001

. Wrote computer programs to extend and update a national database

including phone numbers, geographic specifiers, and demographic data.

Created and tested 50 new programs to supplement the 175 programs already

making up the database update procedure. These new programs incorporated

new approaches for insuring the accuracy of the final data products.

Revised significantly 45 of the already existing programs to increase

automation of the process, with check files created to document any

changes formerly done manually, and to improve the accuracy of the

results and the running efficiency. Created detailed documentation of

the extensive procedures involved in the national database update

process.

. Wrote utility programs, which streamlined tasks involving sorting,

performing frequencies, as well as merging and appending data files. Also

developed a moderately large program for performing cleaning and

switching of area codes that have undergone splits making use of lookup

tables.

. Worked as a member of a two-person team to design and manage a national

database of business data on a SQL Server using Microsoft SQL Server

2000. The project involved creating an application in Visual Basic to

select a universe of records and to create random samples from each

selected universe from the business database.

. Created a Visual Basic application for our production team to determine

the status of telephone exchanges and zip codes in seven separate data

sources for quarterly updates of the national database.

. Developed three Visual Basic applications to allow account managers to

easily access and query information from the national database, relating

telephone exchange, zip code, county and demographic information. This

involved first converting final data files from the national database

update process to Microsoft Access.

Contact this candidate