Kumar Saurabh Agrawal
Download as DOC, PDF0 likes472 views
This document contains a resume summary for Kumar Saurabh Agrawal seeking a middle to senior level position in software testing. He has over 10 years of experience in manual and automation testing using tools like Selenium, Appium, QTP, and databases like SQL. His experience includes testing in domains like banking, finance, healthcare, and insurance. He is proficient in agile methodologies and has experience leading testing teams and managing projects.
More Related Content
What's hot (20)
Viewers also liked (6)
Similar to Kumar Saurabh Agrawal (20)
Kumar Saurabh Agrawal
- 1. KUMAR SAURABH AGRAWAL E-Mail: saurabh.vnit11@gmail.com Mobile No: +1 937 931 6235 Seeking for middle to senior level position in Software Testing with a leading organization in the IT Sector. Professional Snapshot Key Deliverables: Primary Skills: Mobile Testing on Android and iOS devices, Web based Manual & Automation Testing, AS400 testing, Functional Testing, SQL Testing Tools: Selenium IDE, Selenium Web driver using python in Eclipse, Appium, Genymotion & uiautomator, UFT (Formerly known as Quick Test Professionals QTP), vbscript, Robot Framework (Git HUB) using RIDE, Exposure to SoapUI and Jenkins Test Management Tools: HP ALM , Test Director/Quality Center (QC), JIRA, Zephr, Tarantula Testing Methods: Agile Scrum Methodology, V-model, Waterfall model Domain: Banking and Financial domain, Secured and Unsecured loans, Investment Banking, Healthcare domain, insurance claims, Sales force More than 10.5 years of extensive experience in Software Testing for software application and product development including around 4 years experience in Automation Testing Quick Test Pro (QTP) and close to one year Onsite experience. Working experience in performance testing using Microsoft Visual Studio (VSTS) 2010. Experience in Banking and Finance (BFSI) domain, Home Loans Experience in Healthcare Insurance domain Worked on Retail Banking Products, Web based applications like GEM, Hub Front End (HFE), CRMS, 2G & Compass and Client Server application AS400 IBM I-series. Experience in Investment Banking domain in Research and Strategy Worked on assignments which involved Global Event Management and its integration with Salesforce application. 3+ years hands on experience into Salesforce desktop, Tablet and Mobile testing. Experience into Web Services testing using SOAP UI tool. Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 for CVS Caremark Currently using agile scrum methodology - responsible for end to end deliverables including Requirement Analysis, Sprint Planning Meeting, Test Plan and Review of scripts, Test execution, Attending scrums, defect calls, preparation of different metrics, conducting retrospective meetings, team mentoring etc. Used QTP10.0 to create test data for current GEM project. Used V-model and Waterfall models in couple of projects in HSBC using testing techniques Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Experience based testing etc. Involved in Functional testing like Smoke testing, Sanity testing, SIT, UAT, Regression testing. Mainly worked on Core Banking domain, Loans and Payments side.
- 2. Have got expertise in Database testing Good exposure on AS400 queries and SQL. Exposure to performance testing using Load Runner 9.5 Working experience with GIT extension, Stash server and Jenkins machine. Working experience with Console, Confluence and Sharepoint. Gained considerable international exposure of working in places like London and Birmingham while working on-site testing projects as Onsite Coordinator. Showed expertise in working on Application Life Cycle (ALM) HP Quality Center and Test Director as Test Management Tool. Worked as local QC admin/TD admin. Experience of working closely with Development team and Business Analyst team. A team player with strong communication, analytical and organizational skills. Certifications PMI PMP certified professional. CSTE (Certification of Software Testing and Examination) certified tester securing more than 85% marks. Cleared ISTQB/ISEB Certification securing more than 80% marks. Cleared Oracle Database 11g: SQL Fundamentals1 (Exam Code: 1Z0-051) exam securing 100% marks. Cleared QTP certification exam HP0-M47 HP Functional Testing 11.x Software securing 80% marks. Summary Graph
- 3. Academia Completed B.E. from National Institute Of Technology (Formerly Visvesvaraya Regional College Of Engineering) Nagpur in 2005. Secured 67.5%. Completed Intermediate from U.P. Board in 2000. Secured 78.8%, topped at city level. Completed High School from U.P. Board in 1998. Secured 82.67%, topped at district level. Current Employer Working as Agile QA Lead for ATTRA Inc at Synchrony Financials, New York city, NY, USA, since March 2015 till date Previous Employer Jun14 to Feb15 with Nagarro Software Ind Pvt Ltd, Allentown, USA/Gurgaon, Ind as Lead Nov11 to May14 with GalaxE Solutions (I) Pvt. Ltd. Noida as QA Lead. June10 to Oct11 with RBS Development (I) Pvt. Ltd, Gurgaon as Test Engineer. Aug05 to May10 with HSBC Software Development (I) Pvt. Ltd, Pune as Senior Software Engineer. Roles and Responsibilities Project Level: Carry out detailed requirements analysis, strategy and estimation Ensure tractability between requirements and test cases Prepare and maintain test-ware, conduct reviews of test-wares Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Guide and support a team of test executors Do execution for complex functions Do QA on the testing done by test executors Understanding scope and requirements Produce Test Plan Test Case Writing/Test Script writing
- 4. Customer facing Status Reporting Team Level: Played role of Software Configuration Manager from Dec08 to Aug09 where used to upload all the mandatory previous and current project documents in a central repository called Domdoc with the correct version number as and when requested by the team members. Played role of Internal Quality Assurance from Mar08 to Jun08 in the team where ensured if all the team members are following the correct project guidelines for eg using correct templates and are aware of the overall project updates. Played role of Defect Prevention Champions from Jan07 to Jul07 in the team where consolidated all defects raised by the team members and analyzed the cause for rejected defects and worked on to prevent such rejections in future. Conducting knowledge sharing sessions on weekly basis Conducting One-to-One sessions on monthly basis with the team members and providing them performance rating during Annual appraisal. Business Unit Level: Member of Cultural committee for organizing events like Festival celebration, sports activities etc Part of recruitment panel to conduct interviews on weekdays/weekends. Part of award committee which identify and recognize the resources who perform well for the Organization. Accolades Received Spot Award for performing extremely well in the month Nov09. Received Long Service Award in Aug09 for working consecutive four years with HSBC Software (Ind) Pvt Ltd. Received Certificate Of Recognition on the last project for consistently exceeding expectations. Received Quarterly Award For Going Extra Mile for performing excellent in 2007. Rated as performing constantly above expectation from the management Completed BrainBench Certification for Software Testing. Topped at city level in 12th standard. Topped at the district level in 10th standard. Was the university captain and champion of Chess Won several accolades in Debate, Paper presentation and Essay Writing. Extra Curricular Activities: Won 3rd prize in Paper presentation at national level in IIT Kharagpur on COMPOSITES in 2002. Was involved in organizing numerous activities in VNIT President of the Blood donation committee for one year. Successfully organized 2 donation camps in year 2002-03. Organizing Committee member of Various technical and cultural festivals held at college level, like Odyssey 2002,2003, Hostel -day , Janmashtami- 2001,2002,2003 etc. Personal Details Date of Birth: 01st July 1983 Marital Status: Married Hobbies: Solving puzzles, Playing Chess, Watching Cricket Current Address: House number 1246, Urban state, Sector-21, Gurgaon, Haryana - 122002 Permanent Address: 74, Mehtan Street, Kathera Bazaar, Jwalapur, Haridwar, Uttrakhand 249407
- 5. Visa Status H1B valid till Nov 2017
- 6. ANNEXURE Project Details: SyPi Duration: Feb15 Till Date Client: Synchrony Financial (A GE Company) Testing Methodology: Agile Methodology Role: Agile QA Lead Location: Manhattan, New York Responsibilities: Performing Android automation testing using Selenium python Client and Mentoring a team of manual testers. Working with Eclipse, Selenium IDE, Web driver, Appium, Genymotion & uiautomator Attending Sprint planning meeting, Daily scrum, conducting Defect Triage meetings, conducting applications demos and driving retrospective meetings. Interaction with Business Coordination with Offshore team/managers Lutron Electronics Duration: Jun14 Feb15 Client: Lutron Technology: Keyword Driven Automation Testing Database: SQL Server 2008 Tool: ROBOT Framework (RIDE) Testing Methodology: Agile Scrum Methodology Role: Test Manager Responsibilities: Requirement gathering, Test Estimation, Kick Off meetings Identification of projects risks and mitigation plans Interaction with Business Preparation of Test Plan and review of Test Scenario/Test Scripts Writing complex automation scripts in ROBOT Framework (RIDE) Uploading latest code on Stash server via GIT extension and running code using Jenkins machine Review of automation scripts and check-in to Live environment. Application and Keyword bug reporting Working closely with the Manual team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Vender Transition Claims Migration from Recap to RxClaim Client Billing and Reporting CBR EZ Test project. Duration: Nov11 May14 Client: CVS CareMark A healthcare company Technology: AS400 Testing/ QTP Automation of EZtest web application Database: DB2 Testing Methodology: Agile Scrum Methodology Role: Test Manager Responsibilities: Requirement gathering, Test Estimation, Kick Off meetings Identification of projects risks and mitigation plans
- 7. Interaction with Business Preparation of Test Plan and review of Test Scenario/Test Scripts Test execution SAT, SIT, Regression, Database Testing Adjudication of Manual Claims Testing of Automation process which migrates Claims from Recap to RxClaim system. Testing of existing EZtest claim processing tool Defect reporting Working closely with the Dev team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Testing of Claim Extraction Taps (CETs) Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 as part of testing CETs Global Event Management's integration with Salesforce Duration: June10 Oct11 Client: RBS Bank Technology: Manual/Automation Testing/Performance Testing (Web based Manual/ Automation testing using Hybrid Framework/Performance testing using Visual Studio 2010), Database Testing Database: SQL Server 2008 Testing Methodology: Agile Scrum Methodology Role: Test Lead Description: Gobal Event Management is a Java based front end web application which is used by Royal Bank Of Scotland users to enable them to create Corporate/Institutions/Corporate Group/Institution group roadshows where RBS plays the role of mediator and schedules roadshows/meetings/events for Corporates/Institutions. Through this application, RBS also maintains the logistics to pickup attendees from airport/station or any pickup point, providing them accommodations and drop them till the meeting points. Accounts and Leads are created in Salesforce and its integration with Global Event Management application is tested. Responsibilities: Review of Test Scenario/Test Scripts Testing Saleforce and its integration with Global Event Management application. Creation of test data using QTP 10.0 Test execution SAT, SIT, Database Testing, Regression Performance testing using Microsoft Visual Studio. Defect reporting Interaction with BA team to understand business Working closely with the Dev team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Web Services testing using SOAP UI tool Tablet and Mobile testing for Salesforce application. Poland DBwB (Direct Banking with Branches) LEVEL4 Project Duration: Oct 09 May10 Client: HSBC Poland Technology: Manual/Automation Testing (Web based testing, Database Testing and AS400 testing) Database: DB2 Testing Methodology: V Model Role: Lead Tester Team Size: 6 (Handling a team of 4 resources offshore and 2 resources onshore) Description: The objective of the project is to implement Advance Proposition in Poland in addition with less emphasis on a branch network, and instead focus on selling HSBC products via direct channels. The Advance proposition is part of a wider PFS Customer segment strategy, driven by a global
- 8. PFS initiative. The project would involve implementation of some local enhancements applicable for the Poland site. The following test items are being used: HUB Screen Input / Enquiry / Batch Output. HFE2 Normal Teller functions, Demand Deposit, CRMS, Global Premier Marker AS400 Query/SQL Query File Interrogation (Database Testing). Mercury QTP Automation of HFE2 and Back end Test Scripts where applicable. Mercury Quality Center Test Management & Defect Management Tool. Responsibilities: Carry out detailed requirements analysis and estimation Producing Test Plan Ensure tractability between requirements and test cases Review of Test Scenario/Test Scripts Do execution for complex functions Providing assistance to QTP tester Assisting Manual testers in data staging, SQL etc. Defect reporting and attending defect calls Participate in knowledge management activities Participate in defect prevention activities Do QA on the testing done by test executors Customer facing (Interaction with Business, Overall IT Project Manager) Daily Status Reporting CWD For Compass Duration: Aug 08 Sep 09 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) Database: Oracle Testing Methodology: V Model Role: Lead Tester Team Size: 4 (all offshore) Description: Compass is a front end based application which is used to create loan accounts. System needs customers details like Bank details, Personal details, address, date of birth, employment details, existing loan account details. Based on the details provided by the customer, bureau decides customers eligibility in terms of score. This score will decide how much loan can be disbursed to the customer. If customer and bank both are happy upto this point, system then process customers request through the system, gets it approved via Compressive Banking system, prints necessary documents and create loan account for the system. Cashiering system is used to disburse loan amount to the customer via BACS process, once disbursed, BACS file should get updated. CBS and GL reconciliation to be done after every batch. Cashiering is also used to for different functions like Repayment, Settlement Letter, Loan disbursement, Request Settlement letter. Cashier start and end of the day should be done & Till and Cash balances should match at every end of the day. Responsibilities: Carry out detailed requirements analysis Producing Test Plan Ensure tractability between requirements and test cases Test Scenario Writing/Test Script writing Guide and support a team of test executors Do execution for complex functions Defect reporting and attending defect calls
- 9. Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Do QA on the testing done by test executors Customer facing Status Reporting Intraday MT942 Testing Duration: Aug 07 Jul 08 Client: HSBC United Kingdom Sites: Britain, Netherland, Belgium, Ireland, Spain Technology: Manual Testing (AS400 testing) Database: DB2 Testing Methodology: Waterfall Model Responsibility: Onsite Coordinator & Test Analyst Team Size: 5 (4 offshore and 1 onshore) Description: Intraday MT942 message enables customer to see his/her intraday cash flows (in or out) done on a particular account within the day. These messages can be generated either at a predefined time or after every XX minutes. The structure of the information in MT942 files is based on the SWIFT format. SWIFT (Society for Worldwide Interbank Financial Telecommunication) is an international, electronic communication network used by banks throughout the world for data exchange. The SWIFT format is the universal standardized format that has been developed for this purpose. The file consists of one or more messages. Each message consists of a Message Header, followed by an Interim Transaction Report (MT942), which in turn is followed by a message trailer. Testing of MT940/950 messages after batch. Responsibilities: Carry out detailed requirements analysis, strategy and estimation Producing Test Plan Ensure tractability between requirements and test cases Test Scenario Writing/Test Script writing Guide and support a team of test executors Do execution for complex functions Defect reporting Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Do QA on the testing done by test executors Customer facing Status Reporting HUB Frontend 2.4 Duration: Jun 06 Jul 07 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) /Automation Testing (QTP using Data driven framework) Database: DB2 Testing Methodology: V Model
- 10. Responsibility: Test Analyst Description: HFE 2.4 is the first deliverable on the HFE to R2 Roadmap. HFE 2.4 will migrate existing HFE Teller and CRMS applications to an R2 front-end architecture. This includes migration from the IBM WSBCC application framework to the Group standard Execution Services framework, adoption of the Group Message Framework and integration with Group EAI (Enterprise Application Integration) technology. The CRMS is a sales support system, developed to further the Groups personal banking Wealth Management initiatives. This system is essentially a tool for the Customer Service Representatives (CSRs) and Relationship Managers (RMs) to further the Group's Wealth Management initiatives in the Personal Banking sector. Customer Relationship Management System 3 (CRMS), which is aimed at the Customer Service Representative (CSR) and Personal Financial Services representatives (PFSR), provides for consolidated customer information, individual solutions, contact history, opportunity management functions and sales and marketing data mart to facilitate analysis. Integration of HFE 2.4 with Salesforce is tested. HUB Frontend 2.3 Duration: Aug 05 May 06 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) Database: DB2 Testing Methodology: V Model Responsibility: Test Executor Description: HFE 2.3 is the first deliverable on the HFE to R2 Roadmap. HFE 2.3 will migrate existing HFE Teller and CRM applications to an R2 front-end architecture. This includes migration from the IBM WSBCC application framework to the Group standard Execution Services framework, adoption of the Group Message Framework and integration with Group EAI (Enterprise Application Integration) technology. The main deliverables for HFE are: Customer creation and maintenance of sole and joint relationships. Creation of customer profile in salesforce. Creation and maintenance of address, demographic, family, and contact preferences information for new and existing HUB customers. Demand deposit account opening with optional links to associated services. All teller functions (deposit, withdraw, transfer, cheques, currency handling etc.) Term deposit account opening/maintenance. Payments (demand draft/telegraphic transfer/cashier's order) Loan/OD scoring via an interface to AAPS Back office transactions (inward remittance, salaries, inward clearing etc.) Remote approval of transactions via a Central Approval Repository (CAR). Peer approvals. Printing of pre-filled application forms for payment transactions (demand draft/telegraphic transfer/cashier's order) and Term Deposit accounts. Consolidated customer advices printed on laser printers. Electronic Journal to enquire, reverse and re-print transaction confirmation advices.