Post Job Free

Resume

Sign in

Sales Sql Server

Location:
Hollywood, FL
Posted:
March 06, 2017

Contact this candidate

Resume:

**** ** ***** ****** *******, Florida *****

954-***-**** 954-***-****

acy5mb@r.postjobfree.com

visionary technology professional

Goal oriented Professional with 15+ years of progressive expertise and a comprehensive background as a solutions-oriented IT Professional. Proven success in designing, implementing and integrating cost-effective, high performance technical solutions to meet challenging business needs. Kevin Lockerby

S o f t wa r e E n g i n e e r

qualification highlights

15+ .Net experience with Enterprise-Level Applications. Experience working with .Net framework since its introduction in 2001. Extensive experience developing object-oriented desktop and web applications with complex architectures. Full Stack Developer. Equally capable of front-end, back-end, database and desktop development.

UI/UX Design. Extended experience building pixel perfect front end designs. Experience with HTML5, CSS3 UI/UX design and development, responsive design. Strong design capabilities and graphic skills. Past experience as a graphic designer. Front-end Development. Over 10 years experience incorporating best practices for javascript development including working with modern frameworks, i.e. jQuery, prototyp, ext js, bootstrap. Extensive experience with Ajax with javascript libraries as well as the native XmlHttpRequest.

Back-end Development. 15+ years experience with C#, VB.Net. Extensive hands-on experience in emerging .Net technologies; LINQ, Generics, ADO.Net, Entity Framework, Visual Studio Extensibility and more.

Database Development. Strong SQL Server development skills including T-SQL, user-defined functions, common-table-expressions, triggers, and reporting. Web Development and Design. Highly experienced in all facets of web development and design and various .Net architectures including Webforms, MVC, razor and others. Strong design capabilities and graphic skills. Past experience as a graphic designer. Web Services and API Development. Developing service-oriented architectures and web services in a production environment with both REST and SOAP using WCF, Web API, and web services .

Multithreading and Concurrency. Have created low-level multithreaded applications as well as using BackgroundWorker libraries, Task-Parallel Library as well as asynchronous controllers in Web API environment.

C / C++/MFC/Win32 Experience. Low-level experience in C/C++ windows development with both MFC and Wind32. Have worked with COM and COM interfaces with managed code via COM Interop with C# and VB.Net.

Architecture and Design Patterns. Developed several applications utilizing client-server infrastructure, n-tier applications and MVC architecture. Familiar with most widely used design patterns such as factory, singleton, decorator, proxy and observer patterns. Development of Business Logic/Analysis. Diversified background in both technical development and business (executive management positions, MBA), excel at development of enterprise applications by performing business

Strong Written and Oral Communicator. Strong technical writer experience in drafting requirements, functional specifications, scope-of-work, software documentation. Previous business experience in public speaking.

Project Management. Well versed in the software development life cycle. Over five years working in Scrum/Agile environments with previous background in waterfall methodology.

Net Framework

Visual Studio 2015

Asp.Net / MVC 5

Web API, WCF (REST, SOAP)

SQL Server 2014 / SSMS

C, C#, C++, VB.Net

Javascript ECMAScript 6 / jQuery

HTML 5 / CSS3 / Bootstrap

Visual Studio Extensibility

Team Foundation Server

LINQ / LINQ to SQL / LINQ to Datasets

Fiddler / Postman / Dynatrace

Nuget Package Manager

Redgate Reflector

Various 3rd Party Components

(Telerik, DevExpress, Kendo

Jetbrains Resharper 2015

Nuget Package Manage

Visio 2014

JIRA

LINQPad

technology skills

Kevin Lockerby

API Middleware

Sales Lead Processor

Sales Census Module

Project Highlights

Created a database message queue monitoring application that processed changes to entity objects and communicated through RESTful API’s to facilitate data synchronization between the company and its vendors.

A SQL Server database employing Service Broker and Query Notifications provides queue based messaging to a middleware application that processed a message queue and then utilized HttpClient to communicate with 3rd parties via RESTFul API’s to synchronize data between various business modules i.e. quoting, ordering, incident management, provisioning and billing. All entity models in the application were dynamic objects created at runtime from entity mapping tables in the database. This allowed the application to adapt to ever changing model properties without the need to modify code and recompile. The application contained a robust HTTP Request/Response This project was an MVC application that allowed marketing managers to process sales leads that were manually collected as opposed to those that were automatically processed from various marketing landing pages. MVC with a razor view engine and jQuery were used to create a single-page application (SPA). The interface provided the user with the ability to upload a spreadsheet with model data.

After client and server-side validation that application retrieved model properties from a SQL Server database and returned both the spreadsheet and database object properties asynchronously to the UI where it presented the user with the ability to map spreadsheet properties to database properties via a duel-tree, drag-and-drop interface. The application with attempt to provide default mapping for matching fields.

Developed WCF web services and back-end class libraries for new sales module. Developed data contract and service contract libraries, data access libraries that retrieved prospect related data from both SQL Server and Oracle database. Wrote complex queries for Oracle database used by ADO.Net data access classes. The application received marketing lead information from the lead generation application in JSON format. Application parsed JSON logging, global exception handling, logging and email notifications and utilized OWIN authentication.

The heart of the solution consists of two main components. First is a SQL Server database which contains the entity objects and a collection of queue-related tables containing the information needed to notify the necessary partner applications. The database employs SQL Service Broker providing asynchronous queuing and messaging functionality allowing an application to detect table record changes saving us from continuously re-querying the database to get new values.

The second component is the Monitoring application which hooks into the SQL Service broker and receives event-driven notification when changes are made to identified tables through the SqlDependency and SqlNotificationRequest classes which allows an application to perform large-scale batch processing using parallel processing and the ability to detect changes on a database table. Every change will trigger a notification message containing values for updated, inserted or deleted records. After confirmation, the application would process a small representative sample to a 3rd party lead processing company. HttpClient was used to process a sample of 10 leads to validate the data since lead processing is an expensive proposition. Results were analyzed and emailed to authorized approval managers via role-based security functionality built-in to the program. The generated email provided a link to a landing page that displayed the full results and a button to process the remainder of the leads.

Lead processing is a lengthy, intensive process. Requirements dictated that it was undesirable for the users UI to be unresponsive during this thread-blocking process.

Hangfire is an open-source library that allows background tasks to execute outside of the request processing pipeline in a reliable way. Method invocation are performed in a background thread. It could take 10 hours or more for processing of approximately 5,000 leads. After completion, the results were posted on a corporate intranet site and emailed to the appropriate managers. data and mapped to business layer classes and database fields. It also provided error and exception data by utilizing ELMAH. Complete api logging information by logging all HttpRequest and HttpResponse data in SQL Server database. Utilized Fiddler and Postman chrome as an Http development tool.

2 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017 Kevin Lockerby

Project Highlights (Cont.)

Driver Safety CRM

MS Dynamics Front End

Repair Management Back office

A new customer reporting CRM application was needed to replace the existing webforms application due to poor performance and a clunk user interface. In addition, it was necessary to migrate and federate the database which was poorly designed. The database supported the application supported the application as well as the call center which, although only represented approximately 15% of the total usage, place over 80% of the load. Additionally the database had never been archived in over 15 years, was poorly indexed and in some cases even lacked unique identifiers. The new application was developed in MVC 5 with Telerik MVC components. The application consisted of a user-configurable dashboard, call center reports, driver performance reporting, telematics, motor vehicle reports, training, and driver performance The objective of this project was to create a web-based front end for a MS Dynamics ERP system which was used both internally by this multi-division organization and their customers. The reason for this project was 1) to provide ubiquitous access and the desire to private-label the user interface for their customers. This was achieved by employing a single-page application (SPA) architecture in which all (virtual) pages were build dynamically by combining data from the database, and content from a custom client-side template framework which employed the concept of themes. Themes allow for unmatched customization that can be achieved beyond that which can be obtained by merely swapping out a style sheet. Themes, as defined in this project are a combination of a style sheet and a client-side template or skin. The skin determines the layout and the style determines the colors and formatting of the elements in the skin.

Upon receiving the incoming HttpRequest, a custom HttpModule intercepted the request and provided SSO Authentication (active directory credentials for employees, forms authentication for The goal of this project was to improve efficiency and reduce costs of the repair department for this supply-chain logistics provider. Automation of the repair process represents tremendous cost savings and efficiency gains. This project provided reporting information, the ability to generate sales orders in MS Dynamics, performance metrics and a complex receiving process manager for the elaborate incoming receiving process.

This application was developed in Asp.Net Webforms, jQuery and jQuery UI libraries. A multi-tier architecture consisted of a rich scorecards.

The application employed role-based security so that customer’s management hierarchy could view reporting information for which they had authorization, with parent managers being able to view all data from their subordinate managers. Due to the poor design of the legacy database, customer groups lacked unique identifiers, relying on the group names for uniqueness. The main challenge of the application was to remap customer group structures and required the creation of a drag-and-drop hierarchical group remapping controls to remap groups, locations, and users enforcing constraints imposed by business rules engine. This necessitated migrating customers one at a time and necessitated the application to be able to accommodate two database systems due to the time required to migrate the more than 3,000 customers.

external users) and obtained the user apps, user groups, user roles that and placed in the HttpContext property. Next the request was re-routed to the only physical page, index.aspx where it would get the page info, application template, section template, page template, module template, and control template based on information from the parsed url and populate with content from the database or cache.

Since the organization is a multi-divisional company, it was desired to have all development efforts across divisions to utilize a common framework. Such was the case for the dynamically created SPA architecture created for this project. In addition, since all virtual pages are created dynamically, the database contained all of the structure that would normally be contained in the file structure of a conventional application, such as applications, sections, sub-sections, articles in which content is displayed. The visual studio extensibility framework was used to create custom project and item templates and wizards that would automatically generate visual studio projects and add the file structure to the database that would contain the content. presentation layer, business logic layer and data access tier. This was all built on top an enterprise level business object framework that handled all of the repetitive tasks of creating business objects, CRUD operations, dirty object tracking, business rules engine and more.

The reporting module provided information on Shipped items, open items, order history and customers repair related information. Performance information tracked and provided statistical data for all parts in the receiving process and consisted of 1)Turnaround Time Analysis, 2) On Time Analysis, and 3) Daily Repair Metrics.

The major efficiency gains for this project were in the incoming 3 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017 Kevin Lockerby

Project Highlights (Cont.)

receiving process module, an Ajax-based wizard for an extremely complex incoming parts receiving process. Although this process had tremendous variability, human interaction for the highly variable permutations were minimized by the rules- based decision engine. One noteworthy feature of this module was the implementation of web-based scanning component necessary for warehouse personnel to scan incoming purchase order documentation. This was achieved using An ActiveX Twain Scanning API modified to work in a web application. Database persistence was achieved via web-service calls to the MS Dynamics applications. The UI provided constant information and feedback to the user through the AX Communication Console. It tracked a part as it moved through the process, tracking its location, status changes, events fired

from the MS Dynamic Web Service

calls and more.

Reservation System Migration

4 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017 In support of the overall goal of integrating three applications under one umbrella the team had to:

Draft requirements and specifications.

Create Scrum User Stories, Work Items

Develop TFS reporting and administrative functionality

Create Html Mockups and Wireframes for every page

Convert Business Logic Layer to MVC Model layer

ORM mapping of database with MS Entity Framework. The online reservation system used by Carnival Cruise Lines consisted of three autonomous projects created by three separate development teams, with three separate styles, using three different development frameworks. and three separate architectures.

The online system was not used to book cruises, but rather the ancillary up sale items. The three components of the reservation system are:

Shore Excursions

Spa Treatments

Travel

if the user wanted to make reservations for more than one item, they had to exit one application and launch another. Booked Guest was an integration project that was launched by the company and commissioned a new development team consisting of established in-house developers and newly recruited contractors. This development team was labeled a “Tiger Team”, and sequestered in its own workspace and with its own resources. For the first time, Scrum would be the methodology used. Booked Guest was under the corporate microscope and this experiment was viewed as a pilot project that, if successful would be the cookie-cutter development framework for all future projects. The team chose to employ a message-centric Service Oriented Architecture built around MVC II, which is Microsoft’s implemen tation of Model-View-Controller (Although some sections were built using the code-behind model). WCF was used to communicate with the legacy database held on the corporate mainframe. JQuery was used as the client-side scripting language and C# was used for the server-side. Visual Studio Team Foundation Server (TFS) was used for both source control as well as project management. Microsoft Project was also used to allocate development costs to work centers. A Scrum reporting tool provided by Rally Corp. was used to for scrum related project tracking.

Kevin Lockerby

During this period I worked as an independent contractor working on three the following three projects:

Telecommunication Middleware (WCS). Created API Middleware application to provide data synchronization amongst different vendors. Application used SQL Broker and .Net Query Notifications to monitor changes to database entity tables and Web API and HttpClient to communicate to and from vendors.

Dental Practice Website (www.drlindh.com). Created a public facing website for a Plantain dental practice. Converted wordpress Helped create sales lead management API using .Net MVC and Web API architecture. This application served as a sales lead processing engine that received input data from various sales/ marketing landing pages which captured user information. The application required a background processing solution to handle intensive, long-running background tasks by using background threads in a reliable way.

Created a web-based application that received sales lead information data by allowing sales personnel to upload sales data contained from a spreadsheet and map spreadsheet columns to database fields through a drag-and-drop field mapping. Created custom, strongly-typed, data bound html helper components Migrated legacy customer portal application which provides reporting, data importing, form viewing and administration in products and service offering which are: 1) How’s My Driving Call Center, 2) GPS based Telematics, 3) Motor Vehicle Reporting and 4) Training.

Responsible for all application development including frontend, server-side application and database. Application was developed in .Net 4.5 in Visual Studio 2013 MVC, HTML 5 and SQL Server 2012. Third party controls from Telerik Asp.Net MVC Controls Toolkit were used for all component development.

rebuild the customer facing website (www.driversalert.com). Initially done in asp.net, final version was a wordpress template but with a hybrid asp.net subdomain for the 200+ training courses. site from a template provided by the client. Unique features in- clude 1) a new patient form which had to be processed by email- ing data to the client since they lacked a server-side processor and 2) integration of real-time reviews through DemandForce API. Men’s Healthcare CMS (rmmcenter.com). Wrote a .pdf pro- cessing project that integrated with their existing CMS. Used iTextSharp library to create a set of classes that would process lab results and populate pdf versions, merge documents, store in the database and send as attachments to clients.

and extension methods for MVC Razor view engine. Created a data access layer utilizing table-valued parameters to reduce server-round trips by sending approximately 5,000 sales leads to database server in a single request.

Developed WCF web services and back-end class libraries for new sales module. Developed data contract and service contract libraries necessary for WCF service interfaces to interact with AngularJS front-end. Developed data access libraries that retrieved prospect related data from both SQL Server and Oracle database. Worked with Team Foundation Server for source control in a complex multi-team, multi-user environment.

This was necessary because the training courses were required to interface with our SQL Server database.

The application employed state-of-the-art performance enhancements including AJAX, callbacks, and dynamically generated user controls. LINQ To SQL was used for Database-ORM mapping as well as LINQ Queries. Standard LINQ to Objects with Lambda expressions were employed for dynamic data queries. Employment History

MAY2016 MAR

APR

2017

2016

AVX

Independent Contractor

Miramar, Florida

DEC2015

ADP

Contract Developer

Kendall, Florida

NOV2013 OCT2015

Driver’s Alert

Lead Software Architect

Deerfi eld Beach, Florida

5 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017 Kevin Lockerby

Contracted to develop feature and performance enhancements as well as bug fixes to their two flagship POS web applications, POS Planner and POS Ordering. POS Planner is a data-driven, point-of- sale planning application. Marketing personnel use this application to create marketing programs, projects and point-of-sale systems for the companies 44 brands and multi-tier distributors. POS Ordering is used by field reps. The field reps use this application to order point-of-sale displays, packaging, manage inventory and marketing communication logistics.

POS Planner was written in C# and POS Ordering in VB.Net. Both Brought in to fill a new position whose purpose was to develop web-based solutions that would automate manual or inefficient processes for this Managing General Agent(MGA) in the insurance industry .The company used a 3rd party application

(AIM by Vertafore), for the tasks of tracking submissions, quotes, endorsements, etc. unique to the insurance industry. I was then tasked to automate the inspection system. Whenever there is a new insurance policy, an inspection must be performed of the physical address. The solution would flag all new policies entered every day (average of 200 – 300) and display in the UI. After selecting a policy, the program would display related policies Main area of responsibility was to create web-based front end applications for back-end Microsoft Dynamics (Axapta) ERP systems, for internal and customer applications for this multi- division corporation. Developed customizable client and vendor portals that allowed them to review open orders, order history, view inventory levels, request return material authorizations

(RMA), and drop-shipment of parts. Also allowed users to setup email alerts, view statistical data such as turnaround time (TAT) and cross-reference data in chart formats.

Developed customized framework that allowed for all web applications to customize look-and-feel without modifying the underlying codebase (using client-side templates and regular expressions). This was necessitated by Business Development which wanted to customize front-end based on customers design specifications.

applications were developed to run on .net framework 3.5 and Visual Studio 2010 relying heavily on Developers Express 3rd party components. Sql Server 2008 R2 was used for the database. Performance enhancements mostly revolved around optimization of Developers Express ASPx GridView control and associated Sql Server stored procedures. Several Feature enhancements were added such as data-filtering, user-customizable grouping, and bulk editing. In addition, admin section enhancements including bulk project item re-assignments, user management and role-based security.

which might require inspection, list all related locations, additional insureds, and other rule-based properties required by the carrier. It would then list all relevant coverage's for that type of policy. Finally, that application would use a series of hierarchical rules to select the inspection company and create an xml file representing the order. All orders were submitted during off hours via a sql job. An administrative section allowed the department manager to view productivity documenting every inspection created. It would report production information on each inspection company and relevant information on the carriers and the insurance agents. Developed Web based framework for parent company that allowed them to control the look and design of all web-based applications developed by five divisions as well as customers. Architecture for this framework utilized custom HTTP modules, HTTP handlers and URL rerouting to a single asp.net page which dynamically generated all content and data (which was persisted in a SQL Server database).

Created completely new repair management application for supply-chain functionality. This centered around a rules-based decision engine that minimized or eliminated human interaction for highly variable permutations based scenarios. Tracked and provided statistical data for all parts in the receiving, quality, stocking, pick-pack-ship and shipping areas of the supply-chain process for customers and vendors.

Employment History (Cont.)

Coral Gables, Florida

NOV2012 AUG2013

Bacardi USA

Contract Developer

AUG2011 SEP 2012

ATC Aerospace

Senior Web Developer

Pompano Beach, Florida

NOV2010 JUN 2011

Bass Underwriters

Senior Web Developer

Sunrise, Florida

6 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017 Kevin Lockerby

Employment History (Cont.)

Engaged for an eight month project to work as a member of a scrum team commissioned to integrate multiple modules of their reservation system under one unified application. The reservation system was previously developed by separate development teams and was not cohesive. The project named,“MyRes” was created in Asp.Net MVC II.WCF was used to communicate with the legacy database held on the corporate mainframe.

Created a reusable promotion code business rule engine for their Served as Senior Programmer for the IT Department’s Web Development Group. Responsible for development and maintenance of the Corporate Intranet and all web applications that service over 800 domestic and international facilities. Developed new multi-layer Enterprise Framework which served as the underlying infrastructure for all web applications. Framework consisted of the following layers: 1) Business Logic, 2) Data Access, 3) Web UI, 4) Html Parser/Base Page, 5) Web Controls 6) Content Management, and 7) Client-side object-model. Business logic layer abstracted various business-enterprise functionality such as dirty object tracking, multi-level undo, rule- based services, and data connection interfaces.

Client-side layer consists of object-oriented, AJAX-driven custom JavaScript framework which provided UI, Http, Event-management, base object extensions, CSS Selector and CRUD (create, read, update, delete) functionality.

Created extensive custom control infrastructure including abstract and base classes as well as interfaces and concrete controls and ecommerce shopping car. It allowed the marketing department to create discount codes and various parameters for which the promotion was valid. Application allowed administrators to enter business rules for which the promotion code was valid. For example a promotion code must have eight characters, must be issued between applicable dates, must be effective for a particular ship at a particular port for some specific demographic group. components. In addition, provided complete design-time support including custom designers, type-converters, custom collection editors, UI type editors, and component Editors. Also developed custom control-builders, embedded resources, analogous client- side framework and databound-templeted controls.

Developed custom HttpHandlers to handle dynamic generation of bitmap images, generation of variable-based style sheets, and JavaScript consolidation and compression.

Framework consists of an extensive admin section supporting multiple levels of role-based security. Allows IT team to test various roles by using SessionManager class to change session and HttpContext variables on the fly. Also allowed department heads to create their own department home-absent of any IT resources. Generates dynamic Html content, employs drag-and- drop, user selected data fields, and custom expressions MAY2010 NOV2010

Carnival Cruise Lines

Contract Developer

Miami, Florida

APR2008 APR2010

The Geo Group

Software Developer

Boca Raton, Florida

7 KEVIN LOCKERBY kleelockerby@acy5mb@r.postjobfree.com MMarch March 2017 Kevin Lockerby

Education

1992 MBA, Marketing & Finance

UNIVERSITY OF PHOENIX

Wilmington, Delaware

1985

1984

1983

1983

Naval Engineering

UNITED STATES NAVY

Newport, Rhode Island

Surface Warfare Offi cer

UNITED STATES NAVY

Newport, Rhode Island

B.S. Chemical Engineering

NORTH CAROLINA STATE UNIVERSITY

Raleigh, North Carolina

B.S. Applied Mathematics

NORTH CAROLINA STATE UNIVERSITY

Raleigh, North Carolina

8 KEVIN LOCKERBY acy5mb@r.postjobfree.com March 2017



Contact this candidate