William Hauser Email & Phone Number

Philadelphia, Pa, Us

- Query data in SQL Server and BigQuery to provide impact reports to internal associates - Construct comprehensive Tableau dashboards on Claims, Enrollment, and Contact Center records to drive business intelligence and decision-making- Develop an in-depth understanding of both the Self Funded and Fully Insured business models to support operations- Use performance tuning on previous queries to improve report efficiency and database management- Analyze benefit utilization by pulling claims denial codes, status, adjudication details, and paid amounts. - Investigate application and database issues from both the business and technical sides to ensure efficient/accurate Operations continuity- Assist Provider Network Services team in providing rapid insights and issue diagnostics by analyzing trends and inquiries

Philadelphia, Pa, Us

- Lead business representative in the implementation of Salesforce HEAL application in Enterprise Operations using an agile DevOps approach- Define and oversee the development of all business requirements and user stories built into Salesforce HEAL application broken out by sprints- Construct SQL queries to pull Member and Provider Services data into Tableau and Power BI for leadership to track key performance metrics - Analyze databases Facets, EXP Maccess, and Enrollment file for issues within operations and locate key Member/Provider data- Lead operations analyst to support the launch of new Medicaid Managed Care plans such as AmeriHealth Caritas Ohio and North Carolina. This includes policy and procedure documentation, KPI reporting, call flow construction with Avaya, training materials, workforce management trends, and vendor communication- Identify current issues and trends within operations to report on and develop change management approaches - Provide desktop procedures and policies to state Medicaid departments to highlight business processes and data processing in the Contact Center

Denver, Co, Us

- Design and release weekly performance reports on digital campaigns through Google Analytics- Manage and automate Zoho email drip campaigns to be sent out to over 10,000 clients internationally - Drive SEO and digital presence with website coding, keywords, tagging, metadata, and Google AdWords- Lead project management of multiple product implementations and member engagement outreach strategies

West Hartford,, Ct, Us

- Assist in the design and launch of company digital newsletter, High School Counselor Week (HSCounslerWeek.com) using HTML and Java- Clean and pull data lists to provide to clients looking to improve their student and admissions office outreach strategies- Work with CRM platform Zoho to visualize outreach call center results and help with sales dashboards in Salesforce to effectively reach the target audience- Conduct outbound calls to clients educating them on the company's data lists and how they can leverage this information to create stronger student/counselor engagements

Philadelphia, Pennsylvania, Us

- Consult and mentor local businesses looking to expand digitalpresence- Help with development and implementation of a multifacetedmarketing strategy-Train clients on multiple platforms including Google Analytics, Salesforce, Zoho, and Excel to expand their business model and drive new leads

Philadelphia, Pa, Us

- Design implementation around the mySQM reporting platform to increase monthly contact center metrics including First Call Resolution- Construct call flows in Visio for new lines of business including TFNs, internal transfer number assignment, prompt development, and announcement verbiage - Release weekly operations metric reports in Excel and Tableau highlighting the call center's service level agreements in each Medicaid market- Help write and approve training content using the company's Online Help platform to ensure business processes and documentation are followed in operations - Build a Microsoft Access query by working with the lead Business Systems Analyst to gather all report submissions and Online Help topics ensuring ad hoc reporting is readily available to all leadership

Philadelphia, Pennsylvania, Us

- Write HTML and CSS to enhance current advisor submission portal that thousands of students interact with daily- Work with Klein Advising staff to promote an efficient and well-operated office- Answer student and parent questions about all areas in the school of communication- Schedule and manage advising meetings between students and advisors- Be a liaison between students and the Temple University Portal including diagnosing error codes to escalate to the digital team

Bachelor Of Arts - Ba, Business And Entrepreneurship

High School Diploma