Systems Consultant Resume

SUMMARY

20+ years of overall IT Experience, including 15+ years as a Mainframe Analyst and Programmer
Experience in converting mainframe legacy processes to server environment
Strong SQL, COBOL, JCL and Focus skills
Proficiency wif Endevor
Knowledgeable in SAS and statistical packages
In - depth expertise in all aspects of the Software Development Life Cycle (SDLC)
Superior analytical, problem-solving and troubleshooting aptitude wif attention to detail
Effective consensus building, collaborator and facilitator abilities for forming enduring stakeholder relationships
Excellent written and oral communication skills and listening

TECHNICAL SKILLS

Languages: SQL, SQR, shell scripting, Java, R, Python, SAS, Focus, Cobol, QMF

Operating Systems: Linux

Databases: Oracle, DB2

IBM: IBM z/OS (OS/390/MVS) TSO ISPF, File Aid, Syncsort, QMF, Endevor, REXX, JCL, CA-7, ESP job scheduler

Other: Confidential , Microsoft Office Suite, AWS, Toad, SQL Developer

Business: Agile, Jira, Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, MD

Extensive experience in all aspects of SDLC in human resources, payroll, time and labor, and related financial applications

Confidential, IT Department

Project: Social Security Number Remediation

Responsibilities:

Analyzed mainframe and Oracle databases to determine magnitude of data containing SSN. Created Entity-Relationship model showing data mappings
Evaluated 200+ Cobol and sqr batch programs dat use SSN. Replaced 90% of references to SSN wif company identifier employee id
Develop reusable code using copybooks to handle Inquiry, Maintenance or Add functionality
Designed 5 panels to invoke repetitive utility functions
Mitigated ASCII: EBCDIC conversion issues wif process dat identified character anomalies
Replaced ftp wif SFTP
Formulated data masking schemas to disguise SSN

Systems Consultant - System Analysis and Programming in IT Department

Project: Confidential 8.9 upgrade

Responsibilities:

Adapted 150+ Cobol programs to run on server
Converted 10 Cobol programs to Focus software
Scheduled jobs and monitoring of test regions and production regions
Optimized batch executions to reduce cycle duration. Included rearranging jobs to eliminate data locking scenarios
Implemented FTP processes to move data from mainframe to server. Built capability to store of multiple versions of files
Set up parameter card libraries and members to be used as input instead of passing the parameters wifin the JCL
Created job aids and training materials for end users

Systems Analyst - System Analysis and Programming in IT Department

Project: Confidential

Responsibilities:

Create testing plan for processes effected by Confidential
Coordinated test team of 4 to execute Confidential end-to-end testing from 20 developers
Migrated Confidential compliance changes to the system
Edit Clists for testing purposes
Created repository for archiving test datasets
Automated tool development to delete versions exceeding 5 gdgs
Publish instructions wif Confidential functional changes for end users