Senior Business System Analyst Resume
Chicago, IL
SUMMARY
- Object - oriented, strategic and result-driven Business System Analyst and Certified Scrum Master with over 10+ years of broad-base experience working in the Banking, Finance and Retail domain.
- Recognized as a visionary and creative thinker with well-rounded knowledge and experience working with Loan Origination System, Portfolio Management System and Payment Systems.
- Possesses excellent communication skills, work ethics, strong sense of leadership and excellent analytical skill adept at conceptualizing solutions with business strategy to meet business objectives within acceptable level of risk.
- Expertise in Business System Analysis, Data Analysis, Software Design, Development, and Implementation of business applications with knowledge of Software Development Life Cycle methodologies as Waterfall, Agile(Scrum, SAFe.
- Proficient in leading Requirements Gathering process via different elicitation techniques such as document analysis, Joint Application Development (JAD), one on one interviews, reverse engineering, prototyping, focus groups workshops and Joint Requirement Planning (JRP)
- Business analysis experience in conducting Impact analysis for change requests and conflicting stakeholder requirements, GAP analysis for assessing business differences and Root cause analysis for finding core issue of defects.
- Conducted due diligence for Change Requests and implemented the change requests effectively by following change management protocols designed by Change Control Board (CCB)
- Extensive experience in creating meticulous artifacts like Business Requirements Documents (BRD), Software Requirement Specifications (SRS), as well as creating Requirements Traceability Matrix (RTM) and Use Cases.
- Developed UML diagrams such as Use Case Diagram, Data Flow diagram, ER Diagrams, Sequence and Activity Flow Diagrams as well as BPMN diagrams (Business Process Model and Notation) using MS Visio which enabled business and developers to understand the system.
- Involved in the SAFe ceremonies such as, PMC, PO Sync and played a key role in Program Increment (PI) Planning, Architectural Review and Scrum of Scrum (SOS) ensuring the cadence is maintained across the whole Agile Release Train.
- Engaged in all scrum ceremonies such as Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective with off-shore team and on-shore team and maintained project plans and schedules
- Assisted the product owner refine the product backlog by writing technical user stories based on the INVEST Criteria, prioritizing user stories based on the MoSCoW Technique, and tearing down user stories based on the SPIDR criteria.
- Working knowledge of databases such as Oracle and MS SQL Server for Data Processing, Data Mapping, Data Modeling, Extraction, Transformation, and Loading (ETL), DataStandardization, Cleansing, Scrubbing, Deduplication, and Normalization and Data Visualization and reporting applications such as Tableau and Power BI.
- Facilitated end-to-end Web Service testing on SOAP & REST API via Swagger & POSTMAN and API Documentation.
- Comprehensive knowledge of web services related concepts such as XML, JSON, JWT, WSDL, HTML, AJAX, SOA, API, SOAP and RESTful Web Services as well as experience in working with SOA architecture and Micro-Service architecture.
- Good experience in Relational Database Management System including performing complex SQL queries for mapping of various system applications.
- Sound knowledge and understanding of methodologies such as TDD for code testing, BDD for behavior-oriented functionality testing and ATDD for user-oriented testing for their application
- Highly involved in SDLC and STLC by conducting efficient code reviews, facilitate various testing by performing planning and development of Test Plans, Test Cases and Test Scenarios to meet product’s business requirements.
- Actively assisted in creating test scenarios, test accounts and test strategy framework for UAT and Regression Testing to support pre- and post-implementation of applications and production issues along with QA and other business groups.
- Extensive knowledge and understanding in Fannie Mae and Freddie Mac, TRID regulations, CARES, OFAC, BSA, FINCEN, AML laws, FFIEC AIBE rules, KYC and due diligence procedures, GAAP and IFRS rules, and HMDA regulations.
TECHNICAL SKILLS
Methodologies: Agile - Scrum, SAFe, Waterfall, Hybrid
Web Technologies: JSON, XML, HTML, SOAP, RESTful Web Services, API, AJAX
Protocols: HTTP, HTTPS, SMTP, SOAP, FTP
Project Management Tools: Microsoft Project, Jira, Rally, Azure DevOPs
Database: Oracle 12c, MS SQL Server 2012, IBM DB2 - 10.5
Data Warehousing Concepts: OLTP Database, OLAP - Datawarehouse, ETL process through SSIS
Languages: SQL
Modeling Tools: MS Visio, Figma, Lucid Charts, Draw.io, Balsamiq
Reporting Tools: Tableau, MS Power BI, SAP Crystal Reports, XSL-FO
Documentation Tools: MS Office Suite, SharePoint, Confluence
Testing Tools: Swagger, Postman, HP Quality Center/HP ALM
PROFESSIONAL EXPERIENCE
Confidential - Chicago, IL
Senior Business System Analyst
Responsibilities:
- Elicited Business Requirements by conducting detailed Interviews and Focus Group Sessions with Business Users, Stakeholders, and Subject Matter Experts (SMEs) such as Underwriters, Credit Analysts to define the Financial Projections and Cost-Benefit Analysis
- Worked closely with the Product Owner and assisted in breaking down features by WSJF method and their refinement
- Coordinated with Residential Underwriter, Mortgage Loan Servicer, Credit Analyst, and Compliance Professionals to determine the Business rules concerning Fixed-rate mortgage loan, Adjustable-rate mortgage loan, Government-Insured Mortgages, Jumbo Mortgages, and Conventional Mortgages
- Documented the gathered requirements in BRD and facilitated the JAD session where Requirement Modeling was done by drafting UML diagrams and BPMN Diagrams to identify the area which requires Customization
- Performed GAP Analysis for the elicited requirements to analyze if the Loan Origination System is capable of fulfilling the business requirements
- Draft and maintain software/business requirement documents in order to outline REST API project needs, assumptions, constraints, and milestones.
- Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower
- Responsible for the quality of all changes to Empower, the Confidential loan origination system for the branches
- Wrote Client-Side Validation, Server-Side Validation and Database Validation for various functionalities of the system
- Authored User Stories and Acceptance Criteria for the business requirements using INVEST criteria pertaining to the ATDD approach and managed team to build-up their velocity and managed performance using Agile KPIs such as Velocity chart, and Burnup chart in Jira Tool
- Defined and suggested SOAP, XML based Web services, and APIs based on languages such as C# and JAVA which would be compatible with the “As-Is” and “To-Be” state of the business process
- Provided training to business users involved in Sprint Review and demonstrated the agreed requirements as per the DOR and DOD criteria expected by the Product Owner and business stakeholders
- Utilized UDDI to look up existing web services and WSDL to identify the corresponding request and response web methods
- Assisted the Product Owner to prioritize User-Stories using MoSCoW techniques during Sprint Planning and Backlog Grooming Sessions
- Responsible for developing functional and technical user stories in INVEST criteria and Acceptance Criteria in GHERKIN format
- Excellent backend skills in API Integration and API Mapping, creating SQL objects such as Tables, Stored Procedures, Functions, Views, Indexes, Rules and SQL Performance Tuning to facilitate efficient data Manipulation and Consistency
- Created Data Mapping documents and worked with business to write Transformational rules
- Hands-on experience in Schemas, Dimensional modeling and Reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies in RDBMS including developing optimized SQL queries, Stored Procedures, User-defined Functions, and Transactions
- Ensured the application is compliant with all TRID regulations, AML laws, OFAC, BSA, FINCEN, and HMDA regulations
- Facilitated UAT sessions and developed Test Plans and Test Cases for verification and validation of requirements at all levels
- Involved in recognizing and generating reports for both the clients and the management being a core team member of the Center of Excellence
- Performed Functional testing and Smoke testing on a regular basis to make sure that the basic functionalities of the system are working
- Facilitated Triage calls to identify defects by performing Root Cause Analysis and mitigated it along with development and testing team
Environment: Agile - SAFe, SOA, Framework (HTML/CSS, Angular JS, Java, SQL, Oracle 12c, DB2), Tableau Desktop, AJAX, SOAP, XML, REST, Microservice, UML, Jira, Confluence, MS Excel, MS Visio, XSLFO, Windows 8.0, Informatica Power Center, Swagger, HP QC
Confidential - Providence, Rhode Island
Sr. Business System Analyst/ Technical Scrum Master
Responsibilities:
- Analyzed the existing system, performed Reverse Engineering to understand the As-Is system, extracted important functionalities, analyzed possible enhancements and documented them
- Validated the MT to MX mapping as per ISO 20022 and coordinated with the product owner in mitigating any impact.
- Analyzed data points and data fields on EDI 835, 837 to implement in the project
- Performed Gap analysis to assess the strengths and weaknesses of the proposed project in comparison to the current state documented in terms of various components
- Created SOS Interest (PI) grids to identify the key stakeholders for eliciting business requirements
- Facilitated Focus Group meetings, Stakeholder Interviews, and JAD Sessions with business users, developers, architects and database development team in order to elicit the base level requirements
- Designed and developed UML Diagrams including Use Case, Activity Flow, Class, Data Flow and Sequence diagrams usingMS Visio
- Created Dynamic Wireframes using Fluid UI for better understanding of the GUI and flow of the application
- Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved
- Involved in estimating the story points for user stories using Planning poker and Fibonacci series
- Responsible for creating the FRD and the BRD. Created various types of reports, sub-reports and drilldowns like standard and cross tab reports with bar chart, pie chart and line-chart graph representation reports using Crystal Reports
- Involved in identifying and implementation of SOAP, XML based webservices and web methods
- Performed Extract, Transform and Load (ETL) operations to perform data cleansing and standardization for reporting and actively involved in Data Mapping process
- Facilitated meetings with the development team to help them better understand use cases and to help them come up with code flow for these research items
- Acted as the gatekeeper for all the defects in the testing phase, logged and analyzed defects using HP-ALM and also tracked the overall progress of testing by maintaining a Requirement Traceability Matrix (RTM)
Used Power-BI software to create functional diagrams and identify key areas for data analysis.
Environment: Agile - Scrum, SOA, Framework (HTML/CSS, REACT JS, Java, SQL, IBM DB2), SOAP, REST, AJAX, SLA, Web service, Microservice, Rally, MS Visio, MS Project, Windows XP, XML, Java, SSRS, SSAS, .Net, MDM, Postman, HP Quality Centre.
Confidential - Cincinnati, OH
Sr. Business System Analyst
Responsibilities:
- Gathered Requirements through different elicitation techniques such as Document Analysis, Brainstorming, Interviewing, and conducting JAD sessions with technical teams, and SMEs
- Documented requirements in Business Requirements Document (BRD), Functional Requirements Document (FRD), Non-functional Requirements Document (NFRD) and System Requirements Document (SRD)
- Responsible for the quality of all changes to Empower, the Confidential loan origination system for the Retail branches
- Conducted Gap Analysis of the current state of the system and future state of the system, SWOT analysis to identify the areas of improvement and feasibility analysis of the proposed enhancements
- Created QTP Vbscripts to automate testing. Tested Empower LOS functionality
- Performed Business Rules Analysis by gathering and documenting business rules and made sure all the processes are in place and updated according to external and internal changes
- Created and maintained Narrative Use Cases (Business and System Use Cases) and modeled Use Case, Activity Flow, and Data Flow Diagrams using Microsoft Visio
- Used SQL to compare the database and the periodic reports generated by the application at various levels
- Designed prototype of Orchestration Processes in MS Visio by invoking respective Web Services and APIs to scrub the errors in initial loan origination validation process
- Used HP Systinet for SOA governance, lifecycle management and API management
- Involved with the team to build-up the velocity and performance using Velocity chart and Burn-down chart
- Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners & stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM)
- Prepared test cases and test scenarios identified and established Positive and Negative test cases and coordinated other QA’s in executing the test plans
- Conducted User Acceptance Testing (UAT), beta testing, and involved in code review sessions to ensure that the functionality of the system aligned with the business requirements specified in the BRD
Environment: Hybrid - Waterfall and Agile, J2EE, JavaScript, SQL Queries, Microsoft Office tools, HTML, XML, Crystal Reports, Share point, Rally, MS Visio, web service, REST, UML & Mockup screens, TFS, SSIS, SOAP UI.
Confidential- Lagos, Nigeria
Business System Analyst
Responsibilities:
- Implemented changes and educated team members on regulations of PCI-DSS (Payment Card Industry, Data Security Standard) to become a PCI-DSS compliant vendor
- Collected and documented business processes as well as business rules and performed GAP analysis
- Implemented Data Governance using Excel and Collibra
- Custom extracts, reporting, metrics and dashboarding from Collibra
- Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level
- Created various Business Documents such as BRD and SRS to record Functional, Non-Functional Requirements, and technical requirements
- Worked with Billing Application group for the Customization and Stabilization of Batch Receipts, Revenue Cycle Management and updating Accounts Receivables (AR) reports
- Prepared and maintained the Requirement Traceability Matrix (RTM) for tracking the requirements till the testing phase is complete
- Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and satisfied the business requirements
- Validated the Web Service requests and response payloads and did API documentation using the Postman
Environment: Waterfall, .Net Framework, MS Project, GIT, SQL Queries, SQL Developer, MS Access, XML, MS Office Suite, HTML, AJAX, Java, Python, R, HP QC.
Confidential - Lagos, Nigeria
Jr. Business System Analyst
Responsibilities:
- Facilitated and participated in various Scrum ceremonies such as Sprint planning sessions, Daily Standups, Sprint Reviews, Sprint Retrospective, and backlog grooming sessions.
- Adoption of Agile related techniques such as Planning poker and MoSCoW technique to estimate user story points.
- Calculated the team’s capacity and velocity to have a better visibility of upcoming sprints.
- Created Data Mapping documents and worked with business to write transformation rules.
- Utilized HP-ALM tool and HPQC to generate test cases, scenarios to identify defects and mitigate them.
- Used Postman for examining and validating the external APIs used in the project.
- Created Test plans and developed User manuals for User Acceptance Testing, recorded the test and documented the bugs.
- Performed Functional testing and Smoke testing on a regular basis to make sure that the basic functionalities of the system are working.
- Facilitated Triage calls to identify defects by performing Root Cause analysis and mitigated it along with the development and testing team.
Environment: Waterfall, Java, MS Project, Oracle, GIT, SQL Queries, SQL Developer, XML, MS Office Suite, HTML, Cognos, DataStage, Python, R, HP ALM.
