Qa Analyst Resume
MA
SUMMARY
- Seven Years of Experience in Software Quality Assurance of Web based and Windows Applications. Client/Server and Web based applications. Proficient in Manual testing using Mercury tools (QTP, Win Runner, Quality Center/Test Director), Back end testing and Unix/Linux Environment.
- Good understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle (BLC),Agile Methodology
- Expertise in RDBMS backend testing for data validation and data integrity using SQL Queries on DB2, Oracle and SQL Server and using stored procedures in PL/SQL, Executed negative and positive test cases to test application functionality against user requirements
- Excellent Reporting and Presentation skills using MS Excel, Microsoft Word and MS PowerPoint.
- Experienced in software analysis, Requirements Management, Quality Assurance, Modeling and Configuration Management.
- Extensive knowledge in implementing Structured Methodologies test plans, test cases, test scenarios and test deliverables
- Experience in Manual and Automation (Load and Performance) testing of Web and client/server applications on UNIX and Windows environment.
- Knowledge of protocols VOIP, TCP/IP, FTP and HTTP.
- Proficient in designing and executing test cases - both manual and automated. Involved in developing and maintaining automation test scripts.
- Strong Knowledge of Oracle and PL/SQL Data Bases.
- Extensive experience in writing PL/SQL Stored Procedures and Functions
- Experienced in various types of testing like, Black box, White box, Functional test, Integration test, System test, User Acceptance test, Regression test, and Performance Testing.
- Proficient in Oracle9i/11G, SOAP,XML,, SQL, Unix, Linux.
- Expertise in review and documentation of system Test plans and creating Test cases on the basis of products releases features, client's requirements and related technical document.
- Enthusiastic team oriented member with good communication skills. Ability to work in tight schedules and on different applications concurrently.
TECHNICAL SKILLS
Programming Languages: J2EE, .Net, C, C++, VB and COBOL.
Database: SQL, Oracle 9i/10G/11G,.MYSQLWeb HTML, XML, VB Script, Java Script, Apache,Web Logic
Operating System: Windows 95/98/2K/XP/NT, UNIX, Linux, SAP NWF .
Testing Tools: Winrunner, Testdirector, QTP8.0, Quality Center, Selenium
Test Strategies: Manual, Integration (System), Regression, User Acceptance (Beta), Functional, Compatibility, Product Verification.
Version Control: Rational Clear Case, Requisite Pro, SVN, CVS, Mercator.
Bug Tracking Tools: Rational Clear Quest, Heat, BugZilla, Dragnet,Jira, Testdirector, Quality Center, Trac, Version One
PROFESSIONAL EXPERIENCE
Confidential
QA Analyst
Responsibilities:
- Created the detailed test plan, Test strategy, test scripts, test cases from the business requirements documents and meetings.
- Develop Test Scripts Using Use cases and User Procedures
- Interact closely with Developers, Business/Systems Analysts, Project Managers, and End Users.
- Developed Test plan for each Client Separately (objectives, scope, resources, scenario’s, test cases, schedule)
- Process a Batch Jobs in Windows system and verify the each document and sections
- Run a batch jobs for Client process and Back end Process
- Verify the Mandatory Attributes values in Database Level.
- Verify the E-delivery documents and Log files.
- Validated the XML file, Including Attribute names and Tags
- Create XML Request file and Generate XML Response file and compare the attribute name values with database column values
- Create a SQL Queries and verify the populated data in database
- Involved in Regression Testing and Retesting of Each Build.
- .Able to work in tight deadlines, as well as independently.
- Attend the Regular Meetings with Project Manger and Update the Status weekly Basis.
- Create SQL Scripts and verify the request and response files in windows system as well as in database level
- Executed integration end-to-end testing scripts STARS, UpDoc, CRM IPM, and FI
- Report a defect in Bugzilla
- Prepare test Evidence Document and Report to Client end of each build
Environment: Oracle 10G, Adobe 10.0, FTP, Unix, XML, Java script, VMware, Web services (SOAP), web logic, Oracle SQL Developer 2.1.1.64, PL/SQL, Windows NT, Jira.
Confidential, MA
ETL Tester
Responsibilities:
- Understand the Functional and Design Requirements.
- Understanding the software development life cycle (SDLC)
- Create the Test Plan, Test Scripts using Business rule from mapping document
- Using SQL Query Compare each customized column one sample from Target and Source.
- Create DB compare query and validate data source and target systems
- Create the SQL Scripts for Table count, Null Values, and Zero’s.
- Involved in ETL testing Initial and Incremental load of each cycle in different schemas
- Create the test result of each cycle and upload the client internal site share point.
- Participate the test status meeting weekly and update the status to QA Director.
- Involved in repository testing.
- Performs data quality analysis using advanced SQL skills.
- Tracks defects to ensure appropriate management and escalation of defects. Coordinate defect resolution and retesting.
- Run the Reports and Log the Defects in Quality Center.
- Testing ETL components by Executing SQL and PL/SQL Queries.
- Run the automated scripts for all Service reports created by using load runner tool.
- Tested Service, Data Marts each load of data for Initial and Incremental.
- Tested all modules reports data and validate the data against Oracle EBS source system
- Involved in Different type of testing Like Security testing, Regression testing.
- Using UPK tool create Report documents and publish for UAT Testing.
- Participates in root cause analysis for defects and provides process improvement suggestions to eliminate future occurrences of similar defects.
- Tested all Modules of Dash Board and BI Publisher Reports Navigation and Data validation
- Able to work in tight deadlines, as well as independently.
- Performed Regression testing with QTP by executing the automation test scripts
Environment: Windows XP,QTP9.0,SQL Server, Quality Center, MS- Office, Core-FTP, Shell scripting, Unix,CITRIX,Oracle BI Interactive Dashboards, Answers, UAT Environment, Share Point, Security Testing, Test Track, Source(GCX/GCT) and Target Systems (DWH),Data Marts, Oracle 11i, Oracle EBS 11.9.5(Financial, HR, Service and Supply Chain Management, Order Management),Citrix, Informatica 8.1.1, TOAD 8.0, DAC, Test Director, Business Objects, OBIEE, IIS, Windows XP Client and UNIX Server, UPK Client.
Confidential, Chicago, IL
QA Analyst
Responsibilities:
- Understand the Functional and Design Requirements.
- Under standing the software development life cycle (SDLC)
- Create the RTM’s (Requirement Traceability Matrix) and wrote the test cases based on the functional document.
- Create the payment files like different formats (BELI,DTA,PEXR,CLIOP,NORMA,BTL91,FLAT FILE, EDIFACT (PAYMUL & DIREDEB), XML, X12, LSV, SEPA)
- Process the payment files thru different channels like FTP, AO, File Act, File Handler and GXS.
- Process the payment files thru Different Security Mechanisms like Entrust, AUTACK, TD Access, and SAFEX.
- Verify the complete payment, ack and report flows using the TOAD and Access Direct.
- Create the customer, ack and report routing setups and process the payment files and verify the recreate formats for particular customers.
- Log the project-related issues on test management tool Test Director Update the test case result in TD.
- Analyzing results, identifying solutions that may improve application performance or system capacity
- Completely involved manual regression cycle on different environments like SIT, UAT, Pre-Prod
- Involved in the Performance testing and High Availability testing on UAT and Preprod Environments
- Verify the payment files in Access direct UI monitor.
- Write/Execute SQL Queries to perform UI/Database validations
- Coordinate with other team members and update the test status to test manager on daily basis
- Tested on UAT and Production Tickets and immediate support to customers.
- Involved the GPL (Global Payment Link) Formats ISO8583, Bankline IAT, Bank line HVP, Royal line IAT and GPL end to end testing.
- Involved User Acceptance testing web based application of Access direct.
- Write and executing SQL Queries for complete payment process.
- Create the Payment, ack and report files for different customers and account numbers.
- Involved the customer migration and create the customer and account setup in both databases and upload the payment files and verify the database payment successfully loaded
- Verify Forward mechanism in Payments, Acks and Reports on both databases.
- Report the problems and interact with Access online team on regular basis.
- Migrate customers and roll back the same customers and verify the data on Access Direct Using the Web Monitor.
- Tested extensively the new Link (GXS) to Access Direct ABNAMRO Payment Gateway that replaces the existing FTP.
Environment: Windows XP Client and Linux Server, Clear Quest, Quality Center, QTP, Win runner, Business Objects, J2EE, XML, Oracle 9i, FIX,TOAD, Ultra-Edit, MS- Office, Core-FTP, Unix, MYSQL, Access Direct, UAT and Pre-Prod Environment, WCS, Selenium, FLEX, Web Monitor, ETL, IBM Web Sphere(Mercator), WTX, Access Online, File act(Swift Net),File Handler, Adobe flex, Load Runner.
Confidential, Bridgeport, CT
Software engineer
Responsibilities:
- Prepare Software Test Plan, develop and review the Test cases & Test Scripts for System, Integration, Regression and User Acceptance testing.
- Analyze requirements during the requirements analysis phase of projects and escalate concerns
- Test Case Management using Mercury Quality center.
- Keep track of the new requirements & Change Requests for the Project.
- Forecast / Estimate the Project future requirements and ensure proper documentation of the same
- I was solely responsible for testing and generating reports for online Banking application.
- Performed Manual Testing on this Web based application and automated by using Win Runner.
- Arrange the Hardware and software requirement for the Test Setup.
- Tested the Web application using the Selenium Tool .
- Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager
- Extensive knowledge of Equities and Options Trade Clearing systems required.
- Involved working on the FIX Analyzer tool which monitors and analyzes your FIX Trading flow, instantly reporting problems and important trading events and activities by monitoring the content and status of your message traffic in online/real time or offline mode.
- Organize meetings, Prepare agenda for the meetings including Weekly Team/Status meetings
- Attend regular status calls and update the client with weekly/daily status
- Act as the single point of contact/escalation between Dev team and Test team for Iterations, Testing and Deployment activities.
- Automation using Mercury QTP.
- Testing adobe and flex applications using adobe and flex addin in QTP
- Involved load testing, regression testing and system testing.
- Involved in performance and manual testing of Adobe Flex based web applications
- Experience with performance testing on Web sphere commerce and Web Sphere Commerce Server.
- Track and report upon testing activities, including testing results & defects
- Ensure content and structure of all Testing documents / artifacts are documented and maintained.
- Wrote SQL Queries using TOAD to validate the data in Oracle database.
- Daily status check meetings with the team, review various reports prepared by Test engineers.
- Log project related issues in the defect tracking tool identified for the project (Rational Clear Quest)
- Check for timely delivery of different milestones, Identify requirements and forward it to the Project Manager (Technical and Soft skills).
Environment: Quality center, QTP 8.0, Java, J2EE, XML, Oracle 9i, ETL, TOAD, Microsoft SQL Server - SQL Query Analyzer/Rapid SQL 7.4, FIX, Rational Clear Case, Clear Quest, Swift, Load Runner,WATIR XMLSPY 2004 Professional Edition, Microsoft Visual SourceSafe 6.0,Unix, shell scripting, SVN, Beyond Compare.
Confidential
QA Analyst
Responsibilities:
- Understand Functional and Design Requirements.
- Prepared test cases with expected inputs and outputs.
- Executing the test cases and reported bugs using Jira..
- Involved complete end to end PNR creation and Regression Testing.
- Involved database testing, verify the Travel Guru Database scripts Understand Functional and Design Requirements.
- Detecting bugs classify them based on the severity and reporting them and filed in Bugzilla.
- Install gateway files Start Tomcat and Jboss servers
Environment: Windows XP, Unix, J2ME, MYSQL, Junit,Jboss4.0.3, Load Runner, Win SCP, RUBY, Selenium, Adobe Acrobat, JMeter, MS Office, BugZilla, Soap,, Jira,XML, MVN, Excel, SVN.