-Leading data quality control efforts, performing comprehensive data analysis, and implementing quality assurance processes to ensure accurate and reliable data resulting in 97% data quality from specialists.-Conducting data wrangling processes on large datasets to produce weekly KPI metrics reports for 43 individual specialists, and create visualizations in Excel using pivot tables to effectively communicate with stakeholders.-Creating automated production templates utilizing power queries, macros, and advanced LOOKUP functions to streamline specialist workflows resulting in a 95% on time deliverable for pitchbooks.

-Utilized inferential and descriptive statistics to identify water pump failures signals by running multivariate regression equations, time series analysis and correlation heat maps.-Produced interpretable presentations and visualizations in Tableau of analytical and business solutions for audiences of 10+ members of varying technical ability.-Developed SQL queries and Python code to clean large datasets and extract actionable business insights to stakeholders.

-Conducted comprehensive analysis using SQL and PyCharm on Bloomberg client help desk queries, ensuring accurate and timely responses to concerns regarding inaccurate data posted on Bloomberg machines, resulting in a 93% client satisfaction.-Implemented new issuance templates for mortgage-backed security deals via Linux and Excel templates, resulting in a 100% same-day release to terminals.-Established and maintained strong business relationships with lead managers of multi-billion-dollar deals, fostering effective communication and collaboration.

-Performed phone interviews with borrowers, analyzed mortgage amortizations for various mortgage products, and performed personal credit analysis resulting in over $11 million in retained business.-Simultaneously managed upwards of 25 accounts at different stages of the mortgage loan process, ensuring organization and effective communication with various departments and clients.