Sal Martinez Email and Phone Number

• Streamlining manual processes by creating self-service BI solutions.• Business Intelligence, Data Warehousing, and ETL Development.• Performing complex systems development & analysis with numerous BI Tools.

• Supervising the creation and delivery of servicing fee collection reports for a $170 billion UPB Co-invest mortgage loan portfolio and providing remittances to investors in accordance with structured financing agreements.• Performing fluctuation analyses of servicing fees, prepayment speeds (CRR, CDR, CPR), loss rates, and delinquencies metrics, researching and presenting root causes to external partners and internal management• Creating and delivering billing files to Master Servicers for the cash-out portion of recaptured refinances based on changing pricing grids • Maintaining Co-Investment database which tracks encumbered assets that are part of structured finance agreements.

• Created reports and dashboards for different business units and external investors.• Identified and modified Key Performance Indicators (KPI’s) for dashboards that I created or maintained. • Wrote DDL and DML scripts to create, modify, and delete database objects. • Responsible for extracting information from different OLTP systems, transforming the data, and loading it into a semantic layer.• Created and deployed SSIS Packages to automate reports created.• Created Tables, Views, triggers, functions and stored Procedures in T-SQL• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the databases.• Deployed SSRS reports with different functionality like drill down, drill ‬‬‬through, and sub reports

• Converted manual tests to data driven test to improve department efficiency. This lead to a reduction of offshore representatives and improved testing by testing 100% of a population and not just a 5-10% sample.• Communicated with different business units to develop tests around CFPB, FDCPA, OCC, AG, State Regulations, and other regulations.• Wrote complex SQL queries to pull populations for compliance tests. • Created dynamic reports using dynamic SQL allowing management in the department see compliance test scores at different time periods. • High level reporting for the AVP, VP and SVP upon request.