Data Analyst Front Office

Tasleem M. Khan

***************@*****.***

+1-973-***-**** Los Angeles, CA

Professional Summary

Senior Data Analyst & Tech Business Analyst with over 15 years of experience in finance, business analysis, and data analysis, specializing in financial products within the IT finance domain. Extensive experience across Front Office, Middle Office, and Back Office operations, including P&L production, liquidity risk reporting, regulatory compliance, and payment methodologies. Over 5 years of experience with Loan IQ, including Loan IQ 7.5 implementation, and hands-on expertise with ACBS migration projects. Proven track record in risk mitigation, AML compliance (Actimize, KYC), and syndicated lending processes. Adept at Agile methodologies and SDLC processes, ensuring seamless system implementations and data integrity.

Core Competencies

Loan IQ (5+ years) & ACBS expertise & AFS-Vision

Syndicated & Bilateral Lending

Payment Processing & SWIFT Messaging, ISO 2022

Regulatory & Liquidity Risk Reporting

Data Mapping & Data Lineage, Data Sourcing

Data, Business & Functional Requirement Documentation (BRD, FRD)

Agile & Waterfall SDLC methodologies

SQL, Data Analysis & ETL Processes

AML, KYC, and Compliance Reporting

Tableau & Business Intelligence Reporting

Key Accomplishments

Led Loan IQ 7.5 implementation and payment workstream for major financial institutions, ensuring seamless integration of syndicated loans and regulatory compliance.

Managed ACBS migration projects, including end-to-end quality control, payment processing, and lender share validation.

Developed comprehensive dashboards in Tableau for syndicated loan reporting and liquidity risk analysis.

Designed and implemented automated processes for global payments, including ACH, FEDWIRE, CHIPS, CHAPS, SEPA, and SWIFT methodologies. With ISO 20-22 vision

Spearheaded anti-money laundering (AML) compliance initiatives, mapping live transactions and enhancing regulatory adherence.

Optimized P&L reporting processes, improving efficiency and accuracy in financial statements and regulatory filings.

Technical Skills

Loan IQ, ACBS, AFS Vision, AXIOM

JIRA, Agile, Scrum, SDLC

SQL, MS SQL, Oracle 11g, ETL (Informatica)

Tableau, Power BI, Microsoft Office Suite

Data Modeling (Erwin DM), Data Mapping, Data sourcing, Data Lake

SWIFT Messaging (MT103, MT202, MT202COV, MT101, MT900, MT940, MT952), APEX

Actimize AML, KYC Compliance

EDUCATION

●Associate Computer Programing Computer Science Education Prams, New Jersey NJ USA 1996

●MBA – MARKETING, UNIVERSITY of PUNJAB, LAHORE, PAKISTAN 1972

●BSc. Math, Physics UNIVERSITY of PUNJAB, LAHORE, PAKISTAN 1974

WORK HISTORY

MUFG – Credit Lending Project Wipro 04/2022 - 08/2024

Sr. Data Analyst –QA- ACBS MIGRATION FROM AFS

GT & Ops - Production QA & Support System Engineer V. GBAM Payment Systems.

●Payment Methodology of Customer Remittance Instruction (CRI) 12 different type have been set up on Apex application and GPP (Global Pay Plus) and mapped to respective Lenders GL Account.

●Managed Revenue, PNL and Earned Income of 28 different type of fees

●Quality Control of FIS- AFS Vision Commercial, Syndicated Loans migration to ACBS, SWIFT Messaging subject matter expert - Core payments and banking environment. Account Blocking, Payment Pooling and Repairs, General and Sub-ledger Journaling. LIQ servicing creation of DEAL, FACILITY, OUTSTANDING, Customer and Host Bank Remittance Instructions Cash Flow Release and GL Entry posting, Syndicated Loans Lender Share validation, Creation of Tableau Dashboard for reposting Syndicated Loans and upfront Fee

●Various Payment Methodologies such as ACH, FEDWIRE, CHIPS, CHAPS, SEPA, NOSTRO-VOSTRO, SWIFT MESSAGING, Using GPP (GLOBAL PAY PLUS) and APEX or Bank Platform.

●Structured Syndicated and Bilateral DEAL, Facility and Loan, Payment Methodology, SWIFT Role Messaging, ISO 2022 Modified MT Tags. MT103, MT202, MT202COV, MT101 and MT900, MT 940, MT952,

●I utilized Informatica ETL (Extract, Transform and Load), or DCT (Data Conversion and Transformation)

Bank of America – Credit Lending Tek Systems Consulting 07/2020 - 03/2022

Sr. Data Analyst – LIQ Production & BAU (7.5) for Credit Lending Project

GT & Ops - Production Support System Engineer V. GBAM Payment Systems

●SWIFT Messaging subject matter expert - Core payments and banking environment. Account Blocking, Payment Pooling and Repairs, General and Sub-ledger Journaling. Loan, Loan Servicing and Collateral Monitoring.

●LIQ servicing creation of DEAL, FACILITY, OUTSTANDING, Customer and Host Bank Remittance Instructions Cash Flow Release and GL Entry posting, Syndicated Loans Lender Share validation, Liquidity reporting, FRA2025, LC,

●Payment Methodology of Customer Remittance Instruction (CRI) 12 different type have been set up on Apex application and GPP (Global Pay Plus) and mapped to respective Lenders GL Account.

●Various Payment Methodologies such as ACH, FEDWIRE, CHIPS, CHAPS, SEPA, NOSTRO-VOSTRO, SWIFT MESSAGING, Using GPP (GLOBAL PAY PLUS) and APEX or Bank Platform

●Provide assistance and monitor Production Support for the defects reported by Ops team members

●System understanding such as FIS, ACBS, LOAN IQ, With Database development

●Structured Syndicated and Bilateral DEAL, Facility and Loan, Payment Methodology, SWIFT Role Messaging ISO 2022 Modified MT Tags. MT103, MT202, MT202COV, MT101 and MT900, MT 940, MT952

●Anti-Money Laundering (AML) regulatory compliance live transactions mapping.

Barclays – Wholesale Lending TCS Consulting 10/2018 - 03/2020

Data Analyst – Loan IQ Implementation (7.5)

●Prepared BRD, FRD, Requirement Document Funding, Payment Workstream using AGIL Methodology, Scrum and Sprint, JIRA. Comprehensive LIQ Payment Flow and respective Cash Flow generation and release, TB Entries.

●Managed Loan IQ servicing for Payment and Funding Work Streams of multi-currency using SWIFT IMT Messages. ISO 2022 Modified MT Tags

●Various Payment Methodologies such as ACH, FEDWIRE, CHIPS, CHAPS, SEPA, NOSTRO-VOSTRO, SWIFT MESSAGING, Using GPP (GLOBAL PAY PLUS) and APEX or Bank Platform.

●LIQ servicing creation of DEAL, FACILITY, OUTSTANDING, Customer and Host Bank Remittance Instructions Cash Flow Release and GL Entry posting. Reconciliation of Accrued Interest, Principal and Fee on Loan IQ. Payment via Apex System and Global Pay Plus (GPP)

●Structured Syndicated and Bilateral, Creation of DEAL, Facility and Loan, Generating Cash Flow, CRI -Customer Remittance Instruction, Payment Methodology, SWIFT Role Messaging MT103, MT202, MT202COV, MT101 and MT900, MT 940, MT95

●Up Stream of LIQ are SDS – KYC (SDS ID Customer Information update and Customer Location Completion. Creation of Tableau Dashboard for reposting Syndicated Loans and upfront Fee

●Payment Methodology of Customer Remittance Instruction (CRI) 12 different type have been set up on Apex application and GPP (Global Pay Plus) and mapped to respective Lenders GL Account

●Documentation of all work streams using Visio Diagram. XQuery, XML, JASON, MQ, REST (Web)

UBS –IT, Stamford, Connecticut Synechron Inc 10/2014 - 07/2018

One-Bal Restructuring of Sub Ledger Systems Feeds

Sr. Data and Functional Analyst

●Managed Project of ALM Assets and Liability Management - One Bal & IB KYR -Investment Banking [Know Your Records] Key Records Analysis documentation on global 96 system feeds. GL Entry validation posting to PeopleSoft.

●Prepared Queries and questionnaire for SMEs input on [CAL- Consolidated Accounting Ledger] regarding Consolidated Variables / Consolidated MFLs and SKIP to be addressed by the System Feeds SMEs. Managed ETL Cash Monitoring Data feed to EDW-Stage Tables for aggregation.

●Create SAR, Suspicious Activity Report, and Data Mapping & Correlation.

●System understanding such as FIS, ACBS, LOAN IQ, With Database development

●Project managed BASEL III Regulatory - Intraday Liquidity Monitoring work stream for which includes all cash movement on all assets class.

●Prepared Queries ILM Schema for Dashboard is the tool for these reports around all main streams.

●Prepare reports using Tableau dashboard. Worked on Tax Utility Application

●IHC – Stamford Accounts.

●US Accounts Dashboard.

●PRA – UBS Limited London.

●FINMA – All UBS Group AG..

●Managed Revenue, PNL and Earned Income of 28 different type of fees

●G5 – FR 2052a and LCR Liquidity Coverage Ratio, Regulatory Reporting, Repo & Reverse Repo – Triparty Pool. Cash Securities, Volume, PNL, and Net Control and Risk mitigation.

Barclays Capital, Manhattan, New York Synechron Inc 02/2013 - 10/2014

All Assets Class – Sr. Technical (Business / Data) Analyst

●Remediation Project Managed in full scope of complete life cycle SDLC

●Products: Fixed Income, Equity, Treasury and Listed Products - Derivatives.

●Re-engineering BRD and FRD on Enrichment Project: Fixed Income Non FTL products [Loans, Syndicated Loans, Bonds, Derivatives Interest Rate Swap, Total Return SWAP] (Global Loans, Loanet, Legacy Lehman Accounts and FTL (Equity and Listed Products).

●Fixed Income FTL – Firm trade Lane Pricing Validation analytics, Direction of Trade before Settlement. Experienced in data mining using SQL and Reference.

●Proof of Concept Analysis: Trade Inventory (Activity, Fails and Positions) vs. Trial Balances.

●G-2025A report, HQLA -High Quality Liquidity Assets, Overdraft and Credit Usage report, Intraday liquidity Monitoring, Repo and reverse Repo- Tri Party Pool

●Prior experience with JIRA/ JIRA Align, Clarity, KPIs and reporting

Credit Suisse, Manhattan, New York Software Guidance 03/2012 - 12/2012

Fixed Income – LOAN-IQ Implementation and Reporting

●Cadence Mortgage Processor for credit lending: Manage Position, Amortization (Principal & Interest Payments), Impairments, Dollar Role, GL posting, FEE- Earned Income.

●Project management CFO Book Report development (P&L Attribution, Position report, NAV Report), Data Modeling team to source enrichment data, FRD, Off-shore team, UAT / QA Testing team and Report. Experienced in data mining using SQL and Reference Data.

●System understanding such as FIS, ACBS, LOAN IQ, With Database development

●Prior experience with JIRA/ JIRA Align, Clarity, KPIs and reporting.

Citigroup (ICGT), Warren, NJ Princton Information 06/2011 - 01/2012

PMO – Sr. Technical Data & Business analyst –

Fixed Income Arbitrage Trading Platform Support

●Project management on MDW (Matrix Data Warehouse), managing 46 source system related JIRA Tec development requested by Performance Management Group, BO-BI Testing on completion of JIRA. Experienced in data mining using SQL and Reference Data.

●Data Lineage: Data Field mapping of MDW with various Source Systems SPECS such as TMLSALO, TMLS MB, RADAR, DOGS, ATLAS, IOWA, CNS418/ CNS272, CTS, BROADRIDGE, PMA, F2B: (Front to Back Measure). Experienced in Lynx and OLAP

Citigroup, (GTPL - Global Trade PNL), Manhattan, NY Morgan Clark Enterprises Inc 06/2009- 05/2011

All Assets Class - SR. BA / DA / PMO

●Project management On GTPL – Global Trade PNL software development from 77 traded global entities, Product controllers Balance Sheet, OCI validation with GL Accounts, Migration of position from Product Controller Books to GTPL, UAT / QA Testing. System understanding such as FIS, ACBS, LOAN IQ, With Database development

●BRD using RUP / Agile related skillset (ability to write stories, use RTC, support release/sprint planning, etc.). Experienced in data mining using SQL and Reference Data related to KYC.

Inter-American Development Bank, Washington DC Prestige Staffing NY 04/2008- 03/2009

Sr. Data Analyst Reporting Trading Desk

Fixed Income & Treasury – Liquidity Management

●Data Mart Development: Designed transactional data mart from various portfolios, maturities and payment obligations to generate liquidity reports.

●Developed financial information system for maturities in pipe line to invest in the capital market.

Citigroup, Manhattan, New York Finlay Associates 10/2007- 03/2008

Sr. Technical analyst – fixed income arbitrage trading desk

●Allocation Process Requirements / Testing: Prepared BRD using agile methodology, user story and use cases for automation process of client’s sub-accounts, electronic trade allocation.

Fannie Mae Washington DC, Henredon Vergina IBM – (GBS-SBS-IBM) 06/2005-09/2007

Sr. Technical Data analyst – restatement project

Products: Fixed Income (Residential and Commercial Loan Portfolio, Securities Portfolio (CMBS – Commercial Mortgage – Backed Security, RMBS – Residential Mortgage-Backed Securities, ABS – Assets- Backed securities, Mega, REMIC). Experienced in Lynx, Oracle and OLAP

HQLA -High Quality Liquidity Assets, Overdraft and Credit Usage report, Intraday liquidity Monitoring, Repo and reverse Rep- Triparty Pool

JP Morgan Chase Partners, NY Constantine Control Asso 03/2002-06/2005

Sr. Analyst – Bank One / JPMC (private equity, fund investment)

Prepared Market Risk Limit Control and validate Risk Limit compliance.

PNL Product Controller: Chase Global Bank: Credit Derivatives, Structured Finance SPV, Manhattan NY. Experienced in Lynx. Oracle and OLAP.

Citigroup (Smith Barney) Mahwah, New Jersey SBS Securities 03/1998-03/2002

Sr. Analyst - Lease Accounting- Implementation of Info Lease Project

Accounting Fundamentals: Strong working knowledge of lease accounting basics such as lease classification, lease term, lease inception date, and initial lease measurement

Analyze and validate leas cycle, Make sure First Instalment as security was applied to lease.

All entries applied to proper GL Buckets such as lease earned income, Tax amounts, all 28 types of Fee bucked in Earned Income Account

Database was maintained all transaction details on tables and financial statement of profitability has been maintained.

Chase Global Bank, Manhattan, New York SBS Securities / Juniper Systems 03/1996-03/1998

Fiduciary Services Cash Controller and payment processer on State of Israel Account

Manage DTC Payment account must be zeroed out

Prepared Vol Seirs Identification of Security RID paid on that particular payment program

Reconcile Controllers Due Payment for Interest and Principals

Contact this candidate