Alfred Lawson

  • Mainframe Developer
  • Southfield, MI
  • Member Since Jun 14, 2023

Candidates About

 

Alfred Lawson

OBJECTIVE                    Sr. Mainframe Developer or Analyst (w/J2EE & Big Data interest)

TARGET JOB         Desired Job Type:      Employee/Contract

                                    Desired Status:             Full-Time

 

                                    Desired Salary:             Negotiable

 

                                    Site Location:                 Detroit Metro Area

 

SUMMARY           I am a Senior Application Developer with strong mainframe application

and systems integration experience, across large complex enterprise

systems. For 20+ years I have demonstrated best-practice development

skills in the following industries:

 

automotive manufacturing • banking • auto insurance • retail • healthcare •

sales & marketing and prescriptions

 

I have used methodologies based on industry standards and tailored these to fit the clients' environment. I ‘ve worked with the System Development Life Cycle (SDLC); Classical and Unified Solution Delivery Methodology (SDM) and FORD Agile Framework (FAF).  I have worked on multiple projects at once and have worked on a team(local or global), but can work independently. I communicate effectively with internal and external customers both orally and in writing.

 

                                                               

Key skills            Mainframe COBOL; DB2; IMS DB/DC; CICS; J2EE; Micro Focus

                   COBOL; ETL; EDI; Expediter; SDLC; ITS; SQL; JSP; JAVA Scripts;

                   Servlets; EJB; JAVA(1.5yr); JCL; TSO; ChangeMan; MSOffice;

                  ENDEVOR; CA7; VSAM; QMF; SPUFI; IMS/CONNECT; PUPS; XML;

                  Sharepoint; File Manager; DEBUGGER; Classical and Unified SDM; 

                  AGILE; SOX; MQ Series; FAF; CICS Explorer; RALLY; Abend-Aid;

                  Legacy FOCUS

 

Key courses

and training                       JAVA; NASCO; Interplan Teleprocessing System(ITS); Oracle;

                                Big Data(IBM); LINUX; WebFOCUS; DataStage

 

Knowledgeable NASCO; Teradata

 

 

 

 

 

 

 

 

Professional experience

EXPERIENCE         01/2017 –  Present        Job search and training

                                                                           Training:  WebFOCUS; DataStage;

                                                                                           LINUX; Oracle and Teradata

 

                                 10/2015 – 01/2017                    STG, INC     Southfield, MI

                                                                             Application Management Analyst (AM)

                                       Order Management System(OMS)/Single Order Bank(SOB)/ Single Order Edit(SOE)

 

                                       FORD MOTOR Company

 

OMS receives and controls product and non-product-related  order changes. SOB is a common

order repository to support North American Order Management and SOE allows business  rule

lookup, creation and maintenance via online JAVA .

 

I provided production support to OMS/SOB and monitored and reported SOE processing errors

and delays.  I also Investigated the root cause of data errors that made applications abend. 

My responsibilities included

 

                                                • Analyze  business  and  technical processes via tech specs, reports and online screens

                                                • Provide 24/7 production pager support to OMS/SOB

                                                  Supported job abends and incident resolutions utilizing BMC Service Desk

                                                  Processed Non-Standard Run Request (NSRR) coming from the applications to

                                                    perform JCL Cancels, Force Completes, Restarts, Demands within the CA7 environment

                                                  Reviewed and approved tech specs for any change  made in the system

                                                  Performed Program components and JCL maintenance and migration reviews for

                                                     Manufacturing/Assembly plant launches or decommissions.

                                                  Make sure all changes and documentation meet FORD standards and SOX compliant

                                                  Prepare eTrackers and Request tickets for system incidents where necessary

                                                  Documented system and data flows

                                                  Ran DBCRs to release table locks and provided the proper documentation

                                                  Prepared SQL for investigative purposes

                                                  Prepared instructional documentation

                                                  • Communicated well with Team

 

 

               

                       03/2015 – 07/2015                      CIBER, INC                 Southfield, MI

Mainframe Developer Consultant / Expert - Worldwide Engineering Release System

                                                                            (W.E.R.S.)

                                       FORD MOTOR Company

 

I worked on the Application Development (AD) side of IT. I was part of a team that used Ford

Agile Framework (a process based on Agile principles) to develop the new Automated File Set

Up (AFSU) project.  All activities were tracked using RALLY. 

My responsibility included

 

                                                • Analyzing, designing, developing and implementing application code supporting the WERS

                                                    AFSU project using  COBOL, SQL, DB2, IMS and TSO

                                                • Read XML Replace/Replace-by data to populate IMS databases

                                                  Pass back message to calling program to Add, Insert or Copy a Notice Function

                                                  Trigger Notice Build process using MQ Series input passed from the BOMF team

                                                  Documented and set up test cases

                                                  Documented system and data flow

 

                                 08/2010 – 03/2015                    IBM, Michigan Distribution Center(MDC) - Lansing

                                                Sr. Application Developer

 

                                                • Worked with a client to understand and write requirements

                                                • Analyzed existing MF systems

                                                  Impact analysis

                                                  Designed and developed  new code to support various change requests

                                                • Created high level design documents(HLD) and low level design documents (LLD)

                                                • Unit tested all changes

                                                • Handled defects and responded with fixes

                                                • Documented changes

                                                • Develop into an Subject Matter Expert(S.M.E.) as projects are worked on

                                                • Completed projects on time

 

 

                                                08/2011 - 10/2014        IBM  -  Major Insurance Firm (AMICA)

 

                                                Project Description:The AMICA account is a very large insurance account that deals with

                                                                                  managing Insurance products (HOME, AUTO ,Motorcycle, Ocean

                                                                                  Marine and Life to name a few) regulated by state. Product(s) are released

                                                                                  monthly and policies are tested in the form of ‘COMBOs’ to assure that

                                                                                  new changes are working and no other process is affected.

 

                                                • Interpret requirements

                                                • Created Technical Specification design documents (TSD)

                                                • Modified existing programs

                                                • Unit tested all changes

                                                • Introduced a process which aided team to complete tasks 50% 

                                                • Handled defects and responded with fixes

                                                • Documented changes

                                                • Develop into an Subject Matter Expert(S.M.E.) as projects are worked on

                                                Complete projects in a timely manner

                                                • Received Client Value Award 

 

 

                                                08/2010 - 08/2011        IBM - (Express Scripts (ESI) Prescriptions and Medicare/Medicaid

 

                                                Project Description: The Express Scripts account is a very large account that deals with

                                                                                   managing healthcare through Prescription drugs. Medicare and Medicaid

                                                                                   are huge parts of this account. Through regulatory and compliance issues, as

                                                                                   well as code enhancements, the task was to incorporate changes into

                                                                                   Express Scripts software. ESI has very aggressive release schedules, with

                                                                                   releases of various ‘projects’ each month. Projects responsible for Diabetic

                                                                       Ace;  Medicare Coverage Gap; PA Identifiers and AWP-CBA Assignments

 

                                                • Worked with ESI to understand and write requirements

                                                Created high level design documents(HLD) and low level design documents (LLD)

                                                • Wrote new programs and/or modified existing programs using the Micro Focus

                                                  •  Transferred and updated  CICS and  BATCH programs using the Micro Focus

                                                • Unit tested all changes using the Micro Focus tool

                                                • Handled defects and responded with fixes for warranty periods

                                                • Data analysis using FileAid; JOBSCANS; Xpediter and Micro Focus

 

                                   1/2009 – 08/2010                               Job search

 

                                   6/2007 – 12/2008                               JAWOOD      Troy, MI

 

Sr. Developer Consultant  / ITS and FACILITY Claims Processing

                                                     Blue Cross Blue Shield of Michigan (BCBSM) - Healthcare

 

Documented the Software Architecture Document (SAD) for NASCO and ITS release 10.0; 10.1

and 10.2. (These releases effected large complex COBOL mainframe systems using ENDEVOR

for change control. The changes were to add a POA indicator, reformat the Seq-Num, allow future

dated zero charge Medicare Advantage Home health claims and converted IMS databases to

DB2). I installed third party software (ITS components) on the mainframe and audited and

tested the FACILITY side of the system after installation. (ITS is the common language, data

formats, software and procedures that allow Plans to access, send, receive and control claim

information). These components interfaced with the Professional, P&A and Home Plan Aid

systems via multi-level  sub-routines, copybooks and PROCs.   My other responsibilities included  

 

                                                ·  Documenting technical specs from Use Case documents using Rational Rose for each

                                                      program, PROC, JCL and MFS screen 

                                                  ·  Analyzing and modifying FACILITY programs, PROCs, JCL and COPYLIB members  

·  Creating and loading DB2 FORMATS Tables after running a SPLIT

·  Creating and loading IMS databases

·  Pulling Bill Provider, Submission Format(SF), Disposition Format(DF) and Notification

    Format(NF) data for analysis

·  Data analysis using ITFI screen; FileAid; JOBSCANS; Xpediter 

·  Loading SCCFs to FORMATS Table and selected Bill records to REPOSITORY Table partitions

·  Creating test files and setting up test environments

·  Coordinated and controlled the deployment of all my team and ITS elements and components

    (i.e. JCL, PROCS, COPY members, MFS, PSBs, Programs, Sub-routines etc.) 

·  Created PACKAGES as part of the implementation process

·  Added and modified PROCs and controlled step-flow using ‘IF’s and COND parms

 

 

 

 

 

2/2006 – 5/2007     COMPUTER ENGINEERING SERVICES            Aurburn Hills

 

Sr. Analyst/Programmer Consultant  / Vehicle Build Analysis & Scheduling System(VBASS)

                                                                   Chrysler Holdings LLC Auburn Hills

 

Involved in the system design, development and project management process of the

WHAT-IF project.  As part of the project, reverse engineered VBASS sub-systems

(Chassis, CPOS, Chassis Adjustments, Calendar, PBRS, Work to Static and Schedule)

and documented using VISIO, PowerDesigner and MSOffice.  Designed, developed, tested

and implemented a process to correct differences in the adjustment process of the VBASS

system.  This after doing a Root Cause Analysis to determine why authorizations on the IMS

database did not match the DB2 Authorization Table.  This analysis crossed multiple sub-systems

(Volume planning, Marketing and Sales, Order Counts and Plant Cycle Time). Databases, tables

and FTP files interfaced with the various systems. (Some files were created via MFS online

screens.)

ENVIRONMENT: COBOL II; TSO/SPF; DCCS; SQL;  Xpediter; Eztreive; File-Aid; FTP; DB2 

 

                                                ·  Converted the IMS Adjustment database to a DB2 table as part of the web-enabling effort for

                                                      the TRAPLINE project and use it in the back-end adjustment process

                                                  ·  Created a COBOL stored-procedure and its STP element which is called by a JAVA bean  

·  Did an investigative analysis to determine why Chassis authorizations were being dropped

·  Documented online and back-end adjustment system flow process including Cycle-Time

    components using MSOffice and VISIO

·  Prepared test environment using BATCH FTP to copy production data to test system

    (Mainframe to Mainframe)

 

·  Prepared Ad-hoc table reporting with Eztreive that included SQL code

·  Extracted data using File-Aid to build test files and for data review

·  FTP’d files to servers and test Mainframe

·  Received files from servers using FTP

 

 

6/2005 – 12/2005     COMPUTER ENGINEERING SERVICES       Aurburn Hills

 

Sr. Analyst/Programmer Consultant  / Sales and Marketing – SSI/CSI Vendor change to Maritz

                                                                   DaimlerChrysler Auburn Hills

 

Created five new daily DCX data pulls from new vendor (Maritz) using file transfer EBMX

protocol. I also created four new feeds to same vendor using EBMX.  I Encrypted, decrypted data,

edit, converted, verified, validated and reformatted files and FTP’d selected data to DCX internal

systems (Dealer Services, Warranty, COIN and others) for further processing.  ETL project.

 

·  Gathered requirements, analyzed, designed, tested and implemented Split and

    Reformat process

·  Documented entire feed process using MSOffice and VISIO

·  Prepared and modified JCL to send data files to DCX supporting systems via FTP and

    to vendor via EBMX 

·  Defined and modified record layouts from incoming  EBMX files

·  Set up userids and passwords through E-Business Services, to FTP files to DCX servers

·  Programmed two new COBOL program utilities to edit and compare incoming file types

·  Set up a new process to bridge incoming data with DCX PAI and LMS/DCA systems

    (reformatted files and lrecl)

·  Set up EBMX (file transfer protocol) DocTypes, parms and passwords

·  Developed Split and Reformat processes for incoming EBMX files (created new JCL, PROCS,

    four new COBOL programs)

·  Created totals and difference reports

·  Coordinated the entire project that involved contacts with seven systems, two vendors,

    management staff  and DCX  E-Business Services (sets up the FTP Mailbox)

 

 

 

1/2005 – 6/2005     COMPUTER ENGINEERING SERVICES         Auburn Hills

 

Sr. Analyst/Programmer Consultant  / Payroll Dept.  DaimlerChrysler  Auburn Hills

 

 

Backup support person for the Supplemental(SUB) and Sick & Accident(S&A) systems

that’s part of the Salary and Hourly payroll Wage Attachments system.  Maintained  COBOL

programs (CICS, VSAM and DB2). Analyzed problems and recommended solutions. 

Applied changes to the system(s), documented according to Sarbanes-Oxley and implemented.

 Responsible for creating the SUB Overpayment Letters using QMF and Eztreive.

 

·  NDM’d production VSAM files to test mainframe

·  Set up test JCL and created test data using File-Aid and Home-grown utilities

·  Gathered requirements for Friend-of-Court(FOC) changes, correcting return address on checks

·  Prepared QMF SQL reports

·  Converted Executive SUB and S&A to PeopleSoft platform

·  Determined the JCL and steps that required changing and modified, tested and implemented

    (removed steps accessing databases that were converted to PeopleSoft)

 

 

3/1999 – 12/2004     COMPUTER ENGINEERING SERVICES                 Auburn Hills

 

Sr. Analyst/Programmer/Project Lead/Web Dvlpr Consultant  / Procurement and Supply