Matthew C. Wood
12 Paynter Street
Bear, DE 19701
mattcwood@comcast.net
(302) 388-9057
SUMMARY IT professional with 10 years of experience in database design and administration, project development, and business intelligence solutions. Skilled in quickly mastering new technologies, software products, and situations. Experienced in complete application development including planning, design, implementation, testing, deployment, and end-user support. Enjoys finding solutions to “impossible” problems. Highly regarded by end-users for addressing problems on a non-technical level. Very strong SQL background.
EXPERIENCE Health Core
September 2001 – present
Senior Database Analyst.
Responsible for all Microsoft SQL Server 2000 servers in the Data Coordination Center (DCC). Performed all database administration tasks on these servers including design, data loading, backup, performance tuning, security management and basic server maintenance.
Created a set of tools in Data Transformation Services and SQL to scrub data from disparate sources and convert to a standard format suitable for end-user analysis.
Designed the Data Definition Plan (DDP)—a standard set of forms for analysts to complete in which to get a limited data set from the DCC databases for further analysis.
Wrote SQL, Perl, and VBScript programs to satisfy DDP and database maintenance requirements.
Applied Card Systems
December 1999 – September 2001
Data Acquisition Developer.
Responsible for data acquisition and business intelligence for Data Management department.
Evaluated and implemented software solutions for ETL (data movement), complex query and analysis, and data access/reporting.
Designed and implemented data movement solutions using Informix DataStage and SQL.
Performed ETL processes based on end-user and data model requirements.
Coordinated with off-site personnel to maintain remote servers for Data Stage, Business Objects, and SAS (via Windows NT Terminal Server).
Designed and implemented reports using Business Objects running out of a MS-SQL Server data repository.
Assisted the Database Administrator in maintaining databases on both Microsoft SQL Server 7.0 and IBM DB2.
Conducted internal SAS training classes and coordinated the deployment of the web-based version of Business Objects.
Seaboard Farms
September 1998 – November 1999
Information Specialist.
Designed, implemented, and administered databases for production data for poultry processing plants. Databases were stored using a Clarion/TopSpeed proprietary format.
Converted an MS-Access operational system for collecting and reporting production data for poultry plants.
Implemented an automated ETL interface between operational system and ABC Technologies’ Oros activity-based costing software.
Assisted in the design and implementation of cost models.
Created Oros OLAP multidimensional databases and reports for use with Cognos tools.
Implemented and administered a Citrix WinFrame terminal server for operational and cost model systems.
Designed and deployed reports on operational and cost model data.
University of Georgia College of Veterinary Medicine - Dean's Office
June 1996 – September 1998
Computer Services Specialist IV.
Designed, implemented, and administered MS-DOS and Windows-based database systems for various departmental needs. Databases were stored using a Clarion/TopSpeed proprietary format.
Maintenance and troubleshooting of hardware and software on departmental network.
Duties ranged from maintaining a homegrown accounting and budgeting package to repairing and installing PC hardware.
University of Georgia - Financial Information Systems.
March 1994 - May 1996
Programmer II/III.
Created and maintained programs on IBM Mainframe systems using SQL over DB2 databases.
Responsible for various systems requiring 24-hour support.
As primary programmer, created a full-featured database application for staff training department in NATURAL.
COMPUTERS Professional experience with:
SQL / Transact-SQL
Microsoft SQL Server 2000
Database Administration
Data warehousing and OLAP techniques
Data modelling
Windows (all versions)
Citrix and Windows Terminal Server
Perl and VBScript
SAS
Business Objects reporting tools
Data Stage ETL tools
Clarion database RAD tools
IBM DB2 and AS/400
Visual Basic
PC-based hardware
Personal/Educational expience with:
LINUX / UNIX
C / C++
Java
Delphi
HTML / Web page design
EDUCATION University of Georgia, B.S. in Computer Science, March 1994.