Profile

User Profile

ID NETWORKS: November 1999 to Present
Senior Developer / Technical Manager / Project Manager
Project Manager:
My role as a project manager requires that I take the lead in all aspects of many large and small projects. This involves the defining
of the project, delegating work assignments, meeting mileposts, monitoring progress and making adjustments as necessary.
Technical Manager:
The technical Manager aspect of my position gives me bottom line responsibility for deciding which combination of technologies is
the best fit for large and small projects. This requires the thoughtful consideration of many factors, including: the skill set of our
current staff of programmers, the desire to enhance rapid development by reusing existing objects, the desire to take advantage of
new and improved technologies, and the need to build software frameworks that will promote good standards and result in portable
code that can be serviced by multiple programmers. Location of application logic is another of my responsibilities; determining if
company goals are best met by implementation in the presentation layer, business rules layer, or perhaps as a stored procedure or a
trigger in a database.
Senior Developer:
I am also very much a part of the software development staff, tackling the more technical and challenging programming tasks. I
specialize in the development of reusable objects that form the foundation of many software frameworks.
ID Networks highlights:
o Designed and authored an automatic software update process that ensures that every computer at each customer site is
running the same software. Placing a patch in a pre-determined location on a server at the home office triggers the
process for all participating clients. Any new COM components will be registered as needed, regardless of the security
privileges of the interactive user. This is achieved by utilizing the CreateProcessWithLogonW API and an encrypted set
of credentials stored on the server. Web services, SMTP e-mail, out of process exes, ActiveX Dlls and .NET services
were all custom developed to handle the various aspects for this solution.
o Designed and authored an n-Tier Client/Server application framework that includes a database agnostic presentation
layer, separate COM components that encapsulate the business rules, and a Database Gateway component that maintains
legacy B-Trieve Files, Access MDBs, Microsoft SQL Server, Oracle or any ODBC compliant backend.
o Designed and authored a COM role based security framework. This programmer-friendly security engine makes it easy
for developers to integrate standard security into any .NET or COM application. It is intuitive for developers to add new
security settings as their applications evolve. It also includes a user friendly front end that allows the end user to
interactively create multiple security groups and add and remove users and privileges.
o Designed and authored an automated issue tracking system for in-house use. It utilizes VBA code and the Outlook object
model to delegate and track e-mail service issues directly from the e-mail client. Developers can open their copy of the email
message to reply, enter time or add comments. Management can monitor progress and drag and drop assignments
among various resources as needed.
o Designed and authored an AVL user control that reads GPS sentences and uses MicroSoft MapPoint object model to plot
vehicle location speed and direction in real time.
o Designed and authored an application based on .NET web services that uses the above AVL control to post remote
employee GPS information in real time to a map monitoring application at the home office.
o Designed and authored a browser-based digital Line-Ups application that allows participating agencies to create digital
criminal Line Ups over the Web. A separate DCOM object was developed specifically for this application - it runs on the
Web Server and provides image and demographic data to the client browsers. This application was deployed as an
ActiveX Document to allow implementation of many features not normally found in a web application. This includes
drag and drop functionality as well as image editing capabilities like changing brightness and contrast, cropping and
changing image backgrounds.
o Designed and authored a custom screen driver that allows each customer to modify their own data entry screens by
dragging and dropping controls inside of a custom IDE.
o Designed and authored a framework that allows officers to work in a disconnected or connected fashion in their cruisers.
The M.O.S.T. (Mobile Officer Software Toolkit) engine is configurable to use S.O.A.P or MSMQ when an IP signal is
available. It can also use the Motorola RD/LAP signal if desired, or allow the software to operate in a disconnected
fashion with batch synchronization from near building wireless or hotspots.
o Designed and authored a document based review and approval engine that allows the document reviewer to interactively
open issues in a document annotation layer. The engine facilitates interactive conversation threads between the reviewer
and the document author.
David A. Zatkiewicz Page 2 of 3
o Designed and authored a Client/Server imaging application suite. This suite includes a Photo Capture application that
allows users to capture or import digital images into a searchable archive, e-mail image and demographic data from inside
the application, and quickly browse through the image archive by name, keyword or physical characteristics. A separate
Line Ups application features a full-blown image editor that allows users to crop and resize images, change brightness
and contrast and modify image backgrounds if necessary. The entire suite was built around a well-defined set of COM
interfaces, allowing for development of a separate SDK for third party applications. The SDK consists of several ActiveX
controls and a single DLL and provides complete third party access to all of the functionality built into the imaging
engine.
o Designed and authored an ActiveX toolkit currently in use by NorthPointe / JICS classification software. This SDK
consists of an ActiveX DLL providing a COM interface that allows any 3rd party software vendor to update and make
inquiries into our JMS databases directly from their applications.
o Designed and authored an application framework for 3-Tier Active Web pages. The framework is a combination of ASP,
VB Web classes, XML, JavaScript, DHTML and SQL Server. This was developed as a server side DLL that runs under
Microsoft IIS. XML that are embedded in HTML templates provides the end user the flexibility to control their own web.
Other accomplishments include:
Developed an SQL driven “Query By Example” component that is a standard part of client
applications. This tool allows end users to create add hoc queries using a drag and drop interface.
Developed an OCX that allows ID Networks programmers to add document and image scanning to
any client application.
Developed a user control that allows programmers to digitally reproduce business forms, and
optionally allow end users to input data directly into the WYSIWYG preview.
Developed a DLL that acts as a Crystal UFL (User Function Library) and expands the Crystal formula
language to include homegrown functions inside the Crystal design environment.
Created several user controls to standardize the look and feel of the various client applications.
Developed a Visual Basic Add-In that integrated directly into the programmer’s development
environment and generates all necessary run-time error trapping code for any application.
TRI-STATE BUSINESS INSTITUTE: January 2002 to 2004 Part Time Computer Instructor
Tri-State Business Institute is an accredited institution offering degrees in various computer related fields. I am a part-time member
of the Tri-State faculty, and occasionally teach an evening class. Over the past year I have instructed the following classes at Tri
State:
Oracle 8i DBA SQL and PL/SQL preparation for Oracle Certification exam 1Z0-001
SQL Server 2000 Programming - preparation for Microsoft Certification Exam 70-175
SQL Server 2000 Administration – preparation for Microsoft Certification Exam 70-228
VB 6 Distributed Applications preparation for Microsoft Certification Exam 70-229
PLANTROL SYSTEMS: August 1994 to November 1999 Visual Basic Project Manager
Plantrol Systems provides custom turnkey solutions to the Business Forms Printing Industry. Plantrol uses SCO Unix and Transoft's
U/BL language to read and write ISAM files. My first two years at Plantrol were spent writing UB/L code and familiarizing myself
with the many systems that Plantrol supported. I later designed and created the n-Tier development environment that facilitated
porting the existing UNIX based systems to a graphical Client/Server front end. Using VB5, I wrote an ActiveX DLL that wrapped
low level ODBC APIs in standard COM interfaces that could be called by any client application. I also implemented the business
rules for each application in a separate DLL suitable to run under Microsoft Transaction Server. The database gateway tier
implemented as an ActiveX DLL, and could connect to SQL Server, Access and Transoft’s proprietary data files. All of these
ActiveX components were written using VB 5.
I also took advantage of VB's extensibility object, and wrote a custom VB Add-In that effectively bound standard OCX controls
directly to the legacy data files. This is done by storing all of the necessary information in the tags of the control arrays. With this
Add-In, a VB developer can add a textbox to a form, right click while still in the VB development environment, and bind the
textbox to a particular field in a table. I also installed Source Safe on an NT Server and we are using it for revision control of the
VB code.
BOGART GRAPHICS GROUP: February 1992 to August 1994 Director of MIS
Bogart Graphics Group is a Commercial / Specialty Printer catering to a select group of clientele including Walt Disney and the Taj
Mahal Casinos. As Director of MIS my responsibilities were separated into two distinct areas: 1) The Business Computer
Information System, and 2) Electronic Prepress System.
The Business Information System centered around a Point 4 mini computer and its associated accounting software. It was my
responsibility to maintain this system and develop and implement applications that integrated with it. I developed and wrote several
systems, including a shop floor data collection / job costing system - using the IRIS Business Basic Language native to the Point 4.
Before I left Bogarts I had re-written all systems using Visual Basic 3.0 and was able to unplug the Point 4 computer for good,
replacing it with a Lantastic Network. Highlights include a Custom Cost Estimating System and Order Entry system that posted
directly to PeachTree Accounting for Windows using DDE.
David A. Zatkiewicz Page 3 of 3
Electronic PrePress improvements in computer hardware and software have made a dramatic impact on the production cycle for
printing and publishing. Part of my mission at Bogarts was to identify and train personnel to utilize the software that was
dominating the industry. I learned and trained Bogart's Art Department in: Aldus PageMaker, Aldus FreeHand, Adobe Illustrator
Quark Xpress and Adobe Photoshoppe. I also developed internal systems to service those customers submitting their work on
computer disk.
PROFESSIONAL COMMUNICATIONS, INC. May 1990 to February 1992
As the IS Manager of this Radio Common Carrier I was responsible for the efficient operation of the mini computer system which
served 22 users. I designed and wrote the software that interfaced with paging terminals in five remote sites, allowing for real time
programming of the pagers from the home office. I wrote all of the software in-house using BBx on a Unix Platform.
KUBINSKI BUSINESS MACHINES: September 1991 to February 1992 Application Programmer
As a part time application programmer I was responsible for the translation of data and program files from proprietary environments
to an SCO Unix platform running Open Systems Accounting Software. I used BBx Progression 3 running under SCO Unix to write
all utility programs needed to facilitate the translations. I used the same language to customize the Open Systems Accounting
Software as required by the client.
TRI-STATE BUSINESS INSTITUTE: December 1988 to January 1991 Computer Instructor
As a computer instructor at this accredited private business school, it was my responsibility to insure that each student was provided
with comprehensive and competent instruction for each class. Classes that I instructed include: Lotus 1-2-3, Word Perfect, Basic
Programming, COBOL Programming and DBase programming.
Programming languages, databases and object models used on a regular basis include:
VB 6
VB.NET
SQL 2000 / 2005 with T/SQL
MicroSoft Access
MSMQ
MapPoint object model
MAPI
Outlook Object Model
ADO.NET 2.0
DAO
ADO
T/SQL

Buyer Activity

Provider Activity