SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

ACL Connections

kiersten avatar
kiersten
16 diapositives · 410 Views · Sep 17, 2012

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.

ACL Connections - slide 1
01 / 16ACL Connections
1 / 17

Télécharger la présentation

ACL Connections
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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.