• Managing the information about enterprise-wide credit exposures of wholesale and high valued clients which being delivered through the Enterprise Wholesale Credit Risk System (ESN)• Design the data models and lead data infrastructure innovation for Enterprise Risk teams. The new system will meet the needs and requirements of multiple stakeholders and downstream user groups• Proactively monitoring and analyzing daily and monthly changes of credit exposures, and Investigating, escalating and resolving data integrity issues, and enhancing the data quality process • Led the development of stewardship/governance processes for the Credit Risk data from the source raw data, to ETL integration, to reporting layer, to the user friendly GUI/ Reports • Maintained and applied the wholesale credit risk parameters and new methodology to ESN System• Connected to risk managers, business owners/account managers, created and maintained Business Specifications, Developed test cases, and participated in testing of the ESN application or new products/ data feeds, such as integrated City National Bank data with RBC, and HSBC integration project• Provided exceptional database experience to user community of ESN, internal / external auditors, data lineage team. Helped on building CDE and reconciliation processes• Automated report processes by programming in Python, SQL, Access, VB, Tableau, etc.