Frank Saponaro Email & Phone Number

Washington D.C. Metro Area

As part of the Asset Forfeiture Management Staff (AFMS) at the Department of Justice DOJ, I provide quantitative data analysis support for the AFMS team leaders and Consolidated Asset Tracking User Group (CUG). I am also involved in requirements gathering with our team and the CUG and scrum workshop with our developers. The analysis team that I work on updates our current documentation with each release and we work closely with the other teams including operations, development, and testing as we prepare each work request,

Assists with the development of strategies to expand office analytic and reporting functions. Collaborates with staff to explore and expand the Enterprise Data Warehouse and Enterprise Reporting Platform.• Developed and provided reporting requirements to the in-house data warehouse build team using Oracle.• Wrote SQL queries to provide system testing and data validation of the data warehouse and underlying PeopleSoft database tables, leading to ETL changes and enhancements. by the data warehouse team.• Partnered with a small team in the Institutional Research office to bring Enterprise Data Warehouse Report Delivery System (EDWARDS) on-line; converted existing PeopleSoft reports and queries into EDWARDS, set-up user accounts, and promoted system to key stakeholders including executives, faculty, and staff.• Reduced delivery time 50%, improved faculty course evaluation data dissemination process, and reduced the need for manual compilation of statistics for each class by assisting with the creation of reports in EDWARDS that provided supervisors access to course evaluation data used in performance evaluations of faculty; delivered training for faculty supervisors and account maintenance following conversion, and set up and oversaw the process of sending course evaluations to faculty.

Provided data reporting and analysis consulting support. Reviewed business processes and applied IBM's Business Process Reengineer (BPR) to client needs.• Worked as part of a team to implement the transit-time measurement system (TTMS) used by USPS to monitor and identify opportunities to improve delivery time; produced and reviewed performance assessment reports with USPS executives.• Contributed to developing a recommendation for a demand forecasting system to support management decisions by evaluating client’s supply chain processes and using modeling to review performance.• Participated on the Business Process Reengineering team that reviewed several processes within the National Geospatial-Intelligence Agency (NGA); made several recommendations to improve data sharing process across the organization (data dissemination) including changing the way analysts accessed hard and video data, provided analysis, and requested new data.• Provided data analysis for the survey research team that was used to make business process improvements.

Partnered with researchers to present clinical trial results.• Worked with researchers and epidemiologists to improve the analysis and dissemination of their information at the National Cancer Institute by developing new graphical options to present their data.• Added over 20 new reports in SAS to existing reporting system that tracked efficacy of clinical trials by working on-site with Pfizer Pharmaceutical.

Mba, Management Information Systems, General

B.A., Computer Science/Economics

Education record