ANTHONY L JONES

**** ********** ***** · Buford, Georgia 30518 · 770-***-**** adbhb9@r.postjobfree.com

Technical Skills

Proficient in an assortment of technologies

TSQL, SSIS, SSRS, TABLEAU

SQL Server 2014,2016

Microsoft Office 2016

TOAD for Oracle version 12

CERTIFICATIONS

Querying Microsoft SQL Server 2012

Administering Microsoft SQL Server 2012

Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft Office Access 2013

Microsoft Certified Professional (MCP)

EDUCATIONAL/PROFESSIONAL DEVELOPMENT

SQL Server Database Developer Certified 2014

Pacific Institute of Technology, Morrow GA

Master Online Teacher Certificate 2010

Thomas Edison State College, Trenton, NJ

Master of Business Administration 2003

Shorter University, Rome GA

Bachelor’s degree: Management 1991

Northwood University, Midland MI

PROFESSIONAL SUMMARY

Used TSQL scripts such as stored procedures, views, functions, COALESCE to manipulate data for analyses.

Used MS ETL tools such as File System, Foreach Loop, Conditional Split, Merge, Data Conversion to extract data from different sources such as txt, excel, etc…

Implemented Reports such as Tabular, Drill Down, Parameters for viewing extracted cleaned data.

REVELANT EXPERIENCE

Market Force Inc – SQL Developer – IT Dept 09/2019-Present (Contract)

6625 The Corners Pkwy NW, Peachtree Corners, GA 30092

Developed TSQL scripts and Parameterized stored procedures using Microsoft Azure Cloud in Agile

Created Seed data for Staging Databases

Gwinnett Medical Center – Data Analyst – IT Dept 08/2018-08/2019 (Contract)

665 Duluth Highway Lawrenceville GA 30046

Develop TSQL, STAR SQL scripts to extract medical data, ICD10 codes from various database systems.

Retrieve data for medical research for physician training residency.

Analyze, audit, test and process data for quality, integrity of the medical information.

Dekalb County Government – TSQL\SSRS Developer - IT Dept 07/2017-05/2018(Contract)

Bobby Burgess Building 3630 Camp Circle Decatur, GA 30032

Converted existing reports from TOAD Oracle Report Builder to SSRS.

Converted queries for existing reports from TOAD Oracle to SQL Server 2012

Created adhoc SSRS reports using parameters and expressions based on client requirements.

Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv into SQL

HDSupply – TSQL\SSIS\Business Objects Developer - IT Dept 06/2016-02/2017(Contract)

3100 Cumberland BLVD, Atlanta, GA 30339

Migrated Access 2013 queries to SQL Server in an AGILE environment

Developed complex stored procedures, views, and ad-hoc queries for extracting data into sql server

Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv into SQL Server

Deployed reports using SAP software Business Objects with different formats such as pdf, excel, etc.

Generated SSRS reports such as drill down, drill through, and different types of Charts

Aramark – TSQL\SSIS\SSRS Developer 02/2016-04/2016(Contract)

775 Tipton Industrial Dr., Lawrenceville GA 30046

Converted Access 2013 queries to T-SQL code

Migrated DTS to SSIS 2014 packages and tested the packages

Modified SSRS reports such as drill down, drill through, Matrix, and different types of Charts

Home Depot – TSQL\SSIS Developer 09/2015-02/2016(Contract)

2455 Paces Ferry Rd NW, Atlanta, GA 30339

Assigned Primary & Foreign keys to columns, eliminated un-used tables

Developed complex stored procedures, views, triggers and ad-hoc queries.

Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv to SQL Server

Implemented logging on packages

IndegeneTTM – TSQL\SSIS\Tableau Developer – Health IT 03/2015–09/2015(Contract)

222 Chastain Meadow Ct, Ste 300, Kennesaw GA 30144

Developed SQL scripts to retrieve data from medical charts of high-risk patients’ healthcare industry.

Developed complex stored procedures, views, ad-hoc queries

Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv to SQL Server

Transferred & upgraded databases to a new cloud server

Deployed SSIS packages for scheduled jobs

Implemented worksheets, dashboards, story points in Tableau

Cargill Corporation – TSQL\SSIS Developer 03/2014-03/2015(Contract)

862 West Ridge Road, Gainesville, GA 30501

Developed complex stored procedures, views and ad-hoc queries

Optimized queries using indexes (cluster and noncluster), indexed views, constraints, execution plans etc.

Deployed SSIS packages for scheduled jobs

Designed SQL scripts to retrieve large datasets from Data Warehouse

Created SSIS packages to perform ETL tasks to extract data from txt, excel and csv to SQL Server

Quad Technologies, Inc. – Systems Administrator 01/2012-03/2014

3782 Harris Blvd., Kennesaw, GA 30144

Installed new software releases, system upgrades, and evaluated and resolved software related problems. Performed system backups and recovery. Provide support for desktop running windows operating systems

United Parcel Service (UPS) – Database Analyst Supervisor 03/1995-01/2012

55 Glenlake Parkway Northeast Atlanta, GA 30328

Developed complex stored procedures, views, and functions to retrieve large datasets.

Retrieved large 30 GB datasets from two different Data Warehousing architectures using the SSIS Tool.

Migrated queries from MS Access to SQL Server environment.

Designed and developed SSIS packages from various sources such as txt, excel and csv to SQL Server tables.

Deployed, configured, managed, troubleshooted and optimized SSIS best practices.

Uploaded special accounts to the Data Warehouse to retrieve data for accuracy of data.

Documented all processes and Data Flows in SSIS and SQL environment for future reference.

COMMUNITY INVOLVEMENT

Gwinnett County Public Schools: Mentor for the Community-Based Mentoring Program

Junior Achievement of Georgia: Volunteer to teach leadership to middle and high school students

United Way: Served food to the needy and boxed perishables to be given to deserving families

Habitat for Humanity: Assisted with building houses for low-income families

Contact this candidate