Louise Chen Email and Phone Number

· Re-engineered a robust model for Matched Maturity Funds Transfer Pricing (FTP) with design of complex yield curves, term funding spread, and option cost matrices. Created detailed workflow diagrams and spreadsheet calculation specifications. The design streamlined communication of rate configurations for new instruments among all stakeholders and shortened software development life cycles.· Provided comprehensive support to FTP rate model, including user cross-training, model enhancements, daily rate monitoring, and authored Matched Maturity FTP qualitative model documentation. Worked with regulators to remediate model risk findings including input weaknesses from upstream models.· Played a pivotal role in Wallstreet Suite to SimCorp investment system migration. - Configured Treasury’s issued debts and foreign currency instruments’ terms and conditions and accounting configurations in SimCorp. Mined data from Bloomberg and researched prospectus. - Create the chart of accounts and developed an Access reconciliation tool to validate expected journal entries and position reports. The tool cuts reconciliation processing time from one-day to 15 minutes which led to quick turnover of issues and the ability to run multiple iterations of mock testing prior to critical cutover deadlines.

· Implemented QlikView, a business intelligence software tool, to transition monthly business management, credit, and forecast reporting from spreadsheets to auto-generated reports published via intranet for Finance and Credit Risk Teams. Business users experienced a significant 50% reduction in report creation time.· Provided business and technical support to QlikView dashboards and scripts. Synthesized information from large groups to define enhancement requirements, functional system design, and test plan/scripts. Oversaw version upgrades.· Gathered requirements, provided business logic, developed test cases, and successfully upgraded FTP to Matched Maturity FTP model to align with the bank’s new FTP standard. Worked closely with Treasury, Tech, and QA Teams to promptly address post-implementation user enhancements and technical issues.

· Served as subject matter expert (SME) in Wells Fargo and Wachovia post-merger initiatives. Transitioned municipal and corporate bonds, stocks, and structured products between investment systems, PAM for Securities (PAM) to SimCorp. Responsibilities encompassed preparing instrument setup files, position reports, transaction history, accounting rules, and general ledger accounts for extract and import between the systems. Additionally, conducted security and trade set up test cases in the new system to ensure seamless transition and supported the migration of all legacy reports generated via Excel and Access using SQL and TOAD.· Served as SME for both PAM and SimCorp, specializing in Operations and Accounting configurations. This included GAAP accounting events and posting rules, cashflow set up, instrument configuration, general ledger and trade transaction postings, along with accounting scheme configurations.· Provided comprehensive support for PAM, covering software maintenance, version upgrades, cross-training, documentation of operating procedures, and addressed daily and monthly accounting and operational challenges with effective solutions.· Led key projects such as Straight Through Process utilizing Bloomberg trade capture, developed waterfall workflow chart for FTP model, and Bank Charter Consolidation initiative, which entailed merging and transitioning legacy GL accounts and posting rules to the consolidated bank standard, and user testing cases.

· Managed complete data mapping process during the investment system migration of all assets held by the Capital Markets Group, transitioning from spreadsheets and legacy investment system to PAM.· Served as SME for PAM and resolved daily and monthly accounting and operational issues.· Created and provided comprehensive support for Access reports and Excel macro templates to convert raw data from PAM into printable format for Balance Sheet, Income Statement, GL entries, transactions, and position reports.· Accountable for monthly Yield Analysis, QRM, and BASEL reports.

· Worked closely with traders, counterparties, credit officers, and custodian banks to ensure all trades are settled and funded properly.· Recorded transactions, tracked open positions, and security terms and conditions information in spreadsheets and legacy investment system.· Performed asset and cash reconciliations with custodian banks.· Responsible for publishing open position and transaction reports.· Ensured timely acquisition of month-end market prices from brokers for pricing valuation.