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.

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.

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.

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.

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.

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.

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.

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.

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.

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).

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.

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