Project Manager Visual Basic

** ****** ******, ***** *******, PA *****

********@*******.***

Phones: 215-***-****(h); 215-***-****(c)

ANDREW C. MILLS

______________________________________________________________________

Programmer / Analyst

TARGET JOB Desired Status: Part-Time or Full-Time

Location: On-Site; Commutable from Lower Gwynedd, PA

Description of my ‘perfect’ job:

* Stimulating project work involving problem solving through systems analysis and programming in Visual Basic, SQL, C#, C++ or FORTRAN

* A work and project environment, which requires new creative solutions to problems--solutions that stretch the limits of past knowledge and experience.

TARGET COMPANY Category: Information Technology; Service Industry; Product Industry

Description of my ideal company:

* A company that provides freedom for each employee to develop his/her potential and skills at his/her optimal pace

* A company that puts a high value on the results of hard, conscientious and creative work.

EXPERIENCE Analyst

Marketing Systems Group, Fort Washington, PA April 1998 – January 2001

Responsibilities included the updating and maintaining of a national database, Genesys, which comprises phone-number exchanges, geographic specifiers, and demographic data. Programs were written in Fortran on a daily basis for specific data needs and to extend, and to improve the accuracy of, the national database. Work was performed on a PC workstation with network connections to an Alpha VAX computer.

Responsibilities also included working as a member of a two-member team to design and manage a national database of business data on a SQL Server using Microsoft SQL Server 7.0. 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. This involved participating in the creation of stored procedures and in the writing of Visual Basic code which accesses and manipulates data from the database, often through the stored procedures.

Toward the end of my employment at Marketing Systems Group, I was involved in creating a Visual Basic application for our production team to determine the status of telephone exchanges and zip codes in seven separate data sources for any selected quarterly update of the Genesys database. Earlier I developed three Visual Basic applications to allow account managers to easily access and query information from the Genesys database, relating telephone exchange, zip code, county and demographic information. This involved first converting final data files from the Genesys update process to Microsoft Access tables.

Created and tested 50 new programs to supplement the 175 programs already making up the Genesys 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 Genesys database update.

Developed and tested FORTRAN 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.

Groundwater Hydrologist

Various Engineering Consulting Companies in NJ, PA, IA July 1972 - Jan 1998

Previous employment with engineering and environmental consulting firms, including: Dames & Moore, Woodward-Clyde Consultants, Earth Technology Corporation, McClure Engineering Company (Iowa), Geraghty & Miller, and Vincent Uhl Associates. During the course of project work, he developed and employed FORTRAN computer programs based on analytical equations for multiple-well pumping, slug-test analysis, pumping-test analysis, bail-down test analysis, water-level data reduction, and statistical analysis of groundwater quality data. He also created programs for reservoir routing of runoff; mass accounting of inflow to, and outflow from, reservoirs; and, development of synthetic stream flows based on limited stream/river gaging data. The work also frequently involved numerical model development for groundwater flow and contaminant-transport simulations using state-of-the-art computer groundwater models and modeling systems.

He applied, and in some cases modified, several public-domain or commercial numerical models written in FORTRAN for projects requiring groundwater flow or mass-transport modeling. These have included the Prickett-Lonnquist flow model, the USGS groundwater solute transport model (MOC), the USGS Modflow model, MT3D, and the Princeton Transport Code.

Principal Engineer

MACTEC Engineering and Consulting, Blue Bell, PA Jan 2001 - Oct 2011

He served as a project manager and principal investigator on hydrologic projects. He specialized in groundwater quantitative analysis and assessments, including groundwater numerical modeling using the graphical-user-interface software Visual Modflow and Groundwater Vistas. He developed and tested numerous FORTRAN programs based on analytical equations for multiple-well pumping, slug-test analysis, pumping-test analysis and contamination migration in aquifers, and has utilized these programs on a number of projects. He, moreover, wrote and utilized several FORTRAN programs that perform the types of statistical tests required by regulatory agencies for evaluation of water-quality data. He created and maintained project databases using Microsoft’s Access, including development of required queries and reports.

EDUCATION M.S.E. Water Resources Engineering, University of Michigan

B.S. Forestry, Pennsylvania State University

Computer Course Work:

Introduction to PageMaker, Summer 1996, Bucks County Community College

CIS 111, Intro to Computer Science with C Language, Summer 1997, MCCC

CIS 112, Data Structures & Algorithms Using C++, Fall 1997, MCCC

CIS 235, Object Oriented Programming in C++, Spring 1998

CIS 122, Programming in Visual Basic, Spring 2000, MCCC

CIS 108, Web Page Design/HTML, August 2000, MCCC

CIS 245, Database Management with SQL/Oracle, Fall 2000, MCCC

(Obtained an ‘A’ grade in all the above courses)

(MCCC = Montgomery County Community College)

Took two certificate courses in fall of 2011 at Penn State Abington using Microsoft Visual Studio 2010 involving programming in VB.NET and C#.NET. Obtained an A grade in both.

SKILLS Programming in Fortran

Programming in Visual Basic

Programming in SQL including Stored Procedures

Programming in C# and C++

Contact this candidate