John Reed

Contributed to major server database conversion by remediating software packages and reporting to use new data sources • Enhanced high visibility executive Tableau dashboards earning confidence and trust • Customized and supported HEDIS data extracts for consolidators • Enhanced and supported HEDIS quality scorecards and Gaps In Care reporting • Extensive modification of SSIS packages using Visual Studio • Remediated and optimized SQL code, enabling faster analytical reporting • Monitored data quality to ensure accurate reporting

* Updated chat SQL code to support expanded reporting needs, streamlining and simplifying code to facilitate team cross training and understanding. * Created flexible and modular SQL code with CTEs to accommodate ever changing business requirements, reducing development and QA cycles to implement. * Supported ad hoc reporting requests across multiple platforms such as Alteryx, AS400, Snowflake, SQL Server and Teradata. * Created Excel macro solution to ingest 30+ cost center spreadsheets, saving over 40+ hours (ongoing) of manual entry and eliminating errors. * Created Power BI dashboards supporting CSLT and associate reporting * Designed innovative table-driven budget/forecasting allocation by G/L major solution to support Business Intelligence / Project Services team * Participated in daily scrum calls for 2 week sprints, using Jira for project and task tracking * Led team in creating path to production documentation for all technical projects

* Business analysis in a Scrum environment * Strong technical skills ensure data driven results * Lead technical role on chat application implementation for customer service, performing extensive SQL Server data validation ensuring seamless reporting cutover * Mentored BA team members on SQL Server query writing, increasing data validation skills

On-board new volunteers and actively maintain the UES website: http://uesdenver.org/ • Analyzed and decided on scheduling software implemented by UES to streamline event scheduling.

Acted as Scrum Product Owner for 3 projects, prioritizing product backlog, collaborating with business, IT, and offshore team to develop user stories (requirements) and user acceptance criteria. Created test plans, performed user acceptance testing (UAT), and participated in daily standup, review and release planning meetings. Gained knowledge of major coal indices by converting spreadsheets to database back-end solution.

Managed and led team of 3 analysts responsible for tier 1 application support, metrics reporting and ad hoc queries, interface support, EDI vendor on-boarding, departmental QA analysis and reporting, and security setup, auditing and reporting. Performed in-depth business analysis, collaborated with functional teams to document requirements for IT projects, reducing change requests (CR) and expediting on-time project completion. • Enhanced test scripts and managed all department UAT of Lawson ERP upgrades & ImageNow scanning software, resulting in more successful implementations with measurably fewer defects. • Project managed and successfully implemented Procurement Card (P-Card) program switch for 1100 users from Mellon Bank to Bank of America using Concur’s (SaaS) application in less than 90 days.