Sr QA Analyst

Gunjan Bhargava Phone: 818-***-****

QA Analyst E-mail: *******************@*****.***

Summary

Extensive business and IT experience in Quality Assurance, Quality Control, Testing and Customer Service. Testing experience includes functional, regression, and stress testing of software products and features prior to production implementation. Strong organizational, analytical, leadership and communication skills.

SOFTWARE SKILLS: Extensive knowledge of various software life cycle models, various phases, Quality Assurance etc. Hands on experience on Databases like SQL server and Oracle. Knowledge of PL/ SQL and writing SQL queries.

PERSONAL SKILLS: Comprehensive problem solving abilities, Excellent verbal and written communication skills, Good leadership qualities, Zeal to learn, Team facilitator.

PROFESSIONAL SUMMARY:

B.E with more than 5+ years of IT experience spanning the disciplines of software development, implementation, Quality Assurance and Automated Testing.

Expertise in formulating and evolving testing methodologies out of test strategies.

Excellent communication, interpersonal, research/analysis, organization and leadership skills.

Proven ability to work effectively in both independent and team situations with positive results.

Hands on experience in testing Web Services written in .Net language.

Experience using Quality Center.

Participated in Full Software Development Life Cycle and QA Life Cycle

Developed test plans and test requirements for Manual & Automated testing

Strong organizational skills and the ability to work with other technical staff and customers.

Wrote and Executed SQL statements for back-end testing.

Extensive knowledge of Databases like SQL Server/ Oracle.

Performed Unit, Integration, regression, functional and User Acceptance Test.

Automation of regression and functional testing using QTP. Expertise in data driven testing and parameterization of regression and performance test scripts.

Worked with Version Control and Change management systems.

Analyzed, documented, and verified system change requests (defects, enhancements, new features).

TECHNICAL SKILLS:

Languages ASP, ASP.Net, SQL and PL/SQL, JavaScript.

Testing Tools Quality Center, Quick Test Pro, TestDirector

IDE Visual Source Safe 6.0, SQL Query Analyzer, TOAD

Web and GUI Tools HTML, DHTML, MS Front Page, MS Excel and PowerPoint

Databases Oracle, Sql Server 2000/2005, MS Access

Version Control Visual Source Safe

Change Management Test Director.

Application Servers IIS

Operating Systems MS Windows 95, 98, NT 4.0 & 2000

Work Experience:

Bank of America, Agoura Hills, CA Sept 2010 – Present

Sr. QA Engineer

Part of QA team that is involved in testing the Status Mart/cwNautilus application which is used as a fulfillment and reporting platform by BAC mortgage division. Responsibility includes creating Test plans and Test cases.

Responsibilities:

• Create Test cases and Test plans for modules assigned modules and reviewed Test Plans and Test cases created by Peers.

• Tested Web services using in house developed tool name “Valium”.

• Tested Data feeds and ETLs that deliver data to a distribution server in form of text files.

• Extensive use of XMLs as the data coming to Status Mart from multiple systems was in the form of XML files.

• Writing SQL queries in SQL (SQL query Analyzer) and Oracle (Toad) to validate data processed by the parser application.

• Extensively used HP quality center to file/track defects.

• Working closely with UAT team to help them with their testing efforts.

• Regularly attend functional specification review session.

• Presenting the Test plan and test cases to the whole project team on regular basis.

• Involved in systems integration testing efforts (SIT) and making sure that the system works end to end.

• Provide estimates and timelines to the manager for tasks assigned.

Environment: Quality Center: HP Quality center, .Net, XML, MS Excel, SQL Server2000/2005, .Net, Web Services, Oracle 10.2, and Toad.

Gold Coast Partners, Agoura Hills, CA Jan 2007 – Aug 2010

QA Analyst

Gold Coast partners are a Telemarketing company that provides marketing data to its client in forms of web Based reports, Ad Hoc queries. It has a wide variety of clients that use its web portal to get customer data. The customer data can be exported to various downloadable formats. My Job duties involved extensive testing of these customer reports as well as testing the results generated by running the AD Hoc queries before it gets to the client.

Responsibilities:

• Responsible for implementing effective quality assurance processes and practices.

• Lead weekly meetings with the QA team to obtain status, gather innovative ideas for continuous process improvements and delegate work load.

• Involved in automation of business-reports testing using QTP.

• Extensively used HP quality center to file/track defects.

• Provide estimates and plan work effort based on defect trends and projects.

• Provide weekly test status and defect matrix reports to the management.

• Create test plans outlining the scope, approach, schedule, resources and deliverables.

• Collaborate with architecture and external teams to draft integration test strategies.

• Attend use case and technical specifications review sessions with product and architecture teams to provide feedback in the elaboration phase.

• Designed test flow diagrams to facilitate system and integration testing.

• Coordinated the maintenance of multiple test environments to support parallel test efforts.

• Performed end-to-end, cross platform testing, comprising of web, database, billing, provisioning modules.

• Extensively used XML to test the web services.

Environment: Quality Center, QTP, .Net, XML, XML, MS Excel, SQL Server2000/2005, .Net, Web Services.

United Online Inc, CA Nov 05 – Dec 06

QA Analyst

United Online is a leading provider of consumer Internet and media services. The company's Content & Media services include social networking (Classmates) and online loyalty marketing (MyPoints). Its Communications services include Internet access (NetZero, Juno) and email.

Project(s): Account Provisioning; DSL Billing

• Preparing Test Plan, Test Cases and Test scenarios for covering Smoke, Sanity, Reliability, Functional, Regression, Performance and Backend Testing

• Working with System Analysts, Developers to understand business requirements and to resolve the defects.

• Collaborate with architecture and external teams to draft integration test strategies.

• Analyzed business and system requirements and formulated business flow diagrams and data flow diagrams to aid in comprehensive test-coverage.

• Writing extensive SQL queries to validate data.

• Conduct one on one sessions with developers in performing white box testing while testing critical changes performed in adherence to a tight schedule thereby reducing test cycle time.

• Performing automated testing for the reporting module using VBScript with Quick Test Pro.

• Using SQL Server to run queries for data and backend validations.

• Coordinating defects with developers depending on priority.

• Working under a fast paced environment and delivering the product with minimal or no defects.

Environment: JAVA, Oracle, SQL Server 2000, Oracle 9i, Test Director.

AirCel Digilink India Limited, Jaipur Feb 2002 – June 2005

QA Analyst

Responsibilities:

• Worked with Business Analysts and Business users to understand business needs and requirements

• Wrote test plan and test cases based on business requirements and product release document

• Prepared test requirements, test plans and test sets using Mercury Test Director.

• Defects were entered and maintained in Test Director for all releases.

• Worked closely with Development team and production maintenance team.

• Manual testing of web based reporting Application.

• Writing extensive SQL queries to extract data from SQL database to test the application.

• Functional and GUI testing for QA Lab management system.

• Participated in Full Software Development Life Cycle and QA Life Cycle

• Performed Unit, Integration, regression, functional and User Acceptance Test.

Environment: Sql Server, C#, ASP.Net, Windows 2000, IIS 5.0, T-SQL.

Contact this candidate