Harold Young II

**** ******** ****

Des Moines, IA 50322

419-***-**** (Cell) 515-***-**** (Home)

advc2s@r.postjobfree.com

EXECTUTIVE SUMMARY

Database administrator (DBA) with extensive experience designing, coding, testing and supporting SQL Server environments. Proficient in DB2, Access, MS SQL Server and Windows. DBA skills include:

MS SQL 2000

MS SQL 2005

MS SQL 2012

MS SQL 2016

VB NET

Visual Studio 2005

Visual Studio 2010

Visual Studio 2012

Visual Studio 2015

SSIS

COMPUTER KNOWLEDGE

Programming Languages: COBOL, MicroFocus COBOL, JCL, HTML, RPG III, SQL, Pascal, REXX, Quiz, & QTP

Computer Utilities: Suprtool, Comparex, SuperC, Fileaid, Team Foundation Server, and AbendAid

Operating Systems: MVS, VSE, DOS, Windows 95, Windows 98, Windows XP, Windows 7, Windows 10 and Windows NT

Databases: IMS, Image, Microsoft Access, Alpha 5, MS SQL 2000, MS SQL 2005, MS SQL 2012, and MS SQL 2016

Software: Microsoft Office, Microsoft PowerPoint, Microsoft FrontPage, QuickBooks Premier, Microsoft Visual Studio 2005, 2010 and 2012.

PROFESSIONAL EXPERIENCE

State of Iowa – DHS, Des Moines, IA ITS3-Databse Administrator Mar. 2008-June 2022

Maintain and create new jobs in COBOL, REXX, MS SQL 2005 MS SQL 2012 and MS SQL 2016.

Work with SSIS and Visual Studios 2005, 2010 and 2012.

Working on converting MS Access database to MS SQL 2016.

Created database with over 20 tables and SSIS package for keeping track of different charges to the department.

Restructured tables and SSIS packages.

Work with Team Foundation Server

Maintain Databases and Tables Using MS SQL 2005, MS SQL 2012 and MS SQL 2016

Monitor production to make sure everything ran successfully and fix any problems that occur.

Maintain about 30 different databases and data marts.

Modified SSIS packages so packages will run more efficiently.

Convert any DTX packages to SSIS.

Create Adhoc reports when asked.

Mansfield Plumbing Products, LLC, Perrysville, OH Database Administrator / EDI Coordinator Jun. 2006-Mar.2008

Maintaining MS SQL 2000 databases, stored procedures, views, DTS packages, and jobs.

Create Adhoc reports for management.

Maintained and created new EDI packages.

Work with AS400 Computer

Created new tables and maintained current tables

On Call 24/7/365

Young’s Computer Services, Galion, OH Owner Jan. 2002-Mar.2008

Responsible for entire operations of business. Maintained accounting records w/ QuickBooks Premier.

Create custom web pages for clients using HTML, JavaScript and ASP.

Assist in setting up computers for clients.

Troubleshoot computers and networks for clients.

Ryan Logistics, Inc., Marysville, OH Accountant Nov. 2005-Feb. 2006

Built Website using HTML and JavaScript for company.

Maintained accounting records for 4 companies with QuickBooks Pro.

Responsible for entering payments received from clients and factoring company.

Responsible for the printing of accounts payable checks and various reports for the President.

Assisted in the collections process.

Helped fix computer problems.

Worked with CPA firm in the auditing of the records for the different companies.

Christine’s Styling Salons, Inc., Columbus, OH Accountant Jan. 2004-Jun. 2004

Converted the accounting system from MAS-90 to QuickBooks Pro and brought payroll in-house.

Setup Point of Sale computers for salons and taught how to use the computers in the salons.

Setup a network in the corporate office.

Responsible for accounts payable/receivable, payroll, account reconciliation, and financial reports.

Responsible for maintaining the corporate and salon computers.

Cardington Yutaka Tech., Inc., Cardington, OH Production Associate Apr. 2002-Jan. 2004

Responsible for running robotic welders to build catalytic converters.

HJY Enterprises, Inc., Galion, OH Owner Jan. 1994-Nov. 2001

Responsible for the marketing.

Responsible for the bookkeeping with QuickBooks Pro and all taxes and returns.

Built, repaired, upgraded computers for clients, and taught how to use them.

Setup various computers and software for clients and created custom programs with Alpha 4 database, MS Access, and MS Excel.

Prepared tax returns for clients.

Managed a full service family style restaurant with 17 employees.

Gates McDonald and Co., Inc., Columbus, OH Programmer Analyst Apr. 1998-Sep. 2000

Maintained COBOL programs on both the IBM and HP computers.

Created new checks and balances for the daily activity runs.

Worked with Mercator to map data from one computer system to another.

Worked with Suprtool to evaluate, modify, and create files.

Worked with Quiz and QTP to create and maintain jobs on the HP.

Converted COBOL programs from the IBM to work on the HP.

Member of the Year 2000, IBM to HP, and Infrastructure programming teams.

Worked with Image, IMS, and Oracle databases.

Worked with MPE, MVS, and Panvalet operating systems.

Studied UNIX and CICS.

East of Chicago Pizza Co., Crestline, OH Assistant Manager Oct. 1994-Apr. 1998

Brought into the company in-house accounting and payroll using QuickBooks.

Responsible for the daily operations of the restaurant.

Responsible for the scheduling of drivers, creating specials for businesses and cost control.

Responsible for accounts payable, payroll, payroll taxes, payroll reports, and franchise fees.

Supervised 3-8 employees per day.

Shelby Insurance Group, Shelby, OH Programmer Feb. 1989-Dec. 1993

Maintained personal auto and worker’s compensation, COBOL rating and declaration page programs.

Maintained and created JCL jobs.

Worked with Fileaid to create and examine test and production files.

Worked with Comparex and SuperC to compare files.

Worked with Micro Focus Cobol to test changes via the PC.

Created a new statistical program to help with the creation of new rates and products.

Maintained GTAMS that were used by the rating programs.

EDUCATION

Mount Vernon Nazarene University, Columbus, Ohio

B.A., Business Administration

North Central State College, Mansfield, Ohio

A.A., Business Computer Programming, Minor: Accounting

Contact this candidate