SUMMARY:

• Around 7+ years of experience as a QA Analyst with extensive experience in Quality Assurance Process into Manual to Functional, Integration, Regression, System, Cross - Browser and User Acceptance testing during SDLC.
• Expertise in QA Methodologies, Test Strategies, Test Metrics and Software Development Life Cycle (SDLC)
• Experience in testing Web Applications, Client-Server applications, Web Services and Web APIs
• Experience in Agile (Scrum) and Waterfall methodologies of SDLC.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Scenarios, Test Cases, Test Execution, & Defect Report.
• Experience in analyzing the system requirements and developing detailed Test Plans and test cases for System Testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced working with Database Objects like Tables, Stored Procedures, Views, User defined data types and functions using SQL Server.
• Excellent in writing SQL queries to perform Backend testing
• Good hands-on experience in cross browser, cross platform web testing with TFS, C# and Grid
• Expertise in writing Test cases, Test scripts, Test plan formulation along with extensive working knowledge in defect tracking tools like HP Quality Center, Bugzilla and TFS
• Worked with Business analysts to understand the business requirements and involved in walkthroughs, and periodical meetings to come up with project plans.
• In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
• Proficient in different phases of testing like Black Box testing, Integration, System Testing and User Acceptance Testing.
• Good experience in working with Business Analysts and Development teams to clarify requirements, Application testing status and to provide bug report status updates
• Supporting multiple projects, while maintaining strong quality and ability to meet deadlines
• Excellent analytical skills, documentation skills and presentation skills
• Self-starter and ability to present ideas in a concise, logical and well organized format
• Authorized to work in the US for any employer

WORK EXPERIENCE:

Sr.QA ANALYST

Confidential, Fort Lauderdale, FL

Responsibilities:

• Participated actively in User stories grooming meetings to understand the requirements.
• Attend daily scrum stand ups and provided status updates.
• Created Test Scenarios, Test cases and prepared Test data.
• Configured CRM configurator tool for Document management in QA & Stage environments.
• Perform QA for III successful phases for Online Enrollment.
• Performed Smoke test, Integration test and regression test
• Used SOAP UI to test Web API services directly, which returns Order details, Order Status, Prices for Market, Customer Details, and Contract Details etc.
• Used TFS as bug tracker and reported bugs on Iteration basis.
• Created test cases using Microsoft Test Manager and ran test cases.
• Managed Four offshore resources and assigned them work.
• Wrote many SQL queries to validate the data in database.

Environment: SQL Server 2012, TFS, SOAP UI, HTML, MTM, CRM and Windows 7.

Confidential

Responsibilities:

• Participated actively in User stories grooming meetings to understand the requirements.
• Attend daily scrum stand ups and provided status updates.
• Created Test Scenarios, Test cases and prepared Test data.
• Created multiple test cases based on the mapping document
• Performed detailed testing on each database field level with their data types.
• Compared ESG data fields to existing ISTA data fields and report missing mappings
• Ran SSIS packages in QA & Stage environments for Full Load and Incremental Loads and validated data
• Ran multiple reports to compare data produced by ISTA and ESG
• Perform QA for II successful phases for IT148.
• Worked 7 days a week for multiple weeks as per project demand
• Used TFS as bug tracker and reported bugs on Mappings, SSIS and mainly DATA mismatch.
• Created test cases using Microsoft Test Manager and ran test cases.

Environment: SQL Server 2012, SSRS,SSIS,Visual Studio 2013, Windows 7/2008, TFS, MTM

ETL TESTER

Confidential, Indianapolis

Responsibilities:

• Analyzed Business Requirement Specifications and Test plan Documents for the testing process of the Application.
• Worked in AGILE Methodology and attending daily huddles.
• Developed data quality test plans and manually executed BI test cases.
• Worked with ETL group for understanding Informatica load for dimensions and fact tables.
• Writing Test Plan and executing Test Cases.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application, extensively worked on testing several Microstrategy reports for data quality.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tuned ETL jobs/procedures/scripts, SQL queries to improve the system performance.
• Involved in Writing Detailed Level Test Documentation for reports and UAT testing.
• Tested Micro strategy reports and written test Scripts.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Implemented and maintained tools required to support data warehouse testing.
• Used APEX SQL studio, RedGate SQL compare tools for Data comparison.
• Worked on test data and completed testing and validated all business rules and requirements are met, also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Wrote SQL scripts to perform database testing and to verify data integrity.

Environment: SQL Server, Micro strategy 9x Series, Agile, Data warehouse ETL Informatica 9.5, APEX SQL studio, JIRA.

QA Analyst

Confidential, Miami, FL

Responsibilities:

• Attend Daily Stand-up meetings, as part of the Agile Methodology
• Involved in Preparation of Test Scenarios and Review of Test Cases.
• Created many test cases using Microsoft Test Manager and ran test cases.
• Analyzed test cases that could be automated using automation tools.
• Involved in Regression testing using Selenium and creation of automation scripts for web pages.
• Interacted with client and Development team to understand and gather the Functional and Non-Functional requirements

ETL Tester

Confidential, NJ

Responsibilities:

• Prepared Test cases for Informatica Powercenter jobs & Teradata Scripts on V13 Environments.
• Analyzed Business Requirement Specifications and Test plan Documents for the testing process of the Application.
• Preparing the Sql's in Teradata based on the business rules.
• Validating the files in UNIX.
• Test Cases were prepared to validate the jobs functionality.
• Checkout the code by using with Code promotion Tool.
• Executing the jobs in Control-M scheduling tool.
• Executing, Reporting and Tracking the defects with Mercury Quality Center.
• Involved in Black Box Testing like Functional testing, Smoke testing, Sanity testing and Regression testing.
• Involved in interacting Teradata application from Informatica Powercenter using Teradata Enterprise, Teradata Multi load and Teradata Connector.
• Performed Performance Testing and Integration Testing.
• Analyzed Test Results and prepared Test Summary Report.
• Involved in using Sub Queries, Joins, Functions and Set Operations in Teradata.
• Executed various UNIX Commands and Executing Scripts.
• Results (UTR).

Environment: Quality Center 10.0, SQL, PL/SQL, QTP, Agile, UNIX, Scripting, Oracle 10G, DB2, TOAD9.7

ETL Tester

Confidential, San Francisco, CA

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested source data for data completeness, data correctness and data integrity.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: Data warehouse ETL Informatica 8.6, Business Objects, SQL, PL/SQL, EDI, HP Quality Center 9.2, XML, Oracle 10g, SOAP UI, JavaScript and TOAD for Oracle.