Scott Scranton Email & Phone Number

Charlotte, North Carolina

Charlotte, North Carolina

Charlotte, North Carolina Area

Database Analyst, Data Integration Team, 2016-2017• Analyzed source database systems, determining best course of action in transferring data to destination database.• Designed and developed ETL procedures for data transmission to new systems, using Informatica.• Documented ETL procedures for data collection via REST APIs.• Developed and documented ETL processes.• Created data extractions for clients.Data Analyst, Enterprise Data Warehouse, 2015-2016• Summarized analysis of source database systems, determining requirements for data warehouse.• Developed and document data linage from source systems for developers.• Created reference data tables in Master Data Services (MDS).Database Support Analyst, Engagement Services, 2008-2015• Supported account managers to create client surveys and reporting results.• Troubleshot and corrected data quality issues account managers and clients encountered. • Created queries for custom client reports. • Administered Microsoft SQL Server 2005 and 2008.• Facilitated administration and monitoring of Windows Server 2003.• Developed and documented processes for issues occurring during survey administration.• Created data extractions for research teams.• Analyzed data to correct reporting issues.• Received and closed problem tickets.• Served as backup systems administrator.

Charlotte, North Carolina Area

Technical Analyst, CIS Enterprise Database Security, 2006-2007• Developed and documented processes based on risk project recommendations.• Organized standard operating procedures for enterprise database security team.• Created and provided monthly compliance item failure reports to database administrator teams.• Analyzed and tracked compliance item results.• Surveyed database upgrade tickets via PICCT.• Checked gap analysis of processes received from project teams.• Designed metrics for senior-level management and sponsors.• Evaluated enterprise-level risk analysis and remediation.Technical Analyst, DBMS Risk Remediation Cleanup Project, 2005-2006• Constructed and maintained enterprise-wide database inventory with change control.• Performed data analysis of database inventory via SQL on an Oracle database.• Led analysis of database upgrade tickets via PICCT.• Developed and documented processes, based on Wachovia DBMS Risk Remediation Program.• Systematized project team inventory and scheduling database.• Created and provided metrics to senior-level management and project sponsors.• Evaluated enterprise-level risk analysis and remediation.

Charlotte, North Carolina Area

• Managed 10 help desk associates.• On call up to 300 hours per month.• Researched and developed solutions for level III issues on Windows and Arrendale’s proprietary software.• Provided remote and on-site application support for over 110 clients.• Remote monitoring and administration of 75 servers via Symantec pcAnywhere and Ultra VNC.• Experienced administering Oracle 8i/9i databases, on Linux and Windows Server, and manipulating data using SQL.• Received and closed up to 750 problem tickets per month.• Configured, loaded, and tested servers and PCs with Arrendale’s proprietary software.• Managed local intranet website.• Provided training for new technicians.• Provided application and user support for a variety of Microsoft Windows OS platforms including 2000/2003 Server with Active Directory.

Master Of Science (Ms), Network Management, 4.0

Bs, Computer Network Technology

Certificate, Network Administration And Security

As, Computer Science / Mathematics