David Blewett

Current

• Database Administrator at The Salvation Army

Past

• Database Analyst at National City Bank

Education

• Ball State University
• Chesterton High School

Recommended

2 people have recommended David

Connections

27 connections

Industry

Information Technology and Services

Websites

• David Blewett @ DjangoPeople
• David Blewett @ DjangoSnippets
• David Blewett @ Facebook

David Blewett’s Summary

I have five years experience designing database applications, following normalization procedures. I've re-engineered systems for National City bank to simplify reporting and data entry. I have also successfully virtualized a legacy application and retired the physical server, lowering the maintenance burden and increasing performance.

I have deployed an intranet application that utilizes Django and PostgreSQL on the server side and ExtJS on the client side. The design allows for form details to be stored in the database and built dynamically in the client on demand.

I have deployed a backup system for the entire server infrastructure at the Salvation Army Harbor Light Center. This system utilizes Bacula to centralize the data collection from multiple operating systems (such as OpenSolaris, Linux, FreeBSD and Windows Server 2003). PostgreSQL's Point In Time Recovery capability is utilized to maintain a warm standby of the database which can be activated if the master database goes down for any reason.

David Blewett’s Specialties:

SQL, Python, Javascript, HTML, CSS

David Blewett’s Experience

• Database Administrator

  The Salvation Army

  (Non-Profit; Non-Profit Organization Management industry)

  April 2006 — Present (3 years 9 months)

  ·Responsible for $2m in funding from the state of Indiana
  ·Administered server infrastructure
  ·Designed data processing logic
  
  Projects:
  ·Write Interface to SOAP Web Services
  Utilized suds, a Python SOAP library to adapt Django's ORM to save and retrieve from a SOAP server, as well as provide data validation
  
  ·Design Flexible Questionnaire Application
  Designed questionnaire definition to be completely data-driven
  Utilized a normalized database structure to allow for easy customization and retention of past formats
  Created AJAX interface using the ExtJS Javascript library
  Included ability to automate the creation of materialized views to improve OLAP performance
  
  ·Rewrite Data Processing Application
  Utilized Django, a Python web framework
  Simplified and corrected application logic
  Wrote data extraction process to pull data from a legacy database, utilizing JDBC and XML-RPC
  
  ·Design Backup Process
  Utilized Bacula, a cross-platform network backup solution
  Took advantage of PostgreSQL's Point-in-Time Recovery feature to archive saved state, enabling restoration to any point in time since the start of the cluster
  Backed up 4 servers, including Windows XP, Windows Server 2003, Linux and OpenSolaris
  Utilized technology available to the operating system to allow for a consistent backup (ZFS snapshots on OpenSolaris, Volume Shadow Copy on Windows, and LVM2 snapshots on Linux)
  Backed up approximately 150GB of data on set schedule

• Database Analyst

  National City Bank

  (Public Company; PNC; Banking industry)

  January 2004 — April 2006 (2 years 4 months)

  ·Led project to change deposit policy, with savings from fraudulent activity estimated at $2m to $4m
  ·Collaborated with team members in 3 states
  
  Projects:
  ·Design IRS Bulk TIN Match Process
  Created process to exchange data and verify customer name and Social Security Number combinations with the IRS
  Reduced analyst workload by 90%
  
  ·Design PATRIOT Act Application
  Worked on a team to design data entry and reporting system for PATRIOT Act compliance
  Led team in migration of system from Microsoft Access to Microsoft SQL Server
  
  ·Combine Database Functionality
  Combined database functionality of 5 teams
  Centralized data entry and management reporting
  Converted data format from flat file to normalized structure

David Blewett’s Education

• Ball State University

  Bachelor of Arts , Criminal Justice, Criminology, Spanish , 1997 — 2002

  Activities and Societies:

  Music

• Chesterton High School

  Honors Diploma , 1993 — 1997

Additional Information

David Blewett’s Websites:

• David Blewett @ DjangoPeople
• David Blewett @ DjangoSnippets
• David Blewett @ Facebook

David Blewett’s Groups:

IndyPy

•    Python Community
•    Linux Expert
•    Django
•    PostgreSQL Professionals
•    FreeBSD Users

David Blewett’s Honors:

Employee of the Month: July 2007
Excel Award, Efficiencies Improvement: January 2004
MVP Award, Retail Controls Division: 2003
Exceptional Service Award, Retail Controls Division: 2nd Quarter 2003

David Blewett’s Contact Settings

Interested In:

• career opportunities
• consulting offers
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch