Manpreet Singh
Chantilly, VA *****
Phone 703-***-****
Email:**********.*****@*****.***
Abstract: Eight years of experience in software quality assurance (QA) and
software testing; specialized in Manual and Automated Testing client-
server, desktop and web-based application on various platform and
industries. Hands on experience in System Analysis, QA Processes, Testing
Life Cycle (STLC) and software Test Methodologies. Extensive experience in
creating and executing of Test Plans, Test Cases, Test Strategy, Test
Scenarios, Test data, Test log, Test Summary Report and bug documentation.
Strength:
. Extensive knowledge of Software Development Life Cycle (SDLC),
Software development methodologies and Software Test Methodologies.
. Experience in analysis of system requirement specification, functional
specifications and design documentation.
. Experience in testing reports built in MicroStrategy.
. Expert in Writing, Executing, and Maintaining Test Plans, Test
Procedures, Test Cases and Test Scenarios.
. Expertise in problem solving and bug tracking reports using Bug
Tracking tools Quality Center, and Test Director.
. Solid experience in Smoke, GUI, System testing, Integration testing,
Functional testing, Performance testing, Stress testing, Backend
testing, Sanity testing, and Regression Testing.
. Hands on experience in Tracking and Reporting of defects using Defect
Tracking Tools such as HP Mercury Quality Center, Test Director.
. Knowledge of Capability of Maturity Model Integration (CMMI) levels.
. Experienced in maintaining Requirement Traceability Matrix (RTM).
. Experienced in tracking and logging Defects with high level of detail,
accuracy and informative recreation steps.
. Expert in analyzing Business Requirements, Functional specifications,
Design Documents and other Test Procedural documents for UAT testing.
. Experienced in tracking and logging Defects with high level of detail,
accuracy and informative recreation steps.
. Extensively written Test Analyzing Report (TAR).
. Ability to convey technical concepts to non-technical and end clients.
. Performed structured walkthroughs, Peer Reviews meeting, and testing
to carry out verification and validation process.
. Performed back-end and integration testing to ensure data consistency
on front-end and raw feed by developing and executed complex SQL
queries.
. Excellent knowledge and working experience in Test Execution and Test
Result Analysis.
. Self-starter, team player working on fast-faced development
environments committed to the deliverables.
. Flexible and versatile to adapt to any new environment and work on any
project.
. Possess strong communication, presentation, problem solving and
excellent interpersonal skills.
. Organized, attention to detail, multi-focused and ability to meet
project milestones and deliverable dates.
. Strong team player with excellent interpersonal and teamwork skills
Work Status: US Citizen
Technical Expertise
Version Control Tools : Visual Source Safe
Software Testing Tools : HP QuickTest professional, Quality Center,
Test Director and
LoadRuuner
Languages : VB, SQL, XML
Defect Tacking Tools : Quality Center and TestDirector
Operating System : Windows XP, VISTA, UNIX
RDBMS : Oracle, MS SQL Server, MS-Access
Application servers : Web logic, Web sphere
Professional Experiences:
Fannie Mae, Washington D.C
11/2009 - still there
Software Test Analyst
Responsibilities:
. Coordinating with source system owners, day-to-day ETL(Abnitio)
progress monitoring, Data warehouse target schema Design (Star Schema)
and maintenance.
. Worked with Business analysts and the DBA for requirements gathering,
business analysis and designing of the data warehouse.
. Analyzed business process workflows and assisted in the development of
ETL procedures for moving data from source to target systems.
. Done extensive bulk loading into the target using Oracle SQL Loader.
. Assisted the team in the development of design standards and codes for
effective ETL ( Abnitio).
procedure development and implementation.
. Used Beyond and Compare for data mapping.
. Working with database connections, SQL joins, aggregate conditions.
. Participated in system analysis and data modeling, which included
creating tables, views, indexes, synonyms, triggers, functions,
procedures, cursors and packages.
. Developed PL/SQL scripts to validate and load data into interface
tables (TOAD). The backend was in Oracle and database operations were
handled using stored procedures.
. Worked on all phases of multiple projects from initial concept through
research and development, implementation, QA, to live production, by
strict adherence to project timelines.
. Extensive performance tuning by determining bottlenecks at various
points like targets, sources, mappings and sessions.
. Strong communication and interpersonal skills, self-motivated and
highly organized with excellent system analysis and problem solving
skills.
. Create QA project plan, identify tasks and assign resources for
individual project.
. Create testing documentation as needed such as Test Plan/ Test
Strategy and how to setup manual or automated test cases.
. Involved in developing Project Test Plans, Test Scripts, Test
Scenarios and Test Cases.
. Participated in reviews and walkthrough.
. Performed System testing, functional testing, GUI testing, UAT testing
regression testing and ADHOC testing.
. Strong experience in debugging and troubleshooting various
applications running in Production and Test environment.
. Experience includes Client Interaction and 3rd party vendors to
understand network or system issue. Working with the development team
to resolve issues. Implement fixes delivered by development team and
retest the issue to ensure the problem is resolved.
. Ensure client satisfaction meets or exceeds established goals,
investigating and responding to any customer complaints regarding
quality.
. Possess understanding of System Development Life Cycle (SDLC) and
strong interpersonal skills demonstrating the ability to work
individually and with a cross functional team.
. Participated in setting up the test environment, building and pushing
all the application code to the test environment Created start/stop
scripts for application server.
. Updating the managers with day to day testing status.
. Used Quality center for all testing purpose.
. Designed and managed the execution of Test Cases for the multitier
trading application. Involved in writing Test Cases and participated
in weekly walk through meetings to discuss the status of the project
Environment: Quality Center, HTML, Oracle, Toad, Beyond and compare,
Microsoft Office, SQL Server, UNIX, Abnitio.
General Dynamics, Fairfax, VA
10/2008 - 11/2009
Software Test Analyst
Responsibilities:
. Involving in reviewing and analyzing the business requirements,
functional requirements and software design document.
. Analyzed& Designed Test Plan, Test Scenarios and Test Cases based on
Business requirements, technical specifications, and Use Cases.
. Analyzing test results to ensure existing functionality and
recommending corrective action.
. Creating Test Scenarios with Negative and Positive Scenarios for all
functionalities
. Creating Test Data and performing Functional Testing, Regression
testing, End-to-End Testing.
. Participating in User Acceptance Testing (UAT), Documenting procedures
and guiding the users in verifying various transactions on the System.
. Creating Regression Test Suites for every Release
. Creating Traceability Matrix between Requirements and Test Cases.
. Creating Separate Test Sets for the Each Release Under Test Lab in
Mercury Quality Center
. Involving in changing the Test cases for regression testing according
to the new functionality of the application and executing them.
. Involving in Business Requirements, Design and Testing Review
Meetings.
. Created test bed in order to accomplish testing efforts
. Mentored test team members in a multi-cultural environment.
. Executed of end-to-end testing to evaluate system testing of the
application
. Coordinating testing efforts with teammates and User Acceptance Test
(UAT) with business users as well.
. Developed and enhanced automated script using QuickTest Regression
testing
. Organized weekly meetings to discuss the issues about the project.
. Gathered test requirements by coordinating with design and development
teams
. Developed detailed test cases basing on use cases, requirements
. Prepared Requirement Traceability Matrix to ensure that all the
requirements are met for the sprints
. Defects were tracked and reported in Quality Center
. Worked closely with all the business as well as technology
stakeholders to analyze complex business processes
. Mentored test junior test engineers.
. Involved in preparation of the test data required for executing test
cases.
. Performed Data Driven Testing using QTP
. Managed the testing process, logged and tracked defects using Quality
Center.
. Attended the weekly status meetings and create notes for meeting-
minutes.
Environment: QuickTest Pro, Quality Center, HTML, Oracle, Microsoft Office,
SQL Server, UNIX
QWEST Communications, DC
01/2006- 09/2008
QA Test Analyst
Responsibilities:
. Analyzed Business Requirements, Functional Specifications and the
Required Documents for testing.
. Worked closely with the Developers and Business Development Teams
(BDT) in the review and Modification of Product Specifications.
. Involved in preparing Test Plan and Test Cases.
. Reviewed Functional and Design Specification documents. Identified
Test Conditions, Ambiguities, Conflicts and Risks
. Participated in defect review meetings with the team members and
monitor defect status.
. Performed Functional, Negative, Regression and Smoke Tests on the new
enhancements added to the web application.
. Responsible for generating of various Test Scenarios & Test Cases,
Test Cases Review and Test Execution.
. Used MS Project to keep track of tasks status and prepared Test Status
Reports during test execution processes.
. Performed Back-end testing using SQL queries to validate the data in
the back-end Oracle Database.
. Used Quality Center for defect management and VSS for version control.
. Allocated priorities to all the test cases and took into consideration
the product module priorities.
. Performed Functional and regression testing using quick test pro
(QTP).
. Modify the existing QTP scripts based on approved requirement changes.
. Monitor resources to identify performance, bottlenecks, analyze test
results and report the findings to the clients, and provide
recommendation for performance improvements as needed.
. Developed Base line scripts for Performance, Load and Stress Testing
of the application using LoadRunner
. Developed LoadRunner VuGen script and Created LoadRunner Controller
scenarios to run the script.
. Analyzed the Business requirements, Performed ambiguity reviews and
communicated the inconsistencies between the requirements and
application
. Worked with development and QA team to perform root cause analysis for
defects found during testing.
. Involved in identify Bugs and problems, analyze test results, and bug
reporting and bug tracking.
Environment: QTP, Quality Center, loadRunner, Oracle, Toad, Microsoft
Office, VSS.
Merril Lynch, Somerset, NJ
02/2001 - 12/2005
Software Test Engineer
Responsibilities:
. Responsible for documenting Test Plan, Test Cases as per Business
requirements for each release.
. Investigated the Software bugs and interfaced with developers to
resolve technical issues.
. Executed Test Cases using different testing techniques like Positive
Testing, Negative Testing, Stress testing.
. Gathered test requirements by coordinating with design and development
teams.
. Reviewed QA check lists to make sure that all the requirements are met
for the releases
. Define the test strategy for customer requirements to include
designing, writing, and executing test cases and procedures.
. Regularly following up with Development Team to discuss discrepancies
identified during testing.
. Test Director was used to create the test plan, store test cases and
run the test sets.
. Used Test Director for bug tracking and reporting, also followed up
with the development team to verify bug fixes and update bug status.
. Created and filed various office documentation using MS Office
applications.
. Performed execution of test cases manually to verify the expected
results.
. Performed Functional Testing using QuickTest professional.
. Meet with the developers and technical content writers on a regularly
to update the test documents.
. Developed & executed Test scripts and Test cases for Functional and
Regression testing using QuickTest Professional.
. Designing and Executing Test Cases in Test Director.
. Defects were tracked, reviewed, analyzed and compared using Test
Director.
Environment: VB, Test Director, Oracle, SQL Server, UNIX, Windows 98/NT
Education: Bachelors of Information & Technology, New Delhi, India