SQL Database Engineer - T-SQL Master & Excel Expert

Ferron Shorter

Peachtree Corners, GA ***** ****************@*******.***

404-***-**** linkedin.com/in/ferron-shorter

SQL Database Engineer/Developer/Data Analyst/T-SQL Coder/Excel Formula Expert

Summary:

T-SQL Server 2012, 2019 - Stored procedures, Triggers, Views, Indexes, Backup, Restore, Database Security, Functions, DML, Writing SELECT, UPDATE, DELETE, and INSERT statements with multiple tables joins. OLTP.

DDL, Writing CREATE, ALTER, DROP and TRUNCATE statements. Aggregates (SUM, COUNT, MIN, MAX, AVG).

Develop ETL/SSIS/SSDT Imports and Exports that meet provided specifications. SSIS Control Flow, SSIS Data Task, SQL Tasks, Data Conversions. Data sources include Excel, csv files, flat files, Access, Website data.

Delivering reporting solutions in SSRS based on criteria, cascading parameters and drop-down lists for end users.

Certified Microsoft Office Specialist, Data Analyst having expertise in analysing and reporting data. Including decades in mastery of MS Excel Functions, Formulas and tools including V-lookup, X-lookup, pivot tables, Index Match, Conditional formatting, charts, Text to Columns, SumIfs, SumIf, CountIfs, CountIf, AverageIfs, AverageIf, IsNumber, CONCATENATE, NOW, Trim, LEN, IF statement/function, Data Validation / Drop Down Lists and countless other Excel function knowledge.

Creation of databases in 1st, 2nd and 3rd form, data modelling, normalization, structure, primary keys and foreign keys for referential integrity. Designing tables and reports.

Possessing a passion for T-SQL scripting in SSMS, building SSIS packages and SSRS reporting.

Superior spoken and written communication skills; articulate and professional

Managing my relationship with exterior customers/clients with excellent phone presence and interpersonal skills.

CERTIFICATIONS

MS -SQL Server 2008 R2

Microsoft Certified Technology Specialist

Microsoft Office Excel certification

SCW Fitness Education Certification

TECHNICAL SKILLS AND COMPETENCIES

T-SQL · SSIS · SSRS · SSAS · OLTP · Relational Database Design

· Data Integration and Reporting ·

· Development and Implementation · Data Analysis

KEY ACCOMPLISHMENTS

Developed ETL/SSIS Imports and Exports that specify source-to-target mappings, data conversion, data cleansing, data validation and data upload from SQL Dev to SQL staging servers to SQL production for various applications.

Built SQL-triggers to capture front-end application transactions by employees that was beneficial to the organization with the ability to identify and track the work of the front-end user in the application.

Delivered reporting solutions in SSRS based on criteria, cascading parameters and drop-down lists for end users. This reduced error possibility and increased efficiency and saved time for end users making decisions.

Achieved Company expense savings providing critical data for 2022 Florida Hurricane Catastrophe Exam (FHCF).

Accomplished solution to a critical accounting report issue by dissecting and investigating all steps of SSIS package, finding data entry errors, then eliminating the errors by modifying the package and adding rules and constraints resulting in reporting accuracy.

Building datasets containing data of the Insurance industry, medical field, retail and various additional industries.

Enjoying the technical/programming side as well as working with the business people as a liaison.

Solved major reports that were missing data by discovering the problem being related to leading zeros, then modifying the SSIS package by adding a new text file as a source data input file and adding an SSIS data conversion.

PROFESSIONAL EXPERIENCE

SQL Freelancer Remote

SQL Data Developer/ SQL Database Engineer August 2023 – Present

Designing Databases in 1st, 2nd and 3rd Normal form, diagrams, tables, schemas, foreign key constraints.

Building SSIS packages for loading/integrating data and populating tables. Data Flow & SQL Execution.

Creating Tables, Store procedures, Views, User defined functions, Indexes, Triggers along with other database workflow objects (CTEs, Temp tables, Table variables, derived tables, For Loops, data types, Indexed Views).

Writing Complex T-SQL stored procedure scripts to produce datasets that tell the stories of an organization's state of business and progress with calculated fields and quantifying.

Optimizing complex SQL and Query Optimization SQL Performance Tuning. Create Indexes, using SQL Profiler and Execution Plan resulting in much faster query execution time.

Writing T-SQL codes that produce dataset reports.

Running SSIS packages via Command Prompt.

SageSure Insurance Company Remote

SQL Database Engineer November 2021 – July 2023

Created T-SQL codes in building crucial reports of Renewal Underwriting and Claims for Underwriters. Also building T-SQL codes in producing monthly Sales reports used as decision support models by Sales Managers and upper management. These reusable codes have been saved for usage by future analysts.

Optimizing and improving SQL performance by converting long-running stored procedures to SSIS packages as well as creating indexes. Database Engine Tuning Advisor, SQL Profiler, building Indexes.

Responsible for recurring reports per JIRA tickets and ad hoc requests.

Translate Insurance business language to technical understanding. Incorporating SQL Logic to decipher Insurance policy difference of New Business policy versus renewal policy, Quotes versus Policies and policy state of Active Policy versus Cancelled policy versus reinstated policy.

Using SSRS and DOMO visualization tools for producing reports.

Working in cross-functional teams and projects (Actuarial, Underwriting, Sales).

JRS Data Remote

SQL, SSIS, Reporting, Developer (freelance) December 2020 – November 2021

Extracting the data by writing T-SQL queries, view, functions, joins and aggregate functions.

Developing stored procedures to optimize SQL server dataflow.

Migrating data to SQL Server from Legacy systems via my creation of ETL/SSIS Data Flow. Pulling data from data sources such as Microsoft Access, flat files, Excel, Oracle and populating the newly created tables via SSIS.

Database Design in Building SQL Relational Databases from the ground up and protecting the integrity of the data.

Using numerous test cases to test the data along with Staging tables to confirm row count and format of columns for Database verification.

Source to Destination data mapping, analysing data, data cleansing, data conversion and data retrieval.

with source data

Using VLOOKUP, XLOOKUP, Index Match and Pivot Tables for pulling data for Excel Spreadsheets/Workbooks.

Bank of America Remote

SQL Analyst consultant (6-month contract) June 2020 – December 2020

Creation of stored procedures for campaign cases.

Modification of stored procedures for campaign cases.

Used SSIS to bring data from Production server to Development environment.

Used SQL, TOAD, Visual Studio (SSDT), JIRA for deployment requests.

Create Stored Procedures, Views and other data sets for regular reports and requested/ad hoc reports.

FIRST DATA Marietta, GA

SQL Analyst Engineer November 2017 – April 2020

In charge of database backend and working frequently with ad hoc requests and SQL coding scripts.

Design, testing and deployment of SSIS packages for various tasks including data integration for Databases, Access, text/csv and Excel files to SQL.

Produced Triggers for audit trail and tracking of changes made by front end users of the application.

Continuously writing joins for stored procedures to deliver additional data including backend User data, last login date/times and employee data for audit reviews.

Created SQL views linked to relational databases and tables in RiskVision. Providing daily reports for Remediation staff and vulnerability analysts saving hours of time.

AGX Fitness Atlanta, GA

IT Consultant (contract) Feb 2017 – Oct 2017

Designed databases, built related tables within SQL Server for migration of imported data from Access and Excel via ETL/SSIS packages.

Created Stored procedures that automatically identified and removed trainers and staff members from the database who were not tied to any clients, as well as clients who were inactive for more than two (2) years or deceased.

Invesco Atlanta, GA

SQL Developer/Data Analyst (12-month contract) Jan 2016 – Jan 2017

Built SQL Stored Procedures and User-Defined Functions using T-SQL for financial data fragments in applications and documents for Stakeholders.

Developed parameterized reports via SSRS with SQL queries and stored procedures for easier access by users.

Tested existing SSIS packages for database upgrade.

Processed Pivot Tables and charts to provide metrics and updates to upper management.

Brightree Lawrenceville, GA

Data Analyst/SQL Developer (12-month contract) Sep 2014 – Sept 2015

Captured data of doctors, patients and medical equipment to create customized business reports using SSRS reporting including creation of data sets through SQL queries.

Imported the clients’ data to our SQL staging & production database via SSIS subsequent to the data analysis.

Consistent interaction with the clients via phone conferences and email for detailed information of their data ensuring their data needs are met and training the clients on how to use our data scrubbing application.

Was responsible for the creation of databases in SQL Server with various constraints and keys for new clients.

Researched and discovered data-related issues, providing reports to the client as well as resolving the issues.

InVesta Services Atlanta, GA

Data Analyst, Developer Jan 2014 – Aug 2014

Extracted data from SQL and providing data analysis in the form of graphs, pie charts, bar charts for Assets and transactions.

Gathered requirements and documentation for the VP of finance SSRS reports.

Constructed SSIS packages for various tasks including data integration for Databases, Access, text/csv and Excel files to SQL. Setting data key constraints, testing for duplicates.

Created an Analysis tool using Excel Power Pivot loading millions of rows of data to Excel from SQL.

UPS Roswell, GA

SQL Developer (contract) Sep 2012 – Sep 2013

Created SSIS packages used in job steps for scheduled jobs in SQL server agent.

Produced stored procedures in T-SQL, managing tasks and meeting deadlines in response to ad-hoc requests.

Migrated data to/from staging table in SQL from multiple data sources such as Oracle, and other SQL servers.

Created T-SQL stored procedures that are used in SSIS packages and SSRS reports.

Scheduled jobs that generate automated data loading and daily reports for accounting databases.

New Horizons Atlanta, GA

Data Analyst, Jr. SQL Developer Dec 2010 – Sep 2012

Scripting in T-SQL from tables in the student database, developing test procedure cases.

Converted Access databases to SQL design tables, import data and developing constraints and indexes ensuring data integrity.

Transported data between SQL servers using SSIS and generating reports using SSRS in Visual Studio.

Used Database Engine Tuning Advisor and monitoring tools for database analysis.

Experienced exposure to database administration principles and practices including security, permissions and alerts.

Bally Total Fitness Lawrenceville, GA

Certified Professional Fitness Manager/Trainer June 2004 – Dec 2010

Leading and training clients to healthy lifestyle through clean eating, strength training with cardiovascular endurance.

In charge of Business transaction data, Trainer data, schedules, client data.

EDUCATION

Associates of Arts (AA), Accounting

Gwinnett Technical College, Lawrenceville, GA March 2010

Contact this candidate