St. Louis ACL User Group

Thank you Nick Panneri & Rene Kennedy from Enterprise for sharing your ACL/SQL experience and expertise with us.

Here is the Enterprise Robust Continuous Audit powerpoint. ACL_UG_Enterprise

We’re planning our next meeting for April 25^th over lunch. More details to follow – but mark your calendars. Billy Cheung who just joined Mercy Health Systems and was previously a consultant with ACL Services will have some great tips for us.

Developing a Robust Continuous Audit Tool

Nick and Rene will show us how they combined SQL and ACL to provide a continuous audit tool with an efficient exception management solution that has the flexibility of being able to access reports without having to be “ACL” proficient.

Registration and Lunch – 11:30 am

Meeting 12-1

Lunch provided courtesy of Laclede Gas

ACL UG 2012 Q1 Flyer

ACL has just announced that there will be an ACL ACDA examination in St. Louis on March 15 2012.

Registration details are available at http://www.cvent.com/Events/Calendar/Calendar.aspx?cal=bf960e5d-2985-49e6-8c44-ad18388ff4bd.

__________________________
ACL certification evaluates and recognizes your ability to integrate ACL technology into your financial analysis and business process. Earning the ACL Certified Data Analyst (ACDA) designation enhances your professional development while validating your technical skills and ensuring you meet performance standards necessary to address key business challenges.

Here more details!

Training_901

Please let us know if you have any questions!

Thanks to everyone who joined us for the Panel Discussion.

And a special thanks to our panel!

If you missed it or want a refresher, here is a recap.

James Heavin, Shelter Insurance IS Audit Manager, provided us with a couple of very useful handouts.  Thanks James!

Stay tuned for information on our 4th quarter meeting information.

Learn how organizations have successfully implemented ACL through various methods.

Jim Kaiser, Bunzl Internal Audit Director, Implemented AX2 and several continuous monitoring scripts.
Mary Riggs, BJC Audit Services Manager, Works with regular system extracts to run scripts on demand
James Heavin, Shelter Insurance IS Audit Manager, Uses an extensive group of scripts and ad hoc analysis as standard audit procedure.

Tuesday, August 16
11 am – 1 pm
The Center of Clayton
50 Gay Avenue
Clayton, MO 63105
Multipurpose Rooms

Lunch will be provided courtesy of
Brown Smith Wallace, LLC
RSVP to Jan Beckmann by August 8

What do you want to ask?  Would you ask about their approaches to implementing ACL, audit planning, data access, training, continuous monitoring, etc?

Do you have a question to ask our panel?  Submit it via the comment function.  Your question will be sent to the administrator and appear after review.

Tuesday, May 10, 2011, at 4:30pm

at Lester’s Sports Bar &Grill

9906 Clayton Road, Ladue, MO 63124

Take this opportunity to meet the other members of the group.

We will have a computer with ACL and sample data on site for your convenience.

Appetizers will be provided – courtesy of Brown Smith Wallace

Thank you to everyone who came out to the Q3 meeting! CPE-required surveys will be sent out shortly.

Files related to the Q3 meeting:
Main Presentation – Includes Tips & Tricks
Top 100 Tests – Special thanks to Manuel Coello of Stanley Blank & Decker. The presentation was used at the NY Conference.
Adding Value with Data Analytics – Created by Jan Beckmann and used at the IIA Springfield, IL Chapter meeting.

Agenda

ACL Connections Conference Update – New York

Tips & Tricks

Files related to the Q3 meeting:
Main Presentation – Includes Tips & Tricks
Top 100 Tests – Special thanks to Manuel Coello of Stanley Blank & Decker. The presentation was used at the NY Conference.
Adding Value with Data Analytics – Created by Jan Beckmann and used at the IIA Springfield, IL Chapter meeting.

The St. Louis ACL User Group is offering advanced ACL training. We have had several requests for this type of
information and are happy to be able to provide this at no cost to you.

Course Objectives

The main objective of the course is to introduce participants to advanced ACL script commands. We’ll use a project
that has several print image files that need to be defined and will use commands and variables to have ACL loop
through and perform this on all of the required files without much effort on your part to script it. This technique can be
used when working with any number of files. The scripting effort is the same if it’s 10 files or over 10,000. The
concepts learned can be applied to numerous situations other than importing print image files. Click through for more info… Read more »

Agenda and Speakers

ACL Update

Steve Biskie and David Dempsey, ACL representatives, are visiting St. Louis and are hosting this meeting for us. They will share:

• ACL updates, AX2, and continuous monitoring
• Building the business case for data analytics – involving business lines to get what you want
• FCPA highlights
• Review of the executive session held that morning regarding self-funded insurance

So, come armed with your questions for ACL about licensing, Audit Exchange, training, conferences, the future of the software, and anything else you’ve been wondering about.

Tips & Tricks

Jan Beckmann, Brown Smith Wallace Data Analysis Practice Leader and former trainer for ACL Services, will share ACL tips and tricks to help you get your analysis work completed more efficiently. The content will span beginner to advanced levels. Topics will include how to use standard features to enhance the effectiveness of commands and how to use scripts and variables to process commands on multiple data files.

Wednesday, April 14, 2010
Noon – 2 pm
Lunch will be provided – courtesy of ACL Services
Hilton Frontenac
1335 South Lindbergh Boulevard

Be sure to RSVP with StLouisACL@gmail.com by April 7, 2010!

Download Presentation

Download “Auditing self-funded insurance plans” Presentation