Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kiki Dravie

Omaha

Summary

Seasoned Business Intelligence Developer with solid background in translating business requirements into technical solutions. Demonstrated strengths include development of BI dashboards, data modeling and ETL processes. Previous roles resulted in improved decision-making capabilities through delivery of insightful analytics. Skilled at collaborating cross-functionally to drive project completion on time and within budget.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Sr BI Developer

Cotiviti
Omaha
11.2018 - Current
  • Created and maintained hundreds of SSIS packages for insurance, claim, and eligibility data support.
  • Architected complex backend solutions for member-centric applications across multiple client platforms.
  • Migrated existing SSIS 2008 packages to 2022 version to enhance performance.
  • Led a support team to monitor and resolve production issues in a timely manner.

Database Administrator

Obsidian Global
Washington
03.2024 - 08.2025
  • Collaborated with development teams to design and implement database structures.
  • Configured user accounts, privileges, roles, profiles. in the database server.
  • Created and maintained hundreds of SSRS reports for students and instructors, pilot class schedules, flights, and simulation data for 20+ Air Force bases.
  • Led the effort to standardize all SSRS reports and underlying stored procedures.
  • Led the effort to standardize and integrate all databases on a single server.
  • Supported and maintained OLAP cubes.

Sr BI Developer

Tetra Tech
Omaha
08.2019 - 11.2023
  • Same job responsibilities as Obsidian Global. Different contract.

Sr. ETL/Data Warehouse Developer

1-Answer Corp
Omaha
10.2017 - 10.2018
  • Developed SSIS custom components.
  • Developed Visual Studio add-ins for SSIS package auto-generation.
  • Used and enhanced in-house metadata-centric tool to support SSIS package Autogeneration.
  • Created, autogenerated, and customized template-based SSIS packages.
  • Performed relational and dimensional data modeling/architecture by gathering requirements from business users and proposing different prototypes.
  • Developed ETL processes to integrate data from multiple sources.
  • Member of a team that built a data warehouse from the ground up for a large healthcare company.

Sr. BI Developer

Blue Cross and Blue Shield of Nebraska
Omaha
06.2015 - 10.2017
  • Created, supported, and maintained numerous Informatica workflows for processing data files, including claims, members, and financials.
  • Contributed to support and maintenance of over 500 SSRS Reports; created and deployed dozens of new SSRS and Power BI reports.
  • Assisted SQL Server migration from 2014 to 2016 while optimizing SQL queries and stored procedures for ETL processes.
  • Utilized TFS for application versioning, managing reports, stored procedures, databases, and documentation.
  • Supported over 20 .NET applications while managing scheduled execution of SSRS reports through Tidal Enterprise Scheduler.
  • Collaborated with stakeholders to gather requirements for new developments and enhancements.
  • Developed validation scripts for various processes and ETL workflows; participated in redesigning a data warehouse to enhance OLAP performance.
    Conducted training sessions for junior associates on Informatica fundamentals and authored technical documentation for multiple processes.

Sr. Custom Development/Infrastructure Consultant

Quilogy/Aspect Software
Omaha
10.2011 - 10.2012
  • Led a B.I. Team within the Commercial Card Business Unit responsible for the
    development and maintenance of automated processes to produce and deliver periodic reports previously done manually.
  • Architected and implemented a multidimensional OLAP cube to support reporting for business users.
  • Converted existing Excel reports with SAS code into SSRS reports.
  • Scheduled SAS reports using Windows Scheduler.

Education

MBA - Business Administration

University of Nebraska, Lincoln
Lincoln, Nebraska, NE
12-2012

Bachelor of Science - Computer Information Systems

Bellevue University
Bellevue, NE
06-2003

Master of Science - Data Science

Eastern University
PA

Skills

  • ETL and data integration
  • SQL proficiency
  • Report creation and maintenance
  • Business intelligence tools
  • ASPNET, VBNET, and C#NET
  • HTML, CSS, and JavaScript
  • Python programming
  • Virtualization technologies

Certification

  • Security +

Timeline

Database Administrator

Obsidian Global
03.2024 - 08.2025

Sr BI Developer

Tetra Tech
08.2019 - 11.2023

Sr BI Developer

Cotiviti
11.2018 - Current

Sr. ETL/Data Warehouse Developer

1-Answer Corp
10.2017 - 10.2018

Sr. BI Developer

Blue Cross and Blue Shield of Nebraska
06.2015 - 10.2017

Sr. Custom Development/Infrastructure Consultant

Quilogy/Aspect Software
10.2011 - 10.2012

MBA - Business Administration

University of Nebraska, Lincoln

Bachelor of Science - Computer Information Systems

Bellevue University

Master of Science - Data Science

Eastern University
Kiki Dravie