Andrew C.

About Andrew C.

I am an Internal Audit IT Consultant for State Auto Insurance Companies located in Columbus, OH, with a specialization in the execution and delivery of data analytics. I have experience managing large teams based in the US and India (approximately 35 cities), while serving over 700 external clients on over data analytics projects annually (a book of business of about four to five million dollars).During my professional career, I have worked on numerous IT audits and IT consulting projects, gaining experience and knowledge over multiple types of IT controls and a wide array of IT systems. I also have designed and developed two database management systems and three dynamic, database-driven websites. My experience in programming, databases, and systems analysis and design are often leveraged on many internal company projects, as well as client work. My body of work has allowed me to become an effective resource in data analytics, having written scripts and created visualizations for an abundance of computer-aided auditing engagements. In addition, I was a Data Analytics Subject Matter Expert at Ernst & Young as well as a Champion for EY\'s data analytics suite of tools, Helix, and managed data analysis projects for numerous clients in EY\'s Central Region sub-area that were performed by me, by local teams I supervised, or by EY\'s Global Talent Hub offshore resource that I oversaw. Additionally, I was responsible for creating the Controls Review Tool, an audit and advisory engagement enhancement tool which is being utilized globally by Ernst & Young.

Experience

1. Internal Audit IT Consultant

   State Auto Insurance

   Feb 2020 — Present · Columbus, OH, US

   Implement and execute an integrated audit plan that aligns with business objectives, focusing on the IT components and leveraging data analytics procedures wherever possible. Additionally, develop, coordinate, and manage audit plan strategy and procedures utilizing internal and external resources, while providing subject matter expertise on IT audit, information security, and data analytics.

Education

• Washington State Community College

  A.S., Mathematics

  2001 — 2003

• The Ohio State University Fisher College of Business

  MAcc, Accounting

  2007 — 2008

• Marietta College

  B.S. & B.A., Computer Information Systems & Accounting

  2003 — 2007