Development Manager and database administrator with strong systems background
and specialist in system reliability and performance turnarounds.
Server Pages (ASP) 2+ years, Active Server Pages.net (ASP.net) <1 year,
ActiveX Data Objects (ADO) 3+ years, Data Access Objects (DAO) 7+ years,
Database Administrator (DBA) 9+ years, Internet Information Services (IIS) 3+
years, Management 9+ years, Object Oriented Programming (OOP) 10+ years, Oracle
2+ years, SQL 9+ years, SQL Server 5+ years, SQR 2+ years, Transact SQL (T-SQL)
4+ years, Visual Basic 6.0 8+ years, Visual Basic for Applications (VBA) 10+
years, Visual Basic.net (VB.net) <1 year
Confidential Company Discount
furniture chain with 40 locations nationwide 2004-
of Systems Development / Database Administrator in
code base of over 250,000 lines of code that integrates several database systems
using more than 33 custom programs including an operationally critical Point Of
Sale (POS) application.
Wrote VB.net web system for ASP.net,
reducing time human resources spent in applicant tracking process.
Identified and corrected a problem
in legacy code that had gone unnoticed for two years that was causing 5% of all
transactions to be lost.
Eliminated date/time fraud in POS
by programming interface between Visual Basic and centralized ASP timekeeping
server using XML.
Administered four SQL Servers and
one IBM U/2 database server.
Wrote interfaces between ASP and
Component Object Model (COM+) objects.
Lead on project that replaced
verbal sales call-in process with automatically published, standardized
company-wide P&L style report on daily sales activity, increasing timeliness
Maintained multiple intranet
websites in ASP.
Programmed automated database
tune-up utility that virtually eliminated Access database corruption, increasing
store up time.
Added e-mail notifications and
auditing using Internet Information Services’ (IIS) Collaboration Data Objects
(CDO) SMTP in numerous nightly processes eliminating the need for costly Outlook
Planned and supervised development
of merchandise transfer and purchasing programs that automated merchandise
Created countless ad-hoc reports
Geocoded customer and store
locations for business development.
Wrote complex Transact-SQL
(T-SQL)/stored procedures with advanced features such as cursors, loops,
transactions, and case logic.
Wrote views, functions, and
triggers in Transact-SQL (T-SQL) for SQL Server 2000.
Increased efficiency of Visual
Basic and stored procedures system-wide. Several
applications realized increases in speed over 500%.
Developed new centralized WAN-based
program that reduced paperwork and time to do physical counts.
This program was so intuitive the users required no training.
This program also eliminated a tedious manual late-night file transfer
process required by the previous physical count program, freeing IT personnel
for more important duties.
Wrote and maintained automated
regression testing scripts in Rational Robot.
Reduced memory usage, size, and
other overhead in core applications that saved company from having to buy
hundreds of new computers.
Repaired several instances of
massive SQL Server database corruption.
Set up, tested, and optimized SQL
Server 2005 for ERP application.
Consolidated three intranet
services, each on its own server, into one server, reducing maintenance time and
costs using virtual web sites.
Decreased bandwidth usage of one
remote WAN application by 550% by SQL query optimization and increasing use of
Designed custom icons, graphics,
and animations for applications.
Designed, set up, and maintained
multiple SQL Servers including a clustered server.
Transferred data between remote
Access databases under tight timelines.
Maintained and managed MAS ERP
system including panel customization and complex upgrade to new version.
Managed source code through Visual
Studio Source Safe.
Created and monitored scheduled
jobs for automated processing in both SQL Server Agent and Visual Basic
Migrated complete live production
SQL Server 7.0 system to a new SQL Server 2000.
Debugged and repaired legacy code
freeing users to work on genuine auditing and loss prevention issues and
reducing Help Desk calls 85%.
Interviewed, trained, and
supervised two junior programmers on various projects.
Managed and executed projects
through the entire software development lifecycle (SDLC).
Led technical team in migration of
company’s entire systems to Storis ERP.
Planned and offered internal
training class in Microsoft Access.
Triaged bug reports and project
requests for myself and junior developers.
Handled emergencies while keeping
users updated on project timeline changes.
Led technical team on Toshiba /
Questys document management project.
Developed company’s IT policy.
Set up spam filtering on Exchange
server at no cost to company using block list services.
Back up to Help Desk including
Installed and maintained Windows
Server Update Services (WSUS), reducing deskside support time.
Identified network bottlenecks and
designed and implemented corrections.
Mitigated and repaired major virus
outbreak in stores in a few hours after days of failed attempts by network
Enhanced network security including
identifying and stopping unauthorized use of e-mail server by spammers (was an
Integra Solutions Heathcare
revenue cycle management
Basic / Crystal Reports Database Developer on extensive custom in-house system
with over 120,000 lines of code in 20 applications and more than 50 simultaneous
company $10’s of thousands through automation and process improvements.|
over 7,000 new lines of code.|
and corrected over 600 program bugs from legacy code.|
complex SQL using Data Manipulation Language (DML) and Data Definition
Language (DDL) for more programmatic control of Access databases.|
easy-to-use integrated launching program for company’s Crystal Reports.|
performance of some applications by more than 300%.|
(Health Insurance Portability and Accountability Act) HIPAA compliance
rate of 99.9% on initial testing of new projects and changes before rollout.|
many technical tasks.|
company expectations of programmer from firefighter to developer.|
time to add a new client from three weeks to four hours.|
many operations, reducing maintenance and licensing costs.|
user group meetings to discuss changes and new systems.|
systems with client systems using EDI.|
independently to transform business requirements into functional and
disk, memory, and network usage system-wide.|
stability and auditing into many systems.|
systems to improve user productivity.|
all legacy code with standard code.|
automated e-mail application using Outlook objects.|
applications to enable multi-processor ability on servers with none of my
predecessors had been able to do.|
monthly reporting time from two weeks to a few hours.|
numerous reports in Crystal Reports 7 and 9.
Company president was so impressed that samples of these reports are
now used in all sales presentations.|
Simon Marketing/Cyrk World’s
largest toy manufacturer
Systems Development Administrator
e-commerce solutions for order entry system.|
junior programmer on numerous projects.|
and maintained EDI system. Rewrote
slow EDI update process thereby increasing speed 45,000%.|
extensively in Visual Basic for Applications (VBA).|
SQL Server 7.0.|
tested new warehouse software from PSC.|
interfaces to client systems including extensive error-checking procedures.|
warehouse operations and defined and standardized terminology.|
client meetings to determine system needs.|
and supported numerous Microsoft Access reports.|
changeover to new T1 line and installed and tested new ISDN terminator.|
testing tool for Internet connection with logging providing a reliability
report on web vendor.|
many forms for simplicity of use and data entry error reduction.|
company’s shipping technology by discovery meetings with UPS and other
web order systems.|
more than 10 databases, many of which were interdependent.|
servers including extensive backup and restore procedures.|
upgrade to new UPS shipping system including extensive changes to code in
systems process flow and interfaces using Visio and BPwin.|
automated replication between two SQL Servers in two cities.|
users in interfacing with technology vendors that had little business
to and prioritized multiple work requests from the user community.|
and fixed programmatic errors in Access VBA applications.|
up data entry errors and wrote new procedures and logic to eliminate them.|
many complicated SQL procedures to change and update data.|
security on database systems.|
with high-profile clients such as Chevron, Disney, Hallmark, Kraft, and
data accidentally deleted by users using history logs.|
lead on migration to NaVision Advanced Distribution ERP.|
billion dollar strategic workforce management company
1998 - 2000
as lead developer on conversion from PeopleSoft to Ross Financials of over
$4 billion of accounts payable (AP) information. |
100+ user Access database from initial request to full adoption to track
PeopleSoft, Y2K, and weekly payroll work requests through the entire
software development lifecycle. Earned merit award and received special
commendation from peers and management for this project. |
production support and troubleshooting for PeopleSoft applications including
batch processing, reports, menus, and PeopleTools in a Unix environment.|
SQR SQL procedures from the ground up.|
Microsoft Access programs using ActiveX controls.|
and maintained heavily customized PeopleSoft Billing/AR system. |
manual Access processes in multiple databases using Visual Basic for
Access database to the control level using Visual Basic. |
panel and menu changes to PeopleSoft. |
Access front-end to monitor Oracle back-end databases, automatically sending
email and alpha pages to alert on-call personnel of system problems.|
call duties included system-wide support of PeopleSoft Financials
PeopleSoft Billing and Accounts Receivable (AR) systems including EDI. |
and recoded Access 2.0 database in conversion to Access 97 (8.0). |
Access Developer’s Toolkit (ADT) and Office Developer’s Edition (ODE) to
make run time versions (mde’s) of Access. |
with a team on development, upgrade, and conversion projects.|
proficiency in data mapping process during complex conversion and
current and future systems using Visio. |
Access databases using SPEED Ferret. |
Access front-end applications to PeopleSoft/Oracle back-end using ODBC. |
importing and exporting of Excel and text files in Access. |
extensively in Visual Basic for Applications (VBA). |
custom graphics, icons, and animations for Access applications. |
user discussions on changes and new systems.|
three-month PeopleSoft Y2K survey and coding. Worked as a team to inventory
and correct date issues in all PeopleSoft code system wide. |
adjusting insurance firm of 30 employees
1992 – 1998
/ FileMaker Pro Developer and Technical Manager
and computerized multiple offices in different cities.|
research team of five employees.|
up new office with company’s systems.|
centralized database system to record and track insurance losses and report
sales activity. |
and established database application to inventory customer items lost and
numerous applications in Visual Basic for Applications (VBA). |
clients to produce more relevant references for sales force using GIS. |
sales leads in one month using better research techniques. |
many manual tasks using FileMaker Pro and Access including sales hot sheet
to help sales manager track sales activity. |
office from LANtastic network to Windows NT 4.0. Designed, purchased,
installed, and maintained Windows NT 4.0 network. |
users who had networking and software issues. |
web strategy and company Internet site including custom graphics and