Ben Li

Senior Risk Analytics Consultant @Wells Fargo

Generated Tier 1 financial reporting by using SQL and SSIS for dynamic data processing and presented it with Tableau for leadership.\\\\n* Managed and lead a team of 4 offshore team members and provided strategic direction for the team.\\\\n* Established and maintained SQL server environments and created connections with SharePoint, Oracle, ServiceNow, and HRNext.\\\\n* Automated IT controls testing for full populations providing real-time reporting generating time savings each quarter.\\\\n* Developed SAS analytics to automate manual data processing, realizing significant quarterly time savings.\\\\n* Reduced manual monitoring by 75% by defining department SharePoint structure, approval process, and access management.\\\\n* Implemented Analytic Development Lifecycle (ADLC) process which improved resource management and cost-effectiveness.\\\\n* Analyzed complex data from flat files, relational databases, and mainframe systems to provide data analytic packages in user-friendly formats.\\\\n* Assisted in development and implementation of the Data Analytic Services Center of Excellence as part of implementation of system of record.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n