Database Engineer Adjunct Professor

Resume – Michael C. Campbell

Michael C. Campbell Education: University of MD, Adelphi, MD

**** ****** ******, *******, **. 20783 Master of Science in Financial Management, May, 1998 Cell: 240-***-**** University of the District of Columbia, Washington, DC Work: 703-***-**** Bachelor of Business Administration in Computer Home: **********@*****.*** Information & System Science, December, 1989 Clearance: U.S. Citizen, DoD/DoJ Top Secret/SCI/Full Scope Poly PROFESSIONAL SUMMARY

INFORMATION TECHNOLOGY ENGINEER

Systems, Database, and Extraction Transformation and Loading Engineering / Leadership and Project Lifecycle Methodologies /Big Data and Data Governance/Data Science Experienced IT Professional with demonstrated critical thinking skills in public and private industries for Telecommunication, Financial Management, Law Enforcement, Web Technology, Information Security, and Data Science/Engineering within the DOD Intelligence Community with a history of creative solutions to meet and exceed unique customer requirements. Results-driven programmer since inception of career with various programming languages with knowledge of C# and VB.Net. 18+ years experience with Oracle 7/8/8i-11g -12c/9iAS/10g/10gAS/11i –12g Relational Database Management and utilities. I have focused on all aspects of Oracle Database Management supporting design, development and production efforts for Data Warehousing, E-commerce, and Extreme Transaction Processing (XTP) environments. Experienced in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment. 4+ years an Oracle Apps DBA on 11i(11.5.10) & 12g. 5+ years experience with Microsoft SQL Server. Use the SCRUM processes to facilitate agile project management. 5+ years of “Big Data” experience with large and complex databases and Hadoop 1.0/2.0. development and administration. Consistently achieves project results that comply with agency project standards and mission objectives facilitated by solid requirements management, governance and project lifecycle methodologies, risk management, and communication flexibility, both written and oral--interpersonal and organizational problem-solving.

CORE COMPETENCIES

• Project Management

• Predictive Analytics (Data, Algorithm, Model)

• Hybrid experience in software development and

Data Science

• System Development Life Cycle (SDLC) • Cloud Technology – PAAS, SAAS

• Agile Methodologies: Scrum and Kanban

• IT System Security

• Database Management & Administration

• Data Architect (Big Data, Modeling, Analysis)

• Programming: Scalar,SQL,PL/SQL,Python,

• RStudio,Scripting,Powershell, JAVA, NoSQL

• ETL and Databases (Oracle, SQL Server, MS

Access, NoSQL, Tableau)

• Systems Engineering & Data Management Life

Cycle (DMLC)

• Database Engineering (DB Modeling, Design,

programming & Implementation)

PROFESSIONAL EXPERIENCE

Kognition Inc, VA, Director of National Intelligence (ODNI/CIA), McClean, VA. Director of Data Science /SME Data Scientist, May 2018 - Present Responsible for supporting Data Architecture, ETL, Science and Research for IT engineering, technical support, and support the compliance office (CTG) under the Office of Data Strategy and Innovation with applying established or new programmatic and quantitative methods to find patterns and relationships in large datasets in support of auditing and oversight of the organization’s data-handling obligations under numerous authorities. Establish and develop advanced analytic capabilities for enterprise network operations that will deliver proactive network assurance through intelligent assessments of the likelihood of failures in the network before they impact customers through the Predictive Analysis Process. Job Achievements:

Conduct mathematical, statistical, geospatial modeling, or other data-driven problem-solving analyses to address business operations or compliance questions.

Use Python and Zeppelin to evaluate and analyze geospatial applications and large datasets to discover patterns.

Use SPLUNK to report on “data-handling and use” in order to ensure compliance according to the Attorney General’s Guidelines and requirements and identify instances of non-compliance including but not limited to translation/transformation and staging of audit log data for review by less technical members of Sponsor’s team and analytic managers.

Resume – Michael C. Campbell

Research and develop statistical learning models for data analysis using RStudio and Python

Identify data sources, perform exploratory data analysis, develop data models and improve the visualization of data sets to provide data insights using python/zeppelin.

Design, test, implement, maintain and document the auditing and reporting processes used to ensure appropriate use of existing and future data, emerging technologies, new systems/applications in its on- premises and cloud environments such as AWS.

Code/script using Splunk, Perl, SQL, Anaconda Suite, Scalar, Spark/Databricks for extracting/storing data from systems and applications.

Leverage C2S computation services using Python/SQL on FidOS servers for R&D

Translate complex, technical and policy findings into an easily understood narrative (i.e. tell a story with data) in graphical, verbal, or written form.

Develop and deploy complex data transformation flows using graphical ETL tools such as Cloudera Hadoop and some NiFi.

Strong understanding of Database Taxonomies ( i.e, Data Warehousing / Operational Data Stores / Data Marts) with the ability to produce conceptual, logical and physical data models as well as in-depth knowledge of Extraction-Transformation-Loading (ETL) methodologies

Research and stay current with the latest technology trends Aset Partners Corp, Inc, MD, Defense Intelligence Agency (DIA), College Park, MD. Chief Technology Officer (CTO)/SME Data Lead, June 2017 – May 2018 Responsible for supporting Data Architecture, ETL, Science and Research for IT engineering, technical support, and acquisition support services for the DoDIIS, IC ITE enterprise and Mission Services Job Achievements:

Support data engineering for architectural processes and ETL for the entire project

Support for the Data Centric Strategies for Messaging and the Financial Cloud using the DMLC.

Research and develop statistical learning models for data analysis

Data Strategy and Roadmap for future and current state for organizational mission.

Collaborate across the Intelligence Community especially with product management and engineering departments to understand company needs and devise possible solutions

Create the Target Vision for Enterprise Data Usage

Facilitate Paradigm Shift from Current to Target State

Develop linked-data common formats in HTML, JSON/JSON-LD, XML, CVS, and RDFa for packaging data

Develop with various NoSQL such as Marklogic, Niagra Falls, Spark, and SPARQL

Develop MSQL database and scripts and familiarity with pure RDF databases: Sesame, Kowari, and Intellidimension

Develop and store triples in relational databases: Jena, Oracle 11-12g, PostgreSql

Research and stay current with the latest technology trends

(Client) Wood Consulting Services, Inc, MD, National Security Agency (NSA), Ft. Meade. Sr. Principal Systems Engineer/Extraction Transformation Loading (ETL), Sept. 2016 – June 2017 Responsible for supporting Data Ingest and Performance Visualization Services. Job Achievements:

Ingestion of restful data sources using the MS Sql Server SSIS package.

Database programming with SQL and T-SQL including replication, data warehousing, data transformation, and stored procedures.

Application design, development, implementation with strong distributed architecture and concepts, and data management using Oracle PL/SQL, Informatica, and Netezza.

Use Visual Studio for ETL processing and C# and VB.Net programming for the script component of SSIS.

Configuration management using Team Foundation Server (TFS).

Gather and analyze data requirements for solutions based on derived system/application design

Data analysis and data migration using SSIS packages.

Data transformation, conceptual data modeling, data transformation and metadata management

Database Design with logical, physical, and dimensional data modeling. Resume – Michael C. Campbell

Troubleshooting any issues regarding SQL Server,ETL processes, and Web Services

Use Agile Development methods and practices such as SCRUM and Kanban. University of Maryland University College, College Park, Maryland Adjunct Professor for Information Systems Management (IFSM), June 2012 – Present Part-time (Evenings) Professorship of Information Systems Management Job Achievements:

Plan and present Information Technology theory and practice to Students

Conducted undergraduate lectures in various levels of Information Technology in areas such as Systems Analysis and Design, Systems Engineering, project management, and computer science theories.

Excellent skills in both written and oral communication.

(Client) ISM Services, Inc, Carmichaels, PA / Agency: National Security Agency (NSA), Annapolis Junction, MD Sr. Database Engineer, March 2016 – September 2016 Responsible for supporting the database engineering effort for the Installation and Logistics Division for the NSA. Job Achievements:

Provide technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis.

Develop relational, dimensional, and/or Object-Oriented databases, database parser software, and database loading software for interfacing with Archibus.

Projects long-range requirements for database administration and design.

Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users logical and physical distribution, response times, retention rules, security and domain controls.

Works primarily at the front end of the lifecycle- requirements through system acceptance testing and Initial Operational Capability (IOC).

Develop Powershell for directory and file manipulation.

Builds complex system queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

Develops requirements from a project’s inception to its conclusion for implementing data ingestion into the Archibus

(Client) Bogart Associates, Vienna, VA / Agency: Federal Bureau of Investigations (FBI), Washington, DC Sr. Project Extract Transform Load (ETL) Administrator / Data Engineer, April 2015 – March 2016 Responsible for planning, directing, coordinating, managing, and providing oversight of all IT Project data from multiple intelligence sources utilizing enterprise application development, advanced visualization, analytical platforms, and enterprise knowledge to provide link analysis, knowledge management, and collaboration tools to enhance the capabilities of investigative teams including business partners.

Job Achievements:

Lead and manage complex ETL – SQL Server Integration Services - and Oracle DBA projects having multiple dependencies and vague requirements for the FBI Insider Threat Program.

Architect ETL solutions and data conversion strategies for 200+ new data sources such as Oracle, DB2, Sybase, SQL server, MS access and non-relational sources such as flat files into staging area.

Analyze, review and interpret data in existing databases or sources to identify the data extraction, transformation and loading requirements using open-source programming languages such as Python, Java, and Unix Shell

Collaborate with Intelligence /Business Analysts to identify and define atomic data items within unstructured data sources that can be extracted and stored as actionable data.

Integrate Data by developing ETL mappings and scripts using Informatica PowerCenter 9.x and Microsoft SQL Server –SSIS and T-SQL.

Developed Powershell modules in C# and Powershell featuring commandlets to interface with 46 remote servers and files.

Used Powershell for file conversion and extraction of pertinent information.

Provide via data analytics, algorithms, large data structures, large-scale datasets, and real-time search platform using Apache Solr, Apache Lucene and data analysis to develop enterprise search solutions to solve complex challenges surrounding data analytics and Elastic Search engines, utilizing cloud technologies.

Perform advanced sort and filter to view search results based on relevancy in the production environment.

Agile project management using the SCRUM process while adhering to agency standards and policies, promote improved engineering practices, resolve impediments, and track development and operational support via user stories and decomposed technical tasks via the tracking software - JIRA.

Provide oral and written communication on project success/failure through recommendations, lesson learned, analysis, Resume – Michael C. Campbell

justification, and instructions to Upper Management and Team Members.

Conduct and assess new technologies (Big Data and Cloud Technologies) being introduced to the project and define technology roadmaps, reference architectures, patterns, and standards and assess the compatibility and integration of products proposed in order to ensure an integrated architecture across interdependent technology segments within the FBI.

(Client) BAE Systems, McLean, VA / Agency: Dept. of Homeland Security – US Coast Guard, Washington, DC Sr. Oracle Database Engineer/Developer, Nov 2014 – April 2015 Responsible for production/development support for the US Coast Guard that require application specific knowledge or investigation.

Job Achievements:

Assumed ownership of database related problems pursuing root cause analysis and problem resolution through coordinated interaction with database vendors and internal support teams.

Installation, configuration and upgrading of Oracle server software and related products

Establish and maintain sound backup and recovery policies and procedures

Database design, development, and implementation

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for the applications.

Executed high risk changes that required specific application knowledge or used new technologies, approaches or techniques especially with Big Data - HADOOP, NoSQL – Accumolo, MS SQLServer, and Oracle Regular Expressions.

Project lead technical and systems requirements to deconflict complex functional requirements and recommended “best fit” technical requirements.

Used SCRUM process for Project Management in software development and systems engineering.

(Client) Fulcrum-IT, Centerville, VA / Agency: Office of Naval Intelligence (ONI), Washington, DC Project Manager/Sr. Oracle Database Engineer, Sept. 2013 – Nov. 2014 Responsible for the ONI’s Maritime Intelligence Surveillance Reconnaissance Enterprise (MIE), which is a suite of systems that receives Vessel Movement Data (VMD) as well as select characteristics data ingested to current and achieved databases known as SEAWATCH and Merchant Ship’s Characteristics Database (MSCDB). Job Achievements:

Engineering and technical assessments and suggested solutions for applications/database anomalies, user interface bugs, and deficiencies in functionality.

Engineering, implementation and support for high availability solutions using, Real Application Clusters (RAC), Data Guard, Oracle Streams, Replication and specific network storage and clustering solutions.

Successfully engineered, implemented, documented and supported upgrade of the environment to Oracle 11g. Lead engineering effort, implementation and support a migration of an existing Oracle 11g RAC (64cpu/128gb RAM/60Tb ASM disks on Solaris) environment.

Engineered, implemented, documented and support builds of new clusters to use Oracle 11g/11g RAC on Solaris 10. Including installing clusterware, ASM (and shared disks) and creating new databases.

Provides for continued technical assessment and redesign or fixes to support the deployment of or reintegration of the component into the ONI Enterprise.

Development of database schema design for integrating source data into data management systems.

Provides for the Oracle design, development, deployment, testing, user acceptance, security accreditation, and full transition of requirements.

Flexibility to stream-line project activities while managing various Stake-holders requirements.

Supported assessments that increased capacity, strengthen security, and improved reliability and maintainability, and supported the deployment of applications to additional networks.

Provided software development and systems engineering and programming.

All phases of product testing, technical writing, and security engineering. C&C Information Technology, Hyattsville, MD / Agency: Defense Intelligence Agency (DIA), ONI Project Manager/Sr. Oracle Database Engineer, Dec. 2008 – Sept. 2013 Responsible for DIA’s Portico and Cornerstone applications to the next generation suite of enhanced applications called Portico Next Evolution and ONI’s ITTM2 project.

Job Achievements:

Oracle Database Administration and engineering

Oracle and Sybase database design to include database conceptual and physical, schema design, indexing and advanced SQL query capabilities (unions, inner/outer joins, soundex), database views, and stored procedures Resume – Michael C. Campbell

Coordinate format requirements for data interfaces with mission critical systems

Technical POC for interface requirement issues

Provided compliant open standards based architecture for information sharing with Counterintelligence community/systems, Department of Defense (DoD), and Department of Defense Intelligence Information System (DoDIIS)

Testing for security vulnerabilities using FORTIFY

Applied critical thinking and analysis for project assessments to identify Stakeholder requirements.

Performed software engineering to support the integration of new / additional functionality into the system and/or modify existing system functionality.

Technical POC for User interface requirement issues. SkillStorm Govern. Integrated Solutions, Vienna, VA / Agency: National GeoSpatial Intelligence Agency (NGA) Project Manager/Sr. Oracle Database Architect, Feb. 2007 – Dec. 2008 Responsible for Oracle Database Administration, Project Management, and Data Architecture and Engineering to National GeoSpatial Intelligence Agency (NGA) for transforming a collection of large independent systems and databases into a web-based, data-centric, service oriented GEOINT enterprise. Oracle 10g and 11g Functional lead for implementing a new Data Center and Lab. Job Achievements:

Responsible for a large IT outsourcing program providing program management and total life-cycle management of a data center, network, telecom, security, service desk and applications and transformation activities.

Management and delivery of database design and implementation for a new 35000 square feet Data Center and laboratory facilities, gateways, database tools, and services.

Expert knowledge of computer disciplines that facilitated the definition of service level agreements (SLA) and customer requirements.

Created and managed overall project plan.

Provided technical direction and management – coaching, Oracle DBA Team lead.

Designed database structures that fully implement business requirements, development, and maintenance functions to achieve correlation, completeness and consistency across GeoScout data and architecture. Multiple Technical, Managerial and Consulting Positions from 1988 to 2006: 08/06

–

08/07

Sr. Principal Database Engineer/DBA/ISSO/SA - Athena Innovative Solutions, Inc, Arlington, VA

Provides Senior Oracle Database Administration, Project Management, DB Engineering to the US Army and Air Force. Executes the following duties as summarized:

• Establish and install entire Oracle environments including Linux server.

• Database Programming with Oracle 10g Text and Oracle Application Express

• Experienced with Oracle High Availability: RAC, Advanced and Stream Replication, Multi-Master Materialized Views

• Responsible for computer system security and accreditation as the ISSO

• Lead Data Modeler using Irwin

• System Administration of the Linux server and client machines

• Conceptualize, define, and develop complex database architecture solutions for large enterprise wide application

• Relational Data Base design and engineering to include entity-relationship modeling and database programming.

• Analysis and development of data cleansing methodologies

• Develop and implement migration plans to move legacy Oracle into current information systems.

• Develop and communicate data architecture, data quality, and data integration policies, standards, guidelines, and procedures

• Lead technical Personnel for the strategic oversight and planning of data models and database structural design and development.

• Work with customers to define system/application scope, objectives, and processes required to ascertain that the function for the Army and Airforce are appropriately analyzed.

Environment: Oracle 10g on a Red Hat Enterprise Linux AS release 4 and Windows XP Servers. TOOLS – SQL Navigator, Erwin, Oracle Application Express 2.2, Analyst Notebook II.

Resume – Michael C. Campbell

07/05

–

08/06

Technical Project Manager/ Lead. Oracle Database Engineer - SRA Spectrum Solutions Group, Vienna, VA. – Now SRA International, Inc since November 2005. Provides Senior Oracle Database Administration and Project Management to the United States Secret Service within the Department of HomeLand Security. Chief Consultant for all systems within IRMD falling under four main Enterprise-wide categories of systems and sub-systems: (1) Protective Mission – 12 subsystems; (2) Enterprise Mission Support - 13 subsystems; (3) Investigative Mission – 21 subsystems; (4) Enterprise Business Support – 49 subsystems to include Financial Management Accounting System(FMAS), Oracle Financials, Sunflower, PRISM_Pro, Web Interfaces with Websphere Portal, and MS-SQL administration. Executes the following duties as summarized:

• Develop and communicate data architecture, data quality, and data integration policies, standards, guidelines, and procedures

• Senior Oracle Database Administration to include recovery, migration, tuning, and writing stored procedures

• Lead technical resource in the strategic oversight and planning of data models and database structural design and development.

• Provides structural design and development of databases/data warehouse and metadata repositories.

• Develops customer data and metadata policies and procedures for structural design and development to build, maintain and leverage the data model, ensuring integration with established data standards.

• Plans new designs for data source integration into the designed database/warehouse structure, using knowledge of the existing systems added to the structure and the specifications for database interfaces to ensure effective integration and optimal database performance.

• Provides extensive technical advice and strategic guidance to senior managers and technical resources on the creation and implementation of new data standards and databases.

• Interface with business operations and technical staff at multiple levels

• Oracle full project life-cycle implementations / upgrades

• Install, configure and deploy Oracle Workflow

• Backup and Recovery: RMAN

• Implement and managed Oracle Label Security

• Mentor and provide consultation to Systems Analysts on design and analysis of databases.

• Perform database design through diagramming methods such as ERD and data flow diagrams using Oracle Designer.

• Provide logical and physical data models for enterprise-wide capabilities in relation to development

• Oracle migration and new implementation projects including Oracle 11i Federal Financials Apps.

• Examine the current status of the Financial modules, gather requirements for the configurations, perform a fit-gap analysis, and work with the client and Oracle Applications DBA for a successful implementation.

• Develop functional specifications into technical design through requirements gathering and Gap Analysis

• System configurations, and System unit and integration testing.

• Data Warehouse Administration using Informatica to include the ETL and DTL processes, Data Mining, and Star schema design.

• Collaboratively plan, document, and present data strategies, achieve buy- in from IT leadership, and manage the strategy implementation process

• Perform complex analysis, and prepare documentation which establishes business objectives, problems, options, and makes recommendations

• Communicates effectively across functional and technical areas through creating detailed process flows, specifications, and configuration documents to achieve the desired results.

Resume – Michael C. Campbell

Environment: Oracle 8, 8i, 9i (9.2), 10g, Financials 11i on a Unix Sun Solaris 2.9, and Windows NT and 2000 Servers utilizing J2EE, XML, and Perl. TOOLS – SQL Navigator, Erwin, Oracle Designer, Informatica, Business Objects – Crystal Reports XI, and Websphere Portal.

06/04

–

07/05

Sr. Principal Consultant / Sr. Oracle Database and WareHouse Engineer Computer Networks & Software, Springfield, VA

Provides Oracle Administration and Project Management to the various departments within the Office of Naval Intelligence (ONI). Direct responsibility as Senior Oracle DBA and Project Lead for a new multi-tiered web architecture application called the National Cargo Tracking Plan (NCTP) for the Cargo Tracking Division (CTD) in ONI Civil Maritime Analysis Department. Executes the following duties:

• Technical Project Leader for activities related to the administration of databases in a client/server environment for highly complex projects involving Database Management Systems (DBMS) applications and/or generation of new technologies and concepts.

• Work with customers to define system scope and objectives, obtaining, implementing, maintaining, managing and refining the services, technologies, and processes required to assure appropriate security and function for the National Maritime Intelligence Center (NMIC).

• Full lifecycle Web development projects for multiple architectural platforms leading large multifunctional teams to ensure congruence of the various databases and interface approaches.

• Develops and improves strategic processes and technical direction exercising creativity and decision making while leading the efforts of other database administrators to ensure system requirements are met, and activities are compatible with applicable standards, and that unique customer design-to-cost and life-cycle cost requirements are met.

• Formulates and monitors policies, procedures, and standards relating to database management.

• Act as an internal consultant providing DBMS expertise and advice to users of various client/server databases as requested and provide work direction and guidance to others.

• Design and develop audit trail measures and reports associated with data access and security to include identification of database vulnerabilities, apply security patches, and database audits.

• Setup the development, test, and production server and configure as directed by the NMIC.

• Install Oracle on development, test, and production data servers

• Implement partitioning and indexing strategies.

• Design and install the physical database and tune to support the user community.

• Design, develop and maintain stored procedures associated with an application

• Administration of Oracle Warehouse Builder to include the ETL and DTL processes, Data Mining, and End-User Tools

• Integrate/maintain Oracle Workflow with Oracle Warehouse Builder to handle dependencies between processes.

• Administration of Business Intelligence using Business Objects for NCTP

• OLTP, OLAP and reporting database designs using Business Objects Crystal Reports

• Wrote/ debugged/ tuning SQL and PL/SQL

• Administer Oracle Label Security and the EM Control Grid for 10g.

• Database Backup and Recovery, Recovery Manager (RMAN).

• Administer and maintain Oracle, Microsoft SQL Server, Sybase, and Interbase replication services.

• Administer Oracle Database Application Server and WEB environments. Resume – Michael C. Campbell

Environment: Oracle 8, 8i, 9i (9.2), 10g, 9iAS, and 10gAS on a Unix Sun Solaris 2.9, Windows NT and 2000 Server utilizing J2EE, XML, and Perl. TOOLS – SQL Navigator, Erwin, Oracle Portal, Oracle Label Security, Oracle Workflow Server, TOAD, Business Objects (6), VisuaLinks, Digital Information Gateway, Remedy CRM. 05/01

–

05/04

Project Leader / Central Oracle Database Administration– Science Applications International Corp., Falls Church, VA

Provided Oracle Administration within a distributed system environment for the Provisioning Information Management System (PIMS), World Wide On-Line System Replacement (WWOLSR) System, and Status of Service (SOS) systems used to support the Defense Information Systems Agency’s (DISA) telecommunication services to all DOD and Agencies for customer relationship management, customer account managers, network configuration management activities to include functional areas of network design, engineering, service status tracking, inventory, master scheduling, finance, INS NCS, contracting, and configuration management; technical project leader for activities related to the administration of Oracle databases involving highly complex projects with Database Management Systems (DBMS) applications and/or generation of new technologies. Execute the following Oracle DBA duties to include:

• Project Management: Project Lead DBAs around the

Contact this candidate