A selection of data, analytics and transformation work delivered for banks and healthcare organizations, from regulatory capital programs to patient-support 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.