SUMMARY:

• More than 15+ year experience as Sr. Technical Business & Data Analyst, Project Management with SDLC experience - Front Office, Middle Office and Back Office experience with major financial services companies primarily such as Confidential, Confidential, Confidential, Confidential, Confidential and Confidential
• Products: All assets class Product Control, Fixed Income, Global Syndicated Commercial Loans, Global Custody, Equity, Fund Investment, Security Lending, Securities Settlement, Listed Derivatives Products, TRS, Interest SWAP, OTC and Credit Default.
• Business Analysis Proof of concept trade data analysis on Investment Banking and Project Management experience.
• Agile Scrum & 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.
• BRD/FRD/F2B/Data Flow/Process Flow, Experience creating structured documents.
• Proficient in developing Power Point presentation Use Case Model, Data Flow process, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence / Collaboration / Activity and Class Diagrams).
• Visio Presentation Proficient in developing Visio presentation for Data Flow Process, Dependent Process Diagram, Data Timing Feed Diagram depending on respective (SLAs, OLA’s). JAD & RAD sessions facilitated.
• Product Control (PC) and (FA) Financial Accounting,
• CCAR - Comprehensive Capital Analytics Review for Bank payments to PNL and Dividend.
• Cash Liquidity Treasury Keeping in view all type of bank investment, commitments, cash in/out, on periodically cash liquidity due to maturity in pipe line and any default accounted for.
• Oracle / Middleware / Optima - PLSQL, MS Access, Cross Tab, Excel Pivot Table V-H Lookup,
• QA/UAT Testing Script, HP - QC, SOLAR, Technical JIRA writing with SQL, Business Object BO-BI,
• Enrichment Process on ESM Product/Sub-Product and Counterparty Level
• Reference Data 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 / Intex etc
• Broker-Dealer(s), All Assets Class (Cash Securities, Fixed Income Various Bonds, Equity, Listed Derivatives Option, Call-Option, Put-Option, Stock Option, Future, FX and Commodities).
• SAP MAP GUI developed GUI for user to post identify respective SAP acct, ADP Acct mapping to SAP Account
• Data Attribution & Source System Mapping of Matrix data warehouse with various source systems.
• QA/UAT/PROD testing with BO Universe Environment
• Off Shore Support provided to development and Testing team and Investment Banking.
• Analysis in Pricing Evaluation Call-Options/Put-Options using Black-Scholes Model based on the followings factors; (Underlying Price, Strike Price, Risk Free Rate, Maturity, Volatility)
• Credit Risk (VaR API Risk Model) Black-Scholes Model, Credit Enhancements, Quantitative Due Diligence.
• Market Risk, PE Model (Price-Earning) Leverage Ratio, Expense & Profitability Ratio, Sharp Ratio, Sortino Ratio, Beta - Expected Returns on Investment, ROA, WACC, NPV
• Dodd Frank Regulatory Reporting
• GL Posting / Net Control proof theoretical cash vs. actual cash in bank,
• Report Development, experience report development using PL-SQL and ad-hoc reports.
• Smart Stream TML reconciliation application implemented with Confidential (GTPL- Global Trade PNL) Reconciled TB vs Sub ledger, Stock Barrow/Loan vs. Stock Inventory

SKILLS:

Languages: C, C++, VB 6.0, PL SQL, ETL,Databases: MS Access-Cross Tab, Oracle 11g, DB 2, DB-Visualizer, ETL, DB2,/ -DB Track, Data Warehousing,Logical Modeling, Dimensional Modeling, Erwin Tool usage, TOAD tool usage, Data Analysis and Source Discovery, SQL query in RDBMS (Oracle, SQL Server), Data Warehouse architecture, Data Mapping documentation.

Operating Systems: Windows 98/2007, MS Office Suite (EXCEL, Pivot Table, V/H-LOOKUP) Visio,MS Power Point, MS Project, MS Outlook,

Methodologies: RUP (Rational Unified Process), Requisite Pro, Waterfall, Agile Scrum, SharePoint. QA/UAT Testing - SOLAR /QC. Reporting Tools: 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 Confidential System, AML Trade Surveillance, Dodd Surveillance Program FAS 165 /157.

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

EXPERIENCE:

Confidential,

SR. TECHNICAL (BUSINES / DATA) ANALYST

Responsibilities:

• Prepared BRD and FRD on Enrichment Project of Non FTL (Global Loans, Loanet, Legacy Lehman Accounts and FTL (Equity and Listed Products). Agile Scrum & related skillset (ability to write stories, use RTC, support release/sprint planning). Detail oriented & Process oriented e2e/overall process, concept of proof fact data
• Proof Of Concept Analysis on Trade Inventory for BPS224, (Activity, Fails and Positions) vs. Trial Balances.
• FRD Re-engineering encompass BRD, Related attributes on Settled / Fails Trade vs. Trial Balance, Aggregation, Tax Id Netting Functionality. Prepared UAT Test Plan.
• Reference Data Security Identifier “CUSIP”, “ISIN”, “FIT Code” ESM (Product Type / Sub Product Type),
• Broker-dealer(s), All Assets Class (Cash Securities, Fixed Income Various Bonds, Equity, Listed Derivatives Option, Call-Option, Put-Option, Stock Option, Future, FX and Commodities)
• Enrichment on (ESM/ SDS) BPS224 Sub-ledger at (ESM) Instrument level, (SDS) Counterparty level.
• SIMPLE Process (System Interface Methods and Procedure Leger Entries). During this process Recon Entries were identified and Balancing Entries were created.
• Oracle, Middleware, Cross Function ESM analysis on Aggregated and Netted Tax ID at apportionment basis.
• Performed SAP Mapping to ADP Account on accounting event basis,
• Report Development, experience report development using PL-SQL and adhoc reports.
• Developed SAP MAP GUI for the users to fill ADP Account vs. SAP GL Account at various level.
• Cash and Collateral Management responsible for the cash and inventory management for Listed and OTC (Bilateral, & Exchange Cleared) Derivatives Interest SWAP, TRS etc
• Margin Call Analysis to develop a new system to lump to the respective parents account and margin call converted from Local Currency to USD.
• Functional Inventory Data Linage of BPS224, GBS. This included confirmation from Confidential on Summary of Product, Upstream Interfaces, Downstream Interfaces, Oracle Reconciliation Package, SAP Posting Rules.
• PE Model (Price-Earning)/Market Risk Analysis using Sharp Ratio, Sortino Ratio, Beta
• VaR Model Performed Credit Risk analysis (Probability of Default), Expected Return on Investment.
• Market Reference Data 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.
• UAT / QA Testing and production support from Matrix Database to Business, Products Controllers, Finance and Risk Controllers and development team.
• CCAR - Comprehensive Capital Analytics Review for Bank payments to PNL and Dividend.
• Experienced Dodd Frank Act Risk Reporting
• FBO 165 Foreign banks performances as compare to US Bank
• FAS 157 / FAS 133 (Fair Value Report (UGL, Balance Sheet, Off Balance Sheet Reporting), BASIL III,
• US GAAP Regulatory Reporting Balance Sheet / Cash Flow / Portfolio Composition /
• Support offshore development team to make them understand requirements of the projects.
• Understood Technical Architecture to turn business requirements into functional specification.
• Products: Equity, Listed Derivatives, OTC, FX, Stock Borrow & Loan, Repos, Corporate Bond, Convertible Bond, Municipal Bond, ABS, MBS.
• Environment: 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

Confidential,

SR. TECHNICAL BUSINES ANALYST

• Prepared analysis on data attributes of CFO Chart Book, 45 Reports Mock-up, LOAN IQ- Gateway Interfaces (Unadjusted), DAL - Adjusted Interfaces (Detail Accounting Ledger), SMA Trade FACTs tables in Loan Data Model, Accounting Event Trial Balances / Trial Balance Comparative.
• Agile Scrum & 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.
• Developed Master Data Model by preparing data attributes with source tables for the followings reports;
• Fixed Income Data Attribution & Report Development, experience report development using PL-SQL and adhoc reports. Took the account ownership of Current Month, Current Month Movement, FV Drilldown Current Month
• ETL Logic: Prepared ETL Logic to migrate data from LIQ (Gateway) and DAL (Detail Accounting Sub-ledger) to Loan SMA Facts tables and Accounting Event tables.
• Market Reference Data 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.
• QC - Quality Center HP: Uploaded reporting requirements, Mock-up Reports, ETL Logic, SQL in QC HP.
• Validation: During LIQ data interfaces migration, was responsible of validation of DEAL ID, FACILITY ID, OUTSTANDING ID across all respective tables such as Trade Facts, Accounting Event, Business Event.
• DEV - QA - UAT Functional, Regression Testing: Participated in Dev, QA, UAT Testing of various products, Loans, TRS, Derivatives, OTC, FX, Money Market ETC.
• FBO 165 Foreign banks performances as compare to US Bank
• FAS 157 / FAS 133 (Fair Value Report (UGL, Balance Sheet, Off Balance Sheet Reporting), BASIL III,
• US GAAP Regulatory Reporting Balance Sheet / Cash Flow / Portfolio Composition /
• Products: LOAN, TRS, Derivatives - Interest SWAP, OTC
• Environment: MS Office Suite (EXCEL, Pivot Table, V/H-LOOKUP) Visio, Power Point. MS Project & MS Outlook Oracle, PL/SQL, CA ERwin Data Model, BO/BI, HP/QC, LOAN IQ, JAZZ/ Symphony for Adjusted Data, Agile Scrum, Waterfall.

Confidential

PMO - SR. TECHNICAL DATA & BUSINESS ANALYST

• Prepared FRD and data mapping on various Source Systems vs. MDW
• BRD - 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.
• BROADRIDGE: (Cash Securities/Equities) Migrated to MDW (Matrix Data Warehouse),
• Fixed Income Data Attribution & Report Development, experience report development using PL-SQL and adhoc reports.
• Prepared Sonoma Feed- GPDW (Reference Data) Feeds To MDW (Trade Activity Feed, Settled Trade Feed, Fails Trade)
• F2B: (Front To Back Measure) on Settled Trade ETL Measure. Historical Update, JRules reload Functionalities (Outstanding and Net Trade Count/Quantity/Value)
• Data Mapping Documents: Did Data Field mapping of MDW with various Source Systems SPECS such as TMLSALO, TMLSMB, RADAR, DOGS, ATLAS, IOWA, CNS418/ CNS272, CTS, BRODRIDGE, PMA
• Market Reference Data 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
• Oracle, Middleware, OPTIMA Process PNL related feed for risk management and Basel Risk Reporting
• Tech JIRA Development & Tracking: Translated PMA JIRA in to Tech JIRA, Perform JIRA Testing.
• Liaised and analyzed Business Unit, Performance Management Administrator, Finance Controllers, Product Controllers, Balance Sheet Controller and Off Shore Technology.
• Dodd Surveillance Program: Dodd- Financial Regulatory Reform and Consumer Protection Act.
• Dodd- Act: governed enhancements for Trading Surveillance activities. Market Abuse and Fair Dealings with clients across various asset classes.
• FAS 157 / FAS 133 (Fair Value Report (UGL, Balance Sheet, Off Balance Sheet Reporting), BASIL III,
• US GAAP Regulatory Reporting Balance Sheet / Cash Flow / Portfolio Composition /
• PRODUCTs: Cash Securities, Equities, FX, Commodities, BOND, MBS, Structured Derivatives, OTC, Interest SWAP, TRS, Global Syndicated Commercial Loans, LC,
• Environment: SQL Coding, Oracle, MDW (Matrix Data Warehouse), SOLAR, JIRA, TML, Smart Stream, COGNOS MT1- BI/BO (Universe for QA/UAT/PROD Testing), JRULE Derivation, MS ACCESS, EXCEL-PIVOT-VLOOKUP, VISIO, MS Project, SQL Server, Agile Scrum, Waterfall.

Confidential,

SR. BA / DA / PMO

• BRD 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
• Requirement Validation: This was global initiative for centralizing P&L Reporting, All Confidential Trading Entity will report respective PnL from single Platform known as GTPL.
• TB Validation BAU: Trial Balance Validation SOLAR UAT vs. Production for Financial Buckets such as Market Value, Principal Inventory, Realized & Unrealized PnL, UGL, OCI BS LTD, Impairment Cost Price, Interest Income, Dividend Income, Finance Expense, Accretion, Pay down dripping.
• Comparison between TB vs., S2 /SOLAR BAU/ Daily Trading Profile, Referential data mapping.
• Market Reference Data 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.
• Fixed Income Data Attribution & Report Development, experience report development using PL-SQL and adhoc reports.
• 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 of the followings in to GTPL(Global Trading PnL System)
• 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 in USD Equivalent.
• Validated risk reports from OPTIMA Database having feed of Loans, Securities and UGL-PNL
• FAS 157 Fair Value validation and Reporting Structure.
• NET Control: Validated Actual vs. Theoretical Cash for events Trade, Pay Down, Interest & Dividend.
• PRODUCTs: MBS, REMICS, MEGA, MRB, REPOs, Loan, CDO, CLO, CMO, ABS, EQUITY, Derivatives etc.

Confidential, WASHINGTON DC

SR. BUSINESS ANALYST REPORTING

• FRD: Liquidity Management using Agile Scrum methodology user story, use cases in consideration of all business lines.
• Developed Automated Liquidity Management reports in multi-currency for the entire bank’s line of business including various systems Investment, Borrowing, Loans, Bonds Issuance, Discount Notes, Short Term Borrowing, Treasury Securities products, GAC (Salaries Obligation) and approved project to be funded representing Cash Flow In / Cash Flow Out for Maturities, Contractual Obligation including Stress Scenarios
• Data Mart Development: Design transactional data mart from various portfolios, maturities and payment obligations to generate liquidity report.
• Developed financial information system for maturities in pipe line to invest in the capital market.

Confidential,

SR. TECHNICAL ANALYST

• Fixed Income EV Research: Prepared analytical review using SQL on Fixed Income Portfolios and trade transactions of Give Ups, Assign and Correlation Trade to determine and ensure the correct Fixed Income trade commission is credited to correct client. This includes interview, training sales persons, initiate commission movement and metrics reported to MD.
• Management Group Consolidation: Update and consolidate global customer profile database to eliminate dormant and duplicate management groups of respective Platinum Parents Groups.
• 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.
• Analyst Securities Accounting: MBS, ABS (CDO, CMO, CLO, Interest Rate)
• Quant Financial Risk Model: Created Credit Risk model of VaR (Probability of default due to decline Credit Rating)

Environments: Calypso, eSale, INFOLYNX, Oracle- SQL, ACCESS, EXCL -Pivot-VLOOKUP,

Confidential, WASHINGTON, DC

SR. TECHNICAL BUSINESS ANALYST

• Business Requirement Documents: Impairments Work streams FAS 115, EITF 99-20.(Available for Sale/ I/O)
• Prepared Data Mapping, Interfaces, Accounting Control and ETL (RFDW to Security Cost Basis Sub Ledger) for various work streams: FAS 115, EITF 99-20, Book Value, Fair Value and Mark To Market
• Business Process Architecture: Prepared Visio diagrams on Securities Accounting Bond Model. Interaction between processes such as FAS 91-Amortization Engine, FAS 115/EITF 99-20-Impairment Engine, FIN 46 Consolidation, Book Value, Fair Value, Mark To Market Account bond model.
• Prepared process interaction between Securities Data Feed Timing, System Applications Interface, and Accounting Data Warehouse. Prepared use cases via Agile Methodology.
• CPMO - Central Project Management; Maintained Data Validation & Control, Reconciled Technical Requirements on various work streams and enhancements. Maintained log book of issues, pain points and resolution. Products MBS, REMICS, MEGA, MRB, REPOs, Loan, CDO, CLO, CMO, ABS etc…
• Process Flow of Securities & Loan Portfolio, Commitment GA/GO, Creation of Normalized Rating Database.
• UAT & Regression Testing; Prepared scenario cases for testing of various processes. Prepared Technical Requirement Documents for Analytics and Portfolio Composition (Purchase, Sale and Liquidation of MBS, REMICS, ABS)
• Fixed Income Data Attribution & Report Development, experience report development using PL-SQL and adhoc reports.
• Reporting Package: Participated in creation of Data Mart - Static Database.
• Created VLook Up Tables for Product Hierarch, Events Type, GL Transaction Type.
• Validated various reports using SQL queries, Log defects on Clearquest.
• Prepared Operational, Management and Financial Reports using Crystal Reporting System.
• Created Table and Universe for BO (Business Object) and COGNOSE 8.0 for various reporting.

Environments: SQL Coding, Oracle, (QA/UAT/PROD Testing), BO, COGNOS 8 MT1, MS Access, Excel-Pivot-VLO

Confidential

Product Controller

• INVESTRAN Enrichment Implementation on Equity related ESM (Product/Sub Product) and Counterparty.
• INVESTRAN Data Linage / Traceability Matrix mapping on Private Equity all across Confidential and Confidential Chase.
• Prepared Investment Portfolio Diversification on the basis of:
• Prepared analysis on Cost and Book Value for Public and Private Investment. Prepared P & L Report.
• CFO Reporting Development: Confidential /Partners: Equity and Funds Investment, Manhattan NY
• Prepared Investment Portfolio for Public, Private, Direct Securities and Funds Management for (JPMorgan Chase & Confidential - SAP system)
• Risk Metrics: Prepared Public and Private Portfolio Risk Metrics (Stress Loss- Equity Collapse basis of 1987).
• Prepared Market Risk Limit Control and validate Risk Limit compliance. Prepared monthly Balance Sheet Roll-forward (Monthly), Capital Under Management (Direct Control of JPMP Management),
• Capital Ratio: Private Equity Capital Ratio of Confidential & JP Morag Chase.

Confidential

• Analyst GL Integration: Confidential & Confidential .
• CIIS Bridge Mapping: Validated System Feed of Confidential real time transactions in balances and averages on CIIS Bridge. All defaulted items were reviewed at the level of: Accounts, Company, Center, and Trading Partner.
• Verified and recommended defaulted items in SAP Environment.
• Prepared FUPL: (Financial Up Load) for correction of exceptions.

Environments: SQL, Oracle, INVESTRAN, SAP-BI (BO-QA/UAT/PROD Testing), ACCESS, EXEL-Pivot-VLOOKUP

Confidential, MAHWAH, NJ

• Risk Exposure: in the area of Securities Deposit, Property Tax and AFR (Future Rental) accounts.
• Analyst Oracle GL analysis and provided guideline to IT to extract true sub ledger as posted in Oracle G/L vs. Legacy. Confidential (Citicorp Data Distribution Inc) Capital Operations and M&A, Paramus NJ
• Cash In Lieu: Managed Cash In Lieu during merger of Confidential (CITICORP and TRAVELERS).
• Capital Exchange (M&A): Managed (M&A) and Exchange of British enterprise “Quantum” merged with Hanson, New Hanson, then merged in USA such as US Industries, US Energy, Imperial Tobacco, & Millennium.

Environments: SQL Coding, Oracle BI/BO (QA/UAT/PROD Testing), ACCESS, EXCL-Pivot-VLOOKUP

Confidential

• Resolved over $18 Million in conversion related AR/ AP resulting from Fed Book (DTC) settlement.
• Recovered over 1.5 million in receivables from obligors upon reconciliation of Corporate Cash Control Account.
• Managed payment process to DTC, Reconciled payment schedule vs. Fund received from Controller Office of Obligors.