Connor Pickard Email & Phone Number

Atlanta, Georgia, United States

• Full stack development of data entry and data validation tools using ASP.NET framework.• Create vast networks of stored procedures and ETL processes to assist in the intake, validation, and reporting of healthcare data. • Work with end users to gather requirements, model data, and create automation to provide a full service process implementation for data consumption and analysis. • Develop SQL queries within IBM Netezza and MSSQL Server for analytical purposes.• Create visual analytics and user interfaces using software such as Spotfire, SSRS, and Power BI. • Extensive experience using IBM ETL tools such as DataStage and QualityStage.

Charlotte, North Carolina, United States

• Provided DataStage production support to over 30 projects with more than 7,000 combined jobs• Upgraded 10+ enterprise DataStage servers from version 8.7 to 11.5• Teamed with IBM to evaluate and mitigate security risks in DataStage environments • Migrated data ingestion pipeline code from on premises to Amazon Cloud for Tealeaf data• Created and configured Amazon Cloud clusters to run various scripts and tasks• Monitored and verified daily workflow runs to transport/transform 25GB of web traffic data• Developed shell scripts to automate the transportation and validation of data• Collaborated with Big Data team in the configuration and maintenance of a Hadoop cluster

Atlanta, Georgia, United States

• Interned with the Financial Systems Integration division • Built and ran SQL queries to analyze data and create SSRS reports • Created a geocoded map of hospital locations and patients using Visual Basics• Converted SQL databases from ICD9 to ICD10 to comply with new federal regulations

Atlanta, Ga