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

Hilliard, OH *****

THOMAS J

614-***-****

ESTES

abqwq2@r.postjobfree.com

into meaningful

information that can

drive decisions, by

spotting trends and

managing by

exception.

Skills

Windows, Unix,

Linux, AIX, HP UX

MS SQL Server

2000 – 2008R2

BIDS,SSMS, SSRS,

SSIS, SSAS

Oracle DB 8i, 9i,

10g, & 11g

(Standalone and

RAC)

Overview

OEM Grid Controller,

RMAN, ASH,

Experienced database ADDM, AWR,

administrator (DBA) with a PL/SQL, SQL

passion for business intelligence. Developer, TOAD

Turning raw data

Apply SQL, PL/SQL

changes to the

Experience

database via

Enterprise change

requests.

08/2012 – Current

KForce consultant at JPMC

10/2007 – 08/2012

Columbus, OH

Honda Trading

America

Oracle DBA

Marysville, OH

Database

Administrator

Install, configure, administer and

tune Production Oracle

Databases.

Modeled a 2TB data

warehouse using

Kimball methodology

Upgrade databases from various

in SQL 2008 using

versions.

SSIS jobs to perform

the

Install CPU/PSU patches.

ETL from Oracle and

other data sources.

Monitor and respond to tickets

from OEM and Tivoli.

Migrated 500+

Crytal reports to

SSRS.

Open and manage priority SR

requests with Oracle.

Developed A/R, A/P,

Sales, and other

OLAP Cubes

allowing power user to analyze Consolidated multiple

data via SSAS backups jobs into

streamlined process

with single RMAN

catalog.

Developed executive level

dashboard widgets allowing for

management by exception

05/2007 – 10/2007

AMC Registry, Inc

Migrated 14 year old ERP

database from DB2 to Oracle 10g Columbus, OH

4 node ASM RAC.

Database

Consultant

Moved from purchased hardware

to leased hardware with 3 year

turn Allows for more frequent

Migrated MS Access

DB to SQL Server

capacity and performance 2005 via SSIS ETL

reviews and adjustments with

smaller capital impact.

Hardened SQL

Server installs to

Built failover servers in offsite pass Layer 7 /

data centers implementing 2 HIPPA audits.

warm recovery sites with Oracle

Dataguard.

Developed C#

application to

encrypt data

transmission to

Wrote failover scripts and AMC.

institutionalized semi annual

disaster recovery testing.

09/2006 – 04/2007

OPENOnline

Columbus, OH

Managed self

insured customer

Business Systems Analyst

data feeds via

Mercator MapMan

ETL jobs.

Create user and functional

requirements for conversion from

legacy systems.

Wrote 750+ Crystal

Reports maintaining

a suite of customer

quarterly reports.

Translate business requirements

to technical requirements.

Created user and

functional

Refactored data models from requirements for

legacy COBOL/DB2 systems. claim intake portion

of the custom TOPS(

Time of

Manage requirement changes via

Planning System).

change control system.

Adhere to project goals and

milestones as set out in timeline.

by project manager.

05/2000 – 08/2006

Gates McDonald

Columbus, OH

Business Systems Analyst

Develop IDD (Integral Design Documents) for customer implementations on TOPS This includes user

and functional requirements as well as test plans.

Directed claims systems upgrade from 16 bit to 32 bit version, including backend Oracle upgrade.

Tested and verified all 500+ production reports against new system 10 weeks ahead of schedule

thanks to custom VB.net

07/1995 – 05/2000

Anthem Life Insurance Company

Columbus, OH

Business Analyst

Developed PERL ETL jobs for data feeds from HP3000/HP9000, AS400 systems to new Oracle DB.

Wrote data hygienics jobs to verify year end tax data for W2 and 1099 production

Managed end of life data conversion from 7 different legacy systems as part of business continuity

and contingency planning as well as Year 2000 conversion.

Created the user and functional requirements for Anthem Life Insurance Claims System (ALICS).

Created process for automation of reinsurance, which saved the company an estimated $100k a

year in missed reimbursement.

Education

03/2000 – Current

DeVry University

B.Sc. Computer Information Systems

Senior with 9 remaining classes

Contact this candidate