Summary

• Specific job interests:
• Database architecture and design
• Database development
• Data migration
• Database redesign
• Data modeling
• 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

• SQL7 - SQL2014
• Administration, Installation, Performance management, Data Modeling, Database Design, Stored Procedures, Triggers, Functions, TSQL, Client/Server design, Replication, Full Text Search, SQL Server 7-2012, ADO.NET, SSIS, BIDS, Service Broker, SSAS, CLR procedures, UDT
• C, C
• WIN Forms, WPF, 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, WPF, Windows Charts Dundas charts
• Windows
• .NET 1.1, 2.0, 3.5, 4.0, ADO.NET 1.1, 2.0, 3.5, Common Language Runtime CLR, C, C, WIN FORMS, WPF 3.5, Office Automation, Visual Studio 6 2012, OLEDB, ODBC, MFC, COM, WIN32 API, VSTO Visual Studio Tools for Office, ERWIN, PowerDesigner, Virtual Server 2005 R2, Windows Server 2000-2012
• Office
• Office 2000-2010, EXCEL pivot tables, power pivot, VBA, VSTO
• 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
• Mainframe IBM
• MFT, MVT, MVS, CICS, IMS, DL/I, TSO, Assembler, PL/I, COBOL, Fortran, APL, ISAM, VSAM, CMS, LU6.2.

Professional Accomplishments

• Speaker SQL Saturday Detroit, MI Speaker SQL Saturday Kalamazoo, MI.
• Speaker Southeast Michigan SQL Users Group
• Speaker West Michigan SQL Users Grou
• Developed an application to migrate the results of an MS SQL query to a MONGODB database. Dematic is a logistics company that designs, develops, builds and installs systems for distribution centers.
• Developed queries for reporting from a Jira database
• Developed queries for reporting from a QMETRY database.
• Developed an analytics data warehouse for planning and consolidation. SQL2012, SSIS2012.
• Developed SSAS cubes for planning, picking and sorting analytic reporting. SSIS2012
• Developed SQL queries for reporting from Jira and QMetry databases. SQL2008R2, MySQL.

Independent Consultant

Confidential

• Sierra Nevada Corporation 2013 winter spring, . Assisted with the development of an SQL server database to manage enterprise workflow. I wrote a script to generate triggers to manage referential integrity and enforce rules for the tables in one schema that used 'soft deletes'. Wrote a set of stored procedures to manage the CRUD for the principle tables involved with workflow management. Used the SQL Server audit facility along with EXCEL pivot tables to monitor activity in a critical database.
• I developed an SQL2012 Express database to automate labor and machine cost tracking for a West Michigan heavy duty steel products company.
• The North American division of a European biological company was using a very manual process to put together month end statements because they were provided limited access to the data and almost no tools to automate the process. I developed a process to extract data from existing reports, populate an Access database and automate some of the manual month end processing.
• Data Architect for a Proof of Concept to redesign an Employee survey system used worldwide. The existing system was a multi megabyte Oracle database, the target database was SQL2008R2. I was the lead database architect and wrote the code to extract, transform and load the new SQL server model.
• For a Midwest Consulting and Engineering firm I was able to improve SQL Server performance using DMVs and Performance monitor to identify several procedures that were causing excessive locking. I also spent 4 half days sessions with the development staff discussing SQL techniques for handling some of the performance issues they were dealing with.
• A West Michigan developer of custom Web Sites for school systems was having significant several minutes delays during high demand periods before and after school, between classes . Using performance monitor I was able to isolate three views that were causing the problem and recommend techniques to rewrite the views to eliminate the problem.
• 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.

Confidential

• 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
• 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.

Confidential

• At the time this company went out of business I was developing a system to schedule the production of die components and move them through the shop floor.
• 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.

Confidential

• 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.

Confidential

• 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.

Confidential

• 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