Senior Qa Analyst/ Business Analyst Resume
New York, NY
PROFFESSIONAL SUMMARY
- Senior Software QA Analyst having Confidential Computer Science and 10 yrs of experience in IT projects for Investment Banking, Educational Services, Confidential Management,
- Worked on wide range of projects involving product development and customized system development.
- Expertise in all aspects of testing including: Functional, Black Box, Regression, Integration and Usability Testing, Unit Testing, UAT, API testing, Database Testing, Backend Testing, Smoke testing.
- Extensive experience in developing high quality automated and manual test scripts and comprehensive testing.
- Expert skills in automated testing using Silk Test and knowledge of QuickTest Professional, Rational Robot, Silk Performer, Win Runner, Load Runner, SOAPSonar.
- Worked on web based and client server applications. Experience in Web Service & XML Testing using SOAPUI
- Developed, implemented and managed software QA processes using defect lifecycle management tools like Test Track, Clarify ClearQuality, Microsoft Office SharePoint and Dimensions and knowledge of Test Director, Rational ClearQuest, Quality Center.
- Advanced knowledge and experience in complex data validation and manipulation using SQL queries.
- Experience in supporting UAT and production issue resolution.
- Excellent analytical, problem solving and communication skills. Also, managed teams of testers onshore and offshore.
- Business analysis skills in business requirements documentation, user training and acting as face of business to developers.
- SME knowledge in Front to Back ( Confidential ) processing on bank loans for funds and vendor product - Confidential Office (WSO).
- Thorough knowledge and experience with Confidential Online Learning Suite products.
SKILLS
Automated Test Tool: SILK Test 6.3,6.5,7.0, 8.0,9.0, QuickTest Professional 6.5,8.2, Silk Performer 7, Rational Robot, Winrunner 7.0, Load Runner 7.8
Defect Tracking Tool: Clarify ClearQuality 8, Test Director 8.0, Serena Dimensions, Microsoft Office SharePoint, Test Track Pro 7.5.2, Rational ClearQuest, Quality Center 9.0
Web Service Testing Tool: SoapUI 1.7 /1.7 Pro, SOAPSonar 2.7.1
Manual Testing: Writing and Executing Test Cases & Scripts, Managing Defect Reports
Databases & Tools: Aqua Data Studio, TOAD (Oracle) 8.6.1.0, PL/SQL, SQL Server 2005, SQL SERVER 7.0/2000, Query Analyzer, Oracle 8.0,9,10g, MS ACCESS, Sybase ASE11/12/15-TDS5.5
XML Editor: XML Marker, XML CookTop, XMLSpy
Programming languages: JAVA 2.0, JavaScript, C, C++, VB6.0, VBScript, SQL, Unix Shell Script
Web Technologies: JSP, Java Servlet, Java Script, HTML, DHTML
Application Servers: Apache Tomcat, Weblogic, JBOSS, JRUN
Operating Systems: Windows 95/98/2000/XP, Windows NT, Unix
Security Tool: PGP Desktop 9.5
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
Senior QA Analyst/ Business Analyst
Responsibilities:
- Created test cases to accurately and completely reflect the business requirements and real life scenarios.
- The test cases intended to test Confidential loan Confidential functionality including - Buy/Sell, Swap, Paydown, Drawdown, Cash Confidential (fees, interest), term loan and revolver facility, pricing, security and account set up, SRI, SDO and PIK.
- Created expected results for test cases by simulating the feeder processing logic and GLS rules in excel sheet for end to end real life business scenarios.
- Manually tested end to end functionality in the QA environment.
- Led implementation of test driven development process.
- Created test scenarios and test data for developers to help them implement the intended logic.
- Unit tested developed functionality and helped developers debug the code.
- Prepared test plans for smoke testing and carried out smoke testing in development environment.
- Created and executed SQL queries to verify that bank loan Confidential from WSO are posted to the GLS database tables as per the specification.
- Verified the trade messages generated by WSO in the in-house application.
- As a lead tester, developed the Test Automation Framework using SilkTest for data driven automation testing.
- Developed more than 1200 automated test cases (.t files) using SilkTest.
- Automation involved trade capture through WSO GUI (VB 6.0) and backend database validation in GLS system (Sybase database and SQL Server database)
- Created common global silk test functions for WSO GUI trade capture and database validation.
- Created Data driven silk test scripts using excel sheet which includes trade data and calculations for payment, settlement, P&L as per the general ledger system rules.
- Mentored offshore QA team and supervised test implementation and automation.
- Provided SilkTest and WSO training to QA tester.
- Staged QA environment to run regression using Silk Test.
- Ran regression to verify weekly release and verified the test results in .res generated by Silk Test
- Documented issues found during testing in development environment using Test Track Pro.
- Retested issues fixed by developers.
- Created test scenarios for UAT and supported testing in UAT.
- Created XML test scripts for API testing to test an API logic for processing trade Confidential from WSO to GLS.
- Executed XML scripts in Unix, this script calls Silk Test Script(.t) to post trades in WSO GUI and validates trade posting in GLS Sybase database.
- Used Unix commands/shell scripts for testing and to setup testing environment on Unix servers.
- Participated in the improving QA processes and procedures.
- Maintained test cases and automated test scripts to respond to changing requirements leveraging change control tools - SVN and Confidential .
- Prepared release notes and deployment instructions for production support.
- Subject Matter Expert (SME) in Confidential trade processing of bank loan trades through WSO and in house General Ledger System(GLS).
- Gathered and finalized business requirements with Trade Operations and Accounting teams.
- Documented the logic for Feeder interface between WSO and GLS to process the bank loan trades and related business events and calculate payments, settlement information, P&L as well as generate accounting entries and balances.
- Effectively transitioned business requirements to development team and ensured that the business logic is implemented as per the specifications.
- Owned and maintained the BRDs and user documentation to reflect changing business requirements.
- Provided training to UAT testers, NAV team and Prod Support team as an SME on WSO/GLS and supported business processes.
Skills/Tools: Silk Test 8.0/2006 R2/09, MS word and Excel, Sybase ASE11/12/15-TDS5.5, SQL Server 2005, Aqua Data Studio 6.5.9, XML script, CSV files, Unix shell script, Confidential, SVN, Putty
Environment: Sybase ASE11/12/15-TDS5.5, VB 6.0, SQL Server 2005 PowerBuilder, .NET, DEO, Java 6, JDK, JavaScript, J2EE, Apache Ant, UNIX, ActivePerl
Confidential
QA analyst
Responsibilities:
- API testing involved verifying the feeder logic for processing trades as per the requirements.
- Designed the tests to detect any failures of Confidential processed from MO to iGLS.
- Developed automated XML test scripts to process trade files and verified the trade messages and trade entry in GLS Sybase database.
- Used CSV files to post trades through XML test scripts.
- Testing also involved verifying trade messages through in house application called Help Desk.
- Created SQL queries and executed them in Aqua data studio to validate trade data in GLS database.
- Set up QA environment on unix servers for testing and running regression.
- Documented issues found during testing in development environment using Test Track.
- Retested issues fixed by developers.
- Maintained automated test scripts to respond to changing requirements using change control tool Confidential .
Skills/Tools: XML script, CSV files, MS word and Excel, Sybase ASE11/12/15-TDS5.5, Aqua Data Studio 6.5.9, Unix shell script, Confidential, SVN, Putty
Environment: Sybase ASE11/12/15-TDS5.5, PowerBuilder, Sonic messaging MQ, RDBMS, Power Builder, .NET, DEO, Java 6, JDK, JavaScript, J2EE, Apache Ant, UNIX, ActivePerl
Confidential
QA Analyst/Tester
Responsibilities:
- Developed and documented test scripts based on use cases involving detailed test cases for R&R project to carry out functional testing.
- Executed test cases manually to test the functionality of Account Management, Order Management, Scoring and Reporting, Profile Management and Scheduling.
- Conducted Test case reviews with Developers and BA.
- Validated use cases for compliance with requirement specifications.
- Performed Backend testing by cross checking data in backend on Oracle database by executing SQL queries in TOAD.
- Carried out Usability testing by verifying UI screens and navigation flow.
- Performed Smoke Testing at developers’ side to check for any showstoppers before delivering the build in Confidential QA environment. Carried out Integration, End-to-End testing.
- Logged found Issues as Problem Notifications in Dimensions defect tracking tool.
- Reproduced the reported defects in development environment for developers to implement the fix. Tested issues fixed by developers.
- Created traceability between test cases and use cases.
- Carried out deployment testing by running batch processes in UNIX. Verified UNIX log file for application error using PUTTY.
- Used Silk Test for automation.
- Recorded all the changes made to the Test Scripts, Test Scenario using PVCS Version manager.
- Used PGP Desktop software to carry out the Security testing of Scoring & Reporting functionality for authentication.
- As a part of cross-functional testing team provided support to other testers. Coordinated with Developers and Business team.
- Provided production support by analysing production issues and change requests. Tested the fixes for the defects.
- Provided support to User Acceptance Testing.
Skills/Tools: Silk Test 7.0, Silk Performer 7, Toad 8.6.1.0, Oracle 9.2, XML Marker, Putty, WinSCP, Dimensions web client 9.1.3, PVCS Version Manager 6.8.10, MSword and Excel, PGP desktop 9.5
Environment: JAVA, JSP, XML, J2EE, JRUN, Windows XP, UNIX, Mainframe, LDAP, Apache Struts, Vertex Quantum, People Soft 8.0, Softerra LDAP browser 2.5
Multi Program
Confidential, NJ
Responsibilities:
- Performed Web Service Testing to test the functionality of Account Management, Order Management, Profile Management, Scoring and Reporting, Scheduling as a part of Development QA group.
- Created test cases based on use cases and interface specification (SOA architecture) and also created test data template for web service request.
- Automated test cases using SOAPUI. Created data driven test cases, test suites using features like properties, properties transfer and test request.
- Ran test suites, which contain SOAP Request and verified SOAP Response to check the test result, also verified WSDL request response pair log.
- Designed automation framework for Web service testing and trained/mentored testers in soapUI.
- Used XML Marker to validate WSDL Request (XML based) attributes to be in accordance with the web service mapping specification.
- Carried out Unit Testing to verify the requests for different operations.
- Successfully validated tests by cross checking data in backend on Oracle databases by executing SQL queries in TOAD. Set up test data by manipulating database table to carry out testing.
- Logged found issues in the Microsoft office SharePoint. Tested fixed issues in the new build release by reproducing the test scenario and closed the fixed issues.
Skills/Tools: SoapUI 1.7 /1.7 Pro, SOAPSonar 2.7.1, Toad 8.6.0.1, XML Marker, Putty, WinSCP, Dimensions web client 9.1.3, PVCS 6.8.10, MS Word and Excel, Microsoft Office SharePoint Server 2003.
Environment: JAVA, JSP, XML, J2EE, JRUN, Oracle 10g, SOA architecture, Java beans, X-fire, Windows XP, UNIX, Mainframe, LDAP, Apache Struts, MQ Series, Sybase power designer, People Soft 8.0, Vertex Quantum, Softerra LDAP browser 2.5, MS Project Server, WSDL.
Confidential
QA Engineer
Responsibilities:
- Created and maintained Test scripts, Test Cases based on Business Requirements Specification (BRS) for LCMS Desktop Client and Confidential web Content to test the Reviewers Repository, Content management (Capture/Edit/Review/Approve/Promote/Update), Content Contribution and Production Repository.
- Manual execution of test cases for Functional testing as per test plan for client server application based on VB.NET and web application based on Java, J2EE.
- Created automated 4Test Scripts,4Test Include files, Test Plan using Silk Test. Ran the automated test scripts and suites for regression testing. Verified the result files.
- Managed and trained automation team of interns for Silk Test automation.
- Involved in Internationalization (i18n) testing.
- Tested LCMS application in French and Japanese language.
- Tested various content types like AICC, SCORM, Deployed Scorm content, URL, FILE, ZIP/Dir content, Confidential and Confidential offline content.
- Carried out Integration testing to test the integration of LCMS with LMS.
- Used Clarify ClearQuality as defect management tool. Verified bugs fixed by developer. Involved in complete defect closure life cycle.
- Provided production support to the client site implementation by managing issue resolution and testing patches to be released to clients.
- Involved in System testing, User Acceptance Testing.
- Used Confidential as version management tool and followed standard change control process.
- Participated in the product release activities by testing, verifying and signing off new and existing functionality.
- Used SQL queries for data validation on Oracle and SQL Server databases.
Skills/Tools: SilkTest 6.5, Clarify ClearQuality, Confidential and VSS, MS Word and Excel
Environment: C#, VB.Net, Confidential API, AxisServlets, WebDAV, Oracle, SQL Server. The web client used Java axis client, EJB, servlets, JDBC, Oracle/SQL Server, XML, Windows 2000/XP, Unix.
Confidential
Responsibilities:
- Developed Test Cases based on functional requirements document to test Performance Admin, Review Enhancement, Catalog Administration, Certifications and Assessments Authoring.
- Executed test cases manually as per test plan to test the functionality of the application.
- Created automated test scripts using Silk Test ran the automated test scripts for regression testing.
- Logged found bugs using defect tracing tool Clarify ClearQuality.
- Tested the applications on UNIX platform.
- Tested Crystal reports of the application using property files. Tested the reports manually in Japanese and French language.
- Managed day-to-day change control and version management systems using Confidential .
- Actively involved in all meetings held during the project. Coordinated with Developers and Business team.
Skills/Tools: SilkTest 6.0.3, Clarify ClearQuality, Confidential and VSS, MS Word and Excel
Environment: J2EE, EJB, JSP, XML, Weblogic 8.3, Websphere 8.0, JBOSS, Oracle 9.0 and Dot Net, SQL server, Windows, Windows NT, Unix operating System.
Confidential
Developer
Responsibilities:
- Involved in Analysis, Design, Development phases of the different modules of the application.
- Generated User interface screens using JSP, JavaScript, HTML and DHTML.
- Developed the business functionality using JAVA 2.
- Implemented the database connectivity with the back-end SQL Server database using JDBC.
- Configured Apache Tomcat server to run the application.
- Unit tested the modules and also carried out the functional testing for the Confidential modules.
Tools/Environment: JAVA2, JDK 1.4, EJB, HTML, JavaScript, JSP, SQL Server, JDBC, Web Logic 8.1, Apache Tomcat.
Confidential
Software Tester and Trainer
Responsibilities:
- Created Test scripts, Test Cases using functional requirements document of the application in MS-Word.
- Execution of test cases manually to test the functionality of the application.
- Performed Functional testing and tested GUI of the application.
- Tested the contents specific to courses.
- Logged defects and created defect reports using MS-Excel.
- Logged test results in MS-Excel tracking sheet.
Tools: /Environment: HTML, Java Scripts, MS-Access, MS-Word, MS-Excel