Manager Sql Server
Resume:
David Wood
Lewisville, TX **057
*****@******.***
SUMMARY
More than
* ***** ** *********** *** application development experienceCOMPUTER SKILLS
Languages
Proficient in. Visual Basic 6.0, COM/DCOM,
COM+, XML, XSL, OOP. VBA, ASP, HTTP, MTS, HTML, SQL, MSMQ, ADO
Familiar with Oracle Software
Database
Microsoft SQL Server and Access
Platforms
Windows 95, 98, NT, 2000, and XPTools
Crystal
Reports, Rational Rose, ErWin, Homesite, Dreamweaver, Visual Safe SourceEXPERIENCE
PROGRAMMER ANALYST
Capital One Auto Finance
January 2003 - Present
Contractor with IBS
Wrote auto loan originations part of a
functional specification to bring subsidiary loans in house.
Wrote detail design document for the loan
originations of the project.
Using Visual Basic 6 modified the in
house funding system to accept Prime and SuperPrime loans.
Modifed MSMQ system with Visual
Basic 6 to accecpt to XML Schema and business rules for Prime and
Super Prime.
Updated SQL Server 2000 database by modifying
tables and stored procedures for new business types.
WEB DEVELOPER
Centex Home Equity Company LLC.
October 2002 - December 2002
Worked as the sole developer on a Rewrite of
a Bonus system used to pay 60% of the employees.
Developed system using n-tier approach
Wrote Com+ Objects for the Business
layer
Designed SQL database and wrote stored
procedures.
Wrote
ASP pages for the presentation layer
Working in a Source Safe environment.
PROGRAMMER ANALYST
Capital One Auto Finance
January 2002 - September 2002
Contractor with IBS
Worked team to rewrite an existing Access
97 and VB 6 application that was used to correct Loan application
missing information.
Primary responsibilities include design and
development of Visual Basic Code, SQL Server Stored Procedures and
Access 97 code. Assisted in the writing of the Functional Specification.
Wrote the Detail Design Specification to
upgrade to new business requirements.
Rewrote the Access 97 application to
incorporate new business requirement. Also made code more efficient and easier
to maintain
Updated Visual Basic 6 application to
incorporate new business requirements.
Following
standard coding practices the maintainability and efficiency of the code was
increased.
Wrote a COM object
to be called from Access 97. This object created an XML document
which was posted to MSMQ. It also generated letters in Microsoft Word
for applicants whose applications had insufficient information
PROGRAMMER
ANALYST
Digital Architects
July
2001 - November 2001
Project to rewrite Visual Basic 6
Application for Transportation industry
Rewrote application to commercial coding
standards and to give application a professional look and feel. Updated the
application so it would work with SQL server as well as Access 97
database.Worked on
CONSULTANT
ABC
Radio Networks
July
2000 - May 2001
Consultant for One Inc
Radio Broadcast Industry Sales and Planning
system rewrite converting single tier system to n-tier base. Developer on a
large project team.
Wrote User interfaces in Visual Basic 6
Developed Object models using UML
method and Rational Rose.
Wrote Middle tier objects using COM/DCOM,
COM+ methodology, which ran in MTS.
Wrote stored procedures for SQL Server 7.
Developed reports with Crystal Reports
and a VB 6 user interface.
Used Active X controls from Infragistics Data
Widgets Controls and Farpoint Spread Controls.
Assisted
in Database migration from Btrieve to SQL 7.
Deployed company wide via intranet using
ASP and HTML.
Developed entire project
with object oriented approach toward future Web deployment.
CONSULTANT
Worldwide Flight Inc
April 2000 -July 2000
Consultant for Born Inc
Rewrote the automated data integration for a
Payroll System.
Developed
Use cases utilizing UML and Rational Rose
Wrote
Presentation, Middle and Data Access tiers in Visual Basic 6 utilizing COM/DCOM.
Normalized
Existing Access database
CONSULTANT
Old
American Insurance
February 2000 -April 2000
Consultant for Born Inc
Rewrote Insurance Quote and Rating program into a n-tier VB6
application
Worked as a developer and technical architect
on a 2-person team.
Utilized object oriented approach focused
towards future web deployment.
Deployed on MTS or Resource Manager
depending on Agent equipment.
Wrote the presentation, business and data
layers in Visual Basic 6.
Used an Access Database with inline
SQL statements
Wrote reports using Active Reports
CONSULTANT
Sabre
December 1998 - February 2000
Consultant for Born Inc
Rewrite of Major Airline Aircraft Maintenance System as n-tier
Member of large project team.
Wrote Use cases, Sequence Diagrams, and
functional specifications during the project analysis phase utilizing Rational
Rose for the UML process
Participated in Joint Application Design
session with the users.
Wrote in all three layers using Visual
Basic 6 including Forms, User Controls, Com/DCom
Developed Web pages in
Wrote reports using Crystal Reports.
Developed Data Diagrams
using ErWin
TECHNICAL SUPPORT
NCH Corporation
June 1996 - December 1998
Permanent Employee
Functioned in a technical support role
Developed, wrote and implemented applications
in Visual Basic
Supported manufacturing systems through
writing programs and interfaces
Wrote and deployed reports using Crystal
Reports.
Supported software applications like Word,
Excel, Access, Business Objects.
Installed
and supported computer hardware.
Prepared test plans and data, and user
documentation for customer billing system.IT MANAGER
Hydroscience
July
1991-June 1996
Permanent Employee
Managed the IT Department.
Developed application mainly in MAGIC
with a
Btrieve
database.
Also did some development in Visual Basic
3.
PRODUCTION MANAGER
Seismic Engineering
June 1981 - July 1991
Permanent Employee
Managed a small manufacturing shop. Produced
ASW equipment and geophysical exploration equipment.EDUCATION
B.S. in Business Management, University of
Texas, Arlington, TX, 1982.
Contact this candidate