Qualifications

• Over twenty five years experience in ADABAS database administration, project management, systems design, creation and distribution, and support of computer based software and database systems, with focus on ADABAS and Natural.
• Well versed in downsizing and conversion of legacy ADABAS/Natural applications to server platform.
• Extensive experience in the installation, tuning, and application of the ADABAS database management system and its use with Software AG's Natural programming language and other tools and languages.
• Well versed and experienced in the methodology/terminology of data replication data warehousing , especially from legacy ADABAS systems to relational targets such as Oracle, Sybase, SQL Server, and DB2.
• Extensive experience designing and writing system utility, communications, and end-user applications especially using ADABAS and the Natural programming language.
• High-level consulting experience in computer hardware and software, Client/Server technology, and web based applications.
• User support experience including hardware and software installation, troubleshooting and tuning of systems software.
• Teaching experience including class authorship, conducting formal and informal training sessions, and giving presentations.
• Broad knowledge of computer hardware and architecture, especially legacy systems on the IBM mainframe and their conversion to n-Tier and Client/Server distributed systems.
• Experience tying together heterogeneous data sources.
• Successfully ran computer consulting business for over eleven years.

Professional Experience

Confidential

Hired to work as contract ADABAS database administrator for the Bureau of Indian Affairs BIA . Responsible for maintaining BIA ADABAS databases and Natural applications on IBM mainframe and Microsoft 2008 R2 Server platforms related to the National Irrigation Information Management System NIIMS application and its associated subsystems. Maintain and configure Natural application software release control, ADABAS utilities, application and system security Security Point Of Contact , batch JCL and batch scheduling with Control-M, Windows Scheduler, application software migration, application software upgrades, application tuning and performance. Design and implement new files and structures in ADABAS and Natural. Configure and upgrade existing files and table structures. Evaluate, design, and implement system specifications. Update application documentation. Ensure site standards are followed. Provide technical assistance to application programmers, end-users, and system accountants. In charge of referring debt to treasury on a monthly basis. Diagnose problems. Write fixes and upgrades for NIIMS using Natural programming language. Utilize ADABAS utilities for database configuration and management. In charge of continuity of operations disaster recovery testing for NIIMS. Researched and wrote design specifications for future migration of NIIMS to other, downsized platforms Windows server . Successfully migrated legacy ADABAS/Natural application from IBM mainframe to Windows server saving the BIA agency over a million dollars per year in service fees. Rewrote legacy JCL into .bat scripts for Windows. Installed and configured Apache Tomcat utilizing Natural for Ajax. Performed web enablement of legacy ADABAS/Natural applications using Natural for Ajax and Apache Tomcat. Configure and maintain ADABAS/Natural and subsystems software on Windows 2008 R2 server platform.

Confidential

Hired to work as contractor in the DOI National Business Center mainframe operations center performing systems software support for all Software AG related systems software and IBM mainframe for FPPS, and hosted BIA trust partitions. Required to make system software upgrades to ADABAS and Natural along with all related subsystems and communications software. Diagnosed systems related problems for FPPS. Configured and performed continuity of operations testing for FPPS and BIA as related to ADABAS, Natural, and Com-plete. Setup and configured restart and recovery jobs for ADABAS. Configured and ran ADABAS and Natural utilities. Applied fixes and upgrades. Wrote, installed, and configured special user exits for Natural and ADABAS. Configured, installed, and ran data extraction utilities for change data capture from ADABAS to Oracle warehouse.

Confidential

Hired to work with the Federal Government, Department of the Interior DOI , to design and build a VB.net graphic user interface GUI for an existing legacy application written in Natural/ADABAS that accounts for water irrigation management for the Bureau of Indian Affairs. Wrote recommendations on possible fat and thin client architectures for new GUI. Made recommendations on best approach based on client's restrictive trust environment. Perform extensive analysis of existing systems utilizing Natural Engineer, and through reading of Natural code and systems. Isolate and remove business and data access layers into callable components. Construct new GUI presentation layer written in VB.net utilizing Software AG's Entire Network, and RPC Server to access business and data layers. Required to help with end-user support of existing system. Write new functionality to existing Natural based system using Natural programming language. Perform ADABAS and Natural systems administration using ADABAS Online Services, Predict, and Natural Security. Function as N2O Administrator.

Confidential

Systems Consultant/Contract Programming Services

Designed and wrote a data replication product DPS for Treehouse Software Inc. for data warehousing from non-relational database technology ADABAS to relational systems including Sybase, Oracle, MS SQL Server, and DB2. Wrote profiling and performance product Profiler for Treehouse Software Inc. designed to function with Software AG's Natural 4thGL. Provided high-level consulting services to Software AG clientele such as Southwest Airlines, Morgan Stanley, and the State of Washington especially in relation to replication and migration of ADABAS data to relational systems such as Oracle, and SQL Server. Hired by Software AG to design and write various utilities and diagnostics aids for ADABAS including the abnormal termination exit used by the ADABAS nucleus. Designed and wrote custom applications and utilities utilizing ADABAS/Natural, IBM Mainframe Assembler, MS Visual Basic, Access, MS SQL Server, Oracle, and Borland's Delphi language. Converted numerous legacy applications from IBM mainframe to PC based client-server/n-Tier systems including VSAM and CICS based systems for State of Colorado. Designed and wrote Window's based technical support systems for problem tracking and resolution. Designed and wrote accounting systems, order entry systems, inventory control systems, and driver's license inquiry systems for the State of Colorado utilizing SQL Server and MS VB/Access. Taught professional HTML/JavaScript, and web server administration classes. Experience interfacing with IBM iSeries AS/400 data server. Some experience with the MS C .net environment.

Confidential

Senior Technical Advisor

• Advised on technical issues and planning concerning Software AG's product line including ADABAS/Natural, network communications and Client/Server technology. Offered unique business solutions for computer based systems to Software AG clientele specializing in ADABAS/Natural. Installed new releases of Software AG software, wrote customized software/utilities, performed demonstrations, gave technical presentations to both Software AG employees and Software AG clientele, and provided technical advice/service in relation to Software AG and its product line. Performed DBA services with ADABAS. Traveled to Software AG client sites and worked one-on-one with ADABAS DBAs teaching how best to setup, tune, and use
• ADABAS and its related systems and software including the Natural programming environment. Responded to critical problems and/or high-profile customers such as Delta Airlines, Morgan Stanley, US Sprint, MCI, The Los Angeles Times, with on-site
• visits. Wrote various debugging/analysis utilities and custom software for Software AG and Software AG clients utilizing Natural and ADABAS. Worked extensively supporting Natural, ADABAS and Network communications. Ensured timely technical solutions to problems with any and all Software AG software. Developed compiler and utility software in C and mainframe assembler especially for use with ADABAS.

Confidential

Systems Analyst

Managed design/development of new freight billing system written in ADABAS/Natural. In charge of all phases of database file design, program design, and coding of new software systems. Also performed maintenance on old IBM 370 CICS assembler and COBOL programs and systems. Performed maintenance on legacy VSAM based systems.

Confidential

Programmer/Analyst

Worked enhancing existing Manufacturing Resource Planning system MRP written in COBOL on IBM mainframe. In charge of developing/integrating bar coding hardware and software for use with MRP system. Also wrote numerous IBM mainframe CICS COBOL applications. Granted DOE Q clearance.

Confidential

Research Assistant

• Designed and built apparatus to model/simulate convection of heat within a geothermal wellbore. Wrote modeling/simulation software in Fortran and conducted experiments to determine heat transfer by convection within fluids. Published results in several scientific journals. Granted DOE Q clearance.
• Software Knowledge
• Experience designing and writing applications, utility, and communications software utilizing ADABAS/Natural, IBM Mainframe Assembler, MS VB.net and Access with MS SQL Server, Borland's Delphi, COBOL and COBOL II, C, C , CICS, VSAM, Oracle, Sybase, and DB2.
• Experience developing Web based applications utilizing HTML/JavaScript, WebSphere, Lotus Domino Server/Notes, OS/400, and IBM Client Access.
• Experience with MS C .net environment.
• Extensive experience with Windows 2008 R2 Server Platform.
• Extensive experience with IBM mainframe systems, and systems software and databases. Experience with AS/400 environment.