| HARDWARE: |
IBM RS/6000, Sun Workstations, HP, Sequent, VAX, IBM 3090, Data General |
| OPERATING SYSTEMS: |
Unix (Solaris, AIX, HP/UX, DYNIX), VMS, MVS, AOS/VS |
| LANGUAGES: |
C, PL/SQL, SQL, Dynamic SQL, HTML, Dynamic HTML, CGI, Perl, ksh, AWK, SED, JavaScript, FORTRAN, COBOL |
| SOFTWARE: |
Oracle, Oracle WebServer, Oracle Forms 3.0, Oracle Reports 1.0, 2.0, Sybase, Microsoft SQLServer, SQL Navigator, Microsoft Word, Microsoft Excel, Microsoft Project, Microsoft Access, Visio |
| SYSTEM TYPES: |
Information Science(Library/Cataloging), Accounting, Marketing & Sales, Online Shopping, Telecommunitications, Client/Server, Data Conversion |
EXPERIENCE:
| Consultant, Team Lead |
AT&T Wireless Services, Bothell, WA |
|
November 2000 - Present |
| Projects and Responsibilities: |
| * |
Developed an automated process to load complex, variable data into application using Object-Oriented Perl and Perl DBI. Process includes automated error correction, error checking, validation, and reporting. This process replaces a manual process and reduces the time of loading the data by more than 300%. |
| * |
Developed a process to automatically connect to DCS's (Digital Cross Connect Telecom equipment) and download current configuration using Perl. |
| * |
Combined and related Transport Records describing circuits contained in multiple Excel spreadsheets to create input files for data loading. |
| * |
Developed a website using Perl, CGI, and DBI, to provide finer control of access to change data within the application's database. |
| * |
Developed a module in Perl to provide access to other machines, and copy files between the machines, using standard telnet/ftp, rsh/rcp, or ssh/scp. This module provides the user with a consistent interface regardless of the access method. |
| * |
Lead for a team of database professionals to load new database with data collected by another team |
| * |
Learn and understand Telecom terminology and equipment, with a focus on Transport Engineering |
| * |
Write reports to demonstrate the completeness and accuracy of the data |
|
| * |
Write and execute scripts to fix data integrity problems |
| * |
Write and execute Perl programs to fix improperly loaded data |
| * |
Write and execute Visual Basic for Excel programs to fix format reports, and to create loadable data from equipment audit data |
|
| Skills: |
Perl, Visio Professional, Oracle SQL*Plus, Oracle PL/SQL, Microsoft Excel, Microsoft Word, Visual Basic for Applications |
|
| Consultant |
Advanced Radio Telecom, Bellevue, WA
|
|
August 2000 - November 2000 |
| Projects and Responsibilities: |
| * |
One of a two person team to research, analyze, and
document the distribution of important company data
throughout the company’s COTS databases. |
* |
Developed an Enterprise Logical Data Model |
| * |
Created physical ER Diagrams of the
COTS databases. |
| * |
Created a map of
the physical locations of data to the Enterprise
Logical Data Model |
|
| Skills: |
Visio Professional, Microsoft Access, Oracle
SQL*Plus, Microsoft SQL Server, Microsoft Query
Analyzer, Embarcadero RapidSQL, Perl, Microsoft Excel,
Microsoft Word |
|
| Consultant/Technical Team Lead |
The Boeing Company, Seattle
|
|
August 1997 - August 2000 |
| Projects and Responsibilities: |
| * |
Responsible for day to day progress toward fulfillment of team goals, identifying and managing technical issues and obstacles, and oversight of test cycles and production data loading. |
| * |
Wrote programs in Pro*C for converting data to new format for loading into a new database. |
| * |
Wrote ksh and PERL programs for controlling the loading of data. |
| * |
Wrote miscellaneous utilities in ksh, PERL, C, and PL/SQL. |
| * |
Helped debug major libraries. |
| * |
Researched and analyzed data to be loaded. |
| * |
Created a statistics reporting web site using Oracle WebServer. |
|
| Skills: |
C, Pro*C, Korn Shell, AWK, SED, Perl, PL/SQL, SQL*Plus, JavaScript, Oracle WebServer, Microsoft Word, Microsoft Excel, Microsoft Project |
|
| Consultant |
AT&T Wireless Services, Seattle
|
|
May 1997 - August 1997 |
| Projects and Responsibilities: |
| * |
Created adhoc queries and PL/SQL programs to provide information to users. |
| * |
Wrote stored procedures, functions, and packages in PL/SQL for batch processes to update data nightly. |
| * |
Involved in the testing and debugging of an Intranet Marketing Information site, implemented with PL/SQL and Oracle WebServer. |
| * |
Responsible for optimizing queries of existing scripts and programs |
|
| Skills: |
PL/SQL, Oracle, Oracle WebServer, SQL Navigator |
|
| Senior Analyst |
CUC International, Columbus Software Division, Columbus, Ohio |
|
April 1996 - May 1997 |
| Projects and Responsibilities: |
| * |
Designed, implemented and tested new transactions for an existing
server. Transactions were written in C, FORTRAN, and embedded
SQL. |
| * |
Wrote utilities for the division intranet, using C, CGI, and
HTML. |
| * |
Implemented an existing commercial web site using new web
development tools written inhouse using Java accessing an
Oracle database. |
|
| Skills: |
C, Oracle, Pro*C, Embedded SQL, Dynamic SQL, CGI, HTML, Dynamic HTML, JavaScript,
VAX/VMS, Sun Solarius |
|
| Senior Programmer/Analyst |
OCLC Online Computer Library Center, Dublin, Ohio |
|
August 1994 - April 1996 |
| Projects and Responsibilities: |
| * |
Upgraded and maintained online server. Upgraded the original
server from a single user server to a multi-user,
multi-threaded system using sockets for communication. |
| * |
Added to parsing and searching to the above server for searching
databases. |
| * |
One of several developers responsible for the support of
the online systems. |
| * |
Scheduled, coordinated and built the production software
running on the Unix system using the PVCS software management
software. |
| * |
Started a pilot project to create a web-based software submittal system written in Perl. |
|
| Skills: |
C, Sybase, HTML, Perl, CGI, Client/Server, Unix, Unix Shell Scripting, IBM MVS, Embedded SQL |
|
| Consultant |
Information Control Corporation, Columbus, Ohio |
|
March, 1993 - August, 1994 |
| Client: |
Management Consulting Firm, March 1993 - January 1994 |
| Resonsibilities: |
| * |
Created accounting reports using Oracle's SQL*ReportWriter. |
| * |
Created menus to run reports using SQL*Menu and SQL*Forms. |
| * |
Wrote programs in COBOL to reorganize accounting data files. |
|
| Skills: |
VAX VMS, Oracle, Oracle Forms 3.0, Oracle Reports 2.0, Oracle Menu, COBOL |
|
|
| Client: |
OCLC, January 1994 - August 1994 |
| Responsibilities: |
| * |
See entry for OCLC above |
|
|
| System Administrator |
BBS Corporation, Columbus, Ohio |
|
June, 1992 - March, 1993 |
| Responsibilites: |
| * |
Responsible for system maintenance, installation of new
software, archiving and restoring files and regular backups. |
| * |
Wrote shells for automating start up of CADD system. |
| * |
Researched and oversaw the purchase and installation of a
new multiplexor for support of connected workstations at a
remote office. |
| * |
Researched and purchases new PC's. |
| * |
Modified and created architectural plans using GDS CADD. |
|
| Skills: |
PRIME PRIMOS, GDS |
|
| Oracle Programmer |
Ohio Northern University, Ada, Ohio |
|
November, 1990 - June, 1992 |
| Responsibilities: |
| * |
Wrote new reports in Oracle SQL*Report for the university's
new administration system (SCT BANNER). |
| * |
Performed daily backups of the system. |
|
| Skills: |
Oracle, Oracle Report 1.0, Data General AOS/VS |