We provide IT Staff Augmentation Services!

Sr. Qa System/analyst Resume

Sacramento, CA

PROFESSIONALSUMMARY:

  • Eight years of experience as a creative and professional team player in SoftwareTesting and Quality Assurance. Excellent understanding of the Software Development Life Cycle (SDLC) with emphasis on testing of web and Client / Server based applications in multiple verticals like Mortgage, Health care, Insurance and Finance.
  • Solid understanding and participation in all the phases of Software Development Life cycle and testing processes.
  • Self directed organized, attention to detail, self-motivated, personable, mulch-focused, employer dedicated and ability to prioritize along critical path, meet project milestones on deliverable dates.
  • Experienced in technical design analysis: ability to understand, analysis and provide feedback on business requirements, software requirements, use cases, gap analysis, activity diagrams, design specifications and other project related documents.
  • Proficient in the area of Requirements, Analysis, Test Strategies, Test Plans, Test Cases, Bug Tracking, and Execution of projects with Manual testing and/or Automated Testing Tools using Mercury Interactive Quick Test Pro, Win Runner, Load Runner, Test Director/Quality Center and Rational Clear Case, Clear Quest, Requisite Pro in Web-Based, Client-Server and n-tier applications.
  • Testing expertise includes Functional testing, Unit testing, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, Cache Testing, Black Box Testing, White Box Testing, System Testing, User Acceptance Testing (UAT)
  • More than 3 years of experience in Testing of Facets Implementations and in-depth knowledge in healthcare and insurance domains.
  • Good Experience with HIPAA 834, 835 and 837 transactions.
  • Proficient in HIPAA Transactions 270, 271, 275, 276.
  • Experienced in Testing Data Migration/ETL Applications.
  • Experienced in validating relational database systems(My SQL Server, Oracle, Sybase)by querying through SQL
  • Experienced in testing various applications in Java, .Net, J2EE, C, C++, C#, Web Logic, Oracle, SQL Server, DB2, Sybase, MS Access environments
  • Extensive experienced in Agile and Scrum model.
  • Experienced in providing results, analysis, conclusions, offer guidance and suggestions to improve Quality & performance of Software applications.
  • Excellent team player with logical reasoning ability, coordination and interpersonal skills.
  • Knowledge of quality standards like IEEE/CMM/TQM(Total Quality Management)
  • Establish and Maintain testing milestones to ensure on-time completion of assignments by using various QA methodologies.
  • Work individually, as well as in team environment, to achieve project quality goals.Well experienced to handle complex situations and time critical schedules. Excellent communication skills and ability to speak with different development groups and clients
  • Possess teaming skills include effectively participates in accomplishing team goals, encourages learning from one another, and creates group cohesion, works effectively with other work groups

TECHNICAL SKILLS:

Operating System: Windows XP, NT, 2000, 2003, UNIX
Databases: SQL Server, Oracle (RDBMS), DB2, TOAD, Microsoft Access, Sybase,
Teradata
Browsers: Internet Explorer, Netscape Navigator, Mozilla Firefox
Automation Tools: Quick Test Pro, Win Runner, Load Runner, Selenium
Application Server: Web logic, Citrix
Processes/Methodologies: Software Development Methodology (SDM), Rational Unified Process (RUP),
Agile (Scrum).
Reporting Tools: Micro Strategy, Crystal Reports
Software: MS Office, MS Project, Photo shop, Dream weaver and Illustrator, MS Access,
Share Point
Bug-Tracker: Rational Clear Quest, Quality Center/ Test Director, PVCS tracker, Bugzilla,
JIRA
Hardware: SUN SPARC, HP-9000, Dell, Compaq Presario and IBM Compatible
Language environments: C#, Java, J2EE, PL/SQL, SQL, VB Script, Java Script, Perl, XML, HTML &
DHTML

EDUCATION:

Bachelor's in Computer Science.

PROFESSIONAL EXPERIENCE:

Confidential, CA JAN 12- Till Date
Sr. QA System/Analyst
The Information Technology Modernization (ITM) Project will modernize the Department of Motor Vehicles' (DMV) aging computer system. The DMV Automation (DMVA) system will be replaced with the new Enterprise Applications Services Environment (EASE) system. EASE is a Web-based application that will look and work similar to the current DMVA screens and will have navigation features that function more like the Internet. The transition from DMVA to EASE applications will occur in phases. The first phase of EASE is the development and release of the Data Communication System Inquiry (DCS) and Court Inquiry (08Q) transactions. The Information Technology Modernization (ITM) Project, Enterprise Applications Services Environment (EASE), continues with technology milestones that will make our jobs "EASE'ier." To remind you just what the ITM Project is all about.
RESPONSIBILITIES:

  • Extensive knowledge of functional testing, developing software testing process, testing scenarios, test plan and strategy for testing, reporting and analyzing test results
  • Developed automated VB test scripts in QTP for large-scale data validation and comparison between two web applications and between the UI and Database defining simple to complex scenarios
  • Outstanding analytical, decision-making, problem solving and management skills with the ability to organize activities in fast speedy team environment.
  • Ability to perform effectively and efficiently in team and individually
  • Developed Test Scenarios/Test Cases and Test Data for the System Testing using Win-Runner/ QTP and Coordinated with the Functional Users to Understand the Process
  • Analyzed and validated system requirements.
  • Involved in Design, Development meetings
  • Created test cases for manage inventory to test EASE Application.
  • Involved in executing testing cases for DMVA and Vehicle Registration.
  • Analyzed DMVA control cahier requirements.
  • Involved in Analyzing data, and developed enterprise and ad hoc reports.
  • Identified system problems and provided solutions for develop, test, and implementation of the application.
  • Created test cases for DMVA Control Cashier from scratch to test the functionality.
  • Involved in analyzing the requirements for Maintain Local files (005) and created new test cases to test EASE application.
  • Involved in designing and developing workload and statistical reports.
  • Involved in analyzing the requirements for Issue Inventory and created new test cases to test EASE application.
  • Analyzed DMVA error messages and created a test strategy to test EASE error message.
  • Involved in developing, reviewing and maintain IT technical and user documentation.
  • Communicated effectively, and maintained good attendance and professional working relationships with upper management.
  • Involved in requirements gathering and analysis.
  • Involved in preparation user guides.
  • Performed database testing using SQL.
  • Worked as troubleshooting specialist

Environment: Windows XP, NT, 2000, 2003, UNIX, Window 7. FACET 4X, Rational Requisite Pro 7.1, Application Life Management 11.0, DB2, Oracle 10g, Rational Functional Tester, QTP, XML, .NET, HTML, Microsoft Excel, MS Word.

Confidential, Aug 11-Dec 11

The iWe Workspace helps employees to bridge silos of information in a single view—so that they can get to right information, at the right place, at the right time. Workspace's new task-based user interface enables consistent user experience thereby increasing employees learn ability, efficiency and effectiveness. As a result, Lowe\'s can lower the total cost to serve while delivering exceptional customer service experience

  • Analyzed Business Requirement Documents (BRD), Functional specifications & systems requirements.
  • Prepared detailed test plan and test cases by understanding the business logic and user requirements.
  • Responsible in Creating, managing the test cases in Quality Center and also Performed Requirements traceability in Quality Center.
  • Extensive experienced in Agile and Scrum model.
  • Identified the test requirements based on application business requirements and blueprints.
  • Performed manual testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance, Performance and Black Box
  • Involved in analyzing the applications and development of test cases
  • Involved in doing System testing of the entire applications along with team members
  • Applications are tested manually.
  • Analyzed and reviewed the software requirements, functional specifications and design documents.
  • Proficient in QA processes, test strategies and experience in creating documents like Test plan, Test Producers
  • Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
  • Involved in Database testing by writing & executing SQL queries by using SQL & TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
  • Developed Test Scenarios/Test Cases and Test Data for the System Testing using Win-Runner/ QTP and Coordinated with the Functional Users to Understand the Process.
  • Environment: Windows Windows XP, NT, 2000, 2003, UNIX, Window 7. FACET 4X, Rational Requisite Pro 7.1, Quality Center 9.2, DB2, Oracle 10g, Rational Functional Tester, QTP, XML, .NET , HTML, Microsoft Excel, MS Word.

Confidential, Herndon, VA Oct 09 - Aug 11
Application QA Analyst

Project 1:
Multifamily Mortgage Backed Security Locator Service is a web service for investors where the Securities Locator Service Quick Search allows users to search for and view a specific security by CUSIP number, pool number, or trust number. The Advanced Search lets users locate a specific security by choosing from several search options. Users can search and view by trust number, one of 16 security types, by a pool prefix, or by coupon rate. Users can also select an issue date to combine with their selected search criteria

Project 2:
The MBS Program Office is developing an overarching disclosure strategy that will be supported by a Consolidated Disclosure Platform that will be the system of record for all of Fannie Mae's security disclosures. This platform will consolidate disclosure activities, including calculations, editing and file generation, currently existing in several independent applications. This consolidation will provide the ability to enhance and create new disclosure data efficiently and timely while still ensuring effective data controls. A single user interface (UI) will provide investors with a method to view and extract the disclosure data for securities.

Responsibilities:

  • Core responsibilities Involved in both Automation testing and Manual Testing of the Mortgage-Backed Securities module.
  • Have thoroughly done Peer reviews for developing the UAT test plan, strategy, test cases which are used while testing the application.
  • Developed and Executed SQL queries manually to perform Back End Testing on large-scale database into different Database Schemas
  • Used Agile Methodology to task the work and for Project Management
  • Used Requisite Pro tool to verify Customer based Requirements.
  • Have developed and executed the Quick test pro scripts using VB script and made a suite of scripts when needed.
  • Prepared the Traceability Matrix for mapping the Requirements with the Test Cases through Quality Center.
  • Developed and Maintained reusable Test Scripts using QTP and Created flows for running different QTP scripts in sequence.
  • Responsible for designing, developing and implementing the ETL process which include the incremental load strategy, full load and disaster recovery
  • Responsible for creating user groups, privileges to the users using repository manager.
  • Developed automated scripts for migration of the ETL processes from one environment to the other
  • Done Data Driven Test with Quick Test Professional (QTP) to test the application with different sets of data.
  • Used Quick Test Professional to automate the test cases, to check page contents, web objects, frames and tables. Parameterize the scripts to run the scripts using varying form data.
  • Used Quick Test Professional to validate the data from source files to UI before and after the dbmod.
  • Developed the VB Scripts for the functionality of most commonly used panels, added logic to the script with conditional statements, loops and arithmetic operators to create more powerful and complex test using QTP
  • Developed automated VB test scripts in QTP for large-scale data validation and comparison between two web applications and between the UI and Database defining simple to complex scenarios.
  • Developed Automated VB Script to export files to MS Excel and perform Data Comparison
  • Written SQL Queries for Database Testing to make sure that front end operations are being stored into the right tables at the back end.
  • Performed Functional testing, Regression testing for every modification in the application and for each build.
  • Have done Smoke Testing, GUI & Integration testing of the application.
  • The reports are generated from Quick test pro result and reported to QA manager.
  • Involved in writing test scenarios for Load and Performance Testing using Load Runner
  • Worked in UNIX environment for log verification
  • Created UAT test plan documents, strategy, test cases, executed UAT test scripts, and created test reports using quality centre
  • Expertise in analyzing and generating the Test Reports.
  • Prepared Quality Metrics Reports & QA Release Notes after observing the test results.
  • Trained, supported and coordinated with end users during UAT to isolate possible problems in software after implementation.

Environment: .Net, C #, Java, J2EE, XML, Java Script, Windows Server, UNIX, Oracle, MS Access, Sybase, Quality Centre, Filezilla, Quick Test Pro, Load Runner

Project 3:
RMSync is a Fannie Mae's internally developed application to bridge the process gap between Requisite Pro & Quality Center for effective and efficiently managing Requirements through the Software Development Lifecycle. RMSync has the ability to synchronize requirements from IBM Rational Requisite Pro (Requirements Management tool) to HP Mercury Quality Center (Test Management tool).

Responsibilities:

  • Analyzed Business Requirement Documents (BRD), Functional specifications & systems requirements.
  • Prepared detailed test plan and test cases by understanding the business logic and user requirements.
  • Responsible in Creating, managing the test cases in Quality Center and also Performed Requirements traceability in Quality Center.
  • Executed RMSync to get a copy of requirements from Requisite Pro to Quality Center by having multiple Filters in the config file.
  • Configured the RMSync Config file with Multiple Attribute Values and Multiple Attribute Filters for various Requirement types that are available in Requisite Pro.
  • Worked with the business team for planning and coordination for running RMSync.
  • Verified the results in Quality Center and cross checked them from Requisite Pro by creating views.
  • Tested the CQ Component by creating multiple Config files, creating the Quality Center Server, Domain, Project and Requisite Pro Project.
  • Created several config files for RMSync synchronization based on the Requisite Pro Attributes and Quality Center mapping.
  • Tested various components like the Engine, User Portal and the Admin Portal, CQ Component.
  • Conducted Functional, Integration, System, Regression, and User Acceptance Tests to see the entire functionality.
  • Involved in application security testing for securing the application with proper authentication & authorization.
  • Performed Positive & Negative Testing for system validations.
  • Responsible in testing the Performance issues that are occurred in the earlier version of the RMSync.
  • Analyze all report bugs for continuous process improvement and keep tracking on the SDLC.
  • Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.

Environment: Rational Requisite Pro, Quality Center 9/10 ,Clear Quest, VB.Net, Oracle 10g, Microsoft Excel, UNIX,MS Word.

Confidential,Baltimore, MD Jun 07 - Oct 09
QA Test Engineer

Confidential, application provides billing information, claim generation, appointments and insurance. The Graphical User Interface associated with this design helps doctors to have interactive means of explaining the status to patients by enrolling into this application.

Responsibilities:

  • Analyzed business Requirement Documents Definition (RDD), Functional specifications & systems requirements
  • Created, setup, executed, validated and reported, manual & automated software Quality Assurance (SQA) testing specific to assigned Information Services development projects.
  • Involved in testing web pages includes Web Portals includes Accounts modules, Contacts modules, registration, Leads & Opportunities.
  • Prepared detailed test plan and test cases by understanding the business logic and user requirements for manual & automated testing.
  • Testing process included Black Box testing, Functional testing, Integration testing, Data Integrity testing, Regression testing, UAT and End to End testing.
  • Experience with FACETS 4.5 Claims processing and workflow.
  • Involved in eliminating bottlenecks, automating work and reducing costs while improving speed and accuracy using FACETS.
  • Involved in Benefit Code Maintenance routine which helped to provide the user with the ability to create, edit, and define the codes representing the various benefit coverages.
  • Involved in application security testing for securing the application with proper authentication & authorization.
  • Hands on experience in writing, testing and implementation of Procedures, functions at Database level.
  • Defined the approach for automating significant part of QA framework so that easily perform most of the operation outlined in the QA framework and published passed/fail results.
  • Performed Positive & Negative Testing for system validations.
  • Analyze all report bugs for continuous process improvement and keep tracking on the SDLC critical path.
  • Responsible for reporting bugs through the Quality Center and verified known bugs against new builds.
  • Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
  • Involved in Database testing by writing & executing SQL queries by using SQL & TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.

Environment: Windows NT4.0, FACET 4X, Rational Requisite Pro 7.1, Quality Center 9 , DB2, Oracle 10g, Rational Functional Tester, QTP, XML, .NET , HTML, Microsoft Excel, MS Word.

Confidential, Mar 06-Jun 07
QA Analyst

Confidential, helps the field Agents of the company to enter prospective customers\' data. The application also calculates the amount of premium required, cash value and benefit amount for the years in consideration. The Online application has different modules and I was involved in testing the Long Term Cares. In this system, registered members with MetLife can get details of their LTC insurance, change the term of their coverage and also use the premium calculator to determine the new premium.

Responsibilities:

  • Analyzed Business Requirements, System Requirements, and participated in the document inspection
  • Created System Test Plan, Test Strategy and System Test Cases based on the business and system requirements to test the functionality of the system
  • Involved in testing functional Hierarchy billing systems by using Amdoc enabler.
  • Assignment included executing functional tests and documenting results as well as stress or load testing, monitoring servers and response time as well as making recommendations to increase capacity and response time.
  • Documented the MicroStrategy report requirements and performed testing using TOAD.
  • Developed advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
  • Experience with the Benefit Code Maintenance routine in defining the codes representing the various benefit coverages along with the employee/employer annual cost based on the kind of coverage.
  • Developed Test Scenarios/Test Cases and Test Data for the System Testing using Win-Runner/ QTP and Coordinated with the Functional Users to Understand the Process.
  • Involved with automated testing capabilities for functional testing, regression testing, Cache testing, GUI testing and data-driven testing by using Rational Functional Tester (RFT) tool.
  • Involved in running batch process/jobs to make all bill exists under fully configured and supportive QA environments.
  • Involved in database testing by writing and executing SQL queries to validate that data is being populated in appropriate tables.
  • Participated in writing HLS (High Level Scenarios) Test plans, Test scenarios and Test cases, software documentation from business and functional requirement.
  • Extensively used SQL queries to perform back end testing to check the Data Integrity.
  • Performed Test Data set up - a pre-requisite to executing use cases during system testing.
  • Wrote a load test scenario to stress the site using the 100 Virtual Users.
  • Followed the testing progress during status meetings and prepared contingency plans when required.

Environment: Windows NT4.0, Win-Runner, Quality Center 9.2, Rational Functional Tester (RFT), Oracle 9i, Load-Runner, Rational Requisite Pro, QTP, UNIX, HTML.

Confidential, May 05 - Jan 06
QA Tester

Confidential, provides transformational medical technologies and services that are shaping a new age of patient care. Vision for the future is to enable a new "early health" model of care focused on earlier diagnosis, pre-symptomatic disease detection and disease prevention.

Responsibilities:

  • Reviewed business requirements and functional specifications.
  • Designed test plans and wrote test cases.
  • Designed Test Cases and Test Scripts for Functional testing using Test Director and for Automation using Quick Test Pro.
  • Enhanced VB Scripts in Quick Test Pro.
  • Developed Test Scenarios to cover all the business requirements and detailed test cases for File Processing.
  • Involved in establishing and maintaining Testing processes.
  • Performed QA operations tasks including metrics analysis, project planning, and other QA functions.
  • Extensively involved in writing, executing and analyzing UAT, Database Checkpoints, and Data Driven Test Scripts for all the projects using Quick Test Professional.
  • Reported defects in HP QC worked closely with analysts, developers to resolve the problems, and change the status of the defect accordingly.
  • Extensively involved in backend testing of reports created by crystal reports with the Operational data store (ODS) in Teradata and Facet database in Sql Server
  • Worked on UNIX platform for running the scripts.
  • Performed Backend Regression testing by writing SQL statements to review the returned data.
  • Used SQL queries to test data integrity.
  • Performed Data Inspection for all the Incoming Files.
  • Developed Inbound File receiving scenarios, and created mock-up data.
  • Worked closely with developers and functional leads in troubleshooting activities to identify business logic and coding errors.
  • Coordinated with developers, project managers and system analyst to resolve various issues related to defects, re-analyzing certain functionalities and providing creative feedbacks
Environment: Windows NT/2000, SQL Server, FACET 4.21, Teradata, Visual Basic, Web Logic, crystal reports, HTML, Win runner, Test Director 7.6, PVCS Tracker

Confidential, India June 03- Apr 05
QA Analyst

Confidential, is an online account management service that allows the customer to do account maintenance via the internet. Users of a business group (Commercial or Retail) can perform transactions such as Opening escrow accounts, Schedule Bill Payments, View account transactions, Schedule wire transfer (Domestic and International), Transfer funds between accounts, manage escrow accounts, liquidate accounts and more.
Responsibilities:

  • Identified the test requirements based on application business requirements and blueprints.
  • Performed manual testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance, Performance and Black Box
  • Involved in analyzing the applications and development of test cases
  • Involved in doing System testing of the entire applications along with team members
  • Applications are tested manually.
  • Analyzed and reviewed the software requirements, functional specifications and design documents.
  • Proficient in QA processes, test strategies and experience in creating documents like Test plan, Test procedures.
  • Developed test scenarios and test procedures based on the test requirements.
  • Participated in Preparing Test Plans.
  • Wrote SQL queries and stored procedures to validate data.
  • Documented errors and implemented their resolutions.
  • Created test scripts, executed test scripts.
  • Developed Test Objectives and test Procedures.

Environment: Oracle 7.1, Visual Basic 5.0, Manual testing, Win Runner 5.01, Test Director5.0 and Windows 95.

Hire Now