Lillian Truong

Staff Auditor @U.S. Bank

Minneapolis, MN, US

Staff Auditor Rotation Program (SARP)The SARP program provides recently graduated auditors with the opportunity to rotate among three different teams over the course of 18 months. Chief Information Office (CIO) Team- Built out 6 data flow diagrams for the newly developed point of sale consumer financing system, using Microsoft Visio, to aid in CAS oversight of the process- Utilized Microsoft Excel\'s Power Query and Analysis ToolPak to review and reconcile over 10 thousand rows of user access data as part of fieldwork testing-Utilized Microsoft Excel\'s Analysis ToolPak to reperform and reconcile financial data as part of fieldwork testing.Financial Data Management Team- Conducted research and found a solution to automate the generation of a monthly report, which saves over an hour of manual input- Used SQL to extract and filter data from data warehouses for use in fieldwork testing- Used Python and the Pandas extension to reconcile over 1 million rows of financial data and troubleshoot solutions when errors arose-Created a tool to easily reconcile data between the source and the system without the need for sampling data. This reduces the risk acceptance rate by the business and reduces the hours of analysis needed.

University of Minnesota - Carlson School of Management

Bachelor's degree

Inver Hills Community College

Associate of Arts - AA

Eagan Senior High School

High School Diploma