Patrick Hanes Email & Phone Number

Austin, Texas Metropolitan Area

• Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, and other analytics tools
• Take lead in the design, testing, and implementation of process enhancements and identify opportunities for automation
• Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers
• Compile and submit compliance reports to the Texas Health and Human Services Commission

Chicago, IL

• Identify and perform complex data analyses from multiple platforms across claims, provider, and member datato improve business processes and operations
• Engage with various business partners to gather requirements and validate deliverables
• Assist in design and testing of data extracts and implement report automation to drive efficiency
• Convert freeform SQL into interactive dashboards to track member and claim activity for COVID-19
• Gather requirements to standardize and maintain the weekly KPI dashboard for senior management
• Develop custom reports, extracts, and subscriptions for internal and external business stakeholders

Chicago, IL

• Managed in-depth analysis and configuration recommendations to contingent labor program managers
• Collaborated with Production Engineers, Business Analyst, Operation Consultants, and other internal teams to bring resolutions to the clients
• Wrote SQL queries to track spend across work items, system activity, and customer metrics
• Designed custom reports for clients on headcount, spend, and internal audits
• Created the method and formulas in Excel to cleanse data and provide initial analysis on yearly customer satisfaction survey data for review by executive team members
• Designed and led continuing education sessions on internal processes, SAP Ariba Support engagement, and SQL queries

Chicago, IL

• Prioritized and troubleshot system issues based on a clear understanding of business processes
• Led training sessions for staffing agencies on the various modules and use of the application
• Prepared quarterly and monthly service-level agreement reports for review by clients and Account Services Teams
• Conducted guidance sessions to advise newer colleagues on the resolution of challenging cases

Downers Grove, IL

• Assumed full responsibility over work orders and completed quality and performance testing on consumer products by specified deadlines
• Coordinated between technicians, design engineers, sourcing teams, and other departments for the completion of prototype testing
• Applied formulas, pivot tables, and charts in Excel to detect outliers in test data and provide visually appealing summaries of the results
• Submitted research reports to design engineers and directors, in order to provide information needed for new product designs and marketing strategies

Post Graduate Program In Data Science And Business Analytics

Bachelor Of Arts (B.A.), Biology And Environmental Studies, Cum Laude

Independent Research: Clonal Growth of the Asian Bittersweet (Celastrus orbiculatus)