John Kowalczyk Email & Phone Number

New York, United States

Buffalo, New York, Us

London, Gb

Identify and mitigate treasury risks including liquidity, interest rate, operational, model, and compliance for a $250 billion consolidated balance sheet and subsidiary entities in a global bank requiring compliance with multinational risk limits, policies, and regulations.Led the preparation and delivery of Dodd-Frank Act 165(d) resolution plan for the consolidated US operations making recommendations on corporate structuring options to enhance critical services continuityPlan and evaluate financial recovery and restructuring options under various stress scenarios and in consideration of global and local resolution regimes. Subject matter expert in behavioralized and contractual cash flow calculations and forecasting, prepayment modeling, interest rate risk, balance sheet modeling. Experience with interest rate risk systems, modeling, and reporting requirements, design, testing, and implementation.Manage audits and regulatory exams of interest rate risk, funds transfer pricing, liquidity reporting, stress testing, intraday liquidity, and contingency funding. Plan and execute regulatory compliance and internal control deficiency remediation projects.Developed cash flow forecasting model integrating contractual cash flows, modeled assumptions, and business plan forecasts for multiple entities Proactively assess operational processes, risks, policy and regulatory compliance and control effectiveness identifying and implementing efficienciesLed remediation and validation of regulatory reporting including 2052a, collateral monitoring reporting, cash flow forecasting, and resolution planning performing interpretation, mapping, and validation of regulatory and policy requirements; reporting and analytical process design; controls and governance

Buffalo, Ny, Us

Provide leadership, vision, and direction in the start-up of an enrollment analytics capabilityProvide guidance for the principles and practices of enrollment management and the use of data and analysis to support enrollment decisionsImprove data collection and processes and promote the strategic use of information and technology enabling the University to use information to its competitive advantage in targeted recruiting and efficient admissions funnel management to meet class enrollment goals Developed models to support efficient use of scholarship funds to maximize freshman class SAT scores while balancing access and opportunityProvide oversight to the collection, management, analysis, and reporting of student retention, persistence, and graduation rates

Buffalo, New York, Us

Manage a team of analysts to produce a monthly balance sheet forecast, interest rate risk, and earnings at risk analysisInform ALCO and other senior and executive level management of the bank’s projected interest income, margin, and interest rate risk position through monthly presentations, reports, dashboards, ad-hoc analysis and written commentariesResponsible for all aspects of the bank’s ALM model and reporting from data collection and validation, model configuration and tuning, and portfolio level analysis to performance benchmarking and back testingConduct regular analysis and benchmarks to monitor and identify deviations in the bank’s portfolio composition, funding sources, capital and other ratios, earnings, risk and performance metrics relative to industry peersManage special projects including CCAR stress testing, M&A analysis, and implementation and testing of quantitative modelsLead for internal, external, and regulatory reviews ensuring compliance with SR10-1 and model validation and risk management framework.

Buffalo, New York, Us

Manage a team of systems and data analysts responsible for the technical administration and data management of the bank’s ALM risk model, QRM, including software and hardware updates, and database managementEstablished appropriate documentation, controls, and workflow on data and processes to ensure the integrity, reliability, and accuracy of data in a highly audited and regulated environmentWrote a comprehensive documentation and procedures manual including plans for disaster recovery and business continuity Provide analysis on monthly position data with regard to balance sheet management, ALM and IRR to senior managementCompile monthly analysis and report of bank EVE and EVS. Monitor compliance with established risk metrics and communicate elevated risks to management, ALCO, and other governing risk committees

Buffalo, New York, Us

Reengineered treasury data processes and model infrastructure significantly increasing the frequency, accuracy, and availability of data and related analysisDesigned and created a data mart that was used by various departments for a cross section of disciplines and subsequently identified by internal audit and external consultants as “best in class” and used as a model for organizational standardsAutomated ETL interfaces using MS SQL SSIS packages while validating transformations and assumptionsReduced model current position setup time by 75% and balance variance to the general ledger by over 90%Created data validation and exception reporting processes to ensure the integrity and reconciliation of data mart and model data

Managed IT infrastructure ensuring the availability, capacity, integrity, and security of the ID card based payment transaction systems and dataAnalyze data from a database of over 43 million financial transactions to produce financial reports, customer statements, management dashboards, analysis, identify trends, and monitor for aberrations and irregularitiesCustomize and automate data extraction, transformation, and loading between systems and data stores while ensuring data availability, quality, integrity, and reconciliationPlanned for, evaluated, and purchased technology hardware, software, and services to enhance IT environment

Mba

Computer Science