Harshwardhan Patil

Data Analyst @PNC

PA, US

Optimized transaction/payment processing fraud detection using SQL Server, Python Pandas, NumPy with ML pattern recognition, implementing data governance frameworks and data documentation standards in Excel that reduced manual review time.• Delivered regulatory accounting compliance reporting via Alteryx ETL workflows following SDLC practices, performing A/B testing on financial datasets that avoided $25K penalties through Excel pivot table validation.• Built Tableau dashboards analyzing workflow drop-offs using PostgreSQL queries and data modelling, coordinating requirements through JIRA with ERP (SAP) data sources, increasing completion rates 12% and preventing $50K monthly revenue loss.• Conducted data quality assessments using Azure infrastructure and Git version control, applying time-series analysis with Matplotliband adhoc reporting that reduced downstream errors by 40%.• Delivered Tableau dashboards from Snowflake warehouses using hypothesis testing and data modelling, providing insights that influenced $2M roadmap decisions and improved satisfaction scores by 18%.