Lee Rodgers
11809 Oakwood Drive
Austin, TX 78753
 Residence: (512) 836-7772
leebertarian@yahoo.com
OBJECTIVE To serve in the capacity as a leading-edge technologist performing analysis, modeling, planning, design and solution-building services in a team environment.
EXPERIENCE 
SUMMARY
Fifteen years of progressive experience in systems operations, administration, object-oriented analysis and design, data modeling and systems programming. 
Work style characterized by team-oriented problem-solving approach, acting as facilitator, innovator and mentor.
Technical style characterized by facile adoption of new tools, innovative designs, depth of analysis and rapid deployment of operational systems.
Background includes:
Application development, including logical and physical modeling, functional specifications, joint application design and review, rapid application development, regression testing, team leadership.
Database Administration in a multi-tiered state-wide data center woking with multiple operating systems (Windows NT, Unix) and three major DBMS engines (IBM DB2, Microsoft SQL Server, Sybase Adaptive Server). Application developer support and mentoring as well as serving as technical DBA for VLDB implementation in DB2. Directly responsible for ISAM-to-Sybase and Sybase-to-DB2 data migrations.
Development of a phone traffic data mart used in forecasting and troubleshooting a national long distance provider's network.
Start-to-finish development of a longitudinal cohort tracking and analysis system for an association of higher education researchers.
Object-oriented development of end-user OLAP software tools, including custom RQBE windows and interactive dynamic search data grids.
Development of cross-platform data and schema migration tools.
EXPERIENCE 3/1999 - Present

Texas Education Agency

 Austin, TX
Database Administrator (DB2, Sybase, SQL Server; Windows NT, Unix)
Technical DBA in implementation, tuning and maintenance of a VLDB deployed on IBM DB2. Performed various benchmarks (Java, Perl, shell scripts), provided proof-of-concept design and application design alternatives, assisted in trouble-shooting client-side connectivity problems, researched manual stored procedure creation and developed an array of monitoring tools for DB2.
Maintaining all aspects of state-wide data center. Duties involve database design, application review, developer assistance and mentoring, tool-writing, database maintenance, device managment, optimization, trouble shooting and emergency response.
Developer support:
Schema migrations and metadata-driven schema and data conversions (Sybase-to-DB2).
Proof-of-concept code samples (DB2, Sybase, MS SQL).
Real-time monitoring of database and application performance.
 
Tool development:
Windows NT network event monitor (Visual Basic).
A metadata-driven Sybase-to-DB2 migration toolset (Visual FoxPro).
Stored procedures in Java and Transact/SQL.
Sybase system utilities (Perl and Shell Script on AIX).
9/1998 - 3/1999
Texas Education Agency
 Austin, TX
Contract Programmer Analyst (Java)
Developed Java GUI and web applications, including applet screens, business objects and data access layer.
Additionally developed PERL CGI request spooler and related web application server.
9/1997 - 9/1998
Texas Education Agency
 Austin, TX
Contract Application Developer (Visual FoxPro)
Incremental Search Grid classes (Visual FoxPro). 
Interactive OLAP user windows. 
OLAP stored procedures (Sybase Transact SQL).
Metadata-driven data migration utilities (Visual FoxPro). Directly responsible for ISAM-to-Sybase data migrations.
10/1996 - 9/1997
McNeil Consumer Products
 Round Rock, TX
Contract Programmer Analyst (Delphi / Vis. FoxPro)
Wrote Delphi end-user applications for engineers and managers, replete with Windows MDI interfaces, inter-window messaging and incremental search grids. 
Built an intranet web site, fault-tolerant mail processing routines, and LAN analysis tools.
4/1995 - 5/1996
IXC Communications
 Austin, TX
Contract Programmer Analyst (Visual FoxPro)
Worked directly for the VP of Operations of a national long-distance phone company, involved in implementing and maintaining a variety of systems, including a data mining and data mart system which at the time saw 1 GB / day of throughput.
Wrote related decision-support systems and trouble management systems.
Work involved a fast turn-around development RAD cycles, including analysis of the BellCore LERG with development of incremental search grid technologies.
9/1993 - 6/1995
Brazosport College/Dallas County Community College
 Austin, TX / Lake Jackson, TX
Indpendent Consultant (FoxPro for Windows)
Developed the LONESTAR+ System for the LONESTAR (Longitudinal Evaluation, Student Tracking and Research) association of Texas Higher Education Researchers.
Start-to-Finish analysis and design, including requirements, design, logical model, reporting and deployment.
Full MDI Windows application, advanced GUI features, incremental search grids, custom calendar, customized RQBE reporting functions.
9/1993 - 6/1995
Texas Department of Health, WIC Program
 Austin, TX
Contract Programmer Analyst (FoxPro)
Developed intersite asynchronous data update communications system for 700 WIC clinics, their 70 regional offices and the state data center.
Developed Voucher Reconciliation data entry system, optimized for data entry ergonomics.
Summary of Previous Contracting and Work Experience (1985-1989)
Improved long-distance phone company's on-time billing cycle data processing (Wang VS 70).
Computer operator for Staples (VAX VMS) and Homes & Land Magazine (Unix).
PUBLISHED ARTICLES:
FoxTalk Magazine, Feb. 1995, "Improve Your Screens Using Non-Modal Validation." and May 1995, "Improve Your Screens With Hand-Built Spinners." 
These articles were two of the more advanced interface articles at that time. They demonstrated and explained the use of gotfocus-only GUI event handling as part of implementing rule-based object oriented systems. The second article focused on the construction of new GUI components within an object-based application language, including the subtleties of mouse-handling, pixel metrics and focus modality. The first article additionally demonstrated a non-modal calendar screen, which still sells as shareware source code.
SKILL MATRIX 
(for further information, please see the complete skill matrix for skillsets and years of experience)
Languages:
Java, Perl, Transact/SQL, SQL, Unix shell script, FoxPro, Pascal, Visual Basic, HTML, C.
Client-Sever Databases:
DB2, Sybase, Microsoft SQL Server 7
 
Operating systems and environments:
Windows NT, AIX (Unix), Linux, X-Windows.
Application Databases:
Xbase (Visual FoxPro), ADO, Borland BDE.
Development Tools:
IBM Visual Age for Java, Visual FoxPro, Visual Basic, Visual Studio.