Cooper Van Valkenburgh Email & Phone Number

Olathe, Kansas, United States

Forthcoming

Parkville, Missouri

Primarily focused around assisting clients with Microsoft SQL Server and Business Intelligence, but also providing guidance on other Microsoft applications and overall client infrastructure. Assisting clients with migrating SQL Server versions as well as a variety of performance tuning and scalability concerns. Advising clients on Disaster Recovery and High Availability using a variety of methods.

Kansas City, Missouri, United States

Interface with external consultants in building a global data warehouse utilizing Microsoft Azure stack technologies including Data Factory and Synapse. Responsible for ELT and data suppression for GDPR and PCI sensitive fields from U.S. data sources, and assisted other global regions in on-boarding to warehouse.

Mission, Ks

My primary focus is cost containment and risk mitigation. Over the course of my time with SkillPath I've reduced our annual spend by $500,000 while eliminating risk caused by old unsupported applications and operating systems.Managed team of System Administrators as well as Business Intelligence Analysts.Major projects include:Migration of our primary datacenter from 3rd-party hosting to on-premise hostingRedundancy via multiple internet providers through a combination of Azure DNS and local load balancingMitigated risk via migrating or elimination of workload of unsupported applications and OSes including:SQL Server 2000, 2005, 2008, 2008R2Windows Server 2003, 2008, 2008R2Windows 7Reverse engineered a number of undocumented legacy applications in order to either migrate them to new systems or rebuild on a new technology stack, including:IBM WebSphereRailoColdFusion 9-11Deployed Microsoft SCCM Current Branch for management of endpoints and Windows 10 lifecycle management, including patch management with 3rd party patching.

Overland Park, Ks

DBA in PCI regulatory space, working with multi-terabyte databases in SQL Server Availability Groups with cross-continental synchronization toplogyResponsible for migration of SQL 2012 and 2014 to SQL 2016. Researching, procuring and installing new availability group nodes and migrating services to them. Requirements gathering and design of reports in Power BI

Lenexa, Ks

My primary focus was creation of a new datacenter, from initial design through implementation. Responsible for all aspects, hardware, software, storage, networking. The datacenter was used during the final months of operation to allow us to bring in $2,000,000 in monthly revenueDatacenter technologies deployed:HyperVisor - Hyper-VGuest O/S - Windows Server 2016Load Balancer - F5Database - SQL Server Enterprise with Availability GroupWebserver - Microsoft IISSwitches - HPE FlexFabric Switches (Comware)SAN - NexGenFirewall - SonicWallAssisted in migration of a number of undocumented legacy systems to newer, including jBoss.Deployed Microsoft SCCM Current Branch for management of server and user endpoints.

Overland Park, Ks

Responsible for providing architectural guidance to technology team as well as database code reviews of Development TeamRedesigned legacy data warehouse ETL to reduce load times by 50% and designed new data warehouse to provide value to additional business units.Designed and implemented a new data warehouse to allow automation of a number of manual processes, resulting in savings of many hours per month.Tuned performance of a number of SQL processes to allow the business to process transactions per customer demand instead of being restricted to a lower volume by the technology team.Migrated clustered SQL Server environment from Windows 2003/SQL 2005 to Windows 2012 R2/SQL 2012.Coordinated and facilitated cross-departmental strategic planning to develop a multi-year roadmap for the technology organization.Coordinated budget, and handled purchasing and licensing for the technology organization.

Shawnee Mission, Ks

Working primarily with the Microsoft Business Intelligence stack utilizing SQL 2008 R2 to maintain and expand upon a data warehouse solution complete with Analysis Services. Responsible for design of data warehouse, ETL processing through Microsoft Integration Services as well as cube design in Analysis services.Also responsible for source controlling of database servers using Microsoft Team Foundation Server (TFS) and Visual Studio as well as administration of pre-production database servers.Standard DBA work as well.

Shawnee, Ks

Transferred into ProfitStars, a Jack Henry & Associates, Inc company.Responsible for Visual Studio Team Foundation Server Administration. Setting up code promotion model (branching strategy) and developing automated builds. Working with Visual Studio 2010, Windows Workflow. Custom workflows including automated deployment for all environments, including database deployments using Visual Studio Database projects.Responsible for managing pre-production systems configuration, i.e. Dev/QA environments.

Lenexa, Kansas

Successfully evaluated, recommended and implemented SAN storage solutions specializing on database servers. Administered SAN and monitored for performance.Continued to work on load balancing solutions, migrating from Radware to Cisco CSM to Cisco ACE.Implemented network analysis and monitoring solutions and worked extensively with development teams on application analysis. Worked with NetQoS, Coradiant and Network Instruments equipment. Provided forensics reports for sensitive issues upon need. Responsible for long-term monitoring across physical and virtual platforms that pinpointed critical issues in both Jack Henry as well as 3rd party applications.Designed and implemented solutions for both disaster recovery as well as concurrent simultaneous access (active/active) for multiple web facing products. Conducted numerous actual cut-overs as well as annual tests. Developed ongoing processes to keep the D.R. sites up to date and feasible.Developed server imaging solutions using Microsoft System Center Configuration Manager's operating system deployment. Implemented System Center Operations Manager and developed custom monitoring for environment. Implemented Microsoft clustering technologies. Familiar with both Shared SCSI clusters as well as SAN clusters.Administered more than 700 DNS domain names for Jack Henry clients, including reverse DNS zones. Worked with customers to implement Sender Policy Framework (SPF) records upon development of the SPF RFCs to reduce rejection of email.Responsible for server hardware selection until 2007. Evaluated and recommended hardware solutions for data center environments. Set up out-of-band management capability for servers, as well as provisioning redundancy within the systems. Responsible for migrating between different hardware vendors after evaluation process.

Overland Park, Kansas

Administered Secure Computing Sidewinder firewalls; also deployed initial load balancing at firewall and web tiers. Developed hardening procedures for server deployment and installation.

Overland Park, Kansas

Programmed interactive financial websites using ColdFusion. Responsible for converting mock pages into data-driven content with a SQL Server back-end. Also responsible for database design for SQL databases.

Lees Summit, Missouri

Intranet developer using Microsoft Active Server Pages.