Randolph Charles Compton
Farmington, NY 14425
Phone: 585-***-****
acuto4@r.postjobfree.com
LinkedIn Profile: www.linkedin.com/pub/randolph-c-compton/1/875/16/
Summary: Recently SQL and Data warehouse work with ACMs new Clinical trials system. In that roll I was responsible for supporting the new clinical trial system, writing code (vb variant), testing, designing and implementing the Data Warehouse, supporting MS Dynamics upgrades in the accounting department. Seven years working for Xerox, contributed to multi-million plus saving and cost avoidance through my technical leadership. Managed multiple teams both technical and business resources. Excellent communications dealing with multifunctional organization/teams with a keen understanding of translating business processes to technical solutions. Proven record of Troubleshooting and Customer Oriented support with very positive results from clients.
Experience:
ACM Global Labs, Rochester, NY 2014-2015
IT- Applications Analyst
SQL SSIS scripting
DBA functions
Project Management
Application Support (both Clinical Trials Systems[i] and IT in general)
Xerox Corporation, Rochester, NY 2006-2014
XIM-Enterprise Infrastructure Services – IT Manager/ DBA
Leadership of development team for product drove significant improvements in business efficiencies. Major duties included:
oFunction as SQL DBA for Infrastructure Request Tool using SQL 2008
oManage Developers and Development Life cycle
oSupport Legacy Applications (MS Access, Flat File import), using SSIS
oInterface with Development Team on Database Design
oTest and Maintain SQL performance using script, store procedures.
oExtract and Analyze data on an ad-hock basis.
Over 20 years’ expertise in IT Management.
Training in multiply venues’ including live sessions, produce video demos, technical writing and vendor training.
Managed hundreds of technical projects.
Administrative functions of SQL, new accounts, permissions, backups
Interface with other databases Oracle, MS access, Informix
Parity Americas/Kenda Systems, Rochester, NY 2005-2006
IT Manager/IT Support
Managed Corporate network from 4 regional office (NYC, Atlanta, Rochester, Hopewell Junction)
Managed infrastructure in all offices. Each office has a different system
Symon Communications/TargetVision Inc., Victor, NY 1997-2004
Manager, Information Technology
Manager, Content Services
Project Management for CRM(SQL 2003) design implementation, key to implementing consolidated customer records for improved business processes and instrumental in the sale of Target vision to Symon Communications.
Managed stability of infrastructure, and remaining cost effective
Negotiated contracts with Associated Press(2M vs. 3M with Reuters), Weather Channel, Unisys and other service providers to reduced cost on a continuous bases.
Manage News department (3) and IT staff (3).
Computer Task Group, Rochester, NY 1995-1997
Contract - Associate Software Engineer Xerox XNS System
Training of Xerox employees on all Microsoft Products
Education:
Monroe Community College, Rochester, NY
Associate of Science - Computer Science, 1985
Hardware:
Network: Cisco Routers, Cisco Pix Firewalls, Netopia Routers, HP ProCurve Switches, Adtran Channel Banks, Netgear Switches. IBM Console Manager. Linksys Cable Router/GA B access point
Servers/Workstations: IBM Eseries HA servers, Dell Desktops, Dell Laptops, IBM Tape Library, Exabyte/Sony Tape Library, Compaq Proliant Server, Micron Servers.
Telecomm: Panasonic DBS 576 PBX, Iwatsu PBX, Adtran Channel Banks, Aspect ACD
Misc.: Noaaport Weather and Satellite system, Comstock CSP/Satellite network.
Software:
Server:
Windows 2003/2008/2008 R2 Enterprise Server, Windows Advanced 2000 Server ISA 2000 Server,
Windows Exchange Server 2003/2000/5.5/5.0/, Windows 2000/3 Active Directory,
Symantec 10 Backup Exec., AVG Antivirus Software, McAfee Antivirus, Windows SQL Server 2000
Oracle 10g for Solaris 8, IBM WebSphere 6, IIS 6, IAS, Windows 2003 Sharepoint Team Services,
RedHat Linux 7.2 8 and 9, Arc Serve 2000, Trend Micro, WebSense, Windows Terminal Services.
Cisco Unified Communications Manager V 7 & 5, AXL and Soap Interface.
Desktop:
Windows OS XP, Vista, 7, 8, 10;
Office 2000/2002(XP)/2003/2007/2010, Project 2003/07, Visio 2003/07, Paint Shop Pro 9, Adobe Photo Shop CS.
Development:
C# and VBA code for Front end user interface of Telecom Process
TSQL, SSIS – for CDR call detail and other and SSRS – develop reports for critical process and projects. Design and Manage Databases in MS SQL in Version 2005 and 2008.
Professional Development:
Red Hat 8 Administrator (2000)
Cisco Installation and Configuration (1999)
Lean Sigma Six Yellow Belt (2007)
Green Belt icourse work no project (2012)
Brainshark Certification (2012)
[i]