High School Sql Server

Lawrence Harwell, Jr.

***** **** ***** ****.

Austin, TX 78753

CELL: 512-***-****

HOME: 512-***-****

Email: ***************@*******.***

OBJECTIVE: Secure a challenging position as a Programmer/Analyst, Systems Architect, utilizing my strong and varied computer software and hardware abilities.

EDUCATION: Marquette University, Milwaukee, WI Dominican High School, Milwaukee, WI

B.S. Degree, Computer Science, Graduated – December, 1986 High School Diploma, Graduated - May, 1982

HARDWARE: IBM IDZ/RDZ/RPP,, IBM 3090, IBM 370, IBM S/36, DEC VAX 11/780, Mac, PC

SOFTWARE: IMS, IDMS, DB2, MVS/TSO/ISPF, JCL, DCL, JES2, JES3, VM/ESA, DOS/VSE, EDI, CICS,MS SQL SERVER, SPUFI,QMF

Lotus Notes, Telon, Endeavor, Dylakor, Easytrieve, SPF/PC, VSAM, CA-7 Scheduler

Panvelet, Xpeditor, Simon, File-AID, Changeman, CA7, CA-IDEAL, CA-DATACOM/DB Xedit, CMS, FAQS, Novell Netware,

Rational Rose, Erwin, SQL Server 7, 2000, Word, Power Point, Excel,, Natural

OS: IBM IDZ/RDZ/RPP MVS/ZOS, TSO, DOS/VSE, CICS, MS DOS, CMS, OS/2, & Windows 95 / NT / 98 / 2000 / XP / Windows 7,10

LANGUAGES: PL/SQL Developer, SQL, COBOL, COBOL II, JCL, DCL, Pascal, Visual Basic, ABAP/4, JAVA, MicroFocus Enterprise Server,

COBOL

Data Base: IMS DB/DC, DB2, VSAM, CICS, Oracle, MicroSoft Access. MQ, Weblogic

EXPERIENCE

10/3/23 – 05/15/24 Mainframe Analyst/Developer

IBM Contractor thru Zeniuscorp.com

Production Support for US government @ RRB.GOV, Mainframe and CICS systems

Support for JCL,COBOL batch, and DB2® for, US government@ RRB.GOV, Mainframe and CICS systems

Develop and, test batch streams of JCL executing COBOL code using my expertise in TSO/ISPF, JCL and COBOL, Endevor Repository, DB2, VSAM

Develop and test batch streams of JCL executing COBOL code for US government, Railroad Retirement Board, Medicare Billing Application,

AZURE Dev Ops methodology used to track daily accomplishments

12/6/22 – 04/14/23 Mainframe Developer – Cognizant/ Cigna

Develop COBOL programs w/ embedded DB2. accessing DB2 data bases.

Interactive access to z/OS® systems IMS screens, running under CICS regions

Support for JCL,COBOL batch, and DB2 for Client

Test large Cobol programs using Expeditor in CICS region

Agile methodology

5/6/22 – 12/06/22 Mainframe Developer – Wipro / Charles Schwab - end client

Develop COBOL programs w/ embedded DB2. accessing DB2 data bases.

Prepare COBOL code to migrate to Unix Platform

Interactive access to z/OS® systems IMS screens, running under CICS regions

Support for JCL,COBOL batch, and DB2® for Client

5/7/2019 – 6/25/21 Mainframe Analyst/Developer – South West Gas Company – Las Vegas, Nevada

Development/Support of COBOL based programs w/ embedded DB2. executing IMS, and accessing DB2 data bases, CICS skillset

Interactive access to z/OS® systems IMS screens, running under CICS regions

Develop and test batch streams of JCL executing COBOL code for company Billing Application

Support for IMS, CICS®, JCL,COBOL batch, and DB2® for SWG’s Customer Support System

Support of application servers that use GUI front ends to access Mainframe CSS system

1/7/2013 – 2/10/2019 Mainframe /Developer – General Motors - Austin, Texas

1/7/2017 – 2/10/2019 Mainframe Architect/Developer – General Motors – Austin.

Mainframe Modernization:

Using IBM’s, IBM® Developer for z Systems® Mainframe Modernization tool, design, develop, and test mainframe software, deploy enhancements for GM Logistic applications, Web, and composite applications. IBM Developer for z Systems provides a common workbench and tools for Design Development and Deployment

Development of COBOL,DB2, PL/I,, high-level assembler, Java™ and Web Services programs

Interactive access to z/OS® systems

Integration with GM’s repositories, using Rational Team Concert, and the IBM Z Development and Test Environment.

Support for IMS, IDMS, CICS®, Batch, and DB2® stored procedures, application servers

1/7/2013 – 1-7-17 Mainframe /Developer – General Motors – Austin, Texas

Reengineered multiple systems that fueled improvements to productivity, efficiency, uptime and accuracy for global business operations. Developed code using IBM (RPP), system design and test/QA plans for all solutions and often coordinated the national or international rollout

Led, architected and participated in the design, testing and deployment and documentation of International Mainframe applications

Using expertise in IMS,CICS,DB2,TSO,RPP

Involved in all aspects of the product development lifecycle such as business requirements, functional specifications, architectural specifications, development, test plans, and documentation).

Performed on-call duty, supporting QA testing by providing document, program testing results, system flows and setup testing data.

Responsible for assisting off-shore developers in batch stream execution and a brief training to help them get acquainted with the VTIMS batch and On-line processing.

Attend the client meetings or conference calls with the Project Manager to understand the requirements of the project and explain the same to the junior programmers

Trained and mentored junior programmers in programming methodologies and best practices

2/14/2012 – 1/7/2013 Mainframe Developer – Experis/Kohls Department Stores - Milwaukee, WI

Maintain and support Kohl’s Merchandise Replenishment system using expertise in COBOL/JCL, SQL and DB2

Provide Lead role for testing of old and new system using expertise in COBOL/JCL, PL/SQL and Oracle

PL/SQL Developer used to query specific tables for analysis and data validation of Oracle Db used by UI.

PLATINUM,QMF and Spufi used to query specific tables for analysis and data validation of DB2 table modifications by COBOL/Batch JCL and Online modules

Identify, troubleshoot and resolve application issues and code defects of Oracle based applications, MPX, DB2, Mainframe and CICS systems

Develop and test batch streams of JCL executing COBOL code using my expertise in TSO/ISPF, JCL and COBOL

Develop and test batch streams of JCL executing COBOL code for Kohls Billing Application

Responsible for assisting off-shore developers in batch stream execution and a brief training to help them get acquainted with the Kohl’s MR(Merchandise Replenishment) batch processing. These programs use MQ and Websphere logic

Attend the client meetings or conference calls with the Project Manager to understand the requirements of the project and explain the same to the junior programmers

Attended two classes to become familiar with Computer Associates (CA) Repository for z/OS and All Fusion Repository.

3/01/2010- 2/14/2012 Mainframe Developer – Capital Computers/TDS Telecommunications - Madison, WI

Assist in the development and installation of an Oracle based system being converted, MicroFocus to COBOL/DB2 to Oracle

Develop and test batch streams of JCL executing COBOL code using my expertise in TSO/ISPF, JCL, COBOL and CICS systems

Setup test environments for testing and comparison of old Focus system vs new Oracle system after migration

Using Benthic Software create test environments so that PL/SQL code would access specific tables for report comparison

Using Benthic Software, Golden, PLEdit, build test environments for testing of PL/SQL packages and stored procedures

Provide Lead role for testing of old and new system using expertise in COBOL/JCL, PL/SQL and Oracle

identify, troubleshoot and resolve application issues and code defects of Oracle and Mainframe systems

Code, unit test and promote into production COBOL applications

Attend two week FOCUS class in order to manipulate FOCUS programs

5/09 –12/31/2010 IT Specialist - Relevant Instruction for Successful Employment (RISE) - Milwaukee, WI

Manage all computer related functionality of RISE network using XP/Windows 7/Vista Operating Systems

Install, configure and support RISE servers and networked PC’s

Ensure all registry and Operating System problems are corrected in a timely manner

Provide PC and network support, including PC setup, software installation and upgrades

Create web page for global access to RISE applications

Design and code and support Visual Basic and Microsoft Access applications using SQL

Install and support hardware and software for all RISE offices

Identify, troubleshoot and resolve application issues and code defects

Teach RISE personnel and clients to efficiently use PC applications including Microsoft Office software

12/00 –5/09 Mainframe Logistics Software Developer - Optimal Solutions, Irvine TX,

Client: State of Wisconsin, Depart of Work Force Commission, (Un-Employment Compensation)

Converted large amounts of DB/2 data on the IBM Mainframe to an Oracle Database using PL/SQL

Develop and support complex multi-user software information systems written in Natural

Coded 90/% new COBOL development due to complex DB/2 data retrieval in an IBM 30xx Mainframe environment

Completed COBOL project specifications for payroll applications accessing DB2 & IMS databases: COBOL w/ embedded SQL

Wrote COBOL modules written from scratch were used to retrieve, reformat and transform data to be loaded into Oracle, proficiencies in IDMS, CICS, COBOL, JCL, TSO/ISPF and SQL were used in an IBM 3090 Mainframe platform

Assisted in the development, installation and documentation of IBM Mainframe systems, CA7 Scheduler

Supported COBOL/CICS applications and develop new COBOL/CICS applications fixes when necessary

Supported client server applications, DOS/VSE JCL and IBM MVS mainframe applications

Developed website and graphic design projects. Using Java and Websphere, reporting done using Crystal Reports

Designed SQL and relational databases using MS SQL Server.

Implemented n-tier, database-driven, web-based business applications in a strong object-oriented environment using Visual Studio., Visual Basic 6.0, ASP and XML, C and C++ (over two years’ experience), some MicroFocus COBOL support work

5/99 – 12/00 Consultant /Software Engineer - Manpower International/Manpower Professional, Milwaukee, WI

Supported Manpower Payroll application, “MIDAS”, executing in a DOS/VSE Mainframe environment utilizing JCL expertise

Completed COBOL project specifications for payroll applications accessing DB2 & IMS databases: COBOL w/ embedded SQL

Provided team assistance in the coding, development, testing, and installation of IBM Mainframe applications.

Completed Visual Basic code specifications, test, document and install Visual Basic application

Installed communications equipment and terminals for network access

Provided problem determination and resolution of online and nightly batch automation that fails

9/98 – 5/99 Year 2000 Renovator/Tester/Remediator - Stopka and Associates, Milwaukee, WI

Supported all Roundy's RAPS, (Roundy's Application Purchasing System), COBOL/CICS applications

Performed Y2K Inventory, Assessment, Renovation and Y2K compliance testing of RAPS, using JCL

Supported Roundy's online and batch order entry IBM Mainframe applications using TSO/ISPF and CICS

Completed COBOL Y2K project specifications in both DOS/VSE and IBM MVS mainframe environment

Provided assistance in the development, installation and documentation of IBM mainframe systems that accessed DB2 and IMS data structures

5/98 - 9/98 Systems Architect - DMR Consulting, Kansas City, KS

•Supported Sprint COBOL online and batch order entry VAX applications using DCL accessing DB2 data base information

•Supported Sprint online and batch Order Entry, IBM Mainframe applications using TSO/ISPF; utilized JCL to execute COBOL code

•Performed Y2K Inventory, Assessment, and Renovation of Sprint order entry system that was run on DEC VAX system

•Completed project specifications for front-end Visual Basic applications that displayed order entry screens

•Installed communications equipment and computer workstations to promote to SQL/SERVER access

•Assisted in the development and installation of on-line and batch DEC mainframe COBOL systems

10/97 - 5/98 Independent Consulting Software Engineer/Network Engineer, Milwaukee, WI

•Networked 12 personal computers for private video store owner using Novell

•Created web page for Vicks Video stores using HTML and JAVA

•Configured PC's after conversion of operating system, from 3.1 to Windows 95/98

•Designed and coded Visual Basic application to track stores' inventory, application accessed ACCESS databases

•Designed Microsoft Access databases for easy access to customer, employee and SALES information

12/96 - 10/97 Consultant @ Miller Brewing Co. - Keane Inc, Milwaukee, WI

•Supported all of the Marketing IBM mainframe batch applications written in COBOL executing in a MVS/390 environment

•Supported Marketing Divisions’ COBOL applications that accessed DB2 and IMS databases

•Supported all Client/Server Visual Basic applications

•Completed project specifications for new and existing Visual Basic applications utilizing DLL’s to retrieve DB2 information

•Provided user problem determination and user resolutions when the software fails at the user workstation

•Installed user workstations throughout client site

Consultant @ North Western Mutual Life Insurance Co., - Keane Inc., Milwaukee, WI

•Primary support person for Field Financial Departments’ COBOL applications that used embedded SQL to access DB2 databases

•Support all Client/Server Visual Basic applications, also supported application that accessed IMS databases

•Support all of the Field Financials' IBM mainframe batch applications written in PL/1

•Complete project specifications for new and existing Visual Basic applications

•Provide technical assistance to computer operations personnel

7/94 - 12/96 Technical Specialist I - Baxter Health Care, Waukegan, IL

•Attended twelve day SAP ABAP/4 programmer training class

•Collaborated in a five-member team environment, develop the conceptual, logical, functional, technical and detailed designs for a bolt-on to a future Baxter SAP system

•Developed preliminary dynpros for a Deal Maintenance application

Senior Programmer/Analyst - Baxter Health Care, Waukegan, IL

•Attended Visual Basic and Advanced Visual Basic programming class

•Tested DOS/VSE Job Control Language (JCL) to ensure smooth stream execution

•Created design documents and gather user requirements for VB Customer Contract application

•Prepared and delegate Detailed Program Specifications for subordinate employees

•Utilized Visual Basic software as a front end accessing Access Database to perform via LAN or RAS with third party controls (SPREAD, DATE, controls) in application and utilized Crystal Reports via DDE and Excel Chart 5.0 via OLE with several complex forms to allow viewing and editing customer contracts

•Primary responsibilities include COBOL and MicroFocus COBOL new development and support

7/93 - 7/94 Consultant @ Baxter Health Care - TEK, Downers Grove, IL

•Design various new COBOL programs using Arthur Andersen Design methodology

•Create functional and technical Designs of new COBOL programs and their budget estimates using Arthur Andersen Design Method/1, MicroFocus COBOL new development and implementation

•Evaluate and recommend future changes to existing systems that accessed IMS & DB2 databases

•Research and produce solutions for batch and on-line system failures

4/92 - 7/93 Independent Consulting Software Engineer/Network Engineer, Milwaukee, WI

•Placed "Services Offered" ads in periodicals for computer services

•Produced documents, leaflets and invitations for social gatherings

•Wrote general purpose programs for use on the PC in Quick Basic

•Taught Lotus and MS Excel

•Installed retail software, modems and tape drives

•Taught more efficiently use of DOS and OS/2 operating system

9/91 - 4/92 Consultant @ CASE, Racine, WI - Strategem, Milwaukee, WI

•Converted in-house loan monitoring system in a DOS/VSE mainframe environment

•Modified existing IMS programs and screens using Telon

•Attend two week class to become familiar with ZOS -ZVM.

•Performed integration testing on new loan monitoring system

12/86 - 9/91 Programmer/Analyst A - JCPenney Co., Milwaukee, WI

•Participated in the design, development and installation of an on-line, DB2, Relational Database system

•Complete project specifications for new and existing DOS/VSE and IBM MVS applications

•Attended group conferences when users define new project specifications and system changes

•Assisted in analyzing and developing data processing systems and instruct operators in system installation procedures

•Researched and produced immediate solutions for an on-line system failures

Programmer/Analyst B - JCPenney Co., Milwaukee, WI

•Coded, installed, documented and maintained data warehousing application accessing DB2 and IMS databases

•Develop and support complex multi-user software information systems written in Natural

•Provided assistance in the design development, installation and documentation of on-line and batch systems

•Attended classes to acquire knowledge of IBM utility updates and learn to use major IBM utilities and software: Dylakor, Easytrieve, Panvalet, Endeavor, Xpeditor, File-Aid, Abend-Aid, Changeman

•Provided problem determination and resolution of all nightly batch COBOL and Micro focus COBOL stream automation that failed

Contact this candidate