We provide IT Staff Augmentation Services!

Sr. Business Analyst - Data Quality And Lineage Resume

3.00/5 (Submit Your Rating)

Jersey City, NJ

SUMMARY:

  • Business Analyst/PM 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 requirement elicitation, design, coding, quality assurance, documentation, deployment and end user training. Client - focused and exhibit excellent oral and written communication skills. Comfortable and confident among associates to promote consensus. Organized and thorough and will escalate issues when warranted.
  • Financial Services -- Business & Technology domain experience
  • Business/Systems Analysis (BRD); Functional Requirement Documentation (FRD), Solution Design, Traceability Matrix, work with Application Developer/Manager, Test Plan, System Integration Testing and UAT
  • Project Management experience following the PMLC methodology
  • Application Developer (programmer) on the Confidential ASAP back office workflow 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

DATABASES: SQL Server, Oracle, SQL Developer, DB2, RDBMS, Data Warehouse, Informatica knowledge

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, Balsamiq

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. Business Analyst - Data Quality and Lineage

Responsibilities:

  • Creating an exhaustive list of stakeholders from Business and Technology along the transitionary paths
  • Documentation of current data flow data elements in the Actimize system for gap analysis
  • Documentation of proposed Key Data Elements and their data attributes in the respective Source Systems
  • Creation of a matrix of transactional data element value, before and after each transitionary processing along the data flow path to SAS, for each Data Source
  • Create a Dashboard of summarized line-item report for each data source, to indicate any change in value of any Key Data Element during the transitionary processing
  • Drill down on each line-item to display an expanded report showing the change in data element value for each Key Data Element over each transaction, and notify corresponding Business and Technology areal

Confidential, Jersey City, NJ

Sr. Business Systems Analyst

Responsibilities:

  • Creation of a Pega Workflow Procedures Manual and Management Reporting
  • Analyze and create a combined Business Functional Requirement Document (BRD/FRD):
  • Create d various workflow processes based on 3 rd 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 ; Communication via automated emails, and phone
  • Handling of Extension and escalation approval routing, non-compliance risk acceptance
  • Comfortable working with Application Developers/Manager interpreting requirements/technology solution
  • Test Plan/Script/testing and UAT for Pega migration of 3 rd Party Risk ‘Remediation Plans’

Confidential, Mt. Laurel, NJ

Lead Business Systems Analyst/Data Analyst

Responsibilities:

  • 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
  • Forged consensus with business/ technology- to minimize changes to front/backend systems
  • Analysis to create one ‘System of Record’ for capture/update/inquire client contact-related information
  • Collaborated with Application Development Manager/Developer in reviewing the proposed Omni-Channel application framework to capture/update permissions in a new Enterprise Permissions Center database
  • Headed Data Analysis and mapping: Conducted multiple JAD sessions on data flow and integration of 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

Confidential, Jersey City, NJ

Business Analyst

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 XML data through a policy engine to the database Master and Data Lineage database
  • XQUERY used to validate the domain-object-attribute data in XML files going into the policy engine
  • SQL used to track data element-updates by different systems providing data to downstream applications

Confidential, Jersey City, NJ

Business Systems Analyst

Responsibilities:

  • 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
  • XQUERY utilized to interrogate Corporate Action-data in affected Stock Plan accounts
  • 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 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

Confidential, Weehawken, NJ

Business Systems Analyst

Responsibilities:

  • 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.

Confidential, New York, NY

Sr. Business Analyst/ PM

Responsibilities:

  • Enhance the Confidential 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)

Confidential, Pennington, NJ

Sr. Business Analyst/ Data Analyst

Responsibilities:

  • Merrill Edge Technology (GWIMT)
  • Global Books & Records initiative
  • Brokerage Authorization
  • Client Data Interface

We'd love your feedback!