ASP.NET Core 2 MVC 6

Woodward Liquor website

Client: Woodward Liquor (backend password: test)

  • Designed Web application (frontend and backend) from scratch
  • Implemented SDLC Prototype model, DevOps
  • Used LINQ to retrieve the data from the backend through Entity Framework Core
  • Designed DB context, SQL reports, requests, stored procedures, DML triggers, Azure messaging, WebJobs for Development/Production
  • Used Dependency Injection inside ASP.NET MVC Controllers/Views
  • Designed a Business Objects functionality, implemented Web services (REST/SOAP) and Web API
  • Used JavaScript, Bootstrap, JQuery for client-side/server-side code in ASP.NET Web applications
  • Secured Web applications by third-party authorization (MS Exchange O365), client certificates, CORS, token-based authentication, AES cryptography
  • Tested with West Wind WebSurge, VMWare/vSphere 5.1 (cross-browsing testing), MS Unit Test

Implemented technology:

  • C#, MS Visual Studio 2017, MS Azure SQL Server
  • MS Azure Functions (FaaS), Service Bus, Storage, BLOB, WebJobs (timer/queue triggers)
  • T-SQL (requests, stored procedures, DML triggers), SSDS, SSIS, RDLC, SSRS, ADO.NET
  • .NET Core 2.0 MVC 6, .NET Frameworks 4.7, Razor for C#
  • Bootstrap 4, EF Core, LINQ, JavaScript, JQuery, AJAX, JSON, Dependency Injection
  • Web services, Web API, Universal Product Codes API, Google Maps API, EWS Managed API, REST APIs for Exchange Server Office365
  • PayPal REST API, NVP/SOAP API, Sandbox API, IPN, PDT, OAuth, Transaction Search/Details
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video, GIMP 2, Inkscape 0.92
  • Cryptography X509, SSL, PKI, AES, PowerShell
  • Mercurial Source Control
Hardware:
  • Sun Fire 4450 server, APC UPS, backup hardware
  • Barcode scanner Proster
  • Laptop DELL 17"/16Gb RAM/500Gb SSD, HP 29" HD Color Display
  • ASUS/DLink routers, network switch, 10K BTU Portable Air Conditioner

ASP.NET Core 2 MVC 6

Woodward Liquor website

Client: Woodward Liquor (backend password: test)

  • Designed Web application (frontend and backend) from scratch
  • Implemented SDLC Prototype model, DevOps
  • Used LINQ to retrieve the data from the backend through Entity Framework Core
  • Designed DB context, SQL reports, requests, stored procedures, DML triggers, Azure messaging, WebJobs for Development/Production
  • Used Dependency Injection inside ASP.NET MVC Controllers/Views
  • Designed a Business Objects functionality, implemented Web services (REST/SOAP) and Web API
  • Used JavaScript, Bootstrap, JQuery for client-side/server-side code in ASP.NET Web applications
  • Secured Web applications by third-party authorization (MS Exchange O365), client certificates, CORS, token-based authentication, AES cryptography
  • Tested with West Wind WebSurge, VMWare/vSphere 5.1 (cross-browsing testing), MS Unit Test

Implemented technology:

  • C#, MS Visual Studio 2017, MS Azure SQL Server
  • MS Azure Functions (FaaS), Service Bus, Storage, BLOB, WebJobs (timer/queue triggers)
  • T-SQL (requests, stored procedures, DML triggers), SSDS, SSIS, RDLC, SSRS, ADO.NET
  • .NET Core 2.0 MVC 6, .NET Frameworks 4.7, Razor for C#
  • Bootstrap 4, EF Core, LINQ, JavaScript, JQuery, AJAX, JSON, Dependency Injection
  • Web services, Web API, Universal Product Codes API, Google Maps API, EWS Managed API, REST APIs for Exchange Server Office365
  • PayPal REST API, NVP/SOAP API, Sandbox API, IPN, PDT, OAuth, Transaction Search/Details
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video, GIMP 2, Inkscape 0.92
  • Cryptography X509, SSL, PKI, AES, PowerShell
  • Mercurial Source Control
Hardware:
  • Sun Fire 4450 server, APC UPS, backup hardware
  • Barcode scanner Proster
  • Laptop DELL 17"/16Gb RAM/500Gb SSD, HP 29" HD Color Display
  • ASUS/DLink routers, network switch, 10K BTU Portable Air Conditioner

ASP.NET Core 2 MVC 6

ASP.NET Core MVC Demo

Client: small business staffing company

  • Redesigned website from ASP.NET Web Forms to ASP.NET Core 2.0 MVC 6, added Azure Web Jobs
  • Used SSIS for data migration between databases, SSDT, EF/LINQ requests to database context/models
  • Implemented Azure Storage BLOB, Timer trigger for mail flow, Queue trigger for resume parsing

Implemented technology:

  • C#, MS Visual Studio 2017, MS Azure SQL Server
  • Transact-SQL, SQL requests, stored procedures, DML triggers, SSDS, SSIS, RDLC, SSRS
  • MS Azure Storage, WebJobs, BLOB, MS Azure Active Directory
  • MS Azure Functions (FaaS), Azure Storage Timer / Queue triggers
  • .NET Core 2.0 MVC 6, .NET Frameworks 4.7, Razor for C#
  • Bootstrap, EF Core, LINQ, JavaScript
  • EWS Managed API, REST APIs for Exchange Server Office 365
  • OneDrive XML/SOAP, Live SDK, Google Maps API; MS Office Live
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video
  • Hosting MS Azure, SmarterASP.NET
  • Cryptography X509, SSL, PKI, AES
  • PowerShell, Exchange Management Shell
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing

ASP.NET Web Forms

ASP.NET Web Forms Demo

Client: small business staffing company

  • Redesigned website from Joomla to ASP.NET Web Forms
  • Manage system integration: Corporate web application, online payroll system, local accounting, cloud exchange server, automation of event-friendly email distribution
  • Design user-friendly interactive web pages for customers/staff, reports (RDLC, SSRS, ClosedXML)
  • Automated browser compatibility testing using Browsera tests, manual live tests using Saucelabs test, CrossBrowserTesting, VMs in VMWare vSpere 5.1, Selenium
  • Designed web site security (cryptography X509, SSL extended validation certificates, IP restrictions, two-factor authentication, data and email encryption, custom anti-forgery tokens for GET request)
  • Designed a Business Objects functionality (ObjectDataSource Web Server controls)
  • Implemented MS Exchange, MS OneDrive, MS Office, Google web services
  • Designed and maintain disaster recovery procedures, IT instructions, group policy settings
  • Installed, configured, maintained, and troubleshoot software: Office 365, GoDaddy hosting, servers virtualization, AD, DNS, DHCP, remote desktop services, Cisco anyconnect, Quick Books, ACT!Pro, ATX professional tax preparation software, ADP ezLaborManager, MS Windows Vista/7/8/10, MS Office 2007/2010/2013/2016, company backup (GoodSync) and information security (McAfee)

Implemented technology:

  • C#, MS Visual Studio 2013, MS SQL Server 2012
  • Transact-SQL, SQL requests, stored procedures, DML triggers
  • RDLC, SSRS, MS Report Viewer, ClosedXML
  • .NET Frameworks 4/4.5/4.6, ADO.NET, ASP.NET AJAX (ScriptManager, UpdatePanel, UpdateProgress, Timer and GridView), LINQ, WCF, JavaScript
  • EWS Managed API, REST APIs for Exchange Server Office 365
  • OneDrive XML/SOAP, Live SDK, Google Maps API; MS Office Live Workspace
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video, WebVTT, TTML
  • Inkscape, Gimp2, Photoshop, Ffilmora, Open Broadcaster Software
  • MS Unit Test, Selenium, Browsera
  • Hosting GoDaddy (Parallels Plesk)
  • Cryptography X509, SSL, PKI, AES
  • OAuth 2.0 authentication (Microsoft), OAuth (single sign-on, tokens)
  • PowerShell, Exchange Management Shell
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing
Hardware:
  • Sun Fire 4450 server, APC UPS, backup hardware
  • Network scanners (Xerox, Epson), multifunction and color printers
  • Fax Brother, mail station PitneyBowes
  • Switches, routers, hotpoints
  • Ethernet LAN, Wi-Fi
  • Laptops, desktops, monitors, projectors, smartphones, office phones

ASP.NET Web Forms

Bluechip Management website

Client: small business consulting company

  • Redesigned website from Drupal to ASP.NET Web Forms
  • Designed user-friendly web pages (Responsive Web Design, section 508(c) compliance)

Implemented technology:

  • C#, MS Visual Studio 2015, MS SQL Server 2014
  • .NET Frameworks 4.5, JavaScript
  • ASP.NET AJAX (ScriptManager, UpdatePanel)
  • GridView
  • Responsive Web Design
  • EWS Managed API, REST APIs for Exchange Server
  • Cryptography X509, SSL, PKI, AES
  • HTML5, CSS3, XML, SVG
  • Inkscape, Gimp2, Photoshop
  • Hosting GoDaddy (cPanel)
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing

Windows Forms application (.NET Core 3.1, VB.net)

Maryland Transportation Authority WinForms app

Implemented tools and technology:

  • Microsoft Windows Forms App, VB.net, target Framework: 4.7.2
  • Microsoft Access Database Engine 2010 Redistributable 32-bit
  • Microsoft Visual Studio 2019, Microsoft Installer Projects
  • namespaces: System.Text, System.RegularExpressions(.NET Core 3.1), System.IO, System.Data.OleDb, System.Security.Cryptography, System.Runtime.CompilerServices(.NET Platform Extensions 3.1)
  • SQL indexes, stored procedures, transactions
  • Microsoft Windows Forms App controls: DataGreedView, ComboBox, TextBox, Button, Label

Maryland Transportation Authority, Baltimore, MD 21224

Product helps the MDTA employes to track errors with ETL processes with MS Dynamics 2015 SL database.

Design Document
User can view data from database tables, mask, unmask, encrypt, decrypt the FTP passwords. For password creating and testing proposals, a function to enable and validate user input was designed (option disabled in Release configuration).
To ensure reliability, the function of preliminary check of the database shema was developed: missed or wrong indexes or stored procedures will be recreated before using.
Microsoft Visual Studio Installer Projects has been applied to create an installation application for installing a BSGtest app on a user's computer. This is a free extension for Visual Studio 2019.
MS Access 2010 database (MDTAJOBSQL15T.accdb) located in working folder of the application (installation folder). Connection to database uses Windows authentication.
App consists of only one window, created programmatically. Primary screen resolution will be adopted to the full size.

ASP.NET MVC Web application (.NET Core 3.0, C#)

Invisa Logistic Services webapp

Client: Invisa Logistic Services, Washington, DC 20007

Implemented tools and technology:

.NET Core app (2.2), C#

Atlantic Coast Cotton webapp

Client: Atlantic Coast Cotton, Gainesville, VA 20155

  • Developed .NET Core 2 /C# console applications (FTP / SFTP / Telnet / SSH access to Unix / MySQL / MS SQL servers)
  • ETL/ELT data integration between IBM AIX 5.1 and MS SQL servers
  • Designed reports with MS SSRS, MS Access, MS Excel
  • Developed .NET Core 2 /C# web application (Selenium WebDriver to web scraping data from vendors websites)
  • Documented business processes, IT instructions and software solutions
  • Designed C# bulk operations: image resizing / comparing / renaming / uploading / downloading / transforming
  • Used SQL queries Left / Right Join, Inner Join, Join Other, Union and SqlDataReader for SQL Server Reports
  • Used FTP Web Requests / Responses (Unix List of Directory/ Download / Upload), Stream Reader/Writer, LINQ for files
  • Used C# SftpClient for access to remote MySQL / MS SQL, TelnetConnection to execute Unix command IBM AIX 5.1
  • Redesigned Excel / VBA-based solutions to MS SQL / C# console / web applications

Implemented tools and technology:

  • C#, MS Visual Studio 2017, MS SQL Server 2017, MS Report Server 2017
  • MS ASP.NET Core 2.1 / Standard, Selenium WebDriver API
  • T-SQL (requests, stored procedures), SSDS, SSIS, SSRS, ADO.NET
  • C# DataTable, LINQ, ADO.NET, SQL transactions, Regular Expressions, SqlBulkCopy
  • VBA scripts, MS Access databases, SQL Lite, SSMS, MySQL

ASP.NET MVC Core Web apps (2.1), C#

Woodward Liquor website

Client: Woodward Liquor, Washington, DC 20011 (backend password: test)

  • Designed Web application (frontend and backend) from scratch
  • Implemented SDLC Prototype model, DevOps
  • Used LINQ to retrieve the data from the backend through Entity Framework Core
  • Designed DB context, SQL reports, requests, stored procedures, DML triggers, Azure messaging, WebJobs for Development/Production
  • Used Dependency Injection inside ASP.NET MVC Controllers/Views
  • Designed a Business Objects functionality, implemented Web services (REST/SOAP) and Web API
  • Used JavaScript, Bootstrap, JQuery for client-side/server-side code in ASP.NET Web applications
  • Secured Web applications by third-party authorization (MS Exchange O365), client certificates, CORS, token-based authentication, AES cryptography
  • Tested with West Wind WebSurge, VMWare/vSphere 5.1 (cross-browsing testing), MS Unit Test

Implemented tools and technology:

  • C#, MS Visual Studio 2017, MS Azure SQL Server
  • MS Azure Functions (FaaS), Service Bus, Storage, BLOB, WebJobs (timer/queue triggers)
  • T-SQL (requests, stored procedures, DML triggers), SSDS, SSIS, RDLC, SSRS, ADO.NET
  • .NET Core 2.0 MVC 6, .NET Frameworks 4.7, Razor for C#
  • Bootstrap 4, EF Core, LINQ, JavaScript, JQuery, AJAX, JSON, Dependency Injection
  • Web services, Web API, Universal Product Codes API, Google Maps API, EWS Managed API, REST APIs for Exchange Server Office365
  • PayPal REST API, NVP/SOAP API, Sandbox API, IPN, PDT, OAuth, Transaction Search/Details
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video, GIMP 2, Inkscape 0.92
  • Cryptography X509, SSL, PKI, AES, PowerShell
  • Mercurial Source Control
Hardware:
  • Sun Fire 4450 server, APC UPS, backup hardware
  • Barcode scanner Proster
  • Laptop DELL 17"/16Gb RAM/500Gb SSD, HP 29" HD Color Display
  • ASUS/DLink routers, network switch, 10K BTU Portable Air Conditioner

ASP.NET MVC Core Web app (2.0), C#

ASP.NET MVC Core Demo

Client: Ross Professional Services, LLC, Washington DC 20011

  • Redesigned website from ASP.NET Web Forms to ASP.NET Core 2.0 MVC 6, added Azure Web Jobs
  • Used SSIS for data migration between databases, SSDT, EF/LINQ requests to database context/models
  • Implemented Azure Storage BLOB, Timer trigger for mail flow, Queue trigger for resume parsing

Implemented tools and technology:

  • C#, MS Visual Studio 2017, MS Azure SQL Server
  • Transact-SQL, SQL requests, stored procedures, DML triggers, SSDS, SSIS, RDLC, SSRS
  • MS Azure Storage, WebJobs, BLOB, MS Azure Active Directory
  • MS Azure Functions (FaaS), Azure Storage Timer / Queue triggers
  • .NET Core 2.0 MVC 6, .NET Frameworks 4.7, Razor for C#
  • Bootstrap, EF Core, LINQ, JavaScript
  • EWS Managed API, REST APIs for Exchange Server Office 365
  • OneDrive XML/SOAP, Live SDK, Google Maps API; MS Office Live
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video
  • Hosting MS Azure, SmarterASP.NET
  • Cryptography X509, SSL, PKI, AES
  • PowerShell, Exchange Management Shell
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing

ASP.NET Web Forms app (Framework 4.6), C#

ASP.NET Web Forms Demo

Client: Ross Professional Services, LLC, Washington DC 20011

  • Redesigned website from Joomla to ASP.NET Web Forms
  • Manage system integration: Corporate web application, online payroll system, local accounting, cloud exchange server, automation of event-friendly email distribution
  • Design user-friendly interactive web pages for customers/staff, reports (RDLC, SSRS, ClosedXML)
  • Automated browser compatibility testing using Browsera tests, manual live tests using Saucelabs test, CrossBrowserTesting, VMs in VMWare vSpere 5.1, Selenium
  • Designed web site security (cryptography X509, SSL extended validation certificates, IP restrictions, two-factor authentication, data and email encryption, custom anti-forgery tokens for GET request)
  • Designed a Business Objects functionality (ObjectDataSource Web Server controls)
  • Implemented MS Exchange, MS OneDrive, MS Office, Google web services
  • Designed and maintain disaster recovery procedures, IT instructions, group policy settings
  • Installed, configured, maintained, and troubleshoot software: Office 365, GoDaddy hosting, servers virtualization, AD, DNS, DHCP, remote desktop services, Cisco anyconnect, Quick Books, ACT!Pro, ATX professional tax preparation software, ADP ezLaborManager, MS Windows Vista/7/8/10, MS Office 2007/2010/2013/2016, company backup (GoodSync) and information security (McAfee)

Implemented tools and technology:

  • C#, MS Visual Studio 2013, MS SQL Server 2012
  • Transact-SQL, SQL requests, stored procedures, DML triggers
  • RDLC, SSRS, MS Report Viewer, ClosedXML
  • .NET Frameworks 4/4.5/4.6, ADO.NET, ASP.NET AJAX (ScriptManager, UpdatePanel, UpdateProgress, Timer and GridView), LINQ, WCF, JavaScript
  • EWS Managed API, REST APIs for Exchange Server Office 365
  • OneDrive XML/SOAP, Live SDK, Google Maps API; MS Office Live Workspace
  • HTML5, CSS3, XML, SVG, Responsive Web Design, HTML5 Video, WebVTT, TTML
  • Inkscape, Gimp2, Photoshop, Ffilmora, Open Broadcaster Software
  • MS Unit Test, Selenium, Browsera
  • Hosting GoDaddy (Parallels Plesk)
  • Cryptography X509, SSL, PKI, AES
  • OAuth 2.0 authentication (Microsoft), OAuth (single sign-on, tokens)
  • PowerShell, Exchange Management Shell
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing
Hardware:
  • Sun Fire 4450 server, APC UPS, backup hardware
  • Network scanners (Xerox, Epson), multifunction and color printers
  • Fax Brother, mail station PitneyBowes
  • Switches, routers, hotpoints
  • Ethernet LAN, Wi-Fi
  • Laptops, desktops, monitors, projectors, smartphones, office phones

ASP.NET Web Forms app (Framework 4.5), C#

Bluechip Management website

Client: Blue Chip Management, LLC, Hampton, VA 23666

  • Redesigned website from Drupal to ASP.NET Web Forms
  • Designed user-friendly web pages (Responsive Web Design, section 508(c) compliance)

Implemented tools and technology:

  • C#, MS Visual Studio 2015, MS SQL Server 2014
  • .NET Frameworks 4.5, JavaScript
  • ASP.NET AJAX (ScriptManager, UpdatePanel)
  • GridView
  • Responsive Web Design
  • EWS Managed API, REST APIs for Exchange Server
  • Cryptography X509, SSL, PKI, AES
  • HTML5, CSS3, XML, SVG
  • Inkscape, Gimp2, Photoshop
  • Hosting GoDaddy (cPanel)
  • VMWare/vSphere 5.1 on Sun Fire X4450 for testing