Data Analyst
Current● Build a PowerBI dashboard for the Customer Service department to identify duplicate charges on residents’ accounts to reduce customer service calls on billing errors.● Create a PowerBI dashboard for 2020 & 2021 NYC renewal lease increase dates; 10% improvement in data entry and data cleansing process.● Construct a complex case when query in SQL Server Management Studio SSMS, to produce 2020 & 2021 list of renewal units to ensure NYC rental laws are being abided by; 8% decrease in error task request.● Enhance an ad-hoc report by importing community data into SSMS that aided in deeper analysis and data verification.● Extract and transform raw data in Microsoft Excel from wire transfers to actionable data for the Loss Mitigation department; increase payment process data accuracy by 5%.● Transform a fully manual scorecard to a semi-automated procedure with VBA coding; led to a 25% reduction in human errors on associate monthly evaluations and increased turnaround.