John E. Black II

5773 Reagan Dr.

Fontana, CA 92336

(909) 922 - 5367

EDUCATION: A.B.T. Data Processing, Rose State College, Oklahoma

TECHNICAL SUMMARY:

Twenty-five years experience in the Data Processing field knowledge has been gained in the area of database usage and design. Programming, both maintenance and new code, hardware trouble-shooting, technical support, and a strong operations background have been acquired. Systems used have included Windows 3.1, 98, NT, XP, Unix, IBM 30XX, MVS/ESA, XA, OS/390; Sysplex; JES2/JES3, NATURAL SECURITY; NETPASS; COM-PLETE; CICS; IMS DB/DC; MQ; EDI X12, Microsoft Office Suite, FileAid, File Manager, ChangeMan, Teradata, and PREDICT.

Programming languages include Websphere, Visual Basic 6.0, Visual Studio .net, ACCESS, VisualAge for Java, J2EE, MultiLoad, FastLoad, BTEQ, ITEQ, NATURAL 1, 2, & 3, CONSTRUCT, DB2, ADABAS, DB2 Utilities, Perl, FTP, TELON, COBOL, and COBOL2. Responsibilities include SDLC. Both batch and on-line systems have been completed.

Managerial experience also acquired and trained in the following Project Management Methodologies: Agile, Waterfall, Hyperion Essbase, MKS SDLC, and Martin Tate.

CERTIFICATIONS:

Windows XP 2003

Windows NT 1998

J2EE Development using Websphere Developer IE v5.0 5/2003

SAG Natural 2 Advance Programming 5/1990

SAG Complete Concepts and Facilities5/1990

SAG Adabas 2/1990

Data Kinetics tableBASE 3/1990

IBM DB2 2/1995

EXPERIENCE:

September 1993 to Present Burlington Northern Santa Fe Railway

_______________________________________________________________________

Consultant / Consulting Manager

Provide 24/7 support for all applications involved in.

Design, code, implement, and support for new WebSphere applications accessing legacy systems data on mainframe DB2 platform. Full life cycle implementing SOA process into legacy processing.

Experience with setting up and administrating small network on NT and XP platforms.

Responsible for the development of J2EE application to make communication between web application and mainframe possible. Developed JAVA process using IMS Connect under J2EE. This process was then the basis for many other applications to interface with the mainframe. Analyzed mainframe code and presentation layer to determine best approach for implementation into a browser environment. Coded, tested, and supported programs with API wrapping applied.

Leadership role in successful merger of two major companies and the consolidation of the computer systems.

Design, code, implement, and support for legacy systems using Natural for DB2 under IMS. Provide technical guidance for other teams in support of other systems, as well as provide support and code for third party software packages to access DB2 data, support and develop JCL for batch processing. Provide performance support for Natural applications.

Analyze and design files to be normalized from the DB2 legacy system to the Data Warehouse. Implement the file design and indexing to assure proper dispersment across the system. Create ETL process from DB2 to Data Warehouse system. Write MultiLoad/FastLoad data into the Data Warehouse. Analyze current processes with the Data Warehouse for performance enhancements.

Responsible for creating ETL process to extract DB2 data, FTP file to PC’s and servers, then load into ACCESS database. Created ACCESS database with code to support refreshing data, printing, faxing, and prompting for search criteria. Created forms and reports for presentation.

Analyze and code changes to programs, adding fields and updating file accesses. Implementing changes in NATURAL code under IMS using DB2 and Adabas. Design, analysis, creating new code was also done. Design and implement file design and programs to maintain and illustrate Data Base Design and usage in an Enterprise Model of all files and Databases. Used Cobol II, and DB2 to implement system on the Data Warehouse. Assist Database Administration Staff on special project to initially build and load the Data Warehouse. Design and Analysis of Databases, and write programs and use utilities to initially populate the Databases.

Cross team knowledge gained of existing systems over the years. Experience working with various teams and also with external customers, including U.S. Customs, ORIES, and Coal companies, Accounting Department.

July 1992 to September 1993 Department of Defense

__________________________________________________________________________________________

Systems Analyst / Site Manager

Systems Analyst responsible for the design and analysis of the CARNAC System. The State of Arizona, Department of Public Safety working with Criminal Intelligence System. Most of the coding and documentation being done using Natural 2.2, TSO, and PREDICT under CICS. Responsible also for file design and usage specifications using PREDICT.

January 1992 to July 1992 Price Waterhouse

____________________________________________________________________________________________

Systems Analyst / Team Lead

Systems Analyst responsible for the design and analysis of the DORIS System. The State of Wyoming, Department of Revenue Information System handling both Tax items and Mineral work as well. Most of the coding and documentation being done using Natural 2.1 and Natural 2.2, Construct, and PREDICT under CICS. Responsible also for file design and usage specifications using PREDICT. Shared managing of a team of 20 developers and documenters.

July 1991 to December 1991 Farah Jewelry, Los Angeles, CA

Project Manager

Project Manager of Farah Jewelry System. Responsible for the design, analysis, coding, implementation, and production support of system for a Wholesale, Retail Jewelry Store.

This project involved use of an IBM compatible with many software products including Norton’s Utilities, BASIC, MS-DOS, and other utilities.