Professional Summary

• Analytical and solution-oriented technical professional with 7 years of experience in software testing, coupled with an extensive Manual, Automated and ETL testing.
• Partner closely with business analysts, project management, and our application support team to design and test new applications, automation, and enhance the overall reliability and performance of the software test infrastructure.
• Analyze, validate, and test software development projects by writing test plans and test cases, performing ad hoc, manual, and automated testing.
• Designed and build intelligent systems that can explore a wide range of integration testing scenarios.
• 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 ALM, Quality Center, JIRA, TFS,QTP, 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 , Sharepoint.
• 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.
• Experience in working as onsite coordinator for 30 team in an onsite/offshore model

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

Title: QA Lead DB Testing

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

Description: CONFIDENTIALis an Enterprise used by CONFIDENTIALfor capturing, tracking and maintaining various risk sharing instruments including: Selling and servicing representations and warrants reps and warrants , as well as mortgage insurance information and credit enhancement details. The CONFIDENTIAL provides a flexible platform, which can scale to be an industry utility, to capture, track and maintain information about all risk sharing vehicles, offering transparency to all parties.

Responsibilities:

• Developed Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data and Traceability Matrix
• Created Test strategy and Test Plan based on requirements
• Develop and execute system test cases for agile methodology to ensure product meets functional and design specifications
• Involved in giving demo to customer.
• Involved in managing Retrospective meeting.
• 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
• 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 conducting UAT testing
• 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.
• Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
• Report bugs, bug isolation, verify fixed bugs and issue resolution.
• 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

Title: L1 Support Autosys Testing and Support

Environment: Star Track, Autosys, EEM, Windows, Unix

• Description: Autosys project deals with providing support to customer and finding root cause for issues. Supported on different version of Autosys 4.5,11,11.3,11.3.5 performed
• Experience in working with Autosys Admin team to resolve issues in Autosys by checking Event Processer logs.
• Strong team player with excellent inter-personal, written and oral communication skills
• Ability to adopt in demanding, fast-paced environments requiring highly adaptive, flexible and resourceful technical management skills
• Ability to meet deadlines with no compromise on the quality of the work products.
• Schedule Autosys jobs through inserting, deleting and updating jobs in various production instances.

CONFIDENTIAL

Title: QA Lead Db testing

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

Description: CONFIDENTIAL is an Enterprise used by Freddie Mac for capturing, tracking and maintaining various risk sharing instruments including: Selling and servicing representations and warrants reps and warrants , as well as mortgage insurance information and credit enhancement details. The LCI provides a flexible platform, which can scale to be an industry utility, to capture, track and maintain information about all risk sharing vehicles, offering transparency to all parties.

Responsibilities:

• Developed Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data and Traceability Matrix
• Created Test strategy and Test Plan based on requirements
• Develop and execute system test cases for agile methodology to ensure product meets functional and design specifications
• Ensured that each software enhancement deployed achieves its specific purpose/benefit and does not degrade any other feature or performance.
• Tracks and communicates key QA project metrics
• 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

Title: QA Lead

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

Description: Primary aim of the Project was moving existing data from mainframe system to Oracle Retail Merchandising System RMS . We were focused on two major modules RMS and POS. RMS provides flexibility to optimize retailers operations through the effective management and seamless execution of processes such as purchasing, distribution, and financial close all on an agile, highly scalable platform and POS is used for retail transaction.

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
• Gained understanding of the RMS Retail Merchandising System .
• Assisted the development team in creating, implementing and maintaining test documents
• 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.
• Executed Automated Test Scripts using Quick Test Pro.
• Involved in verification of data flow from mainframe to Oracle.
• Performed SQL and PL/SQL queries on Netezza .
• Involved in verifying mapping of 2 different databases.
• 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.
• Mentored/Trained less experienced QA team members in test procedures and processes
• Performed GUI, Functional, Regression, Smoke and User Acceptance testing UAT of Application, its interfaces and Client-Server Utilities.

CONFIDENTIAL Title: 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

Projects worked in Wipro:

• Fifth Third Bank: Account to Account Transfer A2A , Early Resolution ER2 , Open Consumer, BSS FNA , EDOCS
• Goldman Sachs: FINAPPS
• UBS: Data Management System DMG
• Credit Suisse: RDG SSI

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 Wipro 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.
• Experienced in Autosys job scheduling
• Active participant in Bug-Review meetings with software developers, QA engineers, and managers.
• Acted as team player in events and project
• Involved in supporting UAT testing during onsite hours.