• Developed Python scripts and utilized AWS Lambda, S3, and RedShift to assemble the data pipeline process to accurately gather and store invoice data from AWS Security's vendors in the China region.• Created the Vendor Spend dashboard that visualized real-time spending vs budget data to monitor excess spend resulting in a 15% decrease in over-budget spend.• Scripted Python ETL jobs to centralize disparate data sources and automatically load data into Redshift resulting in increased visibility of security audits.• Built QuickSight reports monitoring weekly headcount metrics and gaps towards hiring goals for AWS Security Assurance leadership.

• Leveraged internal and external data sources and researched industry trends to provide analytical support to the Security and Real Estate Management strategy for all of Capital One’s corporate offices, branches, and cafes.• Queried data from PostgreSQL and Snowflake data warehouses in order to advise on operational trends, conduct pilot program testing, and present recommendations to senior leadership resulting in a 20% increase in office space utilization.• Developed Tableau dashboards and automated reports for stakeholders to continually monitor and gain new insights into business operations with real-time data.• Created an automated data pipeline, in Python, that compiled data from disparate data sources to create a single-source dataset for arrival time analysis.• Defined the key performance indicators structured in Capital One’s contracts with its food and facility management vendors resulting in increased performance in budget adherence, sustainability, and service levels.• Presented monthly business reviews to the Vice President of Security outlining performance against key metrics, benchmarks, and imperatives.

• Oversaw multiple teams of Data Engineers and Data Analysts within the Auto Finance division on a company-wide data migration project to transition from on-premise data servers to AWS.• Created detailed project plans, risk mitigation strategies, and milestones that resulted in successfully meeting the tight deadlines set by data center exits.• Delegated roles and responsibilities, team structures, and meeting cadences which led to clear communication between teams and on-time project delivery.• Presented weekly updates to the Senior Vice President outlining progress of the project, presenting recommendations, and escalating issues if needed.• Directed the budget, hiring, and allocation of over 30 contracted Data Analysts to both the internal and external project work streams within Auto Finance.

• Presented a proposal to chief executives on how Amica should market its products to millennial customers as part of the summer internship program.• Researched and summarized the marketing positions and upcoming product campaigns of other insurance providers to benchmark Amica’s performance.• Revised the hiring process by implementing pre-employment simulations resulting in increased job-fit evaluation and reduced turnover for Amica’s claims adjusters.