1 / 16

ACL Connections

ACL Connections. Chicago June 2, 2009. General Purpose. Demonstrate ACL as part of a solution Encourage other uses for ACL Direct contact with ACL team. Using ACL to Automate Scorecard. Talecris – Bio-Pharmaceutical & Mfg. 60+ Plasma collection centers across U.S.

kiersten
Download Presentation

ACL Connections

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ACL Connections Chicago June 2, 2009

  2. General Purpose • Demonstrate ACL as part of a solution • Encourage other uses for ACL • Direct contact with ACL team

  3. Using ACL to Automate Scorecard • Talecris – Bio-Pharmaceutical & Mfg. • 60+ Plasma collection centers across U.S. (employees and location in lower-income areas) • 7,000 donors daily • $2.5 million cash disbursed weekly

  4. Talecris Challenges • Geography • Conduct “surprise” cash counts at all centers • DOS-based mgmt system: month-end reports, focused on operations, data not readily available for data mining

  5. Talecris Operations • Manual process for donor payments • No standardization of payments • Weak cash controls

  6. Talecris: Donor Mgmt System • System-based, automated donor mgmt process • ATM’s used for disbursements • Control concerns still existed • ATM malfunction • Modifications/ addtl pmt to system-generated amounts

  7. Talecris Needs • Independent assessment/reporting tool • Prioritize “surprise” cash counts • Ability to monitor center’s cash activity

  8. Center Audit Scorecard • DB tables imported to ACL • 600-line script calculates metrics and exports an output table to Excel to produce the Scorecard • Rolling six months of data are available • Results are summarized or viewed for a specific center • Reporting by center, consolidated, metric

  9. Scorecard Reporting • Center Snapshot • Charts comparing centers or metric • Consolidated summary

  10. Fraud Prevention & Detection • Dave Goderre – authored books on CAATS, significant contributor to ACL user forum • Fraud Risk Assessment Program - Lifecycle Approach: • Assess – company-wide, fraudster’s perspective • Access – identify all available source • Defend – build and maintain tests, verify data integrity • Continuous Assessment – refine scripts as necessary “Fraud prevention/detection is not an end but a journey”

  11. Craig Leming, Sprint Nextel • 49M wireless customers • 48K employees • 3rd largest wireless provider in U.S. • System Analyst from Info Sys

  12. Goals • Eliminate random sampling • Identify all exceptions from total population • Work with multiple formats and platforms from different departments • Increase data analytics in IA dept.

  13. Solutions • Initial training program for IA dept. • Advanced training for IT auditor • Periodic training • System Analyst performs extracts and queries, Audit Team performs data analysis

  14. Inventory Adjustments Project • Create an easy-to-use program for auditor • Used dialog boxes • Involved over 900K records • Through data analytics, reduced auditor time 40% – 60%

  15. Continuous Monitoring • Use scripts to access data and automate testing • Build for easy use and understanding Very few companies use continuous monitoring • Lack of time and expertise to implement

  16. General Observations • Understand company operations and data • Use ACL regularly • There are resources available to help you succeed with ACL • Not everyone’s going to be an ACL expert but do whatever you can to learn more about ACL.

More Related