SUMMARY:

• I am a Microsoft SQL Server developer with more than 15 years’ experience using SQL Server
• (7.0 - - SQL2016, Express and LocalDB).
• Primary job responsibilities must include developing for SQL Server. Tasks should include many of the following:
• Creating new databases to support
• New requirements
• Provide your view from the data kept by one or several purchased products.
• Writing stored procedures, triggers (table and database), scalar functions, inline table functions, multi statement table functions, user defined types, both tSQL and C# CLR
• Designing normalized relational databases including
• Tables
• Indexes (clustered, non-clustered, filtered)
• Constraints (primary key, unique, foreign key, check, default)
• Computed columns
• Physical Data modeling (prefer Power Designer)
• Service Broker and asynchronous tSQL development.
• Extended Events
• Optimization and tuning tSQL queries
• Working closely with application developers
• Working in teams and independently
• Data migration (ETL)
• Database refactoring
• Synonyms,
• Views
• Sequences

TECHNICAL 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

PROFESSIONAL EXPERIENCE:

Independent Consultant

Confidential, Michigan

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

Database Engineer

Confidential, Michigan

• Dematic is a logistics company that designs, develops, builds and installs systems for distribution centers.
• Redesigned the application database installer scripts for DIQ.
• Wrote the SQL2014 installation manual for DIT.
• Developed an interface allowing SQL server to send messages to ActiveMQ using stored procedures, functions, triggers, SQLCLR procedure Service Broker and a Windows Service.
• Developed an application to migrate the results of an MS SQL query to a MONGODB database.
• 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.

Confidential

Senior Developer

• Confidential (www. Confidential .com) provides custom-fitted Internet solutions for direct selling and multi-channel retailing organization.
• 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

Consultant

• As a consultant in the advanced systems group I helped customers primarily with onsite visits exploit Confidential relational technology.
• I was also a Confidential Certified Professional and instructor for:
• Introduction to SQL an introductory SQL course
• Fast Track to Confidential an introduction to Client/Server Technology and hands on labs to demonstrate how the Confidential 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 Confidential 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