Kevin Connolly

Developer. Architect. Solver of Problems. Changer of Worlds.

Technical Skills

Limited Exposure

Career Experience

Verizon Business · Sr. Applications Developer II · 06/2007 - 06/2008; 11/2009 - 04/2010

Fujitsu Consulting · 11/2009 - 04/2010
Apex Systems, Inc · 06/2007 - 06/2008

• De Facto Lead Developer
• Analyzed, architected, designed, developed, deployed, and maintained a Web Application which provides extremely large customers a simple way to engineer and run complex reports against very large phone bills including historical billing data (C#, VB.NET, ASP.NET 2.0, AJAX, HTML, JavaScript, XML, SQL 2000/2005)
  • Enabled customers to design SQL queries without ever being exposed to the queries themselves
  • Obsoleted a legacy VB6 Windows Forms Application
  • Centralized data and software updates, greatly improving deployment scenarios
    • Analyzed and altered application for load balancing in multi-tiered environment
  • Reduced active Incident Reports from 700 to zero
  • Enabled real-time reporting against data in excess of 60 million rows / 30GB, per month, per customer, spanning back 13 months, with a 3-second response time
  • Implemented Data-driven, hierarchical user-data entitlement system; allows people at different levels of the customer organization to see different amounts of data at different levels within the hierarchy
  • Monthly imports of customer data with regularly changing data definitions without impact to report compatibility
  • Implemented a “Data Versioning” system to allow Applications to run queries against data of an incompatible schema
  • Upstream data structure was data-driven, due to the regularly changing schema of incoming data being an aggregate of 13 independent billing systems in 4 main formats with variations
  • Created complex functionality to implement data pagination throughout tables with millions of rows without support for pagination in SQL 2000
  • Facilitated sunset of legacy architectures and upstream data channels
  • Integration with external systems
    • Netegrity SiteMinder SSO system
    • Mainframe application to allow physical delivery of reports on CD, DVD, and FTP
    • Mainframe application to provide central management for Physical Address, Favorites, and Data Entitlements
• Analyzed, designed, and developed a Windows Service to aggregate and send raw data and large reports to users who want it offline (Windows Services, Web Services, C#, FTP, DB2, SQL 2005, XML)
  • Utilized third-party libraries to compress the resulting file by 95% and transfer it to mainframe via SFTP, to be delivered via external systems
  • Created a private web proxy which would download exported data files via the Web Server, despite being stored on a the Application Server.
  • Later altered application to store ZIP file data to, and retrieve from, SQL BLOB via binary stream (ADO.NET, SQL)
• Analyzed, designed, and developed a Monitoring tool to provide stakeholders and Development staff with key information about the current health of the application ecosystem, and the ability to drill down into more detailed information (Windows Forms, Web Services, C#, SQL, DB2)
• Analyzed, designed, and developed a Windows Service to perform regular maintenance on database (Windows Services, C#)
• Coordination with external contacts and teams
  • With Business to ensure adherence to work prioritization and schedules
  • With QA team to ensure timely delivery of code, manage defects, and map code changes to requirements (HP Quality Center)
  • With Mainframe Programmer to ensure interoperability with external, upstream, and downstream systems
  • With Technical Writers to maintain updated product documentation and integrated Help system
• Coordinated implementation of 5 Production servers
• Coordinated 2 Production SAN Storage implementations

Progressive Insurance · Sr. IT Applications Programmer · 07/2008 - 09/2009

Pomeroy IT Solutions

• Developed, enhanced, and maintained next-generation bulk E-mail processing engine (C#, Web Services, Windows Services, n-Tier Architecture, SOA, SQL 2005, DB2, XML, XSLT)
  • Migrated bulk E-mail architecture to a Windows Service and SQL Server 2005, eliminating dependencies on DB2, CA-7, and other mainframe systems to facilitate sunset of Mainframe technologies. Eliminated the need for a DB2 DBA and a COBOL Programmer, saving the company $150K annually
  • Identified SQL syntax and indexing improvements which increased message processing rate from 2 per second to 27 per second (Transact-SQL, Database Design)
  • Created a website to build and manage bulk E-mail campaigns, and to enable ad-hoc campaigns, thus eliminating the need for Developer and QA involvement, saving 40 man-hours per E-mail campaign (ASP.NET 3.0, AJAX, C#, SQL)
  • Created a website to run statistical analysis & reporting against volume in QA & Production environments, for administrative reporting and Production Support. Website reports on new Windows/SQL systems and legacy Mainframe/DB2 systems to provide migration effectiveness and status tracking during the architecture migration effort (ASP.NET 3.0, AJAX, C#, SQL, DB2)
  • Utilized Agile Methodologies and commensurate coordination technologies
• Migrated Email architecture Continuous Integration / Build and elevate process from CruiseControl.NET to internal/proprietary system ProMotion / ProTools.
  • Key figure in migration of Source Control repositories from Visual SourceSafe to Team Foundation Server
  • Organized hundreds of Project files together into Solutions with corresponding Namespace-based file structures
  • Resolved and mapped 400+ assembly reference dependencies - Corrected an issue where the wrong files and versions had been on Production servers
  • Functioned as a POC for a team of 130
  • Streamlined build process from hours to minutes
• Created an automated testing tool which eliminated the need for 60% of a project's testing staff
  • Enabled reallocation of resources, saving the company $180K annually
  • Reduced regression testing time from 5 hours to 10 minutes per Email Template, enabling 100% daily regression testing on all Email Templates
  • VBA, QTP, HP Quality Center, Mercury Test Director, SQL, DB2
• Analyzed, architected, designed, developed, enhanced, and tested assorted projects as required (C#, Web Services, n-Tier Architecture)
• Eliminated a discrepancy related to Paperless Billing retention; Avoided customer loss, prevented additional overhead; Saved the company up to $4 million annually
• Eliminated a discrepancy whereas 200,000 customers were accidentally unenrolled from an Email campaign; prevented major data quality issue in Production prevented loss of customer communication
• Identified an interdepartmental architectural anomaly which caused an issue where specific outgoing Emails were not being recorded; Prevented legal exposure
• Board Member, Deployment Coordination Advisory Board
• Board Member, Emergency Coordination Advisory Board
• Created and maintained product documentation (Design docs, SRDs, checklists, flowcharts, etc) (MS Office + Visio, Sharepoint)
• Coordinated with external teams to resolve external and upstream dependencies
  • With QA team to ensure expedient delivery of code, manage defects, and map code changes to requirements (HP Quality Center)
  • With Production Support to enhance training, ensure Production Certification & Readiness, and get history behind complex defects
  • With Business and Project Management to ensure adherence to work prioritization and schedules
• Some exposure to IBM MQ Series, Test Automation

CareCore National · Web Developer & IS Support · 05/2006 - 05-2007

• Developed intranet, internet, and extranet websites as needed (ASP.NET 2.0, VB.NET, SQL 2000/2005)
• Accomplished special projects for short-notice contract adherence requirements, assigned directly by CIO (ASP.NET 2.0, VB.NET, SQL 2000/2005)
• Developed a website that enables Contract Managers to manage customer accounts directly - eliminated the need for IT intervention (C#, ASP.NET 2.0, SQL 2005, AJAX)
• Developed web portals that allow new cases to be built over the Internet - Eliminated the need for a call center department (VB.NET, C#, ASP.NET 2.0, SQL 2005)
• Created an application that tests all incoming job applicants for required skills - reduced HR workload per applicant by 2 man-hours (C#, SQL 2005)
• Created a CSR metrics tracking system and WebParts used within multiple Sharepoint portals. Reduced the overhead associated with agent tracking; eliminated the need for a large spreadsheet system; eliminated duplication of effort and data loss caused by multiple people working on a spreadsheet at a given time (Sharepoint 2003, C#, SQL 2005)
• Some exposure to IBM AS/400 systems
• Implemented inventory tracking system
• Deployed remote equipment to employees, enabling office to utilize more people than they had physical space for
• Designed and Implemented new computer identification system, enabling IT to know which computers were at which cubicles, allowing fixes to be implemented remotely

US Air Force · Tactical Aircraft Maintenance Journeyman · 03/2002 - 08/2004

• F-15 Crew Chief
• Inspected, maintained, troubleshot, repaired, and coordinated maintenance activity on many aircraft, each valued at $30M
• Promoted to E-3
• Attained Skill Level 5 (AFSC 2A353A)
• Honorable Discharge
• Commander's commendation for perfect QA Scores on aircraft inspections, Launch & Recovery
• Identified and corrected numerous discrepancies (eliminating emergencies and damage)
  • Identified and replaced Leaking hydraulic switching valve, ensuring aircraft could land
  • Identified and removed foreign objects in engine intake area, preventing damage to $1.5M engines
• Received 4 recognition letters for outstanding performance
• Submitted 2 Deficiency Reports - saved unit $59K by improving processes and eliminating unnecessary rework
• Installed, inspected, serviced, replaced, repaired, and removed aircraft hardware and components
• Coordinated and performed application of external hydraulic, electrical and pneumatic power
• Performed operational checks of aircraft systems including flight controls, engines, landing gear, and cockpit controls
• Marshalled, launched, and recovered aircraft before and after flights
• Verified mission capability conditions
• Maintained, updated, and coordinated Aircraft maintenance documentation in CAMS computer system and paper 781 Forms
• Debriefed fighter pilots and flight crews to convert their description of problem descriptions into technical issues

Software Experience