Our work

Selected engagements

A selection of data, analytics and transformation work delivered for banks and healthcare organizations, from regulatory capital programs to patient-support analytics.

12 engagements

Filter by sector. Client names are kept confidential.

Healthcare

Healthcare

Patient therapy persistence & app impact analytics

For a global pharmaceutical company's patient-support program, we built the analytics that show whether patients stay on therapy, and how much a digital companion app improves it compared with traditional support channels.

  • Snowflake and dbt pipeline (staging, intermediate and mart layers) feeding one cohorted source of truth
  • Persistence and compliance measured across app, hub and specialty-pharmacy channels, by indication
  • App-channel uplift quantified against the other channels combined
  • Power BI semantic model with cohort-filtered DAX measures, validated against Python business logic
  • App engagement score correlated with patient persistence
  • Impact-analysis BRD, data dictionary and phased roadmap toward predictive analytics
  • Snowflake
  • dbt
  • Power BI
  • DAX
  • Python
  • SQL

Healthcare

Patient engagement platform KPIs

Defined and implemented the KPIs for a patient engagement platform, resolved source-data quality issues and kept business stakeholders informed on delivery.

  • KPI design
  • Data quality
  • Power BI

Banking

Banking · Wholesale credit risk

Wholesale credit risk data governance

For a global bank's lending technology transformation, we led data governance and controls for a wholesale credit risk data warehouse on Hadoop, fed by more than ten lending systems and supporting U.S. regulatory commitments.

  • Data quality, lineage and reconciliation controls across 10+ lending systems
  • Data onboarding, validation and metadata processes that cut onboarding cycle time by 30%
  • Data ownership and stewardship framework with business, risk and IT for regulatory reporting
  • End-to-end data quality controls with over 99% reconciliation accuracy on credit exposure data
  • Hadoop
  • Data governance
  • Metadata management
  • Data quality

Banking · Capital markets

Credit risk platform upgrade

Led the data-layer upgrade connecting a new counterparty credit risk platform with capital markets systems: technical specifications, an automated test framework, data lineage and Scrum delivery.

  • Python
  • SQL
  • Agile

Banking · Regulatory capital

Basel III enhanced CVA

Led the end-to-end implementation of the enhanced CVA capital charge (basic and standardized approaches, MAR50), turning regulatory requirements into tactical and then strategic solutions, comparing a vendor engine with in-house calculation and supporting the quantitative impact study.

  • SQL Server
  • JIRA
  • Vendor evaluation

Banking · Finance transformation

Balance-sheet substantiation

Analysis and design for a finance transformation program covering accounting and entity reporting: an automated solution to speed up balance-sheet substantiation for commodity portfolios, trade-to-sub-ledger reconciliation, and business rules and data models for derivative and bond netting.

  • SQL
  • Data modeling
  • Reconciliation

Banking · Market risk

FRTB risk reference data mart

An enterprise data mart for market and credit risk reference data (1TB+), aligning trading and banking book boundaries, desk structures and FX translation risk for regulatory capital oversight.

  • Apache Spark
  • Python
  • SQL

Banking · Risk data aggregation

BCBS 239 risk data & reporting

Streamlined trading-position data flows across business and technology teams, reconciled risk MTMs with finance ledgers, and built data models, validations and Tableau monitoring for risk data aggregation and reporting compliance.

  • SQL
  • Tableau
  • Data pipelines

Banking · Credit risk

Dodd-Frank IHC data governance

A credit risk data governance framework for U.S. intermediate holding company compliance, verifying aggregation of fixed income, derivative and loan exposures behind executive dashboards.

  • Data governance
  • BRD
  • Testing

Banking · Market risk

Trade reconciliation & regulatory remediation

Daily reconciliation of the full trade set between booking and risk-sensitivity systems, with Python automation bridging remediation until strategic solutions were in place.

  • Python
  • SQL
  • .NET

Banking · Regulatory capital

Basel III standardized CVA & RWA

End-to-end Pillar 1 delivery for credit and market risk: standardized CVA, risk-weighted assets, VaR updates and qualified CCP requirements, from requirements through testing and release.

  • Oracle SQL
  • UML
  • Requirements

Banking · Core systems

Treasury, FX & consumer finance implementations

On-site implementations for banks in the Middle East: treasury and FX modules, payment and settlement mapping to SWIFT, and a retail consumer finance system, including gap analysis, testing and user acceptance.

  • SWIFT
  • Gap analysis
  • UAT

Contact

Have a similar challenge?

Tell us about the business problem. We'll tell you what's possible and viable, and how quickly.

contact [at] tegzia [dot] com · +1 (647) 932-7455