SUMMARY

• 8+ years of experience as a certified Business Analyst and a certified Scrum Master wif proven capability of working in different Software development lifecycle (SDLC) methodologies like Waterfall and Agile (SAFe, Scrum) wif deep understanding in various domains such as Banking and Logistics.
• Possess incredible work ethics coupled wif excellent communication, written and interpersonal skills describing a committed team player, stepping up to lead the team.
• Expertise in Business System Analysis, Data Analysis, Software Design, Development, and Implementation of business applications wif 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 andJoint Requirement Planning (JRP)
• Business analysis experience in conducting Impact analysis for change requests and conflicting stakeholder requirements, GAP analysisfor 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)
• Proficient in writing SQL queries for testing and data validation.
• 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 inProgram 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 wif 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 INVESTCriteria, 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 MSSQL 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 APIDocumentation.
• 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 wif SOA architecture and Micro-Service architecture.
• Good experience in Relational Database Management System including performing complex SQL queries formapping of various system applications.
• Sound knowledge and understanding of methodologies such as TDD for code testing, BDD for behavior-oriented functionality testing and ATDDfor 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 wif 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 (SAFe, Scrum,), Waterfall

Project management tools: JIRA, Azure DevOps, Rally

BI Tools: Tableau, Power BI, Crystal Report, XSL-FO, MS Visual Studio

Modeling Tools: MS Visio, Axure

ETL Tools: SSIS, Informatica Power Center

Documentation Tools: SharePoint, Swagger, Confluence

Web Technologies: XML, JSON, HTML, SOAP, RESTful

Testing tools: HP ALM, Soap UI, Postman, Selenium

PROFESSIONAL EXPERIENCE

Confidential, Costa Mesa, CA

Sr. Business Systems Analyst

Responsibilities:

• Collaborate across different teams (product owner, Users, Scrum Masters, Solution Architects, Designers, Vendors, Infrastructure, Security Teams) for gathering requirements, defining scope, identifying product processors, interface requirements for designing different module UI, saving Millions of dollars for rewrite, testing, time, etc.
• Worked on migration project from legacy to Cloud system - acted as liaison between business and IT to ensure all application and tool migration needs are met
• Skilled at reviewing test cases making sure they are in accordance wif requirements and assist the overall testing process by activities such asChange and Defect Managementand conductingUser Acceptance Testing UAT.
• Worked to promote transparency across teams and stakeholders by preparing Project Documentation like Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Release Notes, minutes of meetings (MOM) utilizing MS office.
• Worked wif Infrastructure team for applications migration into AWS cloud for flexible, cost-effective, reliable, scalable, high-performance, and secured applications.
• Completed requirements for monitoring, automating Amazon Web Services and deploying content cloud platform on Amazon Web Services using EC2, S3 and EBS.
• Strong working knowledge of AWS, GCP and Azure cloud platforms and multi could connectivity.
• Used SQL Queries in Oracle to pull out data from the databases for the data validation and routine report generation.
• Detailed XML and SQL analysis to identify data discrepancies between the newly designed application and legacy data.
• Developed data model,SQLQueries,SQLQuery tuning process and Schemas.
• Wrote SQL queries to verify the data in database and compare it to frontend
• Wrote SQLStored Procedures, Functions, and Packages to meet the business requirements
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results wif the actual report against the Data mart (SQL server).
• Proficient in API architectures, autantication mechanisms:HTTP, OAuth, XML, JSON, REST and SoapAPIs.
• TestedREST APIsusingPostmanand documented them usingSwagger.
• Assisted QA Teams inAPI, UI, SmokeTest, Integration Test, User Acceptance Test, Regression Tests, Load and Performance Tests usingPostmanand documentation usingSwaggertools.
• Participated in definingthe RESTarchitecture to expose open API to client
• I was responsible for gathering and analyzing requirements, creating test plans, test cases and leading the UI and API testing effort.
• Participated and contributed actively in UI to API mapping meetings and communicated concerns to the product owners and business analysts.
• Gathered Business Requirements by using techniques such as document analysis, system analysis, one toone interview wif Business Users, Stakeholders, and Subject Matter Experts (SMEs).
• Experienced in working and conducting backlog grooming session wif Product Owner to break down the features and assisted in developing user stories and Acceptance Criteria while making sure that user stories are following INVEST criteria and acceptance criteria is written in Gherkin format.
• Actively involved and cooperated in the roadmap sessions wif the Scrum Team to identify the PI
• Objectives and planning to map the dependency to deliver the project milestones after each P.I
• Performed various analysis such as Gap Analysis, Impact Analysis, and Root Cause Analysis to validate the feasibility of Decision and helped the development team to understand the AS-IS and TO-BE business workflow to provide quality MVP’s.
• Arranged Triage calls to work on defects and prioritize the defects wif their mitigation plans wif the team.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) wif the help of QA teams.
• Proficiency in writing complex SQL queries to extract and validate the data from the Eligible Members database.
• Working extensively wif the QA team to write and execute Test Plans, Test Scenarios, and Test Cases.
• Conducted User Acceptance Testing (UAT) and documented bugs and updated Requirements
• Traceability Matrix (RTM).
• Tracking project dependencies outside of the project team’s control and escalating issues as necessary
• Facilitating cross-group and cross-functional communications for issues resolution and updates.
• Delivered Minimal Viable Product (MVP) as per the deadlines and pushed into Product backlog Increments
• (PBI’s) got appreciation wif senior management on timely delivered sprints.
• Conducted User Acceptance Testing (UAT) in Sprint Review to confirm user stories are moved into
• Incremental Backlog.
• Jira monitored KPIs to assess the team performance every sprint
• Attended the Triage calls to identify the defects to effectively log them and prioritize as per requirement.

Environment: SAFe- (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services, MS 365

Confidential, Boston, MA

Sr. Business Systems Analyst

Responsibilities:

• Worked to promote transparency across teams and stakeholders by preparing Project Documentation like Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Release Notes, minutes of meetings (MOM) utilizing MS office.
• Proficient in writing SQL queries for testing and data validation.
• Created multiple reports using SQL to support business operations such as lender's queue report for displaying real time data of active loans and their states, report for displaying total number of loans as per classifications such as small business, standard and specialty
• Used SQL Queries in Oracle to pull out data from the databases for the data validation and routine report generation.
• Detailed XML and SQL analysis to identify data discrepancies between the newly designed application and legacy data.
• Developed data model,SQLQueries,SQLQuery tuning process and Schemas.
• Wrote SQL queries to verify the data in database and compare it to frontend
• Wrote SQLStored Procedures, Functions, and Packages to meet the business requirements
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results wif the actual report against the Data mart (SQL server).
• Proficient in API architectures, autantication mechanisms:HTTP, OAuth, XML, JSON, REST and Soap APIs.
• TestedREST APIsusingPostmanand documented them usingSwagger.
• Assisted QA Teams inAPI, UI, Smoke Test, Integration Test, User Acceptance Test, Regression Tests, Load and Performance Tests usingPostmanand documentation usingSwaggertools.
• Participated in definingthe RESTarchitecture to communicate wif third party applications such asCreditAPIs, FHA Electronic Appraisal Delivery and other APIs using HTTP methodsusingCRUD operations- GET, POST, PUT and DELETE. The system includes Collateral Management, Compliance Management and Credit checking.
• I was responsible for gathering and analyzing requirements, creating test plans, test cases and leading the UI and API testing effort.
• Participated and contributed actively in UI to API mapping meetings and communicated concerns to the product owners and business analysts.
• Gathered Business Requirements by using techniques such as document analysis, system analysis, one to one interview wif Business Users, Stakeholders, and Subject Matter Experts (SMEs).
• Experienced in working and conducting backlog grooming session wif Product Owner to break down the features and assisted in developing user stories and Acceptance Criteria while making sure that user stories are following INVEST criteria and acceptance criteria is written in Gherkin format.
• Actively involved and cooperated in the roadmap sessions wif the Scrum Team to identify the PI Objectives and Planning to map the dependency to deliver the project milestones after each P.I
• Performed various analysis such as Gap Analysis, Impact Analysis, and Root Cause Analysis to validate the feasibility of Decision and helped the development team to understand the AS-IS and TO-BE business workflow to provide quality MVP’s.
• Arranged Triage calls to work on defects and prioritize the defects wif their mitigation plans wif the team.
• Designed Test Plans and Test Cases for User Acceptance testing(UAT) wif the help of QA teams.
• Proficiency in writing complex SQL queries to extract and validate the data from the Eligible Members database.
• Working extensively wif the QA team to write and execute Test Plans, Test Scenarios, and Test Cases.
• Conducted User Acceptance Testing (UAT) and documented bugs and updated Requirements Traceability Matrix (RTM).
• Tracking project dependencies outside of the project team’s control and escalating issues as necessary
• Facilitating cross-group and cross-functional communications for issues resolution and updates.
• Delivered Minimal Viable Product (MVP) as per the deadlines and pushed into Product backlog Increments (PBI’s) got appreciation wif senior management on timely delivered sprints.
• Conducted User Acceptance Testing (UAT) in Sprint Review to confirm user stories are moved into Incremental Backlog.
• Jiramonitored KPIs to assess the team's performance every sprint.
• Attended the Triage calls to identify the defects to effectively log them and prioritize as per requirement.
• Actively work wif and help the scrum team to make sure that TILA, OFAC, RESPA, FINCEN,TRID regulations,, and HMDA regulations are implemented in loan application and the development
• Actively work wif 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

Environment: SAFe- (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Azure DevOps, SharePoint, Tableau, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services.

Confidential, Silicon Valley, CA

Sr. Business Analyst

Responsibilities:

• Gathered Requirements through different elicitation techniques such as Document Analysis, Brainstorming, Interviewing, and conducting JAD sessions wif 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)
• 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
• 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
• Hands on experience in debugging generaldatabase SQL code, dynamic SQL, stored-procedures, user-defined functions, SharePoint application
• Extensive backend testing using SQL queries, generating the reports to ensure the data integrity and validate the business rules
• Involved in creating UML Activity, Sequence, Dataflow, and Use Cases 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
• Involved wif 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 wif the process owners & stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM)
• My responsibilities included conducting hands-on manual and automation testing for UI and REST APIs.
• Conducted manual testing of the REST APIs and ensured that core was functioning according to spec.
• Used POSTMAN for smoke and sanity testing of REST APIs.
• 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 wif the business requirements specified in the BRD ensuring Quality Assurance
• Jiramonitored KPIs to assess the team's performance every sprint.
• Attended the Triage calls to identify the defects to effectively log them and prioritize as per requirement.
• Created and developed Canned reports and adhoc reports to deliver progress reports to the product owner so that performance evaluations regarding meeting business requirements could be managed effectively.
• Collaborate wif project teams (both on and offshore) and motivate team members to accomplish team and organizational goals.

Confidential, Charlotte, NC

Senior Business Analyst

Responsibilities:

• Collected and documented business processes as well as business rules and performed GAP analysis
• Translated the business needs into system requirements, communicating wif the business on a non-technical level, and wif the System Analyst on a more technical level
• Involved in Data entry, query and reports request screens and tuned the SQL queries.
• Created various Business Documents such as BRD and SRS to record Functional, Non-Functional Requirements, and Technical Requirements
• Understand and analyzed SQL Data query SQL data to investigate issues or extract
• Involved in Data Validation using SQL queries.
• Prepared and maintained Requirement Traceability Matrix (RTM) for tracking requirements till testing phase is completed.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and satisfied the business requirements
• Worked wif the testers in writing test cases, test scenarios and performed Functional and Regression testing
• Validated the Web Service requests and response payloads and did API documentation using the Postman
• Assisted the Product owner in defining the requirements of the acceptance criteria.
• Assisted in creating the DOR (Definition of Ready) and DOD (Definition of Done) so that user stories met stakeholder needs.

Environment: Agile- Scrum Framework- (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services.

Confidential, Cleveland, OH

Business System Analyst

Responsibilities:

• Developed use cases, workflow, screen mock-ups, and functional and business requirements.
• Interfaced wif business users extensively to prepare and update requirements.
• Performed various SQL operations in order to retrieve data, add database, and add tables
• Performed data analysis and the mapping of the attributes between the source system and the target system.
• Ensured all artifacts complied wif corporate SDLC Policies and guidelines.
• Validated technical designs created by IT developers against functional specification.
• Responsible for coordination and maintenance of the project change request catalogue.
• Created key metrics such as capacity and velocity to track team’s performance.
• Facilitated backlog grooming sessions for refining user stories and ensured stakeholder needs were met.
• Checked wif team members for impediments in Parking Lot sessions and resolved them to ensure team cadence.
• Worked on refining the product backlog and the sprint backlog so that value for features was added in each sprint.
• Monitored and tracked the progress of the team and shared the results wif the management.

Environment: SAFe- (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services, MS 365

Confidential, Old Bridge, NJ

Business System Analyst

Responsibilities:

• Created various Business Documents such as BRD and SRS to record Functional, Non-Functional Requirements, and Technical Requirements.
• Performed data analysis and the mapping of the attributes between the source system and the target system.
• Ensured all artifacts complied wif corporate SDLC Policies and guidelines.
• Responsible for coordination and maintenance of the project change request catalogue.
• Collected and documented business processes as well as business rules and performed GAP analysis
• Comprehensive knowledge of web services related concepts such as XML, JSON, WSDL, HTML, AJAX, SOA, API, SOAP and RESTful Web Services
• Sound knowledge in performing ETL process to migrate data from OLTP Database to OLAP Data warehouse and Data Marts which involved Data Mapping based on the Transformation Rules

Environment: Agile-Scrum (HTML/CSS, Javascript, Java, Oracle), MS Visual Studio, MS Project, MS Visio, Office Suite, Jira, Confluence, PowerBI, Web Services, API, Microservices, AJAX, SOAP UI, RESTful Services.