Senior Qa Analyst/ Etl Tester Resume
Dunwoody, GA
PROFESSIONAL SUMMARY:
- Over 12 of experience in QA testing of software systems in Web based, Client/Server, and mainframe applications using Manual and Automated testing tools Specialized in reviewing Requirement Document, System Requirements, Infrastructure Requirements, Work Flow Diagrams, and Architectural Diagrams. Documenting Test Plans, Test Cases and Execution of Test cases to verify application functionality against Business Requirements and Application requirements.
- Adept in using automation tools like Mercury Quick test pro, Test Director, Rational Test Suite, Win Runner and Load Runner and methodologies i.e. Rational Unified Process, Agile/SCRUM, waterfall, iterative.
- Strong understanding of QA Methodology, SDLC, Project development life cycle and QA Processes.
- Strong Experience in development and Implementation of Master Test plan and Test Cases.
- Solid Back End Testing experience by writing and executing SQL Queries, Nested Queries, Joins (Self, Cartesian, Inner, Outer) for Oracle Database.
- Identifying and creating test scenarios, test cases and executing manual test scripts.
- Extensive knowledge of the relational data modeling and relational database concepts like tables, Primary and foreign keys, Views and Referential Integrity.
- Strong experience with functional, integration, and regression testing techniques in validating web - based applications and services.
- Involved in to convert Business and System requirements into positive and negative test cases.
- Experience in change and configuration management and Experience with the overall Integration, and Regression Testing on Web and client server applications.
- Involved in the system testing, Integration Testing and regression testing process.
- Good experienced with SOAPUI Tool.
- Strong working knowledge of QTP, Selenium, Test Manager, Rational Robot, JUNIT, XDE Tester, Clear Case and Req Pro.
- Experience with Test data creation to Testing team and Dev team
- Experience testing, Created, edited and manipulating the files in UNIX Environment.
- Strong experience in data manipulation using SQL/PLSQL for the retrieval of data, used database triggers to audit the database values.
- Strong writing and analytical skills. Ability to communicate technical concepts in a non-technical manner.
- Defect reporting and monitoring the status using HP Quality Center, Clear Quest and Test Director Defect tracking tool.
- Experienced with Client-Server, Web applications and Mainframe, in industries like HealthCare, Insurance, and Mortgage, telecomm and Finance.
- Diamond (Professional Pricing methods and institutional pricing methods), Quest and Facets 4.x trained.
TECHNICAL SUMMARY:
Programming Languages: C, C++, Java, J2EE, COBOL, VB, Perl, C#, XML, XSLT, Shell Script, Test Script, and SquishOperating Systems: Windows XP/2000/ME/NT/95/98, 2003, UNIX, Linux, IBM3270, OS/390, IIS 5.0, IIS 6.0
Databases: SQLServer7.x, MS Access, Sybase, PL/SQL, MSSQL, MYSQL, Oracle6.x/7.x/10g, Microsoft SQL*Server 2000/2005/2008 , dBase II/III/IV
Web Technologies: HTML, Perl, JavaScript, VBScript, AREXX, XML, ASP, JSP, Servlets, Applets
Server Side Scripting: ASP, ASP.NET, PHP, and JSP
Testing Tools: Mercury Interactive (QTP, HP Quality Center, Test Director, Win Runner and Load Runner), rational tool suite (Rational Test Manager, Rational Clear Quest, Junit, JMeter, Rational Robot Clear Case, and XDE), Soap, JIRA5.0 and 6.2.
Tools and Packages: Adobe Acrobat Reader, Microsoft Office Suite, Web Services, Tibco CIM, SQL Navigator
Web Server: Tomcat, MS IIS
Networking: TCP/IP, HTTP, FTP
Reporting Tools: Siebel Analytics, Crystal Reports, Cognos 7.0/6.6 and Business Object
Case Tools: Rational Rose, UML Methodology
Version Control: Rational Clear Case, MS Visual Source Safe
PROFESSIONAL EXPERIENCE:
Confidential
Senior Test Advocate
Responsibilities:
- Analyzed business and technical requirements for creating test plan, test schedules, creating detailed test cases/scripts, creating/reviewing test cases and executing functional/system/integration testing.
- Analyzed Software Requirements Specification SRS and Software Design Description SDD documents to develop test strategies.
- Developed a broad understanding of the environment Confidential MST, to apply an understanding of the interoperability of systems, technologies and applications that may have an impact on the QA process.
- Involved in test case reviews and gets signoff on test cases from Project Team after updating suggestions.
- Involved in reviewing and updating the Test cases for requirements coverage and completeness.
- Working closely with Business Analysts to test the enhanced requirements.
- Work closely with Developers, Business Analysts and Project Managers.
- Involved in create Defects and Tracked defects using HP ALM Quality Center.
- Involved in testing both client server application and a hand-held device (MC 3190 Handheld), which are currently used in stores.
- Reviews and utilizes customer business and functional requirements in the development of test plans and scenarios.
- Involved in RFID cycle counts in May’s and BLMs stores using with MC 3190Z handheld devices.
- Involve in Smoke Testing, Integration Testing, Regression Testing, Configuration testing and UAT Testing.
- Involved in Fulfillments and Worked on creating Zones, Pick lists and complete pick lists and orders/reservations using POS Registers.
- Validating pick lists, open shipments, not found units, and Reservation details for Store Productivity Manager Application.
- Involved into Ring the tractions and fulfillments using MCE, BLM Registries.
- Performed testing on handheld devices ((Motorola 3190, 3190z and IPod touch) for Tyco patch.
- Provided data to the business analysts during UAT.
- Validating data on handheld, web & Database.
- Involved in testing the B-CONNECTED application (application developed for Bloomingdales customer directory) - Tested the application in both Web and mobile device (IPod) and Motorola 3190.
- Extensively worked on validating the application using the web services from SOAP UI.
- Executed SQL queries to test the different scenarios in the application.
- Created the Test Summary Report (TSR) to detail the testing effort such as Test Case ID, number of Test Cases executed, passed, failed and status of Test Cases.
- Involved validating IAPI log files with SPM functionality in GEMS.
- Created test Data (UPCs)for SIT and UAT testing Using ETL tool and EPS.
- Involved in Task details and communication can be tracked within the JIRA tool.
- Jira is a tool that allows the team to track tasks on a Scrum.
- Participated in User acceptance testing (UAT) meetings with business partners.
Environment: Selinium,QTP,Motorola 3190z Handheld devices, NOKIA LUMIA 920 Mobile device, XML, Oracle, SoapUI, Web Services.Net, HP Quality Center ALM 11 (Application Lifecycle Management), JIRA6.2, DCM 4.1, Java 1.6.0 18, Windows NT/XP,2008, IBM Mainframe,Lotus Notes 8.5, Web services,ETL Tools,SOAP UI 4.6, Oracle, SQL Developer, Windows XP, IBM DB2, Agile and Scrum
Confidential, Dunwoody, GA
Senior QA Analyst/ ETL Tester (Data creation)
Responsibilities:- Involved in all for segments of the planning, design, and execution of complex testing solutions (i.e., user acceptance testing, system, subsystem or interface testing).
- Participate in client meetings, ensuring that work products and deliverables are of the highest quality.
- Involved in communicate and coordinate planned work with an offshore team
- Participate in internal design review of testing materials; check test environment; execute, track and report on test execution using Quality Center 11 (ALM).
- Create and review test scenarios and test cases for completeness and accuracy, as well as, obtain business and development stakeholder approval and analyze results and communicate status.
- Interact regularly with client and Confidential teams to deliver timely, high-quality testing solutions Requirements.
- Used SQL developer to verify the data base changes while performing the functional testing.
- Involved in testing for I -Bill validation using the GLOBYS system.
- Performed Backend Testing, by executing the SQL queries.
- Executed the test scripts on different releases and validated the actual results against the expected results.
- Using Soap UI to perform API testing for CRM, WCSM, MVNE2, and prepaid applications.
- Billing was working with large, small, medium subscribers that the reports are as per the paper bills generated by Samson, with new socs added to the product catalog and the charges associated to the newly added socs.
- Used extensively XMLSpy to verify the XML elements and data generated by the I bill application.
- In VASA projects was verifying all the activities of a subscriber life cycle through GUI and SoapUI.
- Developed required SQL scripts for database testing using SQL and PL/SQL.
- Extensive experience in Database Testing on Oracle and SQL servers.
- Worked closely with middleware, engineering teams and vendors like (VESTA, Ericsson, Confidential, ePay, Siebel TCM) to ensure API’s are working and configured properly by reviewing XML’s, certifying OBRE’s, querying records in tables, using frontend UI’s or SOAP UI.
- Performed device (iOS/Android handsets or tables, mobile broadband laptops or hotspots), testing for various project as part of web testing and end to end, validating new web functionality for gosmartmobile.com and mobile tmobile.com for upgrades, usage, billing and rating, payments, authenticated and unauthenticated account management functionalities, auto pay, ISIS NFC on android devices. Part of this also included that all services SOA services that will impact the device based on the BRD’s and middleware IA.
- Wrote SQL statements to extract data from the Tables using ETL tools .
- Perform software acceptance testing and perform regression analysis.
- Prepared test status reports during test execution process.
- Executing and Managing SQL Back-End Testing for Data Validation.
- Participate in client meetings, ensuring that work products and deliverables are of the highest quality.
- Participate in internal design review of testing materials; check test environment; execute, track and report on test execution.
- Develop testing programs that addresses areas such as database impacts, software scenarios.
- Involved in testing with applications developed on multiple operating systems and mobile applications.
- Interact regularly with client and Confidential teams to deliver timely, high-quality testing solutions Requirements.
- Involved in RPX testing (RPX is most recent implementation of PAG’s main backend Services).
- Involved with integration testing. Coordinating testing efforts across multiple teams.
- Involved with writing test cases, creating bug reports, executing and tracking testing assignments and Defect tracking using the HP ALM Quality Center 11.0.
- Involved in data validation and cross-system testing.
- Working with distributed teams (offshore and offsite) for testing.
- Involved with ACC -Data Import and Export the Data from production to QA environments then provide to Testers using SQL Developer.
- Involved in creating SQL to extract data using SQL Developer.
- Involved in Pair with SIMS and MSISDN and send to Eng Team for loading the Data in to CNTDB.
- Executing and Managing SQL Back-End Testing for Data Validation.
Environment: QTP10.0, SQL Developer, MY SQL, Oracle10g, UNIX, putty, SOAPUI, SQL, PL/SQL Server, C, C++, Perl, Python, HTML, Citrix, CARE, XML, VBScript, Toad8.6.1.0, UNIX, Shell Scripting, HP Quality Center 11.0, JMeter, Java and ETL(Informatica)
Confidential, Atlanta, GA
Senior QA Analyst/ Lead (Off-shore)
Responsibilities:- Attended all phases of project reviews and meetings (design meetings, business requirements, system requirements, functional requirements, and model based analysis and status meetings).
- Analysis of Business Requirements, System Requirements, Functional Requirements and Highly design documents and Application Design Documents.
- Involved in present test strategies, test plans and test status to management, business and development partners.
- Maintain updated documentation for assigned network devices and share newfound information with the team.
- Involved in create and review test strategies, test plans, test cases, and test data.
- Involved in Creating Test cases and Executing test cases Using ATF and Other tools with UNIX.
- Involved in testing, Created, edited and manipulating the files in UNIX Environment.
- Strong experience in data manipulation using SQL/PLSQL for the retrieval of data, used database triggers to audit the database values.
- Working on UNIX Platform Using UNIX shell scripting, Java Script, Perl, Java, XML.
- Solid Back End Testing experience by writing and executing SQL Queries, Nested Queries, Joins (Self, Cartesian, Inner, Outer) for Oracle Database.
- Understanding the systems, their compatibility issues, and interactions with various other components Cisco and Confidential & Confidential Global Network client.
- Involved in creating complex queries for Teradata testing.
- Identify bugs and suggest suitable work around / Fix’s etc.
- Tracking the defects by using testing tools (WebTrax and Quality Center).
- Work closely with the other members of the Development Team and implement test plans, and test the quality of software products.
- Strong working experience with applications running on UNIX, Solaris and write and execute basic UNIX commands and scripts.
- Involved and Identify the ATF Results on the Web for Simple MRC/SBP Session.
- Attended the Status meeting and Co-ordinate with Off-Shore Team.
- Attended the Test Cases Reviews meeting and Trained to Jr Testers.
Environment: SQL Developer, Teradata, Oracle 10i, TELEGENCE, CARE, Business, Balance Manager, WebEx, Journexy, Objects 6.5, Java Script, Sun Solaris 5.8, Toad 8.6.1.0, Hyperion ESSBASE8.i, UNIX, SCP and MQ, Quality Center 10.0
Confidential, Charlotte, NC
Senior QA Analyst
Responsibilities:- Analyzed user requirements and documented test requirements using HP’s Quality Center (powered by Test Director) requirement module.
- Created test plans, test cases and testing strategy for the planning and execution of test scripts and analyzing results, Conducted Black Box and White Box Testing.
- Automated Test scenarios for GUI, Functionality, Boundary, Security and Regression Testing using QTP.
- Developed reusable Quick Test Pro VB scripts and customized as per the test requirements.
- Updated and managed multiple scripts using Object Shared Repository.
- Extensively used Method Wizard to enhance modularity of the scripts.
- Extensively used Object Spy to view both the run time object methods and test object methods associated with an object.
- Extensively used Quick Test Pro Check points (Object Property, text, table, XML, HTML and database).
- Developed and Executed Test Cases and Test Scripts for Performance, Stress and Load Testing using JMeter.
- Developed scripts using Regular expressions to handle dynamic data names.
- Monitors implemented system’s performance and reviews data to identify and correct problems or to enhance the application's functions.
- Identified and categorized Monitoring Parameters to verify performance requirements.
- Created scenarios for peak load and off-load and measured the performance time for each transaction.
- Recommended Performance tuning and Optimization techniques.
- Monitored Windows and UNIX servers for Memory leakage, Processor Utilization, I/O Utilization, Page Faults and Network Statistics.
- Experience in writing test scripts and using with Test Director.
- Performed database testing using SQL queries by using Left, Right Joins and conditional Queries for the test\database used to identify the anonymous users of the application.
- Interfacing with Co-workers in preparing for and executing the tests scripts.
- Monitored the log files in UNIX for errors/warnings and written and executed UNIX shell scripts.
- Experience of reporting tools and involved in reports testing - Crystal Reports, advanced SQL usage.
- The modification requests (MR’s) were reported and tracked by using Mercury’s Quality Center (Mercury’s Test Director).
- Responsible for adding/deleting user’s and modifying their roles in Quality Center using the Admin role.
- Reporting progress through daily and weekly Agile Scrum stand-up’s meetings.
- Involved in tracking defects and enhancement using Atlassians Jira Agile Development Environment (JADE).
- Responsible for code deployment from Dev into QA and UAT environments.
- Participated in interviewing new candidates for the QA positions.
- Sign-off on test strategy, test development, and test results prior to implementation into production.
Environment: Quality Center 9.0, Test Director, MS Office, TOAD (Toad for Oracle 9.7.2), Jira Agile Development Environment(JADE), UNIX, LINUX, SQL Server, VB Script, Oracle, Visual Studio, Windows XP, Lotus Notes, Crystal Reports, C++, C#, Perl, Java, J2EE, JUnit, SOAP, JMeter, JSP, EJB, Java Script, HTML, XML.