SUMMARY:

• Over 40 years of leadership of and hands on experience in IT development and data architect teams throughout conception and the entire life cycle for multi - tier architecture of large enterprise heterogenous systems with data warehouse and decision support applications during planning, analysis, design, dimensional modeling, change detection, SCD dimensions, development, administration, testing and support for government & commercial on premises and hybrid cloud data centers using traditional and modern methodologies, e.g., Agile, Scrum.
• Has significant and recent data architecture and engineering experience with structured and non- structured data technologies using data analysis, modeling, validation/purification, presentation layer, dashboards, key performance indicators (KPIs) with data cubes, data marts and operational data stores.
• Has held high national security clearances and currently holds a public trust clearance.

TECHNICAL SKILLS:

Data Base Management Systems: Oracle 7-19c, SQL Server 7-2019, DB2, PostgreSQL, MongoDB, MySQL, NoSQL

Data Analysis/ICASE: TOGAF, Zachman, Rational Rose, Oracle Case, ERWin, ER Studio/Data Architect

Operating Systems Administration: Centos 6-7, RHEL 6-7, Windows 3-10, HP-UX, Linux, Sun Solaris v6-10, AIX

Programming Languages: Java, Visual Basic, C, Python, SQL*Plus, PL/SQL, T-SQL, SAS, R

Other Tools: SSRS/SSIS, ETL tools, Power BI, Azure ML, MS Project, Git, JIRA, Confluence

PROFESSIONAL EXPERIENCE:

Confidential

Lead Data Base Engineer

Responsibilities:

• Performed system engineering effort for DoED Information Assurance Systems Engineering & Support effort
• Led database and system engineering effort for DHA/JMLFDC on Defense Military Logistics Supply System supporting over 220 military hospitals worldwide using Oracle 11g-19g and migrating to MongoDB and PostgreSQL in AWS
• Served as a Senior Data Architect/Engineer at T. Rowe Price on AWS data warehouse ETL Python development
• Consulted to Baltimore medical offices in planning, design, testing and implementing of CRM ETL Azure solutions.

Primary Skills: Tenable, Oracle, SQL Server, PostgreSQL, Snowflake, MongoDB, NoSQL, AWS, Azure

Confidential, Baltimore, MD

Senior Consultant and Systems Engineer

Responsibilities:

• As a Microsoft Consultant, advised Fortune 500 customers on migrating to Azure Infrastructure as a Service (IaaS) & Platform as a Service (PaaS) cloud environments from on premises data centers and end users for high availability/disaster recovery. Planned and performed evaluation of non-structured databases such as MongoDB and Hadoop (HDInsight) for a cellphone company. Provided operational improvement recommendations for a financial information service for hybrid on premises/cloud data centers. Developed BI dashboards for Microsoft stack for DHA.
• Provided team leadership in a system reengineering effort to improve data integrity and poorly performing SQL Agent Jobs for Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) for a major telecommunications company. Developed SCCM dashboard reports using SSRS (Report Builder) and Visual Studio for DoD customers.

Primary Skills: SQL Server, PostgreSQL, Oracle, MongoDB, NoSQL, Azure

Confidential, Baltimore, MD

Co-founder/Senior Systems Engineer

Responsibilities:

• Developed Enterprise Data Vigilance System (EDVS) as a commercial product for defensive measures against data breaches, information system compromises and other cyberattacks in information technology (IT) environments in the public and private sectors. EDVS monitors system status, manages notifications of alerts for conditions of concern, and assists in the remediation of cybersecurity issues. Any areas of concern that can be monitored, should and can be automated in the EDVS.

Primary Skills: Oracle, SQL Server, MySQL, NoSQL

Confidential

Senior Systems/Data Base Engineer

Responsibilities:

• Served as the Senior Systems Engineer for support team for a large federal intelligence agency on CA Clarity PPM system providing PKI security engineering for Tomcat servers and database program development. Served as Senior Database Engineer on HP enterprise systems monitoring team and performed Linux Oracle 12c installations, 10g and 11g upgrades, patching and conversions for specialized database applications. Provided technical guidance in software engineering and automated support tools for Oracle migration.
• Performed database modeling, design, programming, testing and administration on a secure mechanism for establishing Row Level Security for extending PostgreSQL 9 for a large federal intelligence agency. The secure Select, secure Insert, secure Update and secure Delete trigger functions are to be implemented in specific applications to meet PL3+ security requirements for transition from Oracle OLS to mandated FOSS RDMBS. PostgreSQL 9.2, RHEL, pgAdmin III, plpgsql, Eclipse, Subeclipse, C and C#.

Primary Skills: Oracle, PostgreSQL, MySQL

Confidential

Senior Database Engineer

Responsibilities:

• Served as lead for data conversion, production DBA and performance tuning expert for secure PeopleSoft environment for a recruiting firm. Conducted data modeling and system configuration research for a large federal government database. Oracle 9i-10g, Solaris 10, HP-UX 11, PeopleSoft Financials & HR.
• Technical recommendations for implementing NoSQL document database products such as MarkLogic.
• As a Senior Principal Information Engineer, installed, configured, developed, and administered Oracle 11gR2 Grid Infrastructure and Real Application Clusters (RAC), Oracle Enterprise Manager Grid Control and Oracle Cloud Control 12c, DB2, shell scripting, PL/SQL and Java using Data Architect. Produced internal documents for a large federal intelligence agency infrastructure for ISO9000, ISO20K, ISO27K & ITIL.

Primary Skills: Oracle

Confidential, Baltimore, MD

Sr. Project Manager/Database Admin

Responsibilities:

• As Team Lead/Senior DBA, performed data architecture and design activities for new data center, led the

Primary Skills: Oracle, SQL Server

Confidential

IT Consultant

Responsibilities:

• Developed and supporting complex database and data warehouse ETL packages and jobs using SSIS in a Windows .Net SQL Server 2012 for a large federal intelligence agency to re-engineer a critical enterprise system function in C#, VB.NET, JSON, XML and PowerShell
• As Lead/Senior DBA Performed data analysis, data modeling, design, development, and database maintenance while supporting developers and data administration security policies for the Office of Administration, Executive Office of the President. Led a data migration project for mainframe DB2 to midrange servers Unix Oracle 8i-10g & SQL Server databases. DB2, PL/SQL, Data Architect, Solaris 8
• Led a team and participated in business analysis, data modeling, design, and secure implementation effort for the TSA Hazardous Materials Endorsement (HME) Document Management System and Screening Gateway for terrorist and law enforcement background checks for applicant case adjudication in coordinating secure HME applicant digital correspondence. Conducted joint application development (JAD) sessions with 20+ users & technical staff.
• Performed system planning, business analysis and data modeling at Army Environmental Center HQ for Army’s Military Munitions Response Program. Led five technical and functional staff using RAD/JAD techniques and rapid prototyping of web User Interface alternatives. Performed use case refinement,database, and application design EJB development using MVC, data conversion and testing. Java, JSP, JDeveloper, Oracle 8i, Developer & Reporter, PL/SQL, UML, Solaris 8, AIX 5.2, MS Project, Office.

Primary Skills: Oracle, MySQL

Confidential

Project Leader/Senior DBA

Responsibilities:

• Performed supervision of production DBA tasks including mentoring one junior DBA, troubleshooting complex problems for Verizon Connected Solutions, Inc. in White Marsh data center. Led a team of five people in analysis, data modeling, and design and implementation of Oracle 8i and DB2 database systems.
• Responsible for establishing and coordinating enterprise database activities for T. Rowe Price’s Emerging Technologies Center. Project Manager for CAST Sybase data modeling and impact analysis tools saving company over $1 million in fiscal year 2000. Oracle, Sybase, DB2, Solaris, Patrol, Project, Office.