Sr Qa Analyst Nc
SUMMARY:
- Over 7 years of experience in software industry with emphasis mainly on Quality Assurance of Client/Server, Mainframe and Web based Applications using structured methodologies.
- Leadership skills to motivate team to achieve overall organizational goals and objectives.
- Extensive experience in Financial, Telecom, Banking, Insurance and Healthcare.
- Adopted the methodologies of SDLC (Software development life cycle) in the project development and STLC (Software Testing life cycle) in the test projects environment.
- Expertise in User Requirement Analysis, Functional Specifications, Business Requirements, Prepare Test Schedules, Identify Test Requirements, Test Plans, Design Test Cases, Test Scripts and Test Data.
- Experience on Functionality Testing, Integration Testing, GUI Testing, System Testing, Regression Testing, Performance, Adhoc Testing, UAT and testing the application Structures and Functionality’s using Black box testing.
- Experience working with Java/J2EE applications which are developed in webservices and used Ajax Scripting
- Experience with Loadrunner protocols.
- Used agile methodology in the test environment.
- Experience working with Advanced Query Tool (AQT).
- Ensure the QA activities accurately measure the application, service and process quality.
- Reviewed and approved specified deliverables for release.
- Experience with Automated testing tools such as QTP and Test Management and Defect tracking tools such as Quality Center.
- Possess excellent interpersonal, organizational, and communication skills, and have proven to be goal-oriented, diligent and resourceful. Believe in hands-on approach to managing initiatives and team development.
SKILLS:
Automated Testing Tools:
QTP, Load Runner, Rational Robot
Test Management Tools:
Quality Center, Test director, Rational Clear Quest , HP Quick Test Professional
Operating System:
UNIX, Windows NT/2000/XP/Vista/7
Software Languages:
SQL, PL/SQL, C, C++, Visual C++, HTML, JAVA, J2EE, VB Script, Unix Shell scripting
RDBMS:
SQL SERVER, ORACLE, MS- ACCESS, DB2
Web Technologies:
HTML, DHTML, XML
Education:
Bachelors in Engineering, Confidential, University, 2003
Professional Experience:
Project 1:
Confidential,Durham, NC Jan’11 – Current
Sr QA Analyst.
Frontier Communication is one of the most reputed Telecommunication Company taking over Verizon wired phone businesses for almost 13 states now and still expanding. I have been working here primarily for Carrier-to-Carrier Performance information given to Competitive Local Exchange Carriers project.
Responsibilities:
- Involved in analyzing the BRFDD’s and Technical requirement documents.
- Documented Test Plan and Test cases using Quality Centre, classifying them based on the functionality of the application.
- Interacted with Requirement Analysts, Developers and QA team members in different defect raising situations.
- Executed Test cases manually against expected test results.
- Used agile methodology in the test environment.
- Extensively used SQL queries for interacting with the Oracle Database.
- Validated Source files data with the Staging tables, ODS tables and Target tables.
- Tracked and managed the defects with Quality center.
- Performed System Test and end to end test manually.
- Validated the data in front end and backend.
- Involved in testing the application and the data after migration.
- Involved in testing their monthly reporting database.
- Worked with Data Warehousing developers who extensively used Informatica, to design mapping to move data from source to target database using Stages to do the functionality.
- Provided status summary reports with details of executed, passed and failed test cases to the PM on a daily basis before the status meetings.
- Participated in daily and weekly Status meetings.
- Assisted in Production Validation once the code moved to production.
Environment:
Quality Center10.0 (Test Plan, Test Lab, Defects), XML, Oracle 11g, Windows XP, MS-Office, TOAD, SQL Developer
Project 2:
Confidential,Raleigh, NC Jul’08 – Dec’10
QA Analyst.
This project is about Wage and Hour Bureau. The Department of Labor was faced with an antiquated and rapidly aging system that was largely based on Assembler. The Department of Labor constructed a request for proposal that would replace its aging legacy unemployment compensation systems with a new, Service-Oriented Architecture (SOA) based, custom developed family of applications that would manage unemployment taxes, wage record, benefits and claims for employers and constituents of the Commonwealth. The Commonwealth scoped with three main applications (Tax/Wage Record, Benefits and Claims).
Responsibilities:
- Reviewed Business Requirement documents and Technical Specifications.
- Involved in planning, coordinating and executing project tasks.
- Documented test cases corresponding to business rules and other operating conditions.
- Manual Scripting is done for the test cases on the WHB application and execution in Manual Tester.
- Authored test cases and test scripts for functionality testing.
- Closely worked with developers to resolve the technical problems, discussed issues concerned.
- Performed Regression Test and end to end test manually.
- Validated the data in front end and backend.
- Worked on Clear Quest by logging defects.
- Worked on performance testing using LoadRunner tools.
- Validating the data by writing SQL Queries.
- Validated various XML Interfaces and web services (SOA) using SoapUI.
- Worked on RFT for automating the test scripts.
- Conducted Partly Unit, Component Integration, System and UAT Tests.
- Participated in defect review meetings, Status meetings and GO/NO-GO meetings.
- Maintained test logs, test suites and reports.
- Trained the end users.
Environment:
Rational Suite 2007 (Test Manager, Requisite Pro, Clear Quest, Clear Case, Manual Tester & Rational Functional Tester), LoadRunner, MQ Series, Java, J2EE, HTML, XML, SoapUI, Oracle 9i, DB2, Windows XP, MS-Office, SQL Developer.
Project 3:
Confidential,Richmond, VA Jan’07 – May’08
QA Analyst
This was an application developed for a commercial bank. The complete application covered entry of Cash-In, Cash-Out, Loan Approvals, Wire Transfers, Loans, Financial Cash-flow Statements, Financial Ratio Statements, Assets Accounting, etc. The product is more focused on Mortgage Home loan schemes and Certificate of Deposits, Facilitated with Home buy ability Test and Mortgage calculators.
Responsibilities:
- Worked on Entire Software Testing Life Cycle that includes Test Initiation, designing, execution, reporting and closure.
- Discussed and worked with business analyst team to gather detail functionality.
- Create the Application Area for QTP/QC (Object Repository, Function Libraries, and Recovery Scenarios).
- Identify the common Automation flows so as to write the QTP functions and also write the Generic functions such as Verifying the Pages and Entering Data on Pages etc.
- Identify and create the Components for the respective pages whenever they are developed, we were very successful in creating the components as soon as the page is developed i.e. testing and Development phases went on simultaneously.
- Create the Recovery scenarios for the un-handled exceptions in the components using QTP
- Checked the Integrity of the Backend Data by creating Database functions and also by Database Check Points using QTP.
- Used SQL statements extensively to retrieve data for database testing.
- Maintaining necessary backups and version control and error recovery scenarios for the scripts generated.
- Quality Center to document the test data for both Manual and Automated Tests.
- Involved in testing of each phase of the application using Quick Test Pro and Quality Center.
- Participated actively in Functional, System and Integration testing of the application.
- Updated status to the QA Manager as and when needed.
Environment:
Quality Center9.0, QTP9.0, VB.NET, ASP.NET, ASPX, Visual Studio 2008, C#.Net, IIS, CVS, Web Services, SQL+, SQL Server 2005.
Project 4:
Confidential,Chicago, IL. Dec’05-Nov’06.
QA Analyst.
BCBS is a leading commercial insurance company that forms long-term partner ships with clients to support risk management objectives through a unique combination of engineering, underwriting and claims. BCBS ensures business continuity and safeguard with their client properties with seamless, worldwide coverage and property loss prevention engineering solutions. Project utilized the guidance of HIPAA rules and regulations.
Responsibilities:
- Involved in analyzing the business requirements and filtering as per the specifications.
- Involved in developing Detailed Test Plan.
- Involved in testing the Web services/Website applications in Microsoft technologies of ASP.Net/C#.Net. And TCL, Perl scripting language.
- Perform software troubleshooting by using Facets 4.1.
- Verify and editing test data in new and existing systems
- The interfaces were tested with negative testing regression and functional testing.
- Performed Integration, System, Acceptance testing and Adhoc testing.
- Tested Database integrity testing by executing SQL statements on Oracle database.
- Prepared Test Metrics, Results, Reports on Weekly basis for Management.
- Performed testing during the version releases to verify that system is working as intended.
Environment:
QTP 8.0, Quality Center, ASP .Net, ASPX, C#.Net, VB.NET, MS SQL 2005,XML, Web Services, EDI tool, Windows XP, 2000, TCL, PERL, Test Harness, Facets 4.1.
Project 5:
Confidential,NJ Feb’05-Dec’05. QA Analyst.
Cipla Labs is a research based pharmaceutical company with global operation throughout the world. Systems contain data such as product, health information, research and innovation for livestock and Customer Contact Centers (CCC). These are tools across Pharmaceutical companies based on a common platform with local customizations to enhance sales force effectiveness and to improve customer care. Managed Markets (MM) is a common analytics repository to enable one view of the customer across all channel and operating companies to facilitate marketing effectiveness.
Responsibilities:
- Completed System Integration Testing of new features added to the system.
- Involved in writing Test plan to perform system testing.
- Well versed in testing batch oriented applications.
- Authoring test plans, test cases, and supporting test documentation.
- Strongly involved in regression and integration testing and performed successfully.
- Tested Database integrity testing by executing SQL statements on Oracle database.
- Tested the environment of web services/Websites applications such as in ASP.Net/C#.Net.
- Developed Automated Test scripts using Rational Robot for reuseable fuctions.
Environment:
Quality Center, ORACLE7.3/8.0, SQLLoader, VB.NET, ASP.Net/C#.Net, C, C++, Rational Robot, Test Management, winXP/HP Unix, Backend.
Confidential,INDIA Apr’04 - Dec’04.
QA Analyst
HSBC is the first financial services company in INDIA to bring together Banking, Insurance, and Investments under one umbrella. With the most diverse array of products and the greatest distribution capacity of any financial firm in the world, HSBC employees manage customer accounts across many countries like Singapore, China and others. HSBC maintains Whole financial and customer data by using the environment that Sun Solaris 5.6 system running Apache and Oracle app server supported by an Oracle 8i database running on VB. The system receives and updates several legacy systems via batch jobs and FTP agents.
Responsibilities:
- Developing Test Plan and Test Cases for each individual module.
- Performing extensive manual testing of each module.
- Involved in SQL database backend testing.
- Logging and tracking defects into Test Director 6.0 and producing defects reports.
- Interacting with developers on various issues relating to software defects, builds.
- Suggested Enhancements to the application.
- Prepared Tractability Matrix document to map the test cases to the requirements.
- Initiated and helped in process improvements.
Environment: Test Director, UNIX, VB 6.0, Ms-Access2000 / SQL Server 7.0, WinNT/98/2000/XP.