Post Job Free

Resume

Sign in

Data Analyst

Location:
Princeton, NJ
Posted:
June 29, 2017

Contact this candidate

Resume:

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



Contact this candidate