SMEBA

Role Type: SME/BA

Client Position Title: Project Manager Wholesale Lending

Project Length: 6 months

Client Wells Fargo

Number of Resources Needed: 3; 1 Senior SME/BA 2 SME/BA.

Client Project Start Date: 1/6/25

Client/Project Location (City State): Charlotte NC and New York NY

Remote Onsite or Hybrid: 3 days Hybrid

Contractor Location: Charlotte NC or New York Metro

Years of Experience Required: 710

Certifications/Skills Required: FS skills: commercial banking; wholesale lending; securitized lending (especially commercial); collateral coverage; loan analysis; corporate treasury; liquidity. Risk/Reg skills: regulatory reporting including FR 2052a FR Y14 LCR etc.; compliance.

Functional skills: data analysis; data remediation; Identify data quality issues and raise them to the client to be resolved through their remediation process partner with business teams to create implement & manage data quality rules and standards to drive improvements and streamline workflows. Develop methods and solutions to address data quality issues. Perform statistical tests on large data sets using big data tools. Demonstrated understanding of database structures.

Technical skills : wholesale lending systems (package or custom); data analysis; data reporting; MS Excel pivot tables

Project Details/Job Description: To accelerate regulatory remediation efforts Sia will support the clients commercial banking unit by staffing two project pods. These pods will be responsible for analyzing wholesale loans establishing a baseline population identifying which loans are missing coverage collateral and ultimately remediating the collateral gaps by working through LoBs and operations teams.

The first pod will be responsible for establishing the baseline of loans:

establish the wholesale loans baseline using General Ledger/GL recon System of Record analysis and iHub to make sure we have a 100% of the inscope population identified as wholesale loans

work sidebyside with commercial banking client teammates to facilitate and drive LoB signoff validating the starting population

work w/ each SOR (system of record) on data sourcing and gap closure these data feeds already exist so Sia will be working with the LoBs and Operations teams to correct the missing collateral values

work with the iHub (i.e. commercial bank data warehouse) team to confirm both the mapping and provisioning of that data to Liquidity Management (LM)

The second pod will be responsible for remediation:

Work with LOB leaders to develop a collateral remediation approach and plan for wholesale lending

Analyzing lending data captured in iHub inspect data elements review mappings compared to data requirements and document remediation plans

Validate prioritize and sequence the remediation activities by LOB/product area

Remediation could include several significant change events up to and including rebooking the loan.