SUMMARY

• Analytical and solution - oriented technical professional with 7 plus years of experience in software testing, coupled with an extensive Manual, Automated and Database .
• Expertise in all phases of SDLC - Requirement analysis, Gap analysis, Use case decomposition, Test planning, Test estimation, Test strategy, Test Design, Test Execution, Defect Management, Test Reports and Metrics Analysis.
• Experienced in testing & verifying Business functionality, Database and Security Standards for different client/server applications in the areas of Finance, Retail Banking, Investment Banking, Loans, Insurance System and Retail.
• Expertise in SDLC Models such as ( RUP, Waterfall, V-shaped, Structured Evolutionary Prototype, RAD, Incremental, Spiral, Agile Methodologies )
• Good exposure in performing verification and validation activities, including preparation of test scripts, step-by-step execution of test scripts and consolidation and reporting bugs.
• Expert in validating interfaces majorly involved in checking how communication is flowing from one application to other.
• Worked extensively on testing tools like QTP, Quality Center, JIRA, TFS, Test Director also having familiarity with Rational Tools like Rational Clear Quest.
• Extensive experience in GUI, System Integration (SIT), Functional, Integration, Security Testing, Interface testing, Regression, Unit, Performance and User Acceptance Testing (UAT) and basic knowledge on mainframe testing.
• Involved in Autosys jobs testing.
• Involved in web services testing using SOAPUI tool and exposure to xml testing.
• Extensive knowledge of using MS Word, MS Excel, MS Visio, MS Access .
• Involved in writing complex SQL queries and testing PL/SQL procedures to extract data from various source tables
• Involved in cross browser testing, Log Analysis and Interim release testing.
• Excellent Problem Solving, Analytical, Communication and Interpersonal skills and a proven Team player with a good track record.
• Well versed in conducting Joint Application Development (JAD) sessions for interacting with the stake holders, development teams and other cross functional business unit members to help identify, analyze, and resolve issues.
• Extensive experience in coordinating testing effort, responsible for testing deliverables, status reporting to the management, and issue escalations.
• Understanding of Object Oriented Programming, UML concepts, design patterns, and different Web Technologies.

TECHNICAL SKILLS

OS: Windows 98/2000/XP, Windows 7,MS DOS, Linux, Windows

Testing Tools: Mercury Test Director, HP Quality Center, HP Quick Test Professional, Rational Functional Tester

Databases: DB2, Oracle 9i/11g, MS SQL Server, MS-Access 5.0

Language: SQL, PL-SQL, VBScript

Applications: AQT, Microsoft Office 2005/2007, MS Access (queries, forms, reports), MS Excel VBA, Informatica, Putty, Toad

Domain: Retail Banking, Consumer Banking, Insurance, Loans and Investment Banking

Office Tools: MS- Word, Excel, PowerPoint, Visio, Adobe Acrobat

Other Tools: DFA and Codec Tool ( For matrix preparation)

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

QA Lead

Environment: HP QC 11.5, Rapid Sql 8.1.1, MS Office, Putty, Database Testing, Soap UI 3.6.1

Responsibilities:

• Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
• Developed Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data and Traceability Matrix
• Develop and execute system test cases for agile methodology to ensure product meets functional and design specifications
• Involved in conducting daily stand up meetings and responsible for tracking efforts for each individual.
• Gained understanding of the Loan Cycle and process of calculating sunset dates for loan maturity.
• Involved in allocating and reviewing task along with execution activities.
• Worked on Requirement Management, Test Planning, Test execution and Defect Tracking using Quality Center for Database Testing..
• Created complex sql queries for data validation. Performed SQL and PL/SQL queries to access data from database & other sources
• Analyze data using SQL, Excel, UNIX, SOAP UI and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Loaded the data loads from source files to the target tables using Autosys jobs.
• Involved in running Autosys job in Putty and analyzing logs to verify if we are getting correct result.
• Involved in mapping validation for two different databases and found many critical defects
• Validated different kind of reports and written complex queries to validate data with database.
• Involved in UAT and production support.
• Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
• Report bugs, bug isolation, verify fixed bugs and issue resolution.
• Provide feedback to design reviews and test tool selections/improvements.
• Collaborate with Project Managers, business partners, and developers to coordinate project schedules and timelines.
• Examine sample record sets for consistency, data corruption and over all data quality.

Confidential, Houston, TX

QA Lead

Environment: HP QC 10, Oracle 9I/SQL Server, MS Office, JAVA, Mainframe

Responsibilities:

• Created Test strategy and Test Plan based on requirements.
• Developed Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data and Traceability Matrix
• Gained knowledge of RMS and POS.
• Involved in allocating and reviewing task along with execution activities.
• Worked on Requirement Management, Test Planning, Test execution and Defect Tracking using Quality Center for Manual Testing.
• Involved in Security Roles and System Options Testing of the Application for data encryption and prevention of unauthorized Access.
• Created and Executed Automated Test Scripts for GUI and Functional Testing using Quick Test Pro..
• Involved in verification of data flow from mainframe to Oracle.
• Performed SQL and PL/SQL queries to access data from database & other sources
• Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
• Involved in Interface testing from Orders to Store, Store to Warehouse etc
• Involved in daily bug report meeting and task planning activities.
• Performed GUI, Functional, Regression, Smoke, Boundary. Nonfunctional and User Acceptance testing (UAT) of Application, its interfaces and Client-Server Utilities.

Confidential, Minneapolis, MN

QA Lead

Environment: HP ALM 11.0, Oracle 9I/SQL Server, DB2 V10, MS Office, JAVA, VISIO

Responsibilities:

• Created Test plan for Agile/Scrum model based on business Requirement Document and System Requirement Specification.
• Developed Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix
• Gained understanding of the Asset and Liability management system.
• Involved in testing Desktop software used by corporate advisor to perform calculations.
• Involved in test coordination between Offshore and Onsite team
• Involved in allocating and reviewing task.
• Experienced in Autosys job scheduling to load the data.
• Coordinated end to end testing with clients and functional teams
• Worked on Requirement Management, Test Planning, Test execution and Defect Tracking using Quality Center for Manual Testing.
• Involved in Security Testing of the Application for data encryption and prevention of unauthorized Access.
• Created and Executed Automated Test Scripts for GUI and Functional Testing using Quick Test Pro..
• Worked in UNIX for data integrity and data Validation.
• Performed SQL and PL/SQL queries to access data from database & other sources
• Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
• Performed GUI, Functional, Regression, Smoke, Boundary. Non-functional and User Acceptance testing(UAT) of Asset Management Application, its interfaces and Client-Server Utilities

Confidential

Sr. QA Tester

Environment: Quality Center 10, TFS, Toad, Oracle 9I/SQL Server, DB2,AQT,SOAP UI TOOL,MS Office, JAVA, Flex, Unix, Bloomberg, Mainframe,.NET

Responsibilities:

• Gathered business requirements, supporting transaction processing for Retail Banking Application like Account opening, Funds transfer, payments processing for financial project which revolves around online account opening process and transactions
• Design & Review of KT Document, Traceability matrix, Test Cases, Test Plan & Test Reports
• Involved in Web Testing, Automation testing, Mainframe testing, ETL testing and SOA testing
• Involved in end to end testing along with defect management cycle.
• Involved in Manual and Automation testing for Retail banking application testing which further involves testing Online banking application activities like account opening, funds transfer, documents delivery for transaction etc.
• Involved in testing Loan Applications like Mortgage, Student checking and verified e-documents delivery for different stages of Loan.
• Involved in Investment banking applications testing using MS Office Suite, Database and Automation tool QTP
• Involved in Manual and Automation testing for Investment banking application testing which further involves creating standing settlement Instructions, Trade settlement at front end etc.
• Project Management Activities, Metric Analysis and Reports Generation
• Involved in mainframe testing on TSYS server to validate data.
• Coordinating with Onsite team, BA and Client and Allocating task to team
• Involved in planning/estimation of all phases of testing activities.
• Ensuring completion of all daily deliverable of the team
• Involved in Oracle Financial application testing.
• Written complex sql queries and tested stored procedures.
• Got award from client and Confidential for successful delivery along with late hours support
• Involved in Ad hoc testing, Smoke testing, sanity testing, security testing, Interface testing, Regression Testing, UAT testing. Web services testing and defect tracking.
• Involved in testing on remote system.
• Involved in providing cross training sessions for team mates
• Experienced in Autosys job scheduling
• Active participant in Bug-Review meetingswith software developers,QA engineers, managers and suggested enhancements to the existing application from business perspectives, provided solutions to existing bugs.
• Acted as team player in events and project
• Involved in supporting UAT testing during onsite hours.