Carlos Esquerra Email & Phone Number

Support various Line of Businesses with their reporting needs

Lewisville, Texas, United States

Lewisville, Texas, United States

Build Reports for various Line of Businesses using SQL, SSDT and SSRS by creating stored procedures and tables

Irving, Tx

Utilize SQL, Excel and PowerPoint to create Reports, Refreshables, Dashboards as needed by the Escrow Teams or upper management.

Irving, Texas

Oversee Transfer of FHA cases, Tax contracts, PMI Certs, USDA IDs. Oversee the escrow analysis, tax, insurance, loss draft, optional insurance and MI teams and ensure that deadlines are metCoach employees and ensure that procedures are followed and tasks are being worked properly.Monitor vendors to ensure escrow lines are being setup correctly and payments are being remitted. Ensure that refunds are applied correctly to the loans. Provide reports to upper management when requested. Be the point of contact for any escalations regarding escrow.Was the point of contact for Escrow in the acquisition by Mr. Cooper

Irving, Texas

handle pmi, flood, mip, and tax contract transfers to new servicers on service released loans. build reports and monitor all departmental monetary transactions to ensure corporate accounts are reconciled correctly. Ensure that vendors are funded for Tax and Insurance disbursements. Create and maintain Excel and Access automated templates as well as refreshable tables.Process Wires for loans boarded the prior day.Process payments to vendors for loss draft inspections, property and preservation, and optional insurance.Provide posting instructions to Cash Department for deposits on Taxes, Insurance, and loss drafts.Process Loss Draft checks .Review charge back from new servicers on serviced release loans.

Irving, Tx

build reports and monitor all departmental monetary transactions to ensure corporate accounts are reconciled correctly. Ensure that vendors are funded for Tax and Insurance disbursements. Create and maintain Excel and Access automated templates as well as refreshable tables.Process Wires for loans boarded the prior day.Process payments to vendors for loss draft inspections, property and preservation, and optional insurance.Provide posting instructions to Cash Department for deposits on Taxes, Insurance, and loss drafts.Process Loss Draft checks .Review charge back from new servicers on serviced release loans.

Irving, Tx

Review Monthly Analysis Exceptions created by business rules.Work on task opened by other lines of business in a timely manner.Build SQL Reports based on departmental needs.Analyze escrow accounts.Help Accounting to reconcile the department's deposits. Help create Excel templates to automate processes, and maintain templates already implemented.Remit payments to vendors for loss draft inspections and optional products.Identify any trends that may cause issues on customers and the company.Provide daily inventory and productivity tracking.

Pantego, Tx

Retail Liquidation ServicesSell liquidated merchandise wholesale and retail

Ft. Worth

Review inbound correspondence and find resolution to customers' issues and concerns. Draft outbound letters to respond to customers with the resolution/outcome of their request. Handle Notice of Errors, QWR's, Debt Validations. Train and help other associates to perform daily operations. Run reports that provide daily work assignments as well as task currently in progress. Pay attention to the customer's correspondence to determine any trends or issues that need to be researched and/or corrected.

Help Mortgage Companies with any Business Operations

Irving, Tx

Reverse Mortgages - Title Assignment Package Review.

became Metlife home loans in september. moved position

Bachelor'S Degree, Information Technology

Not Completed, Business Computer Information Systems

High School Diploma