Tilak Mandal, CFA

Experience

• 

  Merrill Lynch

  Nov 1998 - Sept 2001

  Trade Specialist

  - Processed real-time financial transactions including stocks, options, and mutual funds.- Trained and mentored employees as they were given increasing levels of responsibility.- Passed Series 7 and 63

• 

  The State of Colorado

  Sept 2004 - Feb 2008

  Statistical Analyst

  - Managed the data collection process for the State of Colorado Annual Student Census.- Led the development team charged with creating the State of Colorado Data Collection System designed to calculate annual graduation rates to comply with federal mandates.- Regularly reviewed collections to streamline and remove unnecessary fields. Ensured Data Dictionary was up to date with collection changes. Developed test scripts to validate changes for each data collection.- Provided technical assistance and training to school districts regarding the submission of data for mandated collections.- Responded to data requests and prepared reports regarding Data and Research Unit data.- Prepared presentations for the State Board of Education and State Legislature.- Served as the departmental liaison to the US Census Bureau for updating Colorado school district boundaries to facilitate the production of census data by school districts. Show less

• 

  The Federal Reserve Bank of Kansas City

  Mar 2008 - Feb 2015

  Senior Financial Analyst

  - Prepared memoranda and presented to Senior Management on an array of topics which focused on developing trends and issues in financial markets and the banking industry.- Queried relational databases using SQL to build datasets designed to evaluate the impact of proposed regulatory rules on banking capital and liquidity.- Conducted Model Risk Management review as part of Dodd Frank Act Stress Testing to verify compliance with “SR 11-07: Guidance on Model Risk Management”.- Constructed complex financial models to support the quarterly monitoring of depository institutions across the nation, with a specific emphasis on asset quality, capital, and liquidity.- Collaborated with risk specialists to evaluate how new and proposed regulations would affect the District’s portfolio of State Member Banks.- Performed in-depth analysis of bank holding company financial statements (consolidated and stand-alone), bank and thrift financial statements, and SEC filings.- Developed financial risk outlier reports for internal surveillance monitoring, which were later used by peer regulatory agencies.- Conducted credit reviews, using fundamental analysis, of municipal bond portfolios and analyzed cash flow characteristics with the goal of identifying improving or deteriorating conditions.- Created a training program for new employees covering the basics of SQL programming, regulatory reporting, bank examinations data, and banking structure.- Designed reports and tools to assist examiners with the offsite monitoring of Tenth District regional banking organizations.- Worked with team members to prepare and present the Tenth District Risk Report and Surveillance Summaries to senior management and the Reserve Bank President. Show less

• 

  Federal Reserve Bank of San Francisco

  Feb 2015 - Oct 2019

  Manager, Data Analytics

  - Managed a seven-person team of model developers and financial analysts while overseeing long-term strategic planning, internal product management, and staff development.- Collaborated with Federal Bank Examiners to understand and define their needs and expectations for project deliverables.- Developed a comprehensive model risk management framework for bank examiner tools and models; included policies and procedures, validation scripts, and comprehensive code reviews to maintain business continuity and ensure data governance.- Provided second-line oversight of the Federal Reserve quantitative risk models. Evaluated the conceptual soundness of model specifications, assessed model assumptions and limitations including input data and parameters, design and methodology.- Constructed SQL datasets to estimate the probability of default for different loan categories based on loss history.- Leveraged Tableau business intelligence software and data tools to create insightful visualizations that supported information sharing and identified emerging risks.- Worked with internal innovation teams in order to assess the feasibility of implementing new technology to enhance current processes and scope future projects.- Cleansed and standardized loan-level data from depository institution MIS to create visualizations designed to identify deterioration in underwriting standards, changes in business models, and interest rate risk.- Directed the development of text pattern matching applications to review internal bank documentation. One solution streamlined the Bank Secrecy Act risk identification process.- Researched the use of machine learning algorithms to identify inadequately capitalized depository institutions. Show less

• 

  Charles Schwab

  Mar 2020 - now

  Senior Manager

  * Responsible for developing and maintaining the firm’s Y-14A reporting system.* Prepare, analyze and file FR Y-14 Regulatory Reports to Federal Reserve on an annual basis.* Work with stakeholders (report owner, report producer and other key SMEs supporting reporting production) to document and maintain risk based Critical Data Elements used.* Review existing data quality controls and design fit-for-purpose data quality requirements.* Work with technology to implement data quality rules and perform User Acceptance Testing.* Interact with stakeholders across the firm including Technology, Capital Markets, Regulatory Reporting and the respective modeling team members.* Support the interaction with US Federal Reserve and both internal and external auditors, which includes interpretation of new and amended accounting and regulatory requirements.* Manage the continuous assessment & enhancement of regulatory reports, including the retention of supporting documentation and operational risk identification, and where necessary remediation. Show less