jerry@geraldgreenwood.com
Audit Compliance Technical Analyst, The Northern Trust, Chicago IL, June 2007 to present.
I have recently provided general ledger & trial balance platforms for our finance audit group enabling them to validate GL ownership and
isolate manual GL entries within Northern's general ledger system. I have developed automated deposit and loan confirmations for our
personal financial audit group to satisfy outside audit requirements and have implemented the first in depth data analytics of Northern's
accounts payable system. I have implemented ACL V9 network edition client server audit software to domestic & international audit
locations.
My primary duties are as follows:
-Work with business and IT auditors to assist in the creation automated processes to capture non-compliance issues, fraud or lost
revenue.
-Perform complex ad hoc & compliance reporting.
-IT & Vendor technical liaison for audit senior management
-Perform Security liaison and Change control functions for audit
-ACL (Audit Command Language) and mainframe technical expert for audit.
Audit Data Analyst, JP Morgan Chase, Chicago IL, May 4, 1998 to December 2006. In this position, I assisted the audit department
in finding internal control weakness, non-compliance issues and procedures that result in lost revenue, increased expenses or fraud.
Some of my responsibilities included:
-Create & Maintain SQL 2000 databases and feeds to audit banking center branch web page
-Organize, analyze and summarize data from a wide variety of bank systems to create risk based reporting and to assist audit in critical
decision processes
-Develop automated solutions to risk based problems for various internal lines of business
-Develop & monitor automated mainframe reporting
-Assist our forensics group to develop solutions for monitoring PBX & Internet traffic
-Participate in system conversion projects by developing data validation techniques
-Train audit staff in CAATS (Computer Assisted Auditing Techniques and ACL V9)
Systems Analyst with Newark Electronics, Chicago. IL February 1996 to May 1998.
I was primary contact for approximately 200 vendors concerning point of sale and inventory system reporting.
Programmer with ABN/AMRO (LaSalle Banks), Chicago August 1993 to February 1996.
Automated Clearing House (ACH) applications programmer and production support.
IBM MVS/ESA, JCL, FileAid, ACF2, VSAM, ChangeMan, Zeke, Cobol ,Easytrieve, Lotus Notes, SQL-2000, ACL (Audit Command
Language V9), Microsoft Project, Access, Excel, Word, PowerPoint & Visio. Audit Assistant running under Lotus Notes V6.5.
DePaul University, Computer Career Program (Mainframe), Certificate-1993
University of Illinois School of Art & Architecture, BA-1981
Professional Certification:
CISA (Certified Information Systems Auditor)
Professional Associations:
Member of ISACA (Information Systems Audit & Control Association)