Analysis And Reporting Associate
Pasadena, Ca
Oversee integrity of data production and reporting as well as the quality and timeliness of report distribution by junior analysts for this global financial services firm. Develop and maintain RDBMS of data for the company’s Multi-Family and Commercial Mortgage Lending origination system used for reporting, compensation payouts, capital markets hedging and marketing. Mentor team members on data integrity and report accuracy. • Collect requirements, create and manage daily, weekly and monthly reports related to sales, credit, underwriting, operations, servicing and senior management that contributed to the increase of originations from $200mm/month to up to $1b/month.• Track and review operation group’s performance, examining turn-time trends and productivity on a weekly basis. • Documented business and system requirements that enabled the technology group to design and develop the data warehouse and reporting structure for the Multi-Family and Commercial Lending origination system.• Instrumental in overseeing the successful transition of the RDBMS database from MS Access to SSMS, which resulted in improved report generation capability and distribution efficiency.• Create and maintain Stored Procedures, Tables, Views, In-line Table Value Functions for entire Commercial Term Lending Originations and Portfolio data in SSMS database.• Serve as a liaison between line of business and Compliance in producing metric reports for Regulation B and creating data file (LAR) for Regulation C and to ensure regulatory compliance which lead to a less than 1% error rate.