Sql Server Asp.Net C#

Resume of: Richard R. Belanger

* ******* ******, ******* ** 01754, 978-***-****, ********@*******.***

SUMMARY

Full Stack Developer ASP.NET/C# Webforms SQL Server

Cleared for CAC card at Natick Labs Soldier Center while employed

Specialty is creating portals with many sources of information for departments. At Adheris, billing system for 2 users turned into a Business Information Portal for 60+ people.

Senior Web Application Developer with recent web business application development using ASP.NET 2.0/3.5/4.0/4.5, C#, MVC (API endpoints, Microsoft Entity Code First), SharePoint Designer 2010, SharePoint Administration and Out-of-The-Box development, CorasWorks, Visual Studio 2005/2008/2010/2012 and SQL Server 2005/2008 R2/2010/2012.

Skill set also includes Classic Active Server Pages, Coldfusion and PHP.

Development, enhancement and support of several e-commerce web sites using PHP 4.0 and SQL Server 2005.

Creates wireframes, mockups or prototypes when requested

Experienced in Windows business application development using Visual Basic 6.0.

Experienced CPA and 5 year Controller leveraging experience for successful business system development.

TECHNICAL SKILLS & YEARS OF EXPERIENCE

(11) ASP.NET 4.5/C# Webforms

(1) ASP.NET 4.5/VB Webforms (1) ASP.NET 4.5/C# MVC

(20) HTML (20) CSS

(1) HTML5 (1) CSS3

(12) Javascript (7) jQuery

(1) Postman (20) SQL Server

(1) AGILE (1) Jira/BitBucket/Confluence/SourceTree

(17) Visual Studio 2015, 2017,2019 (14) Classic ASP 3.0 w/vbscript

(1) Microsoft Entity Framework (14)ADO/CDO/COM

(6) Coldfusion 4.5 (18) MS Access

(3) MS Project (5) MS Visio

(1) PHP4 (3) PHP5 with OOP

(1) SPServices (2) Sharepoint Object Model

(1) SharePoint Designer 2010 (4) GoDaddy Web Hosting Platform

(2) MS WPF (6) Visual Basic B 6.0 w/OOP

(1) Recently completed tutorials on Angular 2, Angular CLI and Angular 5 CRUD

(1) SelectPDF

EXPERIENCE

DOT/FAA and FMCSA via MSAG, Volpe Center, Cambridge MA and Washington DC (CONTRACT)

10/2017 – 10/2021

Software Engineer

FAA/Part16 is a web based ASP.NET 4.6 Web Forms with C# Complaint Tracking Application. SQL Server database.

oIt is for airport complaint activity throughout the country. Used to file concerns about complaints that have reach need of resolution from the Director of Airport Compliance.

FAA/ACODB is a web based ASP.NET 4.6 Web Forms with C# Pre-Part16 Complaint Tracking Application. SQL Server database.

oIt is for airport complaint activity throughout the country. Used to file concerns about complaints that have reach need of corrective action recommendations from specialists of Airport Compliance.

FMCSA/DataQs is a web based ASP.NET Web Forms with C# portal solution. Oracle database.

oIt is for various trucking activity throughout the country. Used to file concerns about inspection and crash data available from FMCSA.

FMCSA/ELD is a web based ASP.NET 4.5 MVC5 with C# portal solution. Also WPF version used by law enforcement. Oracle database.

oIt is for tracking driver hours of duty activity throughout the country. Aids law enforcement in applying Hours Limits on drivers for highway safety.

FAA/eFSAS is a web-based ASP.NET 4.5/VB.NET solution for tracking inspections of aircraft, pilots and agencies. It has a SQL Server 2014 back end.

oIt involves a web UI project, web services project (SOAP), knowledgebase project, DAL project and Custom Controls project.

oPerformed various bug fixes and enhancements. Some DB SP work.

FAA/APT is a WPF/C# project that annually creates inspection records ported to eFSAS. It has a SQL Server2014 back end.

oIt involves a web UI project, web services project (SOAP), DAL project

oPerformed various bug fixes and enhancements. Some DB SP work.

Explorica, Boston MA (CONTRACT)

5/2017 – 9/2017

Software Engineer

Explorica has 4 major solution with 20-40 projects in each

oDebugging various problems,..UI w/Sitecore, SQL Server and C# code, in the Sales, Vendor, TravelAdmin and Payment solutions

oRevising C# code and stored procedures (SQL Server) to handle new line of business (LOB)

Changes to ACH processing...ftp processing of new send and return files

Changes to Credit Card processing...adaptation to new account parameters and host parameters

Console app to synch up interim transaction data from new LOB to Explorica database structure

Consuming API methods to create trips, create travelers, update travelers, validate travelers and redirect to Schoology page a new feature from new business

Create unit tests for various business and data layer processes

UI changes to vendor solution to improve filtering

Coding done in branches/workspaces set up within Team Foundation

Source code using VSS

Bose, Framingham MA (CONTRACT)

11/2016 – 5/2017

Web Application Developer

SharePoint Administration and Out-of-The-Box SharePoint development of Finance Department Portal

Create Master Data Engine ASP.NET/C# Webforms application with a SQL Server back-end to provide Bose employees all over the world an easy way to create or edit data for SAP application. The data being worked includes General Ledger Accounts, Cost Centers, Profit Centers and Internal Orders. All areas are tabbed for Detail, Notes and Reports.

This application is fully set up with content management capability so the users can make their own edits to almost any verbiage on the site.

This application has page sensitive help managed with the same content management system.

This application has emailing to alert users at all pertinent steps.

This application has exception logging and real-time exception emails sent to the programmer.

Andplus, Framingham MA (PERMANENT)

11/2015 – 10/2016

Software Engineer, Agile Development Process

Create accounting application (similar to Quickbooks Online) using ASP.NET/C# MVC

o90% - work on API endpoints, Service, Repository, Entity Framework and Unit Tests

Primary Project houses Controllers

Solution Subprojects of Data (Repositories), Entity (Models and Migration), Service (Service methods) and Unit Tests (Repository and Service tests)

Testing all created Controller methods using Postman

o10% - front-end work using jQuery, Javascript, Bootstrap

Support and enhancement of Microsoft WPF application and related ASP.NET/C# web application

Some Windows Administration for WPF application configuration.

Humantouch/CorasWorks, Virginia (PERMANENT)

2/2015 – 10/2015

Professional Services Consultant

Create applications using Corasworks, a PaaS for Sharepoint.

Part of team that is creating a Project Leader Toolkit for the US Marine Corps. Build upon the existing Project and Portfolio Management PaaS product. Using XSLT, XML, Sharepoint Object Model and jQuery.

Enhancing US Army NSRDEC voting application which I had written using SPServices/Sharepoint Object Model for Sharepoint when working at the Natick Soldier System Center. Using Corasworks to make the application much more efficient. Using XSLT, XML and jQuery.

Part of teams creating Proof of Concepts for DOD and Commercial customers using standard Corasworks applications as base and customizing using XSLT, XML and jQuery.

Enhanced and bug fixed several non-DOD Corasworks applications for commercial customers using XSLT, XML and jQuery.

100% remote from home

Woodbury Technologies, Utah (PERMANENT at Natick Soldier System Center)

12/2013 – 1/2015

Senior Web Business Application Developer

Full SDLC using SharePoint 2010 for several web applications involving equipment maintenance tracking, task assignment and approval, significant action tracking, technology update requests.

All applications have extensive use of Workflows, jQuery, Sharepoint Object Model and SPServices.

Passed background check for Confidential Clearance and issued U.S. Army DOD CAC card.

The Macurn Consulting Group (PERMANENT), Braintree MA 5/2010 – 11/2013

Senior Web Business Application Developer

Full SDLC using ASP.NET/C# SQL Server 2005/2008 for several web add-on applications for Deltek Costpoint Project Accounting systems. Past cost accounting experience was big aid in development of applications.

Applications:

oProposal Creation – Complex system for Job Cost, Project environments

Employs project costing algorithms in rate build up and reports. Shows summary as well as several levels of detail to satisfy various stakeholder requirements.

oEmployee Benefit Portal and Payroll Forecasting

Portal collects/stores employee data and connects to various Deltek Costpoint employee and salary tables to easily create a budget and various forecast to budget comparisons.

Online benefits elections process to allow employees to self-enroll and/or change their elections and beneficiary/dependent information for the various company offered benefits.

o401k Limit Testing

Connects to Deltek Costpoint tables and allows input/storage of relevant other data to create reporting used for completion of various required reports.

oSeveral data preprocessors.

Preprocessors create text/csv files to allow mass uploading of various master file data satisfying data constraints within Deltek Costpoint

Related process to make adjusting journal entries and/or reversing journal entries based on conditions found in current general ledger journal entries in a month.

The Macurn Consulting Group converts to new project organizational structures for clients.

Self Employed (Various Contracts) 9/2008 – 4/2010

Senior Web Application Developer

Created business applications primarily using ASP.NET/C# technologies and SQL Server. Full Stack. Some Classic ASP and PHP development.

ITV Ventures, Beverly, MA 12/2007 – 9/2008

Senior Web Application Developer

Designed, Development, enhancement and support of Customer Relationship Management application using ASP.NET 2.0/C#, Visual Studio 2005 and SQL Server 2005.

Development, enhancement and support of several e-commerce web sites using PHP 4.0 and SQL Server 2005.

Hill Holliday, Boston, MA 6/2007 – 12/2007

Senior Web Application Developer

Development, enhancement and support of company portal of applications using ASP.NET/C# and SQL Server 2005.

Adheris, Burlington, MA 11/2004 – 6/2007

Senior Web Application Developer

Developed multiple web-based applications using full SDLC methodology. All with SQL Server 2000 database, PHP coded interface using stored procedures. Accomplishments:

Solely responsible for the design, coding and implementation of a complex web-based application (400+ pages, 140+ tables), Adheris Billing System (ABS).

Worked closely with the Controller to convert complex Excel spreadsheets and other data sources into ABS.

Included object definition, design and creation of relational database with stored procedures, process control via SQL Jobs, audit logs, navigation logs and multi-level authentication.

Sales and General Journal created in ABS and imported into Peachtree Accounting.

Designed and coded web-based Project tracking system

Self Employed 9/2002 – 11/2004

Independent Consultant for the following projects:

Yankee Group (8/22/2004 – 10/31/2004)

Document workflow process reporting from Documentum database using Coldfusion MX 6.1 and SQL Server 2000

ABT Associates (11/2003 – 4/2004)

Various web applications using Coldfusion 4.5 and SQL Server 2000 on Unix Apache Web Server (www.abtassociates.com); also ASP 3.0 for Intranet applications

Haverhill School Department (9/2002 – 11/2004)

8 Web-based applications, including online school registration, assignment calendar, survey, scholarships, supplies requisition, etc. using Classic ASP 3.0 and MS Access.

EBSCO Publishing, Ipswich MA 3/97 – 9/2002

Sr. Programmer/Analyst

Developed multiple web-based and Windows-based business applications using full SDLC methodology.

Worked independently and as part of a team. Accomplishments:

Designed and coded web-based version of our customer satisfaction package using ColdFusion 4.5 connecting to Oracle, Foxpro, and SQL Server databases.

Created Requirement, General Design and Detail Technical Design documents.

Designed and coded intranet-based customer selection and email broadcast system using ASP and VB.

Designed and coded web-based Project tracking application using ASP and MS Access database.

Designed and coded new web-based customer trial system using ASP and Oracle, Foxpro and SQL Server databases.

Converted Foxpro 2.6 Order Entry system to Oracle database with VB forms.

Completed Allaire Fast Track to ColdFusion Certification and Advanced ColdFusion

Designed and Coded Production Services DataBase (PSDB) using MS Access and ASP to control the visibility of Production of 50 Online, 40 CD and 70 data service (tape/diskette) products.

Walden Industrial Supply, Danvers MA 10/91 - 5/96

Controller/MIS Manager

Oversaw Accounting and Information Systems directly managing 6 clerical staff.

Implemented and maintained Prophet 21 Distribution System on RS6000 / AIX.

EDUCATION

Bentley College, Waltham MA

MS Computer Information Systems

Salem State College, Salem MA

BS Business Administration/Accounting

Contact this candidate