Hise Chapman Email & Phone Number

Raleigh-Durham, North Carolina Area

Designed and built a data warehouse using Amazon Redshift database residing in Amazon's secure GovCloud environment. Established customer specific schema, group, and user security model.Developed numerous ETL jobs utilizing Matillion ETL for Redshift. The jobs populated Redshift tables from various sources; such as: text files, Excel files, JSON file, and RESTful data sources using OData and SODA API.Designed "Sites" and user security model for Tableau Server. Developed and published live Redshift data sources for data analyst access. Utilized Tableau Desktop to develop views and interactive dashboards regarding End Stage Renal Disease vascular access and long-term catheter use rates. The rates were presented at various levels: ESRD Network, State, Facility, Race, Gender, Age group, etc.

Raleigh-Durham, North Carolina Area

Key personnel on the End Stage Renal Disease Network Coordinating Center contract supporting the Centers for Medicare Medicaid Services.Designed, developed, and implemented Release 1 of the NCC Clinical AIMS Data Warehouse using SQL Server 2008. Designed and created all database tables and views. Designed and created SSIS packages for exporting and loading data from CROWNWeb, population of fact tables, and distribution of data to network-specific Microsoft Access databases.Developed official rates and measures for Fistula First/Catheter Last initiative. Developed and published interactive trending reports using advanced Excel techniques using direct database connections, pivot tables, and pivot charts.Hired and directed 3 technical staff members for development of subsequent Data Warehouse releases, as well as, provide technical and administration support for office desktops, servers, phone equipment, and security system.

Raleigh-Durham, North Carolina Area

Provided Level 3 technical support to approximately 6,000 physician practices using the MyWay and ProEHR electronic health record applications. Traced T*SQL and C# source code identifying runtime and logic errors. Documented errors and suggested solutions in Salesforce help desk application.

Durham, Nc

Supporting the CROWN Data Discrepancy Support contract for CMS.Leveraged my knowledge and experience of both SQL Server and Oracle to analyze data in SIMS and CROWNWeb.Designed and developed reports and Microsoft Access utilities to compare legacy SIMS with transformed CROWNWeb data supporting the national release of CROWNWeb.Designed and developed the Patient Merge Utility which allows a data analyst to compare two patients and there associated data (Form2746, Form2728, Patient Events, etc) and select the related records to be retained post-merge.

Raleigh-Durham, North Carolina Area

Led the team responsible for local desktop, server, and network support, and database support for the SIMS and Vascular Access databases.Continues to provide oversight of routine contract deliverables and also serves as the Security Point of Contact for the NWITS contract.Provides data analysis and reporting support to CMS, drawing from years of experience with a breath of database and reporting tools, such as: Oracle, Microsoft SQL Server, advanced Microsoft Access, advanced Microsoft Excel, advanced SQL, SAS, and BI Publisher.

Raleigh-Durham, North Carolina Area

Developed, implemented, and manage standard project management processes for oversight and delivery of contract deliverables supporting the End Stage Renal Disease program at the Centers for Medicare/Medicaid Services.Provide leadership and support of data analysts in researching and resolving complex data discrepancies.

Raleigh-Durham, North Carolina Area

Managed project schedule for Total Cost of Ownership program responsible for consolidating 14 helpdesks, desktop support, and network/server support. The project saved the EPA $2M.Partnered with management to define contract binding SLAs. Developed Microsoft DTS package to extract Lotus Notes-based ticket data into the SQL Server database. Developed TSQL functions and views for calculating SLA metrics. Developed, implemented, and supported a Microsoft Access database for selecting report criteria and displaying contract binding reports using pivot tables and pivot charts.Led project to develop the Email best practices and Collaborative Tools Overview Computer Based Training module. Coordinated activities of subject matter experts in providing and validating training content.Coordinated infrastructure support activities to analyze and resolve enterprise-wide problem with Wake On Lan issues with standard desktop computers.

Raleigh-Durham, North Carolina Area

Led development, test, and implementation of enhancements to global Perl/CGI/Oracle time entry / work order system.Led re-design of WebObjects/Java based application for tracking enterprise application architecture.Lead developer of Perl/CGI/Oracle Document Order Tracking system.Lead developer of data mart using SAS/Base, SAS/EIS, SAS/Connect, SAS/SQL, SAS/Graph. The data mart was featured in a SAS Communications magazine.

Bachelors Of Science, Computer Science

Education record