?
Took over an over-engineered legacy
codebase, successfully consolidating 10 fragmented Maven projects into a clean
4-module architecture. Ripped out obstructing Hibernate ORM, replacing it with
Spring JDBC Template to efficiently manage multi-database routing across 15
physically separated warehouse databases.
?
Engineered the backend to process heavy transactional loads from
warehouse telemetry and Android devices (up to 350,000 Kafka messages daily per
warehouse/~5M+ events system-wide) into structured PostgreSQL databases.
?
Designed a dynamic pivot-reporting
engine allowing users to aggregate KPI data across 40 categories and 5 levels.
Optimized complex dynamic SQL queries, drastically reducing report execution
time from hours to mere seconds/minutes.
?
Implemented aggressive database optimization strategies using
Materialized Views, dynamic PostgreSQL table partitioning (daily retention
management), and for automated background maintenance tasks.
?
Architected a complex distributed
system to ingest encrypted HR data (salaries, hours) and calculate employee
productivity across multiple regional databases, handling edge cases like
shifting calendar periods and cross-warehouse logic.
? Redesigned the data pipeline to resolve critical Stonebranch UAC workflow failures. Engineered a highly performant denormalization strategy, consolidating over 500 multi-domain, hierarchical dictionaries into a single payload, which is dynamically parsed and staged via stored procedures, .
?
Transitioned legacy manual Excel workflows into a robust,
multi-tenant (10 tenants) data model using . Enforced
strict tenant shielding and data privacy rules within a highly regulated
environment.
?
Bypassed limitations of the native MDM
tools by developing and managing a suite of 10+ custom Java/Spring Boot
applications for deployment orchestration, metadata editing, and automated
Excel processing (utilizing SIF calls and direct DB access). Front-end
implemented in Vue.js due to corporate restrictions on React build processes.
?
Architected a 3-tier automated
deployment pipeline. Replaced manual Hub Console promotions with automated
MetCommand metadata synchronization wrapped in packages
via .
? Automated workflow versioning and data transfers using Python and legacy Perl scripts (LCD libraries). Integrated for secure credential management, for automated open-source vulnerability scanning and implemented the ELK stack for log monitoring.
Took over complete technical ownership from external Informatica consultants, resulting in significant cost savings. Introduced Git Flow (release branches), 4-eyes principle code reviews, and automated Release Notes generation directly into Confluence based on Jira issues.Engineered the central data-quality enforcement and workflow engines using TIBCO EBX5.
Designed complex data model transformations, integrating the MDM hub with local core banking systems and downstream BI consumers.
Implemented complex relationship mapping to visualize counterparties and link them to risk structures.
Integrated external risk data feeds into the MDM hub to ensure accurate calculation of credit exposure across the entire banking group.
Led database performance optimization and deployment management.
?
Took over an over-engineered legacy
codebase, successfully consolidating 10 fragmented Maven projects into a clean
4-module architecture. Ripped out obstructing Hibernate ORM, replacing it with
Spring JDBC Template to efficiently manage multi-database routing across 15
physically separated warehouse databases.
?
Engineered the backend to process heavy transactional loads from
warehouse telemetry and Android devices (up to 350,000 Kafka messages daily per
warehouse/~5M+ events system-wide) into structured PostgreSQL databases.
?
Designed a dynamic pivot-reporting
engine allowing users to aggregate KPI data across 40 categories and 5 levels.
Optimized complex dynamic SQL queries, drastically reducing report execution
time from hours to mere seconds/minutes.
?
Implemented aggressive database optimization strategies using
Materialized Views, dynamic PostgreSQL table partitioning (daily retention
management), and for automated background maintenance tasks.
?
Architected a complex distributed
system to ingest encrypted HR data (salaries, hours) and calculate employee
productivity across multiple regional databases, handling edge cases like
shifting calendar periods and cross-warehouse logic.
? Redesigned the data pipeline to resolve critical Stonebranch UAC workflow failures. Engineered a highly performant denormalization strategy, consolidating over 500 multi-domain, hierarchical dictionaries into a single payload, which is dynamically parsed and staged via stored procedures, .
?
Transitioned legacy manual Excel workflows into a robust,
multi-tenant (10 tenants) data model using . Enforced
strict tenant shielding and data privacy rules within a highly regulated
environment.
?
Bypassed limitations of the native MDM
tools by developing and managing a suite of 10+ custom Java/Spring Boot
applications for deployment orchestration, metadata editing, and automated
Excel processing (utilizing SIF calls and direct DB access). Front-end
implemented in Vue.js due to corporate restrictions on React build processes.
?
Architected a 3-tier automated
deployment pipeline. Replaced manual Hub Console promotions with automated
MetCommand metadata synchronization wrapped in packages
via .
? Automated workflow versioning and data transfers using Python and legacy Perl scripts (LCD libraries). Integrated for secure credential management, for automated open-source vulnerability scanning and implemented the ELK stack for log monitoring.
Took over complete technical ownership from external Informatica consultants, resulting in significant cost savings. Introduced Git Flow (release branches), 4-eyes principle code reviews, and automated Release Notes generation directly into Confluence based on Jira issues.Engineered the central data-quality enforcement and workflow engines using TIBCO EBX5.
Designed complex data model transformations, integrating the MDM hub with local core banking systems and downstream BI consumers.
Implemented complex relationship mapping to visualize counterparties and link them to risk structures.
Integrated external risk data feeds into the MDM hub to ensure accurate calculation of credit exposure across the entire banking group.
Led database performance optimization and deployment management.