Professional Work Highlights
During my tenure at Capital One, I delivered $2M+ in business value by designing risk governance dashboards, automating anomaly tracking, and building AI-powered analytics solutions that drove Director-level decision making.
Third Party Risk Governance Dashboard
Business Objective : Third-party risk reporting lacked standardization across the enterprise — different divisions tracked risk inconsistently with no unified measurement framework, making it impossible to assess risk exposure at an organizational level.
Process and Approach:
-
Aligned with stakeholders across multiple organizational silos to understand their unique risk metrics, reporting needs, and business impact — translating fragmented requirements into a unified measurement framework
-
Designed 25 enterprise-wide compliance checks and 10 KRI/RAM metrics that standardized how risk was tracked and reduced across divisions
-
Built ETL pipelines joining multiple data sources, transforming and normalizing data to maintain consistency across organizations that recorded data differently
-
Engineered varied SQL scripts to power each silo's data feed into a single consolidated dashboard with drill-down capability by Division, LOB, Reporting Period, and Date Granularity
Impact:
-
Dashboard outputs presented in board-level risk meetings, directly influencing executive risk strategy and organizational decision making
-
Saved firm from a loss of $1.5M, When a critical third-party outage occurred, the SPOF (Single Point of Failure) metric — designed as part of this dashboard — had already flagged the risk, enabling the team to assess exposure and take mitigation steps before impact escalated
-
Replaced fragmented manual reporting across the enterprise with a standardized, real-time risk monitoring system
Automated Manual Anomaly Tracking
Business Objective : Business Continuity Risk tracking was entirely manual — teams across 22+ divisions had no standardized way to monitor data quality gaps, aging violations, or compliance adherence, making it impossible to proactively identify and resolve risk before it escalated.
Process and Approach :
-
Collaborated with Business Continuity Risk stakeholders across divisions to understand gap categorization, aging thresholds, and compliance rule types — translating operational needs into 27 automated QA compliance checks
-
Designed aging framework tracking violations beyond 90 days, segmenting into "Aged 90-150 Days" and "Aged Beyond 150 Days" buckets to prioritize highest-risk items for immediate action
-
Built ETL pipelines joining multiple data sources across divisions, normalizing inconsistent data formats and maintaining snapshot-based historical reporting for trend analysis
-
Engineered SQL scripts to power multi-dimensional filtering by Reporting Month, Rule Type, QA Check, Days Overdue, Application Type, Division, and Organization — enabling precise drill-down for each stakeholder
Impact:
-
Achieved 90% reduction in manual anomaly-tracking by automating 27 compliance checks previously tracked manually across spreadsheets
-
Enabled real-time visibility into 1,800+ orphaned applications and third-party services, driving proactive remediation across divisions
-
Dashboard adopted as the standard reporting tool for Business Continuity Risk reviews, directly informing risk strategy at leadership level