Kelvin N.

Data Analyst @Vibrant Emotional Health

New York, NY, US

Developed and maintained ad-hoc queries in SQL Server while ensuring readability, scalability, and consistency to inform decision-making for stakeholders and supervising team.Programmed ETL pipelines in python that increased mental health resource allocation by 300% through KPIs.Implemented data visualization in Tableau to drive insight and innovate clinical analysis, and increased service throughput by 140%.Created Tableau Dashboards utilized for stakeholder meetings to track key metrics like length of stay, discharge rate, time series analysis, geoinformation, community demographics, and employee performance to service high needs within community.Performed geospatial analysis and streamlined data to end users that increased community outreach by 250% and enhancing mental health service accessibility towards vulnerable high needs areas.Managed cross-functional teams to ensure the accuracy of the constraints of NYC Department of Health and Mental Hygiene guidelines.Utilized Python for development of data auding tools to ensure the integrity of data inputs and process improvement within DOHMH’s Electronic Health Record Maven.