TECHNICAL SKILLS:

Languages: C# and VB.Net (ADO, ASPX), LINQ, Visual Basic 6, Windows API, VBA, XML/ XST, Quickbooks SDK

Database: SQL Server 6.5 to 2012 (SSIS, SSMS, SSRS), MS Access, MySql

Web Technology: .Net Core 1.1, ASP (.net and classic), MVC, AJAX, IIS, jQuery, Javascript, HTML5, NodeJs, AngularJs, Jasmine, alaSql, CSS 3.0, Bootstrap, ColdFusion, Bower

Applications: TeamServer, Visual Source Safe, TortoiseSVN, Visual Studio 2008 - 2015, Word, Excel, Access 2007, InstallShield

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

.Net Developer

Responsibilities:

• Complete overhaul of proprietary client billing and crm system, switching to .net core with mvc including oAuth security, unit testing using jasmine with AngularJs, bootstrap and css for presentation. Backend web api’s written in C#.

Confidential, New York, NY

.Net Developer

Responsibilities:

• Redesign of online reservation pages to be responsive, allowing access from different sized devices. Backend using PHP with MySQL.

Confidential, New York, NY

Responsibilities:

• Migrated sports fantasy site from a system using MS Access and VB6 dlls to a .net mvc web based environment with Entity Framework, backend web api’s written in C#, utilizing AngularJs, Jasmine for unit testing. Repository used was TortoiseSVN.
• Wrote windows services for real time update of statistics and sports stories utilizing xml feeds from a provider. Changed an elaborate Access front end (linked to sql server) for data maintenance to a web based front end, using web services written in C#, complex sql server procedures, alaSql and server side controllers to re-create the VBA logic.
• Completed an interactive fantasy betting utility tool providing realtime statistics utilizing .net mvc with Entity Framework, Bootstrap for responsiveness and AngularJs for retrieving xml/json data via http from provider, implementing ui-router for state navigation and started implementing LESS for css organization, web api’s written in C#.

Confidential, New York, NY

Responsibilities:

• Migration of current public facing websites from 2003 servers to 2008 servers, iis 5 to iis 7
• Upgrade of asp.net vb code
• Set up and synchronization of SQL CE to hand held devices

Confidential, New York, NY

Responsibilities:

• Worked on Rapid Restore, a huge project designed to respond to feeder outages using the following technologies: asp.net/mvc, C#, classic asp with Ajax, xml/xst, com components written in VB6, soap, Cold Fusion, sql server using advanced procedures and functions. Repository used was Team Foundation Server.

Confidential, New York, NY

Responsibilities:

• Development for online webforms for government social services entities. Persistence and synchronization was obtained through the use of mixed technologies including asp.net/vb, Coldfusiion and AJAX with jquery/javascript. Last two projects utilized MVC 4. Advanced scripting in SQL Server 2008/2005 with the writing and maintenance of stored procs, user functions, views etc. Data manipulation was handled using both LINQ and ADO.net. Repository used was Team Foundation Server.

Confidential, New York, NY

Responsibilities:

• Installed and maintained SQL Server 2008, setup reporting services, created tables, procs etc
• Wrote an add-on system to interact with their Access based POS system, originally using VB6 then porting parts of the program to VB.net. Windows API was used to make custom dropdown boxes.
• Program automatically makes entries into various Quickbooks files from the POS data tables using a custom ActiveX DLL written in C# utilizing the Quickbooks SDK
• Designed a program that uses MySql odbc driver to download email addresses from a remote reservations table, then generates a barcode to be inserted into an email automatically delivered with a discount offer
• When the customer presents the hard copy, another module scans the barcode and automatically enters the discount into the Micro$ale pos database
• Worked on web based automated reservation system using PHP, Flash, Actionscript and Javascript

Confidential, NY

Responsibilities:

• Generated SSIS packages and edited reports in SQL Server 2008. Worked heavily with stored procedures and some user defined functions, some C# coding.

Confidential, New York, NY

Responsibilities:

• In ASP.net, re-designed the In/Out grid, a web based punch clock system allowing employees to punch in and out via a touchscreen and providing various automated reports for accounting with printer friendly pages. Used VB.net with lots of client-side code using javascript and CSS. Extensive use of LINQ.
• Designed a shift log report with a sliding virtual clipboard for use on the public dashboard page utilizing ASP.net with LINQ, javascript, CSS and Telerik controls.
• Implemented Quickbooks reports using ASP.net with LINQ, Quickbooks SDK and Telerik controls.

Confidential, Westport, CT

Responsibilities:

• Assumed responsibilities for maintaining a classic ASP website, including changes to queries and frontend interface.
• Administered IIS and SQL Server 2005.
• Setup a co-site to run .net pages and started migrating asp pages to asp.net.

Confidential, Boston, MA / New York, NY

Responsibilities:

• Upgraded Fibernet portal system by modifying ASP.net pages (VB.net) to use AJAX technology.
• Set up a Sharepoint lab environment in preparation for handling of the migration of Milrose Consulting Inc’s CMS written in VB6 and VB.net to Sharepoint and C#, modified page scraping code written in VB.net to reflect recent changes on the city building code pages.
• Assisted in the maintenance of American Program Bureau’s ASP.net site written in C# using ADO recordsets. Duties included the addition of columns to existing forms and updating the SQL 2005 procedures that modified them . Repository used was Visual Source Safe.

Confidential, New York, NY

Responsibilities:

• Consulted on and/or managed various projects using C#, VB.net, VBA, Windows API and ActiveX
• Migrated Access databases into SQL Server, wrote triggers to generate an audit log, worked with views and stored procedures. Managed security, accounts and privileges on SQL Server.
• Re-worked Privilege Log database project introducing an innovative graphical user interface written in VB allowing each department to customize the application to their own needs