The University of Chicago

Director, Data Engineering at Ipsos Public Affairs

Chicago, Illinois, United States

Ipsos Public Affairs

Lead Statistical Programmer

Statistical Programmer II

- Worked in the Data Analytics and Applied Science group, which provides technical and statistical support on survey/consumer/market research in both the public and the private sector- Maintained code for the collection, sampling, weighting, and storage of data for various projects in SAS- Developed Python script to take online surveys and validate question display/logic for dozens of versions in English, Spanish, and Chinese- Designed programs in SAS and Python to automate the creation of reporting elements such as tables, graphs, and statistical testing results- Developed SQL code within the SAS SQL procedure for data queries, aggregation, and extraction used for data analysis- Performed multilevel regression and poststratification (MRP) in R on a national survey to estimate the opinion of subpopulations- Contributed on and presented MRP paper at the 2018 American Association for Public Opinion Research (AAPOR) annual conference- Assisted in the transition and testing of existing project database to Microsoft SQL Server in Amazon Web Services (AWS) GovCloud- Managed scripts on a SAS server in Amazon Web Services (AWS) GovCloud that transferred data from/to Microsoft SQL Server for sampling, reporting, etc.

Statistical Programmer

- Worked on Cogito Systems, Epic's reporting and data warehousing software suite for healthcare organizations- Trained to extract, transform, and load (ETL) data from operational database to relational database- Gained experience in M/InterSystems Caché and Microsoft SQL Server

Epic Systems Corporation

Technical Services

- Continued work from internship in a part-time capacity- Created an algorithm in Python to extract data tables from PDF files containing confidential weekly clearing reports

Federal Reserve Bank of Chicago

Temporary Contractor

- Worked on the Financial Market Utilities Regulatory Strategy team- Performed daily web scrape of options data from the Options Clearing Corporation and Yahoo with Python- Verified data accuracy and stored in SQLite database- Designed a graphical user interface (GUI) with the Tkinter module to access relevant data and create tables/graphs for reporting- Created an algorithm in Python to extract data tables from PDF files containing confidential weekly clearing reports

Supervision and Regulation Intern

- Operated hand-held bar code scanner to pick orders of bicycle accessories- Packed and labeled boxes for correct shipping, e.g. USPS, UPS- Assisted occasionally in warehouse restocking and inventory counts

Dominick Hannah

Dominick Hannah