Rahul Agarwal Mobile: +1-425-***-****

Email: acz1vv@r.postjobfree.com

WA: H1B Location: Charlotte

PROFESSIONAL SUMMARY

* ***** ** **/** Testing experience with Bank of America & Microsoft

Extensive experience in Quality Analysis, Business Analysis, Database testing and Big data testing. Strong experience in eliciting, analyzing, and documenting testing critical artifacts.

Critical and analytical thinker with business acumen and technical aptitude

Excellent written, communication, interpersonal, multi-task skills, proven QA Team Lead/Test Lead and team player with an analytical bent to problem solving and delivering under high stress environment.

Extensive testing experience and application/technology knowledge in several areas including Web, Database testing, Client/Server and mainframes.

Extensive experience in Systems testing, Functional testing, Integration testing, Manual testing, Automated testing, Big Data testing, User Acceptance testing and Regression testing.

Specialized in development of Project Estimations, Forecasting, Test Strategy, Test Plans, Test Cases, Test Data and Defects Management.

Expertise in leading multiple projects as well as leading onshore/offshore team resources.

Provide comprehensive software QA solutions using various testing tools and methodologies.

Successfully implemented multiple releases into Production environment with extensive and effective testing of multiple projects.

Extensive experience in working with 3rd party Vendors from resource procurement and management perspective.

Expertise in the process of testing and participation in both Waterfall and Agile environments in the Software Development Life Cycle.

Strong knowledge and working experience on FS domain- Home Loans, Insurance and Tax.

Solid understanding of the Software Development Life Cycle (SDLC) and STLC and Agile scrum methodology.

Expert in banking & technology domain. Have created flow diagram for more than 150 application in Mortgage technology. Created multiple decks for domain improvement for the resources.

Experience with Integration, stress, performance, scalability, and load testing along with BDD. Key Performance Indicator(KPI Test)

Web application testing in major web browsers; knowledge of web protocols HTTP, HTTPS, etc.

In-depth knowledge of XML/XSD structure, browsers: cookies, security & settings, browsers debugging tools like Fiddler, Firebug, HTTPWatch, etc.

Good Experience as a trainer. Corporate Training provided on QTP, SQL, testing process, Finance domain.

Certifications

Certification Name

Professional Society

Certification Date

NCFM Derivatives Module

National Stock Exchange

2011

Object Oriented Programming C++

IBM

2012

HP Quick Test Professional 9.2

HP

2011

IBM - Rational Functional Tester

IBM

2011

ASDA- ACN-ATA Application Tester

Massachusetts Institute of Technology

2012

ASDA- ACN-ATA Applied Test Designer

Massachusetts Institute of Technology

2013

Banking Generalist Certification

Accenture

2015

Mortgaged based practitioner

Accenture

2015

TOSCA

Tricentis

2017

PMP

PMI

2017

Technical Skills

Operating System : DOS, OS400, Windows 2000, 2003 and 2007, XP Professional, Unix

Database : DB2, SQL Server, Hadoop, Tera Data

Software Product : AS 400,Pega, Java, Unix, Hive, Impala

Testing Tools : QC, QTP, QzTest, TOSCA, Version one

Packages : Microsoft Office(Word, Excel, Power-Point)

Programming Language : VBA, HTML, SQL, Java script, Perl,Python

Modeling Tools : UML, MS Visio

Automation Tools : Cucumber, Selenium

Professional experience

ACCENTURE (29th Aug 2008– Present)

BANK OF AMERICA, Charlotte NC

Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. The company operates globally – 160,000 associates’ worldwide serving clients in more than 150 countries and operations to meet the needs of these global customers. In U.S. it operates in 22 states in addition to District of Columbia. Bank of America's global headquarter is located in Charlotte NC.

Project Title- Testing and Quality Measurement and Services

Role- Big Data QA Test Lead

Period- Nov 2014 - Present

Managed the testing resources (team size: 11) in onshore and offshore locations.

Lead the preparation and execution of Test plans for multiple projects/releases.

Performed extensive testing on big data Cloudera platform.

Worked on Autosys,Unix,hadoop, Hive, Impala and shell scripting for big data testing. Leading the team for the same.

Performing and leading the testing activity on data lineage.

Performed and lead the testing effort on multi data base testing like SQL server, Tera data and hadoop.

Coordinated and led the reporting and tracking of defects in the application thru Application Lifecycle Management tool and tracking the defect till closure.

Strong experience in defect root cause analysis and present defect metric to the client for improvement.

Expertise in Agile process actively supports team for the process improvement .

Leading the test data preparation activities using various tools for testing purpose.

Participated actively in the meetings & tele-conferences periodically with Users, Business Analyst team, Development team and QA team members.

Automating testing activities on hadoop by shell scripting and through TOSCA tool.

Actively participates in process improvement.

Environment :

HP Quality Center Windows 7, MS office, SharePoint, Hadoop, Hive and Unix, Impala, Tera data, Autosys, SQL server, TOAD, Version one, Wiki, Web based application. MS VISIO and TOSCA automation tool.

Microsoft, Redmond WA

Microsoft is a multinational technology company headquartered in Redmond, Washington, that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems, Microsoft Office suite, and Internet Explorer and Edge web browsers. Its flagship hardware products are the Xbox video game consoles and the Microsoft Surface tablet lineup. As of 2016, it is the world's largest software maker by revenue, and one of the world's most valuable companies

Project Title- MS/Nokia Integration Project-SAP Test Lead

Role- Software Developer Engineer Test

Period- Sept 2014 – Nov 2014

Responsible for planning, coordinating and facilitating testing activities in a multi system truly global environment

Coordination’s between Team spanning across geographies- United States, Finland, India & Japan

Closely work with various test teams to plan and manage environments, test data and test readiness.

Monitor functional, integration, system, regression test execution on daily basis across all test teams.

Gather test status from various teams, create and publish test status reports to project management.

Ensure test teams are adhering to defined bug logging process and ensure bug lifecycle is followed thru.

Able to Implement new processes and templates in support of the different types of testing and reporting.

Collaborate with Development, Analyst and Business teams to triage bugs and follow up thru closure.

Assist in the preparation of Test Plan and Test Approach documents.

Create detailed test execution plan with schedule, assign testers and track the progress

Environment :

Windows 7, MS office, SharePoint, Visual Studio, IE9, Microsoft SQL Server 2008 R2, Microsoft Test Manager, HP ALM

Project Title- ECIT Volume Licensing

Role- Software Developer Engineer Test

Period- Sept 2013 – Aug 2014

Individual Contributor as Performance Test Lead

Ran the performance tests to run the automated data warehouse, included C# coding

Led the automation process of test scripts successfully in Visual Studio

Coordinated and led the reporting and tracking of defects in the application thru Visual Studio 2010 and tracking the defect till closure.

Managed the team’s estimation and forecasting activities as well as time entry process.

Test data preparation using various tools for testing purpose by mocking up production data

Participated actively in the meetings & tele-conferences periodically with Users, Business Analyst team, Development team and offshore QA team members.

Perform functional and Regression analysis.

Coordinate work with other developers and designers on the team which may be cross-location. This may involve off-hour conference calls. Identifying the technical cause and potential impact of errors and implement coding or configuration changes.

Closely working with Line of Business and Development team to embed the newly identified requirements into the system.

Mentor and guide offshore team and provide clarification for the queries.

Create and drive proficiency tests for the application and domain knowledge.

Create and report the release metrics to the client with details analysis of the defects logged during the release.

Suggest the development team for the missed requirements or enhancements.

Track the proficiency for the entire project.

Active member of Innovation team in the project.

Environment :

Windows 7, MS office, SharePoint, Visual Studio, IE9, Microsoft SQL Server 2008 R2, Microsoft Test Manager,

Microsoft, Hyderabad, India

Project Title- Microsoft OEM OSP

Role- Offshore Test Lead

Period- Nov 2010 – Aug 2013

OEM OS Project involved migration of the OEM applications from MSops to the newly designed OEM Security and Provisioning.

Perform UAT testing and end to end testing for Microsoft OEM Opertaions(MOO) applications.

Create UAT test plan.

Test data creation. Working closely with the Test Data management team.

Run automation scripts to create test data.

Closely working with Line of Business and Development team to embed the identified requirements into the system.

Test and Supported LOB team to perform real time testing for long workings hours which includes weekends which was well appreciated by the client.

Tracking Test scenarios provided by LOB to support letter pdf testing.

Implement continuous process improvement plans for the team.

Conducting domain sessions on Mortgage which includes Origination, Fulfillment and Servicing.

Creating documentation and flow diagrams for the applications.

Create monthly reports for the client.

Hosting Bug Scrub Meetings and triaging all the defects, tracking the Defects to Closure.

Using TFS and Microsoft Test Manager for maintaining test deliverables. Microsoft SQL Server 2008 R2 to verify successful job flows and data transfer in the application

Identify the right candidates (i.e) test cases from regression test suite for automation to leverage the manual effort.

Environment :

Windows Vista, MS office, SharePoint, Microsoft SQL Server 2008 R2, Team Foundation Server, Microsoft Test Manager, Excel Macro, Microsoft UI Based applications

Project Title- Microsoft OVRP (OEM Volume Royalty Program)

Period- April 2008-Oct 2010

Role- Quality Analyst:

Prepare execution plan and test data for assigned work.

Perform functional and Regression analysis.

Tracking Test scenarios/Scripting status on the monthly initiatives.

Perform smoke and Adhoc testing for new builds.

Collaborate with business analysts to clarify application requirements for the initiative.

Follow procedures and standards set by the project

Implement continuous process improvement plans for the team.

Perform analysis to improve the process within the team.

Creating macros tools to help work faster.

Conducting domain sessions on Loan Origination and Fulfillment for the new joiners.

Peer review of test cases and ensuring mapping to the requirement specification of the RTM.

Provided Test summary report to management with a complete statistics of testing status.

Education

Bachelor of Technology in Computer Science & Engineering from Calcutta Institute of Technology,WBUT, Kolkata with 82%.(Bachelor in Computer Science US equivalent) 2008 Batch

Achievements

Multiple counts of appreciation certificates from clients in different capacities

Passed prestigious certificates in Banking and Finance, NCFM Derivative module from Indian Institute of Banking and Finance in first attempt.

Won Stellar & ACE award at Accenture.

Recently completed PMP Certification

Strengths

Well-organized, quick learner self-motivated team player and has experience in all phases of the Systems Life Cycle. Strong ability to work individually as well as lead the team and manage the tasks based on business requirements.

Professional References:

James Sammons, Bank of America Director of QA Ph-704-***-**** Email: acz1vv@r.postjobfree.com

Vishal Zadoo, Accenture Senior Manager Ph -704-***-**** Email: acz1vv@r.postjobfree.com

Rajesh Sahoo, Accenture Delivery Manager Ph- 980-***-**** Email: acz1vv@r.postjobfree.com

Contact this candidate