Meher Venkat

Data Analyst @PNC

US

Streamlined financial data from legacy SQL Server sources into Snowflake using dbt transformation models and Alteryx workflows, improving data availability and enabling faster, more accurate quarterly reporting across mortgage operations.• Deployed Tableau dashboards with Ask Data natural language querying to continuously monitor mortgage product KPIs using time series forecasting models that identified $1M in untapped revenue opportunities for executive stakeholders. • Executed customer segmentation analysis using Python, Pandas and scikit-learn across banking customers, enabling targeted personalized mortgage product recommendations that significantly increased offer acceptance rates by 35% across all campaigns. • Executed A/B testing and Python Pandas churn behavior analysis on mortgage loan customer data, surfacing early attrition signals that directly informed retention strategies and reduced overall customer churn by 40%. • Enhanced mortgage data quality monitoring by implementing Alteryx and SQL automated validation workflows across reporting pipelines, enabling consistent error detection and reducing manual reconciliation time for all financial reporting teams.