Mark Isaacson Email & Phone Number

Bloomfield, Ct, Us

Data engineer and project lead in Data Analytics and Engineering department.Led development of process to convert ActiveBatch ETL scheduling jobs to Airflow/MWAA, parsing and interpreting ActiveBatch XML to generate thousands of Airflow DAGs automatically.Built Python-based SQL tokenizer and parser to convert thousands of Teradata SQL statements and stored procedures to Databricks / Spark SQL. Includes rewriting DDL, DML, and SQL functions; supports conversion of arbitrary-depth subqueries and flow control statements.Designed and developed prototype Semantic Layer using AtScale, dbt, and Databricks, providing a unified, self-service OLAP layer to data analysts.

Create automated ETL SQL generator in Python based on standardized business specifications retrieved from Erwin Edge repository. Eliminated boilerplate ETL code and improved development efficiency of team by 80%.Created process to extract and scan SQL repository (procs + SQL) to develop a data lineage and usage repository.

San Francisco, Ca, Us

Consultant guiding design and development of Liquibase integration effort with git and Jenkins as part of a devops/CICD effort to enable developers to automate database deployments in a controlled fashion.

New York, Ny, Us

OLTP and OLAP Database Development and Design Manager, ETL DeveloperAs a member of the Finance Data Infrastructure Team,● Designed and created Accounting Enrichment and Projection, a SQL-oriented, rules-engine-based process that converts 300+ million balance records daily into enriched, double-entry accounting records that serve as a detailed financial subledger.● Developed custom database DDL deployment tool, then later enhanced to work with customized Liquibase. ● Created reconciliation tool to compare tables on 2 Teradata servers containing over 100TB of data, using hash value / checksum approach to remove need to pull all data to client.Earlier: ● Managed project and led team of six consultants remediating all Corporate Actions code to support Kerberos-based authentication for Sybase (Sybase, C, perl, Java, ksh)As a manager in CIS (Client Information Systems),● Supervised development and support of the CIS database, the firm’s global CRMrepository, managing a team of database developers, application DBAs/data modelers, mainframe developers, and support personnel.● Simultaneously, managed a Services / middle-tier development team (tasked with development and support of a SOAP-API based middle tier for the CIS area)

A.B., Molecular Biology

Masters Program