Consultant Dba, Sql Programmer, Data Reporting, Qi, Support, And Training
CurrentI am a consultant to social services agencies which find themselves with inflexible or underutilized database software or who seek to combine and rationalize multiple sources of data to meet regulatory, accounting and workflow needs. As of January 2020 I am available for contracts under 20 hours a week, or short term full time work, but am not seeking full time, permanent job offers.I provide SQL scripting, data reporting, government compliance, normalization, analysis, and application support to several NYC based housing and social services agencies. I specialize in adapted reporting from Netsmart Evolv or any MS SQL based application, using Reporting Services and bespoke reporting,using Structured Query Language.I have long experience with the HMIS data sets, APR, AHAR, and supporting data for NOFA requests. This includes in Continuum of Care relationships, other regulatory reporting and relations, such as NY State OMH, New York City agencies, and HUD, as well as HUD-VASH with the VA. I have provided new software roll out, workflow creation, form design and implementation, program staff buy-in, training, and data quality remediation. I provide special training, auditing, and oversight for HIPAA / HITECH Act covered entities for staff, workflow, IT needs, and follow up auditing. Long experience has given me broad knowledge of the work and requirements of social services providers and mental health clinicians. I have provided workflow development and trained staff in all aspects of charting, EMR usage, NYS Medicaid billing, broader IT, and security.As a member of Regina Project ( reginaproject.net ) I provide training, administration, and support to agencies using SQL Clinic software.Tools: Netsmart Evolv, MS Reporting Studio, MySQL/PostgreSQL/T-SQL, MS SQL Server Management Studio,, R, SPSS, Crystal Reports, Foothold Awards, Social Solutions Efforts-To-Outcomes, Netsmart Avatar, Excel, OpenOffice/LibreOffice suites and SQLClinic.