Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Network Power<100 people
Roles
🔥100%
Startup Founder
💸100%
Marketing
✔️100%
IT
Geos
Work Background
Free Franchise Consultant
International Franchise Professionals Group - IFPGFree Franchise Consultant
May. 2022We offer free advice to individuals considering owning a franchise business.
Software Engineer
Scott RenzSoftware Engineer
Jan. 2021Write, produce, direct, and act in plays and movies. Make Real Estate Deals. Make websites to sell products and services using Python and JavaScript.
Computer Programmer
Syneos HealthComputer Programmer
Feb. 2020 - Jan. 2021Morrisville, North Carolina, United StatesDid computer programming for clinical study data
Software Engineer
Syneos HealthSoftware Engineer
Feb. 2020 - Dec. 2020Make reports and data dumps on Clinical Data with SAS Statistical software and Python and JavaScript and make VBA Macros in Excel to format and to retrieve data and merge and compare and calculate.
Reporting Specialist
Edwards LifesciencesReporting Specialist
Oct. 2011 - Nov. 2017Garner, NCBuilding Clinical Data Management reports from Medidata Rave with Business Objects XI (BOXI) and making reports with Visual Basic (VBA) in Excel and making reports with SAS.
Report Specialist
Edwards LifesciencesReport Specialist
Oct. 2011 - Nov. 2017Made reports and data dumps on Medidata Rave data in Business Objects XI (BOXI) and SAS Statistical software 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.
Project Analyst
INC ResearchProject Analyst
Apr. 2010 - Nov. 2011Maintains awareness of the pertinent elements of contract and scope of work for assigned project(s). Reviews and adheres to the requirements of study-specific Clinical Data Management Plans for assigned project(s). Participates in and presents at internal, customer, third-party and investigator meetings. Participates in internal/external audits. Develops User Test Plans for data entry screens, electronic edit checks, data listings, import / export programs and medical coding. Coordinates and supports release of tested clinical data databases to the production environment. Develops and/or delivers: a. eCRF training for CRAs and site staff ; b. applicable data management departmental training related to technical processes and systems; c. other project specific training. Develops and maintains CRF and eCRF Completion Guidelines (in consultation with clinical / customer team). Designs eCRF entry screens and associated eCRF visit structure, indexing and version control. Reviews a. designs for CRF pages and eCRF entry screens and associated CRF / eCRF visit structures, indexing and version control, coordinating with team members responsible for the associated database design; b. data Entry guidelines; c. configurations of CRF WorkManager; d. SAS Mappings (from CDMS Databases). Assists in the negotiation and contracting process with outside vendors such as e-CRF/Diary vendors, CRF Printer and IVRS vendors. Maintains documentation on an ongoing basis and ensures that all filing is up to date. Participates in the development of departmental technologies, SOPs, processes and procedures. Trains and mentors less experienced data management staff. Contributes to the Request for Proposal (RFP) and Request for Information (RFI) process. Prepares input for, and participates in proposal bid defense meetings.
Data Management Analyst
INC ResearchData Management Analyst
Apr. 2010 - Oct. 2011Made 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
Senior Database Manager
Nabi BiopharmaceuticalsSenior Database Manager
Jun. 2004 - Jul. 2007Made data entry screens, data structures, data validation programs, data reports using SAS and PL/SQL and EXCEL and WORD macros and configured and troubleshot and managed the computer system for data from clinical trials in the Oracle RDBMS and managed clincal data programmers.
Database Services Manager
Nabi BiopharmaceuticalsDatabase Services Manager
Mar. 2004 - Jul. 2007Supervised 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. Made SAS format catalogs from Clintrial coded items with SAS Macros.
Database Programmer
Clinical Solutions GroupDatabase Programmer
Mar. 2004 - Jun. 2004Was on assignment at Nabi Biopharmaceuticals in Rockville, Maryland Writing data validation code in Phase-Forward Clintrial and performing other data base tasks involved with the data from Oracle. Making batch reports on CRF metrics.
Database Programmer
Purdue Pharma L.P.Database Programmer
Nov. 2003 - Mar. 2004Wrote data validation code (edit checks) in Oracle Clinical, making reports in SAS Statistical software from Oracle tables, making electronic data entry books for clinical trial studies.
Database Programmer
InamedDatabase Programmer
Feb. 2003 - Feb. 2003At Inamed in Santa Barbara, California wrote data validation code in Oracle Clinical.
Clinical Database Programmer
Celeris Corp.Clinical Database Programmer
Jan. 2001 - Jun. 2002Was database programmer for data from clinical trials and the database administrator for Oracle RDBMS.
Database Programmer
CelerisDatabase Programmer
Jan. 2001 - May. 2002Served as the Oracle Database Administrator and Oracle Clinical Database Manager. Kept track of system resources and kept them within acceptable parameters. Tuned aspects of the system to keep things running in a timely manner. Investigated and found solutions for any Oracle and Oracle Clinical problems. Performed Oracle database programming using Oracle Clinical and made the edit check and derivation procedures with Stored Procedures. Made screens for data entry of Case Report Forms and set up the database and SAS views in Oracle Clinical. Managed the global library of Oracle Clinical objects. Taught and managed other programmers in these tasks.
Contract Software Engineer
Cyberwerx LLContract Software Engineer
Mar. 2000 - Apr. 2001Performed in Oracle database administration and programming for APHIS at the U.S. Department of Agriculture on ATS programs. Helped trouble shoot system and program problems --monitor the system. Accessed the system remotely from home through the internet using Personal Oracle 8. Showed Oracle techniques to staff. Fielded questions on the system. Tuned the system by building and rebuilding indexes on Oracle tables. Wrote a system for allowing users to make automated rules which the system then automatically turned into triggers which determined which incoming shipments should be held or flagged for review of the documentation so as to determine if a hold is necessary. The system was written mainly in PL/SQL and a script was made to run in SQLPLUS to build all the necessary tables, views, procedures, packages, functions, indexes, constraints, and table and column comments, and make the necessary grants and synonyms. Wrote procedures to create new users and give them the necessary grants and put their names and information in tables needed to check their access to the system.
Contract Software Engineer
ClinTrials Research IncContract Software Engineer
Jun. 1998 - Aug. 1999Used PhaseForward ClinTrial Software accessing an Oracle database in a VAX VMS environment. Created electronic forms for entry of data from clinical drug studies. Designed database structures for storing the data. Created procedures to check the validity of the entered data. Created system wide procedures to update laboratory codes and build reports to be read by SAS Statistical software. Created tools for programmers to use to speed up their jobs. Helped other programmers solve programming problems. Showed programmers Oracle SQL techniques and RPL programming techniques. Helped programmers find bugs. Resolved user problems. Created PL/SQL procedures to validated laboratory data in place of the standard RPL programs reducing the time to validate 40,000 records from 160 hours to 20 minutes. Helped other programmers with problems programming in PhaseForward ClinTrial and in Oracle.
Software Engineer
PPD PharmacoSoftware Engineer
Mar. 1997 - Jun. 1998Used PhaseForward ClinTrial Software accessing an Oracle database in a VAX VMS environment. Designed database structures for storing the data. Created procedures to check the validity of the entered data. Created scripts to make output from Oracle to files for SAS Statistical software. Created tools for programmers to use to speed up their jobs. Helped other programmers solve programming problems. Showed programmers Oracle SQL techniques and RPL programming techniques. Helped programmers find bugs. Resolved user problems. Converted SQR (later called Brio and Hyperion) report programs to new database structure and write new SQR reporting programs for showing clinical data in an HP-Unix environment using Oracle. Instrumental in creating standard processes for PL/SQL validations. Created export process to extract data from Clintrial in format acceptable for importing into Oracle Clinical. Created system of stored packages and stored procedures in Oracle for validating data with a call interface from PhaseForward ClinTrial. Taught the other programmers PL/SQL and how to use the stored package and procedure system. Helped other programmers with problems programming in PhaseForward ClinTrial and in Oracle. Developed system for uploading lab data into Oracle Clinical and validating against other PhaseForward ClinTrial panels. Taught the other programmers PL/SQL and how to use the stored package and procedure system. Helped other programmers with problems programming in PhaseForward ClinTrial and in Oracle. Developed system for uploading lab data into Oracle Clinical and validating against other PhaseForward ClinTrial panels.
Clinical Data Programmer
PPDClinical Data Programmer
Jan. 1997 - Jan. 1998Making clinical trial data entry screens and data edit checks.
Oracle Database Administrator
BayerOracle Database Administrator
May. 1996 - Aug. 1996Resolved problems with the Oracle RDBMS and maintenance. The Oracle database resided in a VAX environment and was accessed remotely from a PC network environment. Helped maintain Oracle user accounts and working schemas and maintained tablespaces for disk access. Helped figure ways to access the database with PC Windows software. Helped to get remote links working to an out of the area mainframe. Helped programmers build SQL queries and views. Built Oracle stored packages and stored procedures to automate the creation of user accounts. Built Oracle roles for access to applications. Built scripts for moving data from other sources to Oracle tables.
Actor
Raleigh Little Theatre-Garner Towne Players-Theatre in the ParkActor
Jan. 1996 - Nov. 2023Performing as an actor on stage.
Clinical Data Programmer
Clintrials ResearchClinical Data Programmer
Jan. 1996 - Jan. 1999Making clinical trial data entry screens and data edit checks.
Contract Software Engineer
QuintilesContract Software Engineer
Oct. 1994 - Aug. 1995Worked on the GAERS (QSAEFT) project. Maintained and developed enhancements for the system which was an Adverse Event reporting system on an Oracle database in a VAX VMS environment accessed through PCs on a Novell Network which emulate VAX VT terminals. Maintained and developed SQLFORMS including the necessary PL/SQL code for entering and accessing the data. Developed DCL and PRO*C programs to generate reports on the data. Maintained SAS Statistical software report generation programs. Developed Utilities for repairing data structures. Developed Utilities to automate regenerating SQLFORMS object code. Developed code to transfer data from the VAX environment to the PC Network environment using Windows based Reflection command language (a clone of VBA) and WordPerfect for Windows VBA Macros so that users can edit Text in WordPerfect for Windows and move files from PC Email to the Oracle database on the VAX. Created the SQL database tables to store data needed for the programs developed. Maintained utilities to set up the necessary environment for user access. Resolved problems for users attempting to access the system.
Clinical Data Programmer
QuintilesClinical Data Programmer
Jan. 1994 - Jan. 1995Making clinical trial data entry screens and data edit checks.

Requests

Touchpoint image
0
Personal Pitch
Bar & Restaurant Entertainment in Raleigh-Durham
Touchpoint image
0Applied by 1
Personal Pitch
Excel VBA Macro Programming Offer
Touchpoint image
0
Looking for a Job
Clinical Trials Data Mgmt Programmer Expertise
Touchpoint image
0
Looking for a Job
Comedy Play to Boost Customer Engagement in Raleigh-Durham NC
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Scott on Intch
Entertainment
1009113 people
16
Producer @ iHeartMedia Cincinnati
16
Creative
15
Production Assistant
EntertainmentSinger
106651 people
16
Creative
15
Production Assistant
21
Dynamic Creative and Leader @ Freelance (Self employed)