nick pickhard

* Member of Clinical Effectiveness data team helping to find innovative ways to improve patient quality and safety through data. * Design quality related data marts by pulling together information from multiple disparate sources and building Tableau dashboards allowing Episodes of Care team to make guided decisions on the front lines and monitor the outcomes of those decisions. * Create and maintain technical specifications via robust Confluence collaboration tool. * Clarity Data Model - EpicCare Ambulatory Certified 2017. * Clarity Data model - Resolute Professional Billing Certified 2017. * Assist converting from legacy system to Epic Clarity system for quality data reporting. * Train other team members on Epic's Clarity Data Model

Responsible for architecting data solutions in support of health insurance operations for public employees in the state of Wisconsin. Lead architect on critical project to support data collection and reporting for HEDIS to ensure NCQA accreditation. Led a successful initiative to create standards, documentation, and training for ETL/SSIS to support audit processes. Successfully converted all legacy data movement processes from data services projects to SSIS packages.

* Transferred to UnityPoint Health from PhysiciansPlus when companies merged * Epic Clarity and Cogito data warehousing * Member of core team tasked with delivering strategic analytics platform to internal stakeholders using Microsoft’s Parallel Data Warehouse (PDW) * Design, maintain and build SSIS packages to populate Enterprise Data Warehouse * Extract data for internal and external clients meeting many different clients expectations and delivering on varying schedules through automation (SSIS and SQL Agent Jobs) * Primary resource responsible for building and maintaining over 400 automated processes for transferring files internally and externally with vendors

* Created reports against the Epic Clarity database (primarily Tapestry data) to share with Insurance business users on AdHoc basis * Designed SSRS reports to be used in Sharepoint by end users * Automated countless manual weekly tasks saving department labor hours and eliminated many potential errors and delays * Built datamart for enrollment group to allow them to drastically improve their testing process and speed up the implementation of new benefit plans

* Gather requirements, analyze, design and build various levels of OLAP and AdHoc reporting solutions for internal and external customer needs * Collaborate with team of 4 on all ETL/DW projects * Primarily use .SQL and .SH scripts in conjunction with CRON through UNIX to execute scheduled ETL loads * Design and build star and snowflake arranged tables in databases for use in data warehouse reporting solutions * Maintain existing reporting solutions, while consistently finding ways for improvement * Scrum master to facilitate team workload, plan sprints, and prioritize our backlog * Product Owner of the Business Intelligence solution

* Managed IT team consisting of System Architect, 3 Data Warehouse Engineers, 9 Java developers, 2 User Experience Engineers * Coordinated QA/Production release scheduling for US, Europe and Australian environments between all business, PM, QA, and IT stakeholders * Accountable for maintaining correct staffing levels to meet demands of the business and the budget * Enhanced entire SDLC from initial business request, through financial approval, business requirements, development, QA, and production release * Implemented resource capacity plan to improve visibility of supply/demand issues to management * Ensured that we had a disaster recovery plan in place for application, hardware, and business continuity planning

* Developed and documented business and technical requirements, process maps and test plans * Analyzed needs of clients, developers and support team to determine/manage scope of projects * Designed SQL queries to analyze data, enhance requirements and troubleshoot bugs * Managed multiple platforms and how they interact and transfer data to the main database * Troubleshoot, dissect and resolve issues * Primary BA for all Data Warehouse related requests * Facilitated communication between client IT and internal IT for integration projects * Designed SDK’s for webservice integration * Administered issue tracking system and developed customized processes/procedures * Created and implemented test plans for quality assurance purposes