Stephen Abbott Email & Phone Number

Vancouver, Wa, Us

Vancouver, Washington, United States

Vancouver, Wa

Providing software consulting services to local companies.

Vancouver, Wa

Windows Service development. Winforms application development. SSIS Package creation and support. SQL Server Database management, stored procedure creation and support.

Vancouver, Wa

• SSRS Report development (2016/2008) for Utilities and Operations divisions.• SSIS Package development and support for daily and other scheduled operations. Package development included interfaces to exterior vendor systems (Selectron, Cybersource).• Service and Web Service development and maintenance using VB.NET.• Database administration including, but not limited to, design, implementation, tuning, development and support for SQL Server 2008 and 2016 databases.• Data mart design and implementation using SSIS and SQL Server 2016/2008.Technical Environment: SQL Server 2016/2008, SSRS 2008/2016/2018, SSIS 2016/2008, Visual Studio 2016/2012/2010/2008, Oracle 9i, T-SQL, C#, VB.NET, ASP.NET, PL/SQL, TFS 2012, JavaScript

Vancouver, Wa

• MVC application development using HTML and Angular 5.0 JS. Includes creation of application pages, data services, and database interface.• Visual Studio 2012/2015 development environment using TFS for source control.• Database design, optimization and maintenance for custom inventory tracking software.• T-SQL scripting for stored procedures and triggers on SQL Server 2012 databases.• SSRS report development and maintenance.Technical Environment: Windows 7, Windows Server 2012, SQL Server 2008/2012, Visual Studio 2008/2010/2012, SSIS/SSRS 2008/2010, TFS 2010/2012, C#, ASP.NET, Angular 5.0 JS, HTML/HTML5, JavaScript, T-SQL.

Vancouver, Wa

• Delivered 3 new and supported 5 existing ASP.NET web applications, working with the business users to define requirements and verify functionality prior to deployment.• Web application development using ASP.Net and C#, HTML 5 and CSS 3 on a Portal application for customer care. Operating in an Agile development environment participated in sprints including addition of new features, maintenance of existing functionality and integration of external systems.• WCF Service middle tier development to provide data access via LINQ and communication with other systems and services. Worked on both existing web services and participated in the design and development of new services to provide access to data to internal and externally facing applications.• Report creation using Tableau Reporting tool, including data source creation and report design and maintenance• Business Intelligence database programming and support using Microsoft SSIS and SSAS to create and support SQL stored procedures, SSIS packages and database cube support using SSAS on SQL Server 2008 servers. Decreased processing time for Business Intelligence Data Warehousing packages and procedures by over 30% through optimization of processing structure and procedures.• SQL Server scripting and SSIS Package development for large scale data conversion from old existing billing system to new existing billing system. Included analysis of existing system, data mapping to new existing schema, script and package design and development, and user testing support.• Contributed to Agile process introduction and adoption by project teams.Technical Environment: Windows 7, Windows Server 2012, SQL Server 2008/2012, Visual Studio 2008/2010/2012, SSIS/SSRS 2008/2010, SSAS 2012, TFS 2010/2012, Tableau 9, C#, ASP.NET, JavaScript, T-SQL.

Portland, Oregon Area

• Web site development work using ASP.Net and C# in Microsoft Visual Studio 2010.SSIS package development for SQL Server 2008, including stored procedure creation and modification.• Produced 10 new reports using Microsoft SQL Server Reporting Services for internal and external users.• Provided production support by resolving identified issues and promoting the resolution to the production systems.• Delivered a set of data integration applications and stored procedures used to integrate and external system with an internal Integra system more than 15% under the forecasted cost.• Gained knowledge of 5 internal Integra Telecom applications and services so to be able to provide support and to make updates and changes as required.Technical Environment: Windows 7, Windows Server 2008, SQL Server 2008/2012, Visual Studio 2008/2010, SSIS/SSRS 2008/2010, TFS 2010, C#, ASP.NET, JavaScript, HTML, T-SQL.

Vancouver, Wa

Development of custom entities, JavaScript and plug-ins on Microsoft Dynamics CRM 4.0.Designed and implemented SQL Server Integration Services to facilitate continuous transfer of data from legacy system and external data sources to the Microsoft Dynamics CRM system.Participated in development and implementation of the Software Development Life Cycle.

Portland, Oregon Area

Development of applications in C# and Java that cross the spectrum of use, including batch applications, desktop client/server applications, web services, Windows services and web based applications.Responsible for working as part of the project team to determine requirements, generate estimates, architecture and design documents.Resurrected the .NET Center of Excellence, which is responsible for advocating .NET technology within The Standard, setting standards and procedures related to .NET development, and investigating and recommending direction for advancement of .NET usage at The Standard.Developed common library used by .NET applications to interface with an IBM WebSphere Message Queue.Microsoft Team Foundation Server (TFS) and Team Build Server administrator and mentor for users of TFS and the build server.

Vancouver, Wa

Responsible for management of two project teams of 4 to 6 individuals, including work plans, schedules, project activities and customer review.Created project metrics and tracked metrics throughout project lifecycle.Manage risk assessments and mitigation plans to resolution.Responsible for client relations, communications, change orders and issue resolution pertaining to projects being managed.Managed a team of 30 SW and QA Engineers onsite at client facility in place of the Program Manager was she was not onsite.Coordinate IT activities at local development center.Coordinate Microsoft Windows Hardware Quality Logic (WHQL) certification and submission activities.

Vancouver, Washington

Provided computer consulting services to individuals and small businesses.

Henrietta, Ny

Lead Software Engineer on several projects in addition to Project Lead responsibilities. Responsible for software development on UNIX and Microsoft Windows systems using C, C++ and C#.Managed multiple project teams of up to 11 members, including work plans, schedules, project activities and customer review.Responsible for authoring technical documentation relating to the Design and Development Process including specification documentation, design documents and other user documentation.

Rochester, New York Area

Software application development in C++ and Visual Basic 6. Worked on and lead teams that developed custom applications for clients that were specific to their needs. This included a VB 6 application for a Top 5 accounting firm that was used by over 3,000 employees across the United States. The application use Microsoft SQL Server for the database backend and a VB 6 front end.Worked closely with the in-house QA team to reduce defects and the need to multiple release cycles.Prepared design documents based on customer requirements, prototype applications for customer review and comment, and other required documentation as needed.

Rochester, New York Area

Handled system development and installation for Transit Control Systems in Seoul, South Korea, Busan, South Korea, Taejon, South Korea, Shanghi, China and New York City, New York, USA.Worked on development of PLC diagnostic software running on OS/2 that communicated with proprietary GRS developed boards. Supported field installations in several location throughout the continental United States as well as in Utrecht , The Netherlands.Software development on UNIX and Microsoft Windows systems using C, C++ and C#.Authored technical documentation relating to the Design and Development Process including specification documentation, design documents and other user documentation.