Svp, Performance Measurement Manager
Created multidimensional and activity based profitability reports for enterprise and down to the customer relationships level.Engaged Fund Transfer Price (FTP) methodology and capital allocation to produce profitability result, plus utilizing operational metrics to determine relationship profitability from transactions all the way through aggregated household.Using the profitability reports to assist executives and division leaders to manage their portfolio effectively and to maximize client’s relationship.Managed the bank’s warrant portfolio. Track all incoming warrant, reconcile warrant portfolio for reporting and exercised warrant when applicable. Achieved efficiency in bank wide reporting. Lead a three member team converted and consolidated over 1000 reports to less than 300 reports during the bank’s core system from FISERV to current FIS system. Reduced over 70% of duplicate efforts in report creation.Responsible for the bank’s data warehouse report system, Business Intelligent Center (BIC). Centralized report creation and standardized reports. Ensured all users received their reports in accurate and timely through the use of extract generator, the automated scheduler. Reports used for financial reporting, operational function report, regulatory and compliance reports.Produced reconciled portfolio data for external vendors to perform real estate geographical concentration and stress test.Collaborated with Credit and Sales Department to create a database for gathering data on real estate and SBA loans that were not available in the bank’s core system. Created product flow chart for loan booking to meet Call Report requirement.Created data file for the bank regulator’s annual safety and soundness Exam.Certified monthly and constant evaluate accounting procedures and process meet Sabane-Oxley (SOX) requirement.