Ryan Hanke Email & Phone Number

San Diego County, California, United States

San Diego, California, United States

- Automate billing processes with Alteryx- Create reports to monitor billing programs- Scrape energy invoice PDF's- Create tools to help billing operations staff with completing tasks faster and more accurately

San Diego

- Test energy rates and billing system for over 20 CCA's (Community Choice Aggregation)- Create tools and reports to help billing operations staff complete daily tasks more accurately and efficiently- QA data and files from 3 California utilities- Monitor energy utility tariffs for rate and language changes

Madison, Wisconsin Area

- Led product design team for ACA (Affordable Care Act) Small Group and Individual plans- Underwrote Small Group, Large Group and Medicare Supplement applications and renewals- Reporting and data analysis using SQL and Excel pivot tables- Increased efficiency through process improvement and software updates- Provided data to state and federal regulators.

Madison, Wisconsin Area

- Managed ACA (Affordable Care Act) Small Group and Individual lines of business for profitability and regulatory compliance- Led team to redesign benefit plans by streamlining offerings and through competitive analysis- Submitted data for state and federal documentation submissions, including QHP (Qualified Health Plan)- Maintained rating software and.

Madison, Wisconsin Area

- Managed underwriting software (Optum Stepwise)- Developed fixes/enhancements for software and customer facing documents- Gathered requirements and translated between IT, developers and users- Designed benefit plans for ACA (Affordable Care Act) small group and individual lines of business- Ran ad-hoc and scheduled SQL queries/reports to investigate.

Madison, Wisconsin Area

- Developed and analyzed reports in Excel to assess group activity and profitability- Ran reports and pulled data to assist underwriting team- Processed individual health applications through Health Insurance Exchange and Salesforce- Set up quotes for large group new business and renewals using Optum Stepwise- Underwrote small group renewals for.

Madison, Wisconsin Area

- Ensured quality of medical equipment orders to properly bill Medicare, Medicaid and other insurance companies- Developed policies and procedures to improve customer service work flow- Researched insurance guidelines and policies to make sure patients met coverage criteria- Tracked errors and trained customer service on correct techniques- Ran reports and.

- Organized documentation and verified accuracy before sending claims to billing- Sent Certificates of Medical Necessity to physicians and ensured accurate information was entered in order to bill for medical equipment- Completed Medicare and Medicaid audits- Ran error reports and corrected data errors- Ensured all Medicare oxygen patients completed.

- Took referrals for durable medical equipment and worked out coverage with Medicare, Medicaid and private insurances- Organized required documentation in order to meet insurance guidelines- Verified coverage and benefits for medical equipment- Worked with doctors, nurses and medical professionals to correctly code and document need for equipment.

A summer job at the zoo

Checked out library materials and closed library at night

Assisted patrons with genealogical research and use of library collections and resources