Shelby Brambach Email & Phone Number

Seattle, Washington

Information, Services, and Technology

Greater Seattle Area

Seattle Metro Area

Currently seeking to give my energy and talents to a world class organization who cares about humanity, community, and the environment. Starting to take exciting analyst work on contract basis and loving it!

Bothell Wa

* 7+ years developing SQL logic, SSRS, Excel, data analysis* Prepared contract-related metrics and reporting* Provided critical data analysis and expert review to a special grant application focused on improving managed pediatrics care in the State of Washington.* In partnership with the Utilization Management team, mapped the process used to log authorizations to QNXT, validate and correct these records, and to produce State Healthcare Authority (HCA) turnaround time… Show more * 7+ years developing SQL logic, SSRS, Excel, data analysis* Prepared contract-related metrics and reporting* Provided critical data analysis and expert review to a special grant application focused on improving managed pediatrics care in the State of Washington.* In partnership with the Utilization Management team, mapped the process used to log authorizations to QNXT, validate and correct these records, and to produce State Healthcare Authority (HCA) turnaround time performance ratings. Built a fully automated tool in SSRS, cutting existing process time from 16 management hours to 30 minutes, and improving accuracy of our HCA Turnaround Time statistics.* Partnered with the Compliance Team to develop an automated service verification process, cutting the error rate from 100 records per file to zero. Show less

The Boeing Company

747-8 Mitigation Project Team - The Mitigation Team was established to compress the delivery timeline for the 747-8 next generation freighter. The team triaged and resolved domestic and international supplier issues.* Key logistics contact for the project team. * Organized complex, multiple, and simultaneous travel arrangements for constantly changing senior managers and project staff. * Generated standard reports for all production lines, created PowerPoint slide decks, PDF… Show more 747-8 Mitigation Project Team - The Mitigation Team was established to compress the delivery timeline for the 747-8 next generation freighter. The team triaged and resolved domestic and international supplier issues.* Key logistics contact for the project team. * Organized complex, multiple, and simultaneous travel arrangements for constantly changing senior managers and project staff. * Generated standard reports for all production lines, created PowerPoint slide decks, PDF files, and Web updates for the 747, 767, 777, and 787 lines.* Supported daily production of Manufacturing Workflow Status report. As part of a data team, executed Access queries and pushed the final report to management file server. Show less

* Education Account Program manager for $4M continuing medical education (CME) fund. Worked with Finance to complete the quarterly account reconciliation process, monthly audits and high-level policy resolution. Partnered with Finance to reconcile account balances, and to resolve legal or financial policy questions.* Resolved sensitive issues for customers and training sites pursuant to National Electronic Manufacturing Association (NEMA) ethics restrictions and Sarbanes-Oxley… Show more * Education Account Program manager for $4M continuing medical education (CME) fund. Worked with Finance to complete the quarterly account reconciliation process, monthly audits and high-level policy resolution. Partnered with Finance to reconcile account balances, and to resolve legal or financial policy questions.* Resolved sensitive issues for customers and training sites pursuant to National Electronic Manufacturing Association (NEMA) ethics restrictions and Sarbanes-Oxley restrictions. Result: $1M invoice settlement with Duke University School of Continuing Medical Education for training delivered to Philips 3D Echo customers. Achieved the release of tuition and reimbursements to 50 continuing medical education clients.* Maintained accreditation for 165+ continuing medical education courses and events through the Society of Diagnostic Medical Sonographers (SDMS). Developed a comprehensive Excel-based spreadsheet to manage the growing volume of courses, and to engage course managers in the update process. Show less

Ibm Global Services (Boeing Contract)

* Manage weekly production of Boeing Contract KPI review.* Simultaneously manage three executive calendars.* Arrange travel and prepare travel expense reports.

Videoconferencing and Telecommunications Project Team – IBM Global Services Contract* Produced weekly project status report and meeting materials* Controlled calendars for three executive managers * Arranged travel for the Account Executive, Senior Project Manager, and various senior personnelAdministrative Assistant - Electrical Subsystems & Electrical Engineering Division* Published weekly engineering status PowerPoint slide decks* Administrative contact for… Show more Videoconferencing and Telecommunications Project Team – IBM Global Services Contract* Produced weekly project status report and meeting materials* Controlled calendars for three executive managers * Arranged travel for the Account Executive, Senior Project Manager, and various senior personnelAdministrative Assistant - Electrical Subsystems & Electrical Engineering Division* Published weekly engineering status PowerPoint slide decks* Administrative contact for 40+ electrical engineers* Facilitated staff and weekly status meetings Show less

*Certified Customer Relations Trainer, FEMA (1995). Trained 200+ peers in desired customer relations behaviors. *Project coordinator, screenwriter, and producer for an "Introduction to the Federal Response Plan" training video*Data Analyst for various Federal disaster response operations, evaluating and conveying critical needs information to supporting Federal agencies. Observed and reported field experiences, including response-time conflicts with long-term loss reduction… Show more *Certified Customer Relations Trainer, FEMA (1995). Trained 200+ peers in desired customer relations behaviors. *Project coordinator, screenwriter, and producer for an "Introduction to the Federal Response Plan" training video*Data Analyst for various Federal disaster response operations, evaluating and conveying critical needs information to supporting Federal agencies. Observed and reported field experiences, including response-time conflicts with long-term loss reduction programs and policies. Show less

Ata, Database Information Technologies

The degree program focused heavily on team interaction and team project delivery. I managed degree completion with a full-time.

Bachelor Of Arts (B.A.), International Economics

Diploma

Activities and Societies: Northern Virginia Youth Symphony, Madrigals, Honor Society Granted Governer's Diploma for Supplemental Studies.