We provide IT Staff Augmentation Services!

Sr. Business System Analyst Resume

SUMMARY

  • Qualified Business System Analyst with 8 years of experience in successful delivery of high - quality IT solutions in Banking Domain. Used analytical and critical thinking to solve a wide variety of critical business problems.
  • Contributed to all phases of Software Development Life Cycle (SDLC) in multiple projects by working with the Business Users, Key Business Stakeholders, Subject Matter Experts (SMEs), Project Managers (PMs), Scrum Master, Product Owner, Architects, Testers, Developers and delivered end-to-end business solutions by facilitating important meetings. Worked in traditional Waterfall and Agile Methodologies such as Scrum, Scrum-Waterfall.
  • Knowledge in various regulatory acts such as Suspicious Activity Report, Bank Secrecy Act and compliances such as Payment Card Industry Data Security (PCI DSS), Anti Money Laundering (AML), Know your Customer (KYC), CIP, Customer Due Diligence (CDD), Automated Clearing House (ACH), NACHA.
  • Strong experience in requirement elicitation techniques like Brainstorming, JAD Sessions, Document Analysis, Interviews, Focus Groups, Job shadowing, Interface analysis, Requirements Workshops & Marketing Analysis.
  • Extensive experience in creating Screen Mock-ups & Prototypes, conducting Gap Analysis, Impact Analysis, SWOT Analysis, Cost-Benefit Analysis, Risk Analysis, Root Cause Analysis, Feasibility Study and Return on Investment.
  • Drafted several artifacts such as BRD (Business Requirements Document), FRD (Functional Requirements Document), SRS (Software Requirements Specification) and RTM (Requirements Traceability Matrix), Risk Register, Data Flow models, Change request document, Project charter, work breakdown structure (WBS)
  • Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Collaboration Diagrams, Data Flow Diagrams and Sequence Diagrams in MS Visio.
  • Participated in Scrum ceremonies including Backlog Refinement, Sprint Planning, stand up meeting, Sprint Review and Sprint Retrospective and experienced in Prioritizing Techniques like MOSCOW, KANO and Estimating Techniques like Planning Poker, Relative Mass Valuation, T-shirt Sizing and Bucket Sizing.
  • Assisted product owner with the Definition of Done (DoD) and Definition of Ready (DoR) for backlog items.
  • Helped with the story mapping process in Agile after elicitation and documentation of requirements (user stories).
  • Facilitated Release Planning sessions for the product, assisted all the teams in writing business epics. Helped in the sizing and estimation and prioritization of epics by helping SMEs performing SWAG Analysis.
  • Experienced with issue creation, built mechanisms to validate changes, evaluate their impact and resolution using Atlassian JIRA.
  • Competent in supporting the Product owner to define Minimum Viable Product (MVP), Definition of Done (DoD), and writing Acceptance Criteria for user stories and tasks. Worked in Test Driven Development (TDD), Acceptance-Test Driven Development (ATDD), Continuous Integration and Behavior Driven Development (BDD) environments and developed Feature Files with high level description in Given-When-Then format (Gherkin format).
  • Experience in Data Integration using Data center with Hub and Spoke. Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
  • Experience working in Mainframe environment and deep understanding of database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data-Entity Relationships and User Administration. Worked extensively with Data warehouses by migrating data from various OLTP’s to OLAP cube using ETL tools such as Informatica.
  • Experienced in creating Entity Relationship diagrams, Conceptual, Logical, and Physical data models.
  • Created Source to Target Data Mapping documents indicating the source tables, data types, transformations required and the business rules to be applied using Informatica. Knowledge of Data Mapping, Integration and Migration.
  • Examined Source Data using SQL queries as a part of Data Profiling to configure and compute the profile data and experience in executing queries like Joins, subqueries, and Aggregate functions. Good understanding of Procedures, Functions and Triggers.
  • Proficient in using tools like Informatica PowerCenter, Tableau and SSRS (SQL Server Reporting Services).
  • Managed ETL (Extract, Transform and Load) testing, data cleansing, transformation testing, data profiling in databases.
  • Solid knowledge of the Three-Tier Architecture, Service-Oriented Architecture (SOA), Application Programming Interfaces (APIs), Simple Object Access Protocol (SOAP), Representational State Transfer (REST), Extensible Markup Language (XML), with the requirements that can be conveyed to the Development/UX team through prototypes.
  • Experienced in performing application programming interface (API) testing using test scripts with the help of Postman and SoapUI to test the requests and responses of APIs.
  • Experienced in Black Box, Manual, Unit, System, Performance, Load, Stress, Regression, Automated, Functional, Non-Functional, UAT, Smoke and Sanity Testing of applications with knowledge on STLC (Software Testing Lifecycle) by creating Test plan, Test Scripts, Test cases, Test Scenarios and Test Analysis reports .
  • Created various types of reports like heat maps, tree maps, histogram, pie charts and dashboards using Tableau and Power BI.

TECHNICAL SKILLS

Banking Domain knowledge: National Automated Clearing House Association (NACHA), Anti Money Laundering (AML), Payment Card Industry (PCI DSS), KYC, Customer Due Diligence (CDD), Bank secrecy Act.

Tools: /Methodology: Unified Modeling Language (UML), MS-Project, MS Share Point, Rally, JIRA, and Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, and Kanban.

Modeling Tools: Power Designer, ER/Studio, ORACLE SQL developer Data Modeler

Requirement Management: MS Office, JIRA, Confluence, HP ALM

Reporting Tools: IBM Cognos, Tableau, MS office Suite, Spotfire

Database: MySQL version 2012, MS Access, Oracle 9i, DB2

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Transaction Processing (OS): IBM CICS TG V9.0

Testing Tools: HP QC / HP ALM 11.5, Load runner, Bugzilla and SOAP UI

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI)

Languages: HTML, XML, SQL version 2012, SOAP and Java

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business System Analyst

Responsibilities:

  • Developed good Understanding of Payment Card industry Data Security Standard (PCI DSS), Tokenization process, Customer Identification Program (CIP), Customer Due Diligence (CDD), and KYC.
  • Conducted GAP analysis by identifying AS-IS and TO-BE process models and process flows to identify the Shortcomings and in turn help product owner to plan how to bridge the gap.
  • Worked in Agile software development methodology and assisted Product owner in performing user research and market research.
  • Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
  • Analyzed feasibility of business requirements and defined scope, identified dependencies by interacting with Management, Business Analysts, Subject Matter Experts (SME), Product Owner, Project Manager and Technical Lead.
  • Actively involved in breaking down Epics into User stories by Satisfying the INVEST criteria in acceptable limits.
  • Sliced user stories using Horizontal and Vertical Slicing Techniques, helped PO in prioritizing using Prioritization techniques such as Moscow, Kano methods and Estimating user stories using techniques like Planning Poker.
  • Used JIRA and Confluence for tracking project progress and team collaboration to carry out the project effectively and maintained the Product Backlog Items (PBIs) and defects by prioritizing and tracking the user requirements and Requirement Traceability.
  • Participated in Scrum ceremonies and assisted the Product owner in writing the Acceptance Criteria in Gherkins format, and extensively used JIRA for converting requirements to user stories and helped in framing Definition of Done (DoD).
  • Worked closely with the technical team to convert functional requirement to technical requirement and developed high fidelity prototypes for Graphic User interface (GUI)-wireframes and mock-up using Balsamiq Mockups.
  • Developed Unified Modelling Language (UML) diagrams such as use case diagram, activity diagram, sequence, and Entity- Data model diagram using Lucid Charts to communicate the flow of project to all the business stakeholders.
  • Examined Source Data using SQL queries as part of Data Profiling to configure and compute the profile data. Extensively performed data mapping according to Data Mapping Specification document from sources data (CSV, Flat file, Excel) to the target data using Informatica PowerCenter.
  • Engineered ETL via data mapping, data profiling, data cleaning and performed different transformation on the data coming from Data Store(ODS) to Data warehouse, to integrate Customer information into the DWH and also performed ETL between Data warehouse and the database so that all the data is integrated .
  • Assisted in implementing a Vormetric token service and token verification system to resolve user authentication and authorization process, and written business logics and system validations to increases the integrity of the system in authenticating the user.
  • Assisted in writing API documentation using Swagger and carried out functional API testing using POSTMAN to connect with web services in HTML and XML formats as per the system requirement for proper data flow between web services.
  • Assisted in practices such as Behavior Driven Development (BDD) by writing test cases in Gherkins using Cucumber.
  • Assisted in creating Automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis performed. Maintained test notes and requirement using HP ALM. Involved in preparing Test Plans based on User Requirements Document (URD).
  • Created test cases for manual testing in Integration testing, System testing and User Acceptance Testing (UAT).
  • Created interactive reports like Customer Enrolment, Transaction Type, Token Generation, and Statics of Customer enrollment using Tableau and Excel to track the effect of the program on transaction process.

ENVIRONMENT: Agile-Scrum, MS Visio, MS Office (MS Word, MS Excel, MS PowerPoint), JIRA, Cucumber, Balsamiq, Tableau, Postman, Swagger, HTTP Protocol, HTTP Apache, HP ALM, KYC, CDD, PCI DSS.

Confidential

Sr. Business System Analyst

Responsibilities:

  • Developed good understanding of Anti Money Laundering , KYC, Rule-Engine Base Solution, Risk Management, Alert Dashboard, Natural Language Processing (NLP), Machine Learning algorithm (Supervised).
  • 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
  • As a part of the Collaborative team, sporadically acted as a Proxy Scrum Master during the Scrum Ceremonies when needed.
  • Responsible for defining the scope and business rules of the project and gathering essential business requirements. Worked with the Business Users through interviews and JAD ( Joint Application Development ) sessions.
  • 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.
  • Communicated across all the Stakeholders various aspects of Machine Learning algorithm and Anti Money Laundering Compliance to keep the data protect from any attacker to have access to the transaction.
  • Produced Unified Modelling language (UML ) diagrams such as Use-Case Diagram and Sequence diagram for the Business Stakeholders and end-users to get a better perspective on the flow of the system using Lucid Chart .
  • Involved in the ETL process using Informatica Power Center and performed transformation on the landing database.
  • Logged the Source table information and the Target table information with transformation logic on the source -target document and performed various transformations on the data being transferred to the target system.
  • Actively collaborated with the development team to design and build a customized Alert Dashboard and AML engine.
  • Used SharePoint to obtain sign-off from stakeholders on the Process Design Document created incorporating business rules, input and output data mappings, feedback etc.
  • Queried database using SQL using joins, views, unions and subqueries like Sum, min, max, avg.
  • Performed rollup and drill down operations as a part of OLAP data warehouses to present data in required format.
  • Defined Test Scenarios and associated Test Cases using JIRA for efficient tracking and resolution of issues.
  • Built mechanisms to validate changes and evaluate their impact and tracked them using JIRA.
  • Responsible for defect tracking and reporting the defects and worked closely with the development team to ensure high quality and timely releases.
  • Identified/documented data sources and transformation rules required for maintaining data warehouse content.
  • Helped the team in implementing ETL process using Informatica and performed OLAP operations so that the Customer data will be analyzed to get information about Suspicion Activity, transitions of money and assessment of funds.
  • Performed RESTful API documentation with validations, assumptions, and specification for request and response messages using Swagger and assisted in API Testing to check for the response format of data using POSTMAN .
  • Created API documentation as reference for API endpoints consisted section like resource description, Endpoints, methods, parameters, and sample requests.
  • Create and managed Test case, Test plan, Test Scenarios and performed UAT and integration testing using HP ALM ; Provided support for bug fixes and aided with maintenance support after the product has gone live.
  • Provided Status Reports every week on the progress of the Projects to the higher management and facilitated peer reviews and inspections to reduce defects in the requirements representations.

Environment: Scrum, MS project, MS office Tools, MS Project, MS Visio, UML, HP QC, JAVA, Oracle 11g, Spotfire and JIRA, Informatica v9x, Tableau, Confluence, Cucumber, Share point.

Confidential

Business System Analyst

Responsibilities:

  • Knowledge of NACHA operating rules, SAME DAY ACH processing.
  • Conducted GAP Analysis to derive requirements for ACH processing.
  • Worked in Agile Scrum methodology.
  • Assisted Project Manager in preparing project plan, Project timeline, high level-scoping document.
  • Worked with business stakeholders in creating user acceptance criteria and conducted/coordinated UAT.
  • Maintained the Product Backlog Items (PBIs) and defects by prioritizing and tracking the user requirements.
  • Complied with NACHA and other state Compliance. Helped the organization in documenting the best practices for P2P Payment and Same-day bill pay.
  • Conducted JAD sessions periodically with various stakeholders at various phases of the project.
  • Highly skilled in communicating the business process to the stakeholders, development, technical team as well as to the end-users.
  • Interacted with various cross-functional Teams on building business use cases and understanding expenses and revenue stream.
  • Actively involved in facilitating Backlog grooming, sprint Planning, Daily scrum, Sprint review and Retrospective.
  • Used JIRA to generate and maintain the artifacts such as Product backlogs, Sprint backlogs, User stories, Impediments list, defects. Generated Burnup and Burndown charts to monitor Scrum Team performance to devise sprint strategies.
  • Identified and documented Business Process Workflows using UML Diagrams and Assisted System Admin in defining process workflows using Business Process Execution Language Process Manager.
  • Worked closely with System Architects, ETL Operations and Quality Analyst teams to provide Use cases and Algorithms to satisfy Business requirements.
  • Involved in Issue assessment, Risk analysis and Change management to articulate and resolve the business needs.
  • Identified, Integrated, and analyzed various data sources like Flat files, RDBS to the OLAP using Informatica and performed Data Verification, Validity and Normalization in the process of maintaining accuracy and effectiveness of data.
  • Collaborated with the QA team to develop the test (plans/scenarios/cases/data) to be used in testing based on different business requirement.
  • Provided Status Reports every week on the progress of the Projects to the higher management and facilitated peer reviews and inspections to reduce defects in the requirements representations.
  • Performed Unit and Integration testing with the Development team, UAT and regression testing of the Network Functionality using QTP and Quality Center.
  • Developed Test cases and assisted Quality Assurance team in System Integration Testing using HP ALM.
  • Responsible for tracking and documenting the defects in the system and appropriate solutions have been tested and released in production environment.

Environment: Scrum, MS Visio, MS Project, MS office, MS SQL server 2012, Visual studio 2013, JIRA, Tableau, MS Office Suite (MS word, MS Excel, MS Project, PowerPoint).

Confidential

Business System Analyst

Responsibilities:

  • Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios a used standard template of the organization to develop requirements. Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME) sessions.
  • Analyzed and gathered requirements for preparation of Business Requirement Document (BRD) , Functional Requirement Document (FRD) and System Requirement Specification (SRS).
  • The methodology used for the project was Waterfall- Scrum (Hybrid), Provided clear and consistent information about project status both internally, IT team and stakeholders.
  • Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.
  • Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
  • Prepared and documented Use-Cases using UML based on requirements gathered from stakeholders. Worked with the change management team and helped schedule training of the new system to ensure a smooth roll-out to business users.
  • Performed data entry, query, editing, computation, and data retrieval using SQL
  • Prepared Business process models used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
  • Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) to capture the dynamic behavior of different applications.
  • Developed Understanding of Billing centers for Data profiling and Data modeling.
  • Utilized Informatica for Extraction, Transformation and Loading ; SAS for report generation of the data to be analyzed from the data warehouses and data marts.

Environment : Scrum-Waterfall Hybrid MS project, MS office Tools (Word, Excel, PowerPoint, and Visio), MS Project, MS VISIO, HTML, CSS, JavaScript, Informatica, MS SQL 2008.

Hire Now