Katrina D. Roberts

ad1fw3@r.postjobfree.com

301-***-**** cell

TECHNOLOGY SUMMARY:

• Full life cycle Production Support for Mainframe & Object Oriented applications.

• Wrote, analyzed programs, researched, designed test scripts and computer applications.

• Achieved high level of success working in multi-database environments, supporting the implementation, development, application testing, analyzing & documenting technical problems.

• Troubleshooting & problem solving through astute analysis.

• Proficient with leading projects, managing scope, and completing on time within budget.

• Proficient with the implementation of LAN/WAN networks, fileservers, workstations and designing of networking systems.

• IBM PCs & IBM Compatibles, Desktops, portables, printers, all PC Peripherals, WAN/LAN Networks, Service System Broads.

• Oracle SQL Developer Data Modeler: ERDs, physical design, PL/SQL packages/triggers, DBA, Fluent with Oracle tools; iSQL*Plus, etc.

• Database engineer; noSQL and relational data modeling, object-relational integration (ORM), physical design/tuning. Specialized with Oracle, UML based specifications.

• Oracle, BMC, DB2, DMLO, IDMS, TSO/ISPF, IDMS, FTP, MVS OS-900, PL/1, CICS, ENDEVOR, SPUFI, SAP/SAP BW, JSURS

• MSAccess, MSProject, REMEDY, CA7, FILEAID,VSAM, SENDIT,WS-FTS, JSURs

• WINDOWS, ACF2, TEST SCRIPTS/CASES, WINRUNNER, CLEARQUEST

• COBOL, JCL, SQL, SQL(Oracle), HTML/HTML5, CSS, DOS and UNIX EDUCATION:

• University of Maryland University College, Adelphi, MD 2015 – Information Assurance

2014 - Informatics, Graduate Certificate

2013 - Database Systems Technology, Graduate Certificate 2012 - Master’s Information Technology-Telecommunication Mgt

• Certificate Electronic Computer Technology, TESST College of Technology, Beltsville, MD

• 1993 - Bachelor of Science, Computer Information Systems, Cheyney University of Pennsylvania, Cheyney, PA

CLEARANCE:

TS/SCI-FS Polygraph Active 2014 - 2016

EMPLOYMENT HISTORY:

United States Postal Services 03/2023 - present

City Carrier Associate

INACTIVE

Resume for: Katrina D. Roberts Page of

● Responsible for the safe and efficient delivery and collection of U.S. mail. Maryland Department of Public Safety and Correctional Services 08/2022 - 04/2023

● Performs analysis and programming in the maintenance and enhancement of criminal history system unit in accordance with departmental standards and schedule. Performs analysis and corrective programming to resolve application system problems. Provides technical guidance to lower grade programming professionals. Follows Quality Management and Configuration Management process.

● Performs analysis and programming in the development of new and revised application systems as assigned and in accordance with schedule and customer’s expectations.

● Shadows team member on their applications and provides support in their absence.

● Effectively and efficiently investigates and resolves Help Desk Tickets within guidelines, providing excellent customer service.

● Evaluates performance of systems and investigates alternatives for systems improvement.

● Maintains communication with IT Programmer Analyst Supervisor; advises of pending technical and resource problems; provides continuous status on project progress.

● Provides technical guidance to other programmer analyst personnel. FedEx. 06/2021 - 06/2022

Courier

● Responsible for delivering documents and goods between locations. Typical work activities listed on a Courier resume are loading and unloading items, picking up customer materials, coordinating mail, keeping in touch with the main office, driving from one place to another, and updating delivery records.

Software Technology LLC - Contractor with SSA. 06/2019 – 04/2021 DB2 DBA

• Administration of databases throughout the development and production lifecycles.

• Conduct performance monitoring and tuning activities on DB2 databases.

• Provide advice and support to development resources.

• Create and maintain the performance of stored procedures.

• Provide guidance in the creation and modification of standards and procedures.

• Supporting the standing standards, policies and procedures of the customer team.

• Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.

Katrina D. Roberts ● 15410 Empress Way Bowie, MD 20716

● 301-***-**** ● 301-***-**** ●

IT Programmer Analyst II

Resume for: Katrina D. Roberts Page of

• Will be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.

• The selected candidate will accept other duties as directed by management Maryland Dept of Information Technology 06/2016 – 6/2019 Database Specialist II (promoted)

• Develop reporting, designing, developing, testing, problem resolution, implementing and maintaining Application Systems and programs using generally accepted computer programming languages.

• Effectively manage and support the State's Information Technology for FMIS, RStars, etc.

• Providing an efficient, organized and consolidated approach to statewide IT services.

• Recovery of DB2 applications and data, administering DB2 security and writing and debugging MVS JCL.

• Problem determination and performance tuning of DB2 applications and SQL; Monitoring DB2 and productivity tools.

IT Database Analyst II

• Develop reporting, designing, developing, testing, problem resolution, implementing and maintaining Application Systems and programs using generally accepted computer programming languages.

• Effectively manage and support the State's of Maryland Health Benefit System.

• Providing an efficient, organized and daily reporting.

• Technical environment: SQL Server Management Studios, Microsoft Access, FTP (FileZilla) Maryland Dept of Health and Mental Hygiene 03/2013 – 06/2016 IT Database Analyst II

• Responsible for configuration, upgrade, administration, monitoring, and maintenance of the database.

• Perform data runs for Investigative units using TSO or JSURs.

• Conduct training on updates to new fields in the database.

• Coordinate with management on ongoing implementation of future database systems for the embitterment of the Investigative Unit.

Maryland Dept of General Services, MD 03/2012 – 01/2013 Database Specialist I

• Perform updates as well as analyzing and reporting on collected data.

• Coordination, installation and implementation of future database management system software and related software tools.

• Maintain security and integrity of data by specifying access polices, standards, methods and parameters.

• Monitors database performance and makes modifications and adjustments. Full-Time Masters & Graduate Certificate, Candidate 03/2009 – 04/2013 University of Maryland University College Largo MD Verizon, MD 01/2010 – 03/2010

Voice Portal Tester

Katrina D. Roberts ● 15410 Empress Way Bowie, MD 20716

● 301-***-**** ● 301-***-**** ●

Resume for: Katrina D. Roberts Page of

• Perform regression testing for the self-service assistance through the use of SVRU (Speech Voice Response Unit).

• Testing the functionality, connections, and call paths.

• Utilizing the following tools: AdminTool, iCAD, vRepair, CMIS.

• Setup testing scenarios.

ExxonMobil Fairfax, VA 05/08 – 04/2009

Section Head Administrator Consultant

• Responsibilities include running queries using SAP Business Warehouse for tracking projects, monthly reports, employee reports, and budgets.

• Create expense reports using eSpeedBuy.

• Review staff expense reports for accuracy, then approves and sent to Section Head Manager.

• Participation for new, transferring in/out employees.

• Update and enter time using SAP.

Contract Complete, Retail Work 02/2008 – 01/2012

Fannie Mae Herndon, VA 03/06 – 01/2008

QA Test Analyst Consultant

• Consultant for Fannie Mae working on a conversion project; Mainframe to Oracle.

• Retrieved data from production, created strategy, programmed and wrote test scripts.

• Perform programming using JCL, SQL and COBOL within a DB2 relational database environment.

• Managed scopes and test execution/scripts, which included coordination with the various test teams and providing test execution utilizing CA7.

• Sent data to Unix/Oracle database using FTP.

• Participated in problem resolution reporting and tracking, using MS PROJECT.

• Technical Environment: COBOL, DB2, CICS, TSO/ISPF, Endeavor, Fileaid, CA7, SQL.

• Types of Software Testing: Unit, System, Performance, Integration, Regression, Acceptance and UAT.

ExxonMobil, Fairfax, VA 02/2003 – 02/2006

Database Supervisor Consultant

• Responsibilities included updating pricing and customer database, update calculations, discounts, and produce summary reports in SAP and EXCEL.

• Perform updates, change requests and manage the integrity of the Access database, which includes tracking and document storage.

• Provide ad hoc technical support to team members.

• Maintain records/data in SAP. Create and Manipulate databases for reports. Using SQL to administrate backups and conduct queries as restoring and compiling updates.

• Also involved in supply chain management activities. Full-Time Parent 04/2002 – 01/2003

Fannie Mae, Herndon, VA 03/2001 – 04/2002

Katrina D. Roberts ● 15410 Empress Way Bowie, MD 20716

● 301-***-**** ● 301-***-**** ●

Resume for: Katrina D. Roberts Page of

Software Tester Consultant

• Perform programming using JCL, SQL and COBOL and test execution utilizing CA7.

• Managed scopes and test execution/scripts, includes coordination with the various test teams.

• Detailing project plans, status reporting and deliverables tracking.

• Conduct test executions and troubleshooting abends.

• Participate in problem resolution reporting and tracking. Caregiver for parent (mother) 09/2000 – 02/2001

Bell Atlantic, New York, NY 03/1999 – 08/2000

Software Engineer Consultant

• Successfully handled migrating objects using Endeavor.

• Reviewed program output resolves to determine fixes in SIR’s.

• Updated, tested and implemented new requirements for COBOL programs.

• Involved with monitoring job streams in CA7 (scheduling system).

• Solve and analyze JCL and SQL abends.

• Updated, tested and implemented new COBOL job script changes.

• Prepared programs for production releases using Endeavor. AT&T, Herndon 09/1998 – 03/1999

MVS Environment Support Tech./Tester, AT&T Consultant

• Created the test environments using JCL for the MVS system. Evaluated and repaired new JCL code/programs.

• Environment preparation including database upgrades, DB2 tables and code ships. Solved and analyzed reported problems.

• Resolved certain job abends {JCL errors, space problems}. Bell Atlantic-NSI, VA & MD 09/1995 – 09/1998

Software Engineer/Team Leader

• Performed software testing on the expressTRAK billing system.

• Monitored batch jobs and resolved JCL errors.

• Supervised, trained and delegated task for team members.

• Solve, analyze and track problems. Conducted performance appraisals & provided training to team members.

• Initiated and wrote technical training manual for subordinates.

• Performed analysis, design, development, testing and mainframe support for a new billing system using COBOL, DB2, MVS, JCL, SQL, BMC and FileAid.

• Documented timelines, requirements and conditions entailing the scope of test/production releases. Created execution JCL using FileAid program to develop and modify production fixes. program specifications {JCL, DB2 binds}, and guide the installation process.

• Coordinated ACF2 security access with other internal security systems using programmer’s workbench, DB2 catalog security.

• Administration/Preparation for unit/system/production test plans for Release installations. Assigned new release headers, promotion/demotion, attach/de-attach, processes using Pegasys. Katrina D. Roberts ● 15410 Empress Way Bowie, MD 20716

● 301-***-**** ● 301-***-**** ●

Resume for: Katrina D. Roberts Page of

• Identified, implemented and executed critical process needed for disaster recovery.

• Participated in performing problem resolutions and restore/backup procedures to ensure the performance of critical business systems.

Katrina D. Roberts ● 15410 Empress Way Bowie, MD 20716

● 301-***-**** ● 301-***-**** ●

Contact this candidate