During this 2-day course, you will learn real and practical solutions to getting the most out of the product in the shortest time possible. You will learn with real life examples and data; from a practitioner that has been using ACL for over 15 years.

The first day will revisit the basics of ACL to ensure the participants understand the fundamentals of the tool. Furthermore, the focus will be on how and when to practically use each ACL technique.

Day 1 will include:
* Project organization
* Data imports
* Tables / formats / log files
* Setting up fields and variables
* Filters
* ACL basic functionality
* Sort / Summarize / Joins
* Managing through data issues
* Date fields
* Introduction to Scripts

Day 2 will be focused on establishing a continuous monitoring program using ACL. Scripts will be designed to take advantage of ACL’s ability to store and compare data over time. Specific topics covered will include:

* Advanced scripting techniques
* Group / Loop commands
* ODBC connections
* Types of continuous monitoring procedures
* User input handling / interactive functionality
* Working with dated tables
* Other continuous monitoring techniques

Attendees do not have to be experienced with ACL to recognize the objectives of this course, but moderate levels of prior ACL experience will help in the overall understanding and application of these techniques afterward. Attendees are required to bring a laptop with an ACL license in order to ensure that the hands on exercises can be completed.

Speaker Information: - Sunera LLC

Peter Armstrong, Sunera LLC
Peter is a Principal and founder of Sunera LLC, a leading Florida-based Risk Services firm. Prior to creating Sunera Peter was a Partner with KPMG LLP based in Tampa where he spent most of his time focused on providing business and technology consulting projects of all sizes. Peter started working with ACL in 1991 and has worked with every version of ACL since then. In 1994, he held the first “advanced” ACL training course in North America which was attended by Internal audit professionals from across the US and Canada. Recently, he has taught version 8 and 9 to the Internal Audit departments of OSI, Burger King, RCCL, NCL, and the Cities of Tampa and St Pete. ACL is not that difficult to use, but has many tricks and techniques that can only be taught by someone who has more than 10 years of experience with the product. Peter is a Chartered Accountant (CA), a Certified Information Systems Auditor (CISA) and an ACL Certified Data Analyst.

Few recent projects.
•Completed a forensic analysis for the Pinellas County School District including the identification of inappropriate payments to vendors or employees, and establishing an automated mechanism to facilitate the board in completing future assessments internally without the need of external consultants. This project included the development of automated ACL scripts to identify transactions to be examined further.

•Completed a detailed investigation into deferred revenue for a professional association that outsources a significant portion of its business. Due to a change in the contract details, the amount of payments to the vendor has changed and both parties were in disagreement regarding the new amounts. In addition to examining the changes to the database made by the outsource partner, we also evaluated the impact of new contract details on the balance owing. All of our testing was completed using the ACL toolset and an independent formal findings report was issued. The result of our findings was approximately $2 Million in favor of our client.

Corey Wells, CIA, CFA – Sunera LLC
Corey is the Managing Director of Sunera’s Southwestern U.S. practice, based in Phoenix, AZ. Corey is a Certified Internal Auditor and Chartered Financial Analyst with over 12 years of experience in Internal Audit and Risk Management in both industry and professional services. This includes vast experience in Corporate Governance, Internal Audit, Internal Controls, Risk Management, IT Audit, Compliance (SOX/PCI, etc) and business process reengineering.
Prior to joining Sunera in October 2005, Corey was the Chief Audit Executive at WestJet Airlines (Canada’s 2nd largest international airline), where he initiated, developed and grew the audit & advisory services practice from 1 to 10 professionals over a five year period. Corey was responsible for all aspects of the department including the evaluation of internal controls, development and execution of an enterprise wide risk assessment process, compliance monitoring and the identification of operational efficiency opportunities. Corey also oversaw all planning and execution of required activities for the organization’s compliance with the Sarbanes-Oxley legislation.

Over the past four years, Corey has advised many Internal Audit Executives, CFO’s and Audit Committees on corporate governance, internal controls, risk management and internal audit best practices. Corey presents regularly at industry events/conferences and is widely viewed as a leading practitioner in the area of corporate governance and internal audit. His experience as both a Chief Audit Executive and advisor to multiple Fortune 1000 organizations, has afforded Corey a unique insight into the best-practices of world class audit departments.

******************************************************************
Additional Information For This Meeting:

Students are required to bring a laptop with an ACL license in order to ensure that the hands on exercises can be completed.

Location:
PERA Club
1 E. Continental Drive
Tempe, Arizona 85281-1053
USA

CPEs:  There will be up to 12 to 15 CPEs available for attending this event.

Schedule: Breakfast and lunch will be provided each day. Class will be from 9am - 4:30pm daily. Registration and breakfast begins at 8:30am daily

Registration & Breakfast: 8:30 am
Class Begins: 9:00 am
Lunch: 12:00 pm – 12:30 pm
Class Ends: 4:30 pm

Registration:

The registration fee is:
$325 – Members Registered & Prepaid by 2/6
$375 - Members Registered & Prepaid by 2/19
$425 - Nonmembers Registered & Prepaid by 2/19

Payments must be made in advance through CVENT using American Express, Visa, MC and Discover Card.

Deadline for Registration is February 19, 2010.

Click here to register for this event.