Sql Server C#
Resume:
James W Collin
James W Collin
Keeseville, NY 12944
****.******@*****.***
202-***-**** (c)
TECHNICAL SKILLS
Operating System: Windows (2008, 2010, 2012, XP, Vista, 7, 8, 10), Linux, UNIX, OS-X
Languages: TypeScript, Angular, AngularJS, NET Core, ASP.NET Core, HTML, XML, VB 3 – VB 6,C/C++/C#(2.0-7.0), VB.NET, ASP/ASP.NET
Databases: SQL Server 2005 – 2022, Oracle 10/11g, DB2, Sybase, MongoDb
Mail Servers: MS Exchange
Others: LDAP (Active Directory), T-SQL, Rational Rose, MS Project, COM+, Citrix, MS Commerce Server, MS BizTalk, GroupWise, Data/Internet, Security, Web Development, .NET Development, Windows Services, Financial Systems, Erwin, Crystal Reports, SQL Server Reporting Services, Perl, ISA Server, HIPAA, EMR, M, SOA, WinForms, log4net, MSMQ, RabbitMQ, Fiddler, CSLA.NET, VBA, J2EE, Agile, SSL, Rest, ADO.NET, MVC, Remoting, Xml Spy, SSIS, Toad, TFS, Entity Framework, LINQ, NHibernate, Ninject, microservices, Web API, Postman, Infragistics, DevExpress, DevExtreme, Radzen, Blazor, WPF, MSMQ, Silverlight, WCF
TRAINING AND CERTIFICATIONS
Microsoft Certified Application Developer
Microsoft Certified Solution Developer .NET
Microsoft Certified Database Administrator
Microsoft Certified Professional
Microsoft Certified System Engineer
Microsoft Certified System Administrator
Az-204 Certification (in progress)
EXPERIENCE
Self-Employed – Software Developer, AI Researcher & Technical Mentor 10/2023 – Present
Designed and deployed full-stack web applications using ASP.NET, Blazor and Microsoft Azure, emphasizing scalable architecture, modern UI/UX, and cloud-native deployment strategies.
Conducted independent research and experimentation in artificial intelligence, with a focus on computer vision, machine learning modes, and generative AI frameworks.
Created and customized educational programming environments to support hands-on learning in robotics and software development, mentoring middle school students through afterschool workshops and one-on-one sessions.
Bridged advanced technical concepts to beginner-level learners, developing curriculum-aligned content and guiding students in building real-world coding projects.
Maintained continuous technical growth through experimentation, open-source engagement, and exploration of emerging tools and platforms across AI and web development.
Leidos Innovations
Lead Full Stack Developer 4/2017 – 10/2023
(U.S. Dept of Energy - Albany, NY)
Responsibilities
As team lead of 6 developers for the Knolls Nuclear Propulsion Laboratory, develop software using C#, AngularJS, Oracle, NHibernate and SQL Server Reporting Services for an application that is used to manage training of Navy personnel in the use and management of nuclear submarine propulsion systems.
Designed and developed testing suites using C# and xUnit.
Create and access database objects by using TSQL in MS SQL Server 2012 and PL/SQL in Oracle 10/11g
Debugged WebAPI/REST and Services using Fiddler and Postman.
Developed new systems to improve production and workflow using VB.NET, C++, ASP and PL/SQL
Manage the maintenance and new development of a data import system instrumental in populating training data.
Worked on Procedures, Functions using Oracle PL/SQL.
Designed and developed student dashboard to allow training personnel to track their progress from locally accessible computer workstations. This was developed using C#, JavaScript, MVC and Angular.
U.S. Dept of State
Washington, DC
Architect/Lead Full Stack Developer 10/2008 – 4/2017
Provide Software development and design services in support of Dept. of State (DoS) and Defense Intelligence Agency (DIA/NMEC).
Designed and lead a team of 4 programmers to build a Human Resources tracking system for State Department Post positions in ASP.NET, MVC, VB.Net, C#, SQL Server, SSIS for data migration and Crystal Reports.
Designed and build global messaging systems using .NET 4.0, C#, ASP.NET 3.5 & 4.0, MVC, SQL Server 2008 R2, TFS, Oracle 11g, T-SQL, PL/SQL, WPF, Silverlight, WCF, MSMQ, Crystal Reports.
Developed Worldwide TS Messaging System from prototype to current release in use by DOS, replacing an older mainframe system. The system encompasses a framework of libraries used by team members that managed message conversion and transmission to 120+ international embassies and many U.S government entities supplying communication between these agencies. This brought about a savings of almost $1M per month on messaging cost for the U.S. Dept of State.
Developed and maintained message processing and communication software in C/C++ and Oracle (DoS).
Provide programming and design support, designing and implementing computer applications and processes that automate processes manually performed by NMEC staff to validate, archive and analyze files and collections of files.
Technical Resource for windows design, development, library and deployment.
GroupM, New York, NY
Developer 4/2008 – 10/2008
Responsibilities
Developed an Excel application framework to facilitate the construction of a flighting (budget management) data for marketing agency using Excel VBA, Visual Studio Tools for Office (VSTO), SQL Server 2005, LinqToSql, NHibernate Web Services, WCF, SOA, .Net 3.5, ASP.NET and C #.
Construction of a multi language Excel spread sheet application and associated libraries that allowed team development of a configurable in language and layout using an external configuration (admin) application.
Maintained and enhanced current Excel/C# marketing application.
MetLife, New York, NY
Architect/Developer 10/2007- 4/2008
Responsibilities
Designed and developed application to reduce archived email and “im” quantity for cost savings.
The design centers on an extract of data from PeopleSoft, Oracle 10g, Lotus Notes, Zantaz, Facetime and 2 proprietary flat files using a custom Java, SQL Server SSIS tools, T-SQL procedure and a VB.NET 2005 front end to manage user interaction.
Deutsche Bank, New York, NY
Application Developer 06/2007 – 10/2007
Responsibilities
Conversion of VB6 legacy application to C# / VB.NET.
This project involved conversion and adaptation of a 10 year old VB6 Fixed Income & Stable Value Products application, replacing unsupported libraries and moving to a .NET platform using C# 2.0 and VB.NET Winforms,GUI, Infragistics, CodeSmith 4.0 and the MS Enterprise Library 1.1 data access and Sybase ASE stored procedures.
Allscripts Inc., Burlington, VT
Application Designer/Developer 05/2006 – 06/2007
Responsibilities
TouchWorks medical practice management application. Technical design and development of Web(ASP.NET), Winforms, GUI and custom controls and library components in Visual C# 2.0 & SQLServer 2005 for use by team members it the US and India. the new release of the TouchWorks practice management application.
This application uses a web browser framework containing multiple Windows components to deliver an intake to billing practice management application tool. Targeted at medium to hospital size medical practices it is currently in version release 10. The version we are working on involves a complete rework of the existing application and the doubling of the number of features supported and increasing the overall codebase by more that 1.5M lines of new code.
The project involves working with and interaction with a large, divers and dispersed team with members in India, Canada, and various cities around the US.
Though my original intent was not to involve myself in the management aspects of this project, I find that the role has been migrating toward me in spite of that choice.
Mentoring the development team and project management as the transition from earlier versions of .NET and COM to the latest MS VS2005 .NET release.
Health Insurance Plan of New York, New York City, NY
Lead Developer/Mentor 02/2006 – 05/2006
Responsibilities
Designed and developed a TabletPC / Digital Ink prototype application to simplify and enhance the daily tasks performed by Acute Care clinical review nurses.
Built using VB.NET WinForms, GUI and C# v2.0 (2005), Web Services, Remoting, MSMQ, SSL, and SQL2005 this application developed using eXtreme/Agile methodologies allowed the nurse practitioner to evaluate the efficacy of extending a patient’s hospital stay
Data for the application was supplied by C# SOA transmitted over unreliable cell phone network VPN connections using data stored in a SQL2005 database.
DTS extraction scripts were developed to extract current hospital / member records from a remote Oracle 9i database 4 times per day.
National Institutes of Health, Bethesda, MD
Application Designer/Application Developer 02/2005 – 12/2005
Responsibilities
Designed and developed an MS .NET enhancement to MS Commerce Server 2002 that schedules, manages and executes the updating of catalog product and category items.
Built in VB.NET this application allows for the automated modification of product information using XML or CVS data loads from multiple vendors to a central e-commerce supply depot web site.
BizTalk script and Windows service application developed in C# to capture approved purchase orders, convert them to assigned formats (cXML, Email, custom EDI, SQL Server, Oracle), and forward them to respective vendor portal sites for fulfillment.
U.S. Office of Compliance, Washington, DC
Consultant/Security Analyst 01/2004 – 01/2005
Responsibilities
Facilitated and managed meetings and planning groups that allowed this federal watchdog agency to develop an overall IT vision and strategy. Helped them form these goals into a set of concrete achievable milestones that factored in budget, personnel, need priorities and office dynamics.
Performed a detailed data and network security analysis of the agency and its local environs.
Provided final white paper report detailing strengths and weaknesses of the current state of the infrastructure plus recommendations to fix and/or improve security in deficient areas.
Kensington Glass Arts, Kensington, MD
Consultant/Developer 04/2003 - 01/2004
Responsibilities
Designed and developed custom web based inventory management system for medium size glass manufacturer and fabricator.
Developed with ASP.NET, VB.NET, C#, Remoting, SQL Server 2000, XML, XSL, Windows 2003 and IIS6.0. This application allows users working at PC and Mac workstations to create purchase orders manage delivery routing and track inventory. The application has a custom Web Service interface to QuickBooks allowing for centralized receivables and payables while extending inventory handling and tracking functionality.
St. Mark’s Episcopal Church, Washington, DC
Consultant/Developer 01/2003 - 04/2003
Responsibilities
Designed and developed custom solution to publish parish membership directory in multiple electronic formats.
Due to unique requirements prior directory production had always been a laborious manual process. The solution developed in ASP.NET, VB.NET, XML, XSL and SQL Server 2000 (MSDE) now automates directory production into PDF, HTML, Outlook & Palm Contact format.
As corrections and additions to the membership database are made, directory regeneration is automatically triggered so the directory is always up-to-date.
Substance Abuse and Mental Health Services Administration, Washington, DC
Consultant/Technical Analyst 07/2002 - 01/2003
Description
Retained to assist SAMHSA plan its Web design and development activities, and provide independent assessments of software components and design strategies already in progress for the Center of Substance Abuse Treatment’s WITS (Web Infrastructure for Treatment Services). This was to be a framework of .NET web components, data structures and web services. The components were designed to be used by state and local agencies to develop their own client management applications and to streamline reporting and data collection for state and federal Medicaid insurance. The web services offer data management, calendaring services and a standardized portal that converts the states proprietary data formats into HIPAA compliant EDI formats (X-12 837p and 837i series). This product is currently under development by a number of contracting agencies. I was contracted to supply advice and expertise in the design, development, deployment and software reuse; recommendations on .NET web services strategies; XML & EDI industry standards, data modeling and schema design, and HIPAA EDI formats.
ExxonMobil, Inc. (Global Aviation Fuels), Fairfax, VA
Lead Programmer/Mentor 03/2001 - 08/2002
Responsibilities
Architected, designed and implemented a remote invoice delivery system to provide on demand printing of fuel delivery invoices at Exxon Mobil’s Turkish affiliate headquarters. My task in this project consisted of developing a framework of library components for capturing X12 & EDIFACT EDI data extracts from a DB2 / Cobol legacy accounting application, converting this into encrypted XML data streams, shipping that data to Turkey over EM global intra/inter – network using MS Active Directory (ADSI/LDAP) for dynamic resource discovery, applying customer XSL Stylesheets at the Turkish site to convert, translate and format into Turkish script and currency for final printing. The original development design documentation was in UML Sequence and Static Structure diagrams using Rational Rose 2000. This application was developed using VB 6.0, ASP, XML, XSL, Win2000 Active Directory (ADSI/LDAP), Cobol, MS SQLServer, MSMQ and BizTalk 2000 using Agile methodologies. This n-tier DNA application is currently being used as the model for the extensive implementation of similar applications in South America, Asia and Europe.
Designed and implemented a proof-of-concept BizTalk 2000 integration between EM’s legacy aviation fuel invoicing system (SMARTS) and Jet-A.com (an internet based Jet fuel tendering and ticketing portal). This involved intercepting X12 and EDIFACT invoice data feeds coming into the fuel invoicing system; extracting and massaging the data and reformatting it into Jet-A’s XML schema; developing XLANG and BizTalk Orchestration scripts and workflows; custom VB 6.0 COM object for business rules; defining custom SOAP envelopes for the XML document, error and exception management; and translation back into the original source EDI for invoicing. Tools and languages used included BizTalk 2000, XLANG, VB6.0, VBScript, Jscript, MSMQ, DB2, Oracle 8i, SQLServer, XML, XSL, ASP, Cobol, MS Host Integration Server, IBM MQ-Series.
Served as technical resource and provided hands-on leadership and training. Mentored and trained in-house staff of mainframe and junior programmers in new windows / pc development skills.
ExxonMobil, Inc.
Application Architect/Application Designer 10/2000 - 02/2001
Responsibilities
Conducted studies pertaining to the development of new information systems to meet current and projected needs.
Developed a number of UML Use Case scenarios using Rational Rose 2000
Delivered oral and written presentations for a proposed architectural design of a consolidated global application development strategy.
Provided a detailed implementation strategy that would allow for the incremental design, development and deployment of application components with minimum disruption to existing systems.
Priceline.com – The Webhouse Club, Stamford, CT
Senior Application Designer/Developer 04/2000 - 10/2000 Responsibilities
Contracted as a middle-tier technical architect to analyze existing web (ASP) and application (VB/Oracle) architecture.
Conferred with various department personnel involved in order to analyze current operational procedures and problems.
Developed a series of UML Use Case and Sequence models using Rational Rose.
Designed and introduced a uniform XML based ‘Shopping Basket’, replacing a proprietary ‘Property Bag’ implementation.
Restructured and improved the site responsiveness through better use of MSMQ messaging.
Contact this candidate