Lance Kolie

Lance Kolie

Independent Business Intelligence Architect / Senior SQL Server DBA at Opportune Tech

Kansas City, Missouri Area
Information Technology and Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Lance Kolie know in common
  • Get introduced to Lance Kolie
  • Contact Lance Kolie directly

View Lance's full profile

Lance Kolie's Overview

  • Senior SQL Server DBA at Sprint
  • SQL Server DBA Consultant at Green Dreams Inc.
  • SQL Server DBA at Nations Holding Co
  • Programmer / Systems Analyst at Transpo Services Limited
  • University of Central Missouri

500+ connections

Lance Kolie's Summary

Dedicated to achieving intrinsic value for clients by leveraging my 15+ years of professional experience building solutions on the Microsoft platform, specifically related to Microsoft SQL Server and Business Intelligence Systems. Whether its performance tuning, designing an Enterprise Data Warehouse, or anything in between, my end goal is always to maximize business efficiency and to leverage the data to discover opportunities that will positively impact the value of the company.

Lance Kolie's Experience

Independent BI Architect / Senior SQL Server DBA

Opportune Tech LLC

Privately Held; 1-10 employees; Information Technology and Services industry

July 2010Present (4 years 3 months) Kansas City, Missouri Area

• Designed, Built and Implemented an Enterprise Data Warehouse that was configured to leverage Business Intelligence through Dashboards, KPIs, Strategy analysis and Predictive Analytics / Data Mining.
• Leveraged key business users’ knowledge by building SSBI (Self-Service Business Intelligence) solutions using PowerPivot, Power View, Excel Services and SharePoint to empower their decision making throughout the enterprise.
• Built ETL solutions from multiple data sources using SSIS (SQL Server Integration Services) for the Enterprise Data Warehouse.
• Production system OLTP performance tuning and process streamlining.
• Cube Design with Analysis Services for reports using Reporting Services.

BI Architect


Privately Held; 51-200 employees; Marketing and Advertising industry

20142014 (less than a year)

Senior SQL Server DBA

Children International

Nonprofit; 201-500 employees; Nonprofit Organization Management industry

November 2004January 2013 (8 years 3 months) Kansas City, Missouri Area

• Implemented with team a production CRM system migration to a new Aptify CRM system.
• Created Business Intelligence solutions through Data Warehouse Designs and built cubes using Analysis Services for reports with Reporting Services.
• DBA support of the production systems for all business units.
• Increased productivity by performance tuning production systems.
• Designed hardware systems for better performance on new SAN and Servers.
• Built SSIS (SQL Server Integration Services) packages to migrate company information from international locations to corporate headquarters.

Senior SQL Server DBA


Privately Held; 501-1000 employees; Information Technology and Services industry

August 2003October 2004 (1 year 3 months) Independence, Mo.

• Performance Tuning of Production System
• Redesigned and maintained SQL Server Replication
• Created new hardware design for production migration to meet future growth expectations
• Implemented and Created Backup Recovery strategies
• Produced database programming to meet company goals
• Administered all aspects of the SQL Server functions
• Performed data conversions using T-SQL Scripting
• Change Management of all application Code and Database changes
• Built custom DTS packages to meet company needs.

Senior SQL Server DBA


Public Company; 10,001+ employees; S; Telecommunications industry

October 2002July 2003 (10 months) Overland Park, KS.

• Built and designed a SQL Server Consolidation Farm
• Performed SQL Server version migrations from 6.5 to 7.0 to 2000
• Configured and maintained SQL Server Replication
• Created SQL Server Database Standards for the Sprint Corp.
• Designed and Implemented Backup Recovery strategies
• Produced Enterprise wide support for SQL Server Database for the entire Sprint Corp.
• Managed several SQL Server clustered environments.
• Implemented Database Security to prevent SQL Server vulnerabilities

SQL Server DBA Consultant

Green Dreams Inc.

March 2001October 2002 (1 year 8 months) Cole Camp, Mo.

• Performed the SQL Server DBA functions for all database systems.
• Wrote VBA programs to meet company needs
• Designed and implemented a disaster recovery plan
• Designed replication model and implement design
• Maintained data integrity
• Established database standards

SQL Server DBA

Nations Holding Co

Information Technology and Services industry

May 2000March 2001 (11 months) Shawnee Mission, KS

• Designed replication model and implemented design
• Created Entity Relationship Database models
• Designed a disaster recovery plan
• Upgrade all servers & databases from SQL 6.5 to SQL 7.0
• Maintained data integrity
• Performed Data Maintenance
• Network design for replication model
• Established database standards
• Data manipulation & data transformation through T-SQL

Programmer / Systems Analyst

Transpo Services Limited

September 1998May 2000 (1 year 9 months) Grandview, MO

• Maintained support for eight companies in SCO Unix.
• Wrote UniVerse, Pick Programs.
• Provided technical support for 80 users.
• Secured the network for eight company divisions.
• Designed and installed database projects.
• Converted new company databases to collaborate using MS Access.

Lance Kolie's Certifications

  • Microsoft Certified Systems Engineer (MCSE)

    • Microsoft
  • Microsoft Certified Database Administrator (MCDBA)

    • Microsoft
  • Microsoft Certified Systems Administrator (MCSA)

    • Microsoft
  • Hardware + Operating Systems (A+)

  • Networking (N+)

Lance Kolie's Skills & Expertise

  1. ETL
  2. Data Warehousing
  3. Microsoft SQL Server
  4. SSRS
  5. SSIS
  6. Databases
  7. Business Intelligence
  8. T-SQL
  9. SQL
  10. Database Design
  11. Data Modeling
  12. SharePoint
  13. Requirements Analysis
  14. Windows Server
  15. Business Analysis
  16. Visual Basic
  17. Data Migration
  18. Aptify (Association Management Software Solutions)

Lance Kolie's Education

University of Central Missouri

Bachelor of Science in Business Administration, Computer Information Systems


Contact Lance for:

  • career opportunities
  • consulting offers
  • new ventures
  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Lance Kolie’s full profile to...

  • See who you and Lance Kolie know in common
  • Get introduced to Lance Kolie
  • Contact Lance Kolie directly

View Lance's full profile

Viewers of this profile also viewed...