Quality Assurance Ms Office
Resume:
P RANAV CHAUHAN Brampton L*S *Y*
Email: ***********@*****.***
( Peter) Contact: 905-***-****
Software Test Analyst Business Analyst QA Analyst
PROFILE SUMMARY
An accomplished people manager with overall 6 years business experience w ith the last 3 years focusing on software
quality assurance, analysis and testing.
Extensive experience in Manual/Automated testing for Client/Server and Web-based applications on several
platforms, using HP tools HP Quality Center/Mercury Test Director, Quick Test Professional (QTP).
Strong knowledge of Software QA methodologies, testing strategies and techniques.
Comprehensive exposure to the complete Software Development (SDLC) and Software Testing (STLC) Life Cycle projects
including requirements gathering & analysis, estimation, test planning, execution and defect tracking & reporting .
Experience of reviewing Business Requirements Document, System Requirement Specifications, Functional Requirements
Document and Use Case Document to determine Testing Strategy, Scope and developing Test Cases and Scripts.
Strong experience in interacting and collaborating with business groups in achieving testing goals and supporting and
coordinating UAT testing.
Strong working Knowledge of SQL and backend testing using Oracle, MS SQL Server & MS Access.
Team player and experience liaising with multiple teams and business groups.
Experience in Real Time/Batch processing testing.
Excellent analytical, planning, reporting and communication skills developed through years o f work experience.
A keen communicator with ability to work in cross-cultural and multi-lingual environments.
Able to efficiently communicate relative to the audience at hand and able to convey complex information in a friendly and
understandable manner.
Able to work collaboratively with Testers, Developers and other team members in testing complex projects and in the
overall enhancement of software product quality.
Excellent communication, analytical, interpersonal and presentation skills. Hardworking, sel f-motivated team player with
a result oriented attitude.
Dedicated to ensuring prompt and high quality delivery of end products.
Willingness and ability to quickly learn and adapt new technologies.
Participated in key Learning session to improve Quality Pr ocess, Standard.
Excellent oral and written communication skills and ability to work in diverse cultural environments.
TECHNICAL SKILLS SUMMARY
Programming Languages : C, C++, C#, JAVA, JAVA SCRIPT, PHP, PYTHON, HTML, DHTML, AJAX, CSS
GUI : ASP, .Net, Visual Studio 2010
Operating Systems : Windows 98/NT4.0/XP/2003/7, UNIX (SOLARIS/HP-UX/AIX), MS-DOS, MAC OS
Testing Tools : QTP 10/11, QC, Test Director 8.0, Knowledge of Web Load, Web FT,
Win Runner, Rational Robot, Tracker, Bugzilla, Tracks, TFS, JIRA
RDBMS : ORACLE 8.0, ORACLE 9i, SQL Server 2000; MS SQL Server; SYBASE, DB2,
INFORMIX, SQL2005, Access 97/2000
DBMS : FOXBASE, FOXPRO
Packages : MS Office 03/ 07/ 10, Microsoft Outlook, Lotus Notes
Testing Types : White box, Black box, Gray box, Smoke, Sanity, Unit, Functional, System,
Integration Regression, Automation, Security, Cross Platform, Cross Browser,
Navigational, GUI, User Acceptance (UAT), Business Acceptance (BAT), Pilot etc.
Testing Artifacts : Test Plans, Test Strategy, Test Cases, Test and Defect Summary Reports
Testing Methodologies : Waterfall, Iterative, Agile
EMPLOYMENT HIGHLIGHTS
Quality Assurance & Business Analyst 09/2011 - 12/2011
The Capris Group, Mississauga, ON Canada
Project Narrative:
Worked as a QA and BA Analyst on web based application project. Responsible for developing functional requirement
documents, creating test plans, executing test cases and reporting defects as per the defect management process.
Accomplishments:
Participated in requirements gathering workshops and sessions with the business team .
Prepared functional requirement documents for web base application ensuring to meet client needs.
Consulted with client about software system requirements gathering, design and maint enance.
Coordinate meetings with project and development teams to communicate project issues.
Utilized MS SharePoint tool for directing, tracking and outlining needs during a project
Responsible for doing Functional, Regression, Integration, GUI and UAT testing.
Generated test data for positive and negative test scenarios based on functional specifications and design document .
Performed manual testing to know the UAT well and also executed test cases manually to verify the expected results.
Extensively used SQL queries to validate the data in the MySQL as part of back end testing effort.
Helped define the Defect Management Process for the Project.
Participated in test case walkthrough meetings with technical team and business representatives .
Performed cross browser and navigational testing along with regression and Ad hoc testing.
Environment:
Windows 7 Professional, MS SharePoint, Microsoft .Net, PHP, MySQL, Crystal Reports, HTML5, MS Office.
Software Quality Assurance Analyst 03/2011 - 09/2011
Volunteer with Matrix Info, ON Canada
Project Narrative:
Worked as a QA Analyst on multiple projects both small and medium complexity applications developing test cases,
creating test plans, executing test cases and reporting defects as per the defect management process.
Accomplishments:
Identified test requirements, developed test plans, updated and created existing detailed test procedures.
Provided feedback in a timely and constructive manner while reporting defects as well as ensuring that corrective
steps were taken in order to meet client needs.
Contributed to optimizing and improving QA processes and plans.
Participated in requirements gathering workshops and sessions with the business team.
Participated in WBS sessions to provide level of effort estimates to the PM and Client Delivery Manager .
Worked closely with BA s to develop test cases and creating testing artifacts as per agreed QA process deliverables .
Worked with development team members to understand technical design in order to ensure adequate test coverage
and improve testing quality.
Performed basic automation and manual black-box testing using QTP 11.
Qualified, prioritized, escalated and documented end -user issues for the weekly priority & variance meetings with the
client.
Extensively used SQL commands to validate the data in the Oracle Database as part of back end testing effort .
Conducted Defect review meetings using QC and liaised with development team for r esolution.
Helped define the Defect Management Process for the Project.
Participated in test case walkthrough meetings with technical team and business representatives .
Performed cross browser and navigational testing along with regression and Ad hoc testing.
Consulted with customers about software system requirements gathering, design and maintenance .
Responsible for functional, regression, GUI testing of the Inventory application.
Verified defects reported by external groups by reproducing them randomly and from a standards perspective.
Environment:
HP QTP 11, Windows XP Professional, ASP.Net, XML, DB2, IIS Server (application server), Web Sphere, MS Office .
Software Test Analyst 11/2008 12/2010
PepsiCo Inc. Purchase, NY USA
Project Narrative:
Worked as a Test Analyst on complex projects including Platform Migration from Windows XP to Windows 7, Browser
migration from IE 6 to IE 8, and MS Office Application Add -ons/plugins for Migration from MS office 2003 to MS office
2007 (Outlook, Word, Excel, PPT) applications developing test cases, creating test plans, executing test cases and
reporting defects as per the defect management process.
Accomplishments:
Interacted directly with the business units to clarify business requirements in order to develop business test
scenarios.
Developed Requirement Traceability Matrix and conducted Test Readiness Sessions with Business Analysts to
ensure all requirements are mapped.
Involved in performing Gap Analysis and managed all documentation on SharePoint for different Projects.
Involved in Test Planning and Test Effort Estimation for the Migration projects.
Used HP QC for maintaining requirements, test cases, creating Test Labs and managing defects.
Performed sanity and smoke testing before undertaking a full-fledged testing effort.
Migration Project includes more than 100 applications for PepsiCo Corporate which include TAX, Corporate
Governance and Communication applications for B rowser, MS Office and OS Migration.
Worked on Remediation of the failed applications on migrated version of Windows/ Browser and Office and involved
in retesting it after remediation.
Logged defects using HP Quality Center and managed the change requests and requirements successfully at all phases
of the SDLC.
Developed detailed and high level test cases in accordance with the business requirements document and functional
specifications document.
Identified test cases to be run for Regression Testing and involved in Regression Testing.
Involved in retesting the defects and ensuring that they are closed .
Handled and addressed queries from business units surrounding application behavior.
Proactively advised the PM and Test Manager of business concerns surrounding the application.
Helped train the business users on the use of new sales portal and navigation through the portal .
Helped develop the business implementation strategy in conjunction with various business units.
Performed Pilot testing along with the selected business users from various stores.
Conducted weekly Defect Triage meetings and sent out the weekly status reports.
Performed User Acceptance Testing (UAT) for the business users, and reported the errors discovered .
Prepared user training manuals and conducted user training sessions.
Environment:
HPQC 10, Windows XP, SQL Server 2005. MS.Net, IE6/8, Oracle 10, TOAD, Access 2007, SharePoint, MS Office .
Software Tester/Business Analyst 04/2007 10/2008
Harsh Info Systems, Jersey City, NJ USA (Client: PepsiCo Inc.)
Project Narrative:
Worked as a Software Tester/Business Analyst on 2 projects i.e. Browser migration from IE 5 to IE 6, and MS Office
Application Add-ons/plugins for Migration from MS office 2003 to MS office 2007 (Outlook, Word, Excel, PPT)
applications developing test cases, creating test plans, executing test cases and reporting defects as per the defect
management process.
Accomplishments
Created & Maintained build release notes for all builds/releases during the course of testing phase .
Reviewed business requirements gap documents for the internal portal tracking web application used by the client .
Reported software defects in a timely and insightful manner while providing accurate observations.
Created and modified several test cases and test requirements for newly developed features, enhancements and
maintenance releases.
Involved in Creating Test scripts for Backend Testing for Data Migration based on the Data Migration Business
Requirement Document.
Performed Database testing for Data Validation, Data Mapping and Data Integrity between Source Database and
Target Database by Executing SQL Queries in SQL server 2005 .
Performed various types of testing such as Regression Testing, Sanity Testing, System/Functional and Integration
testing and participated in the UAT phase.
Reported newly discovered software defects during test regression runs and provided accurate and communicative
feedback to the development teams including steps to reproduce and business impact .
Utilized Quality Centre as a test case and requirement management tool during testing .
Used the Test plan module to develop test cases and test lab to execute test cases and defects module to log and
manage defects.
Working in co-ordination with Director provided testing support to various Sales related applications undergoing
upgrade.
Coordinated the UAT/BAT phase in a team of 5 business testers in support of the business sponsor s mandate an d
enable sign off.
Provided up to date status to the business sponsor on the status of the testin g effort and delivery timelines.
Collected & compiled lessons learned for IT continuous process improvement initiative surrounding Business
acceptance testing.
Ensured all business test scenarios are executed in compliance with the IT process.
Trained IT testers on business processes and other high risk functional areas to enable common understanding
among the team.
Environment:
HPQC 10, Windows XP, SQL Server 2005. MS.Net, IE6/7, Oracle 10, TOAD, Access 2007, SharePoint, MS Office, SQL
Server 2005, SOAPUI.
Other Experience:
Owned a business which selling and implementing business software for the hospitality industry from 2003 2007.
TRANSFERABLE SKILLS
Ability to perform independently as well as a team player .
Result-oriented, resourceful, reliable and thrives in dynamic, fast-paced environment.
Motivated team contributor, with strong organizational skills and ability to mentor junior staff .
Highly adaptable and strong will to meet new challenges.
Strong organizational skills and ability to operate under pressure.
In depth knowledge of testing fundamentals, processes and methodologies.
Ability to train and coach junior staff on testing techniques & tools.
EDUCATION SUMMARY
Certificate course in QTP V11, 2011
Certificate Course in Web Programming, CSS, Dreamweaver, DHTML 2011
Certificate Course in Software Testing, 2007
Bachelor of Science 2003
Diploma in Computer Programming, C, C++, Java, HTML, Front Page, VB, VC++ 2001
Continuing education CSQA Certification summer of 2012
OPEN TO RELOCATION AND REFERENCES AVAILABLE UPON REQUEST
Contact this candidate