Jacob Matthews
SUMMARY
Business Analyst with a track record of successful implementation of projects (on time and within budget), with active participation in the various stages of the software development life cycle (SDLC) including initiation, design, coding, quality assurance, documentation, end user training, deployment and subsequent evaluation. Client-focused and exhibit excellent oral and verbal communication skills. Comfortable and confident among associates to promote consensus. Organized and thorough and will escalate issues when warranted.
Career Highlights
15 years - Financial Services -- Business & Technology domain experience
10 years- Business/Systems Analysis (BRD); Functional Requirement Documentation (FRD), Technology Solution Design, Traceability Matrix, Test Plan, System Integration Testing and UAT
10 years- Project Management experience following the PMLC methodology
6 years - Application Development (coding) on the Merrill Lynch in-house ASAP web system
Experienced in Order Entry/Trades Processing/Settlement/Statements/Custody/ACATS
Worked with Waterfall/Agile development methodologies; familiar with RUP/ITIL
Series 7 registered Rep; Knowledgeable about Options, Futures, Derivatives and other instruments
Knowledgeable about Customer Onboarding, KYC, AML, Dodd-Frank Reform, Basel, FATCA
TECHNICAL SKILLS
LANGUAGES: SQL, HTML, XML, JSON, .NET, ASP.net, SOAP/RESTful APIs, COBOL, CICS, TSO
DATABASES: SQL Server, Oracle, MS Access, SQL, DB2, VSAM, RDBMS concepts
BA TOOLS: Business Process Analysis, Dataflow/Modeling, Data Analysis/Mapping, Use Cases Traceability Matrix
PROJECT MANAGEMENT: PMI methodology, ITIL, Visio, Clarity, Jira
MS OFFICE GROUP: MS Office suite including Outlook, Excel, MS Project, SharePoint, Visio
PROFESSIONAL EXPERIENCE
JP Morgan Chase, Jersey City, NJ Jan 2017 – Current
Sr. PM/BSA – Third Party Legal Risk Remediation migration to PEGA system
Senior BA for creation of BRD and UAT Test Plan/Script for migration of 3rd Party Risk ‘Remediation Plan’ processing to a Pega System Workflow Tool, to remediate and mitigate risk:
Creation of a Pega Workflow Procedures Manual and Management Reporting
Analyze and create a combined Business Functional Requirement Document (BRD/FRD):
Create various workflow processes based on 3rd Party Risk Tier, risk level of each Plan, prioritized due dates
Design/Creation of Reports for each workflow as the basis for processing
Upload of data feeds into Pega from multiple sources – Archer, Phoenix, Gold
Filter/Sort/Selection of Remediation Plans based on multiple columns of reports
Communication (external/internal) processing via automated emails, and phone
Handling of Extension and escalation approval routing, non-compliance risk acceptance
UAT Test Plan/Script/testing for Pega migration of 3rd Party Risk ‘Remediation Plans’
TD BANK Mt. Laurel, NJ
Sr. BSA, Customer Contact Strategy (CCS) initiative & Enterprise-level Consent/Permissions Sourcing (March 2016 to Sep 2016)
Sponsored by Marketing, an initiative among the various Lines of Business (LOB) to consolidate as well as capture expanded ‘customer contact’ information, create and maintain a separate (regulatory-adherent) repository for customer permission/consent, opt-in/opt-out, and customer preferences information – thereby creating two distinct ‘Systems-of-Record’. The data will be used by Marketing, Analytics and Reporting, Customers and Bank employees. The system will synchronize the display, add and update of data using any communication channel.
Responsibilities:
Lead Business Systems Analyst/Data Analyst
Business Process analysis of six lines-of-business operating in silos
Analysis of Customer contact-related data in both current front- and back-end systems
Reviewed proposed architecture and solution using a new Omni Channel application, two databases and RESTful APIs (am knowledgeable about .net framework, ASP.net, SOAP, XML, JSON
Consensus among business/ technology- to minimize changes to front/backend systems
Analysis to create one ‘System of Record’ for capture/update/inquire client contact-related information
Reviewed, with current- technology areas, the proposed Omni-Channel application framework to capture/update permissions in a new Enterprise Permissions Center database
Data Analysis and mapping: Conducted multiple JAD sessions of data analysis on integrating the new application with mainframe ‘Core Banking’ and (vendor) Fidelity (RM, IM, ST) systems
Obtained high-level estimates for integrating the new Omni-Channel application with over 20 front-end and back-end systems (each with disparate and varied source data), including mainframe systems
JP MORGAN CHASE Jersey City, NJ
Infrastructure Data Analyst - Business Systems Analyst (July 2015 to December 2015)
As part of Technology Service Delivery, an initiative to establish a new database as an ‘Authoritative Data Source’ (ADS) [a ‘Golden Source’] for all critical Infrastructure Reference Data. This ADS will pull data from ‘Systems of Record’ (SORs) of infrastructure data which solely will be responsible for ownership and all updates to the data elements contained in the SOR. The user applications (consumers of this data) will access the ADS through RESTful APIs. This will eliminate the need for individual applications linking to various data sources for their data requirements.
Responsibilities:
Created User Stories, Product and Sprint backlogs and daily assessments using Agile methodology
Data Analysis: On identification, duplication, analysis and quality of stake-holder data (sources):
Data Sources interactions and content using SQL data validations
Separation of owned-data and data drawn (for expediency) from other sources
Analysis on allocation of data attributes in the model using MagicData and a domain-object-attribute framework
As part of Data Quality analysis: Traced Data Lineage of data elements to be used in the ADS
Identification of a Level1 data source at attribute creation and subsequent levels
Identification of a Level1 data source based on attribute updates during the data life cycle
Trace current daily staging-library collection of data, ETL transformations and use of MuleSoft
Propagation of data through a policy engine to the database Master and Data Lineage database
SQL used to track data element-updates by different systems providing data to downstream applications
E*TRADE FINANCIALS Jersey City, NJ
Business Systems Analyst - PM (November 2014 to May 2015)
A new Transformation initiative to update and automate Brokerage middle and back office functionalities to provide exemplary service to Stock-Plan Account-clients as opposed to regular (Retail) E*TRADE clients.
Defined User Stories, Product and Sprint backlogs and daily assessments using Agile methodology
Comprehensive analysis of Corporate Action events in an effort to automate CA event processing.
Data Analysis and Mapping of Retail Corporate Action for potential use for the new process
Created Business and Functional Requirement Documents, Traceability Matrix
Assisted Technology on solution design (.net, SOAP and RESTful APIs, XML)
Stock Plan Account processing for E*TRADE Corporate clients
Suppression of Smart Alerts for Managed Account Clients
Designed User Interface screens for dividend, stock split and spin-off events
Created a test plan using the Traceability Matrix, for QA to validate all Business requirements
SSRS was used to create ad-hoc reports on the type of updates on data elements found in applicable infrastructure data sources, as part of the research on data
Validated accuracy of spun-off share 'allocation' by generating SSRS reports
UBS Weehawken, NJ
Business Systems Analyst/PM (May 2014 to October 2014)
Wealth Management- Order Entry
A strategic initiative to develop a new Order Entry web-based application that would serve as the basis for the next generation of single point order entry for most of the investment instruments in Wealth Management. A primary aim of the current project is to establish controls to mitigate risk that is present in the current mainframe system. As a Business Systems Analyst my role is to analyze the business requirements and create the Functional Specification Document for the current phase which includes:
Document the role and capabilities of a third party Middle Tier application that will operate between a new front-end and the mainframe data processing and databases
Create User Interface screens for Order Entry, Recap and Confirmation (of order) for Equity and Simple Option products
Design sets of User Interface screens for ‘Cancel Order’, ‘Cancel and Replace Order’, ‘Transaction Summary’ and ‘Transaction Detail’
Specifications for the (front-end) User Interface in terms of properties, behavior and combination-rule validations for various data fields on the screens and capture them on Field Behavior Tables for use by developers
Document rules that have been migrated into the Middle Tier for validation by the Rules-Engine
Create Activity Table spreadsheets that will be used by the Middle Tier to ‘call’ for data-service access to external databases including Account, Product, and Market information etc.
AMERICAN EXPRESS New York, NY
Sr. Business Analyst/PM: Fulfillment, Issues, Resolution and Prevention (June 2013 to Sept 2013)
Amex Credit Card Issues
Enhance the American Express and Cobrand Card Member experience by resolving issues in a timely manner and instituting ‘strengthen and control’ measures to avoid future occurrence
Took ownership of assigned issue and accountability for remediation and final resolution
Conduct meetings among business and product managers, subject matter experts, technology teams and compliance to evaluate symptoms
Identify and document the issue (say, enrollment in wrong product), the impacted population, obtain consensus on ‘stop customer impact’, communicate with all and ensure compliance
Determine financial implication of the issue and cascading effects on APR, fee credits, statement credit, finance charge etc., plan for immediate financial remediation and/or stoppage of campaign
Create and analyze business process and data flow diagrams, context and state diagrams, cross-systems interactions, based on symptoms to determine the root cause of the failure
Conduct business and system use cases; create a Traceability Matrix to trace the use cases through construction and testing. Used SQL to find appropriate test data from production
Arrive at solution design and institute strengthen and control measures to avoid reoccurrence
Create and adhere to a project plan for 30/90/120-day mile stones, change management, construction, integration and UAT testing, deployment and follow up after implementation
Created reporting template for the breakdown on issues, resolution time frames and identification of issue occurrence concentration (including heat maps)
MERRILL LYNCH INC Princeton, NJ
Sr. Business Systems Analyst/Data Analyst (August 2012 to April 2013)
Merrill Edge Technology (GWIMT)
With the merger of Merrill Lynch with Bank of America the volume of clients with assets under $250,000 has increased tremendously and this warrants a new design and complete rewrite of the current Merrill Edge application
Business and Data Analyst to redesign the current Merrill Lynch Advisory Accounts System to fully integrate Bank of America clients into the Merrill Edge Advisory Center (MEAC) and additional capabilities to the current system
Defined scope for the first phase, gathered requirements through JAD sessions with Business partners
Joint Application Development meetings among Business and Technology partners
Created Swim lane/Workflow, BPD Diagrams, Decomposition Charts, Data Mapping,Data Flow Diagrams
Created Use Cases, Traceability Matrix and Test Plan, Script Scenarios, SIT scenarios, UAT assistance
Authored Business Requirements Specification (BRS), Systems Requirements Specification (SRS)
Conducted Gap analysis between the current and proposed system and specifications
SQL queries used to generate test data from Production systems
Business Systems Analyst
Managed Solutions Group (MSG), GWIMT
Single Experience: A project to consolidate and streamline six disparate Managed Solutions web-portal applications onto a single platform, in order to provide a uniform and simple experience to the (Financial Advisors and Client Associates) user group. Asset classes included Personalized Investment Advisor (PIA), Consults, Mutual Fund Advisor (MFA), and Uniform Managed Assets (UMA)
Business Analyst for the Large Trader Identification (LTID) project affecting all six product groups (SRS, system design, unit and integration testing, QA testing, UAT and deployment)
Business Analyst for the initiative to upgrade the MSG website Menu and ‘Literature and Forms’ pages from .net 2.0 to 4.0 version, to be used in Single Experience
Analyst for Proxy address changes on all affected MSG accounts in the KD system
Performed analysis for the new Financial Advisor Eligibility (FAE) for new categories in the Single Experience platform
Created Test plan, Test scripts and scenarios. Coordinated development, System Integration testing, tracked and resolved issues arising out of QA testing, supervised move to ‘dark pod’, deployment and post-deployment testing by developers, QA team as well as UAT by the business team and obtained sign-off
SQL queries used to create regression/test data from current Production systems
STATE STREET BANK INC Princeton, NJ
Business Systems Analyst/PM (October 2011 to April 2012)
Investment Manager Services (IMS)
Investment Manager Services specialize in on-boarding of client organizations to the State Street IMS platform, providing end-to-end middle/back-office processing solutions
Business and technology consultant specializing in Business/Systems analysis, Design and Data Mart implementation for the client (like Deutsche Bank)
Gathered requirements, documented client business processes using Business Process Diagrams, Functional Decomposition Charts, Activity and Sequence diagrams
Created Business Use Cases, Test Plan and Traceability Matrix
Created Data Flow Diagrams for input, business processing and output
Performed gap analysis, risk mitigation, performance measurement calculations, data analysis-and-mapping involving Security Master Database, Market Data Services, derivatives, legacy system and ongoing solution planning
SQL mainly used to create test data and regression test data from Production area
Define and review test cases against traceability matrix and assist QA as required
MERRILL LYNCH INC Hopewell, NJ
Business Systems Analyst (March 2011 to Sep 2011)
Global Books & Records initiative
Merrill Lynch Global Wealth Investment Management (GWIM) Business and Technology groups together are working very closely on a firm-wide initiative to perform the firm’s Books & Records functionality in real time and across the globe in a distributed manner, as opposed to the single-entity (NY-based) nightly batch cycle
Worked as Business Systems Analyst and concentrated on:
Subject Matter Expert on Cash-and- Margin Bookkeeping
Conducted JAD sessions and focus groups with both business and technology
Elicited embedded business and compliance rules from batch-based Account Processing (AP) system
Illustrated the effect of a transaction on each of the three Account components (Holdings, Money Line and the Activity) using separate business process flow, sequence, and data flow diagrams
Business Systems Analyst/PM
Brokerage Authorization, Global Wealth Management
Lead BSA on real-time tracking of intra-day ‘Transactions’, ‘Balances’ and ‘Positions’ in client accounts, ‘Brokerage Authorization’- approval/Disapproval on transactions, based on COB-previous-day bench mark data
VARIOUS CONSULTING ASSIGNMENTS (Dec 2009 to Feb 2011)
MERRILL LYNCH INC Hopewell, NJ
Business Systems Analyst (June 1995 to July 2008)
EDUCATION
MBA in Finance and Marketing
THE INDIAN INSTITUTE OF MANAGEMENT, Bangalore, India
Bachelor of Technology – Mechanical Engineering, Bangalore, India
THE INDIAN INSTITUTE OF TECHNOLOGY
Certificate program -Client Server Technology
THE NEW JERSEY INSTITUTE OF TECHNOLOGY, NJ, Jersey City, NJ