We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

3.00/5 (Submit Your Rating)

CharlottE

SUMMARY

  • Sr. Business Systems Analyst with 8+ years’ experience in delivering projects across Banking and Finance domain.
  • Sound expertise in performing business requirement elicitation & analysis, business intelligence and coordinating among business and technical stakeholders.
  • Dedicated professional with a deep understanding of businesses dealing with corporate banking, asset and wealth management, blessed with the ability of quick learning, astute decision making, strong work ethic, and teamwork skills.
  • Considerable acquaintance with banking and finance domain concepts such as Asset Management, Wealth Management, Mortgage Solutions, Capital Markets, Investment Securities (Stocks, Bonds, Commodities, Derivatives), BASEL III, FINRA, GAAP, IFRS, Know Your Customer (KYC), LIBOR, Fair and Accurate Credit Transaction Act (FACTA), Fair Credit Billing Act (FCBA), Fair Credit Reporting Act (FCRA), Bank Secrecy Act.
  • Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
  • Experienced in working under various SDLC environments such as Agile Scrum, Waterfall, Water - Scrum Fall showcasing abilities to work with self-organizing and cross functional teams.
  • Highly proficient in capturing requirements from business stakeholders through conducting requirement elicitation techniques such as JAD sessions, Workshops, Brainstorming, Interviews, Prototyping and Document Analysis.
  • Maintained JIRA dashboard while assisting the product owner in slicing the epics into user stories following INVEST criteria and capturing the stories into Product Backlog while linking relevant artifacts to Confluence.
  • Drafted various business artifacts such as Business Requirement Document (BRD), Functional Specification Document (FSD), Use Case Document, Requirements Traceability Matrix (RTM), Risk Register, RACI matrix.
  • Designed diverse architectural and UML diagrams in the form of process flow diagrams, swim lane diagrams, use case diagrams, wireframes, mock-ups and prototypes using tools like Lucid Chart, Balsamiq and MS Visio allowing key stakeholders to comprehend the application design and define Minimum Viable Product (MVP).
  • Periodically assisted product owner in prioritizing and scrum teams in estimating user stories using various techniques such as MoSCoW, KANO, Planning Poker, Relative Mass Valuation and T Shirt Sizing helping deliver critical functionalities of the release and maximizing the business value among different phases of the project lifecycle.
  • Aided project managers in conducting Cost-Benefit Analysis, Feasibility Studies, Impact analysis, root cause analysis, SWOT analysis, risk analysis and ROI Analysis to evaluate and authenticate the needs of the project.
  • Performed API end point validation using Postman and documentation using Swagger to capture the Headers, Query Parameters, Resources, POST/PUT response body and different error codes received.
  • Diligently performed in depth GAP analysis and Business Process Mapping to understand the AS-IS and TO-BE business processes helping to identify source to target mapping (STM) and transformation logics.
  • Hands on experience in writing and executing SQL queries using DDL (Data Definition Language), DQL (Data Query Language) statements to perform CRUD operations like VIEW on database and experience in executing SQL queries like Joins, unions, group by, Subqueries and Aggregate functions.
  • StrongData modelingexperience usingER diagram, Dimensional data modeling,Logical/Physical Design,Star Schema (identification of facts, measures and dimensions) modeling, Snow-flake modeling using tools like Erwin, ER Studio.
  • Excellent insights of data warehousing, data profiling, data migration, ETL and data visualization processes with hands on experience in tools such as Tableau, Informatica PowerCenter, Power BI.
  • Prepared data visualization reports using Tableau and Power BI through connecting csv, excel and database files showcasing the business insights and progress reports using Histograms, Heat Maps, Symbol Maps, Pie Charts etc.
  • Facilitated Integration Testing, Regression Testing, Load/Performance Testing, System Testing, Smoke Testing, Stress Testing, and Sanity Testing. Facilitated testing using Software Testing Life Cycle, Bug life cycle & Bug Tracking tools like HP QC/ALM and Confluence.
  • Collaborated with QA Team in formulating Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data, issuing the Test Reports, and validating requirements with the Requirements Traceability Matrix (RTM).
  • Facilitated UAT sessions ensuring the product quality with a thorough understanding of testing concepts pertaining to both manual and automation using tools like HP ALM/QC and Selenium.

TECHNICAL SKILLS

Banking and Finance Domain: BASEL III, CCAR, Dodd Frank Act, Trade Reconciliation, Asset Management, Mortgage Solutions, Wealth Management, Securities (Stocks, Bonds, Commodities, T-Notes), Derivatives (Futures, Options), FX Trade

SDLC Methodologies: Agile-Scrum, XP, Waterfall, Water-Scrum Fall, Spiral and Kanban

Business Skills: Project Management, Requirements Elicitation, Stakeholder Management, Strategic Planning, Business Process Mapping, Conflict Management, Scheduling, Risk Management, Impact Analysis, Liaising

Business Modeling tools: MS Visio, Balsamiq Mockups, Lucid Chart, Wireframes.cc

Project Management Tools: JIRA, Rally, MS Project, MS SharePoint, Confluence, Load Runner, Postman, Swagger

BI and Reporting Tools: Tableau, MS Office Suite (Excel, Word, PowerPoint), Power BI, SSRS

Testing Tools: Cucumber, HP ALM/QC, Postman, Swagger, Load Runner

IDE and Repositories: Eclipse, MS Visual Studio, GitHub, SVN

Databases and ETL Tools: Informatica PowerCenter, Oracle, My SQL, Postgres, MS SQL Server

PROFESSIONAL EXPERIENCE

Confidential | Charlotte

Sr. Business Systems Analyst

Responsibilities:

  • Organized JAD sessions and workshops, prepared agenda and facilitated the meetings with the SMEs, product owner & stakeholders to elicit requirements, document outcomes, and capture Minutes of Meetings (MOMs).
  • Designed use-case diagrams, activity diagrams and sequence diagrams using MS Visio to create wireframes and low fidelity mockups to provide visual insights to business stakeholders.
  • Performed GAP Analysis by understanding the AS-IS business process and TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio.
  • Assisted product owner in prioritizing epics using MoSCoW approach, vertically slicing epics to user stories and scrum team in estimating story points using Planning Poker to prepare Product Backlog Items (PBIs).
  • Performed API testing using Postman to validate the request and response for JSON based RESTful services using CRUD based methods like GET/POST to capture the response error codes and data received in the body.
  • Participated in scrum ceremonies such as Sprint Planning, Sprint Review, Daily Scrum and Sprint Retrospective.
  • Assisted deployment team in running different builds deployed to dev, test and prod environment using Jenkins.
  • Prepared and maintained Requirements Traceability Matrix (RTM) assisting the developers and testers among different sprint executions to associate the defects raised to each requirement and ensure a reliable test coverage report.
  • Drafted and uploaded various business artifacts to Confluence to maintain a shared, centralized and easily accessible site while linking JIRA issues to relevant spaces to promote information accessibility among team members.
  • Executed various SQL queries of DDL, DML, DQL types for data modification and maintain integrity in terms of the data quality.
  • Created UAT test scripts, lead the sessions and performed testing with end users to ensure the quality of each release.
  • Participated rigorously inSmoke, Sanity, Load/Stress, Regression,End-to-End, andIntegration testing.

Environment: Agile (Scrum), JIRA, Confluence, MS Visio, Selenium, Amazon Redshift and S3, Oracle DB, Tableau, Postman, JavaScript, REST API, HTML, CSS, Apache server.

Confidential | Phoenix, Arizona

Sr. Business Systems Analyst

Responsibilities:

  • Monitored the progress of the overall project, tracked individual issues such as user stories, defects and technical debt using Atlassian JIRA, allowing for improved visibility of project status and accurate forecasts.
  • Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.
  • Leading theAML/Trade Surveillanceactivities for fixed income and equities: BRD, Implementation of incident methodology, monitoring threshold. Liaise between the users and the development team. Act as the focal point for QA and production problems.
  • Analyzed feasibility of business requirements and identified dependencies by interacting with Subject Matter Experts (SME), Product Owner, and Technical Lead. Worked with Product Owners in the breakdown of high-level capabilities into features and User stories.
  • Worked in Scrum Agile Framework and assisted the Product Owner with identifying dependencies and prioritizing User Stories based on MoSCoW model, identifying the Acceptance Criteria, defining Definition of Ready (DOR) and Definition of Done (DOD).
  • Actively participated in all the scrum meetings like sprint planning, daily standup meeting, sprint review, sprint retrospective, and product backlog grooming.
  • Conducted Gap Analysis of existing architecture and prepared workflow scenarios, designed new process flows of the proposed trading floor system.
  • Jointly responsible for assisting Test Plans, Test Scenarios & Test Cases with the testers from the team and assisted testing of the system during Smoke Testing, Regression Testing.
  • Created various Reports like bar graphs, interactive live dashboards, heat maps using Tableau for portfolio Analysis.
  • Generated automated task reminders and documented testers feedback using Confluence for performance evaluation and created various Confluence portals to manage requirements, meeting minutes, discussions.

Environment: Agile-Scrum, Oracle SOA Suite, Salesforce Financial Services Cloud, Confluence, JIRA, Lucid Chart, Salesforce CRM, Salesforce Marketing cloud, Tableau, SQL.

Confidential | Johnston, Rhode Island

Business Systems Analyst

Responsibilities:

  • Analyzed the prior documentation and business processes for complete understanding of the project. Conducted JAD sessions, Document analysis and Interviewed area experts, asking detailed questions, and carefully recording the requirements hereby building a bridge between the stakeholders and technical people.
  • Conducted GAP Analysis to thoroughly understand and document AS-IS process flow and to determine the TO-BE process flow by considering all the Functional and Non-Functional requirements for the future system and conducted IMPACT analysis to capture the effects that the implementation of the new system.
  • Prepared the function flow of application; by creating High fidelity Wireframes and MockUps using Balsamiq.
  • Performed GAP Analysis by understanding the AS-IS business process and TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio.
  • Developed several activity and sequence diagrams with swim lanes and UML components to show entity relationship diagrams (ERD) using Lucid chart and Microsoft Visio for the developers and data architects.
  • Assisted in elaboration of epics into user stories in Product Backlog Grooming Session so that stories are granular.
  • Developed knowledge on Anti Money Laundering and Machine Learning which included Trade Surveillance and Case management for developing risk profiling modules on assuring compliances like Know Your Customer and Customer Due Diligence.
  • Reviewed systematic Anti Money Laundering (AML) alerts and determined if transactions occurring are valid risks based on triggering event driven review for dynamic downgrade of customer risk rating.
  • Designed API technical documents and conducted API designs sessions to understand their functional features of REST, HTML, XML.

Environment: Agile-Scrum, MS Office Suite, JIRA, Java Script, Java Web Services, Oracle DB, HP ALM, Lucid Chart, Cucumber, Balsamiq, Rest API, MySQL Data warehouse.

Confidential

Business Systems Analyst

Responsibilities:

  • Conducted extensive GAP analysis by identifying AS-IS of the project and TO-BE’s for process vision and process flows.
  • Worked with Product Owner to create User Stories, also helped the PO in prioritization of Product Backlog Items (PBIs) and also making sure user stories follow INVEST Criteria.
  • Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Used JIRA for allocating tasks, user story writing, backlog management, issue tracking and user story management.
  • Created Data Mapping Document to capture Source to Target Mappings and ensured required datasets were present.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams and assisted in development of Conceptual design, Logical data design model for Database, Data warehousing.
  • Created class diagrams, ER diagram and performed SQL queries operation such as DDL commands for data extraction and used SQL queries (select, insert, update, delete, sub-queries, joins, etc.) to filter and manipulate the data in the databases.
  • Assisted and Validated DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Reviewed the data model and reporting requirements for Tableau reports with the ETL and Reporting team.
  • Assisted in validation of source to target data by assisting in source and target testing.
  • Assisted in formulating and reviewing testing documents like Test cases and Test scenario, and developed ad hoc, daily, weekly and monthly report on Tableau.
  • Developed strategies with Quality Assurance group to implement Test Cases for User Acceptance Testing.

Environment: Agile-Scrum, MS Visio, MS Office Suite, JIRA, MS-SharePoint, Swagger, MS SQL Server, Informatica PowerCenter, Tableau, CSS, HTML.

Confidential

Business Systems Analyst

Responsibilities:

  • Assisted in generating a streamline process to understand the various steps in the Loan Lifecycle and desired functionality of the new system by interacting with users, SMEs, stakeholders, lenders, underwriters.
  • Identified and analyzed needs for various functionalities by using various techniques such as Document Analysis, Focus Groups, and Interviews with Subject Matter Experts (SMEs) and project stakeholders.
  • Performed GAP Analysis by understanding the AS-IS business process and TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio.
  • Assisted in elaboration of epics into user stories in Product Backlog Grooming Session so that stories are granular.
  • Developed several activity and sequence diagrams with swim lanes and UML components to show entity relationship diagrams (ERD) using Lucid chart and Microsoft Visio for the developers and data architects.
  • Prepared the function flow of application; by creating High fidelity Wireframes and MockUps using Balsamiq.
  • Conducted end-to-end data validation of data flow and created the Data Mapping Document, for defining data flow between data source and target, along with business rules and assisted ETL developers to prepare ETL routines to conduct the process.
  • Written and executed SQL queries to perform various types of analysis like data analysis, data validation and data manipulation using different types of Joins, Subqueries and Aggregate functions on Oracle 12c DB.
  • Used Tableau 9.1 to generate credit check reports and application status reports.
  • Designed API technical document and conducted API designs sessions to understand their functional features of REST, HTML, XML using Postman and worked on developing API integration documentation using Swagger.
  • Worked with the QA team for validating Test Plan and Test Cases for Integration testing, Regression Testing, Whitebox Testing, black Box Testing, Smoke Testing and assisted in facilitating User Acceptance Testing (UAT).

Environment: Agile-Scrum, MS Office, MS Visio, MS Project, Share Point, Balsamiq, HP ALM, Web Services, REST, SOA, HTML, Tableau, Oracle, SQL, Postman, Swagger, JIRA, Confluence.

Confidential

Business Systems Analyst

Responsibilities:

  • Performed Requirement Elicitation techniques to extract requirements from business stakeholders.
  • Worked extensively to understand and document the requirements for the new modules which were being added to the system.
  • Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues to develop specifications.
  • Created Business Requirement Document (BRD), Functional Requirement Document (FRD). Non-Functional Requirement Document (NFRD), Use Case Document (UCD).
  • Maintained Change and Traceability Matrix throughout the project keeping track of the scope, timelines, and budget of the project.
  • Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS Visio.
  • Created Wireframes/ Mockups using Balsamiq tool for both the new modules which are being added to the current system.
  • Interacted with Product Owners to create and identify Epics, User Stories and creating Product Backlog in JIRA.
  • Developed Data Models in collaboration with Data Architect and Data Modelers and wrote SQL queries to validate.
  • Coordinated in creation of ER Diagrams defining entities, attributes, relationships, normalization and business rules.
  • Assisted front-end developers involved in development of UI through HTML, CSS, jQuery & JavaScript.
  • Provided detailed User Interface Document to the development and testing team for clear understanding of the system.

Environment: Waterfall-Scrum, MySQL, JIRA, MS-Visio, MS-Project, Balsamiq, SAP Power Designer, MS Excel, MS Access, Windows 7, RTM.

Confidential

Quality Analyst/ Tester

Responsibilities:

  • Reviewed System Requirement Specifications (SRS), Functional Requirement Document (FRD) & design documents.
  • Designed & documented Test Plans, Test Scenarios, Test Cases based on business requirements & design documents & logged defects in HP ALM.
  • Prepared Test Data for positive and negative test scenarios for functional testing using boundary value analysis and exhaustive testing as documented in test plan.
  • Validated the database using various SQL queries like Joins, group by & SQL Aggregate queries for data profiling.
  • Prepared Requirements Traceability Matrix (RTM) to help the stakeholders trace the requirements.
  • Documented Bug Report and Categorized them based on severity and Priority.
  • Used Quality Center to store all test results and for defect tracking and reporting.
  • Provided weekly management status reports and coordinated meetings between test team and development team to review defects and track them to closure. Created Macros which helped in enhancing the reports.
  • Took part in all phases of testing; Smoke testing, Graphical User Interface (GUI), Functional testing, System testing and Regression testing and support User Acceptance Testing (UAT).

Environment: Waterfall Methodology, Oracle-8, HTML, Java script, Java, Windows XP, Quality Center, MS Office Suite, HP/ALM, Windows 7/XP.

We'd love your feedback!