Open to opportunities

Dennis Maingi

@dennismaingi

Data Modeler at THE NATIONAL INSURANCE COMPANY DAMAN shaping enterprise healthcare data models and migration mappings.

At THE NATIONAL INSURANCE COMPANY DAMAN, I design and maintain enterprise data models for the Data Modernization project. I work across OLTP and analytical environments, and develop source-to-target mappings for data migration.

At DATASEALSOFTWARE LTD., I designed a cloud-native banking data warehouse using Azure Synapse and Data Vault 2.0. I developed ETL pipelines with SSIS and Azure Data Factory, and built CI/CD pipelines for Azure Data Factory and Synapse assets.

On DATASEALSOFTWARE LTD.'s CDP (Customer 360 Data Platform), I led the design and implementation of conceptual, logical, and physical data models. I also contributed to data governance, reporting models, and ETL workflow design.

For the IHDA healthcare insurance data warehousing solution, I customized and extended IBM UDMH and translated business requirements into data models. Earlier at STEADYTECH SOLUTIONS, I implemented SQL ETL logic and built PL/SQL packages to automate reporting processes.

Experience

Work history, roles, and key accomplishments

Current

Data Modeler/Information Designer

Current

The National Insurance Company Daman

Oct 2025 - Present (1 year)

Collaborated with cross-functional teams to gather requirements and designed enterprise conceptual, logical, and physical data models using Erwin and Navicat. Led data migration initiatives and developed enterprise data warehouse models using dimensional and Data Vault 2.0 approaches.

Erwin Navicat Oracle SQL Server Oracle GoldenGate SingleStore Azure Informatica Airflow Power BI Excel DataVault 2.0 Dimensional Modeling Data Governance Data Migration Source To Target Mapping Microsoft Purview UAE PDPL

Senior Data Engineer/Developer

DataSeal Software Ltd.

Feb 2024 - Aug 2025 (1 year 6 months)

Developed ETL pipelines using SSIS and Azure Data Factory, designed cloud-native data warehouses with Azure Synapse and Data Vault 2.0, and provided production support. Authored T-SQL stored procedures and optimized performance, reducing load and query times by 50%.

Azure Synapse Azure Data Factory SSIS T SQL PySpark Databricks Erwin SQL Server Oracle Azure DevOps TFS JAMS Scheduler Informatica Cloud Data Quality Microsoft Purview DataVault 2.0 Performance Optimization CI CD

Data Architect

DataSeal Software Ltd.

Sep 2022 - Jan 2024 (1 year 4 months)

Led data architecture team in designing conceptual, logical, and physical data models using Erwin, implemented star and snowflake schemas, and orchestrated ETL workflows with Apache Airflow. Supported data governance and maintained metadata and lineage.

Erwin Oracle Data Modeler SQL Server Oracle 11g SSRS Pl SQL Azure Data Factory Azure Data Lake Storage Azure Synapse Snowflake Salesforce Airflow Microsoft Visio Data Governance Star Schemas Dimensional Modeling (Star And Snowflake Schemas)Medallion Architecture

Data Modeler

DataSeal Software Ltd.

May 2021 - Aug 2022 (1 year 3 months)

Led data migration from OLTP sources to a cloud-based OLAP data warehouse, customized IBM UDMH for healthcare insurance, and designed star schema and Data Vault models. Implemented metadata management and data governance practices.

IBM Data Architect (IDA)DB2 Netezza Oracle 11g Informatica Cloud Toad SQL Server GitHub Python HL7 Tableau Data Vault Star Schemas MDM Data Governance Metadata Management

SQL Developer/Data Analyst

Steadytech Solutions

Jan 2019 - Mar 2021 (2 years 2 months)

Implemented ETL logic in SQL, designed and implemented PL/SQL packages and procedures, and created logical and physical data models. Provided production support and performed SQL data analysis to ensure data integrity.