JOHN SOMMA

Austin, Texas

ad4gec@r.postjobfree.com

512-***-****

OBJECTIVE

To lead a team of software developers creating web-based applications using ASP.Net MVC, AngularJS, Microsoft SharePoint, Office 365, SQL Server, Oracle, Azure DevOps, and C# with Agile methodologies

PROFESSIONAL PROFILE

Talented professional with broad-based information technology experience in web development, project management, database administration, and graphic design in the healthcare, marketing, and financial services industries

Demonstrated expertise in diagnosing and resolving software challenges and designing intuitive systems

EXPERIENCE

Sr. Software and Database Developer

Tranter, Houston, TX

Contract with RightStone, a subsidiary of CornerStone Staffing Solutions, Dallas, TX (April 2022 – March 2024)

Developed complex PL/SQL Oracle and SQL Server queries to transfer data from a legacy ERP system to IFS.

Created Boomi workflows; updated ASP.Net web services and applications; set up GitHub account and repositories.

Sr. Web Application Developer

Donnelley Financial Solutions, Lancaster, PA

Contract with Insight Global, Atlanta, GA (August 2021 – February 2022)

Improved an Angular 8/C#/Azure SQL/DevOps/open source web application and C# workflow; Mulesoft.

Sr. Web Application and Database Developer

Dell, Round Rock, TX (Employee Aug 2017 – March 2020)

Contract with Experis, Round Rock, TX (Contractor Jan 2017 – Aug 2017)

Built Restful and SOAP WCF web microservice APIs in C#, Angular 5, and React in Azure and Pivotal clouds.

Enhanced the functionality of the Dell Customer, Preference Management Center, and GDPR systems using C#, AngularJS, Web API, JSON, SQL Server, TFS, Git, GitHub, SharePoint, Atlassian Confluence, Jira, GreatBrains TeamCity, Octopus Deploy, Fortify, SSIS, Informatica PowerCenter, Boomi, Redgate SQL Compare, SonarCube, splunk, Elastic Search, Kibana, Postman, SoapUI, Riverbed, Pivotal Cloud Foundry, Pivotal Tracker, and Rabbit MQ.

Automated web application testing with MSTest, xUnit, and Selenium enabling test-driven development (BDD/TDD).

Documented GDPR processes with Microsoft Visio and Threat Modeling Tool. Mentored junior developers.

Sr. Web Application Developer and Architect

Rexel USA, Addison, TX (Apr 2016 - Aug 2016)

Contract with Experis, Addison, TX

Developed the new SupplierPortal.RexelUSA.com site using ASP.Net MVC 5, C#, Web API, JavaScript, jQuery, JSON, REST, WCF, Entity Frameworks, SQL Server 2012, TFS, Test Manager, and Redgate SQL Compare.

Implemented test-driven development (TDD) and security tests in MS Visual Studio and IBM AppScan.

Enhanced performance by converting data to use 4th Normal Form, integer primary keys, and cached dictionaries.

Mentored SharePoint developers and administrators on site design, taxonomy concepts, indexing, and deployment.

Sr. Web Application Developer

Cirrus Logic, Austin, TX (Nov 2015 - Mar 2016)

Contract with Insight Global, Atlanta, GA

Created dashboards for business processes using Telerik Kendo UI and Rad controls, k2 smartforms, k2 blackpearl, SharePoint 2013 & 2010, C#, ASP.Net, JavaScript, jQuery, JSON, and Team Foundation Server.

Sr. Web Application Developer

WorldPay SN, SecureNet division, Austin, TX (Feb 2015 - Oct 2015)

Contract with Insight Global, Atlanta, GA

Enhanced security and upgraded web applications with ASP.Net MVC 4, Razor, jQuery, Web API, JSON, AngularJS, REST, SOAP, and COBOL for managing merchants and processing credit card and ACH transactions.

Created Selenium unit tests along with SpecFlow, Gherkin, MS Test, Octopus Deploy, and TeamCity.

JOHN SOMMA

2

Sr. Web Application Developer and Architect

Accelerated Conditioning and Learning, Brentwood, TN (Remote Project) (Feb 2014 - Feb 2015)

Contract with Celera Group, Franklin, TN

Developed secure websites with ASP.Net MVC 5, Razor 3, Entity Frameworks 6, jQuery, AngularJS, Web API, REST, JSON, Bootstrap, and social media for managing clients, assessments, facilities, and health care providers.

Created SQL Server 2008 databases to support 3D-Dynamic Movement Assessment software and admin websites.

Created dynamic SSRS and PDF reports using iTextSharp, Google Charts, and Microsoft Charts.

Beta tested the system with the Houston Texans NFL football team and the Belmont University ladies' soccer team.

Sr. Web Designer

Mega World Studios, Austin, TX (Sept 2013 - Dec 2013)

Revamped the old Omegatech Game website using WordPress, jQuery, CSS, and Photoshop.

Taught web layout and graphic design techniques to the marketing director.

Sr. Web Application Developer

National Oilwell Varco, Houston and Cedar Park, TX (Dec 2011 - Aug 2013)

Contract-to-permanent through Insight Global, Atlanta, GA

Developed web applications in C# 4.0, ASP.Net, WCF web services, AJAX, jQuery, JSON, Team Foundation Server, MS Test automated unit tests, Vault, and SQL Server 2008 to monitor enterprise-wide blowout preventers.

Enhanced and developed HTML 5 canvas and drawings with vector graphics for hydraulic and electric systems.

Edited and rasterized engineering drawings for web images using AutoCAD, Illustrator, and Photoshop.

Exported and translated configurations from GE Fanuc Rockwell Automation CIMPLICITY.

Created technical specification documents based on project requirements and maintained a SharePoint team site.

Assisted the project manager and architect in conducting daily international status meetings.

Served on a committee to propose new technical specification documentation procedures and templates.

Mentored four developers in database and web development.

Sr. Web Application Developer

Texas Department of State Health Services, Austin, TX (June - Dec 2011)

Contract with TekSystems, Austin, TX

Designed and developed two web applications using VB.Net 3.5, ASP.Net, Oracle, and SQL Server 2008.

Tested for compliance with state and federal Section 508 accessibility laws.

Sr. Database Analyst

Pennsylvania Department of Aging, Harrisburg, PA (Remote Project) (Mar - June 2011)

Contract with Celera Group, Franklin, TN and Harmony Information Systems, Reston, VA

Developed T-SQL scripts to consolidate 52 county databases into one database for their state-wide SAMS and Omnia healthcare applications using Microsoft SQL Server Management Studio.

Sr. Web Application Developer and Architect

KB Kustom Homes, Austin, TX (Jan - Feb 2011)

Designed and developed a new website using jQuery, JavaScript, ASP.Net 4.0, C#, HTML, CSS, Visual Studio 2010, and Photoshop.

Sr. Web Application Developer

Blue Cross and Blue Shield of TN, Nashville and Chattanooga, TN (Remote Project) (July - Dec 2010)

Contract with Celera Group, Franklin, TN

Created two web applications using ASP.Net 3.5, C#, JavaScript, CSS, and SQL Server 2008 and 2005 for BCBS' Volunteer State Health Plan and state-authorized health provider agencies to exchange medical assessments.

Added reconciliation reports for the internal administrator site and more file download capabilities.

Sr. Web Application Developer

Dell, Round Rock, TX (Sept - Oct 2010)

Contract with Catapult Systems, Austin, TX

Developed web pages for Dell's Spectre Administration Console using C#, JavaScript, ASP.Net 4.0 with MVC 2, Prototype.js library, JSON, and CSS in Visual Studio 2010. Screenshots are available upon request.

Coordinated with managers and back-end developers to prioritize and complete the project in Agile sprints.

JOHN SOMMA

3

Sr. Web Application Developer

LifePoint Hospitals, Brentwood, TN (Mar - Sept 2010)

Contract with Santa Rosa Consulting and North Highland Consulting, Brentwood, TN

Developed HIPAA security risk reports with XML, XSLT, JavaScript, HTML, ASP.Net 3.5, TFS, CSS, and C#.

Created SSIS (DTS) packages, stored procedures, and views in SQL Server 2005 to update software product data.

Sr. Web Application Developer

Healthways, Franklin, TN (Dec 2009 - Mar 2010)

Contract with The Ettain Group, Nashville, TN

Developed several web pages and reports for the Operations department to track actual health program service levels.

Converted WPF XAML applications into one web-based, ASP.Net site involving Oracle databases, Microsoft Project and Excel libraries, PDF formats, and CSS styles extended from Healthways.com.

Sr. Database Analyst and Sr. Application Developer

ComData Processing Services, Brentwood, TN (June 2009 - Nov 2009)

Contract with CSI Tech, Brentwood, TN

Executed and improved monthly credit card transaction summary reports and billing processes.

Analyzed SQL Server 2005, Access, and Oracle databases. Fixed C# ASP.Net 2.0 applications and batch files.

Web Application Developer

Deloitte Services LP, Nashville, TN (Mar 2006 - Mar 2009)

Contract-to-Permanent through Rezult IT Staffing, Brentwood, TN (March - Sept 2006)

Developed and maintained several web applications for the Deloitte Audit and Consulting using SharePoint Designer 2003 & 2007 including custom workflows and web parts, C# 2.0 & 3.5 in Visual Studio 2005 & 2008.

Expanded web services for a SharePoint tool, edited SSRS reports, and coded complex stored procedures.

Enhanced high-visibility sections of the Deloitte US intranet site, DeloitteNet.com, used by 40,000 employees.

Fixed security vulnerabilities for the DeloitteConsulting.com as detected in IBM Rational AppScan.

Web Application Developer

Beanstalk Networks, West Palm Beach, FL (Feb 2003 - Dec 2005)

Developed web-based applications using MS Visual Basic 6, VB.Net, VBScript, JavaScript, ASP, XML, and XSLT.

Created 250 mortgage forms to be populated from SQL Server via ASP, XML, and Web Supergoo's ABCpdf objects.

Enhanced the functionality of enterprise-wide reports using ASP, SQL stored procedures, and web services.

Web Application Developer and Database Administrator

European Health Concepts and Out Front Inc., West Palm Beach, FL (Mar 2002 - Jan 2003)

Contract-to-permanent with Robert Half Technologies

Administered 3 MS SQL Server 2000 and numerous MS Access 2000 databases containing sales data of $110 million.

Improved web applications for marketing, reservations, mail operations, and accounts receivable using SQL and ASP.

Created credit card refund reports from SBT VisionPoint using MS Visual FoxPro and MS Access 2000.

Created an ASP e-commerce website featuring Adobe Flash video clips and a secure shopping cart.

Project Manager and Web Development Manager

Mutual Service Corporation, West Palm Beach, FL (May 2000 - Dec 2001)

Managed nine employees: 4 ASP web developers, 4 MS Visual FoxPro developers, and 1 graphic designer.

Led the complete upgrade of the main corporate website to serve customers and internal departments better.

Directed enhancements to company intranet and other websites.

Developed several reports for mutual funds and clients using MS Access 2000, Crystal Reports, MS Visual FoxPro.

Presented educational demonstrations to Registered Representatives and project overviews to managers and directors.

Project Management Database Administrator

Pratt and Whitney, Large Military Engines, West Palm Beach, FL (Oct 1998 - May 2000)

Contract with Arnold-Hanafin Corp., Boca Raton

Administered 17 Dekker Trakker project management databases with budgets totaling $227 million.

Created reports and required documents for U.S. Air Force and Navy project managers and financial analysts.

Fixed project database problems using diagnostic tools in MS Access 97, MS Visual FoxPro 6.0 and Oracle 7i.

Trained 25 users of Dekker Trakker project management software and updated training documents on Pratt’s intranet.

Explained earned-value management strategies and software to product managers and their assistants.

JOHN SOMMA

4

EDUCATION

SharePoint Solutions

Nashville, TN (2008)

Completed a Microsoft Office SharePoint Server 2007 course

Ted Pattison Group

Nashville, TN (2008)

Completed a Microsoft Office SharePoint Server course

Developmentor

Boston, MA (2007)

Completed a comprehensive course in C# 2.0

Global Knowledge

Tampa, FL (2001)

Completed PMI-certified course Project Mgt Essentials

C-TREC

Houston, TX (1998)

Completed certified course in MS SQL Server 6.5 Admin

Houston Community College

Houston, TX (1988)

Completed two courses in economics - GPA 4.0 / 4.0

Rice University

Houston, TX (1986-1990)

Completed 39 credit hrs toward BS in Mechanical Engineering

St. Thomas’ Episcopal School

Houston, TX (1986)

Graduated cum laude - GPA 3.6 / 4.0

TECHNICAL SUMMARY

Web and Application Software

Graphics Software

General Business Software

MS Visual Studio 2022 - 1.0

MS C# & VB.Net 4.6, 4.0, 3.5, 2.0, 1.0

MS ASP.Net 4.8, 4, 3.5, 3, 2, 1 (MVC)

MS Expression Design 3, MS Blend

MS FrontPage 2000, 98

MS IE 11-1/Edge 92 - 20

MS IIS 8, 7, 6, 5, 4

MS SharePoint 365, 2013, 2010, 2007

MS SharePoint Designer

MS Silverlight

MS VBA, VB Script, VB 6 - 3

MS WCF, ASMX/ASCX, WF, WPF

Adobe (f. Macromedia) Dreamweaver

Apple Safari 15 - 2

Angular, AngularJS 12 - 2

Crystal Reports 8.0, 4.6

CSS 3, 2, 1

Dynamic HTML, HTML5 canvas, svg

Google Chrome 122 - 1

IBM Rational Rose ClearCase, AppScan

JavaScript 7 - 1, JSON, EcmaScript

JetBrains ReSharper

jQuery 3.6 - 1.4

Android Studio, Android Browser 4 - 1

Mozilla Firefox 97 - 1

Node.js

PHP

Postman 9 - 7

Prototype JavaScript Library 1.6

Python 3.7, 3.6

React.js 17 - 12

SmartBear SoapUI 5.4, 5.3

TypeScript 4 - 2

WordPress

XML, XML Spy, XSLT

AutoCAD

Adobe Photoshop CS (Win) 6, 5, 4

Adobe Acrobat Professional 9, 8, 5, 4

Adobe Illustrator CS 6, 5; 10, 7

Adobe (Aldus) PageMaker 6.5

Adobe Premier CS 5.5, 5, 4.2

Adobe Go Live

Adobe InDesign CS 5

Adobe (f. Macromedia) Director 7, 5

Adobe (f. Macromedia) Flash MX, 5

Corel Paint & Draw

Dazzle MainActor Video 3.5

InkScape 0.92

IrfanView 4.52

Lotus Freelance Graphics 9

MGI VideoWave 4

MS Paint, Image Composer

MS GIF Animator

MS PowerPoint 365, 2013, 2010, et al.

MS Publisher 2007, 2003, 2000, 4

Quark Xpress 6, 5

Ulead VideoStudio 4

VideoScribe

Web and Application Controls

ArcGIS

Dundas Chart Controls

Google Charts

Infragistics Web Form Controls:

Ignite UI with HTML5 & jQuery

Telerik .Net UI Controls, Kendo

Web Supergoo ABCpdf

MS Excel 365, 2013, 2010, 2007...

MS Exchange Server 2007, 2003...

MS Great Plains Dynamics 3

MS Outlook 365, 2013, 2010, 2007...

MS Visio 2013, 2010, 2007, 2003...

MS Word 365, 2013, 2010, 2007...

Beyond Compare 4, 3, 2

Citrix ICA and MetaFrame

Corel WordPerfect 6

GE Fanuc CIMPLICITY 8

HP (formerly Mercury) LoadRunner

HP (formerly Mercury) WinRunner

InfusionSoft

Lotus 123 9, 8, 7...

Norton Anti-virus & Ghost

Salesforce

SBT Pro 6.5 (Accounting)

SBT VisionPoint 10

QuickBooks, Quicken

Source Control and Deployment

MS Team Foundation Server TFS 2019

MS Visual SourceSafe 6.0 a-f

Apache Subversion

Git, GitHub, Git Cmd

JetBrains TeamCity

NuGet Package Manager, NPM

Octopus Deploy

Sourcegear Vault

Tortoise SVN

Tunnelier

Test Software

MS Test

nUnit, xUnit, Selenium, SpecFlow

JOHN SOMMA

5

Project Management Software

Operating Systems

Database Software

MS Project 2007, 2000, 4

Dekker Trakker 5.0, 4.3, 4.2

Atlassian Jira, Confluence

IBM Rational Clear Case, BlueMix

Oracle Primavera P6 PPM, SureTrak

Pivotal Tracker

WorkFront (At-Task)

MS Windows 10 - 3.1/NT 2018, 2013

Android OS 10 - 1

Apple Macintosh OS X 10, 9, 8, 7, IIe

Atari

BeOS

IBM OS2, AS/400

Linux/Unix

MS SQL Server 2017 - 4.2

MS Access 2013, -10, -07, -03 - 2.0

MS Visual FoxPro 9, 7, 6, 3

Borland dBase IV, III

CA ERwin Data Modeler r9, r8...

Greenplum

MySQL

Oracle 12, 11, 10, 9, 7/ SQL Developer

pgAdmin/PostGre

Redgate SQL Compare Pro 4

Quest Toad 13, 10.6 & DataPoint 3.6

Teradata

ASSOCIATIONS

Linked In - Profile: www.linkedin.com/pub/John-Somma/a/622/428/

Kairos PM – Weekend Leader (2019), Financial Secretary, Advisory Council (2018 - present)

Toastmasters International - Club President (2002), Area Governor (2001), VP of Education (2000), VP PR (1999)

State of Texas and Other States - Life and Health Insurance Sales License (1996 - 1998)

Rice University Alumni Business Network - Planning Committee Chairman (1996 to 1998)

Junior Achievement - Volunteer Classroom Instructor (1996)

Children of the American Revolution - State Organizing Secretary (1987), Society President (1986)

Boy Scouts of America - Eagle Scout (1986), Assistant Scoutmaster (1990 - 1991), Chartered Org. Rep. (2005)

Contact this candidate