Daniel Choi

I am an IT Auditor that has been recently expanding my data engineering and analytics toolbelt. Our department is rapidly expanding our analytics practice and I have taken the lead roll in making sure our technology stack supports our growing practice. Here is a brief history of my work experience in IT Audit and Data Engineering/Analytics.

Experience

IT Audit and Analytics Supervisor, Graham Holdings Company Jan 2020 -- Present

  • Develop and deploy ETL workflows into Redshift using AWS Glue and AWS Data Pipeline
  • Deploy audit dashboards to Tableau using data in Redshift tracking duplicate payments, Benford distributions of payments, journal entry patterns and business unit specific metrics
  • Administer processes to set up and update data sources and dashboards on Tableau Online
  • Deploy Lambda Functions to load public data from RESTful APIs to Redshift
  • Deploy basic Lambda Function with Selenium to scrape restaurant data for a Tableau Dashboard
  • Authored jobs in R and Python to convert PDF files to dataframe format for analysis
  • Maintained AWS resources in Github repositories and deploy using AWS CloudFormation

Senior IT Auditor, Graham Holdings Company July 2013 -- Dec 2013

  • Managed department AWS Virtual Private Cloud and served as lead solutions architect
  • Administered department Redshift Cluster used for analytics around financial statement audits
  • Scripted automated segregation of duties analysis for financial system using R
  • Audited client AWS environments and provided security best practice recommendations
  • Executed analytics on extracted journal entry, sales, receivables and payments data
  • Published analytics results using Rmarkdown and Tableau Online Dashboards
  • Automated timesheet records using Google Developer Suite and Freedcamp API

Risk Assurance Staff/Senior, Ernst & Young (EY) May 2013 -- Apr 2017

  • Coached and developed staff on project management and auditing skills
  • Lead audits for numerous multi-location audits across multiple industry sectors
  • Awarded “EY Culture Coin” for exemplifying positive EY culture and values

Education

University of Virginia, B.S. Commerce and Economics 2009 -- 2013

  • Concentrations in Finance and Information Technology
  • Cumulative GPA 3.6 / Major GPA 3.6 Dean's List - Spring 2010, Fall 2010, Spring 2011, Spring 2013

Skills

  • Amazon Web Services Certified Solutions Architect Associate
  • Working familiarity with SQL, R, tidyverse, Python 3, pandas, boto3, Google Developer Scripts
  • Working familiarity with AWS Glue, Lake Formation, Redshift, Lambda, Cloudformation
  • Basic familiarity with Spark (pyspark)
  • ISACA Certified Information Systems Auditor (CISA)