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

 

November 2004 – January 2005, Telecom Consultant, Vista RMS Corporation

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

 


Member number:8872
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 HARRY Green and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257