Project Test Cases

Location:

Posted:

May 15, 2019

Resume:

Career Summary

Over ** years of hands on experience in the field of Information and Technology with the emphasis on the Quality Assurance, Testing and support activities.

Excellent understanding of Software Development Life Cycle and Test Methodologies from project definition to post-deployment.

Worked in Agile environment for more than 4 years.

More than 4 years of experience with Test Driven Development (TDD).

Performed Manual Testing and experience in using automation tools such as Selenium, Test Partner, QTP, Win Runner and performance tools like Jmeter and QALoad.

Good experience in the successful implementation of Automation Test Framework.

Implemented whole life cycle of testing Methodologies starting from planning, creating, executing, reporting and tracking the defects.

Experience in writing test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements. Documented all phases of QA process.

Experience in identifying the Regression Test Cases.

Strong understanding of Agile methodology and waterfall models

Knowledge of VB Script.

Extensive experience in running various kinds of tests such as Regression, Functional, Performance, Backend, User Acceptance Tests (UAT) for Web (N-Tier) and Client/Server Applications.

Ability to collaborate with testers, business analysts, developers, project managers and other team members in testing complex projects for overall enhancement of software product quality.

Expertise in database querying, data manipulation and population using SQL& PL/SQL in Oracle and SQL Server.

Good knowledge of Data Warehouse concepts with Ab Initio, Informatica, Business Objects reports.

Self-starter and team player with excellent communication, problem solving skills, interpersonal skills and a good aptitude for learning.

Led testing teams both onshore and offshore and experience in leading and coordinating onsite and offshore teams.

Ability to understand & analyze business processes & workflows with the objective of providing recommendations for the best use of technology to improve the process.

Work closely with cross-functional teams to thoroughly test requirements and functionality.

Expertise in Bug tracking using Bug tracking Tools like Quality center/Test Director, Rational Clearquest, Testtrack.

Technical Skills

Programming Languages

C, C++, SQL, Java, Assembly Language (8085, 8086, TI LF 2407).

Databases

MS Access, Oracle9i, 10g, MS SQL Server 2005/2008, DB2

Web Technologies and Scripting Languages

VRXML, VARS, HTML, XML, ASP, JavaScript, VBScript.

Operating Systems

Windows 95/98/XP, Windows NT/2000, Unix, Linux, DOS 6.22

Bug Tracking Tools

Networking

JIRA, Bugzilla, HP Quality Center, Rational Clearquest,

Test Track.

TCP/IP, DHCP, UDP, OSPF, LAN/WAN, TELNET, FTP, HTTP and Socket Programming

Other Software’s

Adobe PhotoShop, MS Office 2000.

Reporting Tools

Business Objects XI R2, Brio 6.6.4

Packages

MS Projects, MS VSS.

RLC 2.X, ITC, FIX, TIBCO.

Performance Tools

MS SQL Server profiler, Jmeter, QALoad, Load Runner

Professional Experience

First Solar LLC.

Lead Quality Assurance Analyst

July 2018 – May 2019

First Solar is a leader in the development and manufacturing of thin film photovoltaic solar modules used in grid-connected solar power plants, as well as a provider of complete solar generation solutions for U.S. utilities.

Currently working on Android and windows based mobile applications for handheld scanning devices. These scanner applications are used to move Solar panels and pallets from shop floor into the warehouses and to verify the labels placed on these panels have the correct Module ID number.

Worked as a Business Analyst on several different Interface application developed in .NET platform to support the manufacturing processes. Creation of new stories in Azure Boards and adding them to backlogs for it to be discussed during Iteration planning.

Worked on VPN hardware upgrade project. This project was to upgrade the existing hardware and software and also consolidating the Active Directory groups for the entire company. My responsibility was to collect requirements and perform functional testing and support UAT.

Also worked on ITSI Splunk project that manages 1000 plus servers spanned over various geographical location.

Guided and assisted testers and UAT users on several SAP related project with setting up of project in HPALM, granting permission, uploading testing documents like Requirements and Test cases. And conducting daily defect meeting and providing testing reports to Project manager and key stakeholders.

Responsibility:

Creation of Testing documents like Test Strategy, Test plan.

Analyzed Functional and Business Requirements with the Business Users and Analyst and discussed Testing Procedure and Risks.

Played role of a Business Analyst and gathers requirements and helped business users during UAT

Attending daily scrum meetings and biweekly Iteration planning meeting.

Understanding the user stories and then writing acceptance criteria and test cases.

Environment and Data setup for conducting testing.

Writing Test cases in HPALM and mapping them to user stories and Requirements.

Automation of Test cases using HP UFT tool.

Testing of RESTful API using SmartBear tools

Testing of message using Queue Messenger

Performing backend testing and writing SQL queries to update and validate data in database tables.

Testing of Tableau reports

Mentoring and training team members on QA Methodology and how to use QA tools

Assisting with UAT and End to End testing

Creation on various testing reports like Burn Down graph, Test Execution report, defect reports.

Testing of ITSI Splunk application

Environment: .Net, Android SDK, Windows CE, Queue Explorer, HPALM, HP UFT, MS SQL2016, Azure Boards, Team Foundation Server, Salesforce, ITSI Splunk, SmartBear Ready API, OKTA, Pulse Secure.

Valassis Communications, Livonia, MI

Lead/ Sr. Quality Assurance Analyst

May 2016 – June 2018

Valassis a leader in intelligent media delivery helps clients of all sizes to optimize campaigns including direct mail, newspaper inserts and digital advertising to enhance the 58,000 local, regional and national clients’ return on investment. The advanced geography-based targeting allows RedPlum® media to reach 9 out of 10 households with national or hyper-local print programs and extend into nearly every neighborhood across the country with digital advertising.

Currently working on a mobile apps for cell phones and vehicle infotainment system where the coupons for nearby businesses including restaurants and will also provide the ability to call and make reservation.

Worked on several other application that is integrated with Salesforce for the CRM capabilities.

Worked on a Campaign Portal where clients can place their order directly via the website thus cutting down the time take to place an order and also saving the company on sales commission. The website where the clients register their accounts to access the site feeds data to Salesforce and Oracle ERP for account setup via REST calls. The clients can place orders on the website which flows into Salesforce and Oracle ERP via REST calls.

Also worked on the previous version of the above application where a client has to call the Sales rep. to create an account in Salesforce and place orders.

Worked on several other project like Integration of Telephony capability with Salesforce, website migration projects, new website launch and many more.

Testing of REST calls using SoapUI tool. Test data setup for backend testing. Data gathering/setup for UAT testing. Supporting UAT and conducting meeting with business to understand the business and also to help them complete their user acceptance testing. Conducting a daily defect calls to inform the status of past defects, triage and inform new defects found during testing.

Responsibilities:

Gathering detail business requirements for stories.

Creation of test cases for stories that will be delivered during each Sprint cycle.

Test cases are then classified as smoke, integration, regression and user acceptance test in Rally.

Data and environment setup for testing.

Setting up of QA tasks in Rally.

Attending the daily Sprint meeting.

Test case execution and updating the status in HP Quality center

Testing of REST API calls.

Performing backend testing and writing SQL queries to update and validate data in database tables.

Reporting defects in Rally/Excel/HP Quality Center.

Creation of reports and customizing the Salesforce pages.

Tested Oracle ERP based applications.

Communicating daily Progress reports for test execution, defect tracking to the project team.

Conducting training to users in how to use the new system.

Assisting in End to End testing and UAT testing.

Working with users to develop a plan for User acceptance testing (UAT).

Creation of Confidence report after each major release.

Environment: Salesforce, UNIX, FUSE, MS SQL, MS Access, SmartBear SoapUI, SmartBear LoadUI, CA Rally, Oracle ERP, Snag it, HP ALM.

Lochbridge, Detroit, MI

Lead/ Sr. Quality Assurance Analyst

Feb 2014 – May 2016

Lochbridge is an IT professional service arm of Compuware Inc. which was formed in the Year 2014. Lochbridge offers professional services to various industries both around Detroit and across United States.

Testing and managing a list of mobile vehicle infotainment projects for several vehicle themes from Cadillac, Chevy, and GMC to Buick for models Year 2017 onwards. These projects is going to bring a revolution in the vehicle infotainment world. The Infotainment head unit also called IHU will be interacting with the internet and will be able to download and install applications through the App store located in Infotainment system. The Infotainment will also support ecommerce for purchasing various packages and data plans. Conducting End to End testing, drive tests and user experience tests, gathering test results from various teams and reviewing test Execution plans and test results. Attending and conducting various meetings for defects, test execution status, and end of day test status and creating test related documents for greater audience.

Responsibilities:

Creation of test execution plan for each Sprint cycle.

Setting up tasks in JIRA for QA resources.

Gathering requirements for the story getting delivered during the Sprint cycle.

Writing Test cases and mapping to each story and business requirements.

Creation of test sets and assigning the task to other QA resources.

Attending the daily Sprint meeting.

Test case execution and updating the status in Quality center

Performing backend testing and writing SQL queries to update and validate data in database tables. Executing automated test cases created with Selenium framework.

Reporting bugs in JIRA and in Quality Center.

Communicating daily Progress reports for test execution, defect tracking to the project team.

Training and mentoring new resources.

Assisting in End to End testing, Security testing.

Working with users to develop a plan for User acceptance testing (UAT).

Creation of Confidence report after each major release.

Environment: Java, Windows NT, Unix, Toad, MS SQL2000/2005, JIRA, Oracle10G, DB2, Snag it, HP Quality Center/ Test Director, Exceed, Jackal, Selenium, Bugzilla.

CME Group, Chicago, IL

Lead Quality Assurance Analyst

Sep 12 – Feb 14

CME Group is the world's largest and most diverse exchange. CME Group offers market participants the opportunity to trade variety of futures contracts and options on futures contracts, primarily in seven product areas, including interest rates, Equities, commodities, FX, energy and metals, Weather and Real Estate. Every month there are new products added on CME exchange for traders to trade.

Worked on Re-Engineering of existing C21 Banking and Asset Management System (BAMS), with this new changes a firm will be able to submit their collateral updates through a csv file or through a FIXML file, and the process is fully automated where the firm will receive a confirmation when the file is successfully processed and when the changes are accepted by CME. Through this application a firm can deposit or withdraw their fund from an interest earning funds. Familiar with all risk systems dealing with Margin/collateral systems, portfolio based Haircuts and other reporting systems. Worked on other Clearing application like DeliveriesPlus where the deliverable products follow a particular schedule before it is delivered to its respective buyer. Also worked on reporting application for entire CME Clearing application which also includes Part 39 and Part 16 reports for CFTC on daily basis.

Lead a team of QA tester for project called COWS which is known as “CME group online web reporting system”. This is a Java based application with Oracle 10g as its database which is accessed by the clients through CME group portal. Designed and developed test cases and executed test case. Planned and executed regression testing for the application. Automated some of the testing efforts by test scripting in TestPartner and Selenium.

Responsibilities:

Attending Business Requirements and the Software Requirement Specifications meeting.

Analyze the requirements during the requirements analysis phase of the projects.

Conducted Test cases review meeting and walkthroughs for each Sprint.

Attending daily Sprint meeting and Sprint retrospective.

Test Execution planning and creation of time line.

HP Quality Center was used to develop a release management plan along with release and cycles and authoring test cases.

Executed test cases present in test sets within the test labs in Quality Center and opening defects through test lab.

Creation of various reports in JIRA and HP Quality Center.

Updating and executing the Automated test suites.

Creating a well-documented bug report in JIRA.

Participated in all phases of project delivery.

Escalated the issues about the project requirements(Hardware and s/w and resources) to the Project manager

Assigned task to all testing team members to ensure efficient use of QA resources

Conducted black box testing and backend testing.

Maintained and document all the Testing documents/artifacts and ensure that all assessment And design documentation is up to date and accurate

Assisted the integration and continued improvements of QA processes and Lead the Implementation of QA processes

Document, implement, monitor and enforce all processes and procedures for testing is Established as per the standards defined by the organization

Defect management is done through JIRA and Quality center right from entering defects to fixing and closing them.

Worked and used on software quality assurance methodologies.

Prepared and reviewed various reports prepared by the QA team members.

Mentoring and training Quality analysts.

Environment: Java, Windows NT, Unix, Toad, MS SQL2000/2005, JIRA, Oracle10G, DB2, Snag it, HP Quality Center/ Test Director, Exceed, Jmeter, Selenium, Bugzilla.

Benefit Concepts Inc., Toledo, OH

Sr. Quality Assurance Analyst/ Lead

Mar 10 – Sep 12

Benefit Concepts is a national reputation as a leading provider of employee benefit administration services for over 2 decades by using a highly personalized, service-oriented approach. The company does administrating of FSA, COBRA, Active benefits and Transit accounts for more than 750 clients. The benefit administration is completely automated so a participant can submit a claim, upload the documents and also pay their dues online.

Currently working on a project to retire the legacy COBRA payment and benefit administration system into a .NET web based application build on .Net Framework 4.0. Along with the current project I am also a tester/coordinator to one of the project that has an external vendor helping in rebranding the benefit administration website. Previous to these projects, I have worked on several different projects like the Interactive Voice response system (IVR), coordinating testing with the Dept. of Health for one of the Compliance project. Introduced and implemented QA processes and testing framework for improving the QA testing efforts.

Involved in improving the performance and upgrading the .Net framework to version 4.0 and upgraded the web pages that were using VB components and .asp extension to aspx pages.

Responsibilities:

Analyzed Functional and Business Requirements with the Business Users and Analyst and discussed Testing Procedure and Risks.

Implementing QA process and testing framework.

Managed testing efforts on multiple projects.

On site coordinator to help and approve test cases and help with issues and conduct daily meeting.

Developing of Test plan and other testing deliverables.

Attending projects meeting and walkthrough.

Coordinated the project release effort.

Identified requirements and wrote test cases in Test Track for software development projects by decomposing functional design documents and information provided during analysis.

Created a traceability matrix in Excel for each project which involved matching the requirements to test cases and also included test assignments.

Conducted test cases review meeting as a test case approval process.

Executed Manual test cases and automated test cases

Updating the automated test suite to incorporate new features and changes.

Test track was used for test case creation, Bug reporting and Tracking.

Created Test data by adding, deleting and updating the database table data in SQL server 2008 using SQL statement.

Wrote and executed complex ANSI SQL queries for test case validation.

Test Matrices were also created for identify testing for various Security Roles.

Performed black box test, smoke test, security test, system test, integration test and end to end test.

Helped users with User Acceptance Testing.

Data collection for Interactive voice response project to assist 3rd party vendor with their testing.

Involved in training users to use new applications.

Performance analysis of the SQL and stored procedure using MS SQL Server profiler.

Tested and executed the Batch process and troubleshooting issues involved during the batch process by checking the issues in various log files.

Daily updated the project team with the progress of testing efforts.

Attended bug reporting meeting and escalated issues that needed to be addressed in timely manner for the success of the project.

Environment: ASP.NET, MS SQL Server 2008, IIS 7.0, TestTrack, Sourcegear Vault, .Net Framework 3.5, .Net Framework 4.0, Microsoft SharePoint, MS SQL Server profiler, Jmeter, Badboy .

CME Group, Chicago, IL

Sr. Quality Assurance Analyst/ Lead

Sep 06 – Mar 10

Worked on NYMEX integration project also called Product Reengineering. The project main goal is to retire C21 and C22 Mainframe systems and the generation of products, venue selection and IXM creation are moved from Mainframe to Distributed side coded in Java. The Agile methodology was used in the successful completion of the project.

Involved in testing Equotes application. This application has lot of other features like TIME and SALES, Alerts, Market depth and many more.

Was a part of CME.com web portal migration and CMEGROUP website projects. Involved in test plan creation, developed detail test cases and executing them. Performed performance testing on the websites. Conducted failover testing of web server and database servers.

Was involved in testing applications like My Ecommerce where I was testing purchasing of various products like Equotes, Datamine 1.0 and 2.0 products and Educational courses.

Responsibilities:

Understanding and Analyzing the User/Business Requirements and the Software Requirement Specifications (SRS)

Analyze the requirements during the requirements analysis phase of the projects.

Contributed to improving existing QA practices in order to be more effective in the project delivery cycle like optimizing the regression suite.

Prepare the Test plan for the projects.

Conducted Test cases review meeting and walkthroughs.

Involved in various meetings with Business Analyst, Architects and Developers.

Test Director / Quality Center was used to develop a release management plan along with release and cycles.

Identifying the functional and performance requirement along with their priorities and entered into the Quality center.

Executed test cases present in test sets within the test labs in Test director and opening defects through test lab.

Maintaining a daily test execution log and status report using various graphs like coverage progress report and quality report like defect opening rate and outstanding rate were generated to check the progress of testing and quality of the application under test.

Updating and executing the Automated test suites.

Creating a well-documented bug report on daily basis through Quality center.

Participated in all phases of project delivery.

Escalated the issues about the project requirements(Hardware and s/w and resources) to the Project manager

Assigned task to all testing team members to ensure efficient use of QA resources

Conducted black box testing and backend testing.

Wrote various complex queries both in Oracle and MS SQL 2000/2005 using joins like inner, right join, left join and dropping and creating the table using conditional If statement with data populated from production.

Organized the meetings and prepare the agenda for the meetings weekly basis.

Maintained the project status reports and frequent status checks of the projects.

Acted as a single point of contact between development and testers and testing and development activities

Clearly communicated testing status and issues by writing status reports, attending meetings, interacting with project team members, escalating issues and producing accurate QA deliverables on schedule.

Assisted in performing the application maintenance and resolve the issues.

Maintained and document all the Testing documents/artifacts and ensure that all assessment And design documentation is up to date and accurate

Assisted the integration and continued improvements of QA processes and Lead the Implementation of QA processes

Document, implement, monitor and enforce all processes and procedures for testing is Established as per the standards defined by the organization

Quality center was used to create a test set for the every cycle in a release and then execute the test runs and update the result of the test run.

Defect management is done through Quality center right from entering defects to fixing and closing them.

Escalated the issues in the application to the client

Worked and used on software quality assurance methodologies

Prepared and reviewed various reports prepared by the QA team members

Managed a team of 2 quality assurance testers

Check for timely delivery of different milestones.

Environment: Java, Windows NT, Unix, Toad, MS SQL2000/2005, Oracle10G, DB2, AQT, Snag it, HP Quality Center/ Test Director, Exceed, QADirector, TrackRecord, QALoad, Jmeter, Exceed, TestPartner, Selenium.

Allstate Insurance Company, Northbrook, IL

Sr. Data Warehouse Analyst (QA)

Sep 04 – Sep 06

Worked as a Sr. Data Warehousing Team Lead/test analyst/ trainer for various projects belonging to various Allstate department like Finance, Claims and Protection. The main objective of these projects was to move all the active records of customer residing in 60 tables in DB2 to Oracle. The project is been accomplished in 2 phases again each of these phases have multiple sub phases. Also worked on Data warehousing projects like LRS, Medman, Special Investigation Unit and many more. All the application was build on Ab Initio tool. Wrote QCP, Test Plan and Test Cases in Test Director as per the Business Requirements document. For data compare and validating transformation logic for millions of record used Ab Initio to develop breadth and depth compare graphs. Tested and developed a Business Intelligence reports using Business Objects to help end users to access their reports through Internet

Responsibilities:

Lead a team of 20 testers both onshore (4 testers, Northbrook, IL) and offshore (16 tester North Ireland) for various projects including Data warehousing, Brio and Business Objects.

Created Project plan and handled resources for the 16 hour project model.

Attending meetings and communicating the status of projects to the upper management groups..

Setting up daily meeting and weekly meeting with the team to find out the process with their respective tasks. Listening to any issues and getting it resolved from the responsible people.

Attending design and code review meetings to understand the flow of the application being developed.

Involved in data acquisition for testing the application.

Developed Quality Control Plan (QCP) that defines the scope and risk involved while testing.

Captured all the requirements in Test Director.

Attended, reviewed and wrote Test cases in Test Director.

Executed manual test cases through Test Director.

Reviewed project’s ETL designs, graphs, and test plan in multiple sessions exercising improvements in design and functionality.

Performed Ab Initio code migration from Dev box to QA box to PreProd to Prod box using air tag commands.

Wrote test plan, test cases and maintained traceability matrix for Business object reporting projects.

Setup of environment in QA box to execute the Ab Initio graphs like checking the config file whether its pointing to the correct schema and has the right access to execute.

Involved in Testing from different source database like DB2 to Oracle Enterprise Data Warehousing using Ab Initio.

Tested the Ab Initio components developed to extract data from mainframe Db2 either by MDG or Xcom push or pull process.

Validated the EBCDIC data received from DB2 in UNIX using the various Ab Initio commands like m_dump or creating Ab Initio graphs.

Executed the graph in UNIX prompt and checked the log file for any error or warning messages

Executing the scripts to run the Ab Initio components and then validating the Transformation logic as defined in the transformation documents.

Checking whether the script that executes the Ab Initio components to load the stage table is working properly by validating various objects.

Writing SQL queries in SQLplus in UNIX or in Toad to validate the data.

Developing compare graphs using various components present in GDE like GATHER used to fetch data from multi-file (MFS), REFORMAT, Input and output file, Partition by key, Sort, Rollup, Filter by Expression and many more.

Used EME (Enterprise Meta Environment) for version control of the graphs and components, VSS (Visual Source Safe) and WSS for version control for testing documents.

Extensive use of Phases and checkpoints while developing graphs.

Written complex SQLs using joins, sub queries and correlated sub queries.

Tested flashback queries in Oracle 10g.

Executed the graphs through scheduler in Pre-PROD environment.

Coordinated as a Team lead for a BO Reports team of size 8 for report migration from Brio to Business Objects.

Defect management was performed in Quality Center.

Environment: Mainframe, Solaris UNIX, Ab Initio (GDE 1.13, Co>operating system 2.13 with EME) Oracle 9i/10g, DB2 SQL, PL/SQL, Shell Scripts, Toad 8.0, MS VISIO, Microsoft VSS, MS Project, Test Director.

Capital One, Richmond, Virginia

Sr. Data Warehouse Analyst (QA)

May 04 – Sep 04

The Adjacent Lending Platform (ALPs) program will establish a new corporate loan-servicing system to enable the second leg of Capital One’s corporate strategy-Diversified Lending. The goal is to design, develop and test the fundamental operational, analytical, and technological infrastructure for a platform serving the current and future needs of non-Card lines of business offering installment loans, including Domestic IL, Small Business, and Auto Finance. Testing will consist of Unit, Data Migration, System, Integration, Financial Assurance Testing, Security, User Acceptance, Performance, and High-Availability Testing. The testing scope of this project is based on workgroup package submission like Loan boarding and Fulfillment, Small Business, Payment Plus, Customer Service and Collections.

Responsibilities:

Managed 3 test analysts who worked with me for Domestic IL module.

Created a testing project plan for the ALPS project.

Conducted weekly status report meeting and daily email status update.

Communicated to upper management on the team progress.

Attending code and design review meeting.

Business requirement analysis, System Requirement Analysis, Business Model analysis.

Designed and developed tested and documented Ab Initio graphs output.

Loading and Unloading data files from Oracle and DB2 database using Input Table and Output Table components of Ab

Contact this candidate