Nick Mccord Email & Phone Number

Seattle, Wa, Us

Mclean, Va, Us

Engineer for the Automated Vulnerability Remediation (AVR) application which handles AWS AMI rehydrations across the enterprise. Integrated notification functionality for improved customer awareness of errors during the AVR candidate selection phase. Engineered dev environment API to enable end-to-end testing and feature development for blue-green rehydrations. Coordinated study groups for both AWS Cloud Practitioner and AWS Solutions Architect exams to improve certification rates across the horizontal Card Tech tower.

Mclean, Va, Us

Developer for the Card Tech Cloud Engineering team which educated and advised application teams in building well-managed, compliant, and cost-effective infrastructure across a variety of AWS services. Accelerated remediation cycle times with Python-driven API automation scripts and significant contributions to Cloud Custodian policies. Coordinated the remediation of 15,000+ AWS Security Groups across roughly 600 application teams to decrease application network vulnerabilities.

Richmond, Virginia, Us

Data Engineer | 6/2019 – 10/2019Execution and development of an Azure data lake to consolidate disparate API and flat file source systems to automate a manually intensive payroll and invoicing process. Primarily developed stored procedures, executed by Data Factory v2, to perform ETL into a MySql database, generate a strictly formatted output and allow for further integration with PowerBI. The resulting system reduced invoicing time from 60+ days to a single day while also enabling payroll auditing, not previously possible.Big Data Engineer | 10/2018 – 6/2019Automation of the tokenization of sensitive customer data in transit from on-prem databases to the AWS cloud. Maintained AWS infrastructure to support daily extracts of data, support downstream financial modeling, and investigations by the Financial Intelligence Unit. Single-handedly managed the team’s disaster recovery efforts and performed a successful regional fail-over of the data movement pipeline.Data Engineer | 6/2018 – 10/2018Built data controls comparing multiple Systems of Records with their respective cloud target tables using internally developed SQL-based comparison tools. Controls were then used to track and prevent data corrupted during ETL from being used in financial models. Remodeled original source-to-target mappings, scripted automation to run the controls daily, and documented all completed work to be reviewed by the Internal Audit division prior to being turned over to a federal regulatory body.Data Analyst | 3/2018 – 6/2018Engineered test cases and ETL load testing for a reporting data mart. Documented project-level business objectives, results/defects, and resolutions for formalized vetting of the functionality of the system. Reconciled data quality analysis results to identify source system limitations and provide client feedback concerning the overall health of the source tables feeding the report mart.

Mclean, Va, Us

Primarily developed in JavaScript and SQL to perform smoke testing on new application functionality. Restructured central repository using Git applications to align source code directory structure requirements with application functionality. As part of a separate internship project, performed a cost-benefit analysis of potential vendors, proof-of-concept demoing, and software installation and configuration as part of the Data Virtualization Team. Responsibilities included:-Active participation in iteration prep, retrospectives, and story refinement through VersionOne-XML schema analysis & report generation-Use of Git to commit file changes to a central repository for multi-environment directory restructuring-CA Workload Automation smoke testing and RapidSQL database testing using QBrowser-Data Virtualization vendor research and analysis-Proof of Concept drafting and presentation to a panel for future software adoption

Blacksburg, Va, Us

Performed tracking for client and internal social media metrics using HootSuite and Google Analytics while also supporting business development objectives through RFP searches and proposal submission. Redesigned existing content management systems used to track active website content and maintain historical archives of case studies, blogs, and articles.

Herndon, Virginia, Us

Accelerated growth of RTC adoption within Pamplin College of Business due to sales and marketing efforts which led to over $10k growth within his first year. Refinement of the “Professor Liaison” sales approach and coached new hires while also serving as the Point of Contact to support installation and application use of RTC software into the classroom.

New York, Ny, Us

Consolidation of customer media usage reports for the Paid Service, Communication, and Membership divisions using both the Microsoft Suite and Tableau. Analyzed website visitor behavior to determine customer segment trends and performed preliminary analysis for an online analytics document sharing system for company-wide use.

Master Of Science - Ms, Management Of Information Technology

Bachelor’S Degree, Business Information Technology - Operations And Supply Chain Management

Bachelor’S Degree, Management And Consulting Analytics