BUREAU OF ALCOHOL, TOBACCO, FIREARMS AND EXPLOSIVES (ATF)

(Sub to iWorks)

Frontline Analytics

Y Point supported ATF Supported ATF’s Frontline Analytics division to lift and shift from Oracle to Microsoft/Azure. This included migrating 500+ mission critical reports from Oracle Database, Oracle’s OBIEE & Discoverer products to Microsoft SQL Server Data Warehouse (DW), SSIS, SSAS & Power BI. Supported ATF Frontline Analytics to create Power BI reports that read data from NFORCE, NSPECT, FLS, NIBIN, ANR and Data Warehouse, ANR – Denial Branch, TRC, BATS, NFA, NSOT, NFAD.

Offices supported: Asset Forfeiture, FTS, KPI, NSPECT.

More about our DW & BI offerings: Business Intelligence, Power BI, ETL, MDM, DW.

In its review of ATF Frontline analytics, Department of Justice (DOJ) OIG stated:

“ATF’s implementation of Frontline resulted in positive steps toward standardizing best practices across field divisions and focusing its limited resources on DOJ priorities; it also addressed systemic weaknesses such as the need for consistent oversight of field operations.”

Get In Touch

Hidden
Name(Required)