Email ID : ad20md@r.postjobfree.com Phone Number : 626-***-****

Objective

A well skilled functional (SSM 5.0 Certified) Business Analyst with 6+ years of experience, in eliciting, analyzing and documenting requirements for business processes with excellence in Scrum/Agile/Dev-Ops environment.

Experience Summary

Proficient in all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) achieving milestone using Agile and Waterfall models

7 years of experience in testing Microsoft dot net and Java applications, analysis, design, testing and production support

Experience in domains - Insurance and supply chain and Finance/Banking domain .

4 plus years of experience in testing salesforce and ncino applications.

Have thorough knowledge of both salesforce lightning and cloud environments.

Handled multiple salesforce, nCino applications UAT’s

knowledge of salesforce admin - workflows, fields, reports, dashboards and other events.

Understanding of business analysis entailing requirements gathering / analysis, communicating between teams, deployments, etc.

Proficient in Smoke, System, Regression and Acceptance testing of mobile, standalone, client/server and web applications.

Well versed with System testing, back end testing, Functional testing, Regression testing and User Acceptance testing.

Worked extensively on JIRA, MTM, TFS,VSTS, HPALM for bug reporting

● Extensively white box testing experience (writing Stored Procedures, Triggers, Functions, Views and SQL queries)

Hands on experience with SQL Server 2000, 2005 & 2008

Experience in Testing Cross Browser Applications

Developed overall Test Strategies and Test Plans for Manual Testing

Writing Test Cases and Test Scripts, executing the Test Scripts and analysing the error logs

Developing Test Case Repository containing pool of regression test cases of the business-critical components for building the automated regression test suites

Highly efficient in Complex, Agile, Onshore-Offshore project environments

Ensured that test scripts, plans and acceptance/signoff criteria are agreed with the end user representatives.

Strong aptitude towards learning new technologies/sharing ideas and Ability to work under tight schedule and strong analytical and problem-solving skills.

Assisted Developers in debugging efforts by conducting root cause analysis

Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel. Clear Understanding of Business Rules and Ability to work as a part of a team.

Participating in Scrum meetings to analyse the bottlenecks

API testing

Interacting with clients for requirement gathering, finalisation of business/functional specifications; generating and compiling reports based on findings; with causes and solutions to systems issues

Suggesting appropriate as well as technology-based solutions for enhancing functional efficiency of the organisation and achieving business excellence

An effective leader with proven abilities in working with cross cultural teams during the project phase; guiding team members and enabling knowledge sharing among the team

A quick learner and the ability to apply the knowledge gained effectively.

Consistent feedback from managers from various geographies regarding excellent communication skills and ability to learn quicklyExperience in API and WebServices testing (e.g. Postman, SOAP UI) and understanding of data formats like JSON and XML

Experience designing and executing API and Integration tests Experience with Azure Test Plans

Experience in testing Data Mapping documents from source to target databases.

Experience in ETL Testing and backend nCino testing.

Scrum as an asset; strong knowledge of all the concepts: tasks, backlog tracking, burn-down metrics, velocity, user stories. Preparation of FSD, Test scenarios, Test cases, Test Schedule and Traceability Matrix

Successfully done all kind of testing process like Unit Testing, Whitebox Testing, Black Box Testing, Sanity and Adhoc Testing System Integration Testing (SIT),User Acceptance Testing (UAT) plan to guide a select group of key end-users in testing the user interface and functionality of the application.

Professional Experience

Client: Wells Fargo Role: (UAT Lead)

Duration: 15 May 2023 – 30 December 2023

Project: Description: nCino Loan Orgination and Servicing System (Mortgage and Commercial Lending) is built upon the salesforce platform. Bank operating system tracks the loan through its entire life cycle while ensuring regulatory compliance, reducing the risk, increasing transparency and efficiency there by creating new revenue opportunities. This project is an Internet application which is mainly used by bank representative for initiating a loan and servicing.

Roles and Responsibilities:

Assisted with documentation of configuration specifications, validated integration data mappings, and led testing defect resolution efforts to ensure a successful application deployment across 8 Salesforce development environments and Production release.

Successfully organized and facilitated sprint planning and retrospectives, improving daily stand-ups by 10%

Collaborated on Salesforce releases and deployments, including Apex, Visualforce, and Lightning Components, resulting in an increase of user adoption rate by 5%

Hosting the daily triage calls for analysis of the bugs/Defects raised to keep to Prioritise the items for better project execution.

Responsible for making and sending of daily reports to the complete team including LOB. ● Making daily assignments to the team based on the priority of the items.

Testing various commercial Lending modules- End to end Loan working flow, workflows, Routes, sub routes, credit memo, etc.

Creating the weekly status report (burn down charts)

Monitoring VSTS daily for priority check for the items

Functional and regression testing of QA environment- creating and execution of test cases

Reviewing the test cases of the team

Responsible for the nCino and salesforce release testing -Creating Test plans, making assignments and executing

Member of the scrum team – involved in Sprint Review, Planning, Retrospective and Refinement.

Participated and represented business in all SCRUM ceremonies

Facilitated Daily Scrum Meetings and Monthly Reviews meetings. Conducted sprint retrospective and

followed up on action items for continuous improvement

Successfully guided three development teams through transition from waterfall to Agile development.

Coached team members on Agile processes and facilitated planning meetings and retrospectives.

Removed impediments and protected team members from interruptions and distractions to maximize

productivity. Encouraged and implemented process improvements. Created team-building opportunities.

Worked closely with Product Owners, coordinating product backlog grooming and story estimation.

Strong hands-on ability to configure DIFFERENT MODULES OF nCino.

Support end to end user testing for the nCino platform to ensure high quality releases and associated business adoption. Mostly works in Credit Descioning and Underwriting & Descioning, Shared Capabilities, Opportunity/Pre-underwriting, Data exporter, Booking & Funding, and Flood Attestation.

Support end to end testing of ncino workflow in IHUB and Loan IQ integration with nCino. Writing SOQL Query for getting the results that all data from IHUB, Loan IQ and CLSI databases are landed in nCino according to Data Mapping Worksheets.

Environment: JIRA, Confluence,nCino, LOAN IQ, IHB Database, CLSI Database, Agile/Scrum SDLC model, SQL Server Management Studio, HP ALM, SharePoint

Client: AgFirst Farm Credit Bank (Tata Consultancy Services) Duration: December 2021 – Present

Role: Business/Quality Analyst

1.Project Description: ClickDimensions is one of the leading marketing platforms for Microsoft Dynamics. The purpose of this project is to replace ClickDimensions with HubSpot. ClickDimensions provides solutions for integration with on-premises and Cloud based Microsoft Dynamics. Whereas HubSpot does not provide any solution for integration with on-premises Microsoft Dynamics. This project will help seamlessly integrate CRM and HubSpot by allowing instant data sync of key entities between the two applications.

Roles and Responsibilities:

Understanding of CRM Microsoft Dynamics 365 application and HubSpot CRM. Fair Knowledge of their Customization, Configuration and workflow. Attending daily scrum meeting periodically to better understand the upcoming and ongoing project stories. Providing Status report to the stakeholders on Weekly/Daily basis/any agreed frequency

Working closely with Product Owner and other Business Analysts within the program coordinating the deliverables to ensure integrity of the end-to-end solution of CRM application.

Providing Status report to the stakeholders on Weekly/Daily basis/any agreed frequency

Serves as the primary liaison between functional departments and the IT Department.

Documented Test Strategy, Test Plan, Test cases.

Handled Defect Triage meeting and maintain defect Tracking system ALM.

Perform Dev Testing, System Integration Testing and User acceptance testing.

Using POSTMAN tool to test Integration -Services in nCino

Used APIM for API testing: REST API checks Perform API testing for ensuring the quality, functionality, and performance of web services and applications.

Working with onshore customer and different stake holders in getting clarification addressed. Attending daily scrum meeting periodically to better understand on the upcoming and ongoing project stories

Providing Status report to the stakeholders on Weekly/Daily basis/any agreed frequency

Wrote different Use Cases and developed Data Mapping Documents for different CRM Associations.

Replacing ClickDimensions with custom solution using HubSpot for the following functionality: Worked on processes/functions enhanced by this solution. For example: “Customer Onboarding” or “Customer Credit Assessment”.]

Replacing ClickDimensions with custom solution using HubSpot for the following functionality: Support knowledge sharing of data sync of key entities like Lead, Contact, Business or Opportunity between CRM and HubSpot

List of major user stories or use cases.

CRM to HubSpot – Create/Update Contact and Lead from Dynamics CRM to Contact in HubSpot

CRM to trigger email from HubSpot – A CRM User will initiate the process by clicking the 'Send New Application' ribbon button from a CRM Lead, Contact, Business or Opportunity. The end result is an email being sent to the Customer/Prospect/Lead from HubSpot.

HubSpot to CRM – Create/Update Contact from HubSpot to Contact and Lead in Dynamics CRM

Training team members on better understanding of CRM Microsoft Dynamics 365 application product with different user roles. Strong communication expertise and interpersonal skills.

2. Project: Description: nCino is built upon the salesforce platform. Bank operating system tracks the loan through its entire life cycle while ensuring regulatory compliance, reducing the risk, increasing transparency and efficiency there by creating new revenue opportunities. This project is an Internet application which is mainly used by bank representatives for initiating a loan and servicing.

Roles and Responsibilities:

Understanding Current and Target Loan origination system and workflow based on Salesforce platform.

Testing of nCino and salesforce based Agworx lending project Environment, with full onsite vision and client demos. Testing of monthly released billing statements for consumer compliance and non – consumer compliance customers also lead a team for monthly releases of the Empower, collateral, credit Pro, Narrative web, Mobile app of the Empower all of these are banking domain applications. Reporting bugs/ issues in VSTS Training team members on better understanding of nCino product with different user roles in Salesforce platform.

Strong hands-on ability to configure DIFFERENT MODULES OF nCino.

Working closely with Product Owner and other Business Analysts within the program to ensure integrity of the end-to-end solution of Salesforce application

Worked on Commercial lending, Wealth Management, Retail Loan System, Credit analysis, Compliance, Commercial Pricing and profitability, Agricultural Lending, Commercial Estate Loan Regulatory area in Banking sector.

Experience working in salesforce domain for configuring nCino – LOAN ORIGINATION SYSTEMS application.

Worked on Credit Analysis, Compliance, Marketing Collateral, Commercial Real Estate Analysis, PRICING AND PROFITABILITY.

Experience in making data mapping documents for different Data Integration for nCino applications.

Experience in testing ACBS and DNA data in nCino Salesforce application from different databases.

Creation of test cases from user stories.

Executing the test cases.

Involved in the various testing phases from the test planning to all the way through systems, integration and regression before handing it over to the UAT group.

Involved in regression testing, risk based testing, smoke and re testing.

Verifying bug fixes.

Logging issues/bugs in HPALM.

Running test cases and recording in HPALM

Lead with UAT team for preparing data and docs for UAT

Environment: Agile/Scrum SDLC model, JIRA and SharePoint, SQL Server Management Studio

Client: Bank of Oklahoma Tulsa Ok. Role: Sr. Quality Analyst Duration: Nov 2020- December 2021

Project: Description: nCino is built upon the salesforce platform. Bank operating system tracks the loan through its entire life cycle while ensuring regulatory compliance, reducing the risk, increasing transparency and efficiency there by creating new revenue opportunities. This project is an Internet application which is mainly used by bank representatives for initiating a loan and servicing.

Roles and Responsibilities:

Understanding Current and Target Loan origination system and workflow based on Salesforce platform.

Highly efficient in Complex, Agile, Onshore-Offshore project environment

Working closely with Product Owner and other Business Analysts within the program to ensure integrity of the end-to-end solution of Salesforce application.

and initiation to deployment and support as well as Software Test Life Cycle (STLC) beginning from review to acceptance test

Distribution of assignments in the team.

Testing various nCino modules- workflows, Routes, sub routes, credit memo, etc.

Monitoring VSTS daily for priority check for the items.

Functional and regression testing of QA environment- creating and execution of test cases.

Data validation – from empower and Agworx.

Creation of defect report

Creation of assessment document after every release.

Testing the salesforce, ncino application build in salesforce lightning cloud environment. Creating data in salesforce - making list views, fields, checking access, giving and granting required access (access control), dashboards and reports handling, profile controlling .

Involved in scoping and distributing work assignments.

Member of Stand up meetings

Validating the match reports of the various Labs .

Creating the monthly Release QA assessment document

Reviewing the test cases of the team .

Creating the weekly status report (burn down charts) Completely involved end to end till the project got live successfully

Working with onshore customers and different stake holders in getting clarification addressed.

Attending daily scrum meeting periodically to better understand the upcoming and ongoing project stories.

Experience working in salesforce domain for testing nCino – LOAN ORIGINATION SYSTEMS application.

Solid experience in writing Epics, Features and User stories for different modules of Loans Workflow from origination to Booked stage in nCino application.

Gathered information from LOB’s how different loans will proceed through the process of nCino.

Gathered requirements from LOBs about different users who can help in booking a loan from Prospecting stage to Inactive stage of Loan.

Mostly worked on different components like SBA Loan, SBA Lending, Role Hierarchy, Review Process, Review Approval, Renewals,/Modifications etc.

Experience in performing and coordinating Functional Black box, Integration and End to End testing and supporting User Acceptance Testing

Conducted weekly meetings to validate and verify the testing process which include Unit testing to Integration testing

Experience on Writing SQL queries to extract data from various source tables to perform database testing

Understanding Business Requirements documents and participating in requirement discussions

Preparation of Test scenarios, Test cases, Test Schedule and Traceability Matrix test artifacts for functional and non-functional tests integration testing and User Acceptance Testing with business users for project implementations

Experience and heavily involved in UAT Process.

Environment: JIRA, Confluence, Agile/Scrum SDLC model, SQL Server Management Studio, HP ALM, Postman

Client: Park National Bank

Duration: Oct 2018– Aug 2020

Role: Business Analyst

Project: Banking Platform That Delivers Intelligence and Efficiency, Automated Spreading, Pricing and Profitability, Customer Onboarding and Deposit Account Opening.

Responsibilities:

Working closely with Product Owner and other Business Analysts within the program to ensure integrity of the end-to-end solution of nCino a Salesforce application.

Conducted JAD sessions with Subject Matter Experts (SME’s) to obtain domain level information, interviewing and asking detailed questions and carefully recording the requirements in a format that can be reviewed an understood by both business and technical team.

Prepared high-level logical data models and Business Required Document (BRD)and supporting document containing essential business elements, detailed definition, and description of the relationship between the actors.

Assist Product Owner with Backlog grooming, Epic, User Story and task development and prioritization

Applying good judgment in balancing and advocating for the use of agile delivery concepts and business analysis tools and techniques

Liaising between developers and project stakeholders, fostering quality communication between engineering disciplines

Involved in GAP analysis both at the time of requirement gathering and later after development with the Testing team to identify areas and possible scenarios that might have been overlooked.

Facilitated collection of functional requirements from system users and preparation of functional specification documents that provided appropriate scope of work for technical team to develop prototype and overall system.

Identify and implement process improvement ideas. Work with management to support upstream and downstream business groups and optimize the end-to-end process

Initiate process and procedure changes to improve and sustain data quality at improved levels (continuous improvement)

Environment: Agile / SDLC model, Jira, Rally, SQL Server Management Studio

Client: ABC Healthcare Inc. Richmond VA (InMNC LLC Plano)

Duration: Jan 2016 – Oct 2018

Role: Business Analyst

Project: Develop an online Rx refill solution with a Web Portal for patients, Doctors, insurance payor. System will provide various management and marketing reports and feed data to the Decision Support System (DSS) and its Data Warehouse.

Responsibilities:

Worked with the managers, management and report requestors to gather requirements.

Involved in requirements gathering sessions with Architects to understand requirements in terms of business change.

Conducted JAD sessions for the documents. Wrote SQL queries for extracting and validating data.

Gathered requirements, analyzed them and created formal Business Requirement Document (BRD) and Functional Requirement Document (FRD).

Used Agile methodology for development. Created Business Process Workflow Diagrams with Stakeholders throughout the System Development Life Cycle (SDLC).

Used Analysis Model for gathering requirements by facilitating Use Case workshops and sessions.

Coordinated with the developer, on day-to-day basis, during the development process.

Wrote and maintained project requirements, facilitated meetings, built business and system flows, managed defects and wrote use cases.

Created UI Mockups screen and maintained Requirement Traceability Matrix (RTM) using MS Visio based on UML.

Conducted weekly meetings to validate and verify the testing process which include Unit testing to Integration testing.

Environment: Agile / SDLC model, Jira, Rally, SQL Server Management Studio, HP ALM

Technical Skills

Operating System

Windows 7, Windows 10, Mac OS (Mojave)

General Tools and Utilities

MS Office (Excel, Word, Outlook, PowerPoint), SQL Server Management Studio, HP ALM, POSTMAN

Management and Reporting Tools

JIRA, Confluence, HP ALM, RALLY, SharePoint, MS Project, Visio, Kanban board, Informatica Tool, postman

Business Documentation Skills

Business Requirements, Use Case Specifications, Functional and Non-Functional Requirements, System Requirement Specifications, UML Diagrams, Traceability Matrix, Project Estimate, Master Test Plan Review (Integration, System and Acceptance), and Visio. Test data Management, KPI Metrices, Master Data management, Data Mapping

Methodologies

Joint Application Development (JAD) or JRD Unified Modeling Language (UML), Systems Development Life Cycle (SDLC). Waterfall Model, Agile Model, Scrum, CI/CD.

Scripting/Programming language

HTML, CSS, REST SOAP, API, JSON, SQL, ETL, Informatica Cloud, POSTMAN

Education

SAFe Agile 5.0 Scrum Master Certification May 2020

nCino 2.01 Certification

Salesforce Admin Certification (In Progress)

Associate of Science (Computer Science) NWACC Arkansas Aug 2012

Master’s (Mathematics) from Ranchi University, Ranchi, India July 2001 - July 2003

Bachelors (Mathematics) from Ranchi University Ranchi, India Aug 1996 - Aug 2003

Contact this candidate