FREDERICK J. STEMP, JR.

**** **** ***** *****, *********, GA 30517 678-***-**** ac0ipe@r.postjobfree.com http://www.linkedin.com/in/fstemp

Professional Summary

Database Administrator/Developer with 17+ years’ experience in auto finance, point of sales and insurance application design and Database management for a nationwide sub-prime auto lender, nationwide auto parts retailer, a unified marketing company and a Certified Managing General Agency. Broad knowledge and experience with enterprise databases, networking and infrastructure administration and configuration, project management, report creation with Reporting Services, data mining and manipulation, disaster recovery of data, application UI design and hardware solutions to include server and workstation builds and database extract, transfer and load (ETL) process utilizing Integration Services. Several years’ experience with SharePoint administration, management and integration. Possess strong leadership skills, collaborative skills and a proven record of reliability with the ability to "get the job done." Has the ability to utilize proactive troubleshooting skills to foresee potential problems/solutions, and promptly correct any difficulties and discrepancies.

Skills

•Relational Database development, warehousing and administration, Data backup, restores and retrievals

•T-SQL Scripting (Stored Procedures, Triggers, Views, SSIS)

•Windows Administration (XP, Vista, Windows 7, Windows 10)

•Remote access technology (RDP and VNC)

•Excellent problem-solving abilities, ability to manage multiple tasks and achieve milestones on time

•Network maintenance and administration

•Network and System upgrades (hardware and software)

•Technical specifications creation

•Excellent communication and diagnostic skills

•Refined system debugging skills

•Website and portal monitoring

•Enterprise technologies

•Instructor/Trainer

•Brand development

Apple products, OS X, iOS, and devices

Programing Languages

•T-SQL Scripts (Stored Procedures, Triggers, Views, Complex Queries)

•DTS and SSIS Packages, SSRS

•JobGen Plus 4.0/5.0/6.0

•Windows PowerShell 2.0

Software and Applications

•Microsoft SQL Server Express/Developer/Standard/Enterprise (MSSQL/SSMS) 2000/2005/2008/2008R2/2012

•Oracle Server 11g

•IBM DB2

•SQL Server Integration Services (SSIS) 2000/2005/2008/2008 R2/2012

•SQL Server Reporting Services (SSRS) 2000/2005/2008/2008 R2/2012

•SAP Business Objects 3.1

•Withdata Software SqlLobEditor

•RedGate SQL, Red Gate Backup, and Data Compare

•Visual Studio 2005/2008/2010/2013 Shell

•Windows NT 4.0/2000/2003/2008

•SharePoint (MOSS) 2003/2007/2010

•JIRA, Confluence, ZenDesk. FogBugz

•Balsamiq Mockups

•Windows 95/98/2000/ME/XP/7/8

•MS Office Professional 97/2000/XP/2007/2010/2011 for MAC/2013/2016/365

•MS Exchange 4.0

•Acronis, Norton Ghost

•TortoiseSVN

•CozyRoc SSIS+ libraries

•dbSchema

•Tableau 9.3 Desktop, Server, SAS Server

Mac Pages, Numbers, Keynote

Employment History

Data Engineer 10/2016 to Present

SimplePart, LLC – Atlanta, GA

•Responsible for the design, architecture, up keep and maintenance (system performance tuning, backups, restores, service packs, and upgrades) of MSSQL 2014 servers.

•Diagram entire Federated Database system to the table schema level as well as process flow diagrams for many of the stored procedures, functions and triggers in use.

•Built and installed servers for replacement within federated system and migrated all databases.

•Created several SSIS packages for ETL of raw auto parts data from OEM auto manufactures for online retail catalog.

Senior Database Administrator / Developer 07/2014 to 09/2016

Dealer Funding LLC – Alpharetta, GA

•Responsible for the design, architecture, up keep and maintenance (system performance tuning, backups, restores, service packs, and upgrades) of MSSQL 2012 servers in a Citrix environment which never existed in this company prior to my employment.

•Maintained and refreshed all MSSQL Servers in the development environment for use by on and off shore development teams.

•Implemented a SVN repository for all development and database scripts for versioning.

•Created multiple ETL process utilizing SSIS to allow submission Excel spreadsheets, CSV files, and other data format for import into various database servers for loan origination systems, OFAC Reporting, Credit Bureau reporting, financial reporting, budgeting, accounting, and reporting applications.

•Created a process that received XML files from an outside source every 5 minutes, stuffed and threaded more than 3000 nodes to a database to be normalized, aggregated to various other third party systems to include AMS 2000 financial suite, QuickBooks, Salesforce CRM, and various U.S. Government reporting agencies.

•Created various reports for all levels of management utilizing SSRS, Tableau and SAS for C level and Management teams.

•Reviewed all SQL related scripts, stored procedures, triggers, schema changes from all on and off shore resources prior deployment to production environment from on and off shore contractors. Worked with Development team on various projects as the SQL subject matter expert.

•Designed, architect, built and implemented the company’s first Data Warehouse that utilized, SSRS, Tableau and SAS servers.

Database Administrator 09/2013 to 06/2014

Southern Insurance Underwriters (CMGA) – Alpharetta, GA

•Responsible for the up keep and maintenance (system performance tuning, backups, restores, service packs, and upgrades) of MSSQL 2000/2005/2008/2008R2 servers in a Hyper-V environment.

•Planned and executed the upgrade of multiple servers from MSSQL 2000 to 2008R2.

•Migrated and consolidated several server instances to a single instance as part of a major infrastructure migration from Hyper-V to VMware.

•Maintained and refreshed all MSSQL Servers in the development environment for use by on and off shore development teams.

•Implemented a SVN repository for all development and database scripts for versioning.

•Created multiple ETL processes utilizing SSIS to allow submission Excel spreadsheets, CSV files, and other data format for import into various database servers for financial, budgeting, accounting, and reporting applications.

•Created various reports for all levels of management utilizing SSRS.

•Maintained, updated and refreshed multiple SAP Business Objects Universes utilized by all levels of the company’s management team.

•Reviewed all SQL related scripts, stored procedures, triggers, schema changes from all on and off shore resources prior deployment to production environment. Worked with Development team on various projects as the SQL subject matter expert.

•Planned and executed upgrades to various third party business critical applications to include, Finance Pro, AIM, and IVR system.

Database Administrator 08/2006 to 09/2013

Definition6 – Atlanta, GA

•Responsible for the up keep and maintenance (system performance, backups and restores) of 30 - 40 MSSQL 2005/2008 servers in a Point of Sale Enterprise structure for 25 retail locations, which are located in 12 States and 2 colocation sites. These tasks were accomplished by utilizing remote technologies like MS SQL Management Studio, Query Analyzer, RDP, FTP, and VNC, as well as travel to store and colocation sites.

•Upgraded and migrated original 8 stores from MSSQL 2000 to MSSQL 2005 remotely and during evening maintenance windows without and any downtime to the core business operations and 0 loss of data.

•Created Maintenance Plans, with email notifications (DBMail), for database backups and rebuilding of indexes.

•Created and maintained DTS and SSIS packages utilizing Visual Studio 2005/2008/2010 for data extraction and manipulation based on Client, State and Federal guidelines.

•Created complex T-SQL scripts to run ad-hoc reports, assist developers and performance tuned the Databases. Configured Jobs (SQL Server Agent) for SSIS packages and various developer and custom requirements.

•Created and maintained more than 100 SSRS Reports utilizing BIDS, MS Visual Studio 2005/2008/2010, for C and Management Level employees. Reports included: KPIs, trend reports, dashboards, general data dumps, inventory management and accounting.

•Demonstrated ability to prioritize and coordinate multiple tasks; managed diverse Systems

•Created and maintained a Disaster Recovery (DR) lab for deployment to any store location within 12 hours of a DR scenario.

•Successfully recovered 3 stores and 1 colocation site from catastrophic hardware failure on core database servers with minimum impact to store and enterprise business operations and which resulted in 0 data loss.

•Built servers and workstations from OS level including patching, MSSQL installation, custom software installation, peripheral installation and configuration for deployment to store locations.

•Worked with development team to create Stored Procedures, Triggers and Views as required for application and web development projects. As well as, created wireframes and UI design for mobile, web and desktop applications using MS Visio and Balsamiq Mockups. Created and maintained technical documentation, specifications and instructional documents for 15 supported desktop applications and mobile application for client. Utilizing SharePoint, Confluence, MS Office Word Documents, MS PowerPoint and Windows Help files. Also provided training on applications to employees and management.

•Created and maintained project management plans for system and software upgrades, application and website rollouts, and new store acquisitions and deployments.

•Managed various vendors for software and hardware purchases.

•Additional responsibilities included training new employees and team members, SharePoint (MOSS 2003/2007/2010) Administration and Help Desk support.

Professional Driver 01/2006 to 07/2006

Werner Enterprises – Omaha, NE

•Professional driver responsible for on time delivery of goods to various distributors nationwide.

•Performed safety and maintenance checks on vehicle and cargo and maintained logbook according to federal guidelines.

Police Sergeant 09/1997 to 10/2005

Duluth Police Department – Duluth, GA

•Supervised 10 -15 officers in various job functions. Insured discipline and job performance as well as created and enforced Departmental Policies and Procedures.

•Investigated various criminal activities, case management, accident reconstruction cases and created work schedules.

•Conducted training in both academy and field settings for officers and civilian personnel.

•Assigned as Division Commander for the: Municipal Court Division, Special Operations Unit, Accident Investigation Unit

•Command Unit as the Communications Specialist. Responsible for security and traffic management planning for various City special events. Conducted media and public relations duties on several serious incidents.

•Collateral duties included: IT Officer, Created and maintained the Departmental website, Network administration and network security.

•Maintained operational effectiveness and proficiency of 10 - 15 employees through team management concepts. Created and implemented work schedules. Strictly adhered to policies and procedures established by department, state, and federal authorities.

Network Engineer 01/1997 to 08/1999

Defintion6 – Atlanta, GA

•Developed and implemented complex Internet and Intranet applications on multiple platforms. Ensured network system and data availability through preventative maintenance and upgrades. Consistently met deadlines and requirements for all production work orders. Managed firewall, network monitoring and server monitoring both on- and off-site.

Education

Completed Microsoft Course 10777 ATG Learning – Atlanta, GA

•Implementing a Data Warehouse with Microsoft SQL Server 2012

Computer Forensic Investigations American Academy of Forensic Sciences - Charlotte, NC

•Intermediate and Advanced level certifications.

Associate of Applied Science: Nursing Northern Virginia Community College - Annandale, VA

Course work completed towards degree

Accomplishments and Awards

Good Conduct Medal, United States Marine Corps

•Overseas Service Ribbon

•National Defense Service Medal

•Desert Storm Veteran

•2 Police Department Purple Hearts

•GA POST Intermediate and Advanced Certifications

•Officer of the Year

•Multiple Letters of Appreciation and Departmental Accommodations

•BSA Golden Quill

Contact this candidate