EXPERIENCE SUMMARY:

• 15 Years of Deep SQL Server development.
• 14 Years of IIS Web Development, Sites and Services.
• 12 Years of .NET Development. Middleware, Data Layers, Services, MSMQ, (+ AMQP Microsoft Azure Service Bus)
• 5 Years of MVC to support more RESTfull scenarios with IIS, .NET, WCF, Web API.
• 15 Years of Multi - Threaded Service Programming with C++, TCP/IP, Service Queues, Message Queues
• 11 Years of DevOps in .NET, NUnit, MS Test, Jenkins, Maven, Git and TFS environments.
• 6 Years of SharePoint, Dynamics CRM, GP-Great Plains, SalesForce and workflow customizations and Integrations.
• 15 Years of ETL, BI, and Data Warehouse Systems around SQL Server and ORACLE. (SSIS, SSAS, SSRS)
• 15 Years of including Operations and Support into Development from day one. (Not an Afterthought).
• 8 Years of Significant Virtualization and Off Site Cloud Hosting of Developed Systems (AWS, Azure, Rackspace).
• 2 Years of GIS with ESRI ArcGIS and the SQL Server Geospatial functions. (Silverlight, WPF, and SSRS Maps)
• Public Trust Security Clearance Government positions and background checks.
• Created a .NET XML web services that hid a highly proprietary data repository such that the .NET front ends thought they were connected to a SQL Server allowing traditional tools to be used against the Data Warehouse. (Solutions Now)
• Built an enterprise service bus and XML messaging system with extreme flexibility allowing any mobile police car in Kansas to submit and query real time web services. (State of Kansas)
• Replaced 20 year old interfaces with new .NET interfaces such that they were binary equivalent. (Security Benefit)
• Reduced the operations staff from 16 man-hours a day to 8 hours a day while the transactions increased 400%. ( Confidential )
• Built a central translation component connecting all law enforcement agencies throughout the state of Kansas. (Genesis10)
• Created a new product by repackaging existing code for a new market segment yielding 100% gross profit margin. ( Confidential )

PROFESSIONAL EXPERIENCE:

Confidential

Lead Developer / Architect / DBA

Responsibilities:

• Lead Developer / DBA for a Medicare Claim Analysis system. The SQL Server 2000 and 2005 Databases process over 200,000 new claims a day plus 600,000 new statuses a day. It also handles 10,000 medical eligibility requests per day.
• The .NET, C#, C++, system uses MSMQ queues to prioritize and distribute SQL Server requests from a processing farm of over 250 virtual servers that feed Claims into the system. The system also emails over 10,000 analytical Crystal Reports a day.
• Built C# and VB.NET based ASP.NET Websites, focusing on page and database speed.
• Responsible for designing and reconfiguring the network infrastructure to handle the always increasing volume of traffic and the special HIPPA Security and routing needs on the many different network physical and virtual segments, both internal and external.
• Develop the applications for transfer of the inbound and outbound data files to the many external computer networks.
• Created for DevOps a repeatable software build and deployment process so that any developer or operations member could compile or deploy the software with high confidence even though they may not have been the primary developer.
• Converted and merged the data from 3 separate SQL Server databases into a single common database model.
• The architecture and design of the core product allowed high margin products to be built quickly on top of the core product. - Specialized Medicare CWF FISS CMS systems are more accessible through the interfaces I built. (HL7, EDI, X12 837)

Confidential

Senior Web and .NET Developer (Senior Associate)

Responsibilities:

• Primary architect for all base and core services including ASP web page templates
• Projects involved building .NET C#, VB.NET, ADO.NET, and ASP.NET beta versions of key products; focusing on architecture, build environments, deployment, and production configuration.
• Development tools included VB, and C++ to build COM (COM+) based middleware application services between SSL IIS ASP web pages and SQL Server 2000 clustered databases.
• Developed all parts of the application including the client side (JavaScript), ASP.NET web pages, C# code behind files, COM+ middle tier services, stored procedures, and the SQL Server data models.
• Developed the core multi-threaded NT Services in C++ that support the production web sites and databases including services that process immediate responses to web site user requests via MSMQ (Microsoft Message Queue).
• Created a C++ TCP/IP data transfer engine that could punch through firewalls and routers and perform HTTP, HTTPS, and SSL based server authentications. Other C++ TCP/IP low-level tools were created for network discovery and asset analysis.

Confidential

Programmer / Analyst

Responsibilities:

• Created custom COM components and DLL's for geographical analysis and use by IIS, SQL Server 7.0, and MSMQ.
• Created multiple SQL Server eXtended stored procedures using VC++.
• Converted DLL's and COM objects from VB and MS Access to C++ XP’s that could be used within SQL stored procedures.
• VC++ DLL's allowed the company to move a significant revenue producer, from a VB/MS Access client only application to a SQL Server 7.0 client server application.
• These backend processes would handle over one million unique web visitors per quarter.

Confidential

Programmer / Analyst

Responsibilities:

• Developed desktop System Management applications that provide the capability to control and monitor remote Cerner Millennium NT, VMS, and UNIX processes. (A true SOA Service based architecture.)
• Helped to create a DevOps process and my specific libraries would be used in over 900 endstate binaries for the base build.
• Created a VC++ multi-threaded framework of DLL’s that allowed other developers to create “single threaded” VB DLL’s.
• These DLL’s were designed to behave like REST and WebAPI type of Active Server Pages (ASP) under IIS.

Confidential

Programmer / Analyst

Responsibilities:

• VB and SQL Server programmer that created large, heavy transaction claim payment and customer service applications.
• Designed and implemented database (Microsoft SQL Server) and VB programs from start to finish.
• Responsible for all DBA functions of development and production SQL Server databases.

Confidential

.NET DBA SQL Web Developer

Responsibilities:

• SQL Server Data Warehouse applications, SQL Reporting (SSRS), SSIS, and Web Service integrations. (SQL Server 2012)
• SalesForce web API Integrations. Microsoft Dynamics GP Great Plains Customizations, SharePoint, MVC Razor, jQuery UI.
• SQL Server query optimizations of 2000% and more. Sales Force Apex SOQL SOSL. Microsoft CRM ( XRM ) xVelocity VertiPaq.

Confidential

SQL Data Feed and .NET Developer

Responsibilities:

• Market data distribution warehouse system with 1000’s of external data feeds over Web Services and proprietary direct protocols using all .NET technologies to funnel raw data into the system. (1 million data points per hour). Typical projects involved SQL Server 2012, Web Sites (aspx, MVC, MVVM), Web Services (WCF, SOAP, and REST), MSMQ, stand-alone services, and all versions of .NET 2.0 thru .NET 4.5. These independent systems gave the illusion of a common data warehouse by using a common interface between the many different technologies. Typical Feeds were Reuters RMDS, DTN, and CME DataMine.

Confidential

Lead SQL Data Middleware .NET Developer

Responsibilities:

• Created a .NET middle tier data layer to connect SQL Server and ORACLE data sources with 4 independent Web Services. (WCF, SOAP) This acted like a data warehouse cube that was created on the fly to give a real-time view into the status of thousands of water sampling lab results. Entity Framework and LINQ drove the operational monitoring parts of the system.

Confidential

Lead SQL Server DBA .NET Developer

Responsibilities:

• Created a .NET SQL Web Service Data Layer and a SQL Datawarehouse for high speed stock market data streams. The consuming proprietary Non Microsoft systems needed pure web service interfaces (.NET / WCF / REST MVC / StreamInsight ) for multiple applications including Android and mobile apps (HTML5, Eclipse).

Confidential

Lead SQL Server DBA .NET Silverlight Developer

Responsibilities:

• Nuclear power plant Security Compliance and Event Auditing Tool as DBA Architect and .NET Silverlight developer. Created Nontraditional database schema with real time analysis. Rapid development with daily deployments based on daily changes of specifications. Supporting NERC NEI NRC Electrical and Nuclear Power Standards Requirements. Developed web service front ends based on the WCF RIA Silverlight design pattern. SSRS for Reporting SQL data.

Confidential

Contract Programmer/Analyst

Responsibilities:

• Complex project involving 4 databases (SQL Server and Oracle) and 50+ file feeds to many Wall Street funds. .NET Project to convert 250,000 variable annuity contracts from Allstate to Prudential.

Confidential

Contract Senior .NET Architect

Responsibilities:

• Used C#, and VB.NET to design and build a new IIS ASP.NET application that centralized all security and reporting features.

Confidential

Contract Senior .NET Developer

Responsibilities:

• Web application developer using C# .NET and ASP.NET to create a new interactive website and also integrate new .NET pages and assemblies into an existing IIS Classic ASP website. 60% of real estate agents in the U.S. used these sites.

Confidential

Senior Programmer / Analyst

Responsibilities:

• Used Visual Basic, Visual C++, and SQL Server to modify an existing application for a 300+ site medical laboratory VPN network in a time critical medical data application. System tasks included: migrating the entire database from Microsoft SQL 7 on a single server to a clustered SQL 2000 server in a DMZ. Moving client sites from the Internet POP in LA to a new VPN pointing to KC. To achieve this, created SQL scripts to move client data over as needed, keeping both sites live during the two-month transfer period.

Confidential

Programmer / Analyst

Responsibilities:

• Developed a Visual Basic / Visual C++ object oriented framework that all VB programmers used to build the GPI VB and VC applications. All Remote Data viewing was with Web Browsers with HTML, this was a radical idea in 1998 for this type of system.