.NET/Sql Server Software Engineer

James Edward Brock III e-mail: ******@********.***

Technical Skills:

Technical Management: Successful technical management, technical leadership and mentoring, technical architecture, and all phases of development.

Software Development: Over a decade of experience designing, developing, and ensuring the quality of advanced, mission-critical n-tier software systems, primarily using ASP.NET and relational databases such as SQL Server.

Primary Current Technical Skillset:

Excellent hands-on development and team leadership skills using the following tools among others:

Microsoft .NET Framework (Versions 1.1 (obsolete), 2.0 – 4.5 advanced. About 13 years of experience). Business and mid-tier logic via ASP.NET, MVC, and WCF using both SOAP and REST SOA communication techniques.

C# (About 13 years of experience.)

VB.NET (About 4 years experience.)

PHP (Through version 5.4 - About 3 years experience.)

Database Programming, Data Modeling, and Administration: Microsoft SQL Server and T-SQL (through 2014 Version of SQL Server) and Azure SQL Database – 14+ years experience). Oracle PL/SQL (2+ years experience.) Stored procedures, triggers, query optimization in both environments. MySQL (~ 2 years experience). Database design, administration, and tuning (10+ years experience). Also Microsoft SSIS, SSRS, SSAS.

JavaScript, jQuery, jQuery UI, AngularJS, Smarty, HTML,CSS, and YUI 3 (about 4-5 years experience.)

Crystal Reports (Versions 9-11 (XI) – 3+ years experience with Visual Studio integrated and standalone editions.)

In-depth experience with the Visual Studio IDE, through Visual Studio 2015.

Experience with SCM tools, including TFS, SVN, Perforce, Mercurial, Git, etc., to provide version control, change tracking and management, and relate software modifications to continuous improvement.

Overall Skillset:

Advanced knowledge of n-tier software engineering, using C# and .NET/ASP.NET Frameworks, SOA web services and WCF (SOAP, REST, MVC, MVVM), VB.NET, Web Forms, Windows Forms, WPF/XAML, WCF, JavaScript, UML, XML/XSD/WSDL/XSLT. Experience/knowledge with WinRT/Windows 8, SharePoint, MFC, Win32, C/C++, TCP/IP Sockets, ASP 3.0 (Classic ASP), Crystal Reports, PHP/LAMP.

Design Experience: Extensive experience in system design and architecture in addition to development, performing usability analysis, encryption and other techniques for secure transaction processing, interface design, business object model design utilizing Separation of Concerns, SOLID principles, n-tier architectures, RESTful interfaces, highly scalable/available/reliable systems, numerous Design Patterns.

Databases: Extensive RDBMS programming, design, administration, and performance tuning experience, including MS SQL Server 2000 – 2014 (including T-SQL, Triggers, DTS/SSIS, SSRS, Analysis Services), Azure SQL Database, Oracle (PL/SQL, Triggers), MySQL, and DB2. Also OLAP techniques (e.g., cube design, MD querying, BI architecture best practices), data warehouse design and workflow principles, ETL tool experience. Experience with petabyte scale and high transaction volume database applications and design.

Methodologies: Strong Object-Oriented Analysis, Design and Programming, with emphasis on component reuse and design pattern implementation. Primary methodologies and disciplines include UML usage, Agile methods (e.g., Scrum, Kanban), Architecture Patterns, SEI CMMI, GUI Design and UX, Automated Testing.

Education:

Harvard University: Intensive Study Program - Computer Science and Astrophysics

University of Chicago: BA, Economics, with minor concentrations in Computer Science, Physics, and Mathematics. (Merit Scholar, Grumman Scholar)

Work Highlights

Sierra Mountain Webs (South Lake Tahoe, CA – remote part-time work from Las Vegas, NV and Sacramento, CA)

Senior Software Developer, March 2003 – Current (Consultant)

Developed and maintained C#/ASP.NET software for internal business and client management support (e.g., CRM and e-commerce) for this firm. Developed PHP scripts and authored/edited copy supporting the primary customer-facing websites for the company, using MySQL, Oracle 10g-11g, SQL Server 2008 R2 and SQL Azure as data stores, web server management and configuration (Apache and IIS), and specification of custom solutions for clients, using LAMP and/or ASP.NET and WCF technologies. Also used jQuery and Angular frontend frameworks/libraries. Provided management consultation on technical architecture and marketing/business development strategy.

Selected Contract Engagements

Veterans Administration Hospitals (Remote position with meetings in Sacramento, CA)

Software Developer, December 2016 – Current

Modified an existing recruitment and staff hiring workflow system to interface in real-time with an existing organizational tracking and reporting system. The modifications were ReST-based and implemented primarily in JavaScript, with some ASP.NET and PHP components.

Maintenance Connection (Virtual Team – Locations across the US)

Software Developer, June 2016 – Current

Created software functionality to implement Single Sign-On for an industry leading cloud-based computerized maintenance management system (CMMS). The solution built was able to seamlessly many simultaneous tenants using various industry-standard Identity Providers such as Active Directory, ADFS, Azure, Amazon Web Services, as well as generic standards such as LDAP, OAuth2 and SAML-P. The development environments and tools used included ASP.NET/C#, Classic ASP, SQL Server, and JavaScript/jQuery among others.

Sentry Data Systems (Virtual Team – Locations across the US)

Software Developer, April 2015 – May 2015

Assisted with development of PHP/MySQL software to manage government mandated prescription pricing programs (340B) for participating hospitals and pharmacies nationwide. This also involved the use of the Symfony framework and Smarty templates.

Teleplan (Roseville, CA)

Software Developer, New Product Implementation, October 2014 – January 2015

Developed C#/ASP.NET software to manage the tracking and work flow of aftermarket repair, refurbishment, and resale of various electronic equipment, including smartphones, computers, and routers, so that each asset and any defective components and their replacements were tracked precisely through the entire process from receiving to return shipment. The client my group was working with was Cisco (for North, Central, and South America). Technologies used included C#, ASP.NET, WCF, SVN, TFS, Oracle 11g, and SQL Server 2008 R2. Also designed/developed automated push deployment procedures using MS Web Deploy and its IIS add-ins. Agile Scrum methodology used.

Applied Knowledge Solutions (Las Vegas, NV– remote work from Sacramento, CA)

Senior Software Developer, May 2014 – August 2014

Developed C#/ASP.NET software for Nevada’s largest roofing and solar panel construction/installation company. This system also utilized Telerik DevCraft controls for the UI, SQL Server 2014, the Dapper ORM, and Crystal Reports. The system manages many aspects of the company’s field construction processes, including scheduling, cost estimation, and asset utilization.

Intel Corporation, Folsom, CA (Contract Position)

Database Administrator, November – December 2013

Short term project to assist with database administration and ETL tasks for the database storing manufacturing quality control information for all Intel Solid State Drive manufacturing, to provide extra resources during a database restructuring effort.

BarNone Auctions, Rancho Cordova, CA (Consultant)

Software Engineer, August 2013 – December 2013

Short term project to develop user interface and server software for querying past auction results to assist bidders in pricing prospective bids. Implemented using PHP, JavaScript (with jQuery and YUI3) and MySQL.

Consultant to TechEvents, Rocklin, CA

Senior Software Engineer, June 2013-July 2013

Very short term project to assist in implementing simultaneous beta testing of ASP.NET software and production use of legacy ASP systems, and provide consultation on software architecture/standards and refactoring strategies.

Intel Corporation, Folsom, CA (Contract Position)

Software Engineer, August 2012-October 2012

Worked developing an Intelligent Virtual Assistant interface to Natural Language Processing technology, to enable free-form chat-based access to the Intel knowledge base, using an ASP.NET 4.0 web services, WCF, C# and JavaScript/jQuery Agile Scrum methodology used.

Intel Corporation, Folsom, CA (Contract Position)

Software Engineer, July 2011-March 2012

Worked in the Software Automation Factory/Visual Processing/Parallel Processing group enhancing and maintaining driver kit building and assembly. Participated in OO Design and Development and Database Administration using .NET 4.0/C#, SQL Server 2008 R2 (T-SQL), and other technologies using agile methodologies. Helped define/design the next-generation SOA (MVC and REST on WCF) architecture by which Intel can assemble and distribute drivers for their market-leading chipsets to OEM’s, Microsoft (Windows Hardware Quality Labs, or WHQL), and other industry participants. Strict adherence to Agile Scrum methodology employed.

International Academy of Design and Technology (Las Vegas, NV)

Instructor, June 2010 – August 2010

Taught courses in computer programming using C# and introductory game design using the (now deprecated) Microsoft XNA Framework, used for computer game design.

Consultant to Voip.Com (remote from Las Vegas, NV)

Software Developer, November 2008 – February 2009

Consulted on the conversion of a sales and billing system between the Classic ASP and ASP.NET environments.

Consultant to Adaptive Information Technologies, LLC (Las Vegas, NV)

Senior Software Engineer, Consultant, January 2008 – February 2008

Developed a .NET 2.0 Windows Forms based application to provide automated construction supervision and scheduling capabilities for field supervisory staff, using VB.NET 2005, SQL Server, Gantt charting tools, and DevExpress.

Consultant to Pinnacle Entertainment, Inc. (Las Vegas, NV)

Senior Database Marketing Consultant/Manager – November 2007 – December 2007

Developed SQL Server DTS and SSIS packages as well as T-SQL stored procedures and scripts used to analyze marketing promotional campaigns, for the purposes of optimization, customer retention, and predictive analytics. Utilized interdisciplinary skills in computer science and econometric analysis to meet urgent Executive level needs for actionable Business Intelligence information, as well as provide recommendations for Pinnacle’s Marketing Data Warehouse. Configured and administered the SQL Server 2000 and SQL Server 2005 database instances used for this effort.

eCommLink, Inc. (Las Vegas, NV)

Senior Software Engineer May 2007 – August 2007

Led design and development of the file-level cryptographic tools for the core business application, using C# and the .NET Cryptography Services to provide strong file encryption to meet the requirements of the PCI Data Security Standard, using asymmetric and symmetric cipher algorithms such as RSA, DH, AES, and 3DES. Led the development of automated file transfer, using any URL-based protocol such as FTPS, SFTP, HTTPS. Guided the preliminary design of automated data archival/retention polices to conform to PCI and industry Data Security Standards. This was a core tool enabling eCommLink to meet the most stringent requirements for data security in the Payment Card Industry.

Used SQL Server 2005 Enterprise tools to tune the database to meet the sub-second response times for electronic funds transfers, and position the architecture to maintain this Quality of Service as business volume increases by a factor of ten.

CashSystems, Inc (Las Vegas, NV)

Senior Developer, October 2006 – March 2007

Created the architecture, logical, and physical design for a multi-enterprise distributed system to interface with multiple external systems for financial transfer in the gaming industry. The technical environment was Visual Studio 2005 Team Suite and Team foundation Server, IIS, C#, NET 2.0, using Web Services, TCP/IP, .NET Remoting, WSE 3.0 and the WS-Security (X.509 certificate) model.

Consultant to RasterMedia, LLC (Las Vegas, NV)

Senior Software Engineer, July 2006 – September 2006

Implementing a T-SQL and .NET 2.0 interface to the Microsoft Small Business Accounting system to allow the management of company accounts, using information submitted by non-accountants that is reviewed in near real time by a professional accounting firm, leading to better management of the client companies and avoidance of quarterly and year-end “crunch” time for the CPA firm.

Consultant to Progressive Gaming International Corp. (Las Vegas, NV)

Senior Software Engineer, March 2006 – April 2006

Designing an ASP.NET 2.0 software system for an Electronic Gaming Machine control and business intelligence system using UML design methodology, targeting Web Forms and AJAX for the GUI interface, C# as the implementation language, .NET 2.0 Sockets and .NET Remoting for communication across computer and AppDomain boundaries, Microsoft SQL Server 2005 for database storage, and Microsoft Reporting Services for reports and charts.

Advanced Information Systems, (Las Vegas, NV)

Software Developer Consultant, October 2005 - March 2006

Developing ASP.NET software for a mission-critical event management application employed at major conventions in Las Vegas and nationwide, using Web Forms and Telerik controls for the GUI interface, C# as the implementation language, SQL Server 2005 for database storage and Crystal Reports for reporting.

Consultant to Apogen Technologies, April 2005 – May 2005 (Las Vegas, NV)

Systems Analysis Consultant

Performed systems analysis and design using the Unified Modeling Language (UML) for a system to manage all records of the US Department of Energy dating back to the initial development of strategic weapon systems, using a J2EE business layer and Java SWT GUI. This system will eventually manage approximately nine petabytes of data (9,000,000 gigabytes) using Oracle

Consultant to Rio Las Vegas, April 2004 – May 2004 (Las Vegas, NV)

Graphic Artist Consultant

Created print advertisements and promotions for Harrah’s Inc, as well as for inclusion in various entertainment publications in the Las Vegas area, primarily using Adobe Photoshop.

Info Tech, February 1986 – February 2003 (Gainesville, FL and remote from Lake Tahoe, CA) (Selected Projects)

Technical Lead, R&D

Led and advised numerous research initiatives, including early XML and XSLT research, MS .NET technical evaluation, n-tier architecture research, and research of automated test management systems. Served on and chaired ad hoc committees tasked with evaluating strategic technologies for achieving strategic business objectives of the company, and developed software proofs of concept.

Designed and led the development of a Generalized Importer framework/class library, using C++. This system allowed data to be imported into an arbitrary database while enforcing the relational and business integrity constraints of the target system. It was highly configurable using XML-specified rules, and was similar to but provided more database integrity than ETL solutions available at the time.

Authored and provided expert direction for numerous trade articles relating to the software developed by Info Tech and the future strategic directions of the company, as well as project proposals, technical documentation, and research white papers. Principal contributor to the strategic direction reflected in these documents.

Senior Manager (Director Level Position)

Among many other projects and responsibilities, Managed the development of Trns•port™, an award-winning, enterprise-wide suite of multi-tier operational and analytical software systems, used in over 40 state Departments of Transportation and several different countries in Europe and Asia. This was a multi-year-multi-phase set of projects, involving several different teams. Duties involved directing team staff (varying from 5 to 20 members over time and projects), authoring several proposals and work plans, marketing proposals to clients, managing and responding to client needs, directing and supervising full SDLC efforts, using advanced object-oriented, n-tier, user-centric GUI architectures, as well as effective modern SDLC methodologies. The system software targeted multiple databases including Oracle, DB2, and SQL Server. This modular yet integrated suite of systems provided multi-million dollar annual savings for many Info Tech clients.

Technical Lead

Led a team in development of the Report Template Facility™: This is an end-user reporting language interpreter developed to allow clients to extract desired information from application databases and create custom reports. It is integrated with DB2, Oracle, and Sybase databases via a DBMS abstraction layer. Developed the Report Template Facility language syntax and grammar, and designed the lexical analyzer, parser, and code interpreter. Also authored the system and user documentation.

Led the design and development of a load-balancing, distributed, asynchronous job-scheduling facility to handle the queuing, dispatching, monitoring, isolation, and general control of asynchronous long-running application services. This subsystem allowed an arbitrary number of clients to queue and invoke parameterized “jobs” on 1 to n load-balanced servers in an asynchronous manner, and monitor or cancel the processes invoked, thus offloading resource-intensive work from the client and permitting the client to perform other tasks. Any output “reports” produced was then made available to the invoking client.

Contact this candidate