Summary

• Over 27 years experience in both scientific and business applications development, principally in design and implementation of mainframe and microcomputer DBMS's from prototyping through system documentation and user training.
• Mid-level/senior programmer/analyst position in application software development and database management with emphasis on client-server and Web-based distributed systems, DBMS design and development, and natural query languages.
• IBM OS/MVS XA/ESA , MS-DOS, MS Windows NT/200x, IBM OS/2, UNIX, and VAX/VMS.
• TSO/ISPF Dialog Management Services, IDMS/R ADS/O, OLM, COBOL Batch , DataEase, Oracle 9i Oracle CASE Dictionary, Oracle Enterprise Manager OEM , PL/SQL Developer, MS Access VBA , Remedy ARS User and Administrator Tools , IBI Focus, Informix-SQL, MS Word/Excel
• FORTRAN, VS COBOL, IBM 370 ALC, MS Qbasic Visual Basic 6.0, Oracle SQL Plus PL/SQL, ANSI SQL, DataEase Query Language, Intermec IRL barcode programming , Java 2 self-study
• IBM minicomputers and mainframes, Convergent Technologies minicomputer, IBM-compatible workstations and file servers, and Data General NOVA minicomputers

Work Summary

Computer Scientist

Confidential

Responsible for Oracle support of data migration task and general Remedy development project on both Windows and Unix servers under the NGA GeoScout Program, Enterprise Service Center Contract. Duties included loading test data with SQL Loader exporting and importing database schemas with Oracle Export and Import utilities preparing SQL and SQL Plus scripts to create views of legacy data for data transfers, insert data into tables, create indexes, grant privileges on views and tables, identify and recompile invalid objects, add table columns and constraints and modify column contents in legacy and Remedy schemas configuring data exchange definitions and data mappings using Remedy Enterprise Integration Engine EIE and Remedy Link for Oracle testing EIE data migration procedures in Windows and UNIX development environments and performing data migration on customer production UNIX system documenting data migration with procedure manual and data mapping matrices from legacy to target tables and forms troubleshooting data exchange errors using Oracle OEM, PL/SQL Developer, EIE debug logs in UNIX, and Remedy search techniques, e.g., sets of rows not transferred, violations of unique keys, required fields set to null, etc. developing LOB conversion functions. Performed minor Remedy development: DPAS report, minor updates of Remedy forms and filters provided Remedy reports of EIE data mappings for data migration documentation.

Senior Systems Analyst

Confidential

Responsible for software development and maintenance under IT support services contracts, Defense Intelligence Agency. Contributed to implementing bar-coding procedures for tracking ADPE inventory during burn-in and installation and to several software prototyping, conversion, and deployment projects. Tasks included: design, development, and operational maintenance of various DataEase and MS Access

database systems on Novell and NT LANs for configuration tracking, service desk, and budget management applications definition and documentation of computer equipment tracking system in Oracle CASE Dictionary development of Oracle prototype for UNIX-software configuration management database conversion of software acquisition database from DataEase to MS Access programming and software maintenance of Intermec bar code readers and implementation of procedures to deploy contract solicitation software utilizing PC-Install.

Senior Systems Analyst

Confidential

Responsible for designing, enhancing, and maintaining IDMS/R relational Quality Assurance Data Base QADB of the National Data Bank NDB project at the Food and Nutrition Service, USDA and designing and developing related NDB mainframe software. Applied structured methodologies for requirements analysis, general software design, program specifications, and implementation scheduling during all phases of NDB system development. Evaluated software products and tools, including IBI's FOCUS and Pilot Software's Command Center. As acting project manager, briefed clients on project status, allocated resources according to task priorities, and supervised staff. Tasks included: design, implementation, and enhancement of mainframe reporting systems in ADS/O, FOCUS, and COBOL Batch preparation of life-cycle documents logical and physical designs, user and program maintenance manuals , utilizing WordPerfect and Ventura regular interaction with clients to determine requirements, formulate project objectives and timetables, and resolve problems during acceptance testing.

Senior Systems Analyst

Confidential

Responsible for development and testing of IMS database backup/recovery and reorganization procedures, using IMS/VS DBRC, for 19 databases of H/HH bond application system at Bureau of Public Debt, Treasury Department. Developed procedures based on size, number of records, growth rate, transaction volume, and critical need. Provided complete system documentation and established test systems for acceptance testing.

Senior Systems Analyst

Confidential

Responsible for data conversion, and design, development, and implementation of reporting systems for the office automation project of the Office of International Cooperation and Development OICD , USDA. Tasks included transferring data from

shared IBM mainframe to dedicated mini-computer under UNIX System V operating system, providing standard and ad hoc reporting capabilities under Informix-SQL relational DBMS, and establishing a test database.

Senior Systems Analyst

Confidential

Responsible for ADP expertise and quality assurance for Deficiency Analysis and Reporting System project for Agricultural Stabilization and Conservation Service ASCS , USDA. As Task Leader, responsible for the system procedure design of the ASCS Freedom of Information Act FOIA project. Assumed position of Task Leader for concluding phase of Conservation Reporting and Evaluation System CRES project for ASCS, which included responsibilities for software development, preparation of system documentation, and acceptance testing. Tasks included program development in IBM VS COBOL and regular meetings with USDA contracting representatives and technical staff to review status and set detailed agendas and schedules.