We provide IT Staff Augmentation Services!

Qa Analyst Resume Profile

PROFESSIONAL SUMMARY

  • 6 years of IT experience in manual and automated testing of Web, Client-Server, Interactive Voice Response and Mainframe applications
  • Strong experience in Financial Domain like Investment Banking, Commodities and Insurance
  • Hands-on knowledge around features, configuration of Commodities trading, specifically for Openlink Endur.
  • Working knowledge on Trade Life Cycle - Front Office, Middle Office and Back Office applications
  • Experienced in waterfall, agile, scrum, v-model, rational unified process and rapid application development models of software development life cycle SDLC
  • Experienced in Integrating and coordinating testing activities into software development activities.
  • Experienced in performing all test activities such as planning and control, choosing test conditions, designing test cases and checking results, evaluating exit criteria, reporting and test closure.
  • Experienced in software process improvement model CMMI and test process improvement TMMI.
  • Extensive experience as a tester/analyst writing test plans, test scripts, test cases Creation/Execution and creating test data for mainframe, client server and web applications.
  • Experienced in performing various types of testing namely sanity, functional, integration, system, performance, stress, load, security, network, end to end, UAT, retesting and regression testing
  • Experienced using UNIX commands.
  • Working knowledge of multiple databases like Oracle, SQL Server, Sybase and MS Access
  • Experience with CICS, TSO/ISPF, Flat Files, VSAM, Datasets, Batch Job Processing, JCL, and Utility Screens, Setting up Jobs on Mainframes.
  • Strong understanding of the principles of Dataware house using fact tables, dimension tables and star schema and snowflake schema modeling.
  • Exposure to Service Oriented Architecture and experience in working with SOA technologies like SOAP, WSDL, XML Schema and performed web services testing.
  • Experienced in supporting multiple projects simultaneously while maintaining strong quality focus on each and ability to meet deadlines.
  • Excellent analytical skills, documentation skills, communication skills, presentation skills, strong problem solving skills and good team player.

Technical Skills:

  • Testing Tools: QTP 8.0/9.0/9.2, Quality Center 8.0/8.2/9.0/9.2, Load Runner 8.0, WR 7.5
  • Programming Languages: C, C , C , VB, SQL, XML, .Net, JAVA, JavaScript, HTML, COBOL, CSS
  • Operating Systems Windows XP/Vista/2000/NT/98/95, Novel Netware, MS-DOS, UNIX
  • Databases: MS SQL Server2000/2005/2008, Oracle9i/10g/11i, DB2, MS Access, Sybase
  • Networking: TCP/IP, FTP, TELNET, LAN, WAN, HTTP
  • Software: MS Office Adobe Photoshop, Outlook, Publisher, Lotus Notes, MS Project
  • Programming Tools: TSO/ISPF, CICS, IBM DB2 Mainframe Tools, Z/Os

PROJECT EXPERIENCE

Confidential

Sr. QA Analyst Manual/Automation

Responsibilities:

  • Performed database testing using SQL, PL/SQL, AVS and JVS scripts on Oracle and SQL Server
  • Worked with the development team to understand how changes in the software product affect maintenance of test scripts and the QA automated testing environments.
  • Performed testing on Endur and Findur applications like gMotion, pMotion and cMotion with all the required functionality.
  • Create, maintain and execute manual and automated tests on Financial and Commodity Trading and Risk Management product suite.
  • Prepare and execute test plans alongside clients as part of a new software version upgrade testing.
  • Write, maintain and execute automated test scripts using in house automation tool, BLAST and Quick Test Professional.
  • Manage client quality testing visits at our corporate office and conduct quality testing visits to sites of our global clients as necessary.
  • Work closely with test experts and software development staff to ensure that issues are dealt with in a timely and professional manner.
  • Automated manual test cases using QTP 10.0 as part of client testing effort.
  • Perform in-depth failure analysis against thousands of automated test executions related to energy and financial markets.
  • Document, report and follow up on outstanding defects to determine the impact on maintenance releases of code.
  • Lead Offshore team and assisted members of QA staff with various automation related challenges.
  • Coordinate and lead the rollout of automated environment application upgrades.
  • Technologies: QTP 10.0, Citrix 11, Test Partner 6.3, VMware, .Net Framework 3.0, SOA, JAVA,
  • Open JVS, C , Oracle 10g/11g, MSSQL Server 2005, BLAST, Micro Focus, XML

Confidential

UAT QA Tester/Analyst

Responsibilities:

  • Worked with BAs and users to understand, document, and capture requirements for test case authoring.
  • Authored test cases and executed tests for sanity, functional and integration testing.
  • Effectively managed towards target operating model TOM while implementing new platform and movement of assets
  • Performed UAT across multiple work streams and apps to be integrated as part of the MSSB merger for managed accounts and advisory business lines.
  • Analyzed, reviewed and assessed Business requirements, Functional Specifications, Use Cases and Design Specifications for testability.
  • Involved in planning and creating Traceability Metrics, Test Plan, Test Cases, Test Scripts and Defect Reports to ensure the system modification will meet the specified business requirements.
  • Prepared test data, translated user requirements into QA test requirements.
  • Generated and maintained Daily Status reports, Defect Analysis reports, Defect and Test Execution analysis graphs and Test Summary Reports using Quality Center.
  • Technologies : Quality Center 9.0, SQL, MS Office, Oracle 10g/11i, SQL Server 2005/2008, C ,SQL, VB Script, XML, TOAD

Confidential

QA Engineer Manual/Automation

Responsibilities:

  • Derived test requirements, test conditions, test cases, test scripts by analyzing business requirements, system specifications, design specifications, use cases, and functional specifications.
  • Actively involved in various phases of the testing cycle namely, Unit, System, Functional, Regression, Integration, End-To-End, Maintenance and Migration testing.
  • Effectively communicated with Business Users, Developers, Business Analysts, Product Managers, and Systems to gather requirements.
  • Prepared traceability matrix to ensure complete coverage on product intended delivery
  • Responsible to convert the manual test cases into Test Scripts and execute them using QTP
  • Responsible for testing communication between the various interfaces and the actual application.
  • Validated tests by crosschecking data in backend on Oracle and SQL Server using SQL Queries
  • Communicated with offshore team, assigned tasks and tracked progress to completion.
  • Automated complete securitization process using QTP 9.2 for functional and regression testing.
  • Created automation test scripts for all modules of ABS Suite such as Structuring, Pool Selection, Collateral, Forecasting, Pre Close, Database Management, and Distribution using QTP 9.2.
  • Validated data models and executed SQL queries on SQL Server and Oracle for backend testing
  • Prepared automation testing strategy and automation frame work.
  • Developed and maintained QTP automation test scripts by incorporating checkpoints, reusable actions, functions, VBA, Excel, descriptive programming and recovery scenarios.
  • Created, uploaded, validated and maintained Investor reports, Collateral reports, and Pool Selection reports using SQL Server Reporting Services application and verified using SQL queries
  • Performed Column, Row transformation, columns transformed on imported data from the host servicing systems and created File Maps and performed edit/check on collateral import process.
  • Technologies : .Net Framework 2.0/3.0, QC 9.2, QTP 9.2, Oracle 10g/11i, SQL Server 2005/2008, C ,VBA, SQL, VB Script, XML, Silver Light, SOAP, VISIO, Visual Studio 2005

Confidential

QA/QC Analyst Manual/Automation

Responsibilities:

  • Analyzed, reviewed and assessed Business requirements, Functional Specifications, Use Cases and Design Specifications for testability.
  • Involved in planning and creating Traceability Metrics, Test Plan, Test Cases, Test Scripts and Defect Reports to ensure the system modification will meet the specified business requirements.
  • Prepared test data, translated the user requirements and specifications into QA test requirements.
  • Conducted and participated in reviews, open defect meetings with developers, BA's and QA Lead.
  • Participated in JAD sessions Involving stakeholders, project managers, system users, others.
  • Derived test cases using different white box, black box and experienced based techniques.
  • Performed various types of testing such as sanity, functional, Integration, system, re-testing, performance, E2E, and regression on all phases of Accumulator and its associated interfaces.
  • Validated XML extract to ensure data integrity when loaded into New Business Accelerator.
  • Executed SQL Queries against Oracle, DB2 and Seibel CRM for back end testing.
  • Performed database testing using TOAD by executing SQL and PL/SQL scripts.
  • Generated and maintained Daily Status reports, Defect Analysis and Test Summary Reports.
  • Performed Post Implementation Regression tests to ensure integrity of applications.
  • Generated and maintained Daily Status reports, Defect Analysis reports, Defect and Test Execution analysis graphs and Test Summary Reports.
  • Documented all the change management records, ongoing upgrades, fixes and approvals.
  • Trained and Coordinated with offshore team, assigned tasks and tracked progress.
  • Technologies: Quality Center 9.2, Quick Test Pro9.2, MS-Office, SQL, VB Script, UNIX, XML, TOAD,
  • ORACLE 9i, SQL Server, JAVA, COBOL, SOA, XML Spy, VISIO, .Net, SOAP, UDDI

Confidential

QA Tester Manual/Automation

Responsibilities:

  • Involved in planning and creation of Test Cases, Test Scripts and Test objectives to ensure that the system modification will meet the specified business requirements.
  • Performed manual and automation testing on various applications namely Proxy Edge, Investor Mailbox, Post Edge, Notice and Access, Proxy Vote, Proxy Vote Rebranding, Proxy Disclosure, CPP, VTT, Straight Thru and Wizard.
  • Conducted Functionality Regression testing during various phases of the application using QTP
  • Responsible for coordinating with offshore team through scoping, planning and execution of QA
  • Responsible for creating,executing and updating the QTP test scripts and documenting results.
  • Performed database testing using SQL scripts on Oracle and executed UNIX commands.
  • Used Built in functions of VBScript extensively and Test Batch Runner in QTP for Batch Testing
  • Coordinated testing of IVR application for proxy voting.
  • Used Mainframe Query Management facility for efficient back end testing on DB2.
  • Extensively used TSO/ISPF utilities in Mainframes and validated VSAM and FLAT files.
  • Setup Test Data for Mainframes applications, created jobs such as P,R,S,A and Z
  • Created, maintained and executed QTP scripts from different projects on a daily basis to ensure
  • system modifications made during Maintenance testing did not introduce any new defects
  • Interacted with the team on a regular basis and attended meetings on a daily for status updates.
  • Provided training to technology associates in QA methodologies, testing techniques, test planning, installation and use of automated testing tools, defect tracking software and best practices.
  • Technologies: Quality Center 8.2, Quick Test Pro 9.0, TSO/ISPF, MS-Office, SQL, VB Script, UNIX,
  • XML, ORACLE, JAVA, VSAM, JCL, CICS, DB2, TOAD, COBOL.

Confidential

Intern QA/Data Analyst

Responsibilities:

  • Have been involved in most of the stages of project development including requirement analysis, design, enhancement, implementation and documentation with complete knowledge of SDLC.
  • Gained thorough knowledge on Oracle 11i, Oracle 10g and Performance Tuning.
  • Gained strong understanding of the principles of Data Warehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Performed database testing using TOAD by executing SQL and PL/SQL scripts.
  • Actively involved in various phases of the testing cycle such as System, Functional, Regression, Integration, and End-To-End Testing.
  • Participated in data analysis, data modeling, database design and PL/SQL programming.
  • Technologies: SDLC, Oracle 11i, Erwin, Oracle 10g, Oracle 9i, SQL Server 2000, TOAD, XML

Confidential

Graduate Assistant and Lab Assistant

Hire Now