Summary
Overview
Work History
Education
Skills
Timeline
Generic

Torrance V. Dunn

Lithonia,GA

Summary

Experienced IT professional with over 20 years in the industry specializing in Cybersecurity, SQL Development, Reporting, and Data Analysis. Possessing a Top Secret Clearance, excels in Financial, Business Intelligence, Data Warehousing, and Reports. Known for high-caliber analytical and leadership skills, highly organized, dedicated, and self-motivated. Proficient in testing various IT Business Management Applications/Interfaces with excellent data analysis and problem-solving abilities. Skilled in business and home software products, office products, and business communication.

Overview

19
19
years of professional experience

Work History

SQL Server Database Administrator

Gunnison Consulting Group, Inc.
01.2016 - 02.2025
  • Cybersecurity domain User Domain, Workstation Domain, LAN Domain, Remote Access Domain, and System/Application Domain.
  • Will handle complex accounts or project assignments as well as manage the CSIRC reporting queue.
  • Provide and deliver support for Symantec Endpoint Protection Manager (SEP).
  • Work with a client to determine security risks.
  • SQL Database Archer Support SGRC for maintenance.
  • Work with the SPLUNK team in given out certificates for websites for Splunk.
  • Create the backend for SPLUNK to SGRC Archer.
  • Maintain and support for Ivanti Heat.
  • Work with VMware vSphere creating VM Servers.
  • Work collaboratively with the OS, CISO Operations and OpDiv Teams to complete reporting assignments accurately and on time, including custom data projects.
  • In place upgrades of all our VM to Microsoft Windows Server 2019.
  • In place upgrades of all our VM to Microsoft SQL Server 2019.
  • Provide superior client support for data questions and requests.
  • SolarWinds upgrade from the hack version to the safer version.
  • Maintain all the SolarWinds upgrades.
  • Support PM with Business Analytics on client delivery, requirement, design and testing activities.
  • Deliver internal data solutions such as Access and SQL databases for client reporting incidents, performance measures, statistics, etc.
  • Interpret business objectives; assess alternatives and present logical solutions to problems for both OS, CISO and CSIRC as designated.
  • Gather and analyze moderately complex facts/data to draw logical inferences from the information.
  • Prepare project management control plans that cover all associate tasks and milestones.

SQL DBA Developer

Incomm
01.2006 - 01.2016
  • Work with existing ETL team to understand ETL implementations at InComm related to data generation, configuration, and inventory management.
  • Implement additional ETL processes that would benefit data generation, configuration, and inventory management.
  • Identify manual processes that can be automated.
  • Develop tools to handle the identified manual processes.
  • Train Operations to use the new tools.
  • Created stored procedure codes using T-SQL that can process data in an efficient way.
  • Developing and supporting analysis solutions, data transformations, and reports along with implementing reporting and data solutions.
  • Tune and optimize the performance of productions stored procedures for our daily customer’s transactions to the DataMart.

SR. Report Developer / Data Manager

Incomm
01.2006 - 01.2016
  • Responsible for developing complex backend database applications using MS SQL 2012, MS SQL 2008, MS SQL 2005 & MS SQL 2000 technologies.
  • Created or modified various daily, weekly and monthly SQL scripts, stored procedures, functions, and packages to include the new enhancements using MS SQL 2005 to meet the business user's expectations.
  • SQL Server Reporting Services (SSRS) R2, SQL Server Integration Services (SSIS) R2, and SQL Server Analysis Services (SSAS).
  • Actively ensured the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.
  • Providing IT expertise and involving in the complete life-cycle of the development, support and maintenance of the Remittance project.
  • Created/coded reports that meet user requirements, validated reports, supported data and technical requests, and supported strategic data analysis.
  • Analyze, extract, transform, load, and integrate data into consumable formats, meeting all critical milestones using data warehouse techniques.
  • Provided financial reports using Stored Procedures created in MS Excel as adhoc requirements to ensure quality decision making to Accounts Managers and Executive Managers of the company.
  • Successfully implemented various financial and accounting reports.
  • Also modified existing Stored Procedures to ensure performance and quality data.
  • Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
  • Created and developed highly complex applications using MS SQL as back-end with expertise in design and development of MSSQL Packages and Procedures.
  • Superior skills in designing and developing MS SQL objects such as Tables, Views, Indexes, Stored Procedures and Functions in SQL.
  • Analyze System Requirements to create a Technical Design with the assistance of other Sr. Report Developers, Project Managers and Sr. DBAs.
  • Have a good understanding of analytical functions with an ability to convert the business requirements to technical understanding, instantiate, iterate, and terminate the code logic to meet the user needs.
  • Responsible for helping set development standards for database development within SQL.
  • Act as a technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer.
  • Implement and support code migration into production.
  • Contributed to a high-performing workgroup by applying interpersonal and collaboration skills to achieve corporate goals.
  • Provided high level of attention to detail while completing multiple tasks demonstrating a commitment to quality while meeting project deadlines.
  • Adhere to the functional design, policies, and procedures of the project with a very good understanding of architecture and concepts of ETL and database design.
  • Analysis of business requirements, preparation of source-target mapping documents, develop data load components using ETL procedures, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing.
  • Usages of MS Access and Microsoft Excel in a data analysis and reports leveraging VBA.
  • Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementations.

Education

BA - CIS

DeVry Institute of Technology
Atlanta, GA
01.1995

Associate Degree - Computer Science

Augusta Technology Institute
Augusta, GA
01.1993

Skills

  • System upgrades
  • Server and system administration
  • Performance analysis
  • System performance monitoring
  • Performance tuning
  • Database maintenance
  • Data migration
  • Data modeling
  • Disaster recovery
  • Database monitoring

Timeline

SQL Server Database Administrator

Gunnison Consulting Group, Inc.
01.2016 - 02.2025

SQL DBA Developer

Incomm
01.2006 - 01.2016

SR. Report Developer / Data Manager

Incomm
01.2006 - 01.2016

Associate Degree - Computer Science

Augusta Technology Institute

BA - CIS

DeVry Institute of Technology

Similar Profiles

CREATE PROFILE
Torrance V. Dunn