We provide IT Staff Augmentation Services!

Sr. Business And Data Analyst Resume

5.00 Rating

Jersey City, NJ

SUMMARY:

  • More than 10+ year experience as Sr. Business & Data Analyst, PMO with SDLC experience. Experienced as Product Controller with JP Morgan Chase on Fixed Income products, Equities, Cash Securities within financial services companies as Confidential, JP Morgan Chase, Fannie Mae, Inter - American Development Bank, Confidential, Confidential and Confidential and MUFG.
  • Products: All assets class, Core Banking Products, Deposits, Fixed Income (Mortgage Loans, Global Syndicated Commercial Loans, CMBS - Commercial Mortgage - Backed Security, RMBS - Residential Mortgage-Backed Securities, ABS - Assets- Backed securities, Mega, REMIC, Security Lending, Bond all type Convertible, Global Custody - Treasury Bond, Notes), Equity, Fund Investment, Assets Allocation,, Securities Settlement, Listed Derivatives Products, TRS, OTC, Credit Default Swap, Interest Swap, CCY Swap, Commodity Swap, TRS, Option, CAP and REPO.
  • BRD/FRD: Experience creating structured documents. Cross functional process Proficient in developing.
  • Liaison: Operations team, LOB Managers, CRM Change Request Management, PMO, Product Controllers, Regulatory Controllers, CFO Book of works team, Development team Offshore / Onshore, Test team, Production.
  • Trade Lifecycle & Validation: Experience manual and electronic trade validation
  • Fixed Income Accounting Methodology: Accounting Schema (FAS 91, FIN 46, FAS 114/115/EITF 99-20, Cost Basis Adjustment, Cash flow, Fair Value, Book Value, MTM Accounting.
  • Treasury - LCR -G5: HQLA / (Outflow-Inflow basis on Entity & CCY) - FR 2052a and LCR Liquidity Coverage Ratio.
  • ALM- Assets Liability Management: Balance Sheet / Off Balance Sheet / GL Posting / Net Control proof theoretical cash vs. actual cash in bank, generating sub ledger entries summarize in Trial Balance at Cost Center level.
  • Product Control PNL Production: Transactional Accounting, Ageing Inventory, Position in portfolio, OCI and UGL. Generating sub ledger entries upon accounting for Cost Basis adjustment and summarized in to GL, PNL Production, Earned Income (Fee, Rebate, Premium, Discount), Cash Flow, Moving Equity, Repo, Stock Borrow and Loan, Margin calculation.
  • Fail / Settled Trade: Develop Fail Trade Feed from Orbit database which maintains Day 1 Fail Trade repository for Operation team. Creation of T-Accounts FTR -Fail to Receive, FTD - Fail to Deliver to up date Inventory and CTR / CTD related to Cash.
  • Stock Inventory analysis and proof Stock Inventory = Settled Trade + Open Trade + Fail Trad
  • ADP Settlement / BPS SME: Settled trade analysis and Settled Trade Inventory Posting to GGL
  • DEC: Derivatives Execution and Clearing (DEC) Clearance transaction posting on the basis Business Events and Accounting Events. This is a process of updating Stock Inventory in case of BUY, In case of SELL the PNL Execution and EARNED Income Account Fee, Rebates get generated and Cash Control be recognized
  • Bond and Derivatives Pricing Validation
  • FiduciaryServices Experience with DTC Clearance Interestand Maturity, State of Israel Bond - Self clearance to financial organization.
  • Fiduciary Services Fixed Income: Convertible Bond Conversions/Warrant Exercise, Bond Redemptions, Foreign Tax Withholding, U.S. I.R.S. Tax Reporting, Cash Dividends/DRIPs, Stock Dividends, Bond Redemptions, Dividend Claims, Bonus Issues, Stock Splits/Reverse Splits, Rights Issues, ADR Conversions/Creation Mergers/Acquisitions/Tender offers/spin-offs,
  • Collateral and Margin Call Requirements: Initial and Variation margin requirements on OTC non-centrally cleared derivatives to the reform programme.
  • Analysed data mining using MS SQL and Oracle PLSQL
  • Enrichment Process on ESM Product/Sub-Product and Counterparty Level.
  • Market & Reference Data Bloomberg: Security Identifier “CUSIP”, “ISIN”, “FIT Code” ESM (Product Type / Sub Product Type) / Pricing / Factors extracted from various vendor such as Bloomberg/FITCH /IDC/DAPI /SAPI / PSDL.
  • Data Sourcing Requirements: Validating source data alignment using SKIP, MFLs, Variable, Product Reference, Static Data and Reference Data Validation Values.
  • Data Architecture: Entity Relationship modeling and SQL querying ability, Data Modeling CA Erwin.
  • F2B Data & Process Flow: All up streams data flow with ETL logic to downstream.
  • Data Linage: Data Fields Specs Mapping of Matrix data warehouse with various source systems and conducted
  • Oracle / Optima - PLSQL, SQL Toad, MS Access, Cross Tab, Excel Pivot Table V-H Lookup,
  • SAP MAP GUI developed GUI for user to post identify respective SAP acct, ADP Acct mapping to SAP Account
  • Liaison - Off Shore Tech Team Support provided to development and testing team in respect to FRD Fixed Income Product process and methodology.
  • UAT/QA/SIT Testing: Unit testing, Manual and automated test execution, Exploratory testing, reporting and bug tracking, module and component level testing, integration testing using SOLAR, HP-QC, BO/BI, JIRA.
  • Data Visualization: Using Tableau and Cognos to present data on the required workstream for visualization.
  • Risk Management Measures: Experience in Operational Risk, Liquidity Risk, Balance Sheet, Short Term Liquidity management under Basel II, Central Bank Liquidity Risk, Market Liquidity Risk, Funding Liquidity Risk and Linkage Risk with financial organization.
  • Credit Risk Model: (VaR API Risk Model), Credit Enhancements, Market Risk, (Beta - Expected Returns on Investment) PE Model (Price-Earning) Leverage Ratio, Expense & Profitability Ratio, Sharp Ratio, ROA, WACC, (NPV, IRR, Intex Data - Cash Flow calculator), Pricing Analysis.
  • Regulatory Reporting Development, experience report development using PL-SQL and ad-hoc reports.
  • FBO165 / FAS 157 /FAS 133 / FR Y 14 A / PNL / POSITION / NAV / ACCOUNTOWNERSHIP. IHC /FINRA Regulatory Reporting
  • LCR -G5: HQLA / (Outflow-Inflow basis on Entity & CCY) - FR 2052a and LCR Liquidity Coverage Ratio,
  • PNL Attribution Reporting PNL reports on Explained and Un Explained PNL Reports

SKILL:

Operating Systems: Windows 98/2007, MS Office (EXCEL, Pivot) Visio, MS Power Point, MS Project

Languages: C++, VB 6.0, SQL, Informatica - ETL

Databases: MS Access-Cross Tab, Oracle 11g, Oracle Data Guard, Golden Gate), DB 2, DB-Visualizer, Data Warehousing. Erwin Data Modeling Logical and Dimensional TOAD SQL Queries for data miming and analysis.

Methodologies: RUP (Rational Unified Process), Requisite Pro, Waterfall, Agile Scrum, SharePoint, UAT Testing.

Reporting Tools: Tableau, COGNOS 8 MT1 (Budget, Performance, Trend, P&L), Crystal Reports.

Financial Systems: ORACLE, BRODRADGE, SAP BW/BI-7.0, INVESTRAN-BI, CALYPSO-BI, LYNX, ACBS, Tech JIRA, CDMS2. SATURN JPM System, AML Trade Surveillance, Dodd Surveillance Program FAS .

Trade Capture: LYNX, CALYPSO-BI, INVESTRAN-BI, Trade Web, Orion, LOAN IQ, Bloomberg.

EXPERIENCE:

Confidential, Jersey City, NJ

Sr. Business and Data Analyst

Responsibilities:

  • Managing DSR Data Sourcing Requirement for GPP Global Payment Process, Vision IP-POD, Customer Check S Settlement and posting in respective debit Account
  • Translate DRD Business Requirement in to DSR, Data Sourcing Requirement, Data Transformation
  • Prepared DSR - Data Source Requirements for Core Banking products loan, mortgage and all kind of Deposits related feeds for the following systems
  • Payment Process including SWIFT, CHIPS, FED wires and ACH - Check Settlement for customer accounts
  • GPP - Global Pay Plus: Payment Process System
  • RAW Messages SWIFT RAW, CHIPS RAW, FED and ACH Cash movement with respective messages
  • SWIFT / CHIPS / FED Messages
  • KYC - Know Your Client Static databases
  • CAF - Customer Account Information Feed
  • CIF - Customer Information Feed
  • BANK Role - Bank messages for / from Correspondence, Respondent, Intermediator Bank Role
  • DART - Detect, Analyze and Report suspicious transaction activities to case manager
  • SAR - Suspicious Activity Report GUI
  • OVS MIS Feed - Overseas feeds in USA, Deposit, Loans, ACH, Wires for anti money laundering compliance.
  • Vision IP - POD - Customer Checks Settlement Process and posting to Debit Account.
  • BONY- Mellon ACH Feed Processing, Lock-Box Return / Reverse Checks and Electronic Check Deposit.
  • Prepare DSR feeds to EDW and AML Platform / EDW to Pre-Stage SAS, for regulatory compliance
  • Validation of GL and Sub Ledger List of Core Banking Inventory, Experienced Data Master and data architect
  • Using Tableau to present data on the required workstream such as Volume of transactions from FED,SWIFT and CHIPS
  • Analysed data using PL-SQL queries in the Oracle platform of GPP SWIFT RAW and Parsed messages, OVS MIS and Vision IP
  • Enhanced Internal and client Tax reporting,

Confidential, Stamford, CT

Sr. Business and Data Analyst

Responsibilities:

  • Developed Reports and Queries using Tableau on Largest Cumulative Positions, Gross Payments, Intraday Position Minute by Minute, Transactional Level reports, Credit Limit Max Usage, Overdraft and Long Balance, NOSTRO Agents Accounts, All reports with SOD Balance.
  • Trade Validation: Prepared trade validation on critical trade by Trade date/ pricing/participant confirmation. Observe direction of trade before settlement and analytical work using Oracle platform and Oracle Schema of data architect.
  • Experience in Operational Risk, Liquidity Risk, Balance Sheet, Short Term Liquidity management under Basel II, Central Bank Liquidity Risk, Market Liquidity Risk, Funding Liquidity Risk and Linkage Risk with financial organization.
  • Reference Data: Created Reference data in OEDM existing set of reference Data to be used from Lookup tables, Staged data written process and procedure, External data at Product Taxonomy level.
  • Repo & Stock Borrow, Manage Portfolio of Repo, Stock Borrow Loan, Margin expected calculations
  • PNL Attribution Reporting PNL reports on Explained and Un Explained PNL Reports
  • Cash Flow Calculation based on NPV and IRR taken care front desk before trader price the securities
  • ADP Settled Trade SME: Managed settled trade process to flow to the FDD/GGL
  • ADP Fail Trades are maintained in ORBIT a database system these records are grouped under "TYPE" column such as FTD Fail to Deliver, FTR Fail to Receive, Cod Cash on Delivery, COR Cash on Receipt .
  • Stock Inventory: analysis and Fail trade feeds from Operations to Back Office database.
  • GL posting, Product Controller Accounts Numbers are commonly owned in GL and Sub Ledger
  • Sub Ledger is based on securities identifiers
  • GL based on Account Number, Company Code
  • Data Sourcing: Validating source data alignment using SKIP, MFLs, Variable, Product Reference, Static Data and Reference Data Validation Rules Values. Bond - Derivatives pricing Validation

Environment: PLSQL, SQL Toad, MS Access, Cross Tab, Excel Pivot Table V-H LookupGL: Oracle, SAP, People Soft

Confidential, Manhattan, NY

Sr. Technical (Business / Data) Analyst

Responsibilities:

  • 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).
  • DEC: Derivatives Execution and Clearing (DEC) Clearance transaction posting on the basis Business Events and Accounting Events. This is a process of updating Stock Inventory in case of BUY, In case of SELL the PNL Execution and EARNED Income Account Fee, Rebates get generated and Cash Control be recognized
  • Repo & Stock Borrow, Manage Portfolio of Repo, Stock Borrow Loan, Margin expected calculations
  • Fixed Income FTL - Firm trade Lane Pricing Validation analytics, Direction of Trade before Settlement.
  • Proof of Concept Analysis: Trade Inventory (Activity, Fails and Positions) vs. Trial Balances.
  • Enrichment on (ESM/ SDS) BPS224 Sub-ledger at (ESM) Instrument level, (SDS) Counterparty level.
  • Performed SAP Mapping to ADP Account on accounting event basis, balancing entry, recon entry
  • Developed SAP MAP GUI and Oracle GUI for the users to fill ADP Account vs. SAP GL Account at various level.
  • Collateral and Margin Call Requirements: I worked on margin requirements as per G20 initiative and prepared requirements for initial and variation margin. As per G20 margin requirements on non-centrally cleared derivatives to process through programed of margin requirements;
  • Objective of margin requirements for non- centrally cleared derivatives;
  • Initial and Variation Margin
  • Bond - Derivatives pricing Validation
  • Using Cognos to present data in Volume and Amount Various Currencies for
  • FTL Firm Trade Lane Fixed Income,
  • Non FTL Equity and Stock Borrow and Loan,
  • Functional Inventory Data Linage of BPS224, GBS. This included confirmation from TDB on Summary of Product, Upstream Interfaces, Downstream Interfaces, Oracle Reconciliation Package, and SAP Posting Rules.
  • Enhanced Internal and client Tax reporting .
  • Dodd Frank Act Risk Reporting: FBO 165 / FAS 157 / (UGL, Balance Sheet, Off Balance Sheet Reporting), BASIL III, US GAAP Regulatory Reporting Balance Sheet / Cash Flow - Intex Calculator and Portfolio Composition.
  • Documentation of the control framework surrounding the regulatory reporting for the CUSO/IHC perimeter.
  • Oracle, Middleware, PL/SQL, CA Erwin Data Model, BO/BI, HP/QC, LOAN IQ, Agile Scrum, MS Office Suite (EXCEL, Pivot Table, V/H-LOOKUP) Visio, Power Point. MS Project & MS Outlook, Adjusted Data, COGNOS.
  • Products: Fixed Income, Equity, Treasury and Listed Products - Derivatives.

Environment: ESM Taxonomy, Oracle PLSQL, SQL Toad, MS Access, Cross Tab, Excel Pivot Table V-H Lookup

Confidential, Manhattan, NY

Sr. Technical Business Analyst

Responsibilities:

  • Project management CFO Book Report development (PNL Attribution, Position report, NAV Report), Data Modeling team to source enrichment data, FRD, Off-shore team, UAT / QA Testing team and Report.
  • Products: Fixed Income (Residential, Commercial Loan Portfolio, Securities Portfolio (CMBS - Commercial Mortgage - Backed Security, RMBS - Residential Mortgage-Backed Securities, ABS - Assets- Backed securities.
  • DEC: Derivatives Execution and Clearing (DEC) Clearance transaction posting on the basis Business Events and Accounting Events. This is a process of updating Stock Inventory in case of BUY, In case of SELL the PNL Execution and EARNED Income Account Fee, Rebates get generated and Cash Control be recognized
  • Developed Master Data Model by preparing data attributes with source tables for the followings reports using PL-SQL and adhoc reports. Took the account ownership of Current Month, Current Month Movement, FV Drilldown.
  • PNL Attribution: Summary, Detail Report by Counterparty, By Department, By Currency, Trade report
  • Position Reports: Position Summary, Trans Detail.
  • NAV Reports: NAV Movement Daily, BY Currency, By Department.
  • Account Ownership reports on multicurrency and region.
  • Enhanced Internal and client Tax reporting . 2002
  • Documentation of the control framework surrounding the regulatory reporting for the CUSO/IHC perimeter.

Environment: Oracle, PL/SQL, CA Erwin Data Model, BO/BI, HP/QC, LOAN IQ, JAZZ/ Symphony for Adjusted Data

Sr. Technical Data & Business analyst

Confidential

Responsibilities:

  • 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.
  • Data Linage: Did Data Field mapping of MDW with various Source Systems SPECS such as TMLSALO, TMLSMB, RADAR, DOGS, ATLAS, IOWA, CNS418/ CNS272, CTS, BRODRIDGE, PMA, F2B: (Front to Back Measure)
  • Tech JIRA Development & Tracking: Translated PMA JIRA in to Tech JIRA, Perform JIRA Testing. QA / UAT / PROD Tested Cash Cube: Prepared Analysis of Trade Messaging Layer. Liaised and analyzed Business Unit, Performance Management Administrator, Finance Controllers, Product Controllers, Balance Sheet Controller and Off Shore Technology.
  • Reference Data: Created Reference data in OEDM existing set of reference Data to be used from Lookup tables, Staged data written process and procedure, External data at Product Taxonomy level.

Environment: QA Testing Informatica 102, PLSQL, SQL Toad, MS Access, Cross Tab, Excel Pivot Table V-H Lookup

Confidential

Sr. Business Analyst

Responsibilities:

  • Project management On Confidential - Global Trade PNL software development from 77 global traded entities, Product controllers Balance Sheet, OCI validation with GL Accounts, Migration of position from Product Controller Books to Confidential, UAT / QA Testing.
  • Derivatives Execution and Clearing (DEC) Clearance transaction posting on the basis Business Events and Accounting Events. This is a process of updating Stock Inventory in case of BUY, In case of SELL the PNL Execution and EARNED Income Account Fee, Rebates get generated and Cash Control be recognized
  • BRD using RUP / Agile related skillset (ability to write stories, use RTC, support release/sprint planning, etc.)
  • Detail oriented & Process oriented e2e/overall process, concept of proof fact data.
  • Unwound and Rebuilt Trade Functionality & Scenarios Testing; Test 97 different scenarios for unwind and rebuild Trade functionalities for Factorable and Non-Factorable Securities, (AFS, HTM, MTM, securities)
  • Managed conversion and UAT Testing: Global Trading PNL UAT Testing Initialized Trading Data Inventory Balances / OCI Balances / Interest Inventory and PNL. Prepared Suspense Account Analysis, GL Balances vs. Activity Recon, Prepared Re-classed and Wash Account entries. FX Revaluation entries and Cash Flow Calculation based on NPV and IRR. Bond - Derivatives pricing Validation

Environment: ETL, Oracle PLSQL, SQL Toad, MS Access, Cross Tab, Excel Pivot Table V-H Lookup,

We'd love your feedback!