SUMMARY

• Around 8 years of IT experience in Quality Assurance, Manual Testing and Software Testing of various business applications inClient Server, Data Warehousing solutions.
• Knowledge on the phases of agile methodology and traditional Waterfall methodology.
• Experienced in Functional testing, Regression testing, Smoke testing, Reports testing and data testing.
• Implemented and performed all testing activities in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC).
• Understanding of Data warehousing and Business Intelligence concepts wif emphasis on ETL and life cycle development. Using Power Centre, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in Mobile testing using various devices and platforms.
• Experience wif Selenium Grid for efficientautomationof multi - browser testing and Selenium Web Driver to drive web UI tests.
• Excellent noledge and experience in creating source to target mapping, edit rules and Validation, transformations, and business rules.
• Expertise in writing Test Plans, Test strategy reports, Test Procedures, Test cases, Test scripts, Defect status reports and Test Summary reports.
• Exclusive working experience HIPPA policies
• Gained good noledge on data analysis, loan processing, mortgage banking, customer service, after working in a financial institution.
• Having demonstrative noledge on load testing tools like load runner, neo load.
• Good experience wif report testing for BI.
• Proven ability in designing and creating automation frameworks using Java, Selenium WebDriver, Junit, TestNG, Appium, Protractor, Jasmine, Maven, ANT and Jenkins tools.
• Expert in Automation Testing (Selenium WebDriver), BDD Cucumber, Protractor Angular Testing and Manual Testing.
• Having noledge on Appium tool for mobile applications.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center, ALM, MTM, Jira.
• Creating RTM (Requirement traceability matrix) to make sure requirements are mapped correctly.
• Used Quality Center ALM, JIRA and MTM to track defects and to create defect reports.
• Experience in writing complexSQL queries for backend and Report’s data validations.
• Adept on database query tools such as TOAD, SQL Navigator and SQL Plus and SQL Developer.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Designed Manual test scripts and maintained in Quality Center ALM and MTM.
• Experienced in conducting crowd source testing.
• Experienced in maintaining healthy relations wif other teams wifin the organization, Customer and Technical organizations.
• Good interpersonal, communication, documentation, and presentation skills.
• Highly motivated to learn new technologies.
• Ability to interact wif developers and product analysts to gather detail testing requirements.

TECHNICAL SKILLS

QA Tools: HP - Quality Center/ALM, JIRA, Microsoft Test Manager, QTP, Team foundation server, Cypress

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/2012

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL Plus, SQL Server Management Studio

Web services: RESTful API, SOAP UI

ETL Tools: Informatica Power Center 9/8.x

Documentation tools: MS excel, MS word, PowerPoint, MS access, MS Visio

Programming Languages: SQL, XML, C, JAVA, C#, PERL

Operating Systems: Windows, Linux, Unix, Android, IOS

Automation tools: Coded UI, Selenium, Appium, Cypress

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg, PA

Software Test Engineer

Responsibilities:

• Created Test cases from DSD and updated all the test cases into MTM.
• Build selenium framework to create new test cases.
• Convert all the coded ui scripts to selenium scripts.
• Tested in two different environment SAT, INT.
• Created different suite in MTM for implementing the test cases under the suites.
• Created bugs in MTM and assigned to the related Developers. Once the bug is resolved condition, re-tested if everything is working fine according to the requirement close the bug.
• Tested most complex test cases in the project.
• Worked on SQL queries to validate the data
• Executed and created Regression related scenarios.
• Created large amount of data for client using codedUI and selenium.
• Developed Tractability Matrix to ensure that all the specifications are being tested thoroughly.
• Experience wif validating multiple browsers like google chrome and IE using selenium.
• Reviewed and analyzing Business Requirements Documents and the Functional Specifications.
• Tested myCOMPASS PA mobile application in Android, IOS platform on all new devices and tablets
• API testing (REST /JSON), API mocking (SoapUI), SoapUI assertions, JSON parsing in SoapUI.
• Worked as an Initiative POD lead.
• Worked on web services validation using REST and SOAP UI.
• PerformedQASmoke, Acceptance, Regression, Function, UI, Usability and Compatibility Testing.
• Created and executed manual smoke, functional, regression, system, integration, and exploratory tests based upon requirements
• Compatibility testing for embedded application software on various mobile devices, including smart phones and tablets.
• Participated inQAteam and Bug tracking or Defect Review meetings
• Build new selenium test scripts

Environment: MTM, Windows, SQL Server Management Studio, Oracle SQL developer, Microsoft Excel, Snag IT, TFS, Jenkins, Git, GitHub, Cucumber, BDD, Agile, HP ALM, .NET, ASP.NET, Selenium.

Confidential, Mechanicsburg, PA

Quality Assurance tester

Responsibilities:

• Worked wif a team on various Work Orders and Maintenance initiatives wifin the iCIS project
• Analyzing and reviewing Business Requirement documents/Functional Requirements and Use Case documents.
• Preparing Test strategy detailing test approach, data used, & test environments.
• Prepared high-level test scenarios and test cases.
• Created and executed system, regression, negative & positive test cases using Microsoft Test Manager
• Performed Regression testing using Microsoft Test Manager
• Executed test cases to determine the eligibility of various benefits and Manage Care Plans offered by DPW
• Experienced in determining the eligibility for various benefit programs like Medical Assistance, Cash Assistance, Long Term Living, Select Plan for Women, Family Works, Childcare works, Low Income Home Energy Assistance Program (LIHEAP)
• Preparing the Test results along wif data used to execute test cases.
• Worker collaboratively wif development and business groups to complete testing on project major releases.
• Worked on various initiatives wifin the iCIS project.
• Automated sanity tests, using a Cucumber BDD framework that captured all the high-level functionality captured in feature files.
• Experienced in Mainframe testing & batch testing
• Used Oracle SQL Developer to run the query to retrieve the data from the data base
• Responsible to validate the Eligibility Results
• Experienced in working wif data exchanges by calling web services
• Experience wif data driven and keyword frame works using selenium
• Worked on mobile testing of COMPASS app on IOS and Android devices.
• Worked on selenium TESTNG frame works to run regression scenarios.
• Experienced in validating the Client Notices that are generated through nightly batch process
• Responsible for defect logging and tracking using Team Foundation Server
• Implement test schedule, track defects and assigning them to developers based on the priority.
• Maintain defects report and status.
• Overall test execution report TEMPhas been maintained and reported to the management on daily basis
• Responsible for training new team members and go to person for functional questions
• Participated in supporting User Acceptance Testing (UAT), coordinated wif clients for better quality, developed user acceptance test plans and test cases, and coordinated user acceptance testing
• Supported in bug prioritization and analysis (UAT) to triage and provide the detail analysis on bugs

Environment: IBM Data Studio, Selenium, Compliance Sheriff, MTM, TFS, Windows OS, ASP. NET, HTML, XML, Visual Basic Team, Foundation Server, Selenium, Java, Jenkins, Git, GitHub, Cucumber, BDD, Agile, Snowflake, WebDriver, TestNG, MAVEN.

Confidential, Mechanicsburg, PA

Quality Assurance tester

Responsibilities:

• JIRA is used as the repository of the project. UsedJIRA Test Designing, Test Analysis, Test Execution and Test evaluation
• Extensively communicated wif QA, developer and business groups to gather information for effective testing
• Created new and updated existing test cases according to the business requirements and functional specifications
• Involved in writing and executing the Test Cases and reporting the bugsusing JIRAtool for Defect tracking purpose and worked until the issue is resolved
• Having good experience working wif Integrated eligibility (Medicaid, MCHP & CHIP) and interfaces
• Responsible for gathering information and transitioned the noledge to the team
• Exhibited flexibility and reliability by extending time and support to different initiatives and multiple state projects

Environment: JIRA, Windows OS, JAVA Platform, SQL Server

Confidential, Bellefonte, PA

ETL Tester

Responsibilities:

• Prepared the test case documents wif the help of BRD, FRS and other supporting documents.
• Attended walkthrough meetings wif the Business Analysts and DEV team to get a clear understanding of the business and the applications being used.
• Extensively worked on documenting understanding document and testing metadata based on
• Creating fact and dimension table implementation in Star Schema.
• Created test cases and queries to test the data move for business card data to load from source to stage and to target.
• Developed and designed test cases based on the Business Rules and Mapping Documents.
• Validated the data coming from various sources using SQL queries.
• Prepared Traceability Matrices to track the requirements wif the test cases and make sure none of them have been missed.
• Logged defects using HP Quality Center 10, linked defects wif requirements and generated Defect Reports in Quality Center.
• Checking log files in UNIX for back end exceptions and forwarding the same to developers.
• UNIX and Oracle are used in this project to write Shell Scripts and SQL queries.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Worked wif other members of the QA and Development teams and managed efforts wif offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call wif Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• Performed Report Testing by performing UI testing and writing SQL queries to validate the data on the report and compare wif the DWH data.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Retested the resolved defects/issues after the developers fix the defects.
• Updated the status of the testing to the QA manager, and accomplished tasks for the assigned work to the Project Management team regularly.

Confidential

Software Engineer - Testing

Responsibilities:

• Wrote Test Cases and Test Procedures based on the Test Plan.
• Analyzed project documentation and prepared detailed Test cases.
• Analyzed, understood, and estimated requirements.
• Designed & Implemented a Hybrid Test Automation Framework using Selenium WebDriver.
• Involved in the System and Integration testing.
• Performed Positive and Negative testing.
• Used Selenium WebDriver API to automate tests.
• Used Quality Center to create Test outlines and maintained Test scripts and created, modified, and debugged the Scripts.
• Used Quality Center to create Test outlines, maintained Test scripts; created, modified, and debugged the Scripts.
• Performed Data integrity testing by executing SQL statements and validated the tables in the database.
• Responsible for coding automated test cases using Selenium and modifying scripts as appropriate to the test case.
• Maintained custom project libraries for the common automation framework using JAVA in Selenium.
• Involved in Automation Feasibility Study for Web based applications.
• Performed Regression testing to check compatibility of new wif the existing functionalities using Selenium.
• Involved in Automation Testing Framework for web-based application using Selenium that maintains the workflow as an end-user.
• Reviewed database Test Cases according to assigned Requirements to validate reports by retrieving data wif complex SQL queries from SQL Server
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved in Meetings and walkthroughs and Responsible for weekly status.
• Setup /Installed and Configured Selenium IDE.