We are an IT solutions provider specializing in Systems Integration, Data Warehousing, and ETL processing. With over 15 years of experience in the ETL domain, using industry best practices, to help customers meet their data needs.

Our specialty is IBM DataStage (up to version 11.7.x) where we provide services including, but not limited to development, code migration, testing, deployment, tool administration, installation, configuration, automation, etc.

Updated 4/18/2024 - We have recently expanded our offerings to include Excel spreadsheet enhancements. Contact us to get more information about how your Excel spreadsheets can be improved based on your use case.

Scroll down to meet the team.

About

Vance Warnock - Owner

Follow me on LinkedIn:

University of Colorado - 2019-2024 - Employed as a Principal Data Warehouse Engineer in the higher education domain. I maintained ETL code base, ETL standards and operating procedures, SDLC practices. Also provided mentoring, code reviews, testing, deployment, and production support for the DataStage, Oracle, Red Hat, Perl, and SAS code base.

Sirius Computer Solutions - 2014-2019 - Served as a Solution Architect, Implementer, and Consultant for a leading IT Solutions Integrator where I specialized in IBM InfoSphere Information Server based solutions, including DataStage (up to v11.7.x). Data was hosted on DB2, Oracle and Netezza databases.

Western Union - 2013-2014 - Worked as Data Warehouse Engineer where I designed and implemented ETL solutions using IBM DataStage and Netezza. Implemented innovative ETL code frameworks and data quality practices to extract meaning from the customers data.

Crop Production Services - 2010-2013 - Contracted as an ETL Team Lead for a leading Agricultural Retailer. Generated a consistent code base for the customers ETL processing, using DataStage & Netezza. Made extensive use of Change Data Capture ("CDC") to minimize processing times.

Where I've worked

I have worked in Data Warehousing for 15 years utilizing various applications to deliver custom solutions in industries such as telecommunication, retail, insurance, transportation, finance, and publishing. I have specialized in IBM's DataStage ETL tool as well as other tools in the InfoSphere Information Server suite.

After several years of working for various employers, I decided to try my hand in a more independent venture, so I expanded my existing consulting business into a full-time endeavor.

I enjoy the challenge of coming up with innovative solutions using best-in-class applications combined with code frameworks that provide a comprehensive results.

When I am not working, I enjoy time with family, fly fishing, camping, and hiking.

Vance Warnock

I have recently started my new adventure, in IT, as an application developer where I provide software development services for customers. My recent projects have focused on Excel based solutions.

I completed a software development course last year where we made use of Python, JavaScript, Java, SQL, React.js, and Flask for algorithm development, coding, debugging, testing, and building of full-stack and software applications.

When I am not working, I enjoy Magic: The Gathering, spending time with my wife and four kids, and working on computers.

Where I've worked

Warnock Consulting - 2023-2024 - Worked as an application developer where I created various tracking spreadsheets to support a local landscaping company.

HOM Solutions –2023-2024 - Provided support for a warehouse dealing with customer service, inventory management, and scheduling of materials.

DevCodeCamp - 2023 - I began a new journey in the IT industry where I completed a course in software development. The course covered a number of different industry standard tools and utilized proven development techniques.

ILG - 2021-2023 - Provided customer service regarding installation questions, Scheduled crews to install flooring in Colorado Springs area for new construction projects, Hybrid work schedule, Partial warehouse work including Forklift operation, Heavy use of Microsoft Office and Zoom to coordinate with other offices. Comparing schedules provided by builders on a daily basis, managing schedules provided by builders, worked closely with a team of schedulers, dispatching subcontracted crews to job locations. Used SAP for scheduling.

Carpet Exchange - 2015-2021 - Direct customer service on a daily basis, answering customer questions, managed expectations, inventory management, employee management, hiring, scheduling, forklift operation, direct work with sales staff, ordering material, receiving shipments, managing subcontractors, and inspecting recently installed jobs.

Gavin Warnock - Application Developer

Follow me on LinkedIn:

Gavin Warnock

Our Location

Based in Colorado Springs, Colorado, USA
Working Hours

Mon-Fri: 7am-6pm MT

Work outside Colorado

Remote project and services engagements based on a SOW.

vance@warnockconsultingcolorado.com

Our Email