Database Developer

STEVEN ROWLAND

**** ***** *** ****, *********, IN 47992 H: 765-***-****) M: 765-***-****) *************@*****.*** SUMMARY

Talents include solid object-oriented, Structured, MVC and SaaS coding practices, strong problem-solving skills, ability to learn quickly and driven to mentor others and to seek out and solve the toughest challenges involving application development and data issues in business today.

Proficient in C#, VB.Net, and ASP.Net.

25 years of experience developing

o Web applications

o Windows Forms Applications

o WPF Applications

o Web Services

o Other WCF Services

o Custom Distributed Data Access Technology

20 years of experience

o Developing and debugging SQL queries, views, stored procedures o Logical and physical database design using SSMS, SSIS, SSRS, and SSAS.

2 Years of Azure based databases and application development

1 year of Machine Learning experience using Microsoft Machine Learning as well as most of the current methods using R and as well as algorithms custom designed by me to fit client needs

25 years of experience application development team management and leadership

Exceptional TSQL coding, debugging, and performance tuning capabilities.

Proficient in modern application modeling tools and techniques ERD, ORM, UML

Use Cases, Unit Testing

Ability to work independently or in a team with a passion for producing high quality work during every project or assignment.

Thrives in challenges and learning new tools and paradigms.

Design, implementation, integration and testing of all classes in n-tier applications.

Software, and particularly database design, is my PASSION; it is what makes me “sing” (as a former manager called it)

When I accept a position, or a contract

O I throw everything that I have into it.

O I take extreme pride in the quality, timeliness, and accuracy of all work that I do. O I am not a “clock watcher”

I am punctual though, and I do ARRIVE at whatever the business’s set arrival time is, and am in the office when everyone else is throughout the day; it’s my departure time at the end of the day that I pay less attention to (again, if it’s allowed)

But unless it conflicts with business rules, I do quickly tend to be in the last group of people to leave the office at night.

Some days I come in and heads down work, without ever even looking at the clock, and end up leaving when I have solved the problem at hand, or am at a logical stopping point, even if it’s not the traditional “quitting time” for the day

(again, assuming that this flows with the way that the business prefers).

I’ve found that this makes my next morning MUCH more efficient and allows me to hit the ground running.

I am aware that some companies prefer that employees arrive and leave around the same time as each other every day, and in those cases, I pay more attention to the time throughout the day so that I am at a stopping point when it is time to leave

I tend put in a lot of hours because I LOVE what I do; NOT because I have trouble getting tasks done on time. If working late doesn’t conflict with my family responsibilities or business attendance rules, I like to leave work after I’ve done what I can to be ready for the next business day. But I am very flexible about this; I CAN come and go at set times without issue.

I have a burning desire to be “THE GUY” that leadership can turn to and count on to tackle/solve/and communicate THE toughest problems that the business faces

I cannot overstress those last 5 points.

EXPERIENCE

2019 – Present Design and development of application/data solutions as a freelance contractor o Also took to needed time off to be a stay at home father for my three daughters, particularly during Spring and summer breaks o Was involved in a major automobile accident that required that I take considerable time off as well o Currently building an eCommerce web site for a personal business 2019 – 2019 Roeing Corporation (Contract Position 1/2019 – 11/2019)

Designed and implemented several total redesigns of current databases/applications to Azure based solutions o Move and make the necessary changes to the Web Applications and Windows Forms “Smart Clients”. Using

Azure Web Apps

Logic Apps

Asynchronous Azure “Serverless” Functions

HTML 5 / MVC Browser front ends running in multiple Azure Pools o Completely redesign existing databases to be Azure compliant as well as meet the changed User specifications. Implemented in

Azure SQL Database

SQL Server hosted inside of VPC’s hosted in Azure Pools

Developed several methods to migrate and physically move the current data into the new data model

Several hundred GB of data, some of which going back to the late 1990’s/early 00’s 2017 – 2018 Database/Solution Developer

CG Visions

Lafayette, IN

o Implement several new methods of importing new client data resulting in significant increases in speed as well as accuracy o For example:

One import took generally a day or so if it was a large client

The import was broken down into several thousand “little” T-SQL / C# methods

Was not manageable, if it did not work the first time, the process needed restarted

Re-designed this with a total T-SQL based solution (utilizing modern SQL Server functionality)

When tested on the largest client, the current method took over 30 hours before it eventually failed

Then new design ran from start to finish in under 2 and a half seconds

The data was 100% complete and accurate

This led to re-designing 20-30 existing imports

The total client data import after these changes went from over a day for most clients to under 5-6 minutes for all existing customers as well as a made-up client that essentially had all existing clients’ data to test a worst-case scenario

o Mentored existing developers to help elevate the T-SQL skillset of the entire team to a more confident, current, and aware of what kind of development can and should be in the database and what should not o Implemented Purchase Order system for the current construction management application

Designed with integrating with clients’ existing accounting/ERP systems by providing class interfaces that could be implemented by an application extension that moved data from our app to their app. 2015 – 2017 Design and development of application/data solutions as a freelance contractor o Also took to needed time off to be a stay at home father for my three daughters, particularly during Spring and summer breaks 2015 – 2015 Database Developer

Roeing Corporation, Inc.

Lafayette, IN

Design, maintenance, and development of maintenance/migration solutions utilizing T-SQL and SSIS.

Design, develop, and maintain several hundred reports using SQL Server Reporting Service, as well as training/mentoring of development staff on SSRS.

Primary developer on several long-term projects that included creating custom applications to enhance clients’ business processes. The continued success of this project resulted in reliable revenue as these clients requested multiple enhancement projects including ongoing support contracts.

Responsible for all aspects of database development, supporting around 5 developers, and several databases. This included the complete data model, both logical and physical, and creation of stored procedures, as well as query tuning, as the databases grew. I was also responsible for all our in-house databases and SQL Servers, including query tuning for 3rd party systems, and maintenance of the SQL Server instances, such as backup plans, index rebuilds, etc... 2013– 2015 Senior Database Developer

TCC Software Solutions

Indianapolis, IN

Original and contributing member of TCC’s internal SQL Server Standards Council that was formed in January of 2014 with the high- level objective to

Establish standards for all facets of data design, storage, and retrieval that can be clearly documented and justified by best practices while providing TCC with databases that perform at the highest level of service.

Improve and Maintain Current Databases using SQL Server 2005, 2008, and 2012.

Develop SSIS packages for data migration.

Analyze existing database objects to ensure top performance.

Perform code reviews of database code with developers prior to integration into the database.

Developed migration plan for upgrading existing SQL 2005 databases to SQL Server 2012.

Performed testing of modifications of the system (Unit Testing, System Testing, and Regression Testing).

Performed back-end testing using SQL queries, SQL Profiler, and the Database Engine Tuning Advisor. 2013 – 2013 Director of Data Administration and Development / Sr. Application Architect Confirm Delivery, Inc.

Lafayette, IN

Primary initial responsibility was to troubleshoot and remedy the continuous locking issues that were occurring in their existing SQL Server 2005 databases.

o These problems were SEVERELY adversely affecting their day to operations/revenue

Problems were virtually constant during the business day. o Performed back-end testing.

Custom SQL queries.

SQL Profiler.

Database Engine Tuning Advisor.

o Developed data warehouse that captured performance measures of the current databases.

This aggregated data helped assist in identifying potential opportunities for improvement. o Performed testing of identified and proposed modifications of the system.

Unit Testing

System Testing

Regression Testing

o Analyzed defects and suggested possible improvements. o Analyze existing database objects to ensure top performance. o Implemented changes on live databases.

Was able to identify and eliminate every locking/blocking issue, as well as several additional performance degradation contributors and objects that were very likely to begin causing new problems as the data grew (approximately 100 to 200 GB/day).

Improve and maintain current databases using SQL Server 2005. o Designed, developed, implemented and tested MS SQL Server stored procedures, queries, views, and user defined functions.

Perform code reviews of database code with developers prior to integration into the database. o Started implementing policy and process to relieve application developers of needing to also develop their own database objects.

As was with Navion, my employment was very short (roughly 60 days), due to financial issues within CDI. o Closed the development department and termination of entire development staff. 2013 – 2013 Senior Database Developer/Application developer Navion Healthcare Solutions

Indianapolis, IN

Primary responsibilities included

o Learning the existing Healthcare Registry submission software. o Assisting in the development of the system to replace the existing system.

Navion’s main goal was to sell this new system to other similar business, not just use in house.

Work with existing consultants to define and implement BizTalk services to move external data into the “new” system from multiple various 3rd party sources.

Define and implement a solution to migrate the existing data from the SIR (Scientific Information Retrieval) databases into the new dynamic SQL Server 2008R2 databases.

Due to corporate cutbacks from Navion’s parent company (St. Vincent Medical Group, dictated by their parent company, Ascension Healthcare Inc.), my employment lasted roughly 90 days. 2009 – 2013 Lead Application and Database Developer Roeing Corporation, Inc.

Lafayette, IN

Responsible for the overall management of project development from requirements gathering, business analysis and system architecture to T-SQL development and implementation of Logical and Physical database models, and application coding. Responsible for the daily maintenance of the applications’ SQL Server databases including several SSIS packages and BizTalk components for 3rd party data integration.

Also responsible for the creation of web and data services as well as the supporting data structures and stored procedures in SQL Server to support application programming.

Mentored, and assisted junior to senior-level developers in completing their tasks, as well as the creation of developer tasks aligned with the production goals of each sprint cycle.

1999 – 2009 Senior Application and Database Developer Roeing Corporation, Inc.

Lafayette, IN

Primary T-SQL developer on several long-term projects that included creating custom applications to enhance clients’ business processes. The success of this project resulted in continued revenue as these clients requested multiple enhancement projects including ongoing support contracts.

Responsible for all aspects of database development, supporting around 9 developers, and dozens of databases. This included the complete data model, both logical and physical, and creation of stored procedures (requiring consistent interaction with application designers), as well as query tuning, as the databases grew.

Responsible for all Roeing’s in house databases and SQL Servers, including query tuning for 3rd party systems, design and enforcement of efficient query plans, and maintenance of the SQL Server instances, such as backup plans, index rebuilds, log shipping etc... EDUCATION

Computer Science

8/1990 – 5/1991

Purdue University

West Lafayette, IN

Computer Programming Technology

8/1992 – 5/1994

Purdue University

West Lafayette, IN

CERTIFICATIONS

Microsoft Certified Technology:

o Solutions Developer (MCSD)

o Application Developer (MCAD)

o Database Administrator (MCDBA)

o Professional Developer (MCPD)

o IT Professional (MCTITP)

Microsoft Certified Professional: MCP

TECHNICAL SKILLS

Databases

o Microsoft SQL Server 7, 2000 -2019

o Azure SQL Database

o Microsoft Access

o Microsoft FoxPro

o MySQL

o PostgreSQL

o Oracle (minor experience)

ETL/Data Warehouse/BI

o SSIS

o SSRS

o SSAS

o Crystal Reports

Languages/Technologies

o T-SQL

o VB.NET

o C#

o ASP.NET

o JavaScript

o AJAX

o VBScript

o XML

o LINQ (to SQL, XML, Objects, and Datasets)

o SQL (General/ANSI)

o DAX

o MDX

o R

Development Tools

o Microsoft Visual Studio 2003 – 2012

o SSMS

o SSDT

o R Studio

Source Control and Tools

o Microsoft Team Foundation Server

o Microsoft Source Safe

o Subversion

Very Strong Microsoft Office skills

o Advanced knowledge and usage of Excel, in particular

Strong understanding of “Set Based Programming” and its effectiveness versus “Application Oriented Programming” (OO, Procedural/Structured) for database development / Queries

Application Platforms

o Microsoft Windows

o Web

o Web Services

o Windows Mobile

Utilize Business Intelligence to provide insight to sales teams and upper level management, as well as proactive SQL Server maintenance.

Probabilistic/Statistical data analysis for small to very large datasets (structured and unstructured); using SSAS, SSIS, SSRS, Excel (with and without data mining Add-Ins), Power BI (and PBI Desktop), Power Pivot, Power View, PerformancePoint, Azure Machine Learning, and Amazon Web Services (minimal).

Contact this candidate