Richard W Tasker

* ****** **

Berwick, ME *****

Phone: 603-***-****

Email: ac7onj@r.postjobfree.com

Objective

I am looking is to find a challenging position where I can use my dynamic database and programming skills,

along with my dedication to customer service, to add strength and leadership to a team. I understand the

importance of data in today's business and I strive to transform this data from disparate sources into a tool

that will support and grow the business. I am looking for a position that I can make a long-term career out of.

Abilities

●SQL Server 6.5/7/2000/2005/2008/2012/2014/2016

Performance Tuning

Complex query creation

Data Analysis and Recovery

Stored Procedures / Triggers

Data Warehousing (BI/ETL/Data Marts)

Integration Services

Reporting Services

Database design and Architecture

●C# / Visual Basic.NET / ASP.NET

●MS Operations Mgr (MOM/SCOM)

●VBScript / VBA / Visual Basic 6

●Communicate Technical Information Clearly

●Customer focused

Employment History

Database / Application developer

05/2014 - 09/2017

Seacoast Outsourcing Solutions

Dover, NH

●Responsible for a full range of software development in multiple client environments. Specializing in creating solutions that are actually functional in today's complex environments using old versions of Sql Server

●Environments are SQL Server / ASP.NET with both VB.NET and C#.

●Data import/exports are built with SSIS. Reporting with SSRS

Database Developer

03/2014 - 05/2014

Newmarket International

Portsmouth, NH

●Responsible for reworking multiple stored procedures for performance enhancements.

●Responsible for reworking ETL for very large warehouse for performance.

Database / Application developer

01/2013 - 03/2014

Seacoast Outsourcing Solutions

Dover, NH

●Responsible for a full range of software development in multiple client environments. Specializing in creating solutions that are actually functional in today’s complex environments using old versions of Sql Server

●Environments are SQL Server / ASP.NET with both VB.NET and C#. Data import/exports are built with SSIS.

●Reporting with SSRS

Database / Application developer

10/2011 - 05/2012

Liberty Mutual

Portsmouth, NH

●Responsible for creating a reporting environment for users with administrative access to servers. Data was loaded in to a SQL Server 2008 database via SQL Server Integration Services from Active Directory and from a flat file extract. I created a ASP.Net front end to the data and Sql Server Reporting Services reports to present the data.

●Contract extended to build and interactive quarterly access review based on original project data. This involved creating a historical data structure, building comparison routines, and creating a new front end.

Database Developer

8/2010 – 05/2011

Loyalty Builders

Portsmouth, NH

●Responsible for reporting solution based that combines multiple Sql Server 2005 databases on separate servers to allow for fast access to data from the different parts of the application.

●Responsible for ad-hoc customer reports supporting customers & the sales process.

Database Developer

8/2009 – 08/2010

Enterasys

N. Andover, MA

●Responsible for data coming in and out of the organization using SSIS. Work to vendor specifications for inputs and outputs. Consolidate vendor data and internal application data in to a central database.

●Responsible for building data marts for different reporting systems and loading data in to reporting systems. This included building a custom C# application that loaded the data in to an Amazon cloud application called GoodData.

●Responsible for migration of older systems from SQL 2000/2005 to SQL 2008.

●Support of software licensing system where data is stored in a SQL Server database, SAP, and FlexNet.

Principal Database / Application developer

05/1993 - 02/2009

Newmarket International Inc

Portsmouth, NH

Lead developer: SalesForce.com interface project

●Development in core SalesForce.com along with APEX code, along with custom ASP.Net and BizTalk orchestrations that access SFDC via their API, and SQL Server databases

●Responsible for all aspects of support and troubleshooting the various environments including continued escalation support for our hosted offerings.

●Developed comparison routines using data sets from the different elements of our enterprise solution

Lead data center automation engineer - hosted data center environment

●Responsible for escalation support and monitoring of our hosted application in our high availability data center. The backbone of the data center is SQL Server, BizTalk Server, and IIS monitored by Microsoft Operations Manager and System Center

●Developed tools that would manipulate BizTalk to automatically process suspended instances (failures)

●Maintained the SQL Servers by building specialized maintenance plans, managing traces and correcting execution plans/query performance, and building reports to show operational health of the database

●Responsible for creating reports in MS Reporting Services and Crystal Enterprise

Lead developer: report internationalization project

●Responsible for converting 200 Crystal Reports from version 8.5 to version XI and replacing the internal reporting subsystem to support the Crystal XI

●Modified reports to support our application's new multi-currency, multi-language feature. This included the ability to display reports converted to any given currency formatted for that currency's locale without localizing reports

Lead developer: sustaining enterprise application and data warehouse

●Formed sustaining engineering team which allowed rest of the development team to focus on new software development without worrying about customer issues

●Supported both internal and external customers in regards to any aspect of existing products

●Key enhancements made during this time included data warehouse performance enhancements to bring nightly processing time from 6 hours to just over 1 hour at upper tier installations

●Developed custom reporting projects for upper tier customers

Lead developer: enterprise data warehouse project

●Designed, implemented, and brought to market, first generation SQL Server 7/2000 data warehouse integrated with existing enterprise software solution

●Developed, tuned, and maintained all aspects of warehouse database

●Developed ETL (extract, transfer, load) routines to populate the warehouse though a series of SQL statements utilizing Microsoft DTS technology

●Developed data marts using complex stored procedures

●Developed front end management tools with Active Server Pages

●Developed multi-dimensional data cubes using Cognos tools

Technical escalation support lead

●Formed high level technical escalation team in conjunction with development and support departments. At the end of the release cycle of our enterprise product, I realized that in order for our product to succeed we needed to be able to support it.

●Provided technical escalation support for all aspects of enterprise software solution and raised the technical expertise of the support organization. Support included MTS, COM, and SQL Server 6.5/7 with replication

●Acted as a liaison between support and development and as a technical contact point for major clients

●Developed and implement software hot fixes and custom utilities

Lead developer: enterprise sales force automation project

●Developed evolution of current windows hospitality software solution to an enterprise class product.

●Responsible for maintaining the "big picture" of the software project

●Developed front end interface and business logic in a proprietary 4GL (visual basic equivalent);

●Creating SQL Server stored procedures and triggers, Creating custom utilities with Visual Basic; Interfacing with the rest of the organization for internal support of the application.

Quality assurance lead

●Responsible for testing and troubleshooting of windows based hospitality software

●Created automated test scripts with Seque QA Partner

●Supported development network environment

Support analyst

●Provided customer support for dos based hospitality software.

●Provided general support for customers, Btrieve databases, and Windows NT and Novell Netware networks.

Education History

Completion Date

Issuing Institution

Location

Degree Received

Course of Study

06/1989

Noble High School

Berwick, ME

High School Diploma

General High School Curriculum

References Available on Request

Contact this candidate