C. V.

Experience
  • Digital Boundary Group - Application Security Specialist - Feb 2015 to Present
    • Perform controlled external and on-site manual and automated testing of internal and external customer applications and services to discover and exploit vulnerabilities such as SQL injection (SQLi), command injection, and cross-site scripting (XSS).
    • Tools used include Burp Suite, Acunetix, Nessus, Nmap, and sqlmap.
    • Write and review security assessment reports for delivery to middle-to-upper management.
    • Work directly with customers to explain how to remediate discovered vulnerabilities.
    • Understanding of surface area reduction, proxies, encryption, certificates and public key infrastructure, and secure data transmission and storage.
    • Familiar with OWASP Top 10; exposure to PCI DSS.
    • Minor development of internal tools, and maintenance of infrastructure.
  • Maplewood Computing, Ltd. - Senior Software and Database Developer - July 2010 to Feb 2015
    • Design, development, maintenance, and internal review of various applications, architectures, data models, and components, primarily using T-SQL, C#, VB.NET, and VB6.
    • SQL Server 2005-2012 management, administration, and configuration of several dozen internal, utility, and customer-hosting environment instances (over 3,200 production-tier databases under management).
    • Review clients' SQL Server instances for optimal performance, manageability, and backup strategy.
    • Deliver technical presentations on various SQL Server topics to client user groups.
    • ETL process implementation, including SQL Server Integration Services (SSIS) package development.
    • Performance monitoring and tuning of applications using techniques including workload and query plan analysis, wait statistics, Performance Monitor data collection, and index consolidation.
    • Exposure to: shared storage architecture and design; virtualization and clustering technologies (Hyper-V, Virtual Iron); Windows Active Directory architecture; SQL Server snapshot, merge, and peer-to-peer replication; SQL Server Reporting Services and Analysis Services; SQL CLR.
  • Stack Exchange, Inc. - Data Analyst - Jan 2011 to May 2012 (Contract)
    • Determine key metrics indicating quality site content, and help to improve the evaluation algorithm based on those metrics.
    • Using both publicly-available, and NDA private site data, write T-SQL queries (for SQL Server 2008 R2) and deliver analysis for crowd-sourced site statistics ideas.
  • PRL Info Systems, Inc. - Software Developer - Sept 2008 to July 2010
    • Help redesign and develop Pimarc, web-based project management software (C# ASP.NET, SQL Server, NHibernate), including rewriting and performance tuning of existing SQL reporting queries. (SQL Server 2000-2008)
    • Product manager, team lead, designer, and technical writer for an application that integrates a concrete batching control software web service and an accounting package. (C# WinForms, SQL Server 2005, NHibernate, web services)
    • Design, development and maintenance of an internal API to unify accounting package connection and manipulation. (C#, Intuit Quickbooks and Sage Peachtree SDKs)
    • Design and development of a client administration tool used to deploy software installations/updates and/or relational database metadata. (C# WinForms, SQL Server, web services)
    • Maintenance of a simplified desktop version of Pimarc. (VB.NET WinForms, Access)
  • Independent Startup - Software Developer - July 2007 to June 2008
    • Development of a retail point-of-sale system using VC++, MFC and PostgreSQL. Learned about patents and trademarks, project complexity estimation, and the need to have supporting business structures and processes in place to effectively run a software company.
  • Surface Science Western, UWO - Software Developer - Sept 2003 to Dec 2005
    • Contract software development using VC++ and MFC. Completed 2D and basic 3D functionality, and end-user documentation of ImageAnalyzer, a scientific microanalysis visualization app; and DataLogger, a utility to perform, automate, and record the results of electrochemical experiments.
    • Summer student in 2003 and 2004: time split doing software development and surface analytical work. Completed JobDatabase (VC++, MFC), a replacement for their paper-based work order system, and MultiInsertPicture (VBA in MS PowerPoint), a utility to arrange images on PowerPoint slides.
  • J. Seigel Footwear Inc. - Software Developer, I.T. Consultant - Aug 1998 to May 2018
    • Development of a website content management application. (VB5 WinForms; completed in 1999)
    • On-call for hardware/software troubleshooting/consultation/installation.

 

Certifications
Microsoft Certified IT Professional: Database Administrator 2008

MCITP: Database Administrator 2008
January, 2012

Microsoft Certified Technology Specialist: SQL Server 2008, Database Development

MCTS: SQL Server 2008, Database Development
August, 2011

 

Additional Skills
  • Proficient with:
    • Windows Forms in both C# and VB.NET using Visual Studio 2005-2013
    • Database and API unit testing
    • Application systems integration
    • Non-linear video editing and production using Blender
    • Graphic creation and editing using Photoshop Elements
    • User interface layout, design, and globalization
    • Reading, writing, and editing technical documents in English (technical writing)
  • Experience with:
    • Virtualization, clustering, Windows Active Directory, shared storage, SQL Server HA/DR features
    • Database persistence frameworks (NHibernate, Linq-to-SQL, Entity Framework 4.0)
    • Windows services, thread synchronization and task parallelization
    • Application architecture development and design
    • Version control systems (SVN, VSS, TFS, Mercurial)
    • Audio recording, composition, editing, and mixing using FL Studio
    • Digital SLR (DSLR) photography and video

 

Formal Education
  • B. Sc. Honors Specialization in Applied Quantitative Information Technology (Applied Mathematics) (Oct 19, 2007) from the University of Western Ontario (UWO/Western University)

© Jon Seigel