SUMMARY

• Extensive 7+ Years’ Experience in IT Industry with emphasis on Quality Assurance & Software Testing
• Expert in Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
• Testing of REST API's for wireless/Telematics Systems
• Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts &test cases for Manual, Automated & bug tracking tools.
• Experienced in developing Test Plans, Test-Case Designs, and Test Scripting based on User Needs, specifications and Systems Needs documents.
• Used SOAPUI for web services validation for SOA architecture.
• Extracted Data from Teradata using Informatica Power Centre ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, SSIS, SSRS, Cognos and Business Objects.
• Good experience of Quality Assurance methodologies like Waterfall and Agile (Scrum).
• Well versed with writing detailed test cases for functional & Non-functional requirements.
• Experience in implementing and testing SharePoint applications in the system
• Expertise in use of Quality centre (QC) & ALM for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Experience in developing, trouble shooting and customizing Manual as well as Automation scripts using Quick Test Professional (QTP).
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Responsible for collection of metrics/ reporting on metrics/ design preventative and corrective measures for senior management consideration.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Experience with version control, configuration management and change control procedures using tools such as Rational Clear Case.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensive experience in testing Data warehousing environment, experience in testing to ensure that ETL process functions well with all the upstream and downstream processes.
• Extensive experience working with onsite/ off site team model; aware of the cultural issues; aware of the issues in terms of planning efforts/ schedules etc.
• Good communication and interpersonal skills, self-motivated and quick learning skills

TECHNICAL SKILLS

Testing/Defect Tracking: HP ALM, Quality Centre, Bugzilla, Jira

Databases: Oracle, DB2, SQL Server, MS Access, Teradata, Hadoop, MongoDB

Operating systems: Windows, UNIX & LINUX

Database Tools: TOAD, SQL Navigator, Win SQL, SQL Gate, SQL Developer

Data Warehousing: Informatica, SSIS, Ab Initio, Data Stage

Reporting: Business Objects, SSRS, Cognos Report .Net

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, Missouri

Sr. QA Tester

Responsibilities:

• Created test scenarios based on the requirements provided by the business.
• Developed expected results test scripts to perform Functional and Regression Testing.
• Involved in updating the requirements along with the developer.
• Design Test Cycle procedure for Telematics Tracking Products which is applied after every Firmware Release.
• Develop Test Cases based on customer use cases, automate them, Perform feature and regression testing based on new features and changes on the bench and in vehicle.
• Experience in testing remote operations commands over telematic Protocol
• Provided daily status reports to the delivery manager and discuss issues related to the issues and deadlines.
• Used informatica to debug the errors if there are any workflow failures.
• Responsible for communicating with development team to resolve the issues and retest them.
• Updated the test scenarios and added new test scenarios when there are changes in the business requirements.
• Involved in generating the sample file for the business so they can run with their ETLs.
• Reviewed test scenarios with the business and made updates if suggested.
• Logged the defects and improvements in JIRA to keep track.
• Retested the defects and improvements once the development is done and closed them in JIRA.
• Worked closely with the development team to explain about the defects that are raised.
• Executed the ETL workflows by triggering them using UNIX Scripts in PuTTY.
• Performed data analysis and data validation using SQL and Informatica Data Explorer on various sources systems including Oracle and Toad.
• Involved in meetings with the business to discuss about the enhancements and new project change requests.
• Documented the test results in the word documented and attached them to related test scenarios.
• Created the test cases in JIRA and added them to the test cycles based on the deployments to the production.
• Involved in System Integration Testing (SIT) along with the business, includes SIT test cases, shared the test results with the business.

ENVIRONMENT: Toad for Oracle 12, JIRA, Telematics, PuTTY, Informatica 9.6.1, Notepad++, Oracle SQL Developer 4.0.3, WinSCP, Documentation Tools: MS Office - MS Word, Excel, PowerPoint

Confidential, Weehawken, NJ.

Sr. ETL QA Tester

Responsibilities:

• Create test plans, test cases, and participate in user acceptance testing to ensure the highest quality products are released to production
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, VB .NET, ASP .NET
• Tested ad hoc and canned reports for Business objects.
• Work closely with business users and the project team to analyze business requirements in order to create project test scenarios
• Analysed the requirements from business requirement & functional use case diagrams, and other project related documents to design and develop TEMPeffective Test cases
• Analyze and design user transactions, scenarios and estimated load projections for performance testing using QTP
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Tested ETL Dimension Table SCD Type 1 and Type 2
• Used Agile testing methodology for achieving deadlines in UAT; extensively worked on UAT of several modules single handed.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
• Tested Business Objects reports and Web Intelligence reports
• Ran workflow in workflow manager of Informatica and verified session logs for data load discrepancy.
• Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required sign-off's.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization
• Created and executed SQL statement to perform Backend Testing manually that ensured data consistency on the Front-end.
• Generated reports using SOAPUI.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Defect tracking and Status reporting using Quality centre (QC) ALM defect tracking tool.
• In-charge of Usability testing on the product and making appropriate recommendations
• Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and target Database
• Design, develop and execute regression, usability, stress, database verification, ad-hoc and other types of testing activities.
• Extracted Data from Teradata using Informatica Power Centre ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Participated in weekly status meetings, walkthroughs, design review meetings and documented proceedings.
• Develop and maintain internal technical documentation relevant to the QA processes and procedures.

ENVIRONMENT: Oracle 11G, SOAP UI, Teradata SQL Assistant, Teradata V2R6, Quality Centre 11 &ALM, Agile, XML, QTP, .Net, SQL Server 2012, Informatica 9, SharePoint, UNIX, Documentation Tools: MS Office - MS Word, Excel, PowerPoint, MS Project

Confidential

QA Analyst / Manual tester

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Identified the Test Cases and documented them in Quality Centre.
• Worked with the Developers and the Test Lead to verify the Test Cases.
• Designed and Analysed Test case design document basing on the Functional Requirement Specifications to implement through testing process.
• Analysed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules in SAP
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Base-line and Regression tests were scheduled and performed on every Release and build.
• Supported End-to-end testing for downstream systems.
• Worked with batch jobs, monitoring and scheduling jobs using CNTRL-M
• Creation of Test Data for Member data’s according to the scenarios.
• Loaded the Test Data into the HPQC to prepare for the execution of Test Cases
• Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication among Onsite and Offshore Team Members.
• Regularly followed up with the development team to discuss the defects identified during Testing.
• Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
• Interact with end users and investigate issues related to the QA.
• Coordinated user acceptance testing with final users. Prepared end user documentation for the new system
• Used Quality Centre to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Centre
• Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using Quality Centre.
• Expertise in generating the daily defect detailed report using Quality Centre for the other project stake holders and the project Management
• Maintained bug lists for critical issues using Quality Centre.

ENVIRONMENT: Quality Centre, SAP, HTML, MS Office, Microsoft Excel, MS Word, Internet Explorer, Microsoft outlook, PowerPoint and Visio

Confidential

SQL QA Tester

Responsibilities:

• Involved in writing the test plans based on Functional Requirement and Business Requirement Documents.
• Designed and documented all the issues and defects to ensure application software functionality for present and future builds.
• Tested several data migration application for security, data protection and data corruption during transfer.
• Worked with functional testing of the extract and load process. Provided the first level of support for the automation framework.
• Involved in creating the test cases from system specifications/ Business requirements. Performed database testing with SQL Queries using Toad.
• Tested ad hoc and canned reports for Business objects
• Worked with Data Conversion projects for testing data quality after migration. Written several complex SQL queries and Stored Procedures.
• Worked in close relation with Business Analysts and Development team.
• Performed Database testing using Oracle and SQL Server. Logged defects and created various defect reports in Test Director.
• Worked with data reconciliation for the entire data migration project for both target system and rejected records.
• Validated the reports to make sure all the data is populated as per requirements. Involved extensively in production support.

ENVIRONMENT: Informatica PowerCenter, Agile, Oracle and Teradata.