Adam H.

Full Stack Data Engineer and Principal Technical Consultant with decades of experience in Oracle Database Architecture and Administration, Javascript Full Stack Development, Cloud Data Integration Pipelines, and DevOps Core Competencies: Cloud / Database: Azure Data Factory, Azure Databricks, Delta Lake, Unity Catalog, Oracle OCI, Oracle RAC, MongoDB, SQL Server Infrastructure / DevOps: Terraform IaC, Ansible, GitHub Actions CI/CD, Linux, NGINX, VM, Containers Languages / Frameworks: Python, Node.js, Vue/Nuxt, C#, PL/SQL, T-SQL, JavaScript (ES6+) Integration: REST / SOAP APIs, RCP, Twilio, SendGrid, Workday Adaptive Insights, NetSuite, Plex, Dynamics365, QBO, Salesforce, etc. Security: OAuth2, JWT, Databricks RBAC, TLS/SSL Methodologies: PM > Agile, Waterfall, SOW Management, Technical Design Review, Knowledge Transfer Planning Compliance & Security: SOC 2, HIPAA, STIG, SOX Experience: Adam Helm Consulting, Inc: Owner and Principal Technical Consultant (2020-Present) Prism PPM: Senior Data Engineer (1/25 - Current) Partner with third-party vendor to design and implement a new business intelligence platform for the company’s SaaS-based Project Portfolio Management application, modernizing reporting and analytics capabilities. Developed and implemented the Change Data Capture (CDC) in Oracle for reliable downstream replication. Consulted on the design and implementation of Azure Data Factory pipelines to extract and transform Oracle source data into partitioned Parquet datasets in Azure Data Lake Storage Gen2 for downstream Databricks ingestion. Oversaw the implementation of a Databricks Medallion architecture using PySpark and Delta Live Tables to process Oracle-sourced Parquet data — deduplicating Bronze-layer ingests, reconciling CDC changes in Silver, and modeling Gold-layer fact and dimension tables powering embedded Power BI analytics. Introduced row-level security (RLS) and Unity Catalog for governed analytics access. Implemented Databricks Delta sharing capabilities for real time Databricks to Databricks integrations. Assisted with the design and automation of a Terraform-based Infrastructure-as-Code (IaC) framework to deploy Azure Data Factory, Key Vault, Storage Account, SQL Database, Log Analytics Workspace, and Managed Identities across dev, test, and production environments. Integrated environment configuration via YAML templates and automated validation through Go-based Terratest to ensure consistent, repeatable deployments. Ensured full alignment to the Statement of Work, validating deliverables and maintaining accountability. Assisted with the creation of the Technical Design Document (TDD) to eliminate ambiguity and ensure maintainability. Structured and led Knowledge Transfer (KT) sessions to equip stakeholders for post-implementation support. Participated in a cross-functional strategy and innovation summit in Cluj-Napoca, Romania, collaborating with engineering, product, and analytics teams to align on AI enablement, process maturity, and delivery KPIs — resulting in improved clarity around product strategy and execution. Casne Engineering: Principal Oracle DBA (2006 – Current) For BP, Perform Oracle upgrades and lead system migrations Assist with Oracle performance optimization through schema design and indexing strategies. Develop Ansible patch automation process / develop application stored procedures and triggers Create HA and DR / backup and recovery strategy. Dropkick Media: Full Stack Engineer (2022 – 2025) Developed a full-stack Nuxt.js application with a Node.js/Express backend and MongoDB database, designed for large-scale web data indexing and search. Integrated Puppeteer and Cheerio to automate browser sessions and extract structured data from publicly available web pages. Implemented secure authentication using JWTs, bcrypt, and Nuxt middleware for session handling and protected routes. Built a dynamic search and filtering interface using Vuetify, Vuex, and Axios to deliver fast, user-friendly data exploration. Configured a scalable server architecture with environment-based builds, REST APIs, and integrated health monitoring endpoints. CSC - Bath Iron Works Client: Senior Oracle DBA Decouple and redevelop Sybase back-end system in Oracle. Saved the company $30K in recurring licensing fees for a one-off Sybase system. Lead DBA in charge of scoping and deploying Oracle RAC databases infrastructure including CRS and ASM to optimize horizontal scaling. Led the geographic relocation of production database system for Enovia when Bath Iron Works became prime contractor for the DDG1000 program. Stanford University: Self Study, Computer Science: Completed hundreds of hours of self-study in computer science, focusing on algorithms, programming methodologies, and software design principles using CS106A and CS106B course materials.