Andrew Sharp Email & Phone Number

Des Moines, Iowa Area

Nsf Cipm, 1730 Varsity Drive, Ste 110 Ncsu Centennial Campus Raleigh, Nc 27606

Serve as system and support administrator for internal CIPM server host environments, network, and end-user workstations. Research, design, and build diverse hardware and software solutions while ensuring compliance with federal agency information system requirements. Serve as first point-of-contact to resolve all major IT problems, including data loss and server failure. » Provide daily support for 50 to 75 staff members in the USDA and NCSU systems» Manage Microsoft System Center administration for an on-site CIPM data center, including management of virtual machines, compliance, and operations; provide network storage systems administration, including EMC SAN support» Support USDA APHIS cooperative agreement sites hosted on CIPM ColdFusion software stacks; perform annual USDA APHIS compliance validation, testing, and remediation » Oversee CIPM networking infrastructure, document CIPM security policies against USDA APHIS system requirements and NIST guidelines, and collaborate with hardware, software, and service vendors to support daily CIPM operations » Develop and support Windows network infrastructure; develop secure and isolated environment for USDA-hosted applicationsKey Accomplishments: » Maintained a web hosting environment used by the USDA APHIS and NCSU/CIPM collaborators for invasive pest research projects and tools; this environment is the only NIST-certified data center outside of the USDA environment» Support IT efforts to improve local, national, and international food security and research, track, and control invasive species » Developed, maintained, and supported in-house security compliance software for six enterprise RDBMS platforms across five+ major operating system platforms; administered, developed, and maintained server and application stack hosting of backend database and applications used for client program reporting and analysis

Dubuque, Iowa

Ensured compliance of Windows, Linux, Unix, database, and account health checking requirements with IBM and customer agreements by managing the patch record process for Unix and Intel compliance, developing in-house security compliance checking software for database management systems, and responding to all audit-related requests. » Supported leadership and a technical team of 50 members using IBM tools to manage server, middleware, and application security; responsible for leveraging IBM and third-party compliance/security tools to maintain a strong, action-ready audit posture » Provided support for all department server and application assets, including Unix, Linux, and Windows server support and administration and support of a DB2 database» Applied knowledge of scripting to develop novel solutions and overcome limitations in the functionality of existing tools» Documented period compliance-related processes and proceduresKey Accomplishments: » Collaboratively established and maintained a multiplatform test and development lab for a local IBM delivery system; this complex lab environment included POWER5/6 AIX servers and IBM SystemX servers, hosting a variety of operating systems» Consolidated a new services delivery line and tool set for security checking databases at IBM; led the technical transition in only nine days, enabling numerous product improvements while reducing required support staff from five employees to one employee and one contractor

Cedar Rapids, Iowa Area

Provided technical support for call center operations, including data collection, data management, and reporting. Managed the implementation of calling projects, set up data and supported ad hoc requests for phonathon operations, and used internal software to load data and projects for a staff of 50 to 100 callers. » Applied strong attention to detail and independent problem-solving within the confines of SOPs to manage data loading, mining, and reporting projects for account-specific databases » Leveraged excellent communication skills to maintain contact with internal and external clients » Used Oracle SQL, FoxPro scripting, Microsoft Office Suite, and proprietary software, including daily use of standard and custom extract, transform, load (ETL) procedures to manage data from company internal data stores and customer data extracts to company data warehouses

Waverly, Iowa

Provided troubleshooting for issues with hardware, software, and anti-virus/anti-spyware. Supported time-management and tracking software for calls and visits. Provided desk-side support for a faculty and staff of 400 and 1500 students. .