SUMMARY:

• Overall 8+ years of experience in IT Industry as a QA Analyst/Programmer in analysis, design, development, testing and implementation of various Client - Server, Web and Banking related applications which use Java/J2EE technologies.
• Certified Software Tester who is results-driven, detail oriented IT professional with over 5+ years of Software testing, Selenium automation, DB programming & web design experience
• Solid experience in analyzing requirements, developing test cases, software verification & validation, test strategy/plan development & test execution
• Experienced in implementing OOPS concepts using Java/J2EE technologies such as Core Java (Collections, Generics, Enums and Annotations etc), Servlets, JSP, EJBs, JDBC, spring, Hibernate and Web Services.
• Well involved in all stages of Software Development Life Cycle including requirement analysis, design, development, testing, deployment and support and maintenance with various methodologies such as Waterfall, Incremental, Iterative and Agile models.
• Extensive experience in writing and implementation of complex test plans, design, development and execution of test scripts for system, integration, UAT and regression testing
• In depth understanding of SDLC, PMLC & Agile development and management processes
• Knowledge & experience in User Acceptance, Regression, White box testing, Black box testing, Backend testing, System & Regression etc.
• Experience in testing of SSIS Packages used for (ETL) Data Extraction, Transformation and Loading, Data Warehousing.tools like Informatica, SQL server BIDS.
• Complete knowledge of Common table expressions, Star and snowflake schema, facts and dims.
• Extensive experience in defect management and status presentation
• Experience in manual testing and automated testing using different tools like QTP, Selenium (Web Driver) using Java. Knowledge and familiarity with different QTP and Selenium automation frameworks (Data driven and Hybrid)
• Experience with Page Object Model (POM) and Hybrid automation framework
• Experienced in programming tools like ANT, Maven Build scripts, JUnit and Log4j.
• Experience in Web/application servers such as Apache Tomcat, WebLogic and WebSphere.
• Experience in using IDEs like Eclipse, Netbeans and Spring Tool Suite (STS).
• Penchant to learn things, Good communication skills, Hardworking and adaptable, quick learning, Self-motivated, precise and dedicated.
• Proven experience in VB scripting, C, C++, HTML, JAVAscripting and knowledge of Ruby on Rails
• Extensive experience in creating SQL scripts
• In depth understanding on database servers like ORACLE & SQL Server
• Ability to work in a team and Independently to attain desired results
• Strong time management skills in handling deadlines under minimal supervision
• Outstanding organizational skills including ability to multi-task prioritize and manage increasingly complex issues with integrative thinking, communicating skills and recognized for being a valued team player.

TECHNICAL SKILLS:

Operating System: Windows XP/2000, Windows Vista,7, 8.1 and Windows NT, Linux, Unix

Languages: Java, SQL, PL/SQL,HTML, xml, C C++, Ruby on Rails, Groovy, VB Script

Scripting Languages: VB Scripting, JavaScript, SQL script

RDBMS: Oracle 9i, Oracle 11g, MSSQL Server 2008 R2, MS Access, MySQL

ETL Tool: INFORMATICA, SQL Server 2008 BIDS (Business Intelligent Development System, SQL Server Integration Services (SSIS)

Functional Testing Tools: Selenium (Selenium Web Driver, Selenium IDE, Selenium RC), TestNG, JUnit, Maven, Jenkins, ant. QTP

Defect Tracking Tools: Quality Center (ALM), Jira, Rally, Test Track Pro, TFS, Test Manager, Bugzilla

IDE/Utilities: Eclipse, PL/SQL Developer, Star UML, TOAD, SQL Developer, Net beans, Spring Tool Suite(STS), Testwise 4.2 and jetbrains Rubymine 7 for Ruby

Productivity Tools: MS Visio, MS Projects, MS Office, Business Intelligence Development Studio

Web Technologies/ service: HTML, JSON, CSS, OO Java Script, AngularJS, SOAP UI,REST, RESTful

Web Browsers: Internet Explorer, Google Chrome, Netscape Navigator, Mozilla Firefox, Opera, Safari

Others: Maven, Ant, Log4j, Adobe Photoshop CS4

PROFESSIONAL EXPERIENCE:

QA Test Developer Analyst (Selenium)

Responsibilities:

• Involved inSCRUMprocess of AGILE methodology in Requirement gathering, Design, Analysis and Code development through iterations. created detailed functional test cases based on the User and Business Requirements.
• Performed manual testing by writing test cases in Excel Sheets, Then by exporting them into HP QC (ALM) and I Logged defects.
• Created SQL scripts using joins and sub queries to retrieve the data from the database and validated the data. I used ETL to test and populate data in Data Warehousing.
• Created query using oracle aggregate functions, analytic function to retrieve and delete duplicate records from database.
• Used Informatica for ETL purpose. Also SQL Server 2008 BIDS (Business Intelligent Development System) and its SSIS (SQL Server Integration Services) was used to test and populate data in Data Warehousing projects.
• Used Selenium Webdriver for creating and executing test scripts for functionality testing of the web application (Application under test).
• Defined test automation strategy and test scenarios, created automated test cases.
• Performed cross browser functional testing using selenium WebDriver. I implemented Page Object Model Automation framework using Java, Selenium WebDriver and Cucumber. I maintained Functional test cases in Testlink Open Source Test Management tool. I configured Maven to download dependent .jar files prior to script execution. performed cross browser testing by using Selenium Grid on multiple browsers and on different platforms performed automated regression testing to verify the new functionality, bug fixes, and fix packs I tracked the bugs accordingly using TestTrackPro. designed and developed the Automation Framework using Eclipse, Java and Selenium Web Driver, Junit/TestNG. I used QC (ALM) for test and defect management in most of time.
• Setup Smoke test suite in Jenkins CI (Continuous Integration) with Maven builds script.

Environment: Oracle, MS SQL 2008 ETL, Informatica BIDS, SSIS. Data Warehousing.Java, JUNIT, CSS, Xpath Checker, Firebug, Selenium WebDriver, Eclipse, Sikuli, Autoit, XML, Maven and Jenkins, SVN, Cucumber, TestTrackPro, Testlink, SoapUIROGERS TELECOM, 8200

Confidential

QA Test Analyst (Test Developer)

Responsibilities:

• Defined testing methodologies, designed Test Plans and Test Cases, verified and validated web based applications and documentation based on standards for agreed Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases for new & changed functionalities
• Agile methodology (Scrum, Bug Scrub) to ensure the new features meet the customer requirements and acceptable quality assurance standards
• Involved in performing GUI, Functional, System and Regression Testing
• Performed Root Cause Analysis for all the assigned issues for existing functionality such as (Corrupted Data, Code Error)
• Prepared automated test scripts using Selenium Webdriver, Java and Junit for the regression testing phase. I have implemented Hybrid framework with Selenium, Excel datasheet and generic keywords sheet.
• Used ANT to automate report generation and mailing over the Junit based Selenium automation framework
• Writing complex SQL Queries to extract data from various database tables for testing purpose.

Environment: HTML, CSS, JavaScript, HP QC ALM, UNIX, Ajax, Microsoft Access, Microsoft Excel, Microsoft word, VSS, IE, Firefox, Chrome, load runner, Selenium Grid, TestNG, Maven, Jenkins, JUnit, Eclipse, MS SQL Server 2008 R2. Oracle, MS SQL ETL, BIDS, SSIS. Data Warehousing. JAVA, Jira, Selenium Ide, Selenium Webdriver, Eclipse, Firebug, Ant, Agile

Confidential

QA Automation ANALYST

Responsibilities:

• Analyzed the business process specifications, use cases and user interface specification documents
• Designed and executed test cases for the customer quote functionality of the application
• Responsible for acting as liaison between database administrators and executive team
• Designed and implemented a multi tier data warehouse and Data Mart using SQL Server 2008.
• Created SQL queries for DB testing, data model design and implementation.
• Worked on Extraction, Transformation and load (ETL) from multiple source systems using SSIS and CDC, (Change Data Capture).I was also using Microsoft BIDS to transform and upload data for analysis for data warehousing related team.
• Performed manual as well as automated testing using testing tool QTP.
• Developed user defined functions in C language. I have interacted with the developers to coordinate bug fixes, build deployments and root cause classification
• Developed Base line scripts for testing the future releases of the application using QTP
• Maintained test logs and test summary reports
• Used Agile and waterfall methodologies during requirements definition, validation, and testingphases. I have prepared and created testing strategies, methodologies, plans, and cases. I participated in daily stand ups and sprint planning sessions

Environment: QTP, Quality Center, Java 2.0, JMS, XML, Web services, Spring Framework 1.2.8, JUnit, Hibernate Structured Query Language (HSQL), DB2, Websphere, Unix

QA Analyst

Responsibilities:

• Analyzed functional requirements and documented the user specifications and business rules.
• Created Test Plans and Test cases documents
• Designed automated tests, created automated test cases and executed using Selenium RC
• Developed SQL scripts for back-end testing, used Selenium to retrieve data from UI and compared results.
• Configured Selenium IDE with Java Bromine for cross browser testing
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium
• Performed functional testing to identify various critical points in the application and automated it by using Selenium RC
• Performed Regression testing for new builds and every modification in the application using Selenium RC
• Used TOAD explicitly to validate the database
• Validated sites across browsers and operating systems, verified the accuracy of links, visual presentation and its alignment with design specifications
• Performed unit testing with JUnit framework. I performed data accuracy, data validation and data integrity testing by querying the database using SQL queries to check the data table on server.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures. I played a major role in design of scalable, reusable, and low maintenance ETL templates.
• Developed complex reports using multiple data providers; user defined objects, aggregate aware objects, charts, and synchronized queries.
• Used Quality Center QC to document requirements, test case creation and test executions including defect logging and tracking

Environment: java, junit+ selenium, tomcat, xml, html, UNIX, Microsoft Access, Excel and word,Java, JUnit, Selenium IDE, Selenium RC, Bromine, Eclipse, TOAD, Quality Center, Firebug MSSQL, Oracleproject: various topics

Confidential

Data Analyst/Software Tester

Responsibilities:

• Created software based on SQL in MS Access with VB.Net front end.
• Analyzed reports for trends and variances in the generated reports
• As a Reporting Analyst, Data extraction done (i.e. Convert data to information) as per government requirement and preparing and storing them in different formats. (i.e. MS Excel, CSV, text file, etc…) to mail them respective departments to plan strategy for next week plans.
• Developed and produced realistic or representational sketches and final illustrations using Photoshop CS4 with touch up corrections.
• Worked on Business Requirements and preparing the Test Plans based on requirements.
• Involved in preparation of the Test Plan and test case documents.
• Used Testing tool like Smoke/Sanity, Functional, System and Regression testing
• Created, Reviewed and executed test scenarios and test cases for end-to-end functionalities and verified the results

Environment: QC, MySql (5.0) - Data Base, Hibernate Search, AJAX, JSON, IOC(Inversion of Control) container - Spring, Spring Security, Log4j, JBoss 4

Confidential

QA Engineer

Responsibilities:

• Worked on Business Requirements, BRDS and formulating the Test Plans based on requirements.
• Prepared the Test Plan and test case documents.
• Used DTS engine to MS SQL fact or Dim as per data structure.
• Sometimes raw data was to be manipulated before loading.
• Created database was tested manually for normalization, relationship and any other defects.
• Defects and suggestions were sent in excel sheet with hard copy.
• Almost all work was done manually with reporting by hard copy.

Environment: .NET, Oracle 9i, windows 2003,Quick Test Pro (QTP) 9.0, Qantom (Open Source Tool), Test Director, Star Team, XML, MS Word, MS Excel, MS Access, VB Script, SQL, Windows Vista.