SUMMARY:

• Extensive experience in DB and Software Testing (Manual and Automation) with a solid understanding of test planning, test management, execution and defect tracking.
• Experience in database/backend validation by writing SQL queries using Squirrel, TOAD, DBeaver and MS SQL Server Management Studio.
• Experienced in creating and executing in Oracle, SQL Server, Informix, Impala and MySQL DB environments.
• Experienced in using big data technologies like Hadoop, Spark, Oozie, Hive, Impala and Thrift server.
• Extensive experience in AWS testing.
• Extensive experience in Black box testing, system, GUI, integration, functional, user acceptance, database testing and regression testing.
• Expert in testing SOA platform including Service definition, design and implementation using WSDL and/or SOAP.
• Coordination experience of creating test strategies, implementation of QA and testing processes and manage requirements using HP Quality Center.
• Experience in ETL Testing, Database Testing.
• Experienced in using tracking tools like RALLY and JIRA.
• Hands on experience working with Unix, Linux and Windows operating system.
• Extensively worked on creating reports and dashboards using Tableau desktop as per the user’s requirement.
• Excellent analytical ability, consultative, accountable, strong leadership, interpersonal communication skills including teamwork and building customer relationships.

TECHNICAL SKILLS:

Project Methodologies: Agile (SCRUM), Waterfall

Databases: Oracle, RDS, MySQL, Informix, SQL Server

Testing Tools: SoapUI, Selenium

Languages: SQL, Java, JavaScript

Web Tools: HTML, XML, WSDL, WADL

Requirement & DB Management Tools: TOAD, DBeaver, SQL Server Management Studio (SSMS)

Test Strategies: Integration, System, Regression, User - Acceptance, Black Box Testing

Defect Tracking Tools: Rally, JIRA, Quality Centre

MS Tools: MS-Excel, Word, Power Point

Big Data Technologies: Hadoop, Hive, Impala, Spark, Oozie, AWS

PROFESSIONAL EXPERIENCE:

Confidential

Quality Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and functional requirements.
• Participated into Cycle planning, Sprint planning, Daily standups, Sprint Retrospective and Scrum of Scrums meetings.
• Documented test plans, test cases and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing and error handling.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries the data across different databases.
• Tested data flow from into source to target was per requirements.
• Validated that data in CDC (Change Data Capture) tables and data into TXT files matched.
• Conducted testing to compare schema and data type for source tables and schema and data type into JSON file.
• Tested duplicate records into data chunks. Verified PCI and PII whether it was getting masked data into files by DB job.
• Worked on Big Data Technologies - Hadoop, Oozie and Impala data warehousing tool.
• Tested data files location and availability into Amazon S3.
• Verified data available into Impala tables and Views pulled data from tables.
• Verified that DB, File, TextToParquet, Append, Compaction Derived jobs process files.
• Participated into story grooming sessions and provided QA inputs.
• Logged, verified and closed defects into Rally.

Environment: Rally, IBM Informix, MySQL, Oracle, TOAD, Squirrel, Oozie, Impala, Hadoop, Selenium WebDriver, Java, SQL, Jenkins, Linux/Unix.

Confidential,San Ramon,CA

Software Quality Engineer

• Developed and provided test strategy inputs to leadership to improve the testing process.
• Review Business Requirement Documents and prepare Test Scenarios and Test Cases as per functional, business requirements.
• Actively participate in scrum meetings, reviews and developed test scenarios in agile environment.
• Extensive experience in creating the Test Plan.
• Used Maven for building the WebDriver project. Integrated with Continuous Integration tools including Jenkins for running test on nightly basis automatically.
• Perform Backend testing by developing and executing SQL queries.
• Conduct Functional Testing using manual and automation testing.
• Responsible for thoroughly testing the Java/J2EE application.
• Using Selenium WebDriver, TestNG, Java to automate test cases.
• Created Selenium automation scripts in Java.
• Worked on automation testing for new features and extensively worked with locating web elements using Id, CSS selector and XPATH.
• Interact with developers to resolve technical issues and investigate software for defects.
• Validated Talend ETL processes to load data through the Staging layer in to EDW.
• Created tasks/Workflows to validate the ETL execution.
• Performed unit/integrated testing of ETL process.
• Investigate software bugs and interact with developers to resolve technical issues using Quality Center.

Environment: Selenium WebDriver, TestNG, TOAD, Maven, Rally, UNIX, Windows 7, PL/SQL, HTML, Oracle, MySQL, SoapUI, Quality Center.

Confidential,Ann Arbor,MI

Quality Engineer

• Analyzed the user requirements, functional specifications and used Case documents for Functional testing.
• Hands on experience writing Selenium tests through Selenium Webdriver/Selenium RC.
• Tested Web Services using SOAP UI
• Reviewed Specified Business Documents and prepared Test Cases using Quality Center based on the requirements.
• As part of compatibility testing, executed the workflow manager web application related test cases on different browsers on different Operating Systems.
• Verification of Frontend GUI objects and elements.
• Familiarity with UAT for making website more user-friendly and for web-applications.
• Created SQL Queries to verify the data storage accuracy
• Created Selenium automation scripts.
• Wrote unit tests using TestNG framework.
• Used Selenium IDE and Firebug for capturing various Xpaths/IDs.
• Extensively used Jira to add and track defects.

Environment: Quality Center, Selenium RC/WebDriver, JUnit, UNIX, Windows, PL/SQL, HTML, Oracle,SOAPUI.