Scott Renz

Education

Southern Illinois University – Carbondale, IL B.S.

Valparaiso University School of Law - Valparaiso, IN J.D. Boston University – Washington, DC - Certificate in Digital Filmmaking Professional Experience

Scott Renz (January 2021 to Present)

• Write, produce, direct, and act in plays and movies. Syneos Health (February 2020 to December 2020)

• Make reports and data dumps on Clinical Data with SAS and make VBA Macros in Excel to format and to retrieve data and merge and compare and calculate.

Scott Renz (December 2017 to January 2020)

• Write, produce, direct, and act in plays and movies. Edwards Lifesciences – Irvine, CA (October 2011 to November 2017) Report Specialist

• Made reports and data dumps on Medidata Rave data in Business Objects XI (BOXI) and SAS and made VBA Macros in Excel to format and to retrieve data from SQL Server with SQL queries.

• Made reports from the SQL Server back end using an ODBC connection and Excel VBA to run the SQL statements to make the report and use VBA to format the reports.

• Administered SharePoint. Made auto-procedures with Flow to put attachments from email into proper SharePoint folders.

INC Research – Raleigh, NC (April 2010 to October 2011) Project Analyst, Data Management

• Made reports and data dumps on Medidata Rave data in Business Objects XI (BOXI) and made VBA Macros in Excel to format and made Edit Check reports

Studied Digital Film Making (July 2007 to April 2010) Nabi Biopharmaceuticals -Rockville, MD (March 2004 to July 2007) Senior Database Manage

• Supervised programmers.

• Made databases and entry screens for Clinical Data.

• Made reports using Oracle and PL/SQL.

• Made reports using SAS Windows software and pulled data from FTP sites.

• Made reports in HTML and XML formats.

• Made EXCEL workbooks for reporting data using SAS Macros and Excel VBA Macros.

• Pulled study data with SQL in Excel macros out of Oracle.