Magda Hitzroth Email & Phone Number

Bothell, Washington, United States

Bothell, Washington, United States

• Requirements writing for IT, SQL code review, and UI design for rewrite of pharmacy vendor eligibility files
• Setup for electronic employee interface, including plan and user setup
• Resolved pharmacy eligibility issues, escalations and vendor setup for members
• Created, loaded and audited 834 eligibility and pharmacy files
• Performed root cause analysis of bugs reported by vendors, members, and clients for various Electronic Data Interchange and 834 files
• Provided input to IT on correct data sources and fields needed to correct bugs

• Maintained the HR and Employment databases, including troubleshooting, expanding capabilities and training users. Worked with vendor to customize database for Genie’s usage.
• Worked closely with HR Director and was a key member on Annual Compensation project.
• Provided ongoing analysis for equity and budget purposes for up to 3500 team members.
• Calculated bonus accruals and bonus payouts for four different plans, benefiting 3500 team members.
• Prepared annual EEO and affirmative action reports.
• Created new process to integrate loading team member. Saved company $5,000 initial cost and ongoing $2,500 annually.

• Maintained the HR and Employment databases, including troubleshooting, expanding capabilities and training users. Worked with vendor to customize database for Genie’s usage.
• Worked closely with HR Director and was a key member on Annual Compensation project.
• Provided ongoing analysis for equity and budget purposes for up to 3500 team members.
• Calculated bonus accruals and bonus payouts for four different plans, benefiting 3500 team members.
• Prepared annual EEO and affirmative action reports.
• Created new process to integrate loading team member. Saved company $5,000 initial cost and ongoing $2,500 annually.

• Maintained benefits enrollment records for 3,000 team members.
• Produced monthly premium statements for seven vendors.
• Prepared COBRA initial notices and qualifying event notices, weekly for up to 3,000 team members.
• Worked daily with team members on resolving claims issues.
• Conducted regular benefits orientations, assisted in producing presentations for new hire benefits orientations and open enrollment.
• Partnered with leave manager backing up on all aspects of leave management.

I worked as a volunteer in charge of the Microsoft Access database containing more than 20,000 names. I helped organize mailings, track campaign contributions and what ever else was needed.

• Started a general bookstore from scratch, built fixtures, designed layout. Grew business by 400%.
• Responsible for all hiring, purchasing, and marketing. Managed up to 10 employees.
• Maintained all financial books and produced payroll and all tax statements, W-2’s, 941, Sales tax, annual income tax.
• Organized regular events, produced up to 40 author events per year, as well as 35 other outside events that were book related.
• Produced bi-monthly newsletter including editing, layout and writing. Distributed 2000 by mail and several hundred in the store.
• Implemented computerized inventory control system, to manage inventory more accurately.

Ba, Oceanography

Cebs, Benefits

I earned a Certified Employee Benefits Specialist certification when the requirements were for 10 classes. I earned the certificate.

Certificate, Business Intelligence Developer

Phi Theta Kappa

Certificate, Relational Database Developer

Phi Theta Kappa