PROFESSIONAL SUMMARY:

• 6 years of IT experience with emphasis on Quality Assurance and data analysis in Finance &Mortgage, Banking, 508/WCAG complaints Federal projects, Health care, Event Management and Telecommunication domains
• Experience in Software development life cycle (SDLC) including user Interaction, Business Analysis, Implementation, Documentation and risk analysis, Testing, Production or Customer Support on Data base Applications, web services, Client Server, BDD and GUI application.
• Extensive experience in using Agile/scrum, Waterfall, Kanban models.
• Hands on experience in Test Plan, Test Cases Design and Execution both in Manual and Automation.
• Extensively worked in Integration, Functionality, Regression, Database, Compatibility, User
• Acceptance, System Testing and End to end testing
• Experience in analysing test results and submitting the bugs using Bug Tracking Tool Quality Centre (QC) & Team Foundation Server (TFS)
• Experience with JAWS Screen reader testing.
• Worked analysing data from problem reports to determine Root Cause and Corrective Action.
• Worked in Mobile testing for Mac, android devices.
• Proficiency in recording, modifying and executing the test scripts using Automation Tool -
• QTP.
• Analysis and review of Software and Business Requirement Documents
• Ability to test back-end applications by writing SQL statements.
• Good knowledge in UNIX shell script and Perl.
• Participated in Testing Methodologies like Planning, Analysing, Execution, Bug Tracking
• Ability to meet tight deadlines with flexi working hours.
• Experienced in developing Relational database using Informatica ETL Tool from the Specifications.
• Designed Sequel queries to test the database with dummy values in SQL Server.
• Good knowledge of ETL and Data quality tool - Informatica, Trillium software.
• Expertise in delivering the product with utmost quality without any post-deliverable defects.

TECHNICAL SKILLS:

AUTOMATION QA TOOLS: QTP 10.0/11.0, Load Runner, Selenium IDE, Cucumber Gherkins, SOAPUI, Nexus, Jenkins

TEST & BUG TRACKING TOOLS: HP Quality Centre 10.0, JIRA, SharePoint, TFS, JAMA

DATABASE: Oracle11g, Teradata, SQL Server 2010/2007/2003 , RDBMS, Rapid SQL, PL/SQL, SQL developer, MS SQL Management Studio

SCRIPTING LANGUAGES: VB Script, SQL, UNIX/LINUX, Perl

ETL: Informatica, Trillium Software, Xml spy

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Quality Assurance Engineer

Responsibilities:

• Developing test plans, Epics and guidelines based on Agile and Kanban methodology.
• Developing test case document and execution suite in qTest document management tool from the user stories for WCAG/508 complaints, functional and regression testing.
• Responsible for planning regression, automation and smoke test stories in everySprint.
• Performing 508 compliant verification testing manually and reviewing technical requirements of software
• Performed GUI functional and sanity testing manually for each new build of the application
• Performing Integration testing, UAT, smoke testing, database, functional, regression testing for the Confidential internal tool.
• Responsible for thorough testing of browser and platform compatibility issues
• Using JAWS, WAVE, WEB-Accessibility tool bar, and Dragon software for 508 compliance testing.
• Test GUI functionality on Android and iOS
• Communicated defects encountered during regression testing; worked with developers until all issues resolved.
• Using JENKINS for scheduling build automation using calendar scheduling and Cron expressions
• Used Postman for Backend API testing
• Using JIRA for defect logging and tracking purposes.
• Developing Cucumber-Gherkins test scripts for automation team.
• Performing Cross browser testing for the 508 complaints sessions.
• Performing Security and Mobile testing for US federal agency projects.
• Performed UAT, regression, smoke testing for product release and involved actively in release management activities.
• Participated in JAD meetings and gathering business requirements with the requirement team and developing requirement artifacts.
• Responsible for transferring the knowledge about tasks from recent Sprint to other Testers in the QA team.
• Participating in daily stand-up meetings, project status meetings as well as retrospective meetings and iteration reviews.

Environment: Maven, Eclipse, JIRA, QTest(document Management), Jenkins, UNIX, Postman API.

Confidential, Riverdale, MD

Senior Quality Assurance Tester

Responsibilities:

• Analysing the functional requirement document and writing integration and functional test case document based on Agile-Scrum model.
• Reviewed requirement document and involved in developing QA test plan document
• Performing smoke testing, functional testing, and regression testing, and end to end testing for new change orders/build.
• Performed Credit card rebill processing using UNIX batch jobs for huge data on scheduled timeslot.
• Performed performance and cross-browser testing for Siebel and web applications
• Developed functional and regression test case for EZ Pass iOS/Android Mobile versions.
• Automated the account creation process in EZ Pass web application using the Selenium automation tool.
• Interacted with business analysts and developers for bug reviews and attendedQAmeetings
• Took ownership of important modules and detected high severity defects.
• Developing SQL Queries to perform Database testing.
• Prepared documents for the new application.
• Responsible for managing off shore/onsite team (team of 6) and reviewing the test scripts developed by Jr. QA Testers.
• Daily coordination with onsite team, preparation of daily and weekly status report
• Maintain and present the test metrics of all the projects in the account and take part inQAaudit.
• Used JIRA, JAMA for defect tracking, test script maintenance.
• Conducting weekly meetings and involving in the meetings with the development and build Team every week and as necessary.
• Performed User Acceptance Testing (UAT) for Java application at the end of the test phases with the requirements collected from the user.

Quality Lead/BA

Confidential

Responsibilities:

• Involved in generating Master Test Plan, which had all complete information about the Test Strategy involved in verifying the functionality of the application.
• Analysed the requirement document and created test scripts and scenarios for the Easy pay application NY and NJ agencies.
• Analysed business requirements, conducted gap analysis and worked closely with developers in different time zone to deliver quality output.
• Involved in Designing, Developing and Managing the QA Process, conducting JAD meetings to analyse the business requirement with the stake holders and requirement team.
• Performed functional testing, smoke testing, and end to end testing for Confidential web applications.
• Performed alpha testing, delivered thorough QA testing reportsthat determined product quality and release readiness to the end users and clients
• Performed User-acceptance testing and defect tracking for three new software releases
• Processed the automatic rebill batch jobs for huge data for customer accounts.
• Extensively used JAMA test management tool to manage and execute test scripts.
• Interacted with the project team to assign priority to deliverables based on dependency and criticality.
• Creating and executing Test Plan for automating QA efforts, including automated test passes, bug verification, and test environment configuration.
• Performed verification and validation testing prior to CAT testing
• Performed EMV (terminal emulator)device testing for both Confidential and EZ Pass application using physical EMV and billing devices

Environment: JAMA, JIRA, SharePoint, Selenium, Jenkins, PL/SQL, UNIX

Confidential, Mclean, VA

Sr.QA Tester

Responsibilities:

• Writing test case based on Agile and Kanban Model
• Automating API test cases using SOAPUI Tools
• Performed analysis of business rules, business and system process flows, user administration to be used for the new merged platform
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Perform analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis
• Gather data required to conduct analysis from several sources, compile it together in prescribed format and enter the data in several data analysis software
• Developed functional and regression test case for website and iOS/Android Mobile apps.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Performed UAT testing on the application in testing, staging, and production silo environments
• Created test case and worked intensively on system testing, end to end testing and UAT testing on the application.
• Performed end to end testing of various functionalities of the products like Ticketing, Payments and Surveys tabs in Event Management application and test the interaction of the application with external systems before product deployment
• Used Selenium and Soap UI for automation and API testing.
• Performed Functional Testing in QA, Staging, Pre-production and Post-production builds.
• Preparation or review of all quality documents.
• Verify that the business logic, rules and strategy are correctly applied.
• Performing Mobile testing for Mac, Android devices
• Performing Cross browsing and Multi browsing testing manually for application verification.
• Performed Component Integration, Regression and End to End testing to ensure readiness for user acceptance testing
• Working Production support team and verify the issues based on severity
• Involved in Back log discussion session and contributed to the improvement plans
• Coordination with Team lead, project manager, BA, DW architect, Developers on daily scrum meetings to deliver quality product and to ensure RTM is completed.
• Involved in preproduction review of all projects. Being part of review meetings to resolve bug, related issues with developers.

Environment: Soap UI, UNIX, SQL, SharePoint, JIRA, Jing, QTP, CBT tool, Mobile testing, SPLUNK, Rational DOORS, JAWS, Jenkins.

Confidential, Germantown, MD

QA Tester

Responsibilities:

• Developing test plan and test strategy and RTM using MS Excel.
• Review of the test cases written for unit and integration level.
• Reviewing requirements, submitting defect tickets and generating Test Summary Reports for each release.
• Scheduling and scripting jobs using crontab in UNIX environment in satellite security management.
• Developed and executed the test cases for the central logging system of the satellite networks, user interface systems.
• Performed installation of various user interfaces in satellite communication system
• Performed batch processing using Cron tab to automate the data loading in database system.
• Performing functional testing, regression testing, performance tests, and security testing to ensure proper user roles are being assigned to the corresponding groups in User Authentication module of the Network management system
• Performed End to end testing before product deployment
• Provide support in developing and maintaining ETL processes that extract data from multiple sources residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Used ticket system with priority to ensure data quality.
• Involved in release planning meeting before the release and prepared the documents for the team to follow the testing during production.
• Performed UAT Testing on the web-based application.
• Used QTP for automation testing.
• Developed QTP scripts to automate functional test cases.
• Supported database systems for the User interface - Visualization Beam Map tool.
• Smoke tested and regression tested applications after defects were fixed.

Environment: Soap UI, Quality Centre, SharePoint, JIRA, QTP, SQL server, SPLUNK, Syslog, Jenkins.

Confidential, McLean, VA

Data Quality Analyst - ETL

Responsibilities:

• Involved in gathering requirements and analysis for applications.
• Developed test Plans, test Cases, test Scripts for UAT tests
• Responsible for analysing and translating business requirements for the development of business rules for business units, identifying and documenting business rules and creating detailed Use Cases
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Based on the ETL specification, loaded the data source to database and performed post - protection testing to ensure the data load in target.
• Involved and tested original Mortgage Amount data from Loan IQ (Mortgage Amount, Mortgage Terms), tested the data elements that should follow the calculation logic in the legacy Purchase application and stored procedures
• Writing SQL queries, generating reports to ensure data integrity and validating business rules
• Created Test Cases in Quality Centre and RTM and mapped Test Cases to Requirements.
• Managed and conducted System Testing, Integration testing, Functional testing, UAT and Regression testing.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Developed SQL scripts and used UNIX for backend testing.
• Used UNIX scripts for running Autosys job in putty.
• Used shell scripts extensively for automation of file manipulation and data loading procedure.
• Execute batch processing and verify the jobs status and data in database tables
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing.

Environment: Rapid SQL, Quality Centre, SharePoint, IBM-DB2, Rational DOORS

Confidential, Maryland

Quality Tester

Responsibilities:

• Understanding the SDLC as well as testing methodologies and objectives.
• Analysing the functional flow of the new enhancement and Business Requirements to check the impact on the existing system
• Creating and updating the Traceability Matrix with the time lines required with planned dates.
• Creating the Test Scenarios and Test Scripts as per the formats required.
• Performing Smoke testing, Unit testing, Functional testing, Regression testing on the new builds by executing the test scripts manually.
• Performing regression testing on EZPASS Web application and reaching deliverables on time.
• Executing the change orders and logs the functional defects in the JIRA Application.
• Maintaining logs in QC, SharePoint for future s.
• Making recommendations to improve performance, minimize risk, and improve the customer experience
• Impart to the new team members to help them cope up with the existing process and functionality

Environment: Siebel CRM Application, Oracle 9i, PLSQL, Crystal and Oracle, SharePoint, Manual testing, Quality Centre, JIRA, JAMA.

Confidential

Data Analyst/Tester - Data Warehousing

Responsibilities:

• Analysed the System specifications and Business Requirements for full understanding of the Business and involved in Database Development process using ETL Tool- Informatica.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Prepared Test Data for executing positive and negative scenarios.
• Designed and developed Test Plans and Test Scripts for the Functional, System and Regression testing.
• Involved in Manual Testing of the application using QC and established baseline Scripts.
• Used QC for managing test execution and Defect Tracking of all issues.
• Involved in Database testing using SQL Queries.
• Executed database queries in Teradata to check and compare the values in the database.
• Used SQL Server to test the database with dummy test data and reported the results in Excel to the On-site Manager.
• Scheduled Meetings, attended Walkthroughs interacting with developers, QA lead and Project Managers.
• Writing Functional Test Cases
• Test Case Review and designs.
• Involved in Database development and maintenance
• Used Informatica ETL tool for developing database and tested the database with test data and reported the results to the Onsite Manager.
• Developing the Test Script using Manual Testing
• Executing the Developed Scripts using QTP.
• Performing Smoke, Sanity, Regression and Exploratory Testing on New Released Builds.
• Reporting the Bugs using QC.
• Used SQL to test the database and documented the reports to the On-site Manager.
• Executed queries in Teradata.
• Back up data, Copy/Restore data, validation of historical loads, Rejection Processing.
• Tested Target Load Order Plan and Constraint based loading for loading data correctly into different Target.
• Experienced using SQL Developer query tools for Oracle to validate reports and troubleshoot data quality issues.
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Attending Client Telecom. Meetings on Weekly Basis.
• Preparing Daily, Weekly and Monthly Reports Pertaining to the Product Testing Process.
• Having Very Good Interaction with the Client Team to have more info. About the New Released Build.
• Analyzed data and user requirements
• Specified, designed, developed, and implemented contact cleansing and consolidation solution using the Trillium tool suite, Oracle, and UNIX to support Toyota Customer Relationship Management needs.
• Worked along with the Database development team in Informatica ETL Tool
• Designed and developed business name and address cleansing and matching process for 2.2 million business name and address contacts including de-duplication and interactive matching using Trillium batch software suite
• Work included: all external feeds, contact dimensions, quality assurance, Trillium (data cleansing & matching) technical support
• Used Quality Centre for reporting and getting updates, changes made on the database.
• Gathered requirements from business users and technical staff across enterprise for data quality needs that can be supported by new Trillium 11.5 version.
• Prepared requirements and design specifications.
• Estimated level of effort based on actual work to meet requirements.

Environment: Informatica, Teradata, Oracle, SQL, Quality Centre, Manual testing, Trillium software.