Gather and analyze complex data to extract valuable insights to assist with business strategy decision making. Utilize advanced analytical techniques and tools such as SQL, SAS, Python, and machine learning, conduct in-depth data analysis and create reports and visualizations to effectively communicate findings to stakeholders.Report on daily or weekly status of savings, checking, and certificate of deposit (CD) accounts. Produce reports highlighting key metrics such as CD term, marginal costs, percentage of new money versus migrating money, and production in each market. Compile and present retail analyst report quarterly showcasing bank's performance in retail space. Create ad-hoc reports designed for custom analysis. Update and automate reports regularly to enhance efficiency.* Consistently meet performance and financial goals set by leadership, demonstrating commitment to PNC's customer focus, enterprise risk management, retail deposits goals, and adherence to bank's values.* Contribute to generation and analysis of best rate summaries, which compares rates offered by other banks across various financial products; ensure PNC competitiveness by aligning rates with industry standards.* Perform data analysis and reporting functions related to multiple CD terms in various markets, including analyzing sales and performance metrics of CDs in each market. Distinguish between money sourced internally and new external funds.* Analyze CD rates across various markets and initiate rate adjustments in states to improve competitiveness. implement rate exceptions to retain customers.* Examine high-yield savings accounts exceeding $5 million threshold monthly; share insights with team members.

Analyzed financial data and developed mathematical models to identify trends, risks, and opportunities. Utilized statistical techniques and mathematical models to analyze large datasets related to financial markets, transactions, and economic indicators. Created and implemented quantitative models, applying knowledge of digital and branch channel impact on account performance. Performed data analysis and reporting functions, ensuring data cleaning and preparation to maintain data reliability and accuracy. Created understandable and actionable reports and dashboards using tools such as MS Excel and Tableau.Utilized SAS and MS Excel for channel optimization by preparing large datasets for modeling, conducting deep dives into data, and driving future business strategies. Provided recommendations for risk mitigation strategies. Tracked market trends, economic indicators, and industry developments to inform quantitative models and strategies. Oversaw ad-hoc projects from team members and managers to meet specific data requirements.* Evaluated launch and performance of "Key Active Savers Account" through direct mail campaign. Analyzed origination channels, initial deposits, and customer tenure. Identified opportunities for optimizing digital and branch channels.* Investigated attitudinal segments among clients originating accounts through different channels, providing insights for tailoring future campaigns and improving customer engagement strategies.* Undertook comprehensive analyses for rule development projects, particularly focusing on Automated Clearing House (ACH) transactions. Employed exploratory data analysis (EDA), data cleaning, feature engineering, and data segmentation techniques to identify patterns indicative of fraudulent activities. Contributed to enhancement of security in ACH transactions and provided valuable insights into fraudulent activities within payment system.