HARRY
S. GREEN
________________________________________________________________________
45
McPherson Circle, Sterling VA 20165
(703) 406-3273
E-Mail: harrygreens@verizon.net
OBJECTIVE
A software or systems design and development position
that utilizes my database, Unix, C, C++, PERL, 4GL, client/server, and database
development background, allowing me to apply my experience and skills.
SUMMARY
I have almost 24 years of
increasing responsibility and expertise in the planning, design, implementation, and administration of
information systems utilizing database and Client/Server applications involving
Oracle, SQL Server, Unix, Perl C/C++, and PL/SQL. I have recent academic
experience developing various applications using C and C++ on Unix. My experience includes the design of
applications for a variety of complex systems including government forecasting
and inventory systems. I have written
database software for telecom billing systems and an IRS datamart application.
HIGHLIGHTS OF EXPERIENCE
Hardware – HP, Sun, Unisys 5000, DEC
Alpha/VAX, Intel, Macintosh, IBM MF, Honeywell, Data General MV Series
Environments – Oracle, Unix,
Designer/Developer 2000, Oracle Financials, SQL Server, VAX VMS, Windows
95/98/NT/XP/2000, MS DOS
Languages/Software – C, C++, PRO*C, OCI, Unix
Shell, Perl, PL/SQL, T-SQL, ODBC, OLAP, Fortran, XML, HTML, Java
Tools – TOAD, PVCS, Team Windows,
Visual Interdev, ClearCase, ClearQuest
PROFESSIONAL EXPERIENCE
Participated in software
development of initial releases of telecom datamart application containing
wireless telephony data, using PL/SQL and Unix Shell Scripting with Oracle 10g
on HP Unix.
August 2001 – November 2004,
Systems Engineer, Science Applications International Corporation
Developed interface for loading
Oracle database using Oracle Forms 6i. As part of a team was responsible for
developing Oracle PL/SQL applications supporting Java web-based forecasting and
trend analysis product for military. As
part of team redesigned Oracle database in support of new requirements and
increased workload required by the forecasting tool; Also developed metadata
applications supporting database redesign, and other Oracle applications for
data verification of raw data. Developing applications for regenerating various
parts of the database schema when there are changes to the tables or their
constraints. Currently developing applications for rebuilding data dictionary
and reference data tables.
Designed and developed
table-driven Oracle PL/SQL procedures to generate business rules in XML format
for business rule case processing system of product for automating tax-exempt
application process to IRS Division, using PL/SQL extensions for XML. Designed and developed Oracle PL/SQL engine
to generate test data for testing this product.
As a tester of GCCS database
segments was responsible for ascertaining compliance of tablespaces, table
constraints, database privileges, DDL, and other database objects with DII COE
Standards. Also performed compliance
and integration test of other GUI and Unix segments that comprised GCCS written
in Unix Shell and Perl. Built test
environments on Unix Solaris hosts in support of testing.
July 1999 – August 2001 Computer Scientist - Computer Sciences
Corporation. Springfield, VA
Designed and maintained code
written in Unix Shell Language, Perl, and Oracle PL/SQL on Sun Servers for
retrieving, processing, integrating data from different customer sites, for
back-end processes of Integrated Data Environment Product on JTAV project. I participated in analyzing functional
requirements, implementing, and troubleshooting various Unix and Oracle applications
for the JTAV, NLAC, and JMAR Projects.
Developed SQL*Loader scripts to load JTAV Oracle tables on HP Unix host
and developed and enhanced Unix Shell and Perl Scripts to accept and process
data from external sites. Created all
DDL, keys, constraints, database triggers for new and modified tables and views
for new functionality on JTAV and NLAC.
Participated in design of
data-mart using SQL Server with Star schema database for IRS SB/SE Division as
front-end for remote data-warehouse.
This database consisted of about 40 Fact and Dimension Tables. Created DTS, T-SQL, and database tables,
indexes, constraints to support loading dimension tables from OS files.
July 1998 – June 1999 Consultant
Participated in the conversion
of Stored Procedures for billing applications written in T-SQL to PL/SQL for
Oracle 7.3 Database on Unix Sun platform.
Assisted with integration test of stored procedures. Developed upload utility program written in
C with API and Unix Shell utilities to support the installation of a document
imaging and workflow product.
Participated in the design and development of extraction and analysis
processes for auxiliary analytic systems for EPA contract. Development was performed using PL/SQL
stored procedures for an Oracle 7.3 Database on DEC Alpha Server running
Unix. Used Erwin diagrams to aide in
the design and development of this product.
Aug 1997 – July 1998 Software Engineer - Computer Business
Methods Inc. Fairfax VA
Developed code for enhancements
to products for Dept. of Education Loan program and Closed School
Administration, using Oracle Designer 2000, Developer 2000, and Reports 2.5.
Also developed PL/SQL Libraries,
Triggers, and Stored Procedures for validating and processing data entered
using Developer 2000 screens. Designed
and developed a product using Designer 2000, Developer 2000, for Department of
Education to selectively update their database with various datasets and report
discrepancies. Participated in writing
functional documentation. Development
of packages was engineered from Erwin diagrams of existing legacy systems.
May 1996 – Aug 1997 Consultant - Princeton Information
Systems. Vienna VA
For telecom clients developed
enhancements to code for back-end Unix host applications for billing systems
running on HP Unix Servers written in C, Pro*C, and PL/SQL. The enhancements included the ability to
interface with other Unix applications that processed network, equipment usage,
and other billing data. As a part of
the development team, provided impact analyses of new performance requirements
on the existing design. Troubleshooted
and maintained C and Unix Shell applications for billing system.
Dec 1992 - May 1996 Consultant
Responsible for developing
interfaces to tables and views used by Oracle Financials package, also
providing analysis of the application and underlying use of Oracle objects by
the product. On DOD contract was team
lead on task performing IV&V on Army personnel system. As Oracle DBA was responsible for
installing, configuring, tuning, and maintaining medium-sized Oracle database
on local Unix host.
Developed applications
supporting business needs for telecom organization using Oracle SQL*Forms,
PL/SQL, SQL*Loader, and SQL*Report Writer on a VAX VMS host. Also wrote SQL*Loader Scripts for
initializing Oracle tables.
Created network
statistics-gathering application that ran on HP Unix host using Developer 2000,
Oracle Forms, and PL/SQL. Provided
enhancements for other inventory and personnel applications using Oracle
SQL*FORMS, PL/SQL, and PRO*C.
Participated in design and
analysis of an existing MIS product for the FDA that was to be re-engineered
using Erwin, Visio, Oracle Case Tools, and Designer. Also developed Process Flow, Data Flow, and Entity Diagrams for
preliminary design reviews of the product.
Jan 1989 – Dec 1992 Senior Applications Programmer/Analyst –
Unisys Corporation. Newington VA
Developed enhancements and new
features for an Oracle-based menu-driven DoD transportation system running on
Unisys 5000 Unix host, that was written using Oracle SQL*Forms, Pro*C/C, and
Unix Shell Language. Participated in
modifications to the database schema, data dictionary, and optimization of
queries by the application. Participated
in the conversion of DoD personnel and supply systems from IBM Main Frame implementation
to Oracle implementation on Unix Unisys 5000 host, using SQL*Forms, Reports,
SQL*Loader, PL/SQL, C, and Unix Shell.
Participated in preliminary system design re-engineering and the design
of Oracle database schema. Developed
load scripts using SQL*Loader, and other utility programs using PL/SQL and Unix
Shell Language for loading/updating tables and validating input and external
data. Wrote modifications and
enhancements for Unix and Oracle applications to incorporate features of new
releases of Oracle and other products.
Jun 1983 - Jan 1989 Consultant
Designed and developed utilities
written in C and FMS on the VAX VMS which were used for supporting in-house
engineering development. Created
information storage and retrieval system using FMS on a VAX VMS for managing
testing activities of internal software used by USPS vending machines. Designed and developed utilities written in
C Language on VAX host for reporting test status of proprietary imaging
applications. Developed client applications
to prototype financial package for DoD.
Developed utilities written in C Language, with Unify Database on Unix
host that provided access to a local area network and network hosts. Also wrote utilities in Unix Shell and C
language tools supporting database administration tasks. Developed host server applications
supporting development team using Fortran 77 for data collection and billing.
Jun 1981 - Jun 1983 Senior Technical Aide - AT&T Bell
Labs (now Bellcore), Piscataway, NJ
As part of Project TIRKS support
team developed utilities written in C and Unix shell that automated the
development, testing, and distribution of various IBM Main Frame telecom
billing and business applications. In
QA I developed code for system test, quality assurance, and maintenance of IMS
on-line and batch processes running on large IBM mainframes. Worked with IMS, MVS, TSO/ISPF, and JES2.
EDUCATION
2000
Pursuing MSCS at George Mason University, Fairfax VA
1981 B.S.
CS/MIS, Spring Garden College – Philadelphia PA