Drew Daniel

***** ****** ***** *

Clayton NY ****4

T: 315-***-****

E: ad3bnz@r.postjobfree.com DD

Highlights ● Experienced leader in data analytics and reporting with a proven ability motivating varying personalities, bringing together cross functional teams, and implementing quick and innovative solutions to drive actionable business insights and results.

● Well versed in building executive level reporting, and creating and tracking KPIs and metrics across all levels of business.

● Able to thrive in face paced growing industries with changing priorities and timelines.

● Lead multiple teams up to 15 direct reports in reporting, business analysis, and forecasting for healthcare companies. Technical Skills ● BI Tools - Tableau, Power BI, Looker

● Administrative - Microsoft Suite, G Suite

● Programming - T-SQL, MySQL, VBA

● Other Applications - Visual Studio, Report Builder (SSRS), SSIS, Salesforce, JIRA, Notion, Confluence, RedGate SQL Toolbelt, Snowflake Experience Business Intelligence Analyst, Matrix Medical Network Scottsdale, AZ/Remote - September 2023 - Current

● Created reporting via Tableau and SQL for the Care Team to track various KPI’s against business goals including Completion Rates vs. Goal, Failure to Keep visits, Attrition Rate, and Days to Field Ready for new hire practitioners along with other operational and HR metrics.

● Modified tracking for Power of Attorney of membership to help ensure proper chain of custodial paperwork.

● Assisted in the Agile release of database and reporting updates via SSIS and SSRS.

● Worked with the operations team to make sure mileage had been appropriately documented and paid for our field practitioners.

● Collaborate with Finance department to ensure our SLAs are being met and help them forecast for potential gains or losses. Sr. Data Analyst, HarmonyCares

Troy, MI/Remote - Oct. 2022 - September 2023

● Assisted in documentation and migration of Sharepoint/SSRS reports to a more real time robust Tableau platform.

● Worked with Actuarial, Quality, and Regional CMOs to produce a new Physician Scorecard in Tableau to help drive better treatment in care for Chronically Ill Patients. Also allows for ease of use for providers to help manage their panel of patients and see where they are tracking relative to their goals for KPIs set by the CMO group.

Business Intelligence Manager, Papa

Miami, FL/Remote - July 2021 - July 2022

● Lead the team in automation of hourly audits of monthly Member Level Reports reducing audit time by 2-5 hours per client per month.

● Created weekly training sessions for the team to learn various aspects of SQL in a practical use case situation.

● Client facing liaison for Implementation team to help standardize our membership eligibility files and reduce data discrepancies.

● Automated daily delivery of grievances and resolutions via sFTP for all clients via Looker/JIRA generated reports to comply with Medicare guidelines.

● Collaborated with Five9 (telephony) team and Data Warehouse team to create on demand disposition reporting for both internal and client facing needs using Snowflake and Looker..

● Worked with product and research team to develop reporting on internal Social Index score to drive ROI and help drive better outcomes of members experience.

Production Operations Data Manager, Matrix Medical Network Scottsdale, AZ - May 2019 - July 2021

● Partnered with the Process Improvement team to develop a new forecasting tool utilized by the Production Planning department, which reduced rework and manual intervention by 20 hours per month and helped ensure that forecasting is tied directly to purchase orders

● Developed and maintained a programmatic source of truth for clients' membership, while supporting periodic updates to a client's targeting logic

● Utilized SSIS to help automate the Do Not Call process to ensure compliance with TCPA rules.`5555555555555555555555

● Worked closely with the Production Planning team to ensure the proper data points were present in order to effectively plan providers, report on actions, and hit budget goals

● Processed membership files from disparate data sources to ensure the appropriate client membership was targeted to reduce unbillable assessments and member abrasion

● Built various tools and reports in Tableau to support operations successfully hitting SLA metrics resulting in multi-year performance bonuses from clients

● Responsible for training end users to not only use published Tableau tools, but also worked with front-end analysts to advance their SQL skills Manager, Client and Operation Reporting, Matrix Medical Network Scottsdale, AZ - Mar. 2016 - May 2019

● Leading the integration of the data and reporting aspect of recent company acquisition, while also helping with process improvement and planning departments integrations.

● Help identify requirements for new Data Warehouse build. Work with Data Warehousing team to identify proper definitions of metrics (business and logical) and provide source of truth for upstream data sources.

● Participated in multiple new product/lines of business launches and helped identify key gaps in process to mitigate downstream impacts and reworks

● Served as Department Steward on the Data Governance board and helped standardize and document various KPI’s and Metrics across the multiple Internal and External data sets and reports.

● Built various tools to help support Production Planning and Control department to better forecast and utilize their resources and membership.

● Implemented a requirements document for new reporting requests based upon feedback received from organization wide input

● Twice nominated for Matrix CEO award recognizing top performers in the organization

Reporting Analyst, SheKnows Media

Scottsdale, AZ — Sept. 2015 - Mar. 2016

● Automate website traffic metrics report using Google BigQuery to allow for reporting daily or weekly.

● Collaborate with AdOps, Finance, and Sales and utilize SalesForce data to accurately forecast booking and running revenue across all brands and lines of business weekly.

● Run Reports to ensure the accurate payment of our writers, editors, and affiliate websites.

● Build and maintain sales reports for regional sales team closed and pipelined sales.

Production Planning Specialist, Matrix Medical Network Scottsdale, AZ — Feb. 2015 - Sept. 2015

● Forecast Monthly and Yearly production plans for clients and finance.

● Provide ad hoc capacity analysis.

● Develop and automate tools reduce processes and increase efficiency in Planning department.

● Assist in determining field staffing needs based on a variety of factors including addition/reduction in business, production limits, and geographies.

● Using historical data, forecast key metrics to help mitigate lost production or drive increased production.

Business Analyst, Matrix Medical Network

Scottsdale, AZ — Sept. 2013 - Feb. 2015

● Lead project to automate executive reports using complex SQL queries, stored procedures and data warehousing allowing for more timely and consistent daily reporting.

● Work cross departmentally to provide data analysis and tools to maximize production control efforts to better meet client goals.

● Provide implementation and support of new product reporting and analytics.

● Facilitate ad hoc and regular reports and analyses for clients.

● Helped develop and implement Clinical Support Services KPIs that monitored effectiveness of new initiatives.

Logistics Analyst, Matrix Medical Network

Scottsdale, AZ — April 2013 - Sep. 2013

● Planned and maintained schedules of up to 70 nurse practitioners across the country to perform in home health risk assessments of Medicare Advantage patients.

● Maintained proper working inventory levels to optimize efficiency by reducing drive times while meeting or exceeding client goals.

● Helped develop tools to reduce processes and increase productivity of the Resource, Planning & Analytics team.

Education Arizona State University

B.S. Geography — 2008 - 2012

Contact this candidate