Qa Analyst Resume
Richfield, MN
SUMMARY
- Over Eight years of experience as a QA Analyst/System Integration Engineer in Analysis and Testing of various business applications in Web, UNIX and Client Server technologies.
- Managing and leading QA projects and schedules, highly experienced in Analyzing Business requirements, Developing & Modeling Complex Documentation, Test Plans, Executing Test Cases, and Test Scripts.
- Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, Testing, Implementation, Debugging & Maintenance of applications in the web and Client/Server environments with focus on Quality Assurance.
- Extensively used SQL/PL SQL queries for Backend Testing
- Demonstrated experience in developing and maintaining detailed documentation.
- Experience in using Mercury Interactive Tools (WinRunner, Quick Test Pro, Quality Center with Business Process Testing (BPT) and LoadRunner and Rational Suite Enterprise (Robot, TestManager, RUP and ClearQuest).
- Experience with industry standard methodologies like AGILE(SCRUM), RUP, SDLC and CMM
- Strong in performing System, Integration, GUI, Functionality, Regression, Automation, Performance, Backend, White Box, Grey Box and Black Box testing.
- Excellent knowledge of testing life cycle, SQA methodology and test process documentation and End user training.
- Experience in managing offshore teams and working flexibly to accommodate their timings if required.
- Strong knowledge in QC administration and managing different projects simultaneously to log defects. Also conducted UAT sessions for the whole organization to get first hand feedback before product is launched
- Exposure in the Quality processes involving in Defect Prevention, Metrics collection, Software Configuration Management and Version Control Management.
- Excellent Communication and Presentation skills &ability to work either independently or as a part of a team.
TECHNICAL SKILLS
Operating Systems: Windows 95/98/2000/XP/NT, UNIX, LINUX, MS - DOS, OS/400
Testing tools: WinRunner, LoadRunner, Quick Test Pro, TestDirector, Quality Center, Rational Robot, Test Manager, Requisite Pro, Clear Quest, TFS.
Testing Languages: TSL & SQA Basic
Application/Web Servers: Web Logic, Web sphere, Apache 2.0 and IIS, Visual Studio Team System
Languages: C/C++, Visual Basic 6, SQL, PL/SQL, Shell Scripting, Perl, HTML, PHP, XML, SOAP, XSL, XSLT, XML Schema, XPATH, XSD, Documentum 6, JavaScript, CSS, J2EE, EJB, JSP & Servlets.
RDBMS: MS SQL Server, Oracle, DB2, MySQL, Sybase 11.x, MS Access
Tools: MS Office, SQL Navigator, Toad, Word Perfect, Visio, Visual Studio 2010, Microsoft Excel, SQL* loader, SQL* Plus 3.2, Crystal reports, XML Spy.
Protocols: TCP\IP, UDP
PROFESSIONAL EXPERIENCE
Confidential, RichField, MN
QA Analyst
Responsibilities:
- Responsible for designing, developing and deploying effective Agile testing techniques for new applications, products and/or enhancements to existing applications throughout their development/product lifestyles.
- Worked in different Modules in SinglePoint such as ACH (Automated Clearing House), Cash Forecasting, Information Reporting, LaunchPoint and Messaging ad also System Administration.
- Developed test framework for Portal UI that is used for integration testing.
- Created Automation scripts in Data driven Automation model using QTP.
- Designed and developed User defined functions, Generic functions with VB scripting, Descriptive programming in scripting dynamic objects and reusable actions in defining scenario flows in Quick Test Professional
- From the detailed use cases, created manual & automated test cases for web applications
- Created Regression test suite using QTP for running the automation scripts every time a new build is released by the developer.
- Wrote XML and PL/SQL scripts to perform batch routines & integrate applications.
- Conducted UAT (User Acceptance Testing) sessions for the clients to better understand the products we provide.
- Created system test flow test cases in Quality Center for Clients to have a better feel and understanding of the strategies and usage of products.
- Created a Traceability Matrix for having a complete check of all items during test phase.
- All the defects opened in Quality Center were mapped to a related test case, to keep track of the bug.
- Logged defects as critical, serious or minor depending on severity in the Defect tracking tool, IBM Rational Clear Quest-DTS and also maintained traceability.
- Made sure that the defects opened were reproducible at the first chance or maintained screenshots of the defect for further proof if in case defects were not reproducible.
- Extensive experience in coordinating the testing effort, responsible for test deliverables, status reporting to management, and issue of escalations.
Environment: JAVA, SQL Server 08, XML SPY, Quality Center 10, IBM Rational Clear Quest (DTS), QTP 10.0
Confidential, WaterStreet, NYC
QA Analyst
Responsibilities:
- Analyzed user requirement document and developed test plan which includes test objectives, test strategies, test cases and the overall scope of the project.
- Proficient in Manual Testing and Automated Testing tools.
- Maintained all test cases and status of test execution in Mercury Quality Center.
- Responsible for maintaining and tracking all defects in QC across different project tracks.
- Responsible for creating and maintaining Traceability Matrix
- Responsible for the release of multiple projects such as Aftermarket Research, Multi Vendor, Research Platform
- Extensively used Documentum Taskspace for documents lookup based on Analysts, Brokers and Field of Interest.
- Uploaded documents coming from Brokers with tags using Documentum TaskSpace.
- Used DQL extensively to query documents in the repository
- Tested Documentum Access Controls Lists (ACL) by giving users various permissions to access documents
- Wrote SQL queries to test DLL’s and validate the scores for Meritmark project as part of White Box testing.
- Involved in writing Stored Procedures, Functions, Joins, Views in SQL Server at backend level.
- Involved in Integration Testing which consists of user creation in our CRM System, user validation in our Admin/Private Site, and Entitlement Validation on Contributor Central Site.
- Documented UAT testing confirmed the level of defects found and allowed them to be viewed as part of normal business flow scenarios
- Involved in testing complex applications which followed Service-Oriented Architecture (SOA) and for communications which happens through Simple Object Access Protocol (SOAP) header.
- Coordinated, Managed, and successfully executed Firm Wide UAT Sessions for Meritmark, AMR Projects.
- Validated Models coming in from different Broker firms.
- Extensively tested and validated data in the form of documents, meta-data files, reports and data points for Estimates from thousands of brokers.
- Worked on Fixed Income Research Aggregator.
- Used TFS for bug tracking and Visual Studio Team Test Load in Meritmark project.
- Wrote SQL queries to validate average estimates for Broker firms
- Involved in testing various Data Reports for AMR, Multi Vendors, Usage, Contributors and more.
- Tracking and analyzing the bugs through the JIRA bug tracking system.
- Logged defects in JIRA Defect tracking tool to track the issues identified during the testing.
- Validated data at Data Center level when moving from One data center to another and also during as part of data recovery testing.
- Extensive Involvement in validating intelligent tagging documents for Fixed Income, Securities, Options, Derivatives and Hedge Funds using RIXML, BondHub, Jovus, HDM, Bluematrix templates.
- Involved in Feed Testing of Research documents and validating metadata files with RIXML, HDM, XML flowing from contributors and Buy-Side firms using Fire FTP and XML SPY.
- Verified Service Center, Private site and Contributor Central applications across different supported browsers.
- Used Firebug for troubleshooting java script errors.
- Involved in testing of various applications using Black Box and White box Testing
- Proficient in Business Process testing in QC and QTP
- Involved in Billing Testing using Sales Logix.
- Used Agile Methodology for RP1 and Multivendor Projects.
- Used SCRUM to complete backlogs of Meritmark.
- Developed smoke automation scripts using QTP.
- DB2 Database Administration and Architect expertise, also performed DB2 installation and configuration
- Extensively worked in creating and integrating MicroStrategy Reports and objects with the data warehouse.
- Solid understanding of automation framework, experienced in risk-based analyses identification of process methodologies techniques for optimal implementation.
- Handle the various aspects of the end to end lifecycle related to complex data warehousing and business intelligence projects.
- Managed offshore teams for Confidential .com and Meritmark.
- Developed Test Summary Reports and participated in GO / NO-GO meetings; reviewed QA and software documentation.
- Conduct tests and provide solutions to data warehousing problems.
- Involved in JAD sessions with requirement analysts, product teams to get a better understanding of product.
Environment: ASP.NET, Java, SQL Server 05, DB2, XML SPY, AJAX, Quality Center 9.0, QTP 9.0,Web Services Description Language (WSDL), MS 2007, TFS,VSS, Document taskspace, Fire FTP, Fire Bug
Confidential, Herndon, Virginia
QA Analyst / Tester
Responsibilities:
- Developed Test Plan based on the user’s requirements.
- Implemented whole life cycle of QA Methodologies starting from Planning, Capturing, Creating, Executing, Reporting and Tracking the defects using Clear Case.
- Developed test cases after analyzing the specifications document. Defining the standard templates and process development to get the quality product to the organization.
- Involved in manual testing of the forecasting module of the application.
- Worked with VI editor for Shell Scripts
- Performed Shell Scripting and PL/SQL programming to resolve business problems of various nature
- Performed Database integrity testing by executing complex SQL Queries.
- Extensively used various joins and keys for accessing data in the database.
- Modified and debugged XML files.
- Analyze and process payroll for multi-state corporation using third party vendor.
- Part of SCRUM team attending daily standup meetings.
- Performed Web Services functional testing using SOAPUI, also validate Web services with various Assertions.
- Performed GUI and extensive Regression Testing for subsequent versions of the application using WinRunner.
- Automated test case execution in a C# .NET environment
- Expert in developing XML applications, SOAP, XSL, XSLT, XML Schema, XSD and XPATH
- Developed, maintained and enhanced test data for automation & performance testing team.
- Hands-on experience in designing, developing, and implementing Extraction, Transformation, and Load (ETL) techniques on multiple database platforms
- Developedand executed SQL queries to verify the proper insertion, deletion andupdates into the data Warehouse supporting tables and cubes.
- Developed test scripts for Data Driven Testing and UAT.
- Defining, developing, and enhancing of two separate custom DW/BI systems for the corporate loans and investment business units.
- Responsible for the ETL build validation process on an ongoing basis and for the validation of any modifications to the MicroStrategy reports before release to production
Environment: Visual Basic, ASP.Net, Windows NT, HP-UNIX, SQL, Oracle 8i, HTML, XML, SOAP XML Schema, XPATH, Web Sphere, Rational Robot, TestManager and ClearQuest.
Confidential, New York City, NY
QA Tester
Responsibilities:
- Involved in writing descriptive test plan as per the Business Requirements
- Outstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
- Involved in developing test scripts for Manual and Automated testing.
- Developed and maintained automated test scripts using QTP.
- Involved in Regression Testing as well as descriptive programming in Quick Test Professional
- Developed VB Script for automated test procedures using Quick Test Professional automated testing
- Evaluated process for selecting electronic medical records (EMR) systems by a physician’s health organization.
- Created test scripts and performed testing of the software in accordance with 21 CFR Part 11
- Involved in writing complex SQL, PL/SQL queries and groovy scripting to perform data integrity testing.
- Extensively designed and developed SQL Stored Procedures in SQL Server.
- Test and Debug HL7 Messages.
- Developed test cases and automated test scripts that define various scenarios to test the Functionality, Security, Recovery and Reliability of the application.
- Created UAT real time scenario scripts and tracked all the defects to create new scenarios around the defects.
- Involved in maintaining the Requirements Traceability Matrix (RTM)
- Involved in writing Standard Operation Procedure (SOP)
- Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status
- Worked in Claims area as Quality Analyst to develop applications which accept different claims like Medical claims
- Dental claims, and vision claims from different vendors and route the claims into Batch Adjudication System and Online Adjudication.
- Large-scale implementation of Facets claims management system.
- Deploying Claims management systems and creating end-user helpdesk.
- Billing and claims system realignment.
- Researched transaction posting to Facet.
Environment: Java, Oracle, MS-Access, PL SQL, Claims Process, Facets Configuration, QTP, Test Director, and Sun Solaris (UNIX) platform
Confidential
Developer/QA
Responsibilities:
- Development using C, C++ language.
- Bug fixing and analysis
- Test Environment Setup using simulators and emulators.
- Prepare all the approach notes and involved in designing.
- Involved in documentation.
- Wrote test cases for unit testing.
- Extensive usage of databases for writing complex queries
- Used BCP commands to copy data from one database to other.
- Responsible for creating and maintaining Traceability Matrix
- Analyzed user requirement document and developed test plan which includes test objectives, test strategies, test cases and the overall scope of the project.
- Extensively used Microsoft Word and Excel for storing data tables.
- Maintained all test cases and status of test execution in Test Director.
- Involved in JAD sessions with requirement analysts, product teams to get a better understanding of product.
Environment: C, C++, HTML, XML, Oracle, Toad, Sun Solaris, Test Director