● Engage stakeholders in constructive dialogues to convert business problems into actionable logic problems solved through data analysis and visualization● Develop and maintained dynamic dashboards using R Shiny, tailored to stakeholder business needs, providing critical insights and competitive intelligence ● Lead design, development, improvement, and maintenance of both ongoing and ad-hoc projects and stakeholder requests● Automate data extraction and processing workflows by setting up Amazon EMR jobs, ensuring timely and efficient data availability on a monthly basis● Author and maintain Scala/Python scripts to trigger data processing pipelines, facilitating the seamless update of data stored in AWS S3● Play a key role strategy development initiatives by analyzing market trends and competitor data, equipping stakeholders with actionable insights to maintain and enhance Capital One's competitive edge in the market

● Developed and launched Geico’s new modeling application using R, to automate the existing pricing risk rating and modeling processes, reducing workload by over 25%● Lead the deployment of new rating models for multiple states, creating rules for existing state data, and conducting unit tests to ensure accurate risk pricing● Aggregated, analyzed, and manipulated multiple data sources across the last 7 years to create deliverables to address state filing compliance audits● Conducted statistical analysis over various tests and datasets to prevent overfitting by crafting decision trees for prediction optimizations on whether applicants owned or rented their property● Utilized data mining methods such as decision trees, clustering, and regression to predict which drivers from previous policies an applicant would add to his or her next policy for edge cases● Collaborated with multiple teams ranging from 6 to 10 team members; participating in daily stand-ups and mentoring interns and new hires

● Analyzed, aggregated, and processed large loan data sets from various servicers using SQL and Excel to ensure proper reconciliation of securities and correct monthly remittances for deals● Utilized VBA to automate the data reconciliation process for various servicer file types● Collaborated with loan officers and investors to ensure collateral is processed in compliance with deal documents and the investor reporting and wires are sent out by the contractual due dates● Managed monthly over remittances, under remittances and non-payments from hundreds of deals across many investor portfolios● Created reports using Excel for external clients and senior management for various deals ensuring that the reporting meets obligatory requirements and contractual deadlines