SATEESH MAGGIDI Sr. QA Test Engineer

SATEESH MAGGIDI Sr. QA Test Engineer

SATEESH MAGGIDI Sr. QA Test Engineer

E-mail:
Contact: 408-685-1223

Professional Summary:

  • Over 8 years of IT experience in Software Testing of web based and Client-Server applications with full understanding of Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle in Global Marketing Information Services, Telecom, Social Networking, Banking, Insurance, and Pharmaceutical domains.
  • Extensive experience in writing Business requirement Documentation (BRD), Functional
  • Documentation and System Requirement Specification (SRS).
  • Extensive experience in developing Test Plan, Test Strategy, Test Cases, Test Scenarios, Test Scripts, Test Metrics, Test Reports
  • Proficient in System Testing, Integration Testing and assisted in User Acceptance Testing (UAT).
  • Experience in requirement Traceability Matrix (RTM)
  • Proficient in Black Box, System/Database, Interface, Functional, White Box, Regression, Performance, Smoke Testing, Sanity Testing, Ad-hoc Testing, Automation Testing, Test Harness and End-to-End Testing.
  • Experience in testing the financial transactions of different applications.
  • Expertise in using tools like Test Director/Quality Center, Jira, Spira, Rally Software, QTP 9.5/10.0/11.0 ,Win runner, Bugzilla and Test Track tools for Defect Tracking.
  • Testing the mobile APPS and creating test cases and test plans and Having good experience in CRM creating and testing in different environments.
  • Expertise in using CRM for data and testing purpose.
  • Expert in Using Automation tools like QTP and Load Runner and Experience in testing web applications utilizing QTP and Win runner.
  • Expert in QTP Linear Frame work, Data Driven Frame work and Hybrid Frame work.
  • Is capable of setting up a test environment for testing different web browsers, operating systems, virtual machines, install testing tools, and database software
  • Hands on experience in HTML, XHTML, SOAP, XML, Web Services.
  • Ability to collaborate with testers, developer, project managers and other team members In

testing complex projects

  • Expertise in protocols SOAP, HTTP, FTP, TCP/IP.
  • Good at Oracle & SQL databases, PL/SQL, T-SQL, Joins, SQL Queries.
  • Expertise on Testing Web Based Applications.
  • Goal oriented professional with strong analytical, verbal and written communication skills, interpersonal and Organizational skills.

Technical Skills:

Testing Tools:Quick test Pro , Quality Center, Rally Software, Jira, Spira, Test Director, Win Runner, Silk, Load Runner,TFS and Rational Test Manager.
Operating System:Windows NT/95/98/2000/XP/Win 7 e.t.c, MAC 10.7, chrome OS,UNIX, HP-UNIX, MS-DOS.
Languages:C, C++, SQL, JAVA, and PL/SQL.
Databases:MS Access, Oracle, SQL Server.
Front-End:Visual Basic, Developer 2000, and Power Builder.
Script:VBscript, UNIX.
Other Tools:MS Office Suite, Clear Case, Clear Quest, Visio.

Education Qualification:

BTech in Electrical and Electronical Engineering, JNTU University, India.

Professional Experience

Experian

Costa Mesa, CA Mar 2013-Current

Sr. Quality Assurance

Experian is a leading Global information services company, providing data and analytical

Tools to client in more than 65 countries. The company helps business to manage credit risk,

Prevent fraud, targeting market offers and automate decision making .Experian also helps individuals

To check their credit report and credit score.

Roles and Responsibilities:

  • Conducted walk through meetings with team leads, analyst and developers in discussing the requirements and to test environment to be setup and writing test cases.
  • Testing the applications of all stage coach front and back end.
  • Performed Ad-hoc testing, smoke testing, Sanity Testing, Functional testing, Integration testing, Block Box, End to End, Navigational and Regression tests Back end validation Testing, End to End Testing.
  • Verifying billing for all transactions and different types of billing.
  • Testing all stage coach applications financial transactions performed through third party.
  • Verified and executed control – m jobs for all transactions.
  • Verified all different enrollments records in database.
  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
  • Developed scenarios for ETL testing and creating data for validating the data transformation.
  • Tested various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Writing SQL Queries for testing data that transformed through informatica.
  • Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
  • Running all daily and nightly jobs using unix and updating all parameter files as required
  • Validating Reports in cognos and verifying all transformed data.
  • Involved in Project co-ordination between different teams and onsite teams for maintaining mutual communication and update information by sending Daily Status Reports of maintenance and development of the project.
  • Conducted and involved in scrum daily stand-up meeting with project stake holders and off-shore resources analyzing defect and discussing on-going automation development.

Environment: Serina, Test Link, Putty, Visual studio, QC/ALM, Quality Center, Rally Software, VBScript, Microsoft Office 2010, SharePoint, Microsoft Communicator 2007, HTML, Excel, Unix, SQL Server.

Professional Experience

J.D.POWER & ASSOCIATES (McGraw-Hill) Sep 2012 – Feb 2013

Westlake Village, CA.

Sr.QA Tester

J.D. Power and Associates is a global marketing information services company operating in key business sectors across a variety of industries, providing customer satisfaction research, market research, automotive forecasting, social media research, and performance improvement programs. Established in 1968. J.D. Power and Associates is a business unit of the McGraw-Hill Companies. The Company expanded to serve a number of other industries, including telecommunications, travel and hotels, marine, utilities, healthcare, homebuilder, consumer packaged goods, electronics and financial services.

Roles and Responsibilities:

  • Involved in manual testing and writing test cases for the Web based different Applications.
  • Conducted walk through meetings with manual QA and developers in discussing the framework and test environment to be setup, schema to be designed and tables under test to be pulled in for validation.
  • Performed POC (Proof of Concept) for QTP 11 to overcome WPF (Windows Presentation Forms) issues persisting in testing the application.
  • Have setup environment for the team by installing QTP 11, QC/ALM and all required, establishing connections to the database servers and also done integration testing between the applications to setup test environments.
  • Developed automation framework from scratch, for automated comparison and automated regression testing for the different Applications.
  • Developed Excel object and HTML framework for creating and reporting the test result files in excel format and as cross-platform compatible HTML formats.
  • Created, Developed and maintained Application areas which consist of Object repositories, function libraries.
  • Developed and scripted Automation Frameworks and in developing scripts in Descriptive programming of VB Script for QTP automation and in deploying and executing the existing and developed test cases in QTP 11.0
  • Involved in Project co-ordination between offshore and onsite teams for maintaining mutual communication and update information by sending Daily Status Reports of maintenance and development of the project
  • QTP 11 has been used for automation development of this framework and development and defect analysis has been done on the same using Quality Center/Application Lifecycle Management (QC/ALM 11)
  • Automation testing for recording, extraction and validation phases has been in place and have developed framework for database record validation between different available and needed schemas.
  • Conducted and involved in daily stand-up meeting with project stake holders and off-shore resources analyzing defect and discussing on-going automation development.

Environment: QTP 11.0, QC/ALM, Quality Center, Rally Software, VBScript, Microsoft Office 2010, SharePoint, Microsoft Communicator 2007, HTML, Excel, Unix, SQL Server.

Professional Experience
AT&T March 2011- August 2012
San Ramon, CA.
Sr.QA Tester
AT&T, Inc. is one of the world’s leading Data, Voice and Internet service providers. Through its world-class networks, AT&T provides a full range of voice, data, networking and e-business services, as well as directory advertising and publishing. A Fortune 30 company and Americas leading provider of high-speed DSL Internet Access services, AT&T currently serves 57 million access lines nationwide.
Roles and Responsibilities:

  • Participated in Walk troughs with Team lead, System Analyst, HCD Designer, Project Coordinator and the Development team to discusses the outstanding and scope change requests and Attended triage meetings to understand and consider the scope changes for the release during the test execution phase.
  • Testing data creation and collecting standardized test data request information, verify requests and translates parameters into detailed application transactions and CRM system is used for order management.
  • Involved in developing and scripting Automation Frameworks and in developing scripts in Descriptive programming of VB Script for QTP automation and in deploying and executing the existing and developed test cases in QTP 10.0.
  • QTP 10.0 has been used for automation development of this framework and development and defect analysis has been done on the same using Quality Center.
  • Expertise in Testing Web based Application testing.
  • Performed Ad-hoc testing, smoke testing, Sanity Testing, Functional testing, Integration testing, GUI/design, Block Box, End to End, Navigational and Regression tests Back end validation Testing, End to End Testing.
  • Involving the testing in billing process using the debit and credit transactions.
  • Involved in testing different AT&T registration pages in different environments and verifying the results in different sub-systems UST (Universal sync tool) as a part of Back-end testing.
  • Worked with offshore team involved in planning and production implementation and validation.
  • Reviewing the test cases for the current releases, executing the test cases manually and using automation tool, test planning, test plan preparation, functional testing, system testing, test script automation, automated test execution, test reporting and logging defects.
  • Performed testing using APIs and Testing IPV4 and IPV6 testing.
  • Analyzed results, managed defects and issues using Mercury quality Center ,Carried out Performance.
  • Involved in ETL testing using Informatica and validated data.
  • Performed data validation after transformed from source to destination.
  • Testing on existing applications, Written and executed test cases in HP Quality Center for the release.
  • Validating the back end logs by using tool Remotex and putty using UNIX and Testing the SPI encryption fields and validating in logs.
  • Written and Executed SQL queries to access the Data Base(MPS) for checking result.

Environment: REMOTEX,API SIMULATOR,UST,QTP, SOAP, QA Tracker, PUTTY, XML, ASCII/TEXT, SQL Server 05/08, Windows NT/2000, MS Office ,QTP, Quality Center , Unix.

CML Media Crop,
Los Angeles, CA. May 09-Mar 11
Sr.QA analyst

Description: In TheMO is a social network and city guide used to connect with friends and get recommendations for spots around the world. Find out who's visiting your profile and get detailed reports and users can claim the business.

Responsibilities:

  • Review Business requirement documentation, Functional documentation and Technical Documentation.
  • Involved in writing and enhancements to Test Plan and developed Test Strategy, test Cases, test Scripts for functional and automation.
  • Performed testing in mobile(Iphone) and Ipad(tablet) for the apps and application(( append Imo available in app store which i worked on)
  • Involved in mobile Application testing in Ios and also cross browser,compatibility testing.
  • Involved in application testing like video,audio and media files
  • Performed Video testing in different formats, testing audio and compatibilities.
  • Performed Application GUI ,functional testing and reported issues.
  • Performed Ad-hoc testing, Sanity Testing, System health check before start testing officially, Functional testing, regression Testing, Manual and automation Testing, Integration testing, Backend validation Testing, End to End Testing.
  • Interact with Project manager, business analysts and developers to understand the application design and functional specifications.
  • Identified and executed manual and Automation test cases.
  • Extensively involved in UI testing.
  • Performed testing for GUI of functional regression by using squish tool.
  • Involved in Performed testing for GUI automation for functional regression squish tool.
  • Coordinate testing tasks and activities with project teams and IT staff.
  • Created and implemented functional tests using QTP and customized QTP scripts with VB scripts.
  • Verified checkpoints using QTP.
  • QTP 10.0 has been used for automation development of this framework and development and defect analysis has been done on the same using Quality Center.
  • Testing Data ware house that all the data is transformed correctly and testing data transformation and quality,performance,integration and regression testing.
  • Performed White Box Testing..
  • Performed ETL testing and validated data.
  • Documented the lessons learned.Prepared Test Metrics Summarizing Defect Summary along the various parameters, Test Productivity.
  • Responsible for understanding high level (cross-platform) business processes related to their application area and its interfaces to other applications.
  • Participate in all team meetings, coordinate testers, resolve issues, and provide overall direction.
  • Involved in planning process and investigate automation scripts to do the testing versus manual test scripts.

Environment: SAP QA, ABAP/4, EAI, JAVA, Web Sphere, SSO, QA Tracker, Main frame, CICS, XML, ASCII/TEXT, SOAP, CGI, Linux, SQL Server, Oracle, Windows NT/2000, MS Office Suite, Load Runner, Informatica,QTP, Quality Center 9.0, Unix and NT, Jira, Spira.
Prudential Financial Inc, Pleasanton, CA. Mar 08-Apr 09
QA Test Engineer
Description: Prudential Financial Companies serve individual and institutional customers worldwide and include the Prudential Insurance Company of America, one of the largest life insurance companies in the U.S. these companies offer a variety of products and services, including mutual funds, annuities, real estate brokerage franchises, relocation services, and more..

Responsibilities:

  • Created and executed the test scripts using Win runner to test functionality, acceptance and limit validations.
  • Analyzed results, managed defects and issues using Mercury quality Center to present in team meetings held on a weekly basis. Carried out Performance Testing on existing applications and Prepared Test Plans.
  • Responsible for User Interface(UI) Testing.
  • Business requirements and create detailed test plans and conditions.
  • Responsible in the Design, Creation and Maintenance of Test Plans.
  • Involved in Regression, Automation Testing and extensively worked on back-end / database testing (Oracle, SQLServer) and validating the application against the front end application.
  • Created, Developed and maintained Application areas which consist of Object repositories, function libraries, and recovery scenarios.
  • Provided Subject Matters Expert (SME) when required.
  • Invovled in testing Mainframe/COBOL/SQL based applications
  • Invovled in testing the overall functionality of the system,ensure connectivity between Java Frontend and Mainframe Backend using CICS calls,generation of test scenarios, execution and report generation
  • Interacting with customers through issue tracker database to resolve issues.
  • Reviewed, maintained and improved existing test conditions.
  • Performance, load & stress testing to avoid system downtimes, potential bugs to achieve standards set by business rules.
  • Designed input data sheets.
  • Involved in Test Harness Building.
  • Involved in SSIS package testing.
  • Used SQL Server to validate report generated using applications.
  • Experience in data warehouse testing of ETL application.
  • Bugs-tracked and reported using Test Director, and managed entire Testing Process from designing to coding to analysis.
  • Carried out data analysis to analyze various issues on project.

Environment: Win Runner, Test Director, VB, ASP, Dot Net Frame Work, IIS, MS SQL Server,

Mainframes, Windows XP, MS word, Ms Excel, Internet Explorer and Fire fox.
State farm insurance, IL Jun 07–Feb 08
QA Tester/Analyst.

Description: The State Farm is one of the largest insurance companies and is leading providers of life insurance, health insurance, automobile and homeowner products. This project is a critical system that supports several major functions such as Client Account (rating/quoting, policy issuance), Billing & Enrollment, Claims and document generation with interfaces to G/L.

Responsibilities:

  • Involved in reviewing Systems Analysis, Business requirements, and Use Cases.
    Designed Test Plan and participated in writing Test Scripts and Test Cases using Test Director.
  • Performed manual testing in Claims and Billing modules and executing scripts manually in Quality Center.
  • Validating check numbers and the amount printed after the payment Run job is processed and comparing online.
  • Running SQL queries to validate data in tables after batch run as part of Database Testing.
  • Performed Positive and Negative testing using valid and invalid data on development, Test Database
  • Environments on MS Access and Oracle.
  • Performed Automation testing on billing modules using QTP and Mercury Quality center.
  • Involved logging bugs in Test Director that are found during the process of testing and running Defect
  • Reports for status meetings.
  • Interaction with developers, users and management to speed up the defect resolution.
  • Involved in Database Testing to verify the data in database tables on Oracle 9i.
  • Involved in Production checkout after implementing application successfully and used PVCS tracker to log any production issues.
  • Developed Test metrics on the weekly basis for senior management using MS Excel.

Environment: Mercury Quality Center, QTP 9.2, Windows XP, Oracle9i, Oracle Reports 6.0, Oracle Reports 6.0, Oracle ERP, SQL, C++,MS Excel, MS Access, UNIX, PVCS Tracker, Web Logic.
Farmers Insurance, CA. Feb 06-Jun 07
QA Analyst.

Top View