Derek Van Email & Phone Number

Brooklyn, New York, Us

Brooklyn, New York, Us

Lead engineer responsible for data engineering at Alma. Responsibilities include:- Data strategy- Database design and maintenance- Ingesting new data sources- Designing, writing, and maintaining business data models- Consulting with product software teams and business users on features- Creating analytic dashboards for end users

Eden Prairie , Mn, Us

Lead team of analysts in Risk Adjustment to support the Medicare chart review line of business- Review analyst code and data to ensure high-quality deliverables- Standardize practices and create training materials and procedure guides- Schedule and assign analyst workloads- Research and resolve urgent data quality issues- Coordinate with other teams to support the chart review deliverable pipeline

Eden Prairie , Mn, Us

Database design, management, and analysis. Some duties include:- Performing exploratory data analyses for State customers to provide insights into business questions. Help customers understand the data they own, and how they can utilize it.- Preparing formal reports, graphs, and tables to support State decision-making. Strong focus on presenting findings in a way that is easily understood by the customer.- Creating and maintaining data models to support end-user database queries- Designing and maintaining databases to store data from external applications.- Primary data warehouse business owner for nursing home and adult services divisions.

Ann Arbor, Mi, Us

Pull and analyze complex data sets to support research. Some duties include:- Working with researchers to translate research questions into actionable data- Pulling data from multiple large and complex data warehouses. Extensive experience with Michigan Medicaid, immunization, and blood lead data warehouses.- Designing, creating, and maintaining the workforce survey database for the American Board of Pediatrics. Advise faculty on database capabilities and pull data to identify workforce trends.- Monitoring trends in health services usage in support of state healthcare initiatives, such as the Healthy Michigan Program (Medicaid expansion), and the State Innovation Model (cost and care coordination).- Rewriting legacy code to increase efficiency and improve documentation. Recently rewrote a bi-monthly data pull and decreased run time from two days to two hours.

Analyze workers compensation data and help support the division’s database. Some duties included:- Providing recommendations and data analysis to support management decision-making. This includes running ad-hoc queries and creating models to detect trends.- Leading a project to improve data quality in the division’s database. Directed a team which interviewed end users to identify current business data entry practices and wrote over 1500 SQL scripts which identified data fields with invalid values.- Serving as a team member on a digitization project. The division transitioned from paper to electronic submission of workers compensation accident reports. Coordinated systems testing and supported external customers. - Collaborating with end users and the IT team to troubleshoot and enhance the division’s database.

Master Of Computer And Information Technology, Computer Science

Master'S Degree, International/Global Studies

M.A., Global & International Studies

B.A., Philosophy & Religious Studies