PROFESSIONAL SUMMARY:

• 10+ years of experience in Information Technology with emphasis on Quality Assurance (Automation and Manual) of Client - Server, Web applications, Analysis (Data, Functional, and Service), Data Modelling and Data Base testing.
• Designed and Developed Automation Framework with Selenium Web driver 2.0, Java Programming, Maven, Junit, Eclipse IDE
• Well Versed in Handling Web Elements for Selenium WebDriver and writing test cases using Element Locators, Web driver methods, Java Programming features, Junit and TestNG Annotations.
• Knowledge and experience of data driven cross browser and parallel test execution using Selenium Web Driver, Junit, TestNG and Cucumber
• Hands on experience on CSS Selectors, XPath expressions to identify web elements using Firefox plugins like Firebug and FirePath for Selenium WebDriver 2.0
• Versatile with Analysis (Business, Data, Functional and Service), stored procedures, functions, triggers using SQL, TOAD, AJAX Data Loader and DB2.
• Experience in creation of Conceptual, logical and physical data models for relational and dimensional databases using CA Erwin to help discover information via data mapping develop reports and app.
• Thorough understanding of Inspection, Validation, Cleaning and Transformation of data using IBM InfoSphere.
• Experience in establishing QA processes and standards for Quality Assurance, Proficient with writing test plans, documenting test procedures and writing in-depth test cases to meet the testing cycle.
• Proficiency in writing Automation test cases using Gherkin with Cucumber.
• Experience in Quality Center 10.0, HP ALM 11.0, QAComplete for test management, Rally, TFS and Version One for Agile Story board and bug tracking.
• Experience in SDLC and STLC of multiple industry domains like Health Care, Pharmaceutical, Retirement and Financial using both Waterfall and Agile Methodologies.
• Sound Knowledge of Agile (Scrum) and active participation in grooming, sprint planning, sprint review, estimation, retrospectives, standups and acted as backup scrum master.

TECHNICAL SKILLS:

Methodology: Waterfall, Agile(Scrum, Safe), Agile(BDD)

Languages: Java, JavaScript, SQL, DB2, HTML

Databases: MS SQL Server 2008/2008 R2, 2014, IBM DB2, OMNI Main frame, Salesforce(CRM DB)

Data Modelling Tool: IBM Info Sphere, CA ERWIN

Bug Tracking Tools: QC 9.0, 9.2, 10.0, HP ALM 11.0, Microsoft TFS, Rally, QA complete, Version One

Tools and Utilities: MS SQL, IBM DB2, TOAD, AJAX Data Loader, IBM Data Stage, AutoSys, COGNOS, Eclipse, Microsoft Visual Studio 2015, Selenium, Junit, TestNG Selenium IDE, Selenium Web driver 2.0, MS Office Suite, Microsoft Visio

Operating Systems: MS Windows 2000/XP/Vista/7/10, MS Server 2008, R2, 2012

Domain Knowledge: HealthCare, Pharmaceutical, Retirement & Financial, Telecom and Research

PROFESSIONAL EXPERIENCE:

Confidential

Software Development Engineer in Test (SDET)

Responsibilities:

• Designed and Developed test Automation framework for smoke and regression test suite of Confidential Connect using Selenium Web driver 2.0, Java Programming, Maven, Junit, Eclipse IDE
• Used Cucumber-Gherkin language to create scenario and scenario outlines in feature files.
• Identified test cases for automation using concepts like ROI, Reusability, Safety Risk Assessment into automation smoke and regression suites.
• Developed Automation Test Scripts using BDD and Page Object Model (POM) design approach with Selenium Web driver 2.0, Java and Excel for Data Driven testing.
• Performed backend testing of application by developing SQL queries, subqueries and joins for validating integrity and accuracy of data received via UI or reported via Manufacturing Dashboard, Client Reports and data feeds received from the clients.
• Created manual test cases using QA complete for FDA compliance 21CFR11 to control access of different user roles.
• Responsible to execute regression scripts and audit logs of various drugs for Risk Evaluation and Mitigation Strategy (REMS) of reputed pharmaceutical clients.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration
• Reviewed and Groomed business requirements and functional specification as an agile team player.
• Performed Manual, Functional, Positive, Negative, Integration, Regression, End to End, and User Acceptance testing.
• Used Version One for Agile story board as well as bug tracking.
• Followed Agile/Scrum Methodologies for all the project activities and attended daily standups, sprint reviews, planning, user story grooming and retrospectives.

Environment: Java, Maven, Selenium Web driver 2.0, Eclipse IDE, QA complete by Smart Bear, Version One, SQL Server 2008/12

Confidential

QA Automation Engineer/ Analyst

Responsibilities:

• Team player in automating highly transactional Salesforce web application PRUForce using Selenium WebDriver and TestNG framework, Java Programming and Eclipse IDE.
• Used CSS Selectors, XPATH expressions to identify web elements using plugins like Firebug and Fire path in Selenium.
• Developed Automation Test Scripts using Hybrid Framework, Page Object Model in Selenium Web driver using Java.
• Proficient in identifying test cases that needs either to be manual or automated by using concepts like ROI, Reusability etc.
• Participating in frequent release of applications by reducing the maintenance effort without compromising the quality of testing.
• Analyzed, Transformed, Validated and Integrated enterprise data warehouse information for various applications using IBM DB2, MS SQL, TOAD, AJAX Data Loader for proprietary and Non Proprietary Funds.
• Supported updates and enhancements of PRUForce (CRMODS DB), generating mapping and DDLs using forward engineering and reverse engineering of CA ERWIN.
• Involved in design, development, modelling and testing of customized payroll reports for various clients.
• Part of a team to build validation engine for incoming payroll files. A functionality to support, validation, helping to improve the data quality using IBM DATASTAGE.
• Involved in design, analysis, development and data base testing of compliance limit reporting on Plan Sponsor Web that comprised of various platforms like OMNI Mainframe, Enterprise Data Warehouse, ODS, Enterprise Service Bus and COGNOS.
• Created Manual Test Cases using HP ALM 11.0 and Tested PRUForce(Salesforce) a cloud based application fields, page layouts, record types, list views, queues, reports and dashboards
• Performed Functional (Negative/Positive), Comprehensive, Integration, Regression and User Acceptance testing.
• Used Rally/TFS for Agile story board as well as bug tracking.
• Participated in grooming, sprint planning, sprint review, estimation, retrospectives, standups and acted as backup scrum master.

Environment: Java, Junit, Selenium Web driver 2.0, Eclipse IDE, Omni Mainframe, CA Erwin, IBM InfoSphere, IBMDATASTAGE, COGNOS, IBM DB2, TOAD, SQL, AJAX Data Loader, MS SQL Server (CRM ODS), TestNG, HP ALM 11.0, TFS.

Confidential

Quality Assurance Engineer

Responsibilities:

• Involved in reviewing Business Requirement Documents and Technical Specification
• Effective communication with developers and business teams to understand requirements and develop test cases around the requirements, create data setup and scenarios and test the same.
• Developed SQL queries and Joins to validate reports.
• Perform defect validation as needed.
• Keep track of various metrics including percentage of script execution, scenario execution, regression testing and ad hoc testing
• Facilitate meetings such as joint application development (JAD) sessions to support the analysis process
• Involved in creating the test plan based on BRD and User Stories
• Used SQL DML to retrieve data and SQL DDL to update the information into database supporting tables.
• Involved in Defect tracking, test execution activities, defect reporting and analyzing test metrics.

Environment: QualityCenter9.0/10.0, SQL Server 2008/12, MS Office Suite, Microsoft Visio

Confidential

Software Test Engineer

Responsibilities:

• Worked with Business Analysts to collect requirements, discuss use cases to create test scenarios and test data.
• Created ETL Specifications, Flow Diagrams and artifacts using Business requirements document.
• Developed/Maintained test repository, executed test cases, logged defects, Retested defects with regression and generated various reports for detailed analysis.
• Performed Smoke, Functional, Integration, System and Regression of the IGO and eCRM web application
• Performed Database Integrity and reliability testing using SQL Queries for verifying the data recorded by the servers in the database.
• Participated in Defect Review meetings and Status meetings.
• Performed requirement analysis to prepared DTPS (Detailed test plan spec.)
• Developed and mapped test cases to requirement using QC.
• Guided offshore QA team in functional, regression and Integration testing.
• Delegated daily tasks to offshore QA team, and conducted status reviews on a daily basis.

Environment: Quality Center 9.0, SharePoint, SQL Server 2008, MS Office Suite, Microsoft Visio

Confidential

Responsibilities:

• Assisted in creating and managing the backend database for the Physical Experimental Research Institution.
• Created and executed queries for retrieving, analyzing and organizing Low Power Hybrid Tokomak Experimentation data on Plasma
• Involved in reviewing Research Requirement Doc. and the TDD for various Experimental Radio Frequency Generators, which included capturing, compiling, organizing, managing experimental data.
• Assisted in creating detailed data analysis for research in proposed plasma research projects.
• Created presentation and reporting to senior Physicists which supported making intellectual decisions.
• Worked with team members for impact and feasibility analysis for commercial plasma apps.
• Assisted Project team for planning, tracking, reporting team’s progress and status as per the schedule using Microsoft Project
• Actively participated in status meetings and interacted with project scientist team to discuss the technical and Project related Issues.

Environment: Test Director, MS Project, MS Office Suite, Windows server 2003, SQL server 2005, UNIX