SUMMARY

• Over 7 years of IT experience as Quality Assurance Analyst performing Manual & Automation testing for various client - server and web based applications on Windows and Unix platforms
• Expertise in all SDLC methodologies and Agile Scrum methodology
• Extensive Knowledge in SDLC, STLC, BLC and those cycles integration
• Proficient in analyzing system requirements, use cases and other documents to determine the appropriate level of testing required and creating Test plans /Test Strategy and test cases based on requirements
• Excellent knowledge in managing the whole testing process using Mercury Interactive Test Management tool Quality Center
• Proficient in Software testing process which includes developing test cases, executing test cases, documentation and defect tracking
• Expertise in GUI testing, black box testing, User Acceptance Testing, Regression Testing, System and Integration testing
• Experience in developing functional system integration test and test plans and test cases based on system requirements and business rules
• Performed testing on Oracle, SQL Server, MS Access databases and Data Migration
• Experience in defect management, defect analysis and defect reporting using various tools including quality center, bugzilla, jira
• Proficient in writing SQL and PL/SQL requried to perform backend data validation
• Extensively developed test strategies for GUI, Web Applications, Web Services, Client/ Server, Database
• Created ETL test data for all ETL mapping rules to test the functionality
• Tested the ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Cognizant in dealing with developers and business analysts to better understand requirements, functionality and business process for QA testing
• Expertise in Writing, Updating and maintaining the Test documents for various stages of Testing for reference and auditing purposes
• Well versed with basic code debugging, Traced and edited system log files and error files
• Expetise in creating the presentations and documentation for training the team
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and provide system solutions using new approaches

TECHNICAL SKILLS

Operating System: Windows 98/NT/2000/XP/Vista, UNIX, Redhat Linux, Sun Solaris 9.0

Languages: JAVA/J2EE, C, C++, SQL, PL/SQL, Shell Script, Visual Basic, .Net, ASP.Net, C#, XML

Testing Tools: Mercury Quality Center 9.0/10, WinRunner7.01/7.6, Quick Test Pro, Load Runner 9.0

Microsoft Tools: MS office Suite (Word, Excel, PowerPoint), MS-Visio

Bug Tracking Tools: HP ALM Quality Center 10.0, JIRA, Rally, Bugzilla

Databases: Oracle 11g, MS SQL Server, Microsoft Access, Teradata, DB2

ETL Tools: Informatica, Abinitio, Data Stage 7.5, Business Objects

Web Technologies: HTML, DHTML, VB Script, ASP, .net, Java, JSP, JavaScript, IIS, Web logic, WebSphere, Tomcat

Protocols: Http, https, TCP/IP, FTP, SOAP

Tools: Rational Clear Quest 7.1, Rational Clear Case, SVN Subversion, Doors, Informatica, Autosys, XML, XSLT, XSD, SoapUI, Putty, Sharepoint, WinScp, Toad, Sql Developer, Rapid Sql

PROFESSIONAL EXPERIENCE

Confidential, Sterling, VA

Manual Tester

Responsibilities:

• Actively participated in complete software lifecycle of requirements gathering, analysis, design, development and testing of the project using Agile Software Development methodology
• Worked with business team to ensure requirements are understood and implemented according to specifications
• Developed test scenarios as per business rules defined in functional and non functional requirements
• Created Test Cases, Test Data and Test Scripts as per business requirements
• Performed backend testing to validate the data writing SQL queries in Oracle using toad
• Involved creating the End to End test scenarios and execution.
• Involved in testing with web services and XML using soapUI
• Validated XML files using the SOAP Web Services calls that load the data from source to the target
• Used SQL extensively to validate Data partitions, data transformation and to validate consistency of data moved from the source system to target Database
• Involving in writing complex SQL queries to verify data from Source to Target
• Performed data validation testing writing SQL queries.
• Analyzed application data using the SQL to identify the ETL processes
• Tested data warehouse solutions involving dimension modeling with star and snow flake schema
• Tested data in star schema marts and 3nf normalization data warehouse
• Supported application migration from dev to prod environments
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Executed batch jobs in Unix and verified Event log file for testing and debugging
• Analyzed test results and prepares comprehensive subsystem and system level evaluation
• Created the defects in the HP Quality Center and communicated with the developers to fix them
• Generated the RTM by mapping all the requirements in the Quality Center that are loaded from DOORS
• Executed the batch jobs in the unix environment to load the data from source systems
• Performed all UI screens validations and data flow between screens that are match with the backend
• Worked on the batch job failures by tracing the log files and resolved the issues
• Assisted UAT team in setting up the test data
• Demonstrated the application to end users and business team
• Worked in Agile methodology for project development and testing
• Generated the test metrics and addressed the progress of the project in the daily status meetings

Environment: HP Quality Center 10.0, QTP 9.0, Java, J2EE, JSP, SOAP, HTML, Java Script, Internet Explorer 8, Oracle Enterprise Server 11g, Oracle XML DB, Toad 9.0, Informatica8.6, Clear Quest, Clear Case and Window 7, XML, XSD, XML Spy, Rally, Unix, Restful, SOAP, Soap UI, JSON

Confidential, Arlington, VA

QA Analyst

Responsibilities:

• Involved in Functional requirement analysis with the business analysts.
• Reviewed the High level design (HLD), A&D’s, Functional requirements, System Impacts and discussed the new functionality Implemented in team meetings and A&D walkthroughs
• Created the test cases and use cases to cover the business flows
• Reviewed the test cases with the Business and system analysts
• Participated in review meetings and walkthroughs with development and Business Analysts and make sure the A&D documents are updated
• Performed back end testing by executing SQL queries with conditions that are derived from business rules
• Created test cases and mapped them to the requirements in Quality center and executed the test cases from test lab
• Involved in a team for testing ETL process for Networx Order Statusing which constitutes five major processes and Installed Data Stage Client
• Involved in testing interfaces, which includes extracting XML messages using web service utility programs and verified the data mapping into main tables.
• Verified XML messages using XSLT, XPath, XQuery, XML Spy sent to EMS via SOA
• Used Data Stage Director to run scheduled jobs and as well monitored server jobs.
• Effectively defined, analyzed and documented client requirements utilizing UML standards including extensive use case modeling and use case realization
• Quality Center was used to create the test plan, store test cases and run the test sets
• Involved in smoke, Ad Hoc, Functional, Regression and Back end testing
• Reported defects to the development team by using defect tracking tools quality center
• Involved in tracking and updating requirement traceability matrix, thereby linking test cases with business requirements in QC
• Executed batch jobs and tested the data flow

Environment: HP Quality Center, Manual Testing, Share Point, Oracle, Toad, Sql Developer, Sql Server, JIRA, Win SCP, putty, Unix, Win 7, JAVA/J2EE, Apache Tomcat

Confidential, Atlanta, GA

Manual Tester

Responsibilities:

• Interacted with business analysts, architects, developers in requirement analysis, design, review, testing
• Analyzed business and functional specifications and created test plan, test scripts for functional, regression and smoke testing
• Developed testing strategies based on priority and repeatability to determine test scripts to be automated and manually tested
• Created test cases, test data as per business requirements and did end to end manual testing
• Did GUI testing, Positive, Negative, Security, Integration, Regression testing using QTP
• Extensively wrote SQL queries to validate the date across the application
• Oracle used as a relational backend and wrote complex queries, stored procedures, triggers, functions using PL/SQL
• Worked on SQL queries to test data consistency across the application
• Designed the data driven tests in QTP scripts to validate with different sets of test data
• Managed multiple versions of tests and test assets while maintaining data integrity
• Created release risk assessment and provide QA sign off for the application release
• Provided subset of functional test cases to UAT test
• Involved with performance testing group to test performance and stress the test scenarios and analyzed the results using graphs and reports
• Reviewed the quality matrices and keep track of project planning and progress
• Actively involved in testing in all phases of the product to best match the requirements

Environment: HP Quality Center, Manual Testing, Share Point, Oracle, Toad, Sql Developer, Sql Server, JIRA, Win SCP, putty, Unix, Win 7, JAVA/J2EE, Apache Tomcat

Confidential

QA Analyst

Responsibilities:

• Developed test cases and test data as per business requirements
• Did Manual testing on Tested application functionality
• Developed defect workflow in Test Director to enable team to log defects and maintain effective and efficient defect resolution.
• Created comprehensive test procedures for web based applications
• Using Visio created workflows and diagrams for new functionalities
• Executed compatibility testing on different browsers and different operating systems
• Analyzed, comprehend and verified test metrics obtained from test procedures
• Documented all test results along with test scripts and test plans
• Involved in build release on QA track and work independently within a team environment
• Worked with business users in UAT environment
• Worked independently in planning, anticipating problems, anticipated cross functional needs and taking appropriate action within the role

Environment: Manual Testing, Sql Developer, Sql Server, Excel, Visio, putty, Unix, Win XPASP .NET

Confidential

QA Tester

Responsibilities:

• Collected Requirements from Client
• Analysis of Client Requirements
• Involved in Designing, Coding and testing of Modules
• Prepared reports of various modules as per the Client requirement
• Involved in Team Review meetings
• Provided Training to Client People
• Performed GUI and User Acceptance Testing
• Performed extensive database testing by writing SQL queries
• Used SQL Developer to execute SQL queries
• Maintained the Work Products in CVS
• Prepared and maintained Change request documents.
• Used Pre-Execution checklist to verify that the environment is ready for testing
• Actively Involved with Users and Business Team and actively participated in business meetings and reviews

Environment: Visual Basic 6.0, SQL-Server 7.0, Windows-NT, SQL Developer