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
Meridian, ID
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
Meridian, ID
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, ID1998
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