Sr. Qa Analyst Resume Profile
Atlanta, GA
PROFESSIONAL SUMMARY:
- Over 6 plus years of experience in the field of IT with importance on software quality assurance
- Good exposure to various SDLC models including Agile Scrum , Water Fall models.
- Proficient in creating Test Plans, Test Cases based on the Business Requirement documents, and Functional Requirement Specifications.
- Experience and good knowledge with SQL for back end database testing.
- Experienced in Smoke Testing, Functional Testing, Regression Testing, Browser compatibility testing and User Acceptance Testing UAT .
- Capability to apply wide technical and practical skills to manage and execute black-box and white-box tests and to evaluate needs for software designing, development, and validations.
- Strong in Front-End Testing and Back-End testing manually, as well as using QTP automation tool.
- Skilled in creating test traceability matrix, test log, automated test scripts and defect reporting.
- Expertise in using Quality Center for writing test cases, test execution, defects management/tracking/reporting.
- Involved in gathering Business and System Requirements of the Application by talking to business users.
- Experience with various Testing tools like HP ALM, QTP, Quality Center, and JIRA.
- Experienced in using Test Director/Quality Center as Test Management Tool for organizing test sets, Daily Runs, defect tracking and reporting.
- Flexible and versatile to adapt to any new environment and work on any project or product
- Good communication and strong inter-personal skills with the ability to co-ordinate activities and work in a team environment and have ability to work on different applications simultaneously.
TECHNICAL SKILLS:
- Testing Tools : Quick Test Professional
- Defect Tracking tools : HP ALM, HP Quality Center, JIRA, Bugzilla
- Testing Types : Manual and automated testing, Black Box testing, Smoke testing,
- Functional testing, Back end testing, Regression testing
- User Acceptance Testing UAT
- Languages : HTML, C, C , Perl, Python,Visual Basics 6.0, SQL, Core PHP
- Operating System : UNIX Solaris, SCO, HP , Linux, and Windows Family
- Database : Ms-Access, SQL Server , MySql , Toad
- Packages : Ms-Office, Ms-Word , Ms-excel , Power point
Work Experiences
Confidential
Sr. QA Analyst
A national non-profit health organization. The faith-based system operates in 17 states and includes 78 hospitals. Performed ICD-10 Project tasks, working on Multiple Confidential applications like Confidential. Processes will be able to handle the modifications to the Medical Data Code Set Standards for ICD-10-CM Clinical Modification and ICD-10-PCS Procedure Coding System by the assigned federally regulated compliance date.
Responsibilities:
- Identify scope systems that will be modified by the ICD-10 project to accommodate ICD-10 code and /or downstream impacts steaming from ICD-10 codes.
- Develops customized reports and system extracts at an advanced level.
- Elicit requirement to be able to generate the tools and info needed to process the ICD-10 information by 2014 Claims Processing, Training etc.
- Mapping of ICD-10 codes to procedure and diagnostic codes in Facets.
- Reviewing all codes and appropriately applying them.
- Sets direction for test data and testing systems and sub-systems.
- Carried out Manual Testing with UNIX Shell scripts, SQL scripts, etc.
- Conduct meeting with the stakeholders and assess their accurate involvement with ICD-10.
- Develop and coordinate implementation timelines with Trading Partners including readiness assessment and coordinated testing.
- Testing Responsibilities included UI Testing, Functional Testing, System Integration Testing SIT , Regression Testing, and User Acceptance Testing UAT .
- Investigated data integrity questions using SQL query and reporting tools and coordinate resolution with key internal and external information technology partners.
- Identify processes and systems to enable to trade files with non ICD-10 complaint trading partner.
- Provision SharePoint sites using departmental processes and standards.
- Analyzes designs and creates complex program specifications or logic.
- Research, debugging and modifications or recommends for modifications to current systems to keep them operating in an efficient and effective manner, conforming to existing department standards.
- Develops complex interfaces utilizing reusable services at an expert level.
- Development of test plans and execution on interfaces.
Environment: QTP, Web Services, SQL, UNIX, MS Visio, MS Project, Excel, Power Point, Word, SharePoint, Win XP Enterprise.
Confidential
Sr. QA Analyst/Data Analyst
CONFIDENTIAL Compass is one of the Confidential banks with 716 branch locations and the second largest bank in Spain. The corporate headquarters, administrative and operational functions are located Confidential . CONFIDENTIAL is among the largest financial institutions in the Confidential, providing its customers around the world with a full range of financial services. This project has to run daily to generate the reports and Confidential managers use these which were generated from this project to take the decision whether to approve the loan to the customer or not.
Responsibilities:
- Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
- Executed reporting test cases for Crystal Reports.
- Performed shakeout testing on the historical loads in UAT and PROD environments.
- Worked on integration of all the processes in UAT/PROD.
- Written several complex SQL queries for validating the data stage jobs.
- Performed data inspection/analysis of tables as well as outbound files.
- Involved in validating the ETL mappings from various systems CRM, OLTP to transaction history/ reporting database.
- Validated SSIS and SSRS packages according to business requirements documents.
- Verified layout of data files and control file entries as per business requirement.
- Based on the generated test data wrote test cases to demonstrate testing approach.
- Responsible for testing the product using SQL Queries/ UNIX command for the DB check and server startup/new builds.
- Preparation of various test documents for ETL process in Quality Center.
- Conducted functionality testing during various phases of the application.
- Tested the entire data reconciliation process for multiple source and target systems.
- Involved in creating the test data for generating sample test reports before releasing to production.
- Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
- Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
- Provided input into project plans for database projects providing timelines and resources required.
- Validated the data integrity and security maintained using integrity constraints and data base triggers.
Environment: Quick Test Professional, Quality Center, UNIX Putty, Oracle 10g, SQL.
Confidential
QA Analyst
The project was about testing the new core pharmacy application for processing mail-order prescription which interact with different interfaces Web, Customer Care,IVR, Mobile
Responsibilities:
- Project planning, scheduling, testing, defect tracking, management, and reporting.
- Quality Center 10.0 and Quick Test Pro QTP in Windows XP Environment with application on it
- Automated testing using Quick Test Pro scripts and also performed manual testing.
- Also used Descriptive Programming without record and play.
- Coded complicated logic in VB scripting used in Quick Test Pro for testing difficult and lengthy scenarios.
- Developed UNIX Shell scripts to execute different SQL tm s to test the sanctity and integrity of the tables.
- Regression testing using Quick Test Pro after deployment of every build in Test Environment.
- Also used Descriptive Programming for Automating Scripts.
- Documented the existing system and verified it with follow-up meetings.
- Written test plans, test scripts, test cases and test procedures.
- Involved in assisting UAT team and end users Business users with data for validating.
- And written functions to improve the performance while executing.
- Executed test scripts in QTP and from the QC by creating test set in test lab.
- Played a major role by actively participating in scheduled conference calls with off shore team to review the testing status and defect summit meetings to triage new defects and to follow up on new fixes, patches and builds.
- Played major role in debugging the scripts.
Environment:Quality Center, Quick Test Pro, Microsoft Visio, VB.net, Java Script, QTP.
Confidential
QA Analyst
As a QA tester/analyst, major responsibilities include guiding the products through the software quality assurance SQA process, design new automated tests, chart test plans for product releases, oversee the review of design and functional specifications, carry out specific test plans.
Responsibilities:
- Developed road map by understanding the business logic and user requirements for manual testing.
- Attended QA meetings in deciding QA test strategies, defining data requirements for the testing and setting up QA environment for testing.
- Prepared the test plans, test procedures and test scripts from the decomposed requirements and use cases, using the QC.
- Created detailed test cases using Excel and imported them into Quality Center.
- Extensively involved in testing the basic functionality of the application manually using QC.
- Performed manual testing of the application interacted with developers to discuss the technical problems and reported bugs using test QC.
- Converted manual tests to automated test scripts using QTP and enhanced the scripts by adding user defined functions.
- Testing Responsibilities included UI Testing, Functional Testing, System Integration Testing SIT , Regression Testing, Security Testing, Data driven and User Acceptance Testing UAT
- Automated test scenarios for GUI, functionality and regression testing using QTP.
- Used verification points and conducted data driven test with the test data set and verified the contents of the website using QTP.
- Inserted GUI, bitmap and text checkpoints in QTP script for validations.
- Involved in writing SQL queries in relational database applications for backend testing and to verify the database updates, inserts and deletions etc., of the records, and validated them.
- Performed regression testing by executing the baseline scripts identified software errors and interacted with developers to resolve technical issues.
Environment: Quality Center, QTP, Java Servlets, JSP, JavaScript, HTML, Oracle, SQL/PL SQL, Windows XP/2000 and MS Office Suite.
Confidential
QA Analyst
This project we create the business product, using JAVA and duck creek technology. It uses the XML session provided by the UI developed in JSP. It compiles the session, processes the request using DCT and sends the response back to UI. Overall, it allows the administration to manage the business in an efficient and effective manner.
Responsibilities:
- Performed manual testing of the application interacted with developers to discuss the technical problems.
- Involved in project planning, coordination and implemented QA methodology.
- Creating test logs and test summary reports using Bugzilla and send them to developers.
- Performed regression testing and identified software errors and interacted with developers to resolve technical issues.
- Performed Component testing and UAT testing.
- Responsible for the delivery and ensuring quality of the deliverables, reporting to the team leader for day-to-day activities and status.
- Created detailed test cases using Excel
Environment: NET ASP, C , XSLT, XML technologies, Bugzilla, CVS, SQL server, MS Office Suite.
