Summary
I am an Information Technology professional with a track record of delivering
applications, systems and data that work for the customer, and provide a
competitive advantage by making my customers able to be responsive to their
customers’ needs. I work closely with my clients to understand their day to day
business needs and make sure my influence on their day makes the work they do
rewarding.
I enjoy an interactive development process that encourages experimentation and
change. Constant interaction, iteration and experimentation lead to a better
understanding of the opportunity and a product that is capable of changing in
response to anticipated and unanticipated changes in business processes. (Change
is normal and good.)
Business Skills
Problem solver
Ability to get things done quickly
Drive “out-of-box” thinking
Team Player
Meet demanding objectives
Recognized authority by peers
Innovator and Risk taker
Hands on shirt-sleeve approach
Simplify complex problems
Relate projects to the big picture
Application Development
Database Design and Management
Technical Skills
SQL2000, SQL2005, SQL2008
Administration, Installation, Performance management, Data
Modeling(PowerDesigner, ERWIN), Database Design, Stored Procedures, Triggers,
Functions, TSQL, Client/Server design, Replication, Full Text Search, SQL Server
7-2008 24x7 support, Backup/Recovery, ADO.NET, SSIS, BIDS, Service Broker, SSAS
C++, C#
Standard Template Library, Class Design, Generic Programming, Sockets, LDAP,
MAPI, ADSI, Novell C API, Lotus Notes C API, TCP/IP, Windows, MFC, Linux,
Macintosh, .NET, Office Automation (C++ with COM, C#, VSTO, EXEL, WORD, Outlook)
Windows
.NET (1.1, 2.0, 3.5), ADO.NET(1.1, 2.0, 3.5), Common Language Runtime (CLR), C#,
C++, WINFORMS, Office Automation, Visual Studio 6--2008, OLEDB, MFC, COM, WIN32
API, VSTO (Visual Studio Tools for Office) , ERWIN, PowerDesigner, Virtual Server
2005 R2, VISTA64, Windows Server 2000-2008
Oracle
PL/SQL,. Stored Procedures, Packages, Triggers. ADO.NET, Data Modeling, Database
Design, Full Text Search
Unigraphics NX
User function development in both C++ and C# .NET. Batch processing of NX files.
Versions NX2, NX3, NX4, NX5
Professional Accomplishments
Independent Consultant
Holland, Michigan
October 2004 - present 
> Vista Asset Management needed a way to analyze the results of various
marketing initiatives. They have a point of sale system in 30+ stores. The Dbase
files are transmitted to the corporate office daily. These Dbase files were
imported into an SQL server using DTS. I developed an SQL database to organize
the various marketing initiatives and map the data from the POS system to the
marketing initiatives. I provided a .NET application that allows them flexibility
in selecting and combining the initiatives and time periods to analyze the
results of these initiatives. This work utilized Visual Studio 2003/2005/2008, MS
SQL 2000/2005, stored procedures, functions and triggers, C#, Win Forms, DTS,
EXCEL interfaced through COM and C#, PowerDesigner, Windows 2003 Server, ELUBE. 
This began in July 2005 and is a continuing project.
> Fox Bright supports a medical claims system and one of their clients had a
database locking problem that was severely impacting processing. I used VPN to
access the SQL server and diagnose the blocking problem.(July 2006, March 2008)
> Priority Health needed a way to reduce the time it took for sales to get quote
information from underwriting. Working closely with sales and underwriting I
developed an Oracle database that contained products, packages and options along
with rules that described the many relationships between packages and options.
The database included pricing and rates for the options and the ability to keep
rates for employer groups and the multiple tiers that had to be quoted for each
employer group. I wrote a C++/MFC application that allowed sales to only select
valid combinations of options, input competitor rates and compare the PEPM (per
employee per month cost) with various selections without having to make repeated
trips to underwriting. This work utilized Visual Studio, C++, STL, MFC, Oracle,
SQL Station, ERWIN, SQL Plus. This project started in November 2005 and was
completed in February 2006.
> Manatron needed the data from some new customers converted from the customers
existing format to Manatron format. This work was done with SQL 2000 stored
procedures and functions. While there I also did some similar work converting
client data to a Manatron Oracle format. This work was done in April and May of
2005.
Imart
Senior Developer
Grand Rapids, Michigan
January 2008 -- July 2008
> imart (www.imart.com) provides custom-fitted Internet solutions for direct
selling and multi-channel retailing organization. Their VeraBradley.com site was
among the 2007 "Hot 100 Retail Web Sites
(http://www.internetretailer.com/article.asp?id=24575)
> My primary responsibility was to monitor the application and SQL server
performance for the Vera Bradley site. I used Dynamic management views and
functions to identify problem areas. I developed a click once C# application to
monitor the daily business activity to insure that orders on the site made it
through shipping in a timely manner.
> This work utilized SQL Server 2005, OPENXML, T-SQL, Visual Studio 2008, C#,
.NET 2.0, .NET 3.5, Office 2007 automation.
Synergis Technology
Technical Staff
Grand Rapids, Michigan
November, 2006 – November, 2007 
> At Synergis my responsibility was to support the engineering design groups.
Design was done with several versions of Unigraphics NX software. Support
consisted of maintaining, enhancing and developing user functions for the NX
software and interfacing the attributes of the design to other business systems.
I developed an SQL server database and software to capture design attributes and
create a bill of material for each design as it was being developed. The database
was capable of capturing in addition to the NX file attributes, documents from
the customers, meeting notes etc in a fully text searchable format. The details
of a design would be loaded directly into the purchasing system to order the
steels and components required to build the design. The database also supported
some production scheduling, while the software I built provided production with
easy access to design drawings and documents. VSTO (Visual Studio Tools for
Office) was used for reporting.
> This work utilized SQL Server, Visual Studio .NET, Visual Studio 2003, Visual
Studio 2005, C#, C++, UGS (NX2, NX3[GM toolkit], NX4, NX5), .NET 1.1, .NET 2.0,
Win32 API and Syteline, VSTO, Windows .NET Forms and controls, Power Designer.
Siemens (formerly Rapistan, currently Dematic)
Senior Database Administration, Client Server Developer
Grand Rapids, Michigan
July 2000 – September 2004
> I was responsible for SQL Server Management that provided with confidence data
availability, and fast performance. This availability and performance provided
developers with an environment that they could count on to complete projects
within deadlines. This work utilized SQL Server 7.0, SQL Server 2000, Windows NT,
Windows 2000, PowerDesigner, DTS, Tivoli.
> In addition to being the SQL Server DBA I took on a number of application
development projects.
* Developed a PC Pool Management application and database that managed a pool of
2500 PCs. This accomplishment reduced the effort to find machines at end of lease
by 50%, eliminated 99% of the effort to allocate PC costs to appropriate
departments, and reduced the manpower necessary to manage computer hardware. This
application utilized SQL Server 2000, Visual Studio 2003, C++, STL, MFC, OLEDB,
PowerDesigner, Lotus Notes C API, Novel CAPI, Active Directory, LDAP, Sockets,
COM, and EXCEL.
* Developed a corporate directory database that harvested information about
employees from Human Resources, Payroll, Novell, Lotus Notes and Active
Directory. This accomplishment allowed applications that previously had to
maintain their own copies of this data to eliminate the code associated with this
activity. It permitted new applications to be developed knowing that this
information was available and current saving development cost and maintenance
dollars. This application utilized SQL Server 2000, Visual Studio 2003, C++, STL,
MFC, OLEDB, PowerDesigner, Lotus Notes C API, Novel C API, Active Directory,
ADSI, LDAP, Sockets, COM, and EXCEL.
* Migrated data from mainframe applications to SQL Server and provided an
application that allowed clients to use this information for reporting, research
and to satisfy customer requests. This reduced the load of special reports
required from an aging mainframe and allowed fast reaction by Siemens personnel
to customer requests for information. This project exploited MS Office Automation
and produced over 300 different EXCEL spreadsheets for the clients to use. This
application utilized SQL Server 2000, Visual Studio 2003, C++, STL, MFC, OLEDB,
PowerDesigner, Active Directory, DL/I, COM, and EXCEL.
* Assisted with the SQL in porting the HR/Payroll system from ULTIPRO to People
Soft.
* Used the SAP .NET connecter to move SAP data to the SQL server.

Applied Image Technology
Senior Systems Analyst
Cascade, Michigan
December 1996 – June 2000
> I provided a Part Search Replacement application which eliminated the most
chronic complaint with the MM2 system. This improvement provided the sales staff
with unqualified customer references and the extra value to close new business.
This work utilized Borland C++, STL, Oracle, and Raima.
> I ported the MM2 Oracle product to Sybase which enabled the MM2 application to
be available to another group of customers and enabled AIT to acquire at least
one major new account. This work utilized Borland C++, Oracle and Sybase.
> I provided integration applications for MM2 (the AIT product) and Maximo
(built by somebody else). This eased the upgrade process for both products at a
major AIT customer. The customer’s not so “standard” installation of Maximo was
different at each plant. This integration used the Oracle catalog to resolve
differences and automatically account for them allowing this customer to continue
using the MM2 product without AIT having to custom build a version of the product
for each plant saving many dollars in development and maintenance costs for both
AIT and their customer. This work utilized Borland C++, STL and Oracle.
Sybase
Consultant Advanced Systems Group
Detroit, Michigan
January 1995 – December 1996
> As a consultant in the advanced systems group I helped customers primarily
with onsite visits exploit Sybase relational technology.
> I was also a Sybase Certified Professional and instructor for:
* Introduction to SQL an introductory SQL course
* Fast Track to Sybase an introduction to Client/Server Technology and hands on
labs to demonstrate how the Sybase SQL Server exploits that technology including
triggers, stored procedures and transaction management
* System and Database Administration course with hands on lab work demonstrating
how to install and manage the Sybase SQL Server
* Relational and Database Design an in depth study of relational database design
with emphasis on the normal forms and how normalization affects physical
implementation
Steelcase
Senior Systems Analyst
Grand Rapids, Michigan
September 1981 September 1994
> Designed a database to manage the life cycle of network components. Functions
included, accounting, charge back, contract management, installation,
maintenance, problem tracking and resolution, network topology, hardware
inventory, software inventory, data inventory, capacity planning, budget planning
and who uses which components. This was to be implemented with Sybase.
> Developed a corporate data model to represent data required to support
worldwide business processes.
> Developed the database to support smart placement, connection of furniture
shapes and to translate the shapes used in the specification into traditional
part numbers and order information. This was a C++ MacApp application.
> Responsible for IMS database design, performance and recovery.
> Responsible for migration from IMS 1.2->1.3->2.0 and a complete utilization of
data sharing in a CICS MRO and batch production environment.
> Changed the performance characteristics of all the databases resulting in a
significant reduction in CICS response time and allowed a major hardware upgrade
to be delayed 9 months.
> Developed LU6.2 interfaces to CICS from several environments where access to
shared data was not possible. This eliminated the need for costly hardware and
simplified system design in the CADAM macro geometry interface. (System 370
Assembler, FORTRAN)
> Designed and developed the Major Order Remote Entry (MORE) system allowing the
entry of major orders from a construction site, supporting specification of
furniture, staging of delivery and installation.
> Developed a number of CICS asynchronous processors for an internal order entry
system that enforced a number of database rules for ordering furniture.
General Motors 
Senior Systems Analyst
Grand Rapids, Michigan
March 1979 – September 1981
> Designed and implemented a system for planning and tracking the progress and
cost of plant projects eliminating the need for overtime to close the monthly
books.
> Designed and replaced a service labor reporting system reducing IS involvement
from 24 hours per month to 0.
Federal-Mogul
Manager Quality Assurance and Systems Administration
Southfield, Michigan
June 1974 – March 1979
> Responsibility for the development of methods and procedures for data
processing and project management, design reviews of application systems and
supervision of technical and clerical personnel involved in these activities.
> Designed and implemented a comprehensive marketing database for product lines
serving the automotive and industrial replacement markets. The database and
supporting programs were instrumental in reducing part count by 48% and
significantly improving profitability.
> Designed an implemented an interface to the marketing database that enabled
quick and accurate cross sections of data to be referenced and analyzed for
strategic marketing decisions.
> Designed and implemented a forecasting system for replacement parts which was
sensitive to meaningful changes in several distribution channels in domestic and
international markets.
James T. Barnes
Programmer
Detroit, Michigan
December 1972 – June 1974
> Maintained mortgage-servicing applications.
Education
Bachelor of Science, Michigan State University, East Lansing Michigan
M. Thomas Groszko
197 Timbercrest Ct.
	Holland, Michigan 49424
[Send email using form at bottom]

3/24/2009	4 of 4