Financial Services Project Manager & Transformation

Wei Guan, M.S.

781-***-**** *******@*******.*** linkedin.com/in/wei-guan1

Bank Project Manager

Analytical, multi-tasking, organized, detail oriented financial services project manager offering expertise in managing complex financial service technology driven projects, ensuring regulatory compliance. Strategic, results-oriented, collaborative manager and proactive, resourceful team player with a hands-on approach and demonstrated success in meeting tight deadline, directing diverse, cross-functional teams to implement financial modernization initiatives, steer digital transformation, process optimization, and improve financial performance and operational efficiency.

CORE COMPETENCIE

Project Management Written / Verbal Communication Teamwork / Coordination Process Improvements Strategic Planning Problem Solving Investment Operations Business Transformation Reporting Training Research Asset Servicing Audit Risk Compliance Client / Partner / Stakeholder Engagement Alternative / ETF Accounting Global Custody Operation

TECHNICAL PROFICIENCIES

Alteryx Xceptor TLM Duco BlackLine Arrow Advanced Excel Tableau Power BI Access Database Major global financial tools SWIFT Euclid ClearStream DTCC Bloomberg In-house Technology Root Cause Analysis Requirements Assessments Metrics Troubleshooting Quality Assurance Risk Mitigation Compliance Quantitative Analysis GAAP IFRS

EXPERIENCE

BNY / MELLON January 2010 – May 2025

Vice President / Project Manager, Everett, MA / Hybrid, September 2020 – May 2025

Lead transformation projects for Bank automation, onboarding and investment process improvement.

Actively engaged / in project planning, requirement gathering and documentation, root cause analysis, solution design / development, training, testing, and coordinating, and providing pre- / post-implementation support. Also providing timely communication to stakeholders regarding project progress status.

Established standardized Agile/ Waterfall methodology, leading to efficiencies and improved controls within the process. Led in coordinating and tracking deliverables to accelerate Operations Automation Program (OAP), closely coordinating deliverables to program goals, and proactively tracking and solving bottlenecks / issues identified by technology and testers to ensure timely completion of the project.

Orchestrated onboarding, delivering proven track records and results, led projects relating to the onboarding global custody / mutual fund / alternative Investment / ETF / OTC / Fixed Income processes to centralized platforms and automated streamline data from source Data Lake. Drove automation and cross-regional process standardization.

Acted as a key liaison between IT and LoBs to ensure success of the project execution.

Devised solutions and change implementation, partnering closely with IT Data scientists to use AI, automating reconciliation and regulated weekly, monthly, quarterly, and annual reporting packages.

Designed an accounting model with IT team, including variance reconciliation and accounting valuation models, playing a key role in the testing and implementation of recent Bitcoin tokenization reconciliations projects.

Audited internal and provide external KPMG auditing support for Reconciliation Risk Control project, identifying and mitigating operational risks within the investment transaction lifecycle

Piloted automation of more than100 manual reconciliations on the TLM suite, also other platforms such a Duco / SmartRec / BlackLine / Peoplesoft

Offered solutions for file formatting data using Alteryx / Xceptor / Macro / Advanced Excel / and Access database.

Utilized Power BI / Tableau tools to report timely and communication to the stakeholders relating to project status, and KPI metrics and trendy performance.

Wei Guan, M.S. *******@*******.*** Page 2

Lead Business Analyst / Project Manager, BNY Mellon, Everett, MA / Hybrid, September 2012 - August 2020

Led and supported bank projects focused on onboarding and process improvement.

Stewarded global investment custody operation, managing projects in complex cross-border settlements for diverse asset classes - equities, fixed income, derivatives / reconciled cash, and securities daily across multiple markets and currencies, ensuring compliance with international regulatory frameworks.

Served as a Project Lead utilized Lean Six Sigma as part of the reconciliation transformation initiative. Led automation and efficiency projects across various processes under the global process owner.

Spearheaded process improvements, leading automation projects of global custody / mutual fund accounting / middle office accounting / Alternative Investment accounting / Security Lending / Collateral Management reconciliation, utilizing an AI tool and data algorithmic match and sourcing reconciliation rules.

Managed collateral and liquidity for institutional clients projects

Automated manual reconciliation using the TLM suite and drove automation and cross-regional process standardization

Supported projects relating to TLM conversion from vendor yearly version upgrades to provide analytical support for company-wide conversion from Winnar / ASR / ARF / NOSTRO / MIS / PeopleSoft / BlackLine variance tools to TLM to streamline the process.

Supervisor Global Custody Reconciliation, BNY Mellon, Everett, MA, January 2010 - August 2012

Led outsourcing and travelled to India to set up the BNY Mellon reconciliation team as part of the Transformation Team.

Oversaw process improvement efforts to redesign the recon to bridge existing process gaps and automate.

Reviewed, analyzed, and reported reconciliation data and KPI to mitigate the risk in the outsourcing activities performed across various processes under Asset Servicing Global Custody Operation.

Analyzed market data and provided custody fee scheduling for global markets clients.

In merger PNC global custody with BNY project, led to solve the PNC reconciliation DEAD records to mitigate the business exposure.

ADDITIONAL RELEVANT EXPERIENCE

BNY / MELLON / MELLON FINANCIAL CO., Everett, MA

Global Custody Senior Specialist, Mellon Financial Co., Everett, MA

Performed daily specialized clients' cash and securities portfolios account on a transaction basis for various foreign sub-custodians.

Assisted the various Global Custody Operating - Trade Settlement, Income, Tax Reclaim, Finance, Compensation, Cash Management, and Corporate Actions Units, Mellon Europe, and the Mellon CIBC Joint Ventures in investigating and closing reconciliation breaks resulting from processes.

Trained specialists on the specifics of processing.

EDUCATION

Master of Science (M.S.), Financial Economics

Boston University, Boston, MA

Bachelor of Arts (BA), Finance, Concentration in Accounting

Hangzhou Institute of Commerce, China

Contact this candidate