We provide IT Staff Augmentation Services!

Systems Architect/senior Developer Resume

Danbury, CT

SUMMARY:

Confidential has 30 years of experience in the design, development, testing, deployment and maintenance of integrated applications. His primary expertise is in Web Development using Microsoft Visual Studio C#.NET, ASP.NET, MVC, RESTful APIs, Linq, Javascript, jQuery, IIS, HTML, XML, CSS and SQL - based databases such as SQL Server and Oracle. Vince has extensive experience in database design, modeling, deployment and maintenance. In addition to his development skills, he excels as a hands-on project leader. Vince is proficient in requirements gathering and documentation, technical design documentation and client interaction. His communication skills are excellent and he possesses the ability to learn and implement new technologies quickly and efficiently. Vince has experience performing mainly as a hands-on project leader or senior member of a development team.

TECHNICAL SKILLS:

Programming Languages: ASP.NET, C#.NET, MVC, VB.NET 4.5 and prior (WCF, MVVM, WPF) RESTFul APIs JavaScript, HTML5, Linq, XML, jQuery, CSS Visual Basic 6.0 and prior including Microsoft Excel, Word and PowerPoint automation Active Server Pages (ASP), VBScript, HTML, JavaScript, PHP SQL Server Transact-SQL/Stored procedures, triggers, functions, DBA tasks MSSQL Reporting Services (SSRS), Integration Services (SSIS) MSSQL Notification Services Oracle SQL*Plus, PL/SQL stored procedures and packages Microsoft Access

Web Design/Development Tools: Visual Studio 2017 and prior Microsoft IIS 8.0, 7.0 and prior Apache Tomcat 4.1 Visio (Database design/modeling) TFS, Visual SourceSafe, Tortoise SVN, Git Crystal Reports (.Net, v9 - v7)

Operating systems/Database Management Systems: Windows Desktop 10 and prior Windows Server 2012 and prior Microsoft SQL Server 2016 and prior including DBA tasks, SSRS, SSIS SQLite Oracle 11g and prior Microsoft Access 2010 and prior UNIX - AIX, HP/UX, SCO, Sun Solaris

PROFESSIONAL EXPERIENCE:

Systems Architect/Senior Developer

Confidential,Danbury, CT

Responsibilities:

  • Lead Developer for RailHealth project - SQL Server 2014, Visual Studio 2015, C#.Net 4.5, MVC 5, jQuery, javascript
  • Design and implement RESTful web service using .Net Web API to replace SQL Compact Edition data transfer between server and Handheld mobile devices
  • SSRS - Create new reports and modify existing reports, update subscriptions for SSRS 2014 format
  • SSIS - create new integration packages and modify existing integration packages
  • Windows Mobile 5.0 maintenance for Handheld mobile devices

Senior Developer

Confidential,Brewster, NY

Responsibilities:
  • EOC (Enterprise Operations Center) intranet site - License Plate Recognition system portal
  • ASP.NET MVC 5, C# .NET 4.5, Visual Studio 2015, jQuery, JavaScript, Kendo/Telerik Controls
  • SQL Server 2014, Entity Framework 6.0
  • WCF and REST services - integration with field units
  • Design and develop new functionality and improve/maintain existing functionality
  • Multi-browser compatibility: IE 8 and up, Edge, Chrome, Firefox, Safari, Mobile browsers
  • Implement new maps engine using MapServer/OGR/SQLite
  • Research and implement performance improvements for large scale databases
  • Remote video camera monitoring (with relationship to database entities)

Senior Developer

Confidential,Bristol, CT

Responsibilities:
  • Playbook application development - Travel project
  • Microsoft .NET 4.0 - VS 2012, C#, Windows Forms, WCF, WPF, MVVM and MVC, Oracle 11g, Infragistics controls
  • Service-oriented architecture (SOA) using WCF
  • Agile development process, working closely with BA’s and end users
  • MVVM methodology using a logical container on top of the physical model, independent of View layer(s)
  • Database designer for all data model changes related to Travel project
  • Develop test harnesses in Visual Studio for major functionality
  • Develop PL/SQL packages (Oracle 11g), triggers and functions
  • Suggest and implement enhancements to logical code container (MVVM)

Systems Architect/Developer

Confidential,Danbury, CT

Responsibilities:
  • Design, develop and maintain SDMS (Sperry Data Management System) web portals to track potential and verified defects in rail
  • VS 2005, C#.NET/VB.NET/ASP.NET 2.0/AJAX web application using SQL Server 2005 database
  • Implement and customize ASP.NET 2.0 membership objects for user authentication and authorization
  • ASP.NET Web parts, drag and drop for custom dashboards, SharePoint integration
  • XML data import from test vehicles - validate and commit using SQL Server 2005
  • Image/graphics rendering for visual representation of potential and verified defects in rail
  • Implement forms authentication for SQL Server 2005 Reporting Services
  • ASP.NET Custom front-end for report subscriptions, ad-hoc reports and report management
  • Design and code web service for authorization and data retrieval from SDMS database
  • Design and code windows service to submit data to 3rd party web service for Trafikverket (Swedish railway system)
  • Implement SQL Server 2005 Notification Services including custom front end for subscriptions
  • Responsible for installation, configuration and maintenance of all SDMS portals (currently over 25 portals in use)
  • Design, develop and deploy Integration Services Packages to build, Email and FTP data feeds to and from various customers
  • Integrate with handheld application using SQL Server 2005 Compact Edition
  • Create specifications for handheld application changes
  • HTML, CSS, Javascript, SQL Server Reporting Services (SSRS), SQL Server Analysis Services, SQL Server Integration Services (SSIS), SQL Server Notification Services

Systems Architect/Developer

Confidential, Weston, CT

Responsibilities:
  • Design, develop and maintain Investment Analysis web portal
  • VS 2008, C#.NET/VB.NET/ASP.NET 2.0/AJAX web application using SQL Server 2008 database
  • Implement and customize ASP.NET 2.0 membership objects for user authentication and authorization
  • Import data feed from JPM Chase bank (flat text files) to SQL Server 2008 database
  • Gather specifications, design and develop interfaces to maintain Hedge Fund and Private Equity balances with reporting
  • Gather specifications, design and develop interfaces to maintain LLC Distribution Percentages and Personal Asset balances with reporting
  • HTML, CSS, Javascript, SQL Server Reporting Services, SQL Server Integration Services

Systems Architect/Developer

Confidential,Norwalk, CT

Responsibilities:
  • Behavioral marketing system - custom reports application development lead
  • VS 2005, C#.NET/ASP.NET web application using large Oracle 10g database
  • Research existing behavioral marketing reporting application and database
  • Gather requirements and review/revise with project managers
  • Design and implement required database and application changes
  • Modify existing C#.Net custom grid control, Infragistics web controls and Dundas Chart control
  • Application utilizes postback event handlers to avoid page refresh
  • Research and design complex SQL to produce reports including cross-tab functionality (decode), embedded case statements, unions and sub-queries

Systems Architect/Developer

Confidential,Stamford, CT

Responsibilities:
  • Intellectual property gaming application development lead
  • VS 2005, VB.NET WinForms application using SQL Server 2005
  • Research existing gaming application and database and design/implement changes per specifications
  • Project was terminated due to budget restrictions after less than one month

Systems Architect/Developer

Confidential,Shelton, CT

Responsibilities:
  • Application Support Leader - Corporate Intellectual Property Applications
  • Technical lead for support, maintenance and new projects related to PAGE (Patent Assets of GE), PIPS (Paperless Intellectual Property System) and InventorCenter applications (over 1,000 users worldwide)
  • Application technology: Windows 2003/IIS 6, ASP, ASP.NET, PHP 5.0.4, Oracle 9i, FileNet (Document Management), Java, Apache Tomcat, USPS Certification
  • Heavy use of Oracle 9i backend: Stored Procedures, Functions, Java Sources and XDB (for robust XML security model)
  • Designed field level data masking structure in Oracle 9i schemas using views and synonyms for Export Control compliance
  • Multiple Oracle schemas used for data masking and operational access
  • Lead migration of all web and content servers (including Oracle 9i and FileNet content) from Windows 2000/IIS 5 to Windows 2003/IIS 6
  • Consolidated 8 out-of-date and costly servers into 4 multi-processor servers resulting in substantial maintenance cost reduction and improved system performance
  • Responsible for day-to-day system operation and responding to user support/enhancement requests in a timely fashion
  • Gather requirements, create specifications, design, develop and deploy enhancements for existing applications
  • Mentored additional team member

Systems Architect/Developer

Confidential

Responsibilities:
  • Project Leader - Intranet system for tracking show Submissions, Waivers and submitting Companies
  • System tracks all show submissions, status (consider/accept/reject) and waiver forms
  • Responsible for requirements gathering, system design/development and implementation
  • Design detailed prototype in Excel and review with managers to verify functionality
  • Design and develop intranet using Visual Studio .NET (VB.NET, ASP.NET) and Microsoft SQL Server 2000
  • Integrate with Active Directory for user group validation
  • Integrate with MS Excel for reporting
  • Project Leader - IT Portal web site
  • Design and develop IT portal site to track all Servers, Switches, Printers, Applications etc. for IT department
  • Developed in FrontPage so that IT managers can easily modify the site
  • Modify and maintain existing applications developed in VB 6 in a Citrix environment
  • Modify and maintain batch load procedures in VB 6 that summarize data from AS/400 and Sybase systems into SQL Server databases
  • Modify and maintain VB 6 application that provides maintenance and reporting of programming and ad sales information using a SQL Server database (integrated with real-time AS/400 lookups via ODBC)

Systems Architect/Developer

Confidential

Responsibilities:
  • Project Leader - Intranet system for New York-based publishing company.
  • System provides entry, maintenance and reporting of P&L forecasting for published materials (Supported Reference, Booklets, Brochures)
  • Responsible for requirements gathering, system design/development and implementation
  • Design detailed prototype in Excel and review with managers to verify functionality
  • Design and develop intranet using Visual Studio .NET (VB.NET, ASP.NET) and Microsoft SQL Server 2000
  • Integrate with Active Directory for user group validation
  • Integrate with MS Excel for reporting

Systems Architect/Developer

Confidential

Responsibilities:
  • Project Leader - Intranet system for NYC publishing company.
  • Responsible for gathering requirements, design and implementation of corporate intranet including Daily World Sales Reports, Item Sales Analysis, Customer Sales Analysis, Item P&L Forecasting and actual item P&L calculations.
  • Implemented system to E-mail PDF invoice, credit memo and quote forms automatically to customers.
  • Microsoft IIS, Active Server Pages, Visual Basic 6.0 code components (DLL’s) and Crystal Reports on a Windows 2000 platform.
  • Oracle back-end database (AIX Unix) - designed and developed new schema specifically for Intranet system including PL/SQL stored procedures and packages.
  • Interfaced with existing business application schemas. Summarized existing detail data from the business schemas into a “data warehouse”-like format in the new Intranet schema.
  • Implemented hierarchical application support data in XML.
  • Team Member - Thomson Corporation Brand Center project.
  • Responsible for design and development of template builder module in Microsoft IIS.
  • Used Active Server Pages and Visual Basic 6.0 code components (DLL’s) to perform dynamic image and text replacement in Microsoft Word and PowerPoint documents.
  • Design and develop VB code to parse XML document which contained all parameters for dynamic image/text replacement.

Consulting Software Development Engineer/Project Leader

Confidential

Responsibilities:
  • Project Leader - responsible for maintenance, add-on design, development and testing of public gaming site for eLottery using Microsoft IIS, Active Server Pages, Visual Basic 6.0 code components, SQL Server 7.0, Visual Interdev
  • Responsible for design, development, testing and deployment of enhancements to existing system functions
  • Responsible for design, development, testing and deployment of new functionality
  • Designed, developed and implemented Data Warehouse for archive of historical data and reporting
  • Responsible for design and implementation of new backoffice accounting Intranet site
  • Implemented development/deployment process adopted by all team members using development, staging and live environments
  • Implemented modification tracking system and release processes
  • Responsible for review of client requirements and technical design documentation for all additions/modifications
  • SQL Server 7.0 database administration, design and development including T-SQL stored procedures.
  • Project Leader - responsible for functional specifications, technical specifications, database design/implementation and web interface design/implementation of a new gaming system for the Jamaican Lottery
  • Microsoft IIS, Active Server Pages, Visual Basic 6.0 code components, SQL Server 7.0, Visual Interdev
  • Responsible for design, development and implementation of public Internet site as well as backoffice accounting Intranet sites
  • Responsible for design, development and implementation of interface to SureFire Commerce credit card verification component
  • Public and backoffice sites delivered on time and on budget

Consulting Software Development Engineer/Project Leader

Confidential

Responsibilities:

  • Project Leader - responsible for design, development and testing of production system using SQL Server 6.5 Transact-SQL stored procedures, Visual Basic 5.0 and PostalSoft
  • Perform SQL Server DBA tasks to manage large (15+ GB) marketing databases for major ski resort
  • Responsible for technical design documents and specifications for production process
  • Hands-on SQL Server 6.5/Transact-SQL Stored procedure coding
  • Manage sub-group of Transact-SQL programmers and PostalSoft operators
  • Responsible for VB 5.0 COM-oriented application maintenance and modifications - 3-tier architecture using RDO
  • VB 5.0 interface with Microsoft Excel Object for reporting
  • Developed PL/SQL stored procedures using Oracle 8.0 to update large (20+ GB) marketing database for major pharmaceutical corporation
  • Maintain and modify Visual Basic 5.0 application which automated several production tasks using RDO to interface with Oracle 8.0 database
  • Developed several reports using Crystal Reports 5.0, Oracle 8.0 marketing database and PL/SQL stored procedures

Hire Now