Project Management Sql Server

Christopher Lewis

Summary

Project leader and software developer with over twenty years of experience.

My strengths include analysis, strategic planning, requirements gathering, functional specifications and software development.

16+ years of MS SQL SERVER 2014/2012/2008 R2/2005/2000 (database design, stored procedures, Triggers, Views).

4+ years of Microsoft Business Intelligence Services.

Very good experience with T-SQL in Developing & implementing Tables, Indexes, Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Dynamic SQL and DBCC Commands.

Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, and Reviewing query Plans, Index Tuning Wizard, Reports and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Working with MS SQL Server in all versions in developing databases for both OLTP & OLAP database solutions.

Conduct data analysis, data mapping, and dimensional modeling, and collaborate with all members of the various teams.

Visual Studio.NET development – Web Services, Web pages, Desk Top Applications

10+ years SQL Server Reporting Services (SSRS)

4 years’ experience SQL Sever Analytics Services (SSAS)

4+ years of C / C++.

6+ years of XML and SOAP development

Excellent written and verbal communications skills.

Skills:

Project Management: Full cycle project management: conception, requirement analysis, scheduling, functional specifications, design, development, test, and deployment.

Software: Visual Studio.Net (VB, C#, ASP), C++, XML, MFC, ADO, ActiveX, ASP, HTML, Crystal Reports, MTS

Database: MS SQL/Server 2014; 2012; 2008; 2005; 7; 6.5, MS Access 97; 2000, Informix

Operating Systems: Windows95/98, NT, 2000, WIN API

Development Methodologies / Productivity Tools: OOD / OOP, Rational Rose, MS SourceSafe, Excel, MS Project

Education/ Accreditation:

University of Alberta - Edmonton, Alta.

Camosun College- Victoria, BC

SQL/Server 7.0 Administration and Development

Professional Experience:

Fred Meyer

Sales Associate Aug. 2016 to present

Part-time furniture sales associate.

Boeing Jul. 2004 to 2015

Lead/Sr Database Engineer

I developed a Report environment for My Boeing Portal using SSRS and SSAS. The Report Environment consisted of SQL Servers replicated from the OLTP servers.

Created and implemented Databases, tables, views, Constraints, stored procedures, functions as per the business requirement.

Generated T-SQL scripts for data retrieval, manipulation & validation and involved in performance tuning of T-SQL Queries & Stored Procedures by analyzing query plans, blocking involved, identifying missing indexes etc.

Increased the Stored Procedure performance by performance monitoring, tuning and optimizing indexes.

Developed several Reporting Services reports with high complexity queries on an as required basis.

Was also responsible for developing a Reporting Services training overview for presentation to the Portal Administrators and developers.

Advanced troubleshooting of issues relating to Microsoft SQL databases

Developed database for numerous smaller applications.

Microsoft Aug.2003 to Apr.2004

Role: Test Analyst/Developer

Automated test development and verification of detection for a new MS Java Virtual Machine Dependency Diagnostic Tool.

Development was in Visual Basic and VC#. Automated test development.

This position required extensive Java and J++ programming to develop code samples to verify that the JVM Diagnostic tool functioned correctly.

Microsoft Mar.2002 to Aug.2003

Role: Analyst/Developer

Was responsible for enhancement development of TOMCAT, an application used by Support Engineers to respond to Newsgroup postings.

Was concurrently part of a team doing development for a new desktop application to replace TOMCAT.

The project required Object Oriented Design and Programming. Software design and development was in Visual Studio.Net (C# and VB) and SQL2000.

The new development employed XML-based Web Services, Microsoft Transaction Server, SOAP, ADO.NET and T-SQL. The sustaining work involved development in C++ and transact SQL

Snohomish PUD Sep.2001 to Dec.2001

Set up an enterprise wide Version control system (MS Visual SourceSafe) to support multiple departments using a wide variety of development tools.

Wrote a version control process for enterprise to follow including Version Control Administration.

SDC, Inc. Information Systems Analyst Mar.2001 to Aug.2001

Contract Engineer

Add Truancy data download capability to Troubled Youth Services of King County court system. Allow courts to import truancy data from school district maintained databases to county court system, manage cases and to publish reports.

I was responsible for estimates, design, development and release of the project.

Development work was in Visual Basic using ADO for interface to a SQL 7.0 database and an Informix database.

The project required extensive stored procedures to coordinate data in disparate databases. I created reports using Crystal Reports.

Contact this candidate