Post Job Free

Resume

Sign in

Test Engineer Sql Server

Location:
Stilwell, KS
Posted:
December 12, 2023

Contact this candidate

Resume:

SRIDHAR CHIMPULA

913-***-****

ad1wtt@r.postjobfree.com

Experience Summary:

Over Twelve Years of experience as a Sr. QA Test Engineer. Sound knowledge of Manual and Automated Black Box, White Box, System, Regression, Integration, Functionality, and User Acceptance Testing (UAT) of both Client/Server and Web-Based applications

Good at understanding the Business Requirement Documents, Functional Specifications

And Technical Specifications

Proficient in preparing Test Plan, Test Cases, Test Scripts designs and Execution of Various test scripts using WinRunner, Quick Test Professional and HP ALM (Quality Center)

Involved with team in executing Performance Test Scenarios using LoadRunner.

Solid knowledge of software installation and maintenance of testing tools LoadRunner, WinRunner, Quick Test Professional and Mercury Quality Center

Solid knowledge of software installation and maintenance of Rational Suite

Experience in Testing Database Applications of RDBMS in Oracle, SQL Server, and MS Access

Extensively involved in Middleware testing, IBM MQ Series is used as middleware.

Expertise in creating data using P2K, Ensemble and RMS

Writing and Testing Complex SQL (DDL, DML and DCL) queries for back-end validations

Extensively worked in Voice Technologies like IVR.

Exposure on ETL Tools like Informatica and EAI tools like “SeeBeyond ICAN 5.0.5 (eGate)”

Extensively worked in various fields Banking, Finance, Telecommunications (Mobile Testing), Healthcare, Credit Reporting, Insurance, Pharmaceuticals etc.

Proficient in all stages of software development life cycle (SDLC)

A team player with excellent interpersonal and communication skills.

Technical Skills:

Testing Tools : Win Runner, Quick Test Professional, TFS, LoadRunner, TestDirector, Mercury

Quality Center

Languages : TSL, Java, J2EE, Java Script, VB Script, HTML, XML, ASP, JSP, C, PL/SQL

Middleware tools : IBM MQ Series

GUI Tools : Visual Basic, Oracle Developer/2000.

ETL tools : Informatica 9.1

Database : Oracle, MS-Access, IBM Lotus Notes, SOA Technologies. SQL Server 2012

Reporting Tools : Crystal Reports, Business Objects & SQL Server Reporting Service

Server : Oracle Web Server, IIS, Web Sphere, Web logic

Web Designing Tools: Front Page

Microsoft Products : Word, Excel, PowerPoint

Operating Systems : Solaris, UNIX, Linux, Windows7/ 2000/NT/XP, MS-DOS, IBM Mainframe

Professional Experience:

T Mobile (Sprint), Overland Park, KS June’ 2016 – Till Date

Analyst, UAT

Sprint Corporation, commonly referred to as Sprint, is an American telecommunication holding company that provides wireless services and is an internet service provider. It is the fourth largest mobile network operator in the United States, and serves 59.5 million customers, as of January 2017.

Responsibilities:

Involved in Sprint Planning, Daily Stand-up, Sprint Review, and the Sprint Retrospective (Agile Methodology)

Testing the integration of the code from VML to Sprint to make sure Dashboard working correctly.

Performed App & Web testing to make sure APIs are working as expected.

Create & Test web pages using AEM components.

Performed Cross browser compatibility testing of the web Application using Browser stack.

Performed System Testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance testing on Web/APP.

Prepare Test Plan, Test Cases based on requirements using JIRA & HP ALM.

Expertise in performing manual testing (emulators & IOS Simulators) & amp; Mobile Application Testing using Appium.

Performed Smoke, White/Block box Testing.

Run Appium tests on Sauce Labs for speed, parallelization, clear test result history, failure analysis, issue tracking.

Communicate effectively in confluence about status of iterations.

Environment: JIRA, HP ALM, Selenium, Java, Angular JS, Appium, AEM Tableau.

Waddell & Reed, Overland Park, KS June’2014 – May’2016

Sr. QA Engineer

Waddell & Reed is among the most enduring asset management and financial planning firms in the nation, providing proven investment and planning services to individuals and institutional investors.

Responsibilities:

Established the business analysis methodology using Iterative model of SDLC.

Created and executed detail functions DW (ETL) test scripts based on the DW Mapping Design Documents.

Responsible for Data Mapping testing by writing SQL Queries.

Involved in Delta load testing and compare source and target data.

Involved in GAP Analysis as per requirements and communicate with our BA on finding GAP Issues.

Define uniform smoke test procedures to be conducted by developers as well as testing guidelines for specific Kofax products.

Professional experience in the space of Informatica AXON and EDC

Arranged meetings with business customers in better understanding the reports by using business naming conventions.

Work closely with team members to follow up on defects validation to get closed within the timelines and the same to be informed to the customer.

Attending daily status meetings (Scrum Standup Meetings) and weekly scrum sprint sessions and planning testing work ahead for self and QA team members.

Performed various types of testing, such as Integration, functional, SIT and Regression testing.

Data testing in Golden Source and Mainframe application (Source) data to migrate properly in Target MDM System thru staging areas.

Involved in testing all required Stage loads and Target MDM Database testing.

Environment: BlueZone6.1, Informatica 9.1, SQL Server Reporting Service, Tidal, TFS (Team Foundation Server), Selenium, JIRA, TortoiseSVN, SQL Server 2012 and Oracle

American Century Investments, Kansas City, MO July’ 2013 – May 2014

Sr. QA Analyst

American Century direct is a web site, through which users can find information about the investments offered by ACI and provides online account management portal.

To support pursuit of Target-Date placement opportunities in Defined Contribution plans, ACI will deliver an online participate education tool for plan participations. By providing the service, ACI will offer tool to plan sponsors as means to engage typically passive participant audience and to reinforce American Century’s capabilities in the Defined Contribution Market.

Responsibilities:

Testing the integration of the code from VML to ACI to make sure the pages are working correctly.

Testing will include browser and acceptance testing. See testing platforms for what operating systems tested.

Validating data of the Target Date Portfolio displayed on the pages.

Changes made to the prototype for different companies requesting their own personalized site.

Regression testing of the IPRO site will be completed.

Created Test Strategies and Test Cases to satisfy Test Requirements and documenting the same in Quality Center.

Wrote test plans and test cases that identify the schedules, environments, resources (personnel, tools, etc.), methodologies, cases (inputs, procedures, outputs, expected results) using Quality Center.

Performed system testing, integration testing, end to end & regression testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Tests are performed in Agile Methodology, Attended scrum meetings.

Environment: Java 2(J2EE), JavaScript, .Net, MS Office, and Windows 7, HP Quality Center

Quest Diagnostics, Lenexa, KS Dec’2012-June’2013

Sr. QA Analyst

Medicheck Implementation: Quest will take ICD9 Codes and exported to them into ANSI and RAPSfiles. Quest will show ICD9 codes into UI.

Responsibilities:

Gather Business Requirements and Prepare requirement Documentation as a Business Analyst according to Agile Methodology.

Review of business requirements, user manuals; use case specifications, system specifications.

Prepare Test Plan, Test Cases based on requirements using Quality Center.

Execute Test Cases using QTP

Verify RAPS File: Request for Anticipated Payment-Medicheck clients submit a RAP file to Medicaid that shows who they plan to submit to MediCare billing claim.

Verify ANSI 837-5010: ANSI 5010 is the new version of HIPPA transaction standards that regulates the electronic transmission of heathcare transactions. The 5010 will replace existing 4010/4010A1 version of HIPPA transaction.

As a Business Analyst assist in Integration and Acceptance Testing, supports the development of training and implementation material, participates in the implementation, and provides post-implementation support.

Verify Member lab results delivered in a tab delimitated file

Verify all theClient Data has been populated on Medicheck UI site

Environment: HP Quality Center, QTP(UFT), .Net, MS Office and Windows 7

Assurant Employee Benefits, Kansas City, KS July’2012–Nov’2012

Sr. QA Analyst

Assurant specialized in quality employee benefits and services, including long-term and short-term disability, life and accidental death and dismemberment insurance, dental coverage, and disability reinsurance management services. Assurance Employee Benefits also offers voluntary (employee-paid) disability, life and dental plans. Products and services marketed by Assurance Employee Benefits are underwritten or provided by Union Security Insurance Company, Union Security Life Insurance Company of New York, or an affiliated prepaid dental company. Underwriting flexibility allows Assurance Employee Benefits to market tailor-made benefit plans for groups of most any size.

Responsibilities:

Analyzed the top-level requirements for software functions for each Business Process.

Conducted walkthroughs and meetings with project team, end users/application owners to understand the application/SRS document.

Performed software requirements traceability analysis to trace software requirements to (and from) system requirements and to risk analysis results.

Created Test Strategies and Test Cases to satisfy Test Requirements and documenting the same in Quality Center.

Wrote test plans and test cases that identify the schedules, environments, resources (personnel, tools, etc.), methodologies, cases (inputs, procedures, outputs, expected results) using Quality Center.

Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Extensive use of SQL queries to validate data in the Oracle database.

The Test report was developed for bug tracking by using Quality Center.

Environment: Java 2(J2EE), JavaScript, HP Quality Center, TOAD, Oracle, MS Office, SOLAR COMPASS and Windows 2000

CSC, Overland Park, KS April’ 2011 – June’ 2012

QA Analyst

WIC provides nutritious foods, nutrition education, and referrals to health and other social services to participants at no charge. WIC services low-income pregnant, postpartum, and breastfeeding women, and infants and children up to age 5 who are at nutrition risk.

Responsibilities:

Review of business requirements, user manuals; use case specifications, system specifications.

Involved in analyzing system specifications from system perspective and Identifying Testable and Non- Testable requirements with Business and development teams

Involved in designing of Test scripts based on the System requirements from the Business Analyst. Attend scrum meeting everyday & ollow Agile Methodology.

Planning, scheduling, and executing System testing.

Reported detailed software problem reports, defect tracking and verifying corrections using JIRA (Defect Tracking Tool)

Environment: Java 2(J2EE), JavaScript, JIRA, TOAD, Oracle, MS word, and Windows 2000

Sprint–IBM, Overland Park, KS Aug’ 2007 – March’ 2011

Lead QA Analyst

Sprint is a global integrated communications provider with a nationwide presence of local, long distance, broadband, video services and wireless assets and a strong national brand.

Sprint develops and delivers compelling bundles that provide the solutions consumer’s demand.

To improve their customer care, a variety of applications were designed to help the customer care advocates while interacting with customers.

The Enterprise Application Integration (EAI) acts as middleware application at Sprint PCS

The middle ware application takes part in the various business processes at Sprint PCS from creating account, adding subscriptions, activating billings etc

It acts as a service broker to the various front ends like FAST, PREMIERE and SPDE. Also acts as a data broker to the front ends by replicating data from back ends like Converges (P2K), NMS, QPST and QXDM, Amdocs and ASI.

The EAI application constitutes various business logic modules developed primarily using C++, J2EE framework.

Responsibilities:

Involved in writing test plans and their corresponding execution using QTP.

Involved in designing of Test scripts for Sprint CDMA Devices based on the System requirements from the Business Analyst.

Involved in the design stages of the Application and participated in the meetings with the client, Business Analyst and the development team & followed Agile Methodology.

Created a Functional test plan for every major release for Wired & Wireless application testing of SPDE

Prepare Test Data for CDMA Device Using Ensemble (CSM)

Supported the QA environment 24x7 as a Primary tier of support which involved trouble shooting by checking logs

Involved in creation of data in P2K & Ensemble for all test environments in all major release

Worked with development team to ensure testing issues are resolved using Change Synergy

Created Test Data with tasks: Administration, Data Modeling & Data Generation using CA’s TDM tool

Involved in Production Cycle0 as well as Test Environment Cycle0 too.

Involved in various meetings includes ADD, Release and Project status calls.

Checking the database for database validations using TOAD.

Activate Mobile Device (Cell) in Test/Production environment. Verify the exiting functionality of Sprint Application for Mobile in Test/Production.

Verify CDMA Device/Mobile Phone is functioning exactly as expected by Client/Vendor. After testing Sprint application de-activate mobile device.

Extensively used Change Synergy tool to log the update and track defects.

Extensively involved in knowledge transfer for Sprint & IBM team in order to train them on various tools and test support.

Environment: Java 2(J2EE), JavaScript, Change Synergy Release 4.3, Web Sphere 6.0, Web Logic 8.1, TODD 7.6, Oracle 9i, MS word, and Windows 2000, QTP(UFT).

Educational Summary:

Post Graduation Diploma in Computer Applications (PGDCA)

Bachelor of Science in Mechanical Engineering



Contact this candidate