Sql Server System
Resume:
Wallace P. Wood
Chicago - Dallas
**********@***.***
Professional Summary
Over twenty seven years experience designing, developing and maintaining Client-Server
business applications, data repositories and automated systems across a plethora of platforms,
operating systems and programming paradigms. Specialize in converting legacy systems and
mainframe operations to Windows-based client server infrastructure and applications and “hard to
understand technology projects”.
Technical Skills
Databases: MS SQL Server 6.5-2008, MS Access
Languages: Visual Basic5 - 6, C#, SQL, .NET v.2003-2005, Basic, C, RPGIII, and 360/370
Assembler
Scripting: VBScript, and DOS Batch
Operating Systems: Windows NT 4.0/2000/2003/2008/XP,7
Networks: Windows Server-Active Directory, WIN NT 4.0, Novell 3.x-5.x, Banyan Vines, and
Invisible Net 30
Application Administration Active Directory Sys. Admin., MS Great Plains/Dynamics Sys Admin.,
SAP Outlooksoft Sys. Admin., SharepointServer 2007 - 2010 Sys. Admin. MS SQL server 2003 -
2008 Sys. Admin.,
Technology Consulting History
W.P. Wood & Associates 1985-Present
Technology Management Consultant
• Developed database schema designs and Web forms for a billing problem ticket tracking and
reporting service using SQL Server 2000, ASPX in .NET 2003 IDE.
• Programmed and created database schema designs and Web forms for a HR scheduling,
time and service billing application using SQL Server 2000 and ASPX utilizing .NET
2003.
• Performed system maintenance and enhancements to data translation and the analysis
system using Windows, Paradox 4.0, MS Access 97, Oracle, and DB/2.
• Designed, coded and implemented network device management, configuration and 'system
health' monitoring using VB 6, Windows 98 and MS Access 97.
• Performed system design including a needs and process analysis, functional process
orientation and custom software design for document archiving, indexing and retrieval to
comply with federal and state Freedom of Information Act requirements using VB 5.0, MS
SQL Server 6.5.
• Maintained and enhanced a vertical market client-billing system using Paradox Windows 5 to
ensure an email policy compliance system using SQL Server 6.5.
• Implemented multiple document imaging and workflow management systems using NT 4.0,
MS SQL Server 6.5, and Lava Systems Lava 5.
• Coded and implemented Unit Analysis concerning financials and designed and implemented
a new HR and payroll system due to acquisition.
• Designed and implemented a sales force automation system on senior management
analysis, contractual compliance and billing reconciliation using Paradox for Windows.
• Performed extensive redesign and programming of shop floor control and reporting system
utilizing RDBMS Smartware II for lot & tooling management tracking and work center
scheduling.
• Managed a system conversion and Y2K compliance assurance for switched-data service
billing by redesigning from Sun OS and Informix to Win95, MS Access 97, Crystal Reports
and VB 5.
• Achieved Y2K compliance assurance for a personal asset allocation and monitoring system
with interface to payroll using Paradox Windows 7 & 8.
• Converted a medical office system from DR CBASIC to Microsoft PDS BASIC 7.1 using
BTrieve
relational database technology and programmed a medical research survey system using
Paradox DOS 3 and designed an academic lender library inventory control system.
• Provided the PC user interface to Mellon Banking systems through HLLAPI and 3270
terminal
emulation for telebanking.
• Converted a mailing list management, publication distribution and billing system from
Paradox DOS 3.5 to Paradox DOS 4 and completed the system to all specifications
contracted by other vendor
• Converted a railroad tariff publication system from RBase 3 for DOS to Paradox DOS 4.
Extended and enhanced the lithographic estimation system providing statistical reporting and
estimate document retention and management, Microsoft BASIC PDS 7.1/4.5, Paradox 3.5,
Private Industry Employment History
Global Layer LLC, Dallas, TX 2012 - Present
Telecommunications Analyst and COO
•Manage and support VOS 3000 software PBX including all regulatory, client and accounting
issues.
HomeTeam Pest Defense, Dallas, TX 2007 - 2012
Senior Systems Analyst
•Active Directory includes extensive integration with enterprise SQL Server applications to
provide single point of login via VBA and powershell scripting. Functioned as assistant to
lead in migration/consolidation of forests due to acquisition, ETL of acquisition databases to
SQL Server, Database analysis and design. System Admin MS Great Plains. System Admin
PestPac vertical market OLTP. System Admin MS Sharepoint server 2007. System Admin
and support of users on Saleforce CRM. Managed all laptops (about 75). Third tier support
on all systems. Primary database stack MS QL Server 2005 and 2008.
Baker & McKenzie, Chicago, IL
1993-1997
Senior Systems Analyst/Litigation Support Manager
• Managed and mentored a group of four junior programmers in a fast-paced legal
environment.
• Performed analysis, design, and coding of marketing and contact management system
including seminar, conference and mailings.
• Selected and integrated litigation support software with products based on Lotus Notes, SQL
Server 6.5, and various document image management software such as: JFS Litigator's
Notebook, Intellect 95, and Revelation.
• Designed, coded and implemented desktop database management software and developed
a central billing responsibility system and Co-designed and constructed RAID 5 mass storage
systems using NT 4.0 on IBM clones.
• Designed and coded optical character recognition batch processes for large document
populations using WordScan 4 and Norton Scriptmaker.
• Designed, coded, implemented and supported various practice management systems for
specific groups including Real Estate, Immigration, Intellectual Property/Information
Technology, and Compensation and Employment.
Central Admixture Pharmacy Services, Inc. Chicago, IL
1992-1993
Systems Analyst/Licensed Pharmacy Technician
• Designed and implemented an EDI interface between client hospitals and CAPS pharmacy
using BASIC PDS 7.1 and Clipper 5 that required extensive stakeholder meetings and
cooperation.
• Responsible for Novell 3.x LAN administration, office systems and procedures & vendor
relations.
• Trained staff on all data systems and local-area-network administration.
ASB/Meditest, Des Plaines, IL.
1987-1991
Senior Programmer
• Designed, installed and managed peer-to-peer LAN at multiple locationsi ncluding
communications and gateways to Unisys mainframe environment.
• Designed and coded multi-user OLTP system using RDBMS Smart 3.1. Implemented
remote order entry software for general distribution to client sites using MS PDS 7.1.
Education/Training
• Loyola University of Chicago and Northern Illinois University - attained 3.5 years as a History
Major and Minor in English Literature
• DeVry Institute of Technology –attended Six Semesters of Computer Sciences
• Computer Learning Center of Chicago (CLC)- Computer programming certificate
• Oracle Training Center of Chicago -Eight training certificates
• Lava Systems of Montreal -Two training certificates
Contact this candidate