+ RACHNA AGARWAL

n Cell: 732-***-**** n adcoek@r.postjobfree.com

Work Authorization: US Citizen

EXPERIENCED SENIOR BA/QA

9+ Years of experience in the IT Industry as a BA/QA Analyst, with strong financial domain knowledge (Commercial Banking, Retail Lending, Lockbox Servicing)

Working knowledge of Agile (SCRUM), Kanban and Waterfall

Hands on experience working with Offshore teams

Good experience in eliciting requirements, collaborating across functional teams and transforming business requirements into functional and technical speciations.

Manual and Automated Testing experience with full system development/testing lifecycle (SDLC, STLC).

Excel in designing Manual Test Scripts, Test Plan formulation, Test Cases and analyzing Test Status Reports for manual as well as automated testing to pinpoint defects, track bugs, close open defects and validate functionality.

Highly skilled in effective client interaction for better co-ordination in accordance to deliveries and providing updates through reports like Test Closure, and weekly PMO reports.

Mentored teams to understand requirements and develop Test scenarios

High-level proficiency with ALM 12.0.

Worked with multiple LOS (Loan Origination System) NetOxygen, Empower, Impact

Education

Bachelor’s degree in Commerce from Pune University, IND in 2000

Certificate in International Business from Harper College, IL in 2003

Business Analyst (BA) Training

BA/QA Experience

Client: Codal Duration: Dec 2019 to Present

Location: Homewood

Project Description: Codal is web-designing company. Currently working on testing the agricultural application on Android’s and iOS.

Responsibilities as an QA Engineer:

1. Reviewing app designs in invision and created scenarios and test cases

2. Testing app on android and iOS 12 & 13

3. Retesting all bugs ready for QA

4. Participating in product backlog and sprint planning

5. Key participant in attending all agile ceremonies (Sprint planning, Stand Up, Sprint review, Retrospective)

Environment: Jira, Zephyr, Invision, Slack, Channel, Test Rail, windows 10, Excel, Confluence

Client: CN Railways Duration: June 2018 to Sep 2019

Location: Homewood

Project Description: The CN Positive Train (PTC) Control program is mandatory and implements a security system so that CN is compliant with the Rail Safety Improvement Act of 2008. The program involves the IT, Mechanical and the Signaling & Communications(S&C) groups at CN. Our PTC team is spread between Montreal, India and the US.

Responsibilities as a QA Analyst:

PTC Core/Essential Onboard Functionality Testing and execution

Defect Validation

Responsible to work on testing Onboard Train Management Computer (TMC), Back Office Server (BOS), Computer Aided Dispatch System (CAD) and Train Management Dispatch System (TMIDS), Precision Dispatch System (PDS) for Positive Train Control (PTC) E2E Lab Integration E2E (LIEE) testing and Production support activities.

Testing and Validation of OffShore Products. The breakup of this contribution is summed as below:

Defines test strategies and develop system test plans in accordance with system specifications from which testers would then prepare detailed flow charts, test scenarios and execute tests

Doing Regression testing, API testing and simulators for System and Product integration testing

Coordinates with customer SMEs and programmers to ensure proper implementation of program and system specifications

Reviewing of work products delivered by offshore and reporting the progress of testing to CN management

Environment: HP ALM 12.5, Share point, Wabtec Railway electronic, Phoenix Dispatching System, TMDS, Outlook, Skype, Window 10, CAD, Field SIM, Mobaxterm

Client: Panduit Duration: Nov 2017 to April 2018

Location: Tinley Park, IL

Project Description: Providing a new LMS (Learning Management System) to the Panduit partners with new functionality and enhancement for better performance. As a UAT Tester working with Business to do E2E testing for the new LMS (Cornerstone OnDemand) System. It is a new PRM (Partner Relationship System) for new and existing partners.

Responsibilities as a BA/UAT Tester-

oReviewed Functional Specs to create Scenarios and Test Scripts for new LMS (Cornerstone)

oKey Participant in Production Testing, created all Test Data for Prod Testing with different combinations (including Language, currency and Tier Level)

oKey participant in Configuration and Implementation on new PRM (Zift) to test Business Plan

oCreated and Validated Sales, Purchase reports for the AVI Data

oTested New Module Business Plan with new functionality and enhancement

oMapped data between multiple Systems (Relayware (Zift), Bluevolt & Cornerstone)

oValidated user’s data for Transcripts and Courses in multiple system

oWorked on Creating User Guides and Workflows for New PRM

oContributing to UX Testing for new LMS(Cornerstone)

oKey participant in making Test plan and Test Strategy for Prod Testing

oWorked on identifying requirements for Clarity tool customization for our organization.

oHelped the team in migrating from an older time tracking tool to clarity.

oInvolved with UAT testing and conflict resolution as the organization, adopted clarity as their new time tracking tool.

Environment: Microsoft Office 365(One Note, Excel, Word, Power Point), Share point, Windows 7, Internet Explorer 11.0, Skype 2012, Microsoft Team, LMS( Cornerstone), PRM(Zift Solution), Agile Methodology, Clarity, Plan view

Client: United Airlines Duration: July 2017 to Oct 2017

Location: Chicago, IL

Project Description: General Data Protection Regulation (GDPR) is to help organizations understand the new legal framework in the EU. As a Business Analyst worked with Business Owners and Technology in the areas of Data discovery of Personally Identifiable information (PII), conducted assessment of U.S. privacy program to develop a global framework and to prepare for compliance with the EU GDPR.

Responsibilities as a Business Analyst–

oParticipated in all Business, Technology and Database meetings

oDocumented every business meeting to understand the business process

oAnalyzed existing process to identify gaps and areas of improvement

oMaintained the meeting tracker excel sheet with all the action items

o Followed up on all the action item with multiple businesses and IT owners to gather the artifacts

Environment: Microsoft Office 365(One Note, Excel, Word, Power Point), Share point, Windows 7, Internet Explorer 8.0, Skype 2012

Client: PNC Bank Duration: Aug 2016 to Feb 2017

Location: Downers Grove, IL

Project Description: Senior member of the Lending Transformation team at PNC Bank (Retail and Consumer Lending) tasked with documenting requirements for enhancements made to the newly implemented LOS (Empower - Black Night Financial Services product). Worked closely with Senior Management, Legal, Compliance, and Subject Matter Experts and outside vendors.

Empower is a Web-based POS (Point of Sale) and LOS (Loan Origination System) providing end-to-end loan processing. In Empower, all user roles (Originator, Processor, Underwriter, Closer, Funder, Post Closer and Secondary) can work within one system to validate information.

Responsibilities as a Business Analyst–

oResponsible for gathering and documenting business requirements

oDeveloped Functional and Non-Functional requirement specifications using MS Word, MS Excel and MS Visio that provided appropriate scope of work for the technical team to develop prototype and overall system

oCreated process flows to map Loan Origination Operations (Lead generation to Funding), which identified redundancies in manual processes and backlogs

oAnalyze existing process to identify gaps and areas of improvement

oTracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM)

oReviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications

oParticipated in defect triage sessions with the testing team and business to evaluate priority and severity of defects

Other Responsibilities:

oReviewed Test Plan and Test Strategy; created test cases and executed them for smoke testing

oLogged defects on behalf of business user, reviewed defect reports to track progress.

oCreated dashboard reports in ALM to analyze defect trends.

oAttended status meeting on weekly basis with project team

oCreated multiple scenarios to test the Reg B functionality

oInteracted with Offshore team for triage calls.

Environment:

Empower, ALM 12, UX, KPI, SharePoint, Windows 7, Internet Explorer 8.0, Skype 2012, PSR (Problem Steps Recorder), Snag it, MS Office 2010 (Outlook, Excel, Word, One Note, Visio, and Power Point) and Waterfall methodology

Client: JPMorgan Chase Duration: Oct 2015 to Aug 2016

Location: Chicago, IL

Project Description: The EBDS (Enhanced Benefits Delivery System) enable JPMorgan to intake benefits requests and payments on behalf of their client the USCIS (United States Citizenship and Immigration Services) – a division of the US Department of Homeland Security. USCIS receives over 90,000 applications per day.

Major enhancements are being developed and tested for the EBDS platform to support the USCIS Electronic Immigration System (ELIS). This enhancement is transitioning the agency to a state of the art case management tool and to a paperless adjudication process. The project consists of changes to the data capture on forms (e.g. I-90 immigration form), changes in the way supporting documentation is identified and categorized, changes in the way paper applications are handled, and changes in the way images are captured and transmitted to USCIS.

Responsibilities as Senior Quality Assurance (QA) & Business Analyst (BA)

EBDS System:

oUnderstanding the EBDS system with in-depth knowledge of processes such as receiving an application, sorting, scanning, keying captured data, and then decision making.

oTrain and mentor new hires about the system and processes.

BA Responsibilities:

oCollaborated with product owner and development teams to understand new enhancement

oVerified and updated the BRDs (Business Requirement Documents), FRS (Functional Requirement Specifications), and all internal documents, e.g. MFV & MFI.

oIndexed multiple forms as per business specifications

oRefinement of stories in PBR (Product Backlog Refinement)

oCreation of epics, breakdown and refinement into stories and prioritize and sized

oCreation of epics of stories in PBR (Product, breakdown and refinement into stories and prioritize and sized

oFacilitated and participated in all SCRUM ceremonies – Sprint planning, daily stand-up, Sprint review and retrospective

QA Responsibilities:

oManual automated regression, smoke and functional testing.

oDeveloped positive and negative test scenarios for all immigration forms and test data based on the business requirements.

oDeveloped potential FQT – Functional Quality Test (end-to-end testing) scenarios to send system outputs to USCIS for reviews.

oCreated TESTBED in ALM11.

oExecuted test scripts, logged and tracked defects using ALM 11; reported deviations from specifications.

oKey participant in KANBAN rotations, resolved multiple production issues.

Other Responsibilities:

oPoint of contact for the team to the client.

oKey participant in COPs (Community of Practice) for better process improvements.

Environment:

ALM 11, Confluence, FitNesse (automation tool), JIRA, SharePoint, OnBase, Opex Scanner, Pitney Bowes, TMS, Snagit (snipping tool), XPath, Beyond Compare (a comparison tool), BigDipper (an internal tool), Lync 2013, MS Office 2010 (Outlook, Excel, Word, One Note, Visio, PowerPoint) and Agile methodology.

Client: BMO Harris Bank Duration: Oct 2014 to June 2015

Location: Naperville, IL

Project Description: Senior member of the Quality Assurance Team at BMO Harris Bank (Retail and consumer Lending); tasked with testing the WGS (Wipro Gallagher Solutions) Mortgage Loan Origination application “NetOxygen”.

NetOxygen is a Web-based POS (Point of Sale) and LOS (Loan Origination System) providing end-to-end loan processing. In NetOxygen, all user roles (Originator, Processor, Underwriter, Closer, Funder, Post Closer and Secondary) can work within one system to validate information.

Responsibilities as BA/QA Analyst Senior

NetOxygen Enterprise application:

oExpert level knowledge achieved via vendor training and thoroughly hands-on on the NetOxygen Application to process a loan from origination through funding (a complete life-cycle of mortgage loan).

oPartnered with SMEs to customize workflows of the loan lifecycle from Lead Management, Processing and Underwriting through Post-closing, Funding and Interim Servicing.

BA Responsibilities:

oAnalyzed the workflow and company requirement for the LOS (Net oxygen)

oConverted Visio diagrams into worded document

oUnderstand business requirements from Business team members and modified existing workflows

oEffectively communicated with Offshore team to understand functional requirements

oProvide walk through to QA team members on workflow and client requirement

Test Scenarios:

oReviewed Business Requirement Documents to understand customization needs for BMO’s 275 Products combined with multiple programs, discounts, fees, and pricing options.

oDeveloped positive and negative test scenarios and test data based on the business requirements and Product/ Program specifications.

oDeveloped potential end-to-end test cases for purchases and refinance (Rate term & Cash out) based on exploratory testing.

oPerformed integration testing to check the data/ information flow with interfacing 3rd party application like Credit Verification and Flood Certification agencies.

Other Responsibilities:

oKey Participant in Smoke Test after each code drop.

oInteracted with Offshore team for triage calls.

oEffectively communicate regarding the deployment into test environment with Offshore team

oTested all the defects in every environment (Integration and QA)

oExecuted test scripts, logged and tracked defects using ALM 11; reported deviations from specifications.

oWalkthrough meetings on monthly basis with Development Teams, BA’s, and testing team.

Environment:

NetOxygen Enterprise, ALM 11, SharePoint, Windows 7, Internet Explorer 7.0, Lync 2013, PSR (Problem Steps Recorder), Snipping Tools, MS Office 2010(Outlook, Excel, Word, One Note, Visio, PowerPoint) and Waterfall methodology

Client: JP Morgan Chase Bank Duration: Feb 2013 to Oct 2014

Location: Chicago, IL

Project Description: The project is to migrate MasterCard SDOL (Smart Data Online) to MasterCard SDG2 (Smart Data Generation 2), which is a new application with newer features and functionalities. The primary goal of this migration is to provide customers a new User Interface (UI) and a workflow with SDG2 that include a more flexible accounting process, online billing statements, expense reporting and receipt imaging, and enhanced online training and online payments.

Scope: understanding, end-to-end Test Planning, Test Cases Development and Execution that align to an 80/20 model of end-to-end user scenarios utilizing 20% of the screens that cover 80% of the data.

Responsibilities as QA/UAT Analyst:

HP ALM Explorer 11:

oCreated and maintained test cases. Created a folder structure in test lab and moved the test set. Using Defect module in ALM 11 to log defects, setting the initial priority & severity for product.

oCreated TESTBED for monthly wave for application testing as well as Product Validation Testing (PVT).

oHP ALM 11 Dashboard – Analysis View, Dashboard View

oDeveloped test scripts based on business approved scenarios.

Reports:

oTested the UDE reports - client specific reports.

oTested the Custom Mapper – reports developed by MasterCard

oProvided results to Transition Specialists (TS) team for UDE’s to communicate with their clients so clients could test those UDE’s at their end.

oSent out weekly updates for Custom Mapper reconciliation to product team, vendor etc.

oFacilitated webinars with MasterCard to better understand the Custom Mapper.

Documentation & Other Responsibilities:

oWorking in two different environments – SDOL Dynamic & Live environment, SDG2 static environment.

oCreated UAT implementation plan for Product Validation Testing (PVT) for each release.

oKey participant in production implementation verification and was accountable for validating the data.

Environment: HP Quality Control (QC) Enterprise 10, HP ALM Explorer 11, Sharepoint, Outlook, Microsoft Lync 2010, Snegit 11, Voltage Encryption Manager V5.3, Beyond Compare, Windows7/ XP, Office and Waterfall Methodology

Client: Tireco Inc Duration: Apr 2012 to Feb 2013

Location: LA

Project Description: The project is to migrate Oracle eBusiness Suite (ERP) system from Sun/Oracle Solaris 5.10 to Oracle Linux and eBusiness Suite upgrade from 12.0 to 12.1 along with Oracle database upgrade from 10i to 11g. ERP system is used for the distribution of an extensive and diverse line of quality consumer, commercial, and specialty tires throughout North America. New functionality of Order entry module was implemented and tested

Client: AEGIS Duration: May 2011 to Mar 2012

Location: NJ

Project Description: Data volumes in areas like premiums, claims, transactions, brokers, re-insurers, policies, risks or coverage’s. Rapid pace of change regarding reporting to regulatory bodies consumes invaluable resources. Worked in a team consists of analysts, developers, testers and project manager under the supervision of the insurance business analyst.

Client: Solo Cup,

Location:Chicago, IL Duration: May 2009 to Apr 2011

Project Description: Solo Cup is a leading manufacturing company of single-use food service products. Worked in a team consists of Business Associates, Quality Assurance and developers to do software testing.

Client : Aadya International Inc., IL Duration : April 2007 to Mar 2009

Project Description: Aadya International is a trading company dealing in oil products like Menthol, Peppermint along with scrap metal trades. I worked with the team of Business Associates as an Accounting Associate.

Client: Dovenmuhle Mortgage Inc., Schaumburg, IL Duration: Jan 2004 to Oct 2004

Project Description: DMI services residential, commercial and multifamily mortgage loans on behalf of banking institutions. I worked in a team consists of Accountants, Financial Analysts, and Business Associates.

Technology & TOOLS

Applications:

Empower, Impact, NetOxygen Enterprise, Cornerstone OnDemand (LMS), Relayware/Zift, Tribridge

Requirement Analysis:

JIRA, Sharepoint, Microsoft Office 2010, Happy Fox

Software Testing:

System Testing, Stress Testing, Load Testing, Reliability Testing, Feature Testing, Acceptance Testing, Functionality Testing, Validation, White Clove Testing

Testing Tools:

HP Quality Center 9.2, 10 / Upgraded to ALM 12,HP FitNesse (automation tool), OnBase, Opex Scanner, Pitney Bowes, TMS, Snagit (snipping tool), XPath, Beyond Compare, Big Dipper

Methodologies:

Agile (SCRUM), Kanban and Waterfall

Contact this candidate