Ryan Anderson Email & Phone Number

Des Moines, Ia, Us

Des Moines, Iowa, Us

1. Served as senior member of high-performing team, overseeing stakeholder management, task coordination, knowledge sharing, & template development to ensure seamless operations. Took ownership of risk management, compliance, & privacy/HIPAA adherence in high-stakes environment involving dozens of stakeholders. Functioned as de facto team lead in the absence of the official leader, providing guidance & coaching & ensuring the team met critical account management needs with precision & accountability.2. Directed development of a self-service Health Services employer reporting suite to enhance client communication & demonstrate Wellmark’s value proposition. Led cross-functional team to design & build Power BI tool which improved client engagement & saved 6+ hours per request.3. Delivered strategic analysis & actionable insights to major accounts, evaluating the effectiveness of point solutions through advanced statistical methods such as propensity score matching.4. Took initiative to redesign a potentially impacted member mailer process to eliminate unnecessary touchpoints, despite only being asked to build the final report. Saved acct. mgmt. teams 50-400 hours of manual work in first 2 months of operation.5. Improved mailer campaign production process for Wellmark's Indigo benefits communication team, converting it from ad hoc mailing list requests to a consultative relationship for developing & executing on an analysis strategy to prove the effectiveness of the program.6. Streamlined process for pulling pharmacy class action reports, automating the creation of individual Excel files for every account & providing clear instructions to acct. mgmt. on how to provide them to the accounts.7. Taught data storytelling & visualization course for analysts from multiple departments. Led initiative to create Power BI branding standards & templates for dashboards presented externally.-- Primary technical skills used: SAS EG, SQL, Power BI, python

Des Moines, Iowa, Us

Served on a team of 7 analysts whose role is to work with the network, pharmacy, legal, product, medical policy, claims, and other departments to keep health care costs sustainable for our members.1. Performed comprehensive analysis of the causal factors (incl. demographic & geographic), extent, & effects of variance in clinical risk grouper (CRG) risk weights & per-member-per-month costs across Wellmark's accountable care organizations (ACOs). Techniques/measures used in gathering & analyzing data: multiple regression, Monte Carlo simulation w/ bootstrapping, Gini index calculation.2. Created & automated report to notify pharmacy department of members with prior authorization for medically benefited drugs who have had a change to their internal ID. This proactive report ensures dozens of members per year will not be denied coverage for treatment based on their internal ID not matching with prior authorization, & it saves them from potentially accidentally redoing the time-consuming process of applying for a new authorization (which may result in conflicting authorizations if the new one is denied).3. Built hospital report for Network VPs & directors to be able to easily disseminate information about individual hospitals from multiple internal & external data sources. Self-service nature of the report saves Network team from having to fulfill several time-consuming requests each month. Created report using SAS for back-end and Excel for front-end display. Techniques used: SAS macros, Excel index/match functions.4. Wrote white paper on the topic of risk adjustment / adjusting for confounding for consumption by sales, network, & analysis team members. Collaborated cross-departmentally to ensure paper would be understood by a broad audience.

Des Moines, Us

LineupIQ provides the first and most comprehensive analytics-based player projections in the Major League Soccer fantasy community.1. Built predictive expected-value models using Excel initially; converted to R programming in 2018 season.2. Published weekly player and team fantasy point projections articles on mlsfantasyboss.com.3. Managed @LineupIQ Twitter account dedicated to providing analysis centered on fantasy Major League Soccer.4. Championed analytics-based analysis in the MLS fantasy community.MLS Fantasy Record:2019 Fall: 42nd overall2019 Spring: 16th overall2020: 5th overall2021: 9th overall2022: 7th overall2023: 22nd overallhttps://twitter.com/LineupIQ

1. Refereed 100+ youth and adult matches, in center and assistant positions.2. Managed player expectations and game flow, diffused heated situations, explained controversial decisions to players and coaches, and worked with other referees to get close calls right.

San Francisco, California, Us

Performed analytics to guide Home Mortgage and other divisions in decisions which improve Wells Fargo's customers' experiences. Primarily used SAS.1. Researched, built, and refined content demonstrating lower call engagement rates as the number of collections calls to a customer increases.2. Built dashboard to demonstrate success of my team's mortgage payments proactive corrections program, noting a 40-70% drop in collections calls in two out of the three categories. Included chi-squared tests to ensure the difference between our test and control was statistically significant.3. Supported other team members in their projects by gathering and cleaning data, testing their results, suggesting improvements to visualizations & presentations, listening to recorded phone calls to determine root cause, and reading complaints for pattern-recognition.

Des Moines, Iowa, Us

1. Using Excel (pivot tables, VLOOKUP/INDEX-MATCH, etc.) and Microsoft's O365 Readiness Toolkit, found patterns in list of over 400,000 macro-enabled files in order to discover migration risks in the VBA code and guide overall migration strategy. Included basic text pattern analysis, along with regression to predict tool run times and determine capability of Excel to handle results.2. Interviewed macro file owners to determine testing priority and narrow down number of files to include in tests.3. Documented and researched team's capabilities for analyzing data sets with >1 million rows, working around Excel's ~1 million row limit. Weighed pros/cons of using Power BI and R in Citrix environment.

Austin, Texas, Us

Des Moines, Iowa, Us

Focused in ETL, SSIS package development, and SQL Server development, working in both third-normal-form and star/snowflake schemas.Modified SSIS packages, stored procedures, tables, and queries to bring account data from provider to a vendor via data staging, warehouse, and mart environments.

St Paul, Mn, Us

1. Built ad hoc SQL queries in Teradata SQL Assistant to be used in R scripts for data science team.2. Built sales KPI report in Excel to be distributed to US sales managers on a monthly basis. Pulled data from SalesForce and BI cubes using SQL queries and SAP BI, combined into single Excel file so managers could see source data along with individual rep summaries. Built formulas to dynamically correct employee and customer naming disparities between data sources. Added value to report by standardizing key metrics and enabling them to be combined into single performance indicators.3. Built R Shiny apps for Data Science team to use to monitor the usage of their other Shiny apps.4. Performed exploratory data analysis with R and Teradata.

Eden Prairie, Mn, Us

Short contract to (1) determine current state of data extraction and submittal processes using ERP data and (2) document security concerns. Since payroll's busiest time of year is Dec-Jan, the challenge was to get the requisite information as efficiently as possible. Delivered results with 10% of budgeted hours remaining.

Chanhassen, Mn, Us

1. Built and maintained reports in Workday ERP system, supporting both HR/HCM and Finance/Accounting functional areas.2. Built and supported drillable P&L income statements in Workday, resulting in 25x decrease in load time from Cognos system (from ~5 min to 12 sec). Reports used by over 1000 club general managers and department heads. One GM commented, “This is the best P&L experience I’ve ever had”.

Woodbury, Mn, Us

SharePoint consulting focused on designing and building business solutions using "out-of-the-box"​ features and tools in SharePoint 2013/2010, SharePoint Online, and other tools in the Microsoft Office 365 suite. Responsibilities include pre-sales, proposals, system assessments, architecture planning, site & page design and construction, technical decision consulting, and future system planning.Additional work included business process analysis, form & workflow construction, and SQL report development.Notable Work:1. Built complex InfoPath form and workflow to help a snack manufacturer's salespeople request product samples for their customers, replacing old Excel and email-based system.2. Developed unique quick-install system for building employee directories in SharePoint, reducing errors from having directory information in multiple locations while allowing for list management by HR users. System has been implemented in multiple clients'​ environments.3. Built SharePoint pages with dynamic content based on URL variables.4. To support a client's legal and compliance review process for their affiliates, built document search center to search over 40 subsites and return data filtered by location, content type, and creation date.5. Designed and successfully implemented and supported expansive on-premise SharePoint 2013 site structure for leading regional affordable housing provider, including site collections with external sharing.6. Assisted graphic designer in implementing & customizing bootstrap-based responsive design on SharePoint 2013 on-premise site.7. Built and modified Crystal Reports reports using Oracle PL/SQL back-end. Improved report's run time from 45+ minutes to 3 minutes.

Minneapolis, Mn, Us

1. Used Handshake Software SharePoint Portals to create dashboards to display live database-connected CMS financial data, iManage (WorkSite) documents, client news, and other LOB application data on SharePoint.2. Managed SharePoint 2010 farm, site collections.3. Planned and oversaw SharePoint 2013 environment design.4. Managed IT relationship with Thomson Reuters and marketing department to implement Business Development Premier on the Microsoft Dynamics platform.5. Worked on Wrike Champion Team to implement and lead use of Wrike project and task management solution.

Bloomington, Mn, Us

1. Led cross-functional global teams of managers and directors to develop and implement Donaldson's Global Capital Program Management process (based on PMI's PMBOK) to be the global standard for projects with $500,000 or more capital.2. Led departmental team to develop and implement AMT's Project Deployment Process standard (also based on PMI's PMBOK), with an forecasted project benefit of $100,000 per year in productivity gains for AMT's project managers and at least 5% savings per project ($250,000 per year for all projects). Total yearly savings forecasted to be $350,000.3. Assisted in the creation of over 30 project management tools for the PDP standard, using SharePoint, Excel, Word, InfoPath, Visio, Project, PowerPoint, and OneNote.4. Developed & maintained standard project management status presentation used by hundreds of employees worldwide.5. Collected & prepared status presentations and facilitated setup of monthly Executive Project Reviews for projects with $500,000 or more capital.6. Elicited status information for & created Major Project Reports for bi-monthly Board Meetings.7. Administrated department's SharePoint site.8. Successfully managed $10,000 (labor costs) project to clean up & redesign department's SharePoint site, completing it on time and within budget.9. Collaborated with IT to ensure the technical needs of the department were met; managed relationship between department & IT.

St. Paul, Mn, Us

Troubleshot wide range of issues with networks and faculty and student computers and accounts.Trained and supervised new employees, wrote training documentation.

St Paul, Mn, Us

1. Wrote and maintained ad hoc queries and T-SQL stored procedures in SSMS to be used in planning & scheduling applications.2. Pioneered use of proprietary SQL-based reporting tool (similar to Crystal Reports) for Prairie du Chien, WI, plant.3. Participated in successful plant production system overhaul, including updating 3 complex ODBC-connected Access databases.4. Applied change management with users and systems team following system overhaul.

St Paul, Mn, Us

1. Wrote and maintained ad hoc queries and T-SQL stored procedures in SSMS to be used in planning & scheduling applications.2. Pioneered use of proprietary SQL-based reporting tool (similar to Crystal Reports) for Prairie du Chien, WI, plant.

St Paul, Mn, Us

Worked on various abrasives converting lines, presses, and stations.

St Paul, Mn, Us

Supported quality control lab team by performing experiments, maintaining the lab, and developing/revising the proprietary manual for an industrial microwave.

Master Of Science (M.S.), Business Analytics

B.S., Management Information Systems