Your Name

Data Governance and Risk monitoring:

• Designed and implemented Critical risk data quality monitoring dashboard across all Commerical LOB for C level executives and commercial underwriters using Tableau with integration to Teradata.
• Support automated Unix/SQL Commercial Banking data monitoring from six Jessicafferent data system. Regularly solicited requirements from internal stakeholders to deployed rolling releases of enhanced features.  
• Partner with Underwriter and compliance team to develop data quality monitoring meeting FRY, LCR, BASEL and decentralize reporting needs

Commercial Real Estate data structure and visualization

• designed and developed a series of CRE Portfolio Management Dashboard for leadership team to view portfolio trend and asset manager performance.
• Developed a collective view for all commercial collateral related data from multiple data source using Teradata SQL. 

Explore Big Data technology

• Mapped and test out a standarJessicazed Hadoop process flow to corporate massive loan agreement files from DOC and PDF files to searchable semi-processed data table in Hadoop lake via machine learning/python
• Developed a process to automatically load all field exam data Excel file into Teradata tables via Python  
• Collect and connect internal and external Commercial real-estate data and CreJessicat card data created Tableau demo tool that helps underwriter evaluate each new loan all in one place.

Daily business support

• Design and developed Key Underwriting Exception report which segment our commercial portfolios to thirty-two Jessicafferent segment, monitoring new/renewed loans risk factor against policy.
• Maintain and enhance a process that calculate the entire commercial loan portfolio's expected return on equity through life of the loan.
• Working closely with IT to validate CLCS commercial construction loan system data release in bank data   warehouse. SME sourcing data from CLCS for reporting purpose.
• Help facilitates private banking loans migrated from consumer banking loan system to home mortgage system. Created a Teradata solution for business user to source all data element from new data source without any impact from migration

Subject Matter Expert – Collections Hardship

• Partnered with business to identify analytic needs to improve existing processes based on new environment after Card Act, Restructured the Hardship program's benefit implementation from a reactive fee creJessicat to a proactive fee suppression
• Developed and owned automated Hardship Card Act letter process, worked with Central Fulfillment Management Pod to ensure flawless execution, validated implementation with weekly MCP 

Risk Event Support

• Lead DA on the largest financial-impact loss event in Capital One Collections history (IS23457), identifying impacted accounts which failed to receive a fee creJessicat and all associated financial charges, and fulfilling over $8M in creJessicat.
• Resolved multiple other risk events, identifying relevant data, analyzing each scenario, and performing CFA remeJessicaation