Test Cases Data

Meena V Pothapragada

**** ******* ** ** ****** GA 30080

Email: **.*****@*****.***

Phone : 484-***-****

Summary

Over 9 years of Financial, Banking, Insurance and Supply Chain Management Industry experience as Software QA engineer and QA Lead. Expertise in writing and executing test plans, test scripts and test cases and performing GUI Testing, Functional, integration, Regression, System, and Performance testing

Ability to manage multiple test events at a time (e.g. functional QA testing overlapping with E2E) and multiple projects at a time

Strong understanding of Agile/Waterfall/ incremental software development and Business Analysis practices.

Strong Manhattan Warehouse Management experience along with Integration experience with packaged TMS/WMS systems, VoCollect/RF devices and DOM of Manhattan

Worked extensively with Sourcing and Allocation rules and templates in DOM web application testing

Worked on Client server, Web based, ETL and Java Applications

Thorough work Experience and knowledge of Sterling and Web Applications interacting with multiple Platforms

Strong working experience on web Applications using Web Service (SOAP) and WSDL

Expertise in testing Application integration Technologies ESB

Experience in debugging and executing automated test scripts and performing manual testing

Basic understanding and working knowledge of UNIX, LINUX and Shell Scripting

Exposure to QTP for .Net, and ERP applications for functionality testing

Received training in UFT and Selenium. Used the tool effectively for automating various business processes and running the automated scripts

Good experience in reporting, tracking bugs and documenting as well as following up tasks with tools like Microsoft Team Foundation Server – TFS, HP –ALM

Extensive experienced in using HP –ALM to develop test plans, test cases, run tests and report/track defects

Working Knowledge in Tableau Desktop

Ability to create data reconciliation reports using Tableau Desktop by merging data from various sources and testing BI reports for data validity

Thorough knowledge of all phases of Software Development Life Cycle (SDLC) and (STLC) Software Test Life Cycle.

Worked thoroughly in waterfall, Agile, Extreme Programing and Iterative Software Development Processes.

Proficient in writing and executing SQL queries for backend testing

Good understanding of Java, VB, XML, HTML, SQL, and JavaScript

Inclined towards building a strong team/work environment and can acclimatize to new technologies and situations with ease.

Capable team player, detail-oriented and motivated individual with strong analytical and exceptional communication skills

Excellent verbal and written communication skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts.

Skill Set

Languages

C, C++, TSL, SQL, UNIX, LINUX, Shell Scripting

Web Technologies

JSP, Servlets 2.0, Java, JavaScript, .net, VB 6.0, classic ASP, HTML, DHTML, XML, web Services, SOAP, Flex

Database

Oracle11g, SQL Developer 4.0.3, SQL Server 2000, DB2, MongoVue 1.6.9, MS Access

Testing Tools

WAPT, BadBoy, Defect tracker 2.1.6, Mercury Interactive Tools: Win Runner, HP ALM, UFT 12 Quality Center 9.2, Quick Test Pro 8.2, Data Stage,Jitter Bit 4.0,Load Runner 8.1, Silk Test Work Bench 13.5,Silk Classic,UFT 12, Selenium Web driver 2.53.1, WMS 2012,Db Visualizer 8.0.9, Hermes v 1.1.4, Tableau 8.6,

Platforms

Windows 9x/NT/2000/XP

Front End Tools

Visual Interdev, MS Front Page, MS Excel.

Browsers

Internet Explorer 5.0/6.0/7.0/11, Netscape Navigator 4.x /7, Mozilla Firefox 10.0, Google Chrome

OperatingSystems

Windows 7, Windows 9x/NT/2000/XP, UNIX

Server Scripting Language

VBScript, TSL

Professional Experience

Employer

Symbiosis InfoTech

Environment

Win 7, IE 11, Java, Oracle 11g, XML, Db Visualizer 8.0.9, SQL Developer 4.0.3, SOAP UI, ESB, WSDL, MS Office, Web Services, Hermes v 1.1.4, UFT 12, Selenium Web driver 2.53.1, HP ALM, SharePoint, Confluence, Manhattan WMS 2012, Manhattan DOM,

Role

Senior QA/QA Lead Analyst

Duration

February ‘15 – Current

Responsibilities:

Project at The Home Depot process required integrating WMS and Web Application with Agile Testing Methodologies for Parcel routing and printing of shipping labels. Worked with 10 offshore resources by coordinating and collecting daily matrix report to accomplish the job.

Ensured that test plans and scenarios fully exercise every aspect of the product

Conducted and participated in test case reviews, requirement reviews, design reviews and change control activities

Responsible for uploading and maintaining all testing documents as well as TSR(Test Summary Reports) in SharePoint

Worked on Agile Methodology of ATDD and DevOps – by integration of test execution plan with project plan and providing Business as well as development teams with test Scenarios

Prepared test flows with User Stories in Agile Methodology working closely with team of Business Analysts, Developers, Architects and executed Functional and System Testing as a Team

Did integration testing of Intelligrated WCS and WMS web Applications by verifying diverted xml messages using notepad + +

Wrote and executed SQL queries to acquire accurate test data as well as for validation of test results

Dropped xml messages in middle ware – MIF and FMW and posted orders in Manhattan DOM web Application by using tools like Postman

Gradually replaced manual Order creation with UFT and then by Selenium working closely with Automation team and running the scripts

Pricing validation is done via API Tester by calculating discounts, taxes, coupons and promotions with formulae derived from BRS and SRS documents

Validated various calls from third party systems by comparing data from source website and current application using SOAP UI – like Address and Tax Validations

Also, Used SOAP UI to test Proxy Web services to Validate data between middleware and Web Application

Automated functional and system validation in Web application like Order processing, Order updates and Returns using UFT Modules

Performed manual testing on Sourcing parameters of Watermark, Manage Capacity and Balance Workload in regard to allocation of inventory to Facilities via Web Application

Took advantage of unattended automation execution there by increasing the speed and efficiency during monthly Releases and Change Requests.

Used LINUX during Integration testing to validate messages flowing in different systems

Executed test cases, prepared Test Metrics and daily status reports using HP- ALM

Provided data and assisted in User Acceptance Testing thereby improving UAT experience to Business

Performed End to End Testing which involved testing of WM and all upstream and down Stream OMS applications

Provided business training and step by step analysis to Automation Team for developing Automation scripts with Selenium and UFT 12.0

Responsible for certifying Automation scripts in terms of accuracy and completeness of Functional testing

Used automated regression test scripts extensively to execute the regression test bed and during new code drop to report results immediately

Prepared and maintained KT documentation for onboarding new analysts and for retaining information for staff roll-off

Created and contributed to the creation of RTM s (Traceability Matrix), test plans, test cases, test scenarios, and test data for use during different testing phases, for new and existing software systems/products while coordinating and leading the QA team

Employer

Symbiosis InfoTech

Environment

Win 7, IE 7,IE 9, 11, Mozilla Firefox 10.0, UNIX, AS400, Java, JavaScript,Flex,EDI,.Net,Ms Access, Oracle 11g, XML, Jitter Bit 4.0, Data Stage 9.1, UFT 12, Db Visualizer 8.0.9,SOAP UI, Service Mix ESB, WSDL, MS Office, Sterling 8.5,PKMS,Web Services, Hermes v 1.1.4,Version1,SharePoint,FileZilla 3.5.3,Core FTP LE Version 2.1, MongoVUE 1.6.9, Tableau 8.6

Role

QA Analyst

Duration

October ‘09 – January ‘15

Responsibilities:

Project at S P Richards Co. involved moving Orders related functionality from Legacy systems (UNIX) to Sterling (Java) which involves Detail and Process Oriented testing on Multi Platforms and Technologies

Served as a key member from the First Phase of Sterling UI Implementation in the Company

Involved in all Phases of Entire Order Life cycle – Business Analysis reviews, Data Loading, Preparing Test plans, Developing and Executing Test cases and Production Support

Performed GUI Testing, Functional, integration, Regression, data base and System Testing

Worked closely with legacy systems, developed in UNIX and AS400 during the end to end testing

Responsible for Data Loading using batch loading tools Data Stage 9.1 and Jitterbit 4.0

After Successful Data Load, did lot of Data Validation from Source system to destination using SQL Queries

Involved in Performance testing of Data Load in Production manually and worked with Developers in fine tuning of Queries to enhance faster Loading

Worked closely with Automation Analyst and developed Automation test cases

using UFT 12. Used the concepts of data parameterization and data driven testing in Automation

Participated in testing Inventory Reports which were initially generated using Custom Java code

Worked with BI team to convert some of the Sterling Operational reports on to Tableau

Worked with Tableau Desktop 8.6 and Tableau Server Reports to test the reports created by the Business Intelligence team

Participated in Creation of Data reconciliation reports to validate the data between source systems and the data warehouse by merging data from both the systems within Tableau

Worked with various Combinations and permutations of positive as well as negative scenarios for testing complicated Business process involving calculations and conversions

Utilized WSDL for ESB to do integration testing, proxied web services in ESB which provided services to integrate Web Application and Sterling.

Testing ESB orchestration was done by using SOAP UI. Validated SOAP UI output and compared to Database to test data retrieved is presented accurately to Web Application

User stories were used to write test cases for Web Application, worked extensively in Web Testing.

Rigorously tested EDI files of Sales orders, Invoices, Credits in different formats using tools like ExamDiff and WinMerge.

Worked with Hermes tool to read the queues and analyze the discrepancies

Identified the root cause of intermittent glitch in code related to Shipment failure, leading to a no-fault audit finding.

Bug tracking and analysis was done Bug Tracking Tools Share Point and TFS

Participated actively in various bug discussions with Business Analysts, developers, Team Lead and Managers

Responsible for weekly status, updated the progress of the automation as well as manual testing effort

Involved in various discussions and meeting with Business Analyst and provided valuable suggestion for enhancement and improvement of the product

Employer

Peak Technical, Horsham,PA

Environment

Win 2000, XP, IE6, IE7, UNIX, Netscape7, MS Excel, Java, Oracle 10g, XML, Oracle Lease Management (OLM), Mercury Quality Center 9.2, QTP 9.5, MS Office, Windows, Citrix, JBOSS

Role

QA Analyst

Duration

August ’07 – September ’08

De Lage Landen is replacing its Legacy system (a Finance Application) with a new system and therefore launched a global initiative called BEACON, which is an enterprise wide system. BEACON Front office is a web application, which focuses on migration of all the necessary functionalities from Legacy application, at once to the new application. The project required extensive Functional, Integration, System and Regression Testing.

Responsibilities:

Performed excessive discussions with functional team and Process Teams about the use case as the requirements kept on changing and a lot of modifications were not understood

Analyzed Business requirements and specifications, and documented test requirements

Preparing Test Scenarios, Test Scripts and Revising test scripts as required to meet new and changing specifications

Collaborated with developers and subject matter experts to establish the technical vision for writing test cases from improper documentation

Executing Test Scripts and reporting Defects using QTP as well as manually

In Integration Testing, tasks involved are opening xml files and analyzing the errors on the software to see if the data is being passed correctly

Studying the gigantic log files of Integration and pulling the correct xmls by using the Tool "Ipswitch WS_FTP Professional"

Worked as a Module Lead for various important Modules of the application

Gave detail analysis of the defects logged; remediated, opened, closed in the status reports to manager

Involved in analyzing and executing the back-end scripts with oracle, OLM

Conducted Smoke Testing, unit testing, link Testing, end- end testing, regression testing during Regular Releases/Builds.

Attending Triage Meetings with Business/Development Teams during Change Requests

Performed extensive SQL Queries to compare the database and periodic reports generated by the application for various levels of management for deception and control purposes.

Performed IDL (Initial Data Load) Testing for all reference data being loaded in the Production environment by Sampling Techniques and creating Transactions

Coordinated Final Testing in California (San Mateo) before Application Launch by Providing 24*7 Production Support

Worked thoroughly with test Plan and test lab in Quality center.

Was involved in Creating Traceability Matrix after the testing effort of the application to show what part of the application was tested during which testing stage

Thorough knowledge of company’s lease application from creation of Credit Application to contract Setup, Funding and Booking the deal

Employer

Devon Consulting, Wayne, PA

Environment

Win 2000, XP, IE6,IE7, Netscape7, Javascript, .net, VB 6.0 classic ASP, Visual Interdev,XML,HTML, DHTML, Sql server 2000, WAPT,BadBoy, Defect tracker 2.1.6,MS Excel

Role

QA Analyst

Duration

October 06’- July ‘07

iPipeline gives the ability for insurance companies and content providers to publish their content on authorized websites (i.e. general agent, bank and broker-dealer, etc. websites) with a single database source to ease compliance audits.

Responsibilities:

Worked independently with users to define concepts and under direction of project managers

Critically evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.

Involved in Reviewing, analyzing, and creating detailed documentation of business systems and user needs, including workflow, program functions, and steps required to develop or modify computer programs.

Performed Unit Testing to manually test the GUI so that it matches with the requirements

Responsible for developing and implementation of Test cases, Test plans, Test data according to requirements in the Use Case and Requirement documentation

Conducted Functional and System testing manually and then automated scripts using WAPT when necessary.

Actively involved to perform Regression Testing of different application versions.

Conducted link testing for the web applications. In this process worked thoroughly with XML scripts and XSL style sheets

Entered mock data and wrote SQL scripts to verify and validate the proper data flow and interactions among different modules.

Used Sql analyzer and Event viewer extensively to analyze the defects.

Used the mock data and parameterized the scripts for data driven testing for both positive test scenarios and negative test scenarios.

Prepared test data for the Entrance and Exit criteria in Integration testing.

Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the database.

Tested the Periodic reports that were generated by the application for various levels of management for decision and control purposes.

Identified and documented all issues and defects to ensure application software functionality.

Performed defect reporting and bug tracking using Defect Tracker

Employer

HSBC Bank, India

Environment

Windows NT Server, Oracle, Java, JSP, WinRunner, and Ms Excel

Role

QA Engineer

Duration

April’03 – December’05

Online Banking application is designed to get the credit approval for the customers applying for Credit Cards, Loans & Mortgages etc

Responsibilities:

Created the detailed test plan and test cases from the business financial requirements document and meetings with the Business Finance Analysts

Conducted functionality testing using WinRunner

Used WinRunner to check for broken links in the application in web functionality testing

Involved in writing SQL statements to extract data from the database

Parameterized the login and password ids to simulate unique users accessing the application

Identified Test Cases to be run for Regression Testing and conducted Regression Testing as and when new builds were made.

Customization of Ms Excel to suite the requirements of the testing effort. Monitored the defect tracking process, troubleshooting and generated customized graphs and reports for the client. Reported Bugs using Ms Excel

Analyzed and debugged existing programs and system program flows and recommended improvements and/or changes.

Involved in conference calls with business and development participants from different regions for results, decisions making and planning of the testing/tracking processes

EDUCATIONAL QUALIFICATION

Masters in Computers and Science, India, 2002

Bachelor of Science, India, 1999

STATUS

Eligible to work (H1B Visa) for any employer in US. No sponsorship required.

Contact this candidate