At United States Citizenship and Immigration Service (USCIS), Sevatec delivers Data Warehouse and Business Intelligence (DW/BI) services to attain the goal of being the system of record for all USCIS data. Sevatec’s Data Business Intelligence Section (DBIS) II program supports the USCIS strategic goal and core mission of “creating an agency culture and capacity for data-driven decision making, policy, strategic planning, resource management, and operations”; adjudication of immigration benefit applications; and strengthening the security and integrity of our immigration system.
The main function of the USCIS DBIS II project is to support and manage various repositories containing copious data received annually by USCIS (approximately 6 million immigration applications and petitions for legal review & adjudication). The massive amounts of data and supporting data for processing was overwhelming the current reporting infrastructure used by USCIS leadership. These critical reports, intended to increase operational efficiency for immigration benefits processing, were terribly slow and caused significant negative user experience issues. Sevatec engaged the user community and quickly identified and corrected a key interface problem that negatively affected user experience. Through systematically working down performance-related technical debt stories, we dramatically reduced the execution time of a key executive dashboard from 1.5 hours to just 3 seconds.