Wesley Kennedy Email & Phone Number

Denver, Co, Us

In my role as Principal Engineer, I serve Switch Architecture's customers as an expert developer who can design, develop, release, and support every layer of a software platform. I am accountable for projects being delivered on-schedule, on-budget, with the highest quality standards, and meeting or exceeding the client's expectations and requirements.PROJECT EXAMPLES• The rapid development of a consumer-facing web app and REST API for opening, funding, and gifting to college savings plans. Primary technologies were React and .NET Core v3. Azure SQL DB, App Service, Functions, and Storage features were used for a serverless platform. Numerous integrations include Docusign for knowledge-based authentication and digital signatures, and Plaid for financial account linking.• Data warehouses and integrations for customers in the healthcare, manufacturing, warehousing, and supply chain industries.• Integrations with e-commerce and product management platforms including Magento, WooComerce, and Salsify. Includes automation of product changes, near real-time management of on-hand quantities, and fulfillment of customer web orders through ERP integrations.• ERP and warehouse (WMS) integrations for sales orders, products, inventory, shipping, and forecasting.• Salesforce Marketing Cloud integrations for near real-time synchronization of leads and accounts with ERP for customer interactions via e-mail and SMS.• Salesforce custom object development and integrations with ERP system. Includes custom objects, tasks, and flows.• Numerous BI and reporting platforms built with Looker, Tableau, and SSRSSKILLS USEDSQL ServerT-SQLNET Core v3React, BootstrapREST API development and integrationAzure App Services, Functions, and Storage (Serverless)Azure SQL DB and Data FactoryAWS RDS, S3, VPCOracle, PL/SQLPostgresSSIS and SSRSSalesforce development and administrationNodeJS, PythonLooker, TableauDependency Injection, Service Layers, and SOLID principles

Denver, Co, Us

I co-founded Switch Architecture to give customers a way to access expert software engineers, integration developers, data architects, and DBAs without having to spend months recruiting, interviewing, and competing for the best people. As a technology leader, I saw the constant effort being spent on recruiting. I also saw the risk it brought to the product roadmap and company vision if leadership wasn't able to add the right people to the team at the right time (or worse add the wrong people to the team).Many of Switch Architecture's engagements can be described as "rescue" projects where a project is behind schedule, over budget, and at risk of failure. These engagements typically begin as a code review to help stakeholders understand exactly what has been delivered and the actual effort required to complete the project. In most cases, Switch Architecture's experience can help bring the project over the finish line in an expedited manner.

A brief period of independent contracting for multiple customers prior to co-founding Switch Architecture.PROJECT EXAMPLES• Senior database engineer supporting an established team with the design, development, and rollout of a large healthcare Data Warehouse and the ancillary processes, tools, and integrations that support and drive it.• Architected and implemented an enterprise job scheduler platform for executing a high volume of scheduled ETL processes (SSIS). Used a Producer/Consumer solution with an intermediate job queue mechanism to support throttling and prioritization.• Served client as an expert technical resource and appeared before a federal judge in United States District Court to perform a technical demo, share findings, and answer questions related to product features and capabilities.• Triaged a sudden increase of deadlocks in a production OLTP system. Provided development team with an explanation of behavior and a recommended solution to lower the deadlock rate to zero.• Implemented and supported a transactional replication topology in a large federated SQL Server environment.• Implemented development patterns, identified limitations, and defined best practices for a development team's use of the new temporal (history) tables feature in SQL Server 2016.• Developed complex SSIS packages and assisted the development team with the creation of SSIS development patterns, best practices, code reviews, and optimizations.• Supported production applications through complex extracts and DML queries.• Advised clients on maintaining HIPAA compliance in the Amazon Web Services cloud.

Nashville, Tn, Us

I'm glad to have been an early member of the Medalogix team - winner of the 2016 Nashville Technology Council's "Early Stage Company of the Year" award.In multiple roles as Director of Engineering, Vice President of Engineering and Principal Engineer, I assisted the company in reaching major milestones by providing expert vision, execution, mentorship, and support at every level.Contributions include:• Member of the company’s Senior Leadership Team and accountable for all technology team activities.• Recruiting for current and future engineering positions.• Served on the web application (C#, ASP.NET MVC), database (T-SQL, SQL Server), systems (AWS, Windows Server), risk/security/compliance, corporate IT, and integration teams as both a peer and servant leader.• Provided architecture, development, release, and project management support during the delivery of three new customer-facing predictive analytics products.• Migrated enterprise platform to the AWS Virtual Private Cloud to reduce costs and improve uptime. The result was a 50% reduction in monthly infrastructure costs, 99.998% uptime, and reduced RTO/RPOs.• Served as an engineer in the development and support of a multi-tenant, federated data warehouse that utilized many shards for horizontal scaling, table partitioning for low-impact data loads, and peer-to-peer transactional replication for global configuration management.• Design, implementation, and support for multiple partner data integrations.• Executed annual HIPAA Risk Assessment program and completed regular security questionnaires from prospective and current clients. • Chartered a formal Information Security Program to ensure proper security controls are in place and to prepare the company for a formal SOC II report. Added a full-time IT Security, Risk, and Compliance Manager to manage security policies, training, and systems.• Accountable for the creation and completion of the company’s technology, security, and IT roadmaps

Louisville, Co, Us

Senior engineer on the Contract Center Xpert (CCX) application used by healthcare providers to maintain accurate contract item pricing through real-time purchase order price validation backed by an ASP.NET MVC web application detailing pricing history.The CCX OLTP database persisted pricing data for 4 billion healthcare items and 8 million healthcare contracts. The application received over 2 million item price requests each day from other services in company’s global product suite. These complex requests were satisfied with an average duration of 25ms through effective query tuning and database design.My role included database, web, and application development responsibilities with an emphasis on query optimization, data architecture, and ETL processes using Microsoft SQL Server 2008 R2 and the Microsoft .NET framework (C#).I also served in a rotating Scrum Master role for our Agile team which used the Kanban methodology.

An early-stage company working to innovate and improve how private companies manage their cap tables and perform analysis on outcomes of potential exit scenarios.As an early member of the company, I served as the web application developer, but also in a jack-of-all-trades IT and sysadmin role as the company's network, employees, and building space grew.• Developed a web-based SaaS application using ASP.NET 4.0, C#, SQL Server 2008 R2, AJAX, WCF Web Services, and Javascript in a RAD development lifecycle• Administered SQL Server databases and instances; administered Windows Servers, corporate network, Active Directory, VPN, and workstation/server backup policies.• Installed and administered the JIRA issue management system and SVN source control repository.

Louisville, Co, Us

• Administered more than 1,200+ databases on 25 SQL Server instances in a 24x7 enterprise environment; identified and improved performance bottlenecks and slow queries; researched and tested the virtualization of the SQL Server instances using VMware.• Led the SQL Server DBA team; trained development teams on SQL Server development best practices, design, and data modeling; authored a roadmap for the SQL Server team to improve our processes to conform to best practices.• Experienced clustering, table partitioning, SSIS and DTS, VMware virtualization, high availability, full text indexes, SAN performance research, version upgrades, Reporting Services, locking and blocking research, query optimization and tuning, statistics research, CLR usage, memory management, and tool evaluation.[I left GHX after just ten months due to an opportunity to join a startup company founded by my mentors at Investment Scorecard. I returned to GHX to continue my work in November, 2011.]

• Managed database security, database server builds, data refreshes, and database backups and restores.• Configured and maintained replication publications and subscriptions (1-way and 2-way transactional).• Experienced working with Very Large Databases (VLDB) (approx. 1 terabyte of data per environment), federated SQL Server environments, replication, and clustered SQL Server environments.

• Wrote complex SQL queries in a large, replicated database environment using stored procedures, user-defined functions (scalar and table), and views.• Developed internal enterprise applications using T-SQL, VB.NET, C++, and VB6.• Designed, implemented, and maintained database tables, primary and foreign keys, indexes, and triggers; researched and extracted data using a combination of T-SQL programming constructs.• Participated in the company’s test-driven development initiative by writing unit tests using the T-UNIT framework and Microsoft Visual Studio 2005 Unit Testing.• Participated in the company’s Software Development Life Cycle by reviewing business rule definition documents, writing technical specifications documents, and reviewing Quality Assurance test plans.The company was sold to Informa Investment Solutions for $50MM in March, 2007.

Bachelor Of Arts, Computer Science

Associate Of Science, General Studies