Hilliard, OH *****
THOMAS J
ESTES
*******@*****.***
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