SKILLS:

Technical: Excel Spreadsheet Design, VBA Macros, VLOOKUP, Pivot Tables, And - If Statements, Access Database, PowerPoint, Visio, MS Project, Jira, Prince, Clarity, Lotus, MySQL, Bloomberg, Reuters, MORvision, Prologue, Crystal Report Writer, FSS, Coda, Global FX, Geneva, BPS Impact, Pam, IRP, Insight, Computron, ADP, Phase III, Gloss, Clarus, Cars, Global 1, Loanet, Loan IQ, Martini, Imagine, Platinum, Summit, Wall Street, Sybase, Oracle, PeopleSoft, SAP, SDAPS, Business Objects, Hyperion Essbase, Sphere, Kondor+, Magellan, RMS, QlikView, MicroStrategy, FIS - UBIX.

Business Analysis: APQC - Process Classification Framework, Documentation of Current / Future State Process Workflows, Business Requirements, Functional Specifications, User Acceptance testing, SharePoint sites.

Financial Analysis: Risk & P&L Reporting, Month-End Close, Accounts Receivable / Payables, Balance Sheet review, Management Reporting, Regulatory Reporting, Process Re-Engineering / Transformation, SOX / GAAP / FASB Compliance.

Product Knowledge: Corporate Bonds (Adjustable Rate, Convertibles, High Yield, Investment Grade), Derivative Products (CBO, CDO, CDS, CLN, Equity Swaps, Interest Rate Swaps, Synthetics, Futures, Options, Total Return Swaps), Equities / Shares (ADR, GDR, Common Stock, Convertibles, Preferred, CFD, DRIP), Foreign (Brady Bonds, Currency Forwards / Spot, Euro Bonds, International Equities), Loans, Mortgage & Asset-Backed Securities (ARM, CMO, CMBS, RMBS, FHLMC, FNMA, GNMA, IO), Municipal and Government Bonds.

EXPERIENCE:

Confidential, New York, NY

Business Analyst, Project Manager

Responsibilities:

• Managed $900k project to automate Product Control team’s Excel - based month-end P&L reporting and reconciliation process on Futures & Options trading; reviewed stale, 87-page 2016 BRD and created clear, concise 20-page BRD.
• Directed $1.1M project from system architect approval to implementation for online user module to automate the Operation team’s multi-currency margins, swaps, and FX data gathering process for settlement. Deployed tool 3 months early and $200k under budget.

Confidential, Warren, NJ

Software Business Analyst, Project Manager

Responsibilities:

• Supported end users within Data Quality team on multiple reporting programs (OCC, CCAR, BCBS 239, Part 30 and IFRS 9).
• Re-designed team’s Excel-based M/E reports for all finance stakeholders, reducing process time from ~3 hours to 30 minutes.
• Produced gap analysis, gathered business requirements and worked with offshore / onshore development teams to create proof of concept for CCAR reporting for mortgage-backed securities (MBS) using group’s RUBY database.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Implemented Volcker and RENTD real-time reporting to support all traders (Fixed Income, Equities, Derivatives desks) and Global Key Stakeholders (Paris PM, Product Controllers/Finance, Operations, IT)
• Created efficiencies for run-the-bank (RTB) reporting responsibilities using MicroStrategy application and ensured trader mandate compliance of no proprietary trading.

Confidential, New York, NY

Business Analyst, Project Manager

Responsibilities:

• Established Excel-based reporting process for the Treasury team’s Intermediate Holding Company ( Confidential ) with Go Live Date.
• Managed 2 AVPs delivering financial information (Daily P&L, Sources and Uses, M/E close, RWA and monthly Performance & Control Metrics) for loans and international trading settled via Loan IQ, FISS, and CARS in compliance with FR 2052A. Performed CCAR-FRY 14A reporting.
• Validated 2013 BRDs, FRDs, and market and financial data to ensure alignment with system’s current state. Performed UAT/QA of downstream reports.

Confidential, New York, NY

Senior Project Manager, Business Analyst

Responsibilities:

• Directed projects with Product Control teams and global stakeholders on reporting issues with Dodd Frank, Volcker, CCAR, FRY, Confidential and bi-annual SOX compliance review (updated VISIO workflows, re-tested and validated automation of manual pain points).
• Instituted Volcker reporting and a centralized data reconciliation tool using ETL feed to QlikView, saving 1 day of M/E close for Fixed Income trading groups. Produced Global Liquidity Management (GLM) team’s monthly Volcker submissions to management team and resolved data quality issues.
• Acted as Product Controller for GLM Repos, CP and Pool trading, ensured accuracy of Daily Risk and P&L, and provided market commentary and trader sign-off. Redesigned offshore team’s FOBO reconciliation reporting process, saving 3 hours and identifying all breaks.

Confidential, Stamford, CT

Business Analyst

Responsibilities:

• Implemented trade-level SAP Business Objects extract into Excel-based reporting tool to provide commentary related to the balance sheet movements on Confidential Derivatives trading products.
• Wrote procedure manual, training materials and held training sessions for offshore team.

Confidential, Shelton, CT

Senior Business System Analyst

Responsibilities:

• Conducted requirements gathering, interviewed users, and reviewed current state of eCLAS application.
• Established library for data mining, cross-checking intrastate rules from 250 BRDs/ FRDs /QA test cases for 106 federal and state mortgage loan regulations to validate RMBS securitization.

Confidential, Elmsford, NY

Business Analyst

Responsibilities:

• Wrote detailed finance department procedure manual to meet internal and external audit standards, maintained the firm’s Access database to produce mortgage loan origination data, validated Prologue financial data, and updated MORvision tables for Sales team status & commission rates.
• Reported daily, weekly and monthly financial summary and analysis to management for commission revenues generated from e-sales, loan sales, forecasts of revenues / expenses, Board of Directors M/E book presentation, and state and federal regulatory reporting.

Confidential, Stamford, CT

Business Analyst

Responsibilities:

• Implemented CCAR - FRY reporting process with 9/2012 Go Live Date using SQL query of Oracle’s Hyperion Essbase-reconciled M/E close financial data.
• Reviewed all edit and quality check errors using 1Q12 UAT submissions data for 32 global entities and 110 subsidiaries.
• Developed detailed test cases for UAT / QA testing using Smart View application and addressed 350+ questions from users.
• Produced PowerPoint training materials for users to understand testing process and new Smart View tool.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Oversaw beta test for Treasury team’s daily production and consolidation of CCAR 4G Liquidity reporting for 22 global entities and submission to Confidential and Office of the Comptroller of the Currency.
• Completed final revision of procedure manual and trained team in Tampa, FL.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Created Excel-based tool with pivot table summaries to consolidate and review data for yearly budget submissions from 53 global entities for current versus prior year analysis.
• Produced training materials for end users and presentations to Board of Directors for proposed savings from creation of a centralized team to oversee global budgets for 6 core services.

Confidential, Stamford, CT

Senior Business Analyst

Responsibilities:

• Senior lead on project to establish trading desk in Sao Paolo, Brazil with 9/2011 Go Live Date.
• Validated project team’s Financial Data Dictionary and produced Visio process flows and PowerPoint presentations to stakeholders.
• Reviewed Accounting Reporting Engine rule tables to produce accounting lifecycle events, trade events, and US GAAP to local GAAP rationalization for 5 trading products—Interest Rate Swaps, FX, Futures, Fixed Income Bonds and Money Market securities—in creation of a BRD for vendor MUREX.

Confidential, New York, NY

Business Analyst, Project Manager

Responsibilities:

• Implemented M/E Pre-Issuance-Pack (PIP) with 12/2010 Go Live Date using M/E Balance Sheet data for multiple users and New York and London Finance Directors.
• Established Opal system SharePoint site with 1/2011 Go Live Date supporting group’s Balance Sheet substantiation, compliance with SOX regulation and FOBO reporting for Structured Trading desks. Wrote procedural manual and trained users on use of tool.

Confidential, New York, NY

Product Controller, Financial Analyst

Responsibilities:

• Reported daily consolidated Risk and P&L for MBS trading products such as Strips & Inverses, ABS, CDO Secondary Trading, and Hedge products (Credit Default Swaps, Interest Rate Swaps). Produced commentary on attributions, Yield Curve and Interest Rate Shift, and T+0 Flash Estimates.

Confidential, New York, NY

Business Analyst, Project Manager

Responsibilities:

• Established Excel-based daily P&L reporting process using CODA general ledger and Loan IQ data and provided commentaries highlighting drivers.
• Reported Cash Flow summary, maintained Customer Trading and Bank O/D Limits DB tables and enhanced the FOBO reconciliation process.

Confidential, Long Island, NY

Business Analyst

Responsibilities:

• Documented and assisted finance team’s M/E close process; prepared journal entries to PeopleSoft G/L, reconciled intercompany and outstanding state sales tax payable.
• Re-engineered monthly budget review process, decreasing preparation time from 5 days to 2 hours.

Confidential, New York, NY

Vice President, Business Analyst

Responsibilities:

• Managed projects for audit issues, compliance to M/E close standards and SOX, Balance Sheet substantiation in support of middle-office groups (Charlotte, Chicago and New York), Finance, Operations, and trading Structured Products in accordance with GAAP.
• Implemented asset-level P&L reporting and reconciliation process for transactions settled via Geneva, Impact, PAM, BPS vs. Swaps trades manually booked by Ops into IRP system. New process facilitated the elimination of 4 FTE positions and identified a $10M P&L overstatement over 5years.