Sr. QA Analyst

Madhavi Katragadda

*******.***********@*****.*** 678-***-**** www.linkedin.com/in/mkatragadda

Page 1 of 3

SUMMARY

Software tester and lead with over 7 years of experience testing web and sever side applications in Linux and Windows.

• Self-starter who can take ownership of test planning and execution for a whole project.

• Expertise in performing different types of testing including Black Box, White Box, Integration, Stress, Regression, Performance, GUI, Functional, and User Acceptance Testing.

• Extensive SQL experience writing complex queries across multiple schemas, performing data analysis, loading test data.

• Experience interacting with Linux systems to check logs, start/stop servers, change settings etc.

• Experience preparing test plans, test cases, test scenarios, documentation and execution.

• Performed browser compatibility and internationalization testing.

• Ability to communicate and work closely with BAs, DBAs, System Admins and Developers

• Excellent track record of successful completion under aggressive deadlines.

• Strong planning, analytical, problem solving skills and organization skills.

• Experience coordinating and working in a team(s) that includes onsite and offshore resources. TECHNICAL SKILLS

Operating Systems: Unix, Linux, and Windows

Languages: SQL, HTML, XML, Shell Scripting

Databases: Oracle, SQL Server, and DB2

Browsers: Internet Explorer, Firefox, Chrome

Debug Tools: IE Developer Tools, Firebug, and Chrome Developer Tools Test Tools: HP Quality Center, HP ALM, Change point, CARS Workbench, Mediation Zone, Kettle, Poster, SOAP UI, JIRA, WinScp

EDUCATION: B.S in Engineering, Chennai, India

EXPERIENCE

Verizon Wireless - Integration Tester May 2013 – Nov 2015 Part of the integration team for JiTR application, which includes EVF, RIW, Seader, Loader, Recon, EOC components. Interacted with RBM to rate and bill the usage. Responsibilities:

• Acted as a primary integration tester on End Of Cycle, Reconciliation & Creating Usage.

• Executed the core commands to rate and bill the customer accounts in RBM.

• Created extensive test cases that are known for clarity and details.

• Worked with large set of XML, CSV, txt, and DAT data files, used in data mediation software.

• Developed complex SQL queries to get information from multiple schemas in Oracle DB.

• Interacted extensively with Linux systems to verify logs for debug and error info, stop/start servers to create input files, update permissions.

• Worked with business analysts, LTAs, and developers to clearly identify the defects and verify after they have been fixed.

• Has been asked to compliment and contribute when other testers are under tight deadline and have always lived up to high expectations

• Trained several testers to transfer knowledge and server as my backup.

• Worked on projects dealing with Mediation Zone (data integration / ETL tool) for various systems.

• Always handled production defects in a timely manner without missing any validation

• Known within the team for detailed and clear documentation for test results that included screen shots, input and output files and any other application information.

• Tested web services exposed by the application using poster.

• Helped system test team during crunch time to meet the deadlines for few releases

• Used HP QC/ALM to track defects, create and execute test cases

• Create Traceability Matrixes to ensure test cases were mapped to correct requirements Madhavi Katragadda

*******.***********@*****.*** 678-***-**** www.linkedin.com/in/mkatragadda Page 2 of 3

Environment: MediationZone, HP QC 10.0 / ALM 11.0, Linux, Putty, Super Putty, SQL Developer, Oracle, Web services, WinScp, Poster

Intercall - Sr. QA Analyst Oct 2012 – Feb 2013

InterCall provides wide variety of services related to conference calls and online meetings. Usage Management System (UMS) is a mediation application that addresses the need for flexible, reliable, and cost-effective usage processing of services provided to InterCall customers. Responsibilities:

• Used Agile process for SDLC.

• Participated in Smoke, Regression, Integration and End-to-End testing.

• Wrote test cases and tracked defects in Quality Center.

• Used Kettle tool (Pentaho ETL tool) to run regression jobs and analyzed results.

• Frequently performed SQL queries that include sub-queries and joins (inner, right outer, left outer) to verify data shown on UI and reports matches what is in the database.

• Worked with SQL extensively to cross check data against multiple schemas and dbs.

• Reviewed the log files in Linux environment for real-time error messages to identify problems.

• Created defects with detail information that includes input test data expected and received results, and errors in server log.

• Tested collection and mediation process for billing.

• Tested billing options for scheduled and operator assisted conference calls.

• Tested billing charges based on conference options selected and actual results.

• Mocked test data in xml files and uploaded to database.

• Created mock data and uploaded to different environments to simulate real user interactions.

• Tracked and verified defects and enhancements in JIRA during product upgrades.

• Used SharePoint to share the documents with in the product development team. Environment: Kettle, Quality Center 11.0, DB Visualizer, Linux, Cyberduck, Java, Oracle, JIRA HealthStream - Sr. QA Analyst Feb 2012 - Aug 2012

SimCenter is simulation software for medical professionals and students to help simulate patient scenarios like births, pediatric services, cardiac assessments etc. This will enable healthcare service professions and organizations alike to meet and/or compliment their training needs. Responsibilities:

• Coordinated onshore/offshore QA team

• Wrote test cases and tracked defects in Quality Center.

• Used TFS & Mingle tools for agile process.

• Participated in Scrum meetings (daily stand-ups, planning, review and retrospective).

• Participated in backlog grooming.

• Identified QA tasks for user stories and provided time estimates.

• Demonstrated the features to product owner in review meetings.

• Tested application in different environments: Buddy, DR, Mudpit, Production & Flex.

• Tested in multiple browsers: IE 7/8/9, IE Compatibility view, FireFox, Chrome

• Performed globalization (i18n) testing using resource bundles.

• Tracked and coordinated production issues.

• Managed production defect calls with clients.

Environment: Quality Center 10.0, Migle, TFS, Agile, .NET, C#, DB9, Sql Server 2008 R2, Commerce Server 2009, Jquery, Telerik Controls, Salesforce, IE Developer Tool Insuresoft - Sr. QA Analyst Aug 2010 – Nov 2011

Insuresoft’s flagship product, Diamond, automates policy rating and underwriting, issuance, billing, claims, and workflow administration for property and casualty insurance carriers and managing general agents.

Responsibilities:

Madhavi Katragadda

*******.***********@*****.*** 678-***-**** www.linkedin.com/in/mkatragadda Page 3 of 3

• Participated in Functional, Installation, Smoke, Regression, Integration, System, End-to-End, User Acceptance and Configuration testing.

• Interacted with Unix systems to check log files, start/stop servers, change settings etc.

• Reviewed the log files for real-time error messages to pin point the problems.

• Executed shell scripts to generate SOAP requests that get sent to specific end point and verified xml response for expected result.

• Tested web services and validated WSDLs

• Involved in database testing by writing SQL statements.

• Prepared test data for various levels of testing.

• Developed and updated Test Cases in Quality Center.

• Participated in production support and attended calls to perform smoke tests.

• Performed cross-browser testing with Firefox, Chrome, Safari and IE. Environment: Quality Center, Unix, SOAP UI, Web services, WSDL, Oracle, SQL Developer Macy’s Information and Technology - QA Analyst Oct 2007 – Mar 2009 Tested Size Profile Analysis (SPA), an intranet web-based application, which allows the Size Analyst user community to do order management and size analytics for Macy's store locations. Responsibilities:

• Wrote test cases for Smoke, Functional, Regression, E2E and UAT.

• Executed the test cases and reported the defects in Change point.

• Worked extensively on CARS Workbench for executing test cases.

• Assisted the team lead in creation of test plan.

• Wrote SQL queries to fetch and update data for testing.

• Supported SPA integration with other projects.

• Supported UAT users by answering their questions and explaining application navigation.

• Participated in load and performance testing using shell scripts. Environment: Unix, Java, Oracle, SQL, Teradata, Change point, CARS Workbench. Primerica - QA Analyst Jan 2007 – Aug 2007

POL Security III/ NFE defines the processes and functions that control access to and management of POL accounts.

Responsibilities:

• Worked with users and business analysts to gather requirements.

• Participated in meetings to distinguish between bugs and enhancements.

• Created and updated test cases based on new specs and executed them.

• Performed backend testing in Mainframe environment.

• Used ISPF Line Commands.

• Used CICS to act as an interface between the OS and application programs.

• Wrote and executed queries in DB2 to validate and retrieve data after transformation. Environment: DB2, Mainframe, Unix, SQL Navigator

Northwestern Mutual (NM) - QA Analyst Aug 2006 – Nov 2006 Tested IT Asset Center application that helps procure, maintain and dispose assets of agents. Responsibilities:

• Wrote all the test cases for this project.

• Performed Manual Testing for the entire application by executing the test cases.

• Developed and maintained the Traceability matrix between requirements and test cases.

• Analyzed BRDs and interacted with business analysts and developers constantly. Environment: Quality Center, .NET, SQL Server, Toad, Traceability matrix

Contact this candidate