SNEHA PALARAPU
******.**@*****.***
Local to Southern NH and BOSTON Area
SUMMARY:
Around 12 Years of diverse experience in Quality Assurance and Functional Testing of Client Server and Web based Applications in IBM SalesConnect, IBM B2B products, E-Commerce/Retail, Financial/Banking, Health Insurance and Pharmaceutical Industries using both Manual and Automation Testing techniques.
QA Expertise Includes:
Proficient manual and automated functional tester with expertise on former Sterling Commerce products.
Proven ability to work in a fast paced environment with multiple geographic teams, on concurrent projects
Has close attention to detail, and writes detailed test cases that show clear understanding of features.
Trained junior team members on products, process, tools, technologies, and techniques.
User Interface, Business Requirement Analysis and System Specification Analysis
Participated in creation of Test plans and Test scripts and worked with developers and Project managers in isolating and resolving problems using appropriate QA testing methodology
Performed Black Box testing from the end user’s perspective without knowing the underlying code.
Performed End-to-End/Integration testing to verify how interrelated components and functions work with each other.
Performed Functional verification and GUI Testing
Regression Testing Using Automated Tools.
Performed Back-end testing for data verification.
Participated in Design walkthrough and Defect report meetings periodically
Performed Functional and Screen Navigational Testing for Web Applications.
Extensive experience in using HP and IBM Rational Testing tools (RQM, RTC).
Experience in both Waterfall and Agile-Scrum development environments.
Technical Skills:
Functional Testing Tools: Quick Test Pro (QTP), Rational Functional Tester, Selenium, SoapUI
Test Management Tools: Quality Center (QC), Bugzilla, Rational Quality Manager (RQM), Rational Team Concert (RTC)
Scripting: SQL, PL/SQL, UNIX Shell Scripting
Operating Systems: Unix, Linux, Windows, System I, Embedded Linux
Languages: Visual-Basic, C, C++, .NET, Java
Databases: DB2, Oracle, MS SQL Server, MySQL, Derby
Web Services: XML, HTML, DHTML
App Servers: Websphere, Weblogic, JBoss
Privacy Controls: HIPAA
Education:
Bachelors in Computer Science [Maths, Physics, Comp Science] from O.U, Hyderabad. INDIA.
Diploma in Advanced Computer Technology, Hyderabad. INDIA.
Awards:
IBM INVENTION ACHIEVEMENT AWARD – Awarded a U.S Patent
PROFESSIONAL EXPERIENCE:
IBM. Littleton, MA June 2008 – Present
Staff Software Engineer
(i) TEAM: Sales Connect April 2013 – Present
Description: SalesConnect simplifies the way IBM’s sellers and sales managers work. With an integrated repository, sellers, opportunity owners, extended team and managers included, everyone can access the most updated status of opportunities, the help that is needed, and to drive the collaboration to close the sale through SalesConnect. With SalesConnect, we give back more time to sellers to be in front of the customer, progressing the deal and closing the deal.
Environment:
Java, J2EE, Siebel CRM, Sugar CRM, DB2, Websphere, REST APIs, POSTMAN, SQL, Apache, PHP, Unix/Linux, XML, HTML, Message Queues, RQM, RTC, Selenium, TestNG, Mobile app testing on Android and iOS
(ii) TEAM: IBM® Sterling B2B Integration June 2008 – March 2013
Description: IBM® Sterling B2B Integration automates business processes shared with trading partners. The goal is automation of the complete “buy-sell-ship-pay” process that involves a range of documents and business processes, which include not just the buyer or seller of the goods/services, but also banks and third party logistics companies.
Projects:
1)EBICS Banking Server: This Module enables you to transact with partners and users using Electronic Banking Internet Communication Standard (EBICS). Sterling B2B Integrator is a complete EBICS solution involving a bank, a partner, user management, certificate management, secure file transaction, error recovery, and reporting. Large and high-volume file transfers, with end-to-end visibility of file movement in a process-oriented and highly-scalable framework that alleviates file transfer challenges, such as protocol and file brokering, automation, and data security.
2)EBICS Client: A client server application that provides end-to-end EBICS solution for an organization to transact with banks. Using EBICS Client, a partner or a user associated with the partner can configure and manage multiple banks, partners, and users. Multiple users can securely transact with multiple banks (EBICS banking servers).
3)Multi Enterprise Gateway (MEG) – An interface for the Customer to interact with all other IBM Sterling Integrator components.
Environment:
Manual Testing, UI Automation using QTP, RFT, Selenium; QC, RQM, RTC, Java, J2EE, Dojo, DB2, Oracle, SQl Server, Derby, Websphere, Weblogic, JBoss, REST APIs, SoapUI, SQL, Cross Site Scripting, SQL Injection, Accessibility Testing, Unix/Linux, Internationalization testing, Web Services, Message Queues
Responsibilities @IBM:
Prepared Test Cases based on Design documents
Took ownership of some of the main components of the product areas and became a subject matter expert for that area of the product.
Executed test cases after they went through internal(QA Team) and external(Developer) review
Done Smoke/Sanity tests to verify readiness of the build.
Developed test cases for testing REST APIs using the SoapUI tool and POSTMAN
Identified test cases for automation
Supported the Automation team members in creating test data for automated scripts
Created and executed Automated test scripts for regression
Conducted debugging of automation test failures
Cross-Browser testing on Internet Explorer, Mozilla Firefox and Chrome.
Performed Functional Testing, Integration Testing, and Regression Testing.
Documented the test results and reported the defects to the development team on a timely basis.
Retested/Verified the fixes on various builds.
Worked with developers to accelerate on high severity and high priority defects
Tracked the testing progress on Quality Center, RTC and RQM and sent weekly reports to the Leads and Managers
Executed SQL queries for validating back-end data using Data Studio
Executed Batch jobs which were written in PHP
Install builds on various test environments and apply patches
SmartBargains.Com. Boston, MA Jan ’08 – March ‘08
QA Engineer
Description: Since 1999, Smart Bargains.Com has been dedicated to giving customers an online, off-price shopping experience that's easy, instantly rewarding, and always fun. At SmartBargains.Com, they believe there's an art to bargain shopping. They pride themselves as Your Personal Bargain Hunter.
Project: RueLaLa.com is an exclusive, online marketplace of limited time Boutiques featuring premier brands at Members-only prices. It is dedicated to providing its members with access to coveted fashion and luxury lifestyle brands at sample sale prices. And Membership is through Invitation only. Members can invite friends to join Liberty and earn referral credits.
Responsibilities:
Analyzed the specifications in the Functional Requirement Document and Technical Requirement Documents for the purpose of preparation of Test Case Scenarios.
Involved in the preparation of Test Cases analyzing the Test Plan and specifications documents.
Done Smoke/Sanity testing to estimate testing readiness of the build for every release.
Developed data and individual test cases to satisfy Positive and Negative testing.
Executed test scripts and test cases.
Tested all kinds of links verifying whether they were broken or/and direct to different pages.
Tested the navigation and the User Interface for ease of use.
Conducted Cross-Browser testing on Internet Explorer 6.0, 7.0, Mozilla Firefox 2.0 and Safari.
Performed Functional Testing, Integration Testing, System Testing and Regression Testing.
Documented the test results and reported the defects to the development team using Bugzilla on a timely basis.
Resolved the issues by retesting on various builds.
Worked with application developers to fix the problems.
Tracked the testing progress on Bugzilla-bug tracking system.
Involved in Writing User Acceptance Scripts.
Executed SQL queries for validating data in Database and Back-End testing.
Environment: Manual Testing, Windows XP, Java, J2EE, JBoss, .Net, Flash, Oracle, Bugzilla, PHP, Apache Server, MS Word, MS Excel, SQL
St Mary’s Bank. Manchester, NH Nov ‘06 – Dec ‘07
QA Test Analyst
Description: As the first Credit Union in United States, St. Mary's Bank is proud of its heritage. For nearly a century, they have been helping New Hampshire residents with a wide range of affordable products and services, including checking accounts, personal loans, real estate loans, business banking, and savvy financial planning.
Project: Application was an on-line distributed financial trading system (DTS). A web based continuous electronic market that traders can use to execute bundle orders. The application used Automated Matching Mechanism providing universal access to traders on the Internet, allows interactive information exchange between traders and market makers. Uses distributed object model (DOM). Worked with Stocks, Options, Futures, Derivatives and Fixed Income Applications.
Responsibilities:
Prepared the Test Scenarios and Test Cases for the Application under test.
Involved in entire QA Life Cycle which includes Design, Development and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
Analyzed the specifications in the User Requirements Document, Functional Requirement Document and Technical Requirement Documents for the purpose of preparation of Test plans.
Performed GUI Testing by creating GUI checkpoints to verify the functionality of the GUI objects using QTP.
Various checkpoints are used to capture the functionality in the application by using Quick Test Pro.
Executed the automated Test Cases and Test Sets in TestDirector.
Enhanced Test Scripts to increase the performance of the application.
Automated Test scenarios for GUI Functionality, Regression Testing using QTP.
Designed and developed dynamic spreadsheets and queries to reconcile test results and logged all test results and bugs.
Parameterized key elements to verify the Database Integrity.
Conducted Regression Testing and System Testing on various builds of the application and reported the defects to the developers using Test Director for bug fixing and tracking.
Facilitated user acceptance testing (UAT) and test strategies with developers and testers.
Performed manual front-end testing to check all functionalities of different modules.
Extensively used SQL Scripts/Queries for data verification at the backend.
Verification of test results (querying the database using SQL) documenting the defects and informing the same to QA Manager.
Helped in Deployment of Portal and Collaboration Solution to increase Investment Results.
Responsible for analyzing various valuation models involving stocks and bonds.
Helped in creating end user manuals.
Environment: Manual Testing, Windows XP, HTML, DHTML, XML, JavaScript, J2EE, VB Script, VB.Net, ASP.Net, Oracle, MS-SQL Server 2005, SQL, PL/SQL, Test Director 8.0, Quick Test Pro (QTP 8.2), Visual Source Safe(VSS), MS Word, MS Excel, Toad.
Assurant Employee Health Insurance. Westborough, MA April ‘05 – Oct ‘06
QA Automation Tester
Description: At Assurant Employee Benefits, they specialize in helping small to mid-size businesses maximize their benefits investment without sacrificing quality. They offer a full line of group disability, life, dental, and voluntary products as well as individual dental. Their goal is to make benefit selection easy and rewarding for all, by delivering quality products with excellent customer service.
Project: Worked on Accounts Receivable and Billing System applications. The data feeds from Client Database store client details, Eligibility Database stores insured details and Rates database allows you to enter rates. Billing System is mainly designed to add and modify statements, assign billing lines, updating administrative adjustments, reconciliation, generating and scheduling Invoices. The entire system is computerized incorporating HIPAA (Health Insurance Portability Accountability Act). It also involves HIPAA analysis work to make the system HIPAA compliant.
Responsibilities:
Involved in writing Test Cases
Manual and functional testing.
Testing the application according to requirements
Involved in Integration testing, System testing
Recorded automated test scripts (TSL) using Win Runner testing tool
Performed Regression testing by using the Win Runner Tool.
Using the bug-tracking tool Test Director for defect tracking and reporting.
Played Back the Win Runner scripts from Test Director
Editing test scripts during Regression Testing and re-execute the scripts after fixing the bugs
Manually performed Back-end testing by executing SQL queries.
SQL, Pl/SQL queries were used in order to view successful transactions of data and to validate data at the back end.
Used Pre-Execution checklist to verify that the environment is ready for testing.
Documented the successful or unsuccessful completion of each test condition in the Test director script Repository.
Verify Actual results against Expected results and investigate discrepancies.
Tested HIPAA Transactions like 837, 835.
Involved with functional, regression and System testing during the various phases of the application.
For a part of the data which was on Mainframes, we used Unix Shell scripting to extract data and used it as a test set.
Environment: Manual Testing, Windows XP, Quick Test Pro, Test Director, IBM web sphere, DB2, Unix Shell Scripting, Java, J2EE, Oracle8.1, C++, MS Excel, SQL Server 2005, SQL, PL/SQL, XML.
Nationwide Financial. Newton, MA Mar ‘04 – Mar ‘05
QA Tester
Description: Nationwide Financial, a Subsidiary of Nationwide Insurance provides Online-banking solutions for over 200 small to mid sized banks. This application was developed using Java, XML, HTML as the front-end and Oracle 11.i as backend on a Windows environment.
Project: Worked as a Tester for Credit Recovery System in Nationwide Financial. This system deals with the customers who have a bad credit by giving them a better offer and an opportunity to build their credit history.
Responsibilities:
Involved in the preparation of Test Cases analyzing the Test Plan and specifications documents.
Involved in Manual Testing and System Testing of the Application
Done Sanity testing to estimate testing readiness of the build for every release.
Developed data and individual test cases to satisfy Positive and Negative testing.
Tested the navigation and the User Interface for ease of use.
Performed Functional Testing and involved in User Acceptance Testing.
Tested all kinds of links verifying whether they were broken or/and direct to different pages.
Conducted Cross-Browser testing on Internet Explorer and Netscape Navigator.
Performed Regression Testing using Win Runner and enhanced Test Scripts.
Reported bugs using Test Director.
Executed SQL queries for validating data in Database and do Back-End testing.
Documented the test results and reported the defects to the development team on a timely basis and resolving the issues by retesting of various builds.
Environment: Manual Testing, Windows XP, WinRunner8.2, Test Director 8.0,
Oracle 11i, C++, Java Script, J2EE, MS Word, MS Excel, MS PowerPoint, XML, HTML, SQL, PL/SQL, Toad.
Walgreens. Springfield, MA April ’03 – Feb ’04
Quality Assurance Tester
Description: Walgreen’s Pharmaceuticals is a leading company in providing information portals on various diseases for patients and physicians
Project: Involved in setting up the testing methodology, QA documentation library, automated tool evaluation and QA parameters that were adhered to by the Aventis QA group. Actively participated in User Requirement Analysis, hands-on testing (manual and automated). Also responsible for confirming that the information posted on the web confirmed the industry standards. The web portals being tested are Heart Help Zone, Cancer Help Zone, Diabetes Help Zone and Infectious Disease Portal.
Responsibilities:
Involved in Creating Test plans, Test Scripts and Cases based on the Functional Requirement.
Performed Manual Testing of the application on various Browser Configurations.
Automated identified Test Scripts using Quick Test Pro.
Involved in Setup of Automation Framework, Modularity and Design.
Performed Smoke test, Integration Testing, System Testing, and Negative Testing on the application before automating the Scripts for Regression.
Used Parameterization and Data Driven Wizard for Data supply from Tables to the Automation Script for testing the application for a varied set of input.
Wrote SQL queries and executed them for validating Front End with the Data Base information.
Created Exception handling functions for Auto-Recovery of the system when encountered with incompatibility of the VB Scripts with the Functionality.
Executed Scripts from Test Director by integrating Test Director with QTP.
Reported Issues with screen shots for the Development Team and Re-Tested the same for closing the Issue.
Involved in Writing User Acceptance Scripts and was involved in setting up UAT – Test Data.
Environment: Manual Testing, Quick Test Professional(QTP), Test Director, ASP.Net, VB.Net, Java, Oracle, Windows 2000/XP Professional, SQL, Visual Source Safe(VSS).
References available upon request