Alan R Willis

• As a Configuration Management Analyst in the Mainframe Configuration Management Section (MCMS), my primary responsibility is to:
• Process IBM Endevor packages on various platforms and closed associated task tickets. Provided problem resolution and escalation management on critical issues.
• Provide user support for the Endevor tool used for Tier I applications processing on the Masterfile IBM mainframe system.
• Create metrics, provide package status reports, and track package progress. Assisted customers with guidance regarding oversight of package deployments.
• Attend and conduct cross functional collaboration meetings with customers and attended filing season readiness meetings to ensure no incidents occurred in preparation for daily status reports.
• Create, review, and update Standard Operating Procedures, training documents and other related documents.
• Participate in the yearly Filing seasons activities. These activities include staging over 800 Endevor packages for production implementation.
• As the lead, I oversee the day-to-day operations of the Section and work as part of the leadership team.
• Ensure that packages/transmittals are being processed correctly and timely and ensure that all projects are properly covered.
• Resolve any processing issues that may arise.
• Attend, weekly Deployment 2 Production meeting.
• Recently, received an Executive Level Mentorship Award for the development and execution of a multi-year training plan used for developing a career ladder employee, and for the development, modification, and execution of an eight-week new employee training plan for multiple new employees that covered section procedures, documentation, and technical procedures.
• Created training plan for GS-07/12 upward mobility employee. The training plan takes the employee from GS-7 thru GS-12.
• Provide guidance to less experienced coworkers in resolving package/transmittal or process issues that may arise.

• As a Senior Mainframe DB2 Systems Programmer, I provided technical support to The Centers for Medicare Services (CMS) of the Department of Health and Human Services (HHS) for DB2 and DB2 related products like BMC Suite, OPTIM, and IBM InfoSphere Data Replication. The support included implementing maintenance, upgrades, and fixes to DB2 and related products.
• Reorganized DB2 catalog/directory tablespaces in DEV/VAL/INT/PROD DB2s, enhancing system performance and stability.
• Upgraded IIDR (QREP) to 11.4.0 to bring product up to current GA release in DEV/VAL/INT/PROD.
• Provided results of the Tuning Model for SQL to be used in the 2018 BRI Annual Process.
• Supported DB2 application restart following an emergency IPL of DB24. All outstanding work was resolved except an MBD transaction on the MBD_ERRORS table, which had to be rolled back. This affected applications that use that table. Once the rollback was completed, the table was returned to service with no further issues.
• Rebuilt DEV/VAL/INT/PROD application and DB2/BMC product databases, repairing internal errors identified during diagnostics and ensuring operational continuity.
• Created and configured a new user account in MAINVIEW/APPTUNE for both DEV and PROD environments.
• Successfully supported the EDB BRI Annual Process Production volume test in Integration.
• Successfully installed BMC RSL1804 maintenance for BMC Object Administration, BMC Performance for DB2 Databases, and Recovery Management solutions into Development DB2s.
• Installed CA/Repository for z/OS CAR1712 maintenance in DEV5 and PROD to Bring Product to Most Current Recommended Maintenance Level.
• Installed BMC RSL1807 Maintenance in PROD and DEV DB2s to bring product up to current maintenance level.
• Registered an external user with the DB2 Governor in Production DB2P to manage resource allocation effectively. This prevents external users from negatively impacting the performance of the Beneficiary Datamart.

• Provided technical support to clients for server network issues, computer hardware purchases, and PC problem resolution.
• Robert Half Technology (Sept. 13th – Sept. 27th) - Installing HP servers and attaching them to the Domain in DC public schools.
• Diagnosed and fixed modem communication issues on client's laptop to restore internet connectivity.
• Analyzed client PC capabilities to assess upgrade potential from Windows 95 to Windows XP Professional.
• Troubleshot and corrected network communication issues between printer and three office PCs to ensure smooth printing operations.
• Canaan Baptist Church (March 2006) - Resolved printer network communication problem with three office PC’s.
• Wrote and delivered a proposal to Antioch Baptist Church, Washington, DC for PC/Network support contract.
• Developed and presented a proposal for PC and network support contract to Antioch Baptist Church, Washington, DC.
• Telephone: (410) 969-7686

• As a Senior Q Replication Administrator, provide technical support to The Centers for Medicare Services (CMS) of the Department of Health and Human Services (HHS) for all QREP systems in Development, Validation, and Production.
• Developed and implemented peer-to-peer Q replication environment using DB2 LUW-to-DB2 LUW across Development, Validation/Implementation, and Production for CMS Enterprise Portal Project.
• After implementation of Enterprise Portal Q Replication environment, I created a Standard Operating Procedures document.
• During project closeout, updated the Project plan, created the Lessons Learned document, and created the configuration document.
• Designed and executed batch jobs to efficiently manage starting and stopping of Q Replication environment.
• Created several automation BATCH jobs to stop, start, and re-create Q Replication subscriptions.
• Delivered on-call support for QREP systems, ensuring timely resolution of technical issues. for all QREP systems.
• Delivered operational and development support for QREP projects, enhancing system functionality and performance. for all QREP projects.
• Established Q Replication dashboard to monitor replication health across all environments.
• Supervised the implementation of a counts process for the Enterprise Portal Q Replication environment.
• Technical point of contact for the Enterprise Portal Q Replication implementation.
• Technical Lead for the 2013 and 2014 Disaster Recovery exercise.

• Provided technical support to Social Security Administration Division of Validation and Testing Technology, maintaining and modifying Validation and Testing regions and software.
• Led enhancements to ad-hoc DB2 Delete process using CLIST and REXX, improving system functionality and user experience.
• Executed test cases to validate software functionality and identify defects early.
• Documented testing results, ensuring clear traceability for troubleshooting and release decisions.
• Coordinated regression testing to confirm system stability after code changes.

• Provided technical support to Army enterprise-wide projects.
• Led disposal project for unclassified and classified Air Force systems, performing system analysis, documenting findings, and presenting results to upper management, resulting in successful disposal in March 2011.
• Project Lead for the disposal of the classified machines in the Data Center and at the DR site. This task included performing an analysis of the system, documenting the findings, and doing a presentation to upper management. The Air Force systems was successfully disposed of in March 2011.
• Project Lead for the disposal of the Air Force Program Data System (PDS). This task included performing an analysis of the system, documenting the findings, and doing a presentation to upper management. The application was successfully disposed of January 2011.
• Monitored Army DB2 and CICS subsystems on a daily basis to ensure system stability and performance.
• Automated the scheduling of the weekly DB2 backups.
• Creating DBA Handbook with all information necessary for the Data Management Team DBA to their job.
• Created job to submit MODIFY utility JCL for all six Army DB2 subsystems.
• Trained GS-13 on DB2 DBA duties and responsibilities, enhancing team capabilities and knowledge transfer.
• Modified DB2 system date parameter, from USA to ISO, to accommodate data changes.
• Cloned the production DB2 subsystem on the test LPAR to provide a viable production test environment for the users.
• Created DSN1COPY jobs to refresh test DB2 subsystem with production IMAGECOPY data sets, ensuring data integrity and availability for testing.
• Documented details of unclassified and classified LPARs to maintain accurate system records.
• Replaced DB2 utility jobs with jobs that use the latest DB2 version 8 enhancements.
• Performed corrective maintenance on the Programming Data System (PDS). Increased the size of over 150 table/index space datasets.
• Completed 4 performance SQLs to identify table/index spaces that need maintenance.

• As a Senior DB2/CICS Systems Programmer on contract with the US Army IT Data Center, provided technical support to Army and Air Force clients.
• Adjusted threshold settings in OMEGAMON II DB2, excluding the OMEGAMON II for DB2 PLAN from DB2 activity monitoring and modifying LOGCOPY dataset thresholds to indicate WARNING when half full and CRITICAL when only one dataset remains unfilled.
• Reviewed DB2 CONNECT version 9 and started writing a recommendation to move to this version because of its enhanced security capabilities (better encryption).
• Use OMEGAMON II for DB2 to monitor Programming Data Systems (PDS) application performance daily.
• Created a mechanism on the Unclassified and Classified LPARS for users to update tables in one subsystem from another using the Distributed Relational Data Architecture (DRDA). The users will be able to execute SQL from one DB2 subsystem to another with the same LPAR or from Production to test. This will decrease time in test environment population by 50%.
• Corrected discrepancies in data set 3 of DB2 Active LOGCOPY1 and LOGCOPY2 on IS Test LPAR by executing the DSN1LOGP utility to identify correct Relative Byte Addresses (RBAs), deleting the incorrect entry from the Boot Strap Dataset (BSDS), and creating a new entry with accurate start and end RBAs.
• Installed DB2 CONNECT and connected it to the 7 DB2 subsystems.
• Installed version 7.1 of DB2 Administration Tools on all LPARS.
• Monitored system and application performance daily using OMEGAMON for DB2 and DB2 CONNECT.
• Modified QMF Dataset allocation CLISTs to function under DB2/QMF version 8.
• Modified CONTROL-M to backup application table/index spaces five days a week instead of twice a week.
• Modified DB2 ARCHIVE LOG retention parameters to keep logs for 90 days instead of 365.
• Worked as part of a team to resolve performance issue with the MPES application. Submitted findings to Customer Account manager (CAM) in writing and verbally.

• Managed database maintenance and development support for developers and end-users, including performance tuning and monitoring for HUDCAPS and PSCS projects across production and disaster recovery environments.
• Trained operations support staff to identify and resolve minor DB2-related problems.
• Developed DBA workload document to track in-progress, scheduled, completed, and not-scheduled work.
• Performed maintenance on largest tablespace to increase partitions from 15 to 20 for more even data distribution, and adjusted characteristic too large to support higher partition maximum and leverage SMS hardware enhancements.
• Delivered document on HUDCAPS disaster recovery and assisted client with adding information to HUD business resumption plan. Created Rerog unload jobs to unload production data to tape for shipment to disaster recovery site.
• Created and delivered document outlining process to reduce project security exposures using top secret IBM groups and deletion of obsolete authorities.
• Revised DB2/VSAM backup and recovery procedures for HUDCAPS application and helped create similar procedures for PSCS application.
• Served as technical point of contact for disaster recovery and business resumption plan readiness.

• As Senior DB2 Systems Programmer on contract at the Foreign Affairs Data Processing Center of the U.S. Department of State, I was responsible for supporting the Year 2000 compliance testing of hardware and software, provided DB2 support for all seven LPARS and the maintenance system. Conducted user and system testing, maintenance, performance monitoring, installation, and debugging of systems.
• Project Leader for Y2K testing of application and Systems Software. Developed Application and Systems Y2K test plans, upgraded software, test schedule, and installed Y2K testing software (SIMULATE 2000 and DATA AGER) on the test platform.
• Worked as part of a team in converting the CLASS-E application data from VSAM files to a DB2 Data Sharing, Parallel SYSPLEX environment under ACF2 for DB2. Also worked on establishing Data Sharing naming standards.
• Performed maintenance on the IEF Composer including dropping and recreating the databases with a new high-level qualifier and new storage group names. This maintenance reclaimed over 50% of the wasted space.
• Developed plan for installation of three years of CICS maintenance to ensure compatibility with DB2.
• Dropped and recreated database structures to improve organization. the COOLGEN table/index spaces to add a new high-level qualifier to table/index names and added new storage group names.
• Installed the DB2 TOOLS portion on the CANDLE OMEGAMON suite, DBA-XPERT for DB2 and FILE-AID on the development machine and added options on the ISPF applications menu for each product.
• Recreated the DB2 GLOBAL, TARGET, and DISTRIBUTION LIB zones on the maintenance machine and changed the dataset backup retention period to provide a point of recovery. The process was documented through the change management system and approved by the CCB prior to changes.
• Coordinated creation of ISYSADM and ISYSOPR source groups to streamline DSNZPARM management when adding or deleting users.

• As a Computer Specialist for the Internal Revenue Services, I served as Project Manager for the ACS/ICS Database Technical Team, responsible for the maintenance, modification, and development of the DB2 subsystems at the development site and ten production sites.
• Participated in the rollout of the enterprise-wide Automated Collection System (ACS) to the ten IRS Service Centers around the United States. Provided support to vendors on ACS database, participated in technical discussions concerning database design and usage, and represented the section as needed. I performed the following DB2 related task:
• Taught a DBA/CSA course at the Philadelphia Service Center. This course was designed to teach the DBA/CSA how to troubleshoot application database related problems and how to backup and recovery DB2 objects during the regular Production Cycles.
• Conducted thorough review of ACS DB2 related test scripts to ensure compliance and effectiveness.
• Combined and modified the system and application modified utility jobs. This batch job executes a QMF query to generate the modify control cards for all full image copy tablespaces. The control cards are passed to the MODIFY utility step and delete image copy records older than 30 days.
• Modified the DB2 storage group DASD allocation as part of the SMS implementation for DB2 data sets.
• Spoke about RACF/DB2 Security at the 3rd annual RACF Conference. The topics included an introduction to DB2, RACF administrator responsibilities, the DB2/RACF interface, and ACS/ICS RACF groups.
• Coordinated the 2nd annual ACS Database Administrator (DBA) Conference. Coordination included: sight feasibility analysis, conference scheduling, cost analysis, creation of an information packet for section members and field participants; approval of all topics and handouts; submission of actual cost to budget personnel; and preparation of conference agenda.

• As a Computer Programmer Analyst for the 7th Communications Group (January 1980 to May 1987 and May 1988 to May 1991) and 1802nd Communications Squadron (May 1984 to May 1988), I was responsible for programming support to the Air Force Surgeon General’s Office, the 1100 Resource Management Group, and the Air Force District of Washington. During this time, I accomplish the following:
• Branch Technical Consultant and Division DB2 Database Administrator, 7th Communications Group (May 1988 to May 1991). Managed project oversight and Division DBA support for all DB2 systems using CICS and CLIST in BATCH and REALTIME environments.
• Drafted two Statements of Work (SOW) for contracting the redesign of the enterprise-wide Report of Patients System (ROP) and development of the new Inpatient Data System (IDS), the largest applications in the Air Force Surgeon General community, utilizing COBOL, DB2, CICS, and SQL.
• Produced operating instructions for the Branch. The operation instructions included guidelines for completing Air Force and DOD forms, standards for programming and documenting systems, instructions for new employee orientation, and instructions for military and civilian counseling.
• Evaluated performance of civilian and military staff through annual appraisals.
• Developed work and training plans for branch employees to guide their professional development.
• Hired new co-op student and was tasked as mentor for all co-ops within the agency.
• Created five-year ADP requirements plan for the users for the fiscal budget requirements.
• Supervised the completion of all backlogged items in three months (190 backlogged development and maintenance work order items). Re-distributing the workload based on expertise did this.
• Successfully supervised and participated in the acquisition process of two requirements costing $50,000 dollars apiece for hardware and software through the first and second Information Systems Requirements Working Group (ISRWG).

Training – Over 1000 hours of Information Technology and administrative related classes (IBM, Unix, Honeywell, OPM)