Test Engineer Sql Server
Resume:
SRIDHAR CHIMPULA
*******.**@*****.***
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