TECHNICAL SKILLS:

HARDWARE / SOFTWARE KNOWLEDGE: IBM OS/390, IBM PC's, PC - Assembler, COBOL, VISUAL BASIC(3.0-6.0), NEON Shadow Direct, SQL, MQ Series, MICRO FOCUS COBOL, INTERTEST, JCL, XPEDITOR, REXX, Roscoe RPF, ASSEMBLER, REALIA COBOL, WINDOWS 95 thru Win 10, EASYTRIEVE, NOVELL, CICS, BTRIEVE, CMS, DATACOM/DB, DB2, QMF, SCRIPT, MVS, TSO, FTP, DTML, VM/CMS, JES3, JES2, VSAM, BASIC, PASCAL, ROSCOE, WYLBUR, DYL280, FILE-AID, TMON, SYSVIEW, OMEGAMON, SyncSort, IBM UTILITIES.

PROFESSIONAL EXPERIENCE:

Confidential, Gaithersburg, MD

D B2 DBA Database Administrator (DBA)

Responsibilities:

• Involved in complete lifecycle of databases, schema, planning and coordinating development, access strategies, security, and performance. Worked with the developers and end users in the design of the databases, business and mission requirements, testing, implementation, and post implementation validation. Provided on call support for production, testing, and development related issues concerning databases.
• The on call support required attention to detail and acute problem solving, production environment was very time and issue sensitive. Utilized various utilities and tools to test, create, monitor performance, and resolve issues with the databases. Assist the storage management group by providing data storage reports which predict the expansion of various databases so they can be maintenaned properly by providing them with sufficient storage space. Involved in testing and evaluating new technologies that would help increase performance and functionality for our DBA’s, developers, and end users.
• Support the communication between platforms between Z/OS and various AIX remote DB2 platforms. Provided verbal and written support for developers and end users to ensure their understanding of technical issues relating to their database and system Proved support for other government agencies in accessing and understanding various components of our system. Created and maintained many execs used by team to streamline and automate many functions required by team to support our required functions. Created various procedure documents for DBA’s, developers, and end users on various database issues. All of the above duties are performed on a state of the art Enterprise Class Mission Critical Data Center.

Confidential, Bethesda, MD

Consultant

Responsibilities:

• Analyzed system to explore the possibility of converting over to DB2. Senior Team Member involved in converting CA Datacom DB project over to DB2 version 8. Performed enhancements and problem resolution to system to ensure proper performance in support of end users and other automated systems. Used various tools and utilities (Intertest and CA Datacom DB tools) to troubleshoot and debug programs.

Confidential, Baltimore, MD

Consultant

Responsibilities:

• Provided technical expertise on client server application consisting of VB 6.0 on the client side with Cobol DB2 on server side. Coordinated migration of system from one data center to another. Set up all job streams used on mainframe OS/390 system. Created test scripts to simulate a full scale access of the database by many remote PC’s. Assisted rollout of multiple releases per year of software (client and server side). Performed performance tuning on system fixing all problem transactions and batch jobs. Central contact for developers with issues with DB2, COBOL, Neon Software, and VB. Maintained software developer’s utilities and tools.
• Designed and maintained software developers environment. Migrated DB2 from ver 5.0 to 6.0 then to 7.0 addressing all source code related issues. Participated in the design, development, implementation, and support of 2 MQ Series applications. The MQ projects were mission critical which required them to be running 24/7. The messages were passed between 3 IBM data centers running ZOS/390. Project senior technical member of the developing team providing guidance and technical help to all members of project. Assisted DBA with schema design, creation, testing, and debugging database. Conducted review of all major enhancements to applications.

Confidential, Montgomery Village, MD

Consultant

Responsibilities:

• The client utilized BMC’s DB2 Administrator and Utility Tools. Developed Visual Basic Recruiter software to track Client Job needs with available applicants. The VB application used MS Access as the database. The application consisted of 30 forms. Converted CA-Roscoe RPF scripts over to IBM REXX execs using DTML(Dialog Tag Markup Language), which is very similar to HTML. The Roscoe RPF’s where used as input screens for various production support personnel. Migrated client’s CA products over from ESA to OS/390 machine while bringing all CA products up to their current release level. This included such products as CA-1, CA-Top Secret, CA-Datacom/DB, and CA-Intertest. SMP/E was used to update CA products on OS/390 machine. Also assisted client with application testing of the OS/390 machine prior to going live. Worked on Client site as a CICS system programmer assisting the senior system programmer with maintenance, upgrages, and production support.

Confidential, Tysons Corner, VA

Consultant

Responsibilities:

• Developed Visual Basic application to track Help Desk trouble tickets. Developed Visual Basic application for payroll group which extracted data from the mainframe system and imported to MS Access database for analysis and manipulation. Developed Visual Basic Employee Personnel application to track employee’s vacation and sick leave usage.
• All VB applications used MS Access as the database. The VB applications ranged from 10 to 40 forms. Maintained Legacy Employee Time Entry System, consisting of Assembler Macro Level CICS and Cobol VSAM batch, for very large telecommunication company. Responsible for weekly and semi-monthly payroll commitment for 20,000 employees. Provided 24 hr on call support for payroll system. Involved in design of new system to replace Legacy system.

Confidential, Bethesda, MD

Project Leader Sr. Programmer Analyst

Responsibilities:

• System consists of CICS and Batch COBOL applications. Attended CSC Project Managers course. Modified system to be more efficient by making run-time performance enhancements. Met with various clients to go over system performance and enhancements. Was involved in new system design and implementation. Responsible for all technical personnel assigned to the NETCHARGE Project. Responsible for all equipment used by the NETCHARGE group (PC's Modems, Software, and etc.).

Confidential, Wash., D. C

Consultant Sr. Programmer Analyst

Responsibilities:

• Designed, developed, installed, trained, and maintained Micro Focus COBOL applications for the U.S. Customs Automated Mail Entry System (AMES). The system runs on 386 PC's under Novell Netware 3.11. Btrieve NLM was used as the database manager, (along with Xtrieve Plus). The application was developed to utilize dual file servers (in-sync), since AMES required a Novell SFT III fault tolerance type system, which was not yet available during time of development. AST 3780 and Barr/SNA RJE boards were used for communication with the mainframe. Developed related programs on the mainframe (Automated Broker Interface) to receive and transmit data to the Mail Entry sites. Installed various devices in PC's resolving all memory and interrupt conflicts.

Confidential, Wash., DC

Sr. Programmer Analyst

Responsibilities:

• Learned various database structures and gained valuable CICS experience. Customized database for various customers individual needs.

Confidential, Rockville, MD

Project Leader / Sr. Programmer Analyst

Responsibilities:

• Analyzed, modified, tested financial CICS application. Led small group in enhancement of application. Was responsible for analysis and testing of changes to system. The system consisted of 60% COBOL and 40% CICS programs. Increased my management and leadership skills during this period.

Confidential, San Francisco, CA

Programmer Analyst

Responsibilities:

• Analyzed, tested, debugged and modified new Route Accounting System. The system consisted of daily batch jobs, which produced various reports both on-line and hard copy. It also consisted of on-line maintenance and transaction processing. Modified and enhanced various COBOL and CICS COMMAND level programs. Increased skills in COBOL, VSAM, and JCL. Completed a SYS-ED course in CICS COMMAND level programming. Provided 24-hour production support.

Confidential, Oakland, CA

Programmer Analyst

Responsibilities:

• Developed, modified, tested, and debugged COBOL programs accessing VSAM files for back-order and add-on order systems. Enhanced and maintained numerous systems including Scheduling and Routing systems using COBOL, ASSEMBLER, and JCL. Participated in the design, coding, and implementation of a disposition of assets application, which monitored the closing of a division and provided status reporting to upper management. which provided productivity tools for the entire Applications Development Group. Developed strong COBOL, ASSEMBLER, VSAM, and JCL skills. Provided 24-hour production support.