We provide IT Staff Augmentation Services!

Sr. Programmer/analyst Resume Profile

2.00/5 (Submit Your Rating)

Dallas, TX

Summary:

15 years of experience as an MS Access application front-end developer using VBA, DAO and ADO against both native Access and SQL Server data 10 years of experience as a SQL Server DBA using SQL Server 2000, 2005, and 2008 10 years of experience consolidating multiple, disparate data formats and sources into a common, integrated SQL Server schema.

Professional Experience

Confidential

Sr. Programmer/Analyst

  • Migrated the data from several hundred separate Access databases into a single, integrated SQL Server schema.
  • Created automated backup and data maintenance routines to protect the consolidated data using the SQL Server agent and very recently simple Powershell scripts.
  • Developed separate Access front-ends using VBA and SQL server and a variety of data access methods from DAO and linked tables to ADO and SQL Server Stored Procedures.
  • Worked with the GIS specialist to install and configure ESRI's ARCGIS application server against SQL Server 2005.
  • Worked with the GIS specialist to develop a routine to parse agency address data against the schema of the Arkansas Centerline Project in order to improve Geocoding results.
  • Developed MS Sharepoint Web Applications of both the pure and hybrid types using Sharepoint Access Services and Sharepoint List data as well as linked SQL server tables.
  • Imported data into SQL Server from a variety of ODBC-accessible data sources as well as data stripped out of different text file formats using original VBA string parsing routines and data importing functions.
  • Developed string parsing routines to convert company names and addresses from one format to another.
  • Developed a data-mining tool capable of recognizing common company name and address data despite variations in spelling, format, dbas , or aliases.

Confidential

Application Developer

  • Worked with the ownership of an Insurance agency a former CPA to develop an Access application to support day to day business operations and produce standard accounting information and financial reports.

Confidential

Desktop Application Developer

  • Hired as an apprentice programmer while learning SQL and VBA.
  • Developed applications in Access with VBA and inline SQL usually against JET, but occasionally against SQL Server.

Confidential

Desktop Application Developer

  • Developed simple desktop applications in Access with the User Interface and VBA wizards for a series of companies spun off from Gameday Apparel, Inc.

Confidential

Inventory Manager

  • Responsible for managing inventory for a clothing manufacturer and distributor.
  • Developed MS Excel spreadsheets to assist in inventory management and record keeping.

Confidential

Instructor, Dept. of Philosophy and Religious Studies

  • Taught sections of The Introduction to Philosophy as well as sections of Critical Thinking to undergraduates and co-taught several courses for the Donaghey Scholars Program.

We'd love your feedback!