LARRY V. DUFFIN
Annandale, VA 22003
********@*****.***
SUMMARY
Seasoned IT consultant with over 18 years of IT experience with over 7 years of Control-M experience installing and administering both BMC Control-M and Mainframe Control-M
Experience scheduling and monitoring batch processing utilizing Mainframe Control-M, BMC Control-M, and CA7 or AUTOSYS as the Automated Schedulers
Schedules ADHOC string(s) and other strings by forcing out the BMC Control-M TABLE to the Enterprise Manager GUI to be process
Performs administrators duties, including installing, upgrading, and configuring software, as well as troubleshooting and resolving issues
Ability to work efficiently within the team, as well as independently, and capable of multi-tasking and quickly adjusting to new environments.
TECHNICAL SKILLS
Languages : SQL*PLUS, SQLLOADER, Oracle SQL Developer, EASYTRIEVE PLUS, TSOCLIST, REXX, FILE-AID, HTML, TOAD
Data Bases : ORACLE 9i/10g/11g, MYSQL, Microsoft SQL Server 2004, DB2, ADABASE/NATURAL2
Operating Systems : WINDOWS 2000, WINDOWS XP, WINDOWS 7, WINDOWS 10, MS DOS, UNIX, LINUX,
WINDOWS NT, IBM MVS,
Software Programs : OS/JCL, TSO/ISPF, CA-PRODUCTS (CA7, CA11), BMC Control-M,
MVS Control-M, AUTOSYS, JES2, VTAM, JOBTRAC, Oracle Enterprise Manager (OEM),
IBM UTILITIES, MS Office (Word, Excel, Access), SDSF, IOF, SPUFI’s, CA-Spectrum,
Self Service Tools, Site Scope, United Service Manager, Service Now, Tivoli Storage Manager(TSM)
EDUCATION AND CERTIFICATES
2010 Oracle Database Administration II: Fairfax County Adult & Community Education
2000 Oracle, SQL Plus, UNIX : Fairfax County Adult & Community Education
2000 Database Programming: Northern Virginia Community College
1974 Computer Operations: Computer Learning Center
SECURITY CLEARANCES
ACTIVE (MBI) Public Trust Clearance / USCBP - United States Customs and Border Protection as of April 16 2014
ACTIVE (MBI) Public Trust Clearance / IRS - Internal Revenue Service as of June 25 2012
EXPIRED TS/SCI SSBI Sept 2009 / Raytheon
WORK EXPERIENCE
Freddie Mac Herndon, VA 01/2017 – Present
Computer Ops Sr.
Monitor the Network using CA-Spectrum, Self Service Tools, Site Scope and United Service Manager
Monitor Mainframe batch processing using JOBTRAC
Monitor Client Server batch processing using AUTOSYS
Have experience using LINUX and UNIX to maneuver through the LINUX and UNIX environments
Create tickets using the SERVICE NOW application
Run shell scripts to check the status of the production servers, also to check on the number of trouble tickets that were created for that day for Quality Assurance
Pomeroy Reston, VA 09/2016 – 01/2017
Production Control Analyst
Schedules and monitors batch processing utilizing Mainframe Control-M, BMC Control-M, and CA7 as the Automated Schedulers
Creates IEBGENERS statements to retrieve data from DASD and CARTRIDGES and print Sequential and Partitioned datasets
Correct JCL and ABEND codes
Modify COBAL source code in the WORKING-STORAGE SECTION to add or delete a column
Plans ADHOC string(s) and other strings by forcing out the TABLE to the Enterprise Manager GUI to be processed
Reviews turnover logs, printouts, and trouble logs to discover job status and identify jobs that have not processed correctly
Works with users or programmers on jobs that had not processed correctly
Execute and modify JCL PROCS utilizing TSO/ISPF to support the Production Support functions
Creates IEBGENERS statements to retrieve data from DASD and CARTRIDGES
Sev1tech, Washington, DC (United States Customs and Border Protection contract) 10/2014 – 09/2016
Production Control Analyst
Schedules and monitors batch processing utilizing Mainframe Control-M, BMC Control-M, and CA7 as the Automated Schedulers
Modify COBAL source code in the WORKING-STORAGE SECTION to add or delete a column
Plans ADHOC string(s) and other strings by forcing out the TABLE to the Enterprise Manager GUI to be processed
Reviews turnover logs, printouts, and trouble logs to discover job status and identify jobs that have not processed correctly
Works with users or programmers on jobs that had not processed correctly
Performs administrators duties, including installing, upgrading, and configuring software, as well as troubleshooting and resolving issues as they arise throughout the day or night
Create TSOCLIST scripts to review job output
Create IEBGENERS to print Sequential and Partitioned datasets
Execute and modify JCL PROCS utilizing TSO/ISPF to support the Production Support functions
Creates IEBGENERS statements to retrieve data from DASD and CARTRIDGES
Performs JCL and ABEND corrections and restart procedures through CA7/CA11 and Mainframe Control-M
Execute DB2 SPUFIs for SQL queries and use SPUFI’s to load records into the DB2 Database tables
Write Easytrieve Plus programs
Uses CA-DISPATCH for report retrieval and report setup
Determines if batch jobs are executing correctly using SDSF
Utilizes REMEDY to create trouble tickets
Creates SQL scripts to extract table data for CRYSTAL REPORT generation
Performs SQL queries and data manipulation
Restores and recovers databases using Recovery Manager (RMAN)
Utilizes RMAN for full, incremental, and archive backups
Use TOAD to view database tables
View job and output using SDSF and IOF
Transfer files from one system to another using FTP
Working knowledge of Linux and Windows operating systems
Telesis Corp, Springfield, VA (U.S. Customs and Border Protection contract) 04/2014 – 10/2014
Mainframe System Support Analyst
Schedules and monitors batch processing utilizing Mainframe Control-M, BMC Control-M, and CA7 as the Automated Schedulers
Modify COBAL source code in the WORKING-STORAGE SECTION to add or delete a column
Modify and executed JCL PROCS utilizing TSO/ISPF to support the Production Support functions
Created IEBGENERS statements to retrieve data from DASD and TAPES
Managed the day-to-day duties for ACS, TECS, FFS to ensure quality and responsive service to the client
Monitored MVS batch and online activities, and provided production support to resolve job ABENDS using JCL corrections and restart procedures through CA7/CA11
Managed and implemented scheduling changes to CA7/CA11 to ensure database integrity and efficiency
Utilized CA-DISPATCH for report retrieval and report setup
Determined if batch jobs were executing correctly using SDSF
Fetched and submitted jobs from a ROSCOE library
Utilized REMEDY for trouble tickets.
Computer Science Corporation (CSC), Martinsburg WV 01/2012 – 04/2014
BMC Control-M Scheduler / Computer Operator
Performed system start up and IPLs, and scheduled ADHOC string(s) by forcing out the TABLE to the GUI
Scheduled and monitored batch processing utilizing Mainframe Control-M and BMC Control-M and AUTOSYS as the Automated Scheduler
Corrected system ABEND Codes, JCL ERROR, and DOS scripts
Modified and executed TSO and JCL PROCS
View output using $AVERS and ENDEAVOR
View jobs and output using SDSF and IOF
Printed standard and special forms on IBM high speed printers
Reviewed shift turnover logs, trouble logs, and job status, and identified jobs that had not processed
Trained new Operators on procedures and technical issues
Generated reports using CRYSTAL Reports Version 11
Utilized BMC Remedy 7.6 to create trouble tickets and to create reports with a series of queries.
National Business Center (NBC), Reston, VA 01/2009 – 01/2012
Technical Support Specialist
For BMC Control – M (Enterprise Manager)
Scheduled and monitored batch processing utilizing BMC Control-M as the Automated Schedulers
Planned ADHOC string(s) by forcing out the TABLE to the GUI to be processed
Reviewed turnover logs, printouts, and trouble logs to discover job status and identified jobs that have not processed correctly
Worked with users or programmers on jobs that had not processed correctly
For MVS Mainframe Control-M
Corrected system ABEND Codes and JCL ERRORS, and executed a TSOCLIST to submit ADHOC batch jobs
Scheduled and monitored batch processing utilizing Mainframe Control-M and BMC Control-M as the Automated Schedulers
Implemented TSO and JCL PROCS to support Technical Support
Used symbolic parameters to override job control language for temporary changes to production jobs.
Raytheon Systems, Reston, VA 08/2005 – 01/2009
Database Technologist
Wrote SQL scripts to create tables and load table data using Oracle 10G and Microsoft SQL Server 2004
Created Oracle database tables using TOAD and SQL Developer
Wrote SQL scripts to extract table data for CRYSTAL report generation, and performed SQL queries and data manipulation
Restored and recovered database using Recovery Manager (RMAN)
Utilized RMAN for full, incremental, and archive backups
Learned how to use OEM to tune SQL statements, TABLESPACES, indexes, and databases
Installed the Critical Patch Update (CPU), which was done quarterly, and installed Oracle 10g on stand-alone computers
Used TOAD to view database tables
Created Remedy trouble tickets
Designed Access databases and created Excel spreadsheets for report viewing.
SAIC, McLean, VA 05/2004 – 08/2005
Database Technologist
Wrote SQL scripts to extract table data for report generation, and created SQL reports using SQL*PLUS
Utilized EXP and IMP from DOS for database backup and recovery of small databases
Wrote SQL scripts to extract table data for CRYSTAL report generation
Performed SQL queries and performed data manipulation
Restored and recovered database using Recovery Manager (RMAN)
Utilized RMAN for full, incremental, and archive backups.
PSSI (Preferred Systems Solutions), Inc., Fairfax, VA 12/2003 – 05/2004
Database Technologist
Corrected database errors, and utilized SQL*PLUS to create queries
Used METALINK to help solve errors, and created METALINK trouble tickets for errors that weren’t able to be resolved
Utilized Oracle Enterprise Manager (OEM) to monitor the database performance, create and delete databases, and create and delete tables.
Raytheon Systems, Reston, VA 12/2002 – 09/2003
Jr. Oracle Database Developer
Corrected database errors and inputted data to the database using SQLLOADER
Created Oracle database tables
Utilized SQL*PLUS to create queries.
Titan Systems, Fairfax, VA 04/2000 – 12/2002
Entry Level Oracle Developer
Utilized Oracle utility (SQL*LOAD) to load table data, and SQL*PLUS to create queries
Used EXP80 and IMP80 for database backup and recovery.
MCI, Chantilly, VA 08/1998 – 04/2000
Production Support Specialist
Monitored batch processing utilizing Control-M and CA7 & ZEKE as the Automated Scheduler
Updated and modified the JCL PROCS, utilized FILE-AID to map COPYLIB members, and corrected JCL-ERRORS and ABEND Codes
Executed TSO Procedures utilizing TSO/ISPF to support the Production Support functions.
Sprint, Herndon, VA 04/1998 – 08/1998
JCL Tester
Monitored batch processing utilizing Control-M and CA7 as the Automated Scheduler
Executed TSO Procedures using TSO/ISPF to support the batch testing functions, and corrected JCL-ERRORS and ABEND Codes.
Bell Atlantic, Arlington, VA 02/1997 – 04/1998
JCL Tester
Performed Mainframe User Acceptance tests
Wrote test plans, test cases, test scenarios, and performed requirements base testing
Executed TSO procedures using TSO/ISPF.
International Business Services, Washington, DC 06/1995 – 02/1997
Natural Database Programmer
Designed databases using NATURAL/INQUIRE
Utilized TSO/ISPF and TSO CLIST to support the ADABAS NATURAL