Summary
Overview
Work History
Education
Skills
Timeline
ac
Shaun Shireman

Shaun Shireman

Boise,Idaho

Summary

An analytical thinker with over ten years of experience in data analysis and application support in a fast-paced environment that thrives on change and growth. A reliable worker, with a high attention to detail and a continued desire to learn and improve processes while completing projects efficiently to satisfy customer needs.

Overview

15
15
years of professional experience

Work History

Data Warehouse Analyst

ELEVANCE HEALTH
02.2022 - 07.2023
  • Analyzed business user needs to create and maintain content of the data warehouse while establishing and maintaining general knowledge of warehouse structure design, definitions, capabilities, SQL, and data integrity issues
  • Collaborated with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge/archive criteria, and reload schedule
  • Created ETL data processes based on business, reporting and file extraction needs.
  • Devised work plans and adhered to strict deadlines in database/data warehouse development, communicating with team members throughout process.

Senior Software Analyst

AMERIBEN
03.2019 - 02.2022
  • Managed, maintained, supported, and updated database configurations with Microsoft SQL Server Management Studio for file extracts using in-house and vendor file formats
  • Troubleshot and resolved file extract-related issues while working with various internal teams and delivering exceptional customer service
  • Subject matter, technical expert, and go-to person for configuration of files used by an in-house .NET application designed to extract data files.

Software Developer I

Microsoft
08.2017 - 03.2019
  • Used, SQL to implement complex stored procedures for data extracts in both AmeriBen standard formats and proprietary vendor formats
  • Used Agile with our Application Support team to manage development workflow
  • Extracted, transformed, and loaded data, while using, debugging, and supporting in-house .Net applications and troubleshot related problems.

Technical Analyst III

Microsoft
08.2015 - 08.2017
  • Supported, maintained and updated database configurations with, SQL Management Studio for table-driven rules engine
  • Gathered internal and external customer requirements
  • Met and exceeded customer driven timelines.

Production Support Specialist

06.2008 - 08.2015
  • Utilized extensive knowledge of HIPAA x12 transaction sets (837, 835, etc.)
  • Developed and implemented a new claims rules-based routing tool, which handles over 15,000 claims weekly
  • Managed numerous manual and automated file transfer processes with a variety of tools and software
  • Troubleshot and resolved file transfer failures and issues while communicating with other departments, as well as external vendors and trading partners.

Education

Diploma - undefined

Meridian High School
Meridian, ID
1998

Skills

  • Certification in "Querying Data with Transact-SQL"
  • Microsoft Office
  • Effective understanding of Agile project management and software development, including Scrum
  • Dependable and Responsible
  • Decision-Making
  • Attention to Detail
  • Multitasking Abilities
  • Analytical and Critical Thinking
  • Excellent Written Communication

Timeline

Data Warehouse Analyst

ELEVANCE HEALTH
02.2022 - 07.2023

Senior Software Analyst

AMERIBEN
03.2019 - 02.2022

Software Developer I

Microsoft
08.2017 - 03.2019

Technical Analyst III

Microsoft
08.2015 - 08.2017

Production Support Specialist

06.2008 - 08.2015

Diploma - undefined

Meridian High School

Similar Profiles

CREATE PROFILE
Shaun Shireman