Roger Coffman Sr Email and Phone Number

• Collaborated with end users to identify needs and opportunities for improved data management and delivery.• Provided ongoing development and maintenance of an operational data stove and enterprise data warehouse using BI best practices, relational structures, and dimensional data modeling, structured query language skills, data warehouse and reporting techniques.• Improved and streamlines processes regarding data flow and data quality to improve data accuracy, viability and value.• Provided ongoing development and maintenance of a business intelligence architecture that enables fact-based decision making and ad-hoc analysis and insight generation.• Provided solutions using the Microsoft Business Intelligence stack, Microsoft Dynamics Customer Relationship Management (CRM), Defense Ready, SharePoint and/or Office productivity tools.

Supervisor: Sarah Davis (Air Force Project)• Prepared a network topology diagram; an incident data flow diagram; and a new layout for the that keeps track of MRL.• Performed test and evaluation of new releases that automates the process of recording incidents and tracking change requests. All anomalies get recorded, tracked and reported back to developers for corrections.• Investigated incidents related to telecommunications and network issues by identifying root causes and tracking progress till resolutions.• Performed peer reviews of all deliverables and provided feedback to the documentation specialists.• Performed regression tests of each new release and provided list recommendations for improvements.Supervisor: Antoine Turk (Veterans Affairs Project)• Established detailed requirements from baseline by meeting face-to-face with owners, so they can become actionable for development and testing activities.• Maintained list of changes to requirements to ensure they are signed-off by the customer and recorded in the requirements management tool (CaliberRM).• Support implementation of the project's CRM Process to include: o Assessment of new CRs to determine if they are in or out of scope. o Conduct impact analysis as needed; along with level of effort or cost to implement the change. o Facilitate CRBs with the customer and document the consensus on any decisions made to resolve the CR.• Support testing activities in EMS, by: o Development of test strategies (functional, section 508, performance, regression) to ensure all new changes meet the customer requirements. o Developed and maintained test strategies for each new production release; and report test results to management. o Coordinated the UAT on assigned EMS modules by creating the test procedures; assist in recording user anomalies, communicating results to management.• Developed and maintained User Manuals, Training Guides, Test Scripts and Known Issues.

• Performed technical and data base support as a member of the Continual Services Improvement (CSI) Team. • Reviewed, updated and maintained all CSI processes and procedures conform to ITIL, ISO/IEC 20000-1, CoBIT and Dev Ops standards and guidance on an annual basis.• Performed Root Cause Investigations (RCI) of CSI submission opportunities provided by the user community. • Prepared Service Improvement Plans (SIP) for those CSI Register candidates selected for review by the Architecture Steering Committee, CSI Panel and Senior Management.• Generated weekly status updates on all improvement opportunities via the SIP Action Tracker worksheet and database.• Assisted the Configuration Management Team in conducting CM audits of new change requests (CRs) being submitted at the next Configuration Change Management Board (CCMB).• Assisted in the migration of the IT Service Management (ITSM Service Operation), Incident Management, Problem Management, Change and Release Management, and Asset Management from Remedy to the ServiceNOW product (IT module).• Provided technical support to Security Management team to get their application migrated over to the Security Operations function, under ServiceNOW.• Provided CSI support during Enterprise Major Incident Reviews on escalated incidents and/or problems.• Developed a prototype CSI application on a test server using Linux with an Oracle database.• Created and executed 38 User Acceptance Test Cases for a new product called CSI_Now, which will be integrated into the overall ServiceNOW application developed by KPMG.

• Providing technical support to the Oracle DBA by building an Informatica Server using Linux and Oracle 11g product software and tools.• Developing SQL scripts to extract, transform, and load (ETL) scripts that are used to automate the quarterly builds and systems intergration.• Developed a Configuration Management – Business Process Model (CM BPM).• Developed a Configuration Management Plan (CMP) and Configuration Change Management Board Standard Operating Procedure (CCMB SOP).• Monitor, track and present incoming change requests (CRs) to the CCMB.• Schedule CCMB monthly meetings; generate the agenda; and produce the CR submission package that will be distributed to all board members and original requestors for review prior to actual board meeting.• Ensured orderly conduct during the CCMB meetings and generate the meeting minutes for approval by the CCMB Chairman.• Post the meeting minutes and associated Project Planning and Management (PPM) artifacts on a client designated SharePoint site.• Provide change processing and status accounting services by generating a report that contains a list of all CRs along with their related PPM artifacts, change control decisions, and closure status.• Record and track all action items to completion and their associated comments and responses.• Provide technical support during the re-establishment of the customers Configuration Management program.• Develop and maintain the processes and procedures related to the Configuration Management Plan.• Ensure all processes and procedures follow the Information Technology Infrastructure Library (ITIL), Capability Maturity Model Integration (CMMI), Institute of Electrical and Electronic Engineers (IEEE) standards and the client’s PPM lifecycle.

• Created and maintained QA audit checklists.• Conducted QA audits on deliverables to ensure they follow SDLC lifecycle and complied with ITIL and Business Process System Library standards.• Recorded results of audits in the Quality Audits & Actions tool and orally communicated them to Senior Quality Management, plus tracked all Corrective Action Requests to completion.• Conducted QA reviews of Performance Excellence Plans, Program Activity Reports, and Compliance Matrix and Baseline work products and communicated results to senior management and customer.• Migrated all QA audit results from the Quality Audits & Actions tool to the new Common Audit Database tool in SharePoint.• Managed day-to-day functions of the Quality Assurance, Configuration Management, Graphics Development, Testing and Documentation Specialist teams.• Prepared daily, weekly and monthly open incident reports for Service Area Leads to review and provide resolution on any inconsistencies.• Assembled data used to create the monthly Service Level Agreements and Key Performance Indicators Report Package deliverables. Presented the findings to senior management and customer.• Updated the SLA/KPI Business Rules on a quarterly basis.• Maintained the Quality Assurance Plan, Quality Assurance Surveillance Plan, Risk Management Plan and Program Management Plan on an annual basis.• Maintained procedure that tracks outstanding defects and presented findings to senior management.• Implemented Process Asset Library to store project deliverables and tools used by the software engineering and test teams to ensure user requirements were being met.• Established an Organizational Process Group to collect all software being developed; and processes and procedures being created.• Conducted QA reviews of Data Center’s daily reports, help desk audit reports, incident reports, and root cause analysis reports.• Generated the Utilization and Trends Report and Trends Analysis Report on a quarterly basis.

• Lead the effort in successfully obtaining CMMI Level 2 Certification. • Established and maintained a Process Asset Library that contains all standard processes, procedures, guidelines and templates.• Scheduled and performed numerous PPQA audits. • Conducted peer reviews of all Work Authorizations (WA) and Master Requirements Lists (MRL).• Conducted QA reviews of all internal projects configuration items. • Developed a CM repository (using KnowledgeTree) where PM’s stored their delivered configuration items. • Established the Engineering Process Group (EPG) where PM’s submitted all outstanding CRs and PIRs and tracked them to completion. • Tracked all non-compliant issues until resolution. Generated reports that listed all non-compliant issues; how many of them got resolved and how many tailoring requests were still outstanding.• Participated in the Change Control Board.• Performed duties as system administrator of the colwiki (Columbia Wiki) and KnowledgeTree (a web-based Document Management System), where I maintained an internal webpage containing the all users accounts, groups and permissions.• Setup the initial hardware and software configurations of the Development and Production IDS servers. • Built a web front-end interface that provided analysis of intrusions or alerts that SNORT has detected on a network using Red Hat Enterprise Linux; Apache; PHP; SSL; Perl; ACID; BASE; Ethereal; SnortCenter; and MySQL. • Developed and maintained all technical documents (ex: Master Requirements List, Test Plan, etc).• Developed and executed 22 test cases, utilizing 73 components specification requirements for the Beta Release of Trailblazer project. • Tracked the flow of each session as it travels through the Workflow Enactment process; then through the Data Handling Instructions (DHI) process; and finally stored within the TBTDP database or forwarded the results on to externals sources.

• Provided data analysis on numerous types of network discovery tools for DoDIIS Life Cycle Management System. • Conducted independent site evaluations of Air Force DoDIIS Infrastructure (AFDI) release 1.2.0.1 application.• Developed and maintained several PL/SQL, UNIX shell and Perl scripts. • Developed and executed several processes that export scanned data from five Tivoli Regional Inventory servers and imports it into an Information Technology Asset Management System database. • Designed and developed several customized end-user reports that provide statistical information about all hardware and software inventory scans. • Maintained the Tivoli Auto-Inventory scanning profiles. • Provided assistance during the design and development phases of a Master Inventory Database Repository system. • Designed, developed and maintained a customized “.MIF” profile that provides endpoint location data to the user community. • Generated several user guides, process flow documents, reference guides and test plans concerning Tivoli Inventory product. • Conducted database analysis and comparisons of the Tivoli Inventory v3.6 schema against future migrated databases (i.e. INOMS v1.4; Peregrine ServiceCenter v3.0 and AssetCenter v3.0). • Provided a technical white paper on how to synchronize and normalize software signatures data files across all five Regional Inventory Servers. • Served as a member of the Performance Tests and Evaluation Team for the Tivoli Decision Support tool.• Installed an Oracle8i Client package on several user workstations. • Assisted in the design, development, and testing of a prototype Information Systems Help Desk application that was used to merge nineteen independent systems into one enterprise-wide application.• Provided data analysis during software upgrades of the NASD Advanced Detection System baseline application. • Installed the Oracle 8i product onto a Sun SPARC/20 workstation as a demo file server.

• Migrated data from a WATCHDOG application (a PC-based Clarion Database Management System) to an Oracle Designer/Developer 2000 Relational Data Base Management System (RDBMS) on a UNIX platform. • Implemented and maintained several data recovery scripts that were designed to retrieve a year worth of data from non-migrated sites and verify the integrity of that data. • Provided technical support during the Test and Evaluation Phase of each new product release or baseline.• Provided conflict analysis, data modeling, and recommendations to standardize data elements in the Characteristics and Performance Database (CPDB) of the Modernized Integrated Database (MIDB). • Performed data comparisons (using the Data Analysis and Reconciliation Tool and Microsoft Excel).• Analyzed information about databases using the PC Access Tool (PCAT).• Developed and analyzed data models (using Erwin/ERX); reviewed messages; and prepared all Interface Change Proposals (ICPs).• Provided leadership and technical support during each phase of the Software Development Life-Cycle (SDLC) and maintained the baseline control documents.• Monitored all change requests using a new tool called “CMVision”.• Developed and maintained several technical documents (i.e. the Baseline Control Specification (BCS); Tools Operation Document (TOD); and Version Description Document (VDD)) for each new baseline release. • Participated as a member of the bi-weekly Change Review Board (CRB).• Provided technical support and software maintenance for the Collections Requirements Management System (CRMS) task. • Provided analysis of the data received from daily imports of Intelligence Information Report (IIR) messages.• Provided software maintenance to an existing NID application.• Identified new user requirements to generate our end product on CD-ROM’s.

• Responsible for integration three independent Naval Reserve Units Administrative Department into the new Defense Intelligence Agency (DIA), J2, Directorate for Intelligence, Joint Reserve Unit (JRU).• Served as Automated Information Management System (AIMS) Leading Petty Officer and participated in three Triennial Inspections as the AIMS Coordinator.• Served as the Automated Data Processing (ADP) Leading Petty Officer while providing training of the AIMS application. Also managed operations and maintenance of all hardware and software engineering tools.• Provided technical support to Reserve Intelligence Area (RIA) - Nineteen staff in establishing the AIMS Remote Processing Center located at the Pentagon.• Developed the process and procedure to extract, transform and load data, via modem, between RIA-19 and the JRU drill sites.• Tested and evaluated the AIMS application and provided feedback to Reserve Intelligence Area Commander (RIAC) and staff.

• Provided technical support during the development and execution of software testing and evaluation (ST&E) procedures for a PC-based Property Accounting System using PowerHouse Relational Database Management System (RDBMS) and assisted in the user acceptance testing (UAT) at customer site.• Designed and developed a BETA model of an internal Skills Matrix Database (using FoxPro2 DBMS) application and provided a demonstration to senior management.• Designed and developed an Automatic Purchase Requisition System using INGRES RDBMS and provided assistance in software/system integration at the customer site.• Provided hardware and software engineering support on several Sun and Hewlett and Packard servers, and Windows workstations.

• Developed and maintained several software engineering accounting applications for Wang VS and VAX/VMS systems. • Performed data extraction, transformation and loading (ETL) of several inventory applications from several mainframes to PC-based applications (using dBASE III Plus). • Provided configuration management support in maintaining of several Wang VS systems. • Designed and developed a prototype data communications link between Wang PC and a Sperry/UNIVAC subsystem and demonstrated to the customer. • Performed collateral duties as Lead System Administrator for several Wang VS and HP AIX mainframe systems. • Provided assistance in the development of a prototype Novell 286 – Local Area Network (LAN) server for software testing and evaluation (ST&E).

• Lead a team of up to 26 system operations and administration personnel. • Monitored the daily operations and maintenance of seven DEC VAX 11/780/8600/ALPHA series servers and two PDP 11/70 series mini-computers using VMS, UNIX and IAS operating systems.• Established and implemented an operator training program and used it to train the operational staff.- Developed and maintained all standard operating procedures (SOP).• Performed duties as Technical Analyst on an IBM 4341 system. • Created and maintained all technical documentation and standard operating procedures. • Participated as a key member of the Division’s Security Test and Evaluation Team.

• Supervised up to two Personnelmen and two Yeomen on the day-to-day activities.• Provided services in the areas of temporary active duty assignments, transfer orders, ship's diary, Enlisted Distribution Verification Report (EDVR), receipts and record maintenance, and stands in port Roving Patrol and APL OOD.• Maintained 365 servicemen and 20 officer service records.• Performed collateral duties as the ship’s journalist.