Get documents about "Douglas Meyer
Document Sample
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
Douglas B Meyer, MCSD.Net, MCDBA
15124 Portland Avenue South Burnsville, MN 55306 job.dbmeyer@gmail.com
(612) 804-5529 (Cell)
Functional summary
Microsoft Certified consultant with current experience in mobile implementations, Intranet and Client-Server
development, GUI design, object-oriented programming, n-tier implementations, healthcare applications and
compliance interests.
Experience
2/11-6/12 IFDC www.ifdc.org
IT Specialist. Nairobi, Kenya. 1) Leading a small team from this NGO (Non-Governmental
Organization), I evaluated and selected hardware and software platforms for field data collection in
remote and device-hostile environments in South Sudan, Mozambique and Rwanda. A primary concern
was unavailability of resources (lack of power for charging the devices and weak or non-existent cellular
data connectivity IFDC_PeaceCorpsConnect, Our team quickly learned how to develop and deploy
electronic surveys using Mobenzi. 2) Evaluated working software in a chillie processing plant Equator
Kenya, Ltd) in coastal Kenya for prospective use in cassava processing facilities (DADTCO) in
Mozambique and Nigeria. The primary criterion for acceptability of the software was demonstrated lot
traceability. Both organizations process foodstuffs destined for human consumption. Traveled to The
Netherlands for technical discussions with software’s author and with the prospective user, and
facilitated closing the deal there.
Toolset: Mobenzi Researcher
1/11-2/12 HAB, Inc www.habinc.com
DesignerAnalyst/Developer. HAB, Inc approached our company with a request to develop a web-based
follow-on to their existing Windows CE-based mobile inspection module. Within one month we designed
and built a working web-based prototype that could be run on any platform that supports browsers and
has access to the Internet. After the success of the prototype, we agreed to build the complete
application for the client. The complete system, now in Beta, is web-based and all the business logic is
embedded in stored procedures and functions that are managed by the database. The system fully
supports multiple simultaneous users and login security. It runs on SSL (HTTPS). The application is a
data collection and capture product that can be run on any supported browser, including IE, Firefox,
Android, Safari, etc. The app is optimized for tablet-sized platforms like the iPad, but runs equally well
on most SmartPhones. The front end logic is concerned with presentation, navigation and essential
editing. The back end (database procedures) handles deep editing, data storage and uploads to the
host computer. The following is best viewed on a tablet or iPad: habmobile.com (login credentials
available upon request).
Toolset: LAMP stack (Linux, Apache, MySql, PHP). Actively developed in MySql and php, using
phpMyAdmin, SqlWorkbench, dbForge Sql for MySql, jQuery.Mobile
5/10-4/11 US Bank www.usbank.com
Analyst/Developer. Many small projects, all focused upon remediation of ancient Access applications
via migration to Sql Server. For one project (Loan Capital Markets), the focus was on data integrity and
consolidation of seven separate applications running on desktops in various Seattle and Minneapolis
locations into a single front-end (Access 2003) and a single consolidated Sql Server. Created a third-
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
normal data model that preserved all original data relationships but whose database now protects it
from corruption. All original functionality and reporting capabilities were either preserved or enhanced.
Numerous additional projects (for Treasury) were focused upon remediation with data security with data
security as the primary focus. This goal was attained through the use of Sql Server authentication
through user identification and association with defined roles, and locking down the Access front ends.
Toolset: Access 97 and 2003, SSMA (Sql Server Migration Assistant), Sql Server 2005, 2008
1/10-4/10 Larkin Hoffman www.larkinhoffman.com
Analyst/Developer. Added functionality and simplified usability of a record keeping application which
allowed the staff of this law firm to manage its workflow.
Toolset: Access 2003
8/08-2/09 Minnesota Department of Transportation (MnDOT) www.dot.state.mn.us
Analyst/Developer. Working with a MnDOT team, re-designed and adapted key components of that
agency's line-of-business project management system for a simplified and effective work flow.
Toolset: Centura Team Developer 3.1, Oracle 10.1, JIRA, CVS
3/08 - 7/08 Regis Corporation Edina, MN www.regiscorp.com
Software Developer Designed and developed a retail point of sale application for use at company
salons. The application is designed for rapid and accurate collection of marketing data from clients. It
returns a limited set of information to its calling program, a legacy product in VB6, through COM
interops. Demographic data is posted to the central mainframe through web services. A local database
provides automatic caching of the data when the web services are not available and automatic
resending of the data when the web services come back up.
Toolset: VB.Net 2005, MS Access
9/07 - 3/08 Verifications, Incorporated Maple Grove, MN www.verificationsinc.com
Senior Developer Analyzed enterprise business policies and implemented improved practices as stored
procedures, user-defined functions and scripts. Working with end-users, developed automated methods
using simple statistical analysis to alert operations management of missing data feeds from contracted
laboratories. Developed an automated mechanism to detect missing Chain of Custody Forms and an
automated fax generation system to identify and launch a faxed request for missing documents from
respective collection sites.
Toolset: SqlServer 2005, Transact-SQL (T-SQL), MS Access 2003, VBA
10/06 - 8/08 Cura Script, Inc Orlando, FL www.curascript.com
Software developer in a fast-moving and results-oriented traditional development environment.
CuraScript is a specialty pharmacy owned by a PBM (Express Scripts) with significant interest in
customer satisfaction through timely and accurate delivery of high-margin pharmaceuticals. Its IT
emphasis is on strategic deployment of legacy code, oriented toward tactical rewrite in Java.
Design and implementation projects:
Blue Cross-Blue Shield of Massachusetts (BCBS-MA). This contract requires extensive, regular
and exhaustive performance reporting, with significant consequences for unfulfilled
commitments. Gap analysis revealed a number of missing, required data elements. Process
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
analysis with internal user community suggested mechanisms for capturing that information
within the normal workflow. Designed and implemented necessary data capture applications,
including attendant database structures and triggers, within a proprietary task/protocol/event
model that provides real-time notification, escalation and call transfer.
SalCompliance (to meet SOX, HIPAA, internal audit requirements) phase two. Canvassed the
code base (approximately 200 independent executables), discovered and corrected errors and
omissions in the original implementation, which had occurred six months earlier. This became
the final phase and the application is now fully compliant.
Centura to Java Integration. Acting as a bridge between the old world of Centura and the new
world of Java, adopted the modified agile methods and extreme programming practices of the
Java team. Meeting in daily standups, we reviewed and reassigned newly discovered
challenges and met them on a daily basis. The initial three tasks I had been assigned to
manage in the Centura world grew into several dozen over the course of several weeks and all
were managed to make a successful release. This release included a simultaneous parallel
move to Citrix by the infrastructure team.
Functional Experience: Business analysis, requirements gathering and analysis, technical design,
software development and unit testing, change management, version control
Agile methods/extreme programming(XP) practices: pair programming, test driven development, whole
team communication, continuous integration, small releases, collective code ownership, sustainable
pace. Used Fowler's daily standups and self-organizing teams in a highly collaborative manner.
Toolset Unify, Gupta, Centura, SqlWindows Team Developer 2.1 http://www.unify.com/Products/TeamDeveloper/features.aspx
Oracle 9ihttp://en.wikipedia.org/wiki/Oracle_database
TOAD http://www.toadsoft.com/toad_oracle.htm
Visual Source Safe 6.0 http://msdn2.microsoft.com/en-us/vstudio/aa700900.aspx
Mercury Interactive, HP IT Governance http://www.mercury.com/us/products/it-governance/foundation/
Citrix http://www.citrix.com/lang/English/home.asp
ActiveData SalCompliance http://www.activedata.com/salcompliance_improves_gupta_security.shtml
Java http://java.sun.com/
6/06-10/06 General Mills, Inc. Minneapolis, MN www.generalmills.com
Developer. Designed and implemented web services and a console application to enable GMI to
outsource high-volume, public-facing email processing to a specialized vendor (ExactTarget, Inc.).
These web services are called by existing GMI web sites and each transaction is recorded in a
scheduled email database. Each transaction can generate any number of follow-up emails at scheduled
future times. At regular intervals (approximately five minutes), the database is scanned for candidate
email transmissions; emails scheduled to be sent are marshalled by a console application, configured
to the vendor's (ExactTarget, Inc) requirements, and the vendor's API is called. An audit trail of all
transmission activity is maintained in the database, and tracking information to tie into other GMI
databases is also applied. The initial phase of the application was taken from concept to production
within six weeks.
Toolset VS 2005, ASP 2.0, XML, SOAP, Windows Framework 2.0, SqlServer 2000, ExactTarget, Web
Services
Dakota Technology Group Apple Valley, MN www.dakotatechgroup.com
3/06-5/06
Developer. Developed business intelligence components for a datamart application for a financial
institution. Components included Data Transformation Services (DTS—rebranded as SSIS) packages
to validate, load, merge and retain over a half-million transaction rows per day. Additionally designed,
tested and tuned SQL Server stored procedures and functions for flexibly reducing this data volume to
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
meaningful management information. Created web services and ASP.Net web pages to support on
demand management reporting.
Toolset VS 2005, C#.Net 2.0, ASP.Net, VBA, ADO.Net, SOAP, XML, SqlServer, DTS, Web Services
9/04-3/06 StudioPlus Software Cambridge, MN www.studioplussoftware.com
Primary developer of the Enterprise version of this commercial application. The Enterprise version is
concerned with synchronization, updating and executing client site job schedules. It collects all
transactions from all client sites and updates the enterprise database with resulting data sets.
Toolset VB.Net, ADO.Net, SOAP, XML, Access 2000, SqlServer, Web Services, nAnt
4/06-6/06 Health Partners Bloomington, MN http://www.healthpartners.com/
Developer. Created customer-facing webpages that support Health Partners members to keep daily on-
line diaries of their food intake and exercise activities. Member privacy is maintained by user-selected
userids and passwords, while security is maintained by use of SHA1 encoding.
Toolset ASP.Net, VB.Net, ADO.Net, SqlServer 2000, Cryptography
5/04-9/04 MicroDynamics, Inc Minnetonka, MN http://www.microdynamics.com
Designer and developer of a Quality Assurance system used at the enterprise level. The company is
engaged in production of micro-scale printed circuit devices and requires complete and accurate data
gathering and analysis from multiple QA collection stations at two geographically separate locations.
The new software was designed by reverse engineering of several existing homegrown software tools
and creating a new design based upon a new fully normalized database. All forms were developed in
Access.
Toolset Access 2000, VBA
2/04-5/04 Austin Mutual Insurance Minneapolis, MN www.austininsurancegroup.net
Architect, designer and developer of an extranet for independent insurance agents that provides a front end for
an existing AS/400 vertical application. Acted as technical team lead for a group of five developers of various
specialties that created a framework for interactively generating custom active server pages using server side
components and Javascript.
The application is database-centric. Specifications for the presentation, positioning, sizing, presence and
behavior of all objects are defined in the Sql Server database, as well as navigation, validation and business
rules. Screen objects are instantiated in a just-in-time mode, and properties of screen objects are determined by
previous interactions in the current session. Data capture, formatting and validation occur automatically, based
upon the specifications entered into the database by the corporate database administrator.
Collected and validated data is sent to the mainframe application, encoded as XML, via Websphere MQ, where
COBOL files are then created and delivered to the vertical application. The round trip is completed when the
mainframe application returns a set of files to its MQ server, which encodes those files as XML and passes the
data to the .Net application, where the Sql Server tables for that user and session are updated and the results
are presented.
Toolset C#, ADO.Net, ASP.Net, SqlServer 2000, MQ Series/Websphere, XML, COBOL
4/03-1/04 CiteWright, Inc Minneapolis, MN www.citewright.com
Chief Technical Officer. Architect, designer and developer of the Company’s flagship product, CiteWright.
CiteWright is a product focusing upon the high school and undergraduate academic markets. It is sponsored and
actively supported by Microsoft, through the Empower program for Independent Software Vendors. See
Empower for details of the program.
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
CiteWright is poised to leverage Microsoft’s most current development tools, database and operating systems.
Currently under development, it is being written in VB.Net, using ADO.Net and SqlServer 2000/MSDE. The
primary component is implemented as an AddIn to MS Office (Word) 2000, effectively making it a part of Word
and with a zero footprint. VBA macros are used in limited areas of the application. A separate but tightly
integrated research and data gathering component is being developed for the Pocket PC platform (Tablet PC
and PDA), which also runs under Windows 2000 and later. CiteWright is a consumer of web services provided
by Google and Amazon, enabling additional direct internet research capabilities. The architecture includes a web
service provider (XML, SOAP, UDDI, etc) to support a pay-per-use marketing model (the Gillette model).
Microsoft design practices, including data access, logging and error handling are integral to the application’s
design.
CiteWright allows the user to do research in both traditional and modern modes using, for instance, actual paper
note cards or electronic analogs of those documents. All research is instantly validated upon entry into the
database and, once captured, an individual research item can be called up and used again in a different setting.
In all cases, CiteWright guarantees a perfectly formed citation and bibliography/works cited entry. Most common
documentation styles, including APA, MLA and Chicago are supported.
Toolset VB.Net, ADO.Net, ASP.Net, SqlServer 2000, MSDE Word 2000 and newer, Windows
2000/XP/Server 2003/Pocket PC, Web Services, MS Patterns and Practices
3/03-10/03 Atlantic Mutual Roanoke, VA www.atlanticmutual.com
Software Designer and Developer. Designed and implemented an embedded system for controlling the creation
and routing of printed insurance policy documents. The system provides several new GUI interface controls at
the administrative and user levels for determining which printed documents require further manual review.
Individual policy print decisions are now made by stored procedures, and cause a given document to fall into a
regular print, hold print or no print category. Documents selected for regular print are converted to Adobe pdf
format and printed. Documents slated for hold have a special routing page prepended and are sent to a special
output queue. All documents, including no print, are sent to the Filenet document management system.
Toolset Centura Tool Developer 1.5, Sql Server 7.0, Visual Source Safe 6.0, Visual Basic 6.0
5/02-3/03 Xumbrus, LLC St Paul, MN www.xumbrus.com
Chief Technical Officer. Architect, designer and developer of the Company’s flagship product, StudentWord.
StudentWord is a stand-alone product aimed at the undergraduate market. It enables its users to organize and
write papers that conform to formatting and style rules for APA, MLA and Chicago styles. StudentWord operates
Microsoft Word as an automation server and it makes many features of Word easily available to its users. It
remembers entries made for papers already written by the student and provides a powerful citation engine that
creates perfectly formatted footnotes, endnotes, bibliographies and works cited entries.
Much of the power of StudentWord comes from the Access database that is included in every installation. This
database is dynamically and automatically updated by the user’s actions. It also contains a large store of
metadata used for creating references and citations, and for guiding the user through the process of creating a
college level paper.
In Process: Currently developing a strategic migration plan for implementiion in VisualStudio.Net.
Toolset Visual Basic 6.0, Word 97/2000/2002, Access 2000, ASP, HTML, COM+, ADO 2.6,
InstallShield, eSellerate, RelevantReach, Microsoft Visual Studio.Net
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
3/01-12/01 MassMutual Retirement Systems Springfield, MA www.massmutual.com
Designer and Developer on Windows 2000 upgrade project. Various assignments within the W2K upgrade
initiative including:
1. Custom forms generation. Full rewrite of an application that generates business forms automatically
customized to include only text and figures appropriate to a specific customer. The original application had been
developed over the years using various releases of Visual Basic dating back to VB2 and it populated Word
Perfect 5.2 forms. The W2K initiative allowed an opportunity to recast the fundamental business algorithms in a
state of the art environment. All access to the database is now made through ADO 2.5. The completed VB6
application uses ActiveX to interactively drive Word 2000 and is built in three tiers to allow easy porting to the
corporate Intranet. The new application employs a rules engine that I devised. The rules engine enables a non-
technical employee to create and fully maintain mapped relationships between enterprise data on Sybase and
Word Templates. The engine obtains simple conditional, procedural rules from two Sybase tables. Selecting one
of a set of master Word Templates, it passes over all the bookmarks present on the template and replaces or
inserts data obtained from the corporate database according to the engine’s interpretation of each of the rules
applying to the respective bookmarks.
2. Enterprise application upgrade. The W2K initiative required this organization’s enterprise application to
upgrade from Centura 1.1.2 to Centura 2.0. I performed that upgrade, replacing all forms generation processing
that used OLE with ActiveX.
Toolset Visual Basic 6.0, Word 2000, Sybase 11,12, Centura 1.1.2, Centura 2.0, COM, ADO 2.5, Access
2000
11/00-2/01 Tuition Aid Data Services (TADS) St Paul, MN www.tadsweb.com
Business Analyst and Developer. TADS provides financial need evaluation services to private K-12 schools
throughout the nation. Management had embarked on a project to replace its existing enterprise applications
systems.
Late in the project I was brought in to develop a key functional component, the Task Management System
(TMS). TMS is a scheduling and task assignment tool that allows offsite workers to bid on and schedule batches
of key-entry work and check in the completed tasks.
After designing and implementing key components of TMS, I was asked to take over the core component of the
TADS system (Calculations). The Calculations object is responsible for accurately and precisely computing
recommended financial aid for each of about 30,000 households, with each set of computations referencing
several hundred data elements. Calculations was implemented as 23 stored procedures and 9 views.
Management recognized that its project was troubled, both in concept and in schedule. I was asked to lead a
team of three analysts to develop an alternate project plan. Working offsite and using selected TADS personnel
as resources, we performed a fundamental business workflow analysis, developed a new data model and
presented our findings to management for its approval
Toolset ErWin, BPWin, Visual Modeler, Visual Basic (VB) 6.0.4, ActiveX Data Objects (ADO) 2.1/2.5,
SqlServer 7.0, Access 2000
.
4/00-11/00 Business Improvement. Inc (BI) Edina, MN www.biperf.com
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
Application architect and developer. For this full-service marketing company, I converted a line-of-business
application to current Microsoft technologies. Working with subject matter experts and professional developers,
converted a set of applications originally written in VB3/DAO/SqlServer 4.x/Access 2.0/SqlAnywhere to
VB6/ADO/SqlServer 7.0. Converted all in-line SQL calls to SqlServer 7.0 stored procedures (approximately 90
new stored procedures resulted). Converted all the original DAO code to ADO by building a single command
object in a new class and routing all database access through the new class code, fully exploiting the power of
ADO and the object oriented capabilities of VB6. Using client-side ADO, implemented a consistent internal error
handling and reporting method and also developed a debugging trace mechanism. Designed the new internal
architecture to conform to DNA standards by using disconnected recordsets, although actual implementation of a
true n-tier architecture (web-enablement) will await further funding and demand from the user community.
Toolset Visual Basic (VB) 6.0.4, ActiveX Data Objects (ADO) 2.1/2.5, SqlServer 7.0
12/99-4/00 TapeMark, Inc West St Paul, MN www.tapemark.com
Client-server developer/analyst for new aplication. Designed, developed and implemented a new application for
this user in a 3-tier, RAD environment. This client has committed to the ERP solution offered by Visual
Manufacturing (VMfg) from Lilly Software Associated (LSA). VMfg partially supports the concept of dimensional
inventory, under which inventory transactions can be managed based upon a part's dimensions instead of simply
its unit of measure. This application supplemented VMfg functionality so that planners could now plan and select
individual items for further processing and implement such plans in real time.
The original design for this project called for numerous (8+) windows Closely collaborating with the designer and
his user community, I was able to reduce that number to four windows in total. Of these, most of the planners'
work can be accomplished using only one main window.
I developed the application as a 3-tier implementation. I called upon the Windows API as necessary to handle
special needs.
Toolset Microsoft tools, products and technologies included Visual Basic 6.0, ADO 2.1, RDO, Centura
SqlBase 7.5, Centura Tool Developer 1.5. Other technologies included Lilly Software Associates'
Visual Manufacturing. www.lillysoftware.com
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
8/99-12/99 LifeTime Fitness, Inc Eden Prairie, MN www.lifetimefitness.com
Intranet Developer and Business Analyst for a new Paperless Contract system. Beginning with a mockup n-tier
prototype originally created by a LifeTime Fitness (LTF) IT manager, I took over development of this Microsoft-
centric Intranet application. I provided extensive direction to a junior programmer who transferred the User
st
Interface (1 -tier) from a VB-based client-server setting to a web-based ASP/HTML/DHTML environment. I
nd
added numerous validation rules to the Business Objects (2 -tier) and I created new classes for new objects. I
rd
also added additonal Data Persistence Objects (3 -tier), using both UDT’s and disconnected ADO record sets
for communication between tiers. I made extensive modifications to the structure of the prototype SqlServer 7.0
database, providing additional normalization and created tables and columns for newly discovered business
properties and attributes. I also designed and built stored procedures, triggers and foreign keys to provide final
th
validation, operational functionality and referential integrity for the target database (4 -tier). The entire
architecture was organized for deployment under MTS.
In order to support interactive checking account and credit card account number capture, I developed an ActiveX
component using VB 6.0 which communicated directly with the Magstripe/MICR reader’s own API. This
component resides on the ASP page. Similarly, I employed an OCX from an electronic signature capture and
encryption tool (Topaz) on the ASP page to provide a legally irrefutable printable contract. I developed additional
ActiveX components to be used in the UI as data validation devices.
I consulted with all levels of corporate and operating management to determine or clarify the business rules to be
employed by this high-profile application, and made live presentations of the product to upper management as
development progressed. Comments, requests and requirements from these meetings were then integrated into
the product as necessary.
Toolset Microsoft tools, products and technologies included Visual Basic 6.0, ASP 2.0, ActiveX, DCOM,
SQL Server 7.0, IIS, Visual Interdev and MS-Office. Other technologies included MagTek
Magstripe and MICR readers and Topaz electronic signature capture and encryption tools
.
2/99-8/99 The Doctors' Company Napa, CA www.thedoctors.com
Developer and Data Analyst. Made modifications to Windows into Property and Casualty (WPC). The client
offers medical malpractice insurance to physicians in each of the fifty states. WPC is its core enterprise
management system. WPC is charged with managing all policies, claims and billing. This product, written in
SqlWindows, had been originally designed for the property and casualty market, and was heavily modified to
support the medical malpractice business. A number of corrections to those modifications needed to be made,
and I was asked to make those necessary fixes. Additional features also needed to be added, and I also
performed that function. A number of data errors resulted from original programming errors which had not been
caught, and I made many direct changes to the live database using PL/SQL and SQL*Plus. I also recommended
improvements to the WPC database by adding foreign keys and triggers to improve its referential integrity.
Toolset Windows into Property and Casulty (WPC), SqlWindows 5.0.3, Oracle 7.3, SQL*Plus, PL/SQL
10/98-2/99 Carlson Companies Plymouth, MN www.carlson.com
Y2K QA Analyst. As a member of a 30-member team composed entirely of consultants, performed compliance
testing and certification for remediated code written in a variety of toolsets including C, Visual Basic,
PowerBuilder and mainframe COBOL. Databases. Trained in and used Mercury's WinRunner test manager
Toolset WinRunner
.
6/98-10/98 DeZurik, Inc Sartell, MN www.dezurik.com
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
DeZurik, a manufacturer of large valves for process manufacturers and municipalities, was engaged in
implementing a BaaN IV ERP system.The BaaN Order Entry system is incapable of entering and pricing orders
for items which have no manufacturing history.As Primary Developer, I worked with MIS and Customer Service
representatives to design and develop an Order Entry/Order Review system as an interactive front-end process
to BaaN. That system receives orders from manufacturer's reps in the field. It then converts the raw order data
into standard order, pricing and shipping information understood by BaaN. The process also involves creating
working bills of material and routings.This front-end system used Access 97 as its data store, which carried both
reference data and validated, captured transactions. The system periodically collected the captured transactions,
reformatted them to BaaN import specifications, and marked them as processed. Upon deployment, an Oracle
7.3 database was substituted for the Access database.
In related work for the same company, converted the business rules contained in its order quoting and pricing
system from an Excel database to ActiveX component for use in the order validation and entry system.
Toolset VB 5.0, Excel97/VBA, COM, ActiveX, SourceSafe 5.0, BaaN IV
3/98-6/98 Graco, Inc Minneapolis, MN www.graco.com
Graco uses a Sales Force Automation product (Sales Track from Aurum, a Baan company). Graco had already
made extensive modifications to this product, yet they needed to simplify the source code and make the user
interface more readily understandable. I was able to conceive of that new interface, convince IS management of
its value and provide technical leadership to a team consisting of myself and two other professionals. The design
and implementation of that SFA product has now migrated from a complex 40+ window, many-layered MDI
interface to a single window, two-panel design modeled on the Win95 Explorer. Our new implementation has
been embraced by the sales force user community, who agree that the design is intuitive, easy to understand
and simple to navigate. It also runs much faster and the size of the executable has been reduced from about 14
MB to less that 3 MB
Toolset SqlWindows 5.0.3, Oracle 7.3, SqlBase 6.1.2, InstallShield Express 2.02
.
8/97-2/98 U.S.Satellite Broadcasting, Inc St Paul, MN www.directv.com
(USSB)
This value-added satellite entertainment provider (purchased by DirecTV in 1999) had two mission critical
applications, as well as numerous (>15) additional applications designed for reporting and direct data
manipulation. Was sole developer of client-side applications for this company. Maintained and upgraded most of
these applications and wrote several new applications for special data collection, reporting and synchronization
with Lotus Notes. Wrote a data bridge that collected transactions from a partner company's AS/400 DB2 system
in Texas and generated component transactions for update of the Data Warehouse. USSB operates two Oracle
7.3 databases that reside, respectively, on Windows NT and Unix servers. Performed reporting, data
maintenance and extraction against both databases using PL/SQL, with some exposure to Business Objects.
This engagement was a full-time consulting assignment.
Toolset SqlWindows 5.0.2, Centura 1.1.1, Oracle PL/SQL, Lotus Notes 3.X API, Business Objects
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
6/97-12/97 McCormick & Co., Inc Hunt Valley, MD www.mccormick.com
McCormick uses Quantum from DataMyte (a Rockwell company) to capture SPC measurements at its food and
spice bottling plant; the application resides on an Oracle 7.3 database. Developed a comprehensive set of
reports for the operational managers which reduces daily report monitoring time from over two hours to twenty
minutes. Used PL/SQL extensively in developing the dynamic SQL for the application. This was a part-time
engagement performed off-site.
Toolset SqlWindows 5.0.3, Centura 1.1.1, PL/SQL
4/97-11/97 Thomson Consumer Electronics Marion, IN www.rca.com
(TCE)
Designed, developed and implemented an Oracle 7.3 data warehouse solution using PL/SQL scripts. TCE uses
Quantum from DataMyte (a Rockwell company) to capture Statistical Process Control measurements at its
picture tube manufacturing facility. The client's end user base wished easier access to their highly normalized
data and suggested denormalizing that data onto a single, wide table. Designed the table (approx 150 columns)
and developed a set of update scripts, implemented as stored procedures designed to be run from either a
trigger or explicit execution from an external action. Also developed stored procedures to preiodically purge stale
data from the denormalized table. This was a part-time engagement performed off-site following a site visit to
define requirements.
Toolset Oracle 7.3, PL/SQL
4/97-7/97 Banta ISG Eden Prairie, MN www.banta.com
Project Lead-Software Development. Designed custom inventory and order management software to interface
with an existing corporate inventory and order management system residing on an AS/400. Evaluated and
selected development toolset. Mentored team of two developers in design of manufacturing systems. Supervised
data modeling and database construction.
Toolset PowerBuilder 5.0, Sybase 10, ErWin 2.x.
6/95-5/97 Prairie Development, Inc Bloomington, MN www.prairiedev.com
One of two primary developers of a commercial product (EmpACT) which manages all front office operations for
temporary and permanent placement organizations. Extended native functionality of tool through extensive use
of direct calls to the Windows API. Developed numerous new classes to control object behavior and
implemented them in the proprietary class library. Created stored procedures to assure data integrity, and also to
move intensive database activity to the server.
Toolset SqlWindows 5.0, SqlServer 6.5, Visual Basic 4.0, Crystal Reports 3.0, Visual C++; also ODBC,
OLE/Word 95
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
1/95-5/95 Various Clients Twin Cities, MN
Performed operations and programming support to clients using a Funds Tracking System, and provided added
functionality (additional tracking and reports) for a client using a commercial product to manage advertising
media placements.
Toolset SqlWindows 5.0, SqlBase 5.2, ERwin/ERX 2.0, Access 2.0
8/94-12/94 Phoenix International Orlando, FL www.london-bridge.com
As a member of a 15-person design/programming/QA team, developed Credit Bureau Reporting component of
the Loan Processing module for a commercial software product used by the community banking industry.
Implemented core functionality as stored procedures.
Toolset SqlWindows 5.0, Sybase 10, TransactSQL
3/94-8/94 Best Buy Company, Inc Eden Prairie, MN www.bestbuy.com
Primary developer and mentor for applications development staff new to the Client/Server environment.
Produced a corporate inventory management system to track fixed assets and expendable inventory by store
location, corporate department or employee. Includes logging of all transactions, a planned general ledger
interface and a service module to monitor service requests and resolution for all managed equipment at both
item and model levels. Wrote service request and resolution reports.
Toolset: SqlWindows 4.0, Visual Basic 3.0, Crystal Reports, SQL Base 5.1
5/93-2/94 St Jude Medical, Inc St Paul, MN www.sjm.com
Worked with Clinical Marketing Manager and staff to create an application called the Sales Resource Manager
(SRM). SRM is deployed upon about 60 of the company's notebook computers and is used to give the sales
professional authoritative bibliographic references, accurate measurements and statistics, graphical
representation of the company's product (artificial heart valves), competitive intelligence and just-in-time
document printing. It provides an opportunity for Sales Management to create uniform presentations with an
easy to manage database of presentation materials and collateral.
Toolset SqlWindows 4.0, various imaging libraries including ImageMan and InsideOut
12/92-4/93 Premier One, Inc Bloomington, MN www.worldtrak.com
Acted in a technology-transfer role while completing the development of this company's Waste Tracking
application. Trained several new employees in use of the toolset.
Toolset SqlWindows 3.2, SQL Base 5.x
At any time in the future, to download the most current version of this resume, enter this tiny URL in your browser:
tinyurl.com/dbm0822 version: 6/5/2012 6:18:47 PM
7/72-12/92 Other engagements
During my career I have participated both as a leader and team member in a number of software development
ventures leading to successful commercial products
Fourth Shift Manufacturing (MRP), Inventory and Order Management
National Car Rental Licensee Back Office System
Rorke Data Imaging and Workflow system
Premier One Waste Management Tracking system
Phoenix International Community Banking System
:
Other toolsets
I have developed applications using numerous additional tools, including
COBOL HP-3000, Honeywell, Burroughs, IBM 370x
FORTRAN CDC 3300, Univac 1106
DBMS Image (HP-3000), IMS, MDBS III (MS-DOS), xBase
Assemblers MS-DOS, IBM 370x
Education
1977 Pepperdine University Los Angeles, CA www.bschool.pepperdine.edu
Master of Business Administration (MBA) with major in Management
1971 Mankato State University Mankato, MN www.mankato.msus.edu
Bachelor of Science with major in Computer Science
Certifications
2003 Microsoft Corporation Redmond, WA www.microsoft.com
Microsoft Certified Application Developer (MCAD)
Microsoft Certified Software Developer .Net (MCSD.Net)
Microsoft Certified Data Base Administrator (MCDBA)
1985 American Production and Inventory Alexandria, VA www.apics.org
Control Society (APICS)
Certified in Production and Inventory Control (CPIM)
1985 Institute for Certification of Des Plaines, IL www.iccp.org
Computer Professionals (ICCP)
Certificate in Data Processing (CDP)
