Senior Business Analyst Resume
New, YorK
SUMMARY:
- Accomplished Finance industry professional with extensive experience as Product Controller, Financial Analyst, Senior Business Analyst and Project Manager for leading global banking institutions. Skilled in the design, development and implementation of reporting processes maximizing resources and providing timely, actionable reliable data. Enhance the core reporting functions to serve multiple reporting needs, Daily P&L, Month - end close, Management and Regulatory reporting.
- Analytical and Accurate Risk and P&L Reporting Manager
- Month-end Close Balance Sheet Review & Substantiation
- Financial Reporting Management Information Reporting
- Process Re-Engineering & Workflow Documentation Control & system Implementation
- Project Coordination / SDLC Regulatory Compliance Reporting
TECHNICAL SKILLS:
FINANCIAL PRODUCT KNOWLEDGE: Corporate Bonds (Adjustable Rate, Convertibles, High Yield, Investment Grade) Derivative Products (CBO, CDO, CDS, CLN, Equity Swaps, Interest Rate Swaps, Options, Total Return Swaps) Equities / Shares (ADR, GDR, Common Stock, Convertible 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
SYSTEMS & APPLICATIONS: EXCEL Spreadsheet Design, VBA Macros, V Lookups, PIVOT Tables, and IF Statements, ACCESS, POWERPOINT, VISIOBLOOMBERG REUTERS MORVISION PROLOGUE CRYSTAL REPORT WRITE HYPERION ESSBASE FINANCIAL SERVICE SYSTEM (FSS) SQL CODA GLOBALFX BPS IMPACT PAM IRP INSIGHT COMPUTRON PHASE III GLOSS CLARUS SDAPS FISS SAP CARS GLOBAL 1 LOANET IMAGINE BUSINESS OBJECTS PLATINUM SUMMIT ADP Sybase ORACLE PEOPLESOFT McCormick & Dodge MARTINI SPHERE KONDOR+ MEGELLAN RMS QLIKVIEW JIRA SCORE
PROFESSIONAL EXPERIENCE:
Senior Business Analyst
Confidential, New York
Responsibilities:
- Work with Global Key Stakeholders (Paris PM, Trading Desk, Financial Controllers, Operations, IT) on implementation of Volcker and RENTD reporting, create efficiencies for RTB reporting responsibilities and ensure trader mandate compliance. Produce power point presentations to heads of desk, legal, compliance, and ensure resolution of identified data quality issues.
Business Analyst
Confidential, New York
Responsibilities:
- LERM Project - Work with Global Key Stakeholders (London PM, Trading Desk, DE Financial Controllers, Operations, IT) on implementation of new IHC Treasury Desk, CCAR 14A reporting, Product migration due to Trading System decommission (MONET to TCW). Lead Requirement and Market / Financial
- Data validation and traceability analysis to ensure 2013 BRD’s and FSDs were aligned with system current state. Produce Project status report, Perform UAT / QA of downstream daily reports used for daily reporting. Produce Process Flows, Enhancements, Power-Point presentations to senior management for HO allocation versus Legal Entity. Manage two AVPs responsible for provision of financial information (Daily P&L, Sources and Uses, Month-end close and monthly Performance & Control Metrics), and produce deep dive analysis of multiple outstanding legacy issues related CP issuance based Interest Rate Swap.
Confidential
Sr. Project Manager | Business Analyst
Responsibilities:
- AGILE project - Work with Global Key Stakeholders (PMO, Finance, Trading Desk, Regulatory Reporting and IT) on various Self-Identified Issues, SOX, and Dodd Frank projects (Volcker, CCAR, IHC Reporting initiatives). Validate quality of Market / Financial Data, and Metrics, Produce and Maintain Process Flows. Volcker; Elicit requirements and produce BRD, FSD and lead development of Centralized Financial Data Reconciliation tool. Resolve Volcker FX Derivatives and Equities E-Trading Big Data issues / defect with LOB, FO and IT in Spain. Produce and Implement solutions to achieve best in class process efficiencies in support Fixed Income, NA Equities, E-trading, Global Foreign Exchange and Global Liquidity Markets, Government Bonds, RMBS, Cash Equities, Futures & Options, FX, Pool, Repo, CP, Money Markets, Structure Credit Finance, and FX & Equity based Derivatives. Product Controller for GLM Repos, and Pool trading, ensured accuracy of Daily Risk, P&L produced by Bangalore team, Trader Review, Sign-off and Commentary highlighting drivers.
Confidential
Business Analyst
Responsibilities:
- Design and Implemented a Trade-level Business Objects EXCEL based reporting tool used to provide Commentary related to Balance Sheet movement of US Rates Derivatives trading products. Report summarize the change on D-o-D, W-o-W, MONTHLY and QUARTERLY, produced Power Point materials and established classes to train the Mumbai offshore team.
Confidential
Senior Business System Analyst
Responsibilities:
- System Build - Elicit requirements gathering, interview current users, and established BA share-point site. Evaluated “AS IS” state within the firm’s eCLAS system by reviewing and aligning the Data contained in over 250 Business BRDs / FSDs / QA Test Cases regarding 106 Federal / State Regulations for Compliance Testing of the underlying Mortgage loans used in the RMBS Securitization process.
Confidential
Business Analyst (Clark Davis)
Responsibilities:
- Document, and Produce a detailed Departmental reporting Standard Operating Procedures to meet internal and external Audit Standards. Supervised and train junior staff member. Document Mortgage Loan Origination Data input/ update to MORVISION tables, PROLOGUE Financials, Crystal Report Writer, MS Access DB and EXCEL files to produce the underlying Report data and Charts. Report the firm’s weekly, monthly Financials and Analysis to EMC Management for Commission revenue from E-Sales, Sales team, Forecasts, Expenses, Board of Directors EOM Book, State and Federal Regulatory Reporting.
Confidential
Business Analyst | Regulatory Reporting (Iconma)
Responsibilities:
- System Build - Implementation of RUP Project with 09/2012 Go Live Date of CCAR FRY 9C Reporting using SQL query of Oracle’s Hyperion ESSBASE reconciled month-end closed Financial Data. Review all Edit and Quality Check Errors in the test of 1Q12 User submissions data for 32 global entities and 110 sub-businesses. As EXCEL SME, Maintain / Update Golden Source File (macro driven multi-worksheet file), develop detailed Test Cases for UAT testing, addressed over 350 User Questions/Issues resulting from QA review. Act as reporting process tool SME and liaison with Europe, Asia and Latin American office teams. Provided Power Point for User on Hyperion ESSBASE linked EXCEL file tool, GECC Consolidation and solutions to issues identified in UAT and QA.
Confidential
Senior Business Analyst
Responsibilities:
- Waterfall project Maintenance Phase of with 01/12 hand-off date - Oversaw the Beta-test of the Treasury team's Daily Production and Consolidation of the of the firm’s CCAR 4G Liquidity Reporting financial data for 22 global entities (Daily 4G reporting) in multi-worksheet EXCEL files submitted to the Federal Reserve Board (FRB) and the Office of the Comptroller of the Currency (OCC). Review and Validate Day-Over-Day Commentaries, establish KPI reporting, Update Procedure Manual for changes, Provide Enhancements and Automation solutions and ensured timely hand-off to Junior Staff in Tampa FL.
Confidential
| Senior Business Analyst
Responsibilities:
- System Concept and Development Phase of SCRUM project- Designed and Implemented an EXCEL based PIVOT Table summary to consolidate and review data for Yearly Budget submissions from 53global entities for current and prior year. Produce material and on use of the DB Tool, Produced Data models, Power Point presentations to the Board of Directors on the proposed savings generated from the creation of a Centralized Team to over-see the cost of 6 core services.
Confidential
enior Business Analyst
Responsibilities:
- Requirements Analysis and Design phase of SCRUM project 09/11 go live date- US MS Office (EXCEL, ACCESS, VISIO, POWER POINT) Review Accounting Reporting Engine to Produce Accounting Life Cycle events, Trade Events and US GAAP - local GAAP rationalization for 5 Brazilian Trading Products:
- Interest Rate Swaps, FX, Futures, Fixed Income Bonds and Money Market securities. Provide data for Weekly SCRUM meeting. Update project Team on progress. Validate team Financial Data Dictionary. Produce process flows, Power-Point presentations and contribute to the Vendor Business Requirement Document. Provide leadership, and to junior CTB project team members.
Confidential
Project Manager
Responsibilities:
- Manage various AGILE MI Reporting Projects: Month-end Pre-Issuance-Pack (PIP) 12/2010 go live date using SOx Data, transitioned KPI / KRI reporting to London office 01/2011 and Establish OPAL system Share-Point Site 01/11 in support of the group’s Balance Sheet substantiation and FOBO reporting for Structured Trading desks: Pool, Repo, CP, Money Market Derivatives, Structure Credit Finance, Equity Derivatives and Firm Finance. Project status, Power Point on new report, Build Prototype to Implementation of a comprehensive month-end MI pack for multiple users (NY and London Finance Directors), meet each group’s SLA obligations, and Data needs/requirements. Lead two consultants in Process Enhancement efforts, Trained Users / Staff and produced KOP Manual.
Confidential
Product Controller
Responsibilities:
- Report accurate EOD T+1 consolidated Risk and P&L for various MBS products (Strips & Inverses), ABS CDO Secondary Trading, and Hedge products (CDS and IRS) as well as commentary and attributions (Yield Curve and Interest Rate Shifts), Review and Validate FOBO Breaks, and T+0 Flash Estimate and Market Data.
Confidential, NV
Project Manager | Business Analyst
Responsibilities:
- AGILE Project - Establish (Design - Implement) an EXCEL P&L Report process using CODA GL, Provide Commentaries highlighting the drivers in accordance to GAAP and IFRS standards (FAS 133, 157 and IAS 39) using ACCESS DB query downloads in support of Function Transfer from Risk & Compliance to Finance. Provide Enhancements to the current (FOBO) reconciliation for Position and Cash breaks between LOAN IQ, FSS and CODA G/L. Prepared and reported Cash Flow summary, maintain Customer Trading and Bank O/D Limits DB, and Update departmental KOP in support of Corporate Bonds, MMs and Treasury desks.
Confidential
Business Analyst
Responsibilities:
- Document and Provide support to the Month-end Close cycle; Journal Entries support and uploads to PEOPLESOFT, Foreign Subsidiaries, Intercompany and Outstanding State Sales Tax Payable Balance Sheet accounts. Re-Engineered the EXCEL based budget review process from PEOPLSOFT which decreased the Preparation time 5 Days to 2 Hours.
Confidential
Business Analyst
Responsibilities:
- Document and support the Daily FX trading Risk and P&L reporting process, Global Consolidation Reporting (Chicago, London and New York) with market commentaries highlighting significant changes using EXCEL File. Review daily Market Data (Yield Curves and FX / Forward rates shifts), Resolved FOBO cash and position breaks between the GLOBAL FX system and SUMMIT GL, Booked daily correction Journal Entries. Reported consolidated EOD T+0 Flash Estimate. Proposed EOD P&L estimate process enhancement which saved 3 hours per day.
Confidential, New York, NY
Vice President | Project Management | Process Change Engineer
Responsibilities:
- Designed EXCEL Spreadsheets that tracked & substantiated $18B+ in assets across 4K+ Balance Sheet accounts, quantified potential write-offs, provided KPI metrics and a basis for escalation & management reporting.
- Developed and implemented an Asset-level P&L reporting process for Assets held in IMPACT, PAM, BPS vs. Swaps in the IRP system which increased accuracy, expedited timeliness, and facilitated the elimination of four full-time positions.
- Developed a deal review Power-Point template with EXCEL based support schedules used by the Business Solution Team to review over 70 swap deals and present to the Management Committee.
Confidential, New York, NY
Assistant Vice President
Responsibilities:
- Designed and Implemented an EXCEL based P&L reporting process utilizing a SQL query of Asset-level multi-currency GLOSS T/B download. The new process reduced the month-end close from 10 days to 4 days, Validated the trading strategy, Identified cash and position breaks, Substantiated FX exposure, and produced the M/E close Journal Entries.
Confidential
Business Analyst
Responsibilities:
- Document and Report consolidated Risk and P&L for 16 Credit Derivatives and Structured Products desks with commentaries highlighting significant gains / losses to management and the trading desk. Reviewed and resolved all CDS Front-office to Back-office (FOBO) breaks and validated terms on ISDA Confirmations vs. trades booked in FISS system. Month-end close responsibilities included SAP journal entries, MI reporting, and Analysis to Financial / Regulatory reporting groups.
Confidential, New York, NY
Responsibilities:
- Project manage User Acceptance Testing (UAT) to Implementation of an automated daily P&L Report process using SQL query to gather data for Equity and Credit Derivative products based on the IMAGINE front office system and the GLOSS general ledger.
Confidential, New York, NY
Project Manager
Responsibilities:
- Establish and Implement the daily Risk and P&L reporting process for NY Stock Loan / Borrow, Equity Swaps, trader sign-off, resolved all market data, cash, position and Balance Sheet discrepancies. Managed the month-end close process, produced a detailed KOP manual on the daily, month-end close and MI reporting process. Trained junior staff.
Confidential
Assistant Vice President
Responsibilities:
- Report daily P&L Stock Loan / Borrow, Market data for Equity Swaps, CFD, DRIP, FX trading, market commentaries, trader sign-off, and global P&L consolidation (London, New York, and Tokyo) and managed three accountants. Month-end close responsibilities included journal entries, management reports / trader’s pact. Produced detailed KOP on the daily reporting process. Member of the Systems and Products Review and Implementation team.
Confidential
Assistant Vice President
Responsibilities:
- Prepare and report daily Risk and P&L for the Firm and Partner Bernard Selz trading Domestic / International Equities (ADR / GDR), Sovereign Debt, Repos, FX trading, trader sign-off, regional consolidation reporting and managed two accountants
