Resume

Sign in

Sql Server Data

Location:
Kennesaw, Georgia, United States
Posted:
October 12, 2016

Contact this candidate

RON HATCHETT

Tel: 770-***-****

Kennesaw, GA ****2 Email: acw0si@r.postjobfree.com

Talented SQL Database Developer With Over 12 years’ Experience in Design, Architecture, Data Modeling, and Data Migration EXECUTIVE SUMMARY

Highly motivated, service-driven professional with a strong technical background and vast IT experience, coupled with proven desire and commitment to continually learn and apply new technologies.

Track record of success in designing, developing and debugging code modules to ensure clients’ expectations are not only met but exceeded.

Experienced at providing leadership, managing multiple concurrent projects, maintaining the ability to make rational decisions in pressure situations, and completion of projects before deadline.

Exceptional interpersonal skills, with the ability to clearly communicate with non-technical and technical persons at all levels both within and outside organization.

Proven ability to install and administer SQL Server databases.

Expertise in the administration, Backup-Recovery and Performance Tuning of large database.

Highly skilled at effectively analyzing and developing innovative solutions in support of SQL Server 2008/2000 and MS Access.

Strong problem management / trouble shooting skills, and well versed in data migration. CORE COMPETENCIES

Design & Data Modeling

Report Design

Data Cleaning

Performance Tuning

Backup and Recovery

Database Security

Data Migration

Capacity Planning

Business Intelligence

Server Administration

Change Management

Project Management

TECHNICAL SKILLS

Databases: SQL Server 2008/2000, Stored Procedures, SSIS/DTS Packages (TSQL), Automated Scripts, Replication, MYSQL 5.6.10, Access 2010/2007/2000, Oracle 11g Languages: VB.NET 2008/2003, VBA, Visual Basic 5.0/4.0/3.0; VBScript 5.6; Internet: Front Page 2003; Cold Fusion 4.0; ASP

Reporting Tools: SSRS, Seibel 7.0, Crystal Reports 5.0/4.5/10, SAS GIS Tools: Arc GIS 9.1; Arc Catalog; Arc Map

Source Control: Subversion (SVN)

Visual Studio 2013 / 2008

ESF Database Migration Toolkit

SQL Server SSDT Deployment Tool

PROFESSIONAL EXPERIENCE

Jinny Corp October 2011 - May 2016

Database Administrator

Successfully migrated a distributed Legacy Visual FoxPro 9.0 Database across 15 sites to a centralized SQL Server 2008 site using SSIS packages and stored procedures.

Analyzed and designed mapping rules for the Migration process.

Validated and designed an Integration test plan for the Migration process.

Maintained an Error-Log for data that did not meet the requirement during Data Cleaning.

Provided Database Monitoring to track performance using tools such as Redgate and Solarwinds.

Maintained and tested data/structural changes for Application Developers and determined overall effect on system.

Provided Expertise/Analysis on slow running queries to optimize the system.

Standardized processes which included creating documentations for installations, migrations, upgrades, backups, restores and index maintenance.

Maintained/updated Jinny Corp Product information & Images for www.Beautylocia.com website on a Monthly basis.

Converted 80 FoxPro 9.0 reports to SQL Server 2008 SSRS reports.

Conducted database schema, T-SQL scripts, code review and assure code complies with coding standards prior to moving them from Staging or QA to Production.

Perform SQL Server Installations, upgrades, configurations and deployment in Dev/QA/UAT/Prod environments.

Troubleshooting transaction blocks and deadlocks using Activity Monitor, DMVs, and 3rd party tools.

Standardize processes within the IT department including creating documentations f or installations, migrations, upgrades, backups, restores, index maintenance, etc.

Support Developers, QA Testers, and Business Analysis with Stored Procedures, complex queries data analysis and ad-hoc reports.

Review Event Logs daily to analyze user and system activity to help detect patterns of normal use and potential issues and warnings.

Spa Sydell Roswell, GA March 2011 - August 2011

Crystal Report Developer

Worked closely with Controller to resolve General Ledger issues, customer accounts and Auditing/Analyzing Data in the Mas90 Accounting System.

Maintained/Created Crystal Reports to track Spa activity for YTD, MTD and Daily Sales using sub-reports, cross-tabs, grouping and sorting, running totals, parameters and conditional formatting from an Oracle Database.

Effectively assisted HR Director with payroll process and modified Crystal Reports to account for changes in commission calculations, rates, products and services. Automated Crystal Reports to run on a scheduled time using VBScript and Batch files.

Created and delivered ad hoc and routine reports as requested by the Controller, HR and Management.

Documented existing Crystal Reports to describe their function, Data Source, users and frequency of use.

Assisted the Network Administrator with designing a Production/Testing environment for Crystal Reporting.

NAPA Headquarters Atlanta, GA February 2010 - January 2011 Database Administrator

Worked with the Director of Business Development Auto Parts Group and staff to design Automated Reporting tools by leveraging my MS Access 2007/2010 skills such as VBA coding, Macros creation, Custom Functions, Menu Forms, SQL queries, and Database creation.

These Automated Reporting tools replaced a manual process which created the reports in Excel.

Exported data from SQL Server 2005 Data Warehouse on a monthly basis into an Ms Access 2007/2010 database. Users have a Custom Menus to choose which report to run. All report are formatted and exported to Excel.

Documented and created a user guide for the reporting tools. The Link Group Atlanta, GA 2007 - 2009

Database Administrator

Worked with Director of Development to create a Tracking Databases for customer data that enabled product development and optimization, which lead to increased engagement and more profitable revenues, Utilized SQL Server, T-SQL, Stored Procedures, DTS Packages, Functions, VB.net, VBScripts, Web Services and MS Access.

Provided executive management with ad hoc, weekly and quarterly reports with key metrics for product growth performance and customer engagement.

Developed an internal project Resources Allotment tool which leveraged HTML, Front Page, MS Access, SQL queries and Macros.

Created Documentation for the Customer Tracking Database and Resource Allotment tool. DataFlow Solutions Woodstock, GA 2007 - 2008

PART-TIME Database Analyst

Developed tools for an online payment system; (NCourt) leveraging VBA, VBScript and MS Access.

Developed and monitored data archival systemic processes.

Assisted in strategic and tactical planning process for the product, planned offline payment procedures.

Planned personal identifiable information leveraging FTP, encryption, compression etc. UPS Corporate Headquarters Atlanta, GA 2003 - 2007 Database Analyst

Developed proprietary key performance indicator tracking tools leveraging MS Access, VBA, SQL Server, T-SQL, Stored Procedures, DTS Packages, Functions and VBScripts.

Strategic review of key metrics and project evaluation; worked with IT loading the UPS Product Development Reporting (PDR) tool for Product Managers and Department Directors.

Created a database that imported weekly UPS billing and revenue data to track sales and customer acquisition costs; the UPS EEMS covered 7 regions and 23 districts and was eventually leveraged enterprise-wide using VBA, Macros, SQL queries and Functions.

Geo-coded and standardized addresses for mapping; analyzed workflow processes to increase driver productivity.

Used Cold Fusion to create Forms for Payroll Admin to assist with calculating pension payments for hourly employees in US.

AD-Hoc Reporting with Crystal Reports/Seibel using SQL Server as the Data Source. Greater Atlanta Metro Area 1998-2003

MS Access Database Developer/Consultant

Responsibilities

Access Developer/SQL Programmer: Cipher Trust

Access Developer Programmer: Home Depot, Paine Webber Inc, UPS Corp. HQ

Data Analysis: Georgia Pacific/Unisource, GNB Technologies

VBA Programmer: Paine Webber

Analyst/QA DocuCorp International-Programmer 1996-1998 Visual Basic Software Developer: The Cbord Group 1992-1996 SAS ProgrammerCornell University 1988-1992

EDUCATION

Bachelor of Science (B.S.) Management Information Systems Syracuse University



Contact this candidate