SUMMARY:

• Over 6 years of extensive experience in IT Industry with emphasis on Quality Assurance, Automation & Software Testing.

• More than 2 years of experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, Informatica Power Center 9.1/8.6/ 8.1 /7.1 , Power Mart 6.2/ 5.1/ 4.7. x (Repository Manager, Server manager, Mapping Designer, Mapp let Designer, Transformation Developer and Warehouse designer).
• Expert in Web based testing including GUI Testing, Regression Testing, QA/Test Automation, Integration Testing, System Testing, Performance Testing, Stress Testing, Functional Testing and Unit.
• Expert in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual and automation testing.
• As a Mobile Tester and QA Engineer, performed manual and automated testing for the number of web projects such as information and news professional QA portal and company web site across multiple browsers ((IE, Firefox, Safari and Chrome) and mobile devices (Android, iOS).
• Ability to understand, analyze business processes and workflows with the objective of providing recommendations for the best use of technology to improve QA Process.
• Expertise in developing manual/automated test strategies, test plans, test scripts and test cases with a wide focus on black box, functional, regression and stress testing
• Good knowledge on software development life cycle (SDLC) and software testing life cycle (STLC) with Agile Methodology
• Highly experienced in analyzing Business/Functional Specification Document (FSD) Business Requirement Document (BRD)and Detail Requirements Document (DRD)
• Proficient in executing various types of testing including User Acceptance testing (UAT), Compatibility and End to End testing.
• Expertise in testing tools like Selenium (IDE, Grid and Web Driver)
• Working knowledge and ability to execute Structured Query Language(SQL) scripts with Database validation by executing SQL queries
• Attended change request meetings with users and planned the testing for the enhancements to the system
• Highly Dedicated, detail orientated and Self - motivated individual with good Analytical skills coupled with great inter-personal and communication skills
• Experience in Test Automation Framework and using JUNITS, to test application.
• Good knowledge of data warehouse concepts and created Data models that involved Confidential -R/Star/Snow Flake Schemas.
• Experienced in working with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Proficient with Advanced SQL Queries using DML commands and to retrieve data from the databases for backend testing and validating database using TOAD.
• Familiar with Rational Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum.
• Experience in the Scala Programming Language

TECHNICAL SKILLS:

Project Methodologies: Agile, RUP, Scrum, Waterfall, Remedy, Cucumber, Ruby.

Automation Testing Tools: Quick Test Pro (QTP), Load Runner, Selenium Web Driver, Selenium RC Rational Functional tester.

Testing and bug tracking: Mercury Quality Center, Quick Test Pro, Rational Requisite Pro

Languages: SQL. C++, HTML, ALM, Rest/API's

Scripting Languages: VBScript

Databases: Oracle 8i/9i, MySQL, PL/SQL and MS Access,

Data warehouse: Informatica Power Center for ETL

Other Tools: TOAD for My SQL, Selenium Grid, JIRA.

Operating System: Windows 98/XP/ 2003, Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Lead Quality Analyst

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.

• Created test cases, test plans, test data, and reported status ensuring accurate coverage of requirements and business processes.
• Wrote and Executed Selenium tests scripts using JAVA programming language for automation testing of the web application using Selenium Web Driver API .
• Designed a mobile search application system requirements and coded back-end and front-end in Ruby on Rails.
• Implemented Single Sign-On (SSO) in multiple Sales force instance. 
• Involved in testing application on different mobile Platform such as iOS and Android devices.
• Involved in Social Collaboration project to connect Sales force Chatter platforms. 
• Analyzed requirements and creating and executing test cases
• Wrote complex and large Scripts to validate data.
• Initiated setting up automation testing from scratch include execute Installation/Upgrade activities
• Performed Integration, End-to-End, system testing.
• Implemented various testing frameworks such as, Keyword Driven (UFT), Data-Driven, Hybrid, Junit, TestNG,  Cucumber , JUnit, ATDD/BDD, POM Frameworks. 
• Used Maven for Project building tool and Jenkins for Continuous Integration and selenium grid and sauce labs for parallel and cross-browsing testing
• Wrote complex SQL queries in Teradata to compare data in core environment.
• Tested data both from TOAD to Teradata by writing SQL queries SQL server.
• Wrote complex SQL queries to verify data from Source to Target database.
• Performed data validation testing writing SQL queries.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Reviewed existing test cases with the different kind of source systems for different periods of data.
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
• Performed automated testing using Selenium Web Driver with Behavior Driven Development (BDD) and Behavior Driven Testing (BDT) with Cucumber JVM

Environment: Sales force, Ruby, Informatica Power Mart 4.7.2/5.1,Windows 7, Vista, Rest/API's, XP, 2003, 98, TOAD,Teradata, Oracle 11g, SQL Server 2008, PL/SQL, Angular.2, Visual Basic 6.0, QC 9.2, ALM,UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, HP Quality Center

Confidential, San Ramon, CA

Lead Quality Analyst

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.

• Tested ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations that facilitate Daily, Weekly & Monthly Loading of Data.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL.
• Worked on TERADATA.
• Attended the Business and Functional requirement document (BRD) review meetings conducted by BA team to better understand the application and to create the Test Plan and Test Scenarios.
• Developed Test cases, Test plan, Test strategy and Traceability Matrix based on design requirements.
• Developed the automated test script for regression test suite in an application by using Selenium WebDriver and Cucumber with java.
• Participated in identifying the Test scenarios and designing the Test cases from Business Requirements and updating the framework functions as needed.
• Wrote Test scripts for System Testing (IT and Business), Performance testing and User Acceptance Testing
• Executed Functionality testing, System testing, Integration testing and Regression testing, End to End testing
• Attended Daily Scrum and provided the story status to the team
• Performed Smoke testing on every new build of the application
• Identified and documented all issues and defects to ensure application software functionality
• Interacted with Business Users directly for verifications
• Provided Testing status updates to the Leadership team on a daily basis
• Reported and assigned the defects to development team through HP ALM/Quality Center.
• Recorded and played back Selenium Scripts for manual test cases against front and screens by inserting different types of checkpoints.
• Tested Triggers that were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Create Crystal Reports, which would facilitate decision-making.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing and Data validation testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts that are transformed.
• Validated data in between source and target after running Mappings by the Informatica developer team
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment:InformaticaPowerMart4.7.2/5.1), Windows 7, Vista, XP, 2003, 98, TOAD, Oracle 10g, SQL Server 2008, PL/SQL, Visual Basic 6.0, Crystal, SSIS/ SSRS, QC 9.2, Ruby, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project

Confidential, LA, CA

Quality Analyst

Responsibilities:

• Test Hanmi Desktop Deposit (DTD), Mobile Deposit application for Wholesale customers.

• Determine the application landscape. Understand the new requirements and specifications.
• Creating and customizing various test scenarios by referring to the Business Requirement Documents and Functional Specification Document.
• Conduct GUI, Functional, Integration and Ad Hoc testing the various applications
• Worked on Cross Browser testing (All A graded browsers) for Desktop Deposit Web Based application.
• Testing of scanner drivers, Active X controls on different versions of IE browsers, Windows XP, Windows Vista, Windows7 and Mac
• Prepared a test procedure and test strategy such as examining application, testing environment and testing resources to test the application in a given timeline.
• Regression testing of DTD Portal, User Interface (UI) testing and validating Java Script (JS) errors.
• Working on HP Quality Center for organizing and managing all phases of application testing process, including specifying testing requirements, planning tests, executing tests and management.
• Test Mobile Deposit application on Confidential ’s mobile devices like iPhones, iPad.
• Support Production for the new Releases and Change Request (CR).
• Interact with Project Manager, Developers and SME’s to understand the severity of the defects and assigned priorities accordingly
• Ensure compliance with best testing practices and standards
• Validated the resolved bugs in UAT, PRODFIX and Production Environments.
• Supporting Production for the new Releases and Change Request (CR).
• Created, modified, deleted and queried for active directory domain services data.
• Understood data mapping document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Transformed data to meet internal clients’ system requirements and loaded data into Oracle platforms.

Confidential

Quality Analyst

Responsibilities:

• Studied High Level Design documents, Flow charts and Screen shots and interacted with Business SMEs, Technical Lead and Lead Developer to clarify issues upon business requirements.

• Involved in various sign off meetings with the Lead Developers, Business Analysts, Managers and Team Leads.
• Determine the complete scope, complexity and size of testing effort.
• Tested Web Based as well as Client Based application for Mobile Deposit.
• Created and Executed Test scripts, Logged Defects and linked Defects with Test Scripts.
• Created and submitted deposits for the downstream process. Verified posting in WF mainframe system.
• Conducted the Defect Review meetings and discussed the defects.
• Interacted with the Development Team for Issue Resolution and Defect Tracking.

Environment: Windows 2000/XP/Vista, Windows 7, Internet Explorer (IE) 6, IE7, IE8, IE9, Safari, Check Scanners (Digital Check, Panini, RDM and Page scanners), Scanner Drivers, Active X Controls, Mercury Quality Center (Version 10.0 and 11.0), SQL, .Net Framework, iPhone (3GS, iPhone 4G and iPhone 4), iPad (2, Mini and The iPad),Java / J2EE Platform.

Confidential, Dallas, TX

QA Assurance Engineer

Responsibilities:

• Evaluated the Software Requirements Specification and Use Cases documentation.

• Managed test plans, test cases and test code under Clear Case.
• Created test plans according to the functional requirements of different mobile devices.
• Created and maintained test cases with different test sets for different scenarios based on the mobile devices.
• Performed functional, regression, usability, system and integration testing on Mobile smart phones.
• Tested different features of application.
• Crosschecked the links on the application as per requirement.
• Presented monthly Defect and status reports of the project using HP Quality center.
• Documented the changes in requirements in HP Quality center.
• Prepared test results, bug reports document managed using HP Quality center.
• Worked with Both UI Design team and downstream team.
• Performed GUI testing on various screens and verified the properties and functionality of the objects on various windows.
• Validating test Results, logging defects, tracking the defects and generating defect reports using Quality Center.
• Involved in assisting Business Analyst during User Acceptance Testing (UAT) of the application.
• Maintained bug lists for critical issues using defect-tracking tool HP Quality center.
• Managed weekly management status reports and coordinated meetings between test team and development team to review defects.

Environment: Windows 2000/XP/Vista, IE, Mercury Quality Center, Smart Phones.

Confidential

QA Analyst

Responsibilities:

• Extensively used Mercury Quality Center for reviewing and analyzing requirements, planning and execution of test cases, tracking defects, traceability and test coverage report to evaluate the risk associated with the defects.

• Prepared Test sets, all possible combinations of the data required to test each requirement and created Data Driven automated scripts using QTP.
• Identified performance testing requirements and established pass and fail criteria for all the necessary tests
• Tracked the results in the Quality Center and reporting the system defects and bugs.
• Active participation in decision making and Defect Tracking Meetings with Business Analysts, Developers and other stake holders.
• Created and modified QTP scripts for regression testing of business work flow
• Introduced checkpoints, parameterized scripts and developed enumerable data driven QTP scripts.
• Performed the Backend validation using complex TOAD and SQL Queries and also validated the UI values against the database. Used various commands like Select, Insert, Update, Sub Queries, Inner Joins, Outer Joins, Union, Advanced SQL etc. for the data retrieval and manipulation.

Environment: Quality Center, SQL, QTP, TOAD, Windows XP.