NAME: SANDHYA OBULAREDDYGARI
EMAIL: *************@*****.***
PHONE:732-***-****
Around 9+years of IT experience in developing applications for Attorneys Legal and Business solutions, Medical Alert, Insurance, life sciences, Federal government and corporate industries.
Around 2+ years as a lead,Provided guidelines, reviewed and support to developers and business analysts creating unit tests and integrating them into the build cycles.
2+ Years’ experience in managing teams performing testing activities, including UI automation, integration testing, performance and scalability testing.
Develop Test cases per the Business Rules in order to direct others on testing requirements.
Automation using Selenium, also created Framework using selenium web driver,JAVA,TESTNG/JUNIT.
2+ year experience in AS 400 IBM mainframes in production side to process all the orders and shipments.
Almost 2+ years experienced with Quality center for defect tracking.
4+ year of experience in PEGA RULES Process Commander (PRPC) 6.2, SOAP UI 5.0, ALM
5+ years of experience involving all stages of software development life cycle (SDLC) using Waterfall model including requirements gathering, design, development, testing and support in Windows, Linux, Unix platforms.
7+ years of work experience in agile as well as waterfall development environment.
Experience in Java development, Data warehousing development and testing platforms.
Around 2 years of experience in QA, Web service testing, manual, regression, functional testing.
6+ years of experience in Design, Development and Implementation of various n-tiered Business applications using Java (1.3, 1.4), J2EE architecture framework.
3+ years’ experience in writing test cases before development did extensive unit testing using integration testing, regression testing, Performance,UI testing, functional testing and kept defects to minimum.
Experienced in Manual testing and Automated testing tools like QTP, Quality Center, ALM, Win Runner, Load Runner, Test Director and Rational Test Manager, Rational Robot, Rational Clear Quest,Soap UI, Microsoft Test Manager and Visual Studio 2010, Visual Studio 2012 RC Integrated shell .
Good understanding in Software Development Life Cycle (SDLC), STLC, QA methodologies like Water fall model, Rational Unified Process (RUP), Agile Methodology.
6years’ experience in defect-fixing during SAT/UAT phases.
6+years’ experience in defect tracking tools like HP Quality Center, Mercury Test Director.
5+ years’ experience using object Oriented methodologies.
3 years’ experience in developing code to interact with the databases using Oracle 9i & 10g, SQL Plus, SQL Developer.
Designed database objects like Stored Procedures, Functions, Triggers, SQL queries.
Excellent logical thinking and problem-solving skills.
Worked on large no. of Change Requests (CR).
Extensive experience in Microsoft package working with Word, Excel, Access.
A very good team player with excellent problem solving and interpersonal skills.
Have great ability to quickly master new concepts.
Strong analytical ability, written and verbal communication skills.
Achieved ‘Star of the month’ and won client appreciation many times.
Played a very active role in team building events and sports at vertical level.
TECHNICAL SKILLS:
Operating Systems : UNIX, Solaris, Linux and Windows NT/2000/XP, AS 400.
Languages : Java, HTML, VB Script, Java Script, XML and SQL
Databases : DB2, ORACLE 8i/9i/10g,MS Access and
SQL Serve6.0, Squirrel SQL 3.5.0
Functional Test Tools : Win Runner 6.0/7.5, QTP 9.2, Rational Robot and
Rational Suite, HP Quality Center ALM 11.0.
Performance Test Tools : HP Load Runner.
Defect Tracking Tools : Quality Center and Clear Quest, JIRA.
Client Epiq Global systems
Senior QA lead:
Duration: SEPT2020-PRESENT
Epiq Systems : worldwide provider of legal services, serving law firms, corporations, financial institutions and government agencies—helping them streamline the administration of business operations, class action and mass tort, court reporting, eDiscovery, regulatory, compliance, restructuring, and bankruptcy matters.
Responsibilities:
Leading the design, development, and implementation of test solutions needed to advance the Hyperloop technologies.
Ensuring design for testability during reviews and audits.
Supporting detailed test planning, including the requirements for engineering models, simulations, testbeds, and special test equipment for all stakeholders involved with system testing.
Conducting peer reviews and provide technical leadership to Test Engineers.
Developing test plans & test procedures using Jira to meet testing needs.
Collaborating with internal and external customers to define requirements and specification for testing.
Managing highly integrated System Testing programs from test planning, test execution, to data reporting.
Responsibilities included project management, including budgeting, scheduling, and communicating project information
Aiding with defining test and evaluation strategy and developing & implementing test processes and best practices.
Ran back end testing to make sure the data created from case managers listing is correct or incorrect from the tables.
Using visual fox pro 9.0 and Microsoft sql server, updated the tables regarding client updated data.
Used Epiq local service to complete service request made by case managers for data which is from the attorneys and business services.
Environment: visual fox pro(VFP) 9.0, Jira-zephyr, Microsoft azure cloud, Microsoft sql server
Reporting: Microsoft excel, Epiq service.
Client: Express Scripts
Senior QA analyst
Duration: MAY2020-SEPT 2020
Express Scripts is a prescription benefit plan provider that makes the use of prescription drugs safer and more affordable for members. Express Scripts handles millions of prescriptions each year through home delivery from the Express Scripts Pharmacy.
Responsibilities:
Develop Test cases for ONE PA as per the Business Rules in order to direct others on testing requirements.
Review and provide guidance on the test scope and output of testers performing testing
Facilitate, record and capture information from demos and user experience sessions.
Create status reporting mechanisms to monitor the status of the above activities
Develop, document and maintain functional test cases and other test artifacts.
Execute test cases and report test results.
Followed Agile-Scrum Software Development Life Cycle (SDLC), worked closely with Business Analyst, Developers and QA team members, Attended daily Scrum, walkthrough and requirement review meetings.
Performed Regression testing for each sprint around like every two weeks for the entire application.
Do the analysis for the new user stories in different scenarios wrote the test cases and perform execution.
Conduct meeting between the team to understand and assign the stories after every refinement meeting.
Work with UAT test closely to decide go or no go to the release.
Have experience working with Jira to log work and write testcases in both Zephyr as well as excel testcase generator tool.
Also execute SQL queries to find the exact data in the tables and match the data with UI testing.
Creating data replication process for VFP database tables
Migrated VFP 6.0 application with DBF tables to VFP 8.0 using SQL Server backend to improve performance.
Migrating FoxPro table data and Windows applications
Performed testing with POSTMAN to generate barcode and verify that is UI.
ENVIRONMENT: JIRA -ZEPHYR,EXCEL test case generator, Sql version 2016 and 2019,VFP 8.0,Post man, SOAPUI
Client: CONNECT AMERICA
SENIOR QA ANALYST
Duration:April2019-January2020
Connect America's medical alert has been providing emergency medical alert monitoring services to thousands of senior citizens nationwide. Connect America’s headquarters is located in Philadelphia, PA and they are considered one of the pioneers in the medical alert monitoring industry. Connect America is a member of the Medical Alert Monitoring Association (MAMA) and they provide medical alerts to CVS stores nationwide.
Responsibilities:
Followed Agile-Scrum Software Development Life Cycle (SDLC), worked closely with Business Analyst, Developers and QA team members, Attended daily Scrum, walkthrough and requirement review meetings.
Created Bugs using Jira and resolved the issues and also wrote the testcases by following the business stories .
Worked on Multiple environments and tested .
Involved in both SIT and UAT testing
Analyzed Business Requirements (BRD) and Functional Specifications (FSD) and Use Cases documents.
Worked closely with BA and QA engineers to select test cases for Regression testing and fix failed scripts.
Identified and tracked defects in JIRA tickets, followed up with developers on questions and status of opened tickets.
Helped team members by providing improvement of testing process during SIT execution .
Reported test case execution status to QA Manager and Project Manager, Created Test Analysis Report (TAR), analyzed issues and discussed enhancements with team.
Worked on Salesforce to compare data and test in three different environments look the same kind of data.
Worked on Thousands of records tested Manually and validated it.
Environment: HSYS,salesforce Web, Rapid Web, Sedona,JIRA
Client: Barnes and Noble, NEW JERSEY
SENIOR QA ANALYST
Duration:April2017-February2019
Barnes and Noble is the one of the biggest warehouse in New Jersey, so it’s basically getting the orders, processing the shipments and generating the shipment labels for NOOK orders and also n.com orders. This warehouse centers are one in Monroe NJ and one in RENO NV. Here we process both the orders successfully.
Responsibilities:
Provide guidelines, reviews and support to developers and business analysts creating unit tests and integrating them into the build cycles.
Manage teams performing testing activities, including UI testing, integration testing, performance and scalability testing.
Developed automation testcases using selenium web driver and NUNIT.
Wrote automation scripts for the New account,new customer.
Develop Test cases per the Business Rules in order to direct others on testing requirements.
Review and provide guidance on the test scope and output of testers performing testing
Facilitate, record and capture information from demos and user experience sessions.
Create status reporting mechanisms to monitor the status of the above activities
Develop, document and maintain functional test cases and other test artifacts.
Execute test cases and report test results.
Creating data replication process for VFP database tables.
Identify, document and ensure resolution of software issues.
Analyze tests for coverage of performance, data, and functionality.
Report on quality of multiple products and the release readiness of the products.
Review historical, existing and ongoing bug reports to identify areas needing specific attention.
Participate in the establishment of software quality standards for life cycle, documentation, development methods, testing and maintenance.
Gathered all the business requirements and test data and develop the scripts for successful shipments.
I’m responsible for running the scripts for the new orders which is from Monroe and Reno and generate the barcode using different ASN’s.
Extensively created Data Driven Test scripts to read data from text files for data validity testing. Checked for data boundaries/limits, incorrect input of data.
Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
Created PL/SQL stored procedures, involved in database design, development of SQL Queries, Functions & Triggers for backend System.
Tested broken links and inter application links in Development, Test, and Production environments.
Involved in UAT testing in UAT environment, Prepared UAT test cases and testing estimates.
Preparing Functional/regression Test Cases/Scripts in HP Quality Center/ALM under Test Plan, And Review Test Requirements, Creating Test Plans and Test Strategy documents.
Involved on testing the new functionality based on test cases and coordinated with development team in fixing the issues, Defect Management by Logging and Tracking bugs during execution in Test lab.
Ensure that all the test cases are updated in the HP Quality Center/ALM along with Master test plan; Generating Matrices Reports and Charts for Defect Analysis to analyze statistical nature of the defects.
Finally I use to pack the chute and process the truck (adding orders to the truck) and exit the truck by running the scripts for successful shipment.
Generating the invoices for those orders by executing the SQL queries.
Provide daily status report, defect matrices, daily updates to lead; Provide daily status report on task assigned to the Project Manager/Client.
Environment: AS 400, SELENIUM,Squirrel SQL client version 3.5.0,VFP 6.0 HP ALM,HP Quality center11.0.
Client: USDA, Washington D.C
QA ANALYST
Duration:July 2014-march2017
Project Description:
USDA -NRCS helps America’s farmers, ranchers and forest landowners conserve the nation’s soil, water, air and other natural resources. Programs are voluntary and offer science-based solutions that benefit both the landowner and the environment. NRCS provides technical expertise, conservation planning and incentives to farmers, ranchers and forest landowners wanting to make conservation improvements to their land
Client Gateway is an application designed to help farmers, ranchers, landowners to get technical and financial assistance from NRCS. NRCS employees are given role based access to act on behalf of farmers, ranchers, landowners.
Responsibilities:
Gathered test data requirements for data conditioning from Business Units to test total application functionality.
Prepared test plans, test cases for both positive and negative scenarios and mapped the same to requirements.
Executed test cases before and after bug fixes for each build for User acceptance testing.
Tested Web page presentation manually for different browser compatibility.
Involved in defining, and analyzing the testing requirements based on the application functionality.
Preparing Functional/regression Test Cases/Scripts in HP Quality Center/ALM under Test Plan, And Review Test Requirements, Creating Test Plans and Test Strategy documents.
Used to submit a minimum of 50 defects for each release twice in a week without any failures.
Created Test Plan and did Test Effort Estimation
Implemented BPM artifacts and strategized BPM based testing.
Reviewed Test cases and guided the team in executing test cases and defect tracking.
Used ALM to execute test cases and defect tracking.
Conducted Defect Triage meetings
Tested external services using SOAP UI
Environment: PEGA RULES Process Commander (PRPC) 6.2, SOAP UI 5.0, HP ALM quality center11.0.
Client: SUNTRUST, Richmond, VA
QA ANALYST
Duration: July, 2012 – july2014
Project Description:
Member of a team that analyzed, and tested credit card banking application, which enable customer Service reps to process Credit Line requests, Fraud claims. Extensively involved in testing the desktop applications, designed for customer representatives to offer various services such as removal of account, user lockouts etc. This project also involves the testing of Main Frame and telephony testing.
Responsibilities:
Involved in defining, and analyzing the testing requirements based on the application functionality.
Gathered test data requirements for data conditioning from Business Units to test total application functionality.
Used quality center to log the defects, Track the defects and to keep update and track the complete documentation for the application.
Created test scenarios for System testing and Regression testing.
Prepared test plans, test cases for both positive and negative scenarios and mapped the same to requirements.
Executed test scripts, and analyzed the test results.
Used Test Director as a central repository for all the test activity.
Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
Responsible for writing the SQL queries to verify GUI front-end results and to extract and to manipulate the data to satisfy test cases/ requirements.
Tested Web page presentation manually for different browser compatibility.
Tested broken links and inter application links in Development, Test, and Production environments.
Executed test cases before and after bug fixes for each build for User acceptance testing.
Performed Back-end testing using TOAD.
Tested the application for third party vendor confirmation and client reports as peruse cases.
Environment: Quality center, Test Director 8.0, Win Runner, J2EE, Tomcat, HTML, UNIX Oracle and Toad.
Client: Indian bank, Chennai
Duration: June 2007 –June 2009
Project Description:
INDIAN BANK Online Resource Center for Home Improvement is a one stop for getting the most value out of your home improvement dollars. The various steps involved in Home improvement are getting started, generating ideas, Planning your budget and Schedule, Finding and Managing Professionals, Managing your work in progress.
Responsibilities:
Involved Manual testing, Functional Testing, Black box testing, Regression testing, System testing, Integration testing and end-end testing, User Interface testing and Data Driven Testing.
Gathered test data requirements for data conditioning from Business Units to test total application functionality.
Created test scenarios for System testing and Regression testing.
Prepared test plans, test cases for both positive and negative scenarios and mapped the same to requirements.
Executed test scripts, and analyzed the test results.
Used Test Director as a central repository for all the test activity.
Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
Responsible for writing the SQL queries to verify GUI front-end results and to extract and to manipulate the data to satisfy test cases/ requirements.
Tested Web page presentation manually for different browser compatibility.
Tested broken links and inter application links in Development, Test, and Production environments.
Executed test cases before and after bug fixes for each build for User acceptance testing.
Performed Back-end testing using TOAD.
Tested the application for third party vendor confirmation and client reports as per use cases.
Environment: Test Director 8.0, Win Runner, J2EE, Tomcat, HTML, UNIX Oracle and Toad
Education Details:
Bachelors in Information technology in Engineering
Started Year: 2004
Completion Year: 2008
Master’s in computer Information Systems
Start year: 2012
Completion year: 2013
Previous Projects:
1.Worked on java script and SQL queries to built a sample website for Motel booking for the customers and tested in using HPALM tools.
2.I EEE project in bachelors
Certifications:
C
C++
JAVA
.NET
RPA(Robotic process Automation Anywhere) [New Tool]