Alex D. Noguera
*** ******* ******.********.**.**035 408-***-**** ************@*****.***
Linked in: http://www.linkedin.com/pub/alex-noguera/b/9bb
Qualifications:
Excel Macro Writing
Database Analysis / Reporting
Encompass 360 Query
Organization
Innovative & Resourceful
Trainer
Process Documentation
MS Office Proficient
Experience and Accomplishments:
Opes Advisors – 4160 Dublin Blvd. Suite 150 Dublin, CA 94568
Shipping Manager Jul 2015 – Nov 2016
Manage loan delivery function of loans for purchase by our Investors. Department also obtains insurance for government loans for FHA and VA loan programs. Other departmental obligations we handle is the loan delivery of files for investor post closed reviews, government agency audits and strategic partner (MI Companies & Warehouse line providers) reviews.
Created production loan delivery reports to establish metrics to track departmental productivity for all areas.
Committee member for product development and loan origination system (Encompass 360) enhancement.
Gateway Bank F.S.B. – 2201 Broadway St Suite 403 Oakland, CA 94612
Financial Planning Business Analyst Sep 2013 – Jul 2015
Manage Daily and EOM Production Reporting for Finance and 2ndry Marketing divisions. Serve as back up in 2ndry Marketing performing Loan Allocations and Pricing/Lock Desk functions. Provide Ad Hoc Reporting to all divisions. Refine and maintain desk procedures.
Data Analyst for current Accounting GL Data Migration
Built Encompass LOS data extract files for Loan Servicing and 2ndry Market Pricing Model.
Enhanced Budget Variance EOM reporting with Macro and Pivot Table Driven spreadsheets
Built production Macro and Pivot Table driven spreadsheet to Balance GL with Loan Origination System.
IT Business Analyst May 2007 – Sep 2013
Manage Daily Production Reporting Que. Provide Ad Hoc Reporting to all divisions. Refine and maintain desk procedures. Assist with Administrator Duties for Network Software applications. (Support, Upgrades & Security)
Business / Data Analyst for Operations LOS migration from Genesis to Encompass
Built NACHA text conversion files for upload to Accounting GL vendor.
Developed Company Dashboard to allow for interactive reports to reduce time and paper copies.
Support data reporting requirements for Accounting, Servicing and Warehouse Lending
Loan City – 5671 Santa Teresa Blvd Suite 100 San Jose, CA 95123
Capital Markets Operations Manager May 2005- May 2007
Manage and developed data reporting & data integrity for all areas of Capital Markets. Serve as backup to
Perform pricing desks duties. Developed and created workflow procedures.
Maintain manual for operational procedures, keeping process & procedures current for all employees.
Integrated Power Seller software into daily workflow process resulting in better management of trades.
Gateway Bank F.S.B. – 2306 Merced St. San Leandro CA 94577
Secondary Marketing Data Manager Jul 2001 – May 2005
Managed daily lock desk operations, priced daily rate sheet, fielded customer service pricing calls. Distributed &
Modified pipeline reporting information. Primary contact for investor relations regarding locks & purchases.
Modified & Streamlined rate sheets process with auto links to Investor rate data sources.
Assisted in the design & development of custom Mark to Market Model.
First Franklin Financial Corp – 2150 N First Street San Jose CA 95131
Operations Manager Mar 1999 - Jul 2001
Overall Manager of Daily Operations for Records Center. Managed staff of 30.
Provided customer support for Whole Loan Sale investors.
Defined & created structure for loan file flow & loan mail to meet loan sale & other departmental record needs.
Continued report creation and refinement for business unit. Measured production levels for the Department, Senior Management and Outside Entities (Auditors, Regulators).
Developed and maintain disaster recovery plan for Business Unit.
Education: University of Phoenix-San Jose Campus - Bachelor of Science, Business Admin. Apr 1996
AS/400 Advanced System Operators Workshop, Certificate of Completion
Writing Queries using MS SQL Server 2008/2005/2000, Certificate of Completion