KEY ACHIEVEMENTSBuilt a process for restating FTP ▪ Profitability team needed a restatement for loan FTP in time for a release and Treasury claimed it would take them 2 weeks due to an antiquated process in Excel ▪ Rebuilt the process in Alteryx, Python scripts, and Snowflake to complete the restatement in 2 daysDesigned the team’s Snowflake database to house profitability data. Highlights include: ▪ Worked with IT to set up appropriate roles and schemas, including roles for users to move data across databases ▪Implemented a row-level security model to provide data to line of business users who have restricted access ▪ Created stored procedures and scheduled tasks to update a number of tables daily for consumption by users and other platforms Remediated several processes that were housed in MS Access databases ▪Automated the process to run in Alteryx with a single user input, exporting output files onto the share driveRESPOSNIBILITIES• Serves as data steward for product & client profitability data that reports on profitability for all areas of the bank• Creates & maintains self-service reporting packages in SAP Business Objects• Key contributor on system enhancements for the profitability platform and responsible for creating business requirements and validation of data • Identifies breakdowns and errors in data and reporting, works with the Data Engineering team to correct those errors

OneWest Bank division - Analytics & Strategic InitiativesKEY ACHIEVEMENTSImproved efficiency by creating a SQL Server based platform to ingest data from data warehouse allowing for an automated reporting process▪ Automated posting of sales scorecards directly to SharePoint, and emailing campaign reports directly to stakeholders▪ Created an automated process for tracking customer incentives where a customer had to meet requirements to get a cash rewardPerformed as mentor to junior analysts who have gone on to successful careers as data professionalsRESPONSIBILITES• Provided strategic guidance and actionable insights to the Director of Marketing and the Marketing Department.• Performed as Lead Analyst on a team that supported many areas of the Retail Banking Group, including marketing, branches, call center, and branch operations• Created acquisition financial models for marketing campaigns• Analyzed customer data to create marketing segments• Provided data to third-party vendors to create customer segmentation and then appended segmentation data into the data warehouse.• Created and maintained a suite of deposit and customer reports for the Retail Banking Group

Mortgage Servicing - Servicing Operations Analytics and ReportingKEY ACHIEVEMENTSCreated a tool to generate data for common ad-hoc requests▪ Used SQL, Excel, and VBA to allow a user to input accounts and automate the output from several data sources▪ Developed a script in VBA to retrieve data row by row due to system limitations saving countless man-hours and reducing errors in generating these reportsRESPONSIBILITES· Used SQL Stored Procedures and SSRS to create and maintain reporting for the Short Sale and Deed-in-Lieu line of business· Prepared and delivered sensitive reports to investors under strict deadlines · Created reports and provided analysis on an ad hoc basis for various levels of management, investors and government agencies (HUD, OCC, and CFPB) where timeliness and accuracy was imperative· Relied heavily on use of SQL, SSRS, SSIS, Access and Excel (VBA) to develop reports

Correspondent Lending DivisionKEY ACHIEVEMENTSDeveloped and prototyped a scoring system for mortgage sellers ▪ Pulled data with SQL queries and did transformation in MS Access▪ Used statistical analysis to determine seller’s elasticity and identify those sellers most/least likely to successfully deliver their loansSaved the organization millions of dollars by building an audit platform▪ Used SQL and the data warehouse to identify system errors & points of failure ▪ Produced 2 dozen audit reports to SharePoint using SQL, Stored Procedures, and VBA scripts▪ Tracked the curing of the audit reports in SharePointRESPONSIBILITIES· Provided actionable insights to improve profit margins based on customer (mortgage sellers) behavior· Verified the accuracy of pricing updates provided by secondary marketing department