Resume

Sign in

Engineer Data

Location:
Chantilly, Virginia, United States
Posted:
May 27, 2018

Contact this candidate

Resume:

TERRY DOWNING

***** ****** ****, ***** ******, VA 20152

703-***-**** © 703-***-**** (h)

Email; ac5m0f@r.postjobfree.com

EDUCATION

BS, Alabama A&M University, Computer Science, 1993

SPECIALIZED TRAINING

• Service Oriented Architecture (SOA) Foundations Survey v1.2, July 2008

• Doors Tool Training, Basic July 2008

• Agile Development Overview, 2007

• Lombardi Team Works Development, 2005 and 2006

• LM Systems Engineering 201, 2005

• Informatica Power Center 7.1, Introduction, June 2004

• Sybase Power Designer Data Modeling, January 2004

• Sybase Power Designer Object Modeling, January 2004

• Engineering Secure Systems Using Threat Modeling, July 2003

• Model-Based Development & Automated Testing, August 2003

• Introduction to Visual Basic Applications (VBA) Programming, September 2001

• Advanced SQL, April 2001

• Oracle Database Administration, August 1999

• Intro to Oracle SQL and PL SQL Units, October 1998, March 2010

• IBM Data Stage, Control-M, September 2015

• AWS Recap Re-Invent (2016), Solutions Architect training (2016) – AWS Big Data training (2018)

SECURITY CLEARANCE

Top Secret/SCI with Favorable Polygraph clearance

DoD Public Trust clearance

PROFESSIONAL EXPERIENCE

Leidos Corporation, Chantilly, Virginia 11/16-Present

Title: Systems Engineer, Enterprise

Responsible in supporting the customer in carrying out established Systems Engineering process, policy and procedures as documented in the SE Management Plan. Provided program-level Systems Engineering support to, from an Enterprise perspective for several application systems in the portfolio. Supported the customer through technical review of briefing slides for projects. Coordinated with project teams, informed them of potential impacts to their systems, coordinate preparation for control gates by reviewing and suggesting changes to briefing artifacts, analyzing technical system architecture and design. Produced architecture and design diagram documentation. Attended application demos as necessary. Attended various board and Technical Exchange Meeting’s (TEM) s regularly for projects being developed on various platforms including Premise and C2S. Coordinated with security to follow processes to obtain proper system security accreditation. Coordinated updates to program websites and requirements as necessary. Provided various aspects of support during Pre/Critical Design, Development and Test phases of projects. Participated in Sprint planning sessions. Monitored and coordinated tickets being worked by developers. Coordinated updates and review of control gate documentation artifacts.

Lockheed Martin Corporation, Systems Engineer, Staff, Chantilly, Virginia 05/16-10/16

Title: Systems Engineer/Data Manager

Program: Shale

I am part of a Data Management Team using Sponsor’s partner’s databases, research tools, and systems to inform targeting for collection. Providing data load ingest in support of data sharing and exchange between partners. Makes suggestions to process and procedure documents. Successfully completed training for several analytical tools used for data collection, exploitation and research analysis.

Systems Engineer, Staff, Fairfax, Virginia 04/03-5/16

Title: Systems Engineer and System Interface Control Documents Coordinator

Program: HRAccess

As a member of the HRAccess Integrated Data Warehouse (IDW) team, Performed HRAccess Operations and Maintenance (O&M) tasks for Transportation Security Agency (TSA) customer by completing daily O&M tasks in accordance with designated interface schedule. Used problem solving skills to resolve issues related to O&M processes. Executed morning and afternoon processes, updated daily check list, updated and sent out daily status email. Monitored email and ensured that all morning and afternoon processes were complete. Updated documentation for manual and automated processes to ensure processes were understandable and repeatable by all team members.

Created and managed changes for the HRAccess IDW Interface Control specification documents. Coordinated and Implemented updates to ICDs based on schema and functionality changes in internal and external source systems that feed into the DW. Submitted questions to source system points of contact (POC) or ETL and reports team members to capture/collect/or clarify information related to Interface Concept of Operations, Functional Steps, Data Transfer, Security Requirements, Frequency of Transfer, System Identification, Interface Initiation, File Layout formats, and FTP if applicable etc. Identified and documented proposed Interface system requirements in the ICD. Coordinated, Scheduled and participated in Peer reviews of ICDs. Provided comments and responses back to the team based on peer review of interface or Software Design documentation. Used the Web Inspect tool to coordinate and document the results of peer reviews. Worked with assigned Systems Engineers (SE’s), to prepare ICD’s for submission to the Engineering Review Board’s (ERB) Chief Systems Engineer for approval in order baseline documents. Facilitated daily O&M team meetings in the absence of the team lead. Worked or coordinated ICD CQ/CI/CR tickets assigned in Clear Quest. Tool exposure consisted of Oracle Toad, Sql Plus, and Putty in Linux environment, Win SCP, Rumba, Data Stage, Microsoft Excel, and Word. The underlying database for the data warehouse was Oracle 11g.

Systems Engineer Staff

Title: Systems Engineer/Requirements Engineer/System Administrator

Program: Employee Business Systems (EBS)

Provided Systems Engineering and Technical Analysis (SETA) support to the Employee Business Systems (EBS) program, by expediting Request for Change (RFC) proposal packages through the request management process utilizing the request management system. Assisted Government personnel in identifying, analyzing, and developing, customer business needs while translating them into system requirements for Human Resource Information Systems (HRIS). Participated in Technical Exchange Meetings (TEM) s with the requirements team, Business Technical Liaison (BTL) s and developers in order to understand, clarify, and derive system requirements to be drafted for review. Interfaced with various Engineering Review Board (ERB) meetings to include the System Engineering Review Board (SERB), Service Request Review Board (SRRB) and the Requirements Review Board (RRB) meetings to evaluate and review requirement agendas or technical issues. On occasion in support of TEM s, captured and distributed meeting minutes. Developed Microsoft Access Reports to show RFC metric and status information. Created and updated the Daily Operational Status report via a webpage utilizing Microsoft Front Page, and sent out notifications to the program. Researched System Requirements Document (SRD), Interface Control Documents (ICD), Design Specification (DS) documents and Requirements Verification and Traceability Matrix (RVTM) as part of analysis and system requirements writing. Maintained the Request Collection and Assessment Tool (RCAT) and (RVTM) databases providing system administration, enhancement, backup and compact. Provided end user support to RCAT and RVTM database users. Performed local database backups and upgrades as needed. Received consecutive 100% award fee ratings since starting the program.

Systems Engineer Staff

Title: Data Ingest Engineer

Program: Terrorist Threat Integration Center (TTIC), aka. The National Counter Terrorism Center (NCTC)

Designed and implemented an Extract Transform Load (ETL) methodology to ingest relational, flat file and XML data sources into data warehouse environment for the Terrorist Threat Integration Center (TTIC) contract. Utilized Informatica Power Center 7.1 to implement ETL methodology. Developed and designed transformation components using Power Center’s vendor proprietary ITL language (i.e., parsing logic) to migrate legacy source data into target, common repository. Coordinated with Informatica vendor representatives to determine optimal strategies to implement best practices for development environment. This included developing migration strategy into production environment. Developed SQL scripts to perform data profiling and analysis activities on vetted, legacy data sources. Supported the design and implementation of Conceptual Data Model (CDM) and Physical Data Model (PDM) design for project, using SYBASE Power Designer 1.0. Used Power Designer to establish Repository Definitions and connectivity to Oracle 9i database environment. Developed software development folder to catalog development activities and environment. Documentation efforts included: Oracle scripts, data warehouse design, data migration constraints and assumption, and Lessons Learned. Also developed CDM and PDM diagrams along with data dictionary reports. Reverse engineered physical data models coming from external source systems. Designed source to target data mapping matrix spreadsheet. Generated data model version comparison reports from within power designer and purged data warehouse of Oracle Reserved Words. Modified and enhanced change request database for data team. Entered change request into database. Installed computer workstations for Geo Scout Program. Served as the Awaiting Clearance (AWC) Global Information Management System (GIMS) and Canteen Coordinator. Responsible for disseminating information related to Training Recommendations, Compliances training, Program Descriptions and Performance Objective Requirements to those AWC personnel sponsored by the GIMS program. Announced monthly meetings to GIMS AWC employees.

Signal/VERIDIAN Corporation 10/02-02/03

Systems Engineer Senior

Title: System Engineer/Architect

Program: PEO-EIS Computing Component Emerging Technology Contract

Provided Information Systems Engineering services to initially support development of the Information Software Engineering Command (ISEC) Program Executive Office Enterprise Information Systems (PEO-EIS) Systems Integration Architecture (SIA). Developed Enterprise Architecture (EA) products (i.e., “AS-IS” Operational View (OV) and System View (SV)) for the following systems: Business Enterprise System (BES), Hazardous Substance Management System (HSMS), Installation Support Module (ISM), Defense Communications and Army Switched Systems (DCASS). Researched Discovery and User Assistant technology to identify the Computing Component Emerging Technology (CCET) projected to be available to the Army in the 2004 – to – 2008 timeframe and beyond that could assist in achieving a network-centric shared data environment for the sustaining base. Assisted customer in the development of the AKEA Computing Component Emerging Technology Profile Architecture (CCETPA) Guidance document.

SAIC, Inc., Vienna, VA 7/02-10/02

Systems Analyst

Title: System Engineer

Program: Reserve Component Automation System (RCAS)

Provided customer support to the RCAS Maintenance and Sustainment project. Presented orientation briefing on Software Architecture of External Interface Systems within the Reserve Component Automation System (RCAS).

AT&T/GRC International, Inc., Vienna, VA, 7/00-7/02

Analyst

Title: Data Engineer

Program: Reserve Component Automation System (RCAS)

Provided External Interface (EI) Engineering and Design expertise to support the Reserve Component Automation System (RCAS) Integrated Database (IDB) Personnel Expansion and Mobilization Planning Data Viewer (MPDV) II Project. Responsible for developing/maintaining and updating the External Interface Integration Matrix (EIIM) for the Regional Level Application System (RLAS) and the Standard Property Book System – Redesign (SPBS-R), during the requirements/analysis/design/construct and testing lifecycle phases of the projects. Developed a metadata cross-references between source and target systems. Developed initial Physical Data Models (PDM) to be implemented into the RCAS integrated Oracle 8i Database System to support the build of External Interface Systems. Performed rigorous domain analysis of the RLAS and SPBS-R raw data files, to establish business rules to be used as a detailed coding specification during the construct phase for EI data cleansing, translation, and transformation. Identified metadata from source systems to be incorporated in the Customized Access to RCAS Repository System (CARRS) tool. Executed the Systems Engineering Institute – Capability Maturity Model (SEI-CMM) compliant processes within RCAS to produce Technical Assessment (TA) and External Interface Specification (EIS) documents during the analysis and design phases of RLAS and SPBS-R EI development. Obtained Senior Management and Configuration Management (CM) approval for submittal to the Program Management Office (PMO).

GRC International, Inc., Vienna, VA, 2/98- 7/00

Analyst III

Title: Systems Analyst

Program: Global Combat Support System- Army (GCSS-A)

Provided Logical and Physical Data Engineering expertise to the GCSS-Army modernization project. Performed front and middle life cycle development of applications and shared data models, including requirements gathering and analysis, physical data modeling, logical data modeling using IDEF1X. Performed data mapping and traceability of items in the functional area of Catalog, Maintenance, and Supply Property. Proposed new data structures based on data map analysis as needed. Maintained the Oracle 8 Designer Repository Object Navigator (RON) on a daily basis through the creation of entities, attributes, domains, code values, relationships, tables, columns, and sequences. Provided descriptions for objects in the repository as new data model structure was being built. Made all GCSS-Army Enterprise Data Model (EDM) and System Data Model (SDM) objects available to other developers through the application share interface. Executed Oracle 8 and 8i Database Design Transformer on a regular basis to convert logical structure to physical structure. Performed generation of Data Definition Language (DDL) and Table Application Programming Interface (TAPI) and documented processes for comparison of DDL. Created, implemented, and updated views, functions, procedures, and packages utilizing design capture technology.

American Technical Resources and GRC International, Inc., Vienna, VA, 8/97-2/98

Contractor

Title: Systems Analyst

Program: Integrated Combat Services Support System (ICS3)

Provided Data Modeling, Integration, and Analysis of Legacy and Migration Automated Information Systems (AIS) for the Integrated Combat Services Support System (ICS3) Program. Contributed support in identifying functional area requirements for Maintenance, Inventory, and Requisition. Developed the initial Conceptual Enterprise Data Model for ICS3 utilizing the Oracle Designer 2000 Software. Also, managed data in the Oracle Designer Repository.

Northrop Grumman Corporation, Herndon, VA, 4/95-8/97

Systems Integrator

Title: Systems Integrator/Engineer

Program: Defense Systems Integration, Design, Development, Operation, and Maintenance Services (DSIDDOMS)

Provided Data Modeling, Data Standardization, and Data Requirement Analysis support to the Clinical Integrated Workstation (CIW) project which was part of the Defense Systems Integration, Design, Development, Operation, and Maintenance Services (DSIDDOMS) Lot III contract. Also, provided support to the Veterans Health Affairs (VHA) Director of Veterans Affairs (VA) Information Resources Sharing Program Office as a Liaison in the areas of DoD Integration & Research, National Distribution and Support, Reinventing Government, and Federal Information Sharing Work Group. Coordinated, supported and integrated all briefing slides, agenda for VA/DoD IRM data sharing teams, and all VA/DoD sharing agreements.



Contact this candidate