We provide IT Staff Augmentation Services!

Etl Qa Analyst Resume

3.00/5 (Submit Your Rating)

Carrollton, TX

SUMMARY

  • Excellent working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) in Requirements gathering, Analysis, Design, Development, Implementation and Testing Methods like Waterfall, RUP & Agile (Scrum).
  • Extensive experience of manual, automation and web service testing of applications and use of Mercury Quality Center, Quick Test Pro/UFT/ Selenium Web driver and API Testing using REST and SOAP UI
  • Good knowledge on web services tools REST API and understanding of HTTP code responses.
  • Created and maintained automated test scripts for API using Java/TESTNG
  • Involved in testing of services usingSOAP/RESTservices usingSOAP UI, Groovy Scrip
  • Thorough knowledge of XML, WSDL and SOAP Protocol.
  • Experience in working with Data warehouse, data marts and relational database projects.
  • Good knowledge in Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
  • Good knowledge of Salesforce configuration, Data migration, System integration Testing.
  • Design and develop the cloud validation platform with extensive automation for CI/CD using groovy,Jenkinsto create a sustainable eco - system for automation testing
  • CI/CD were used forAWS/Azure/Native Cloud deployments
  • Maintenance and development of in-house deployment orchestration platform integrated with Jenkins and git.
  • Complete exposure to quality assurance, analysis and testing for client-server and web-based application with extensive knowledge in thePOS, pharma and telecom domain.
  • Experience in Design and Development of Automation Framework using Quick Test Professional.
  • Hands on experience on Test Planning, Test Scheduling, Test Designing, Test Estimation, Defect reporting, Defect Prioritization and tracking, Test result analysis.
  • Good Experience in preparing Test Plans, Test Strategies, Test Scenarios, Test cases, by reviewing Business Requirements, Software Requirement specifications and creating Gap Analysis for test purpose
  • Prepared Requirement Traceability Matrix (RTM), Compliance Matrix and System Design Documents
  • Demonstrable experience on GUI, Regression, Functional, Integration, System, User Acceptance, Sanity, Performance, Stress, Reliability, compatibility, Cross Browser, Mobile, Security and Database Testing.
  • Experienced in documenting defects using the bug tracking database, providing verifications on fixes in multiple environments, and communicating fix success, failures, status updates as appropriate using Bug tracking Tools.
  • Experience in working with open-source toolsSelenium (Selenium IDE, Selenium Web Driver), JUnit, Eclipseand preparation of automation test framework.
  • Developed the Test case Repository that contained the pool of Regression Test cases of the business-critical components for building the Automated Regression Test suites
  • Proficient in Stress/Load testing and Performance testing for Web based and Client Server applications on Windows and UNIX platforms.
  • Proficient in various UNIX commands as well as executing Shell Scripts.
  • Actively involved in planning and coordinating the test activities, defect status with the onsite and offshore team.
  • Actively designing, running and communicating to all involved parties to ensure that end-to-end testing is successfully completed.
  • Exposure of preparing and presenting Test Execution Reports, Defect Report, Weekly Status Reports to the project team.

TECHNICAL SKILLS

Testing Methodologies/ Tools: Black box Testing, Integration Testing, GUI Testing, Ad-hoc, Regression Testing, System Testing, UAT, HP QC, QUALITY CENTER / ALM, QTP/UFT, Test Complete, ETL, HP SOA, SOAP-UI, JREST, JIRA, CI/CD

Methodologies/ Processes: BPM, Agile, Waterfall, Rational Unified Process, RAD, Use Case and UML.

Tools: MS - Visio, MS - Project, Project Central, SharePoint, Rally, Version One, Active VOS Designer

Databases: MS Access, My SQL, Oracle, SQL Server, Salesforce, Azure

Programming Languages: XML, HTML, Webservice, Java, Groovy, C, C#, .Net, Junit, Visual Basic, PL/SQL, Python, Shell Script

Others: Windows, MS-DOS, MS-Excel, MS-PowerPoint, Mac, Linux, UNIX, Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Carrollton TX

ETL QA Analyst

Responsibilities:

  • Work under Agile methodology attending daily Scrum calls with 4 to 2 weeks’ sprint timeline which were tracked with TFS.
  • Participate in Backlog, Sprint Planning Meetings and Sprint retrospective calls.
  • Actively participating with the development team for building the functional and regression test cases as per the scope of the sprint.
  • Writing test plan and test cases based on the user stories / requirement.
  • Show and Tell the team to demo the test coverage achieved during the sprint
  • Proactively sharing the knowledge across the team for new processes
  • Explore emerging tools and technologies to implement test automation
  • Use TFS for creating and tracking the status of defects.
  • Heavily worked on SQL Server Data Warehouse or Database intensive environment.
  • Hands on experience with T-SQL to create queries with complex joins.
  • Validated requirement specific functions to interact with REST API service and external data sources like Database, Excel, JSON and XML files.
  • Created test scripts usingGroovy scriptto automate web services inSOAP UI.
  • Tested salesforce standard objects (Campaign, Accounts, Contacts, Opportunity) and custom objects, page layouts, fields validations and its access to the user based on defined profile.
  • Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
  • Automated the test scenarios using SQL Server and Python.
  • Worked on validating the reports in Power BI
  • Worked on multiple .Net applications and automated the results with REST assured
  • Created the automation test scripts in Selenium WebDriver using Java for validating the client applications.
  • Design and develop the cloud validation platform with extensive automation for CI/CD using groovy,Jenkinsto create a sustainable eco-system for automation testing
  • Worked on CI/CD forAzure/Data Bricks
  • Perform sanity, smoke, usability, functionality, GUI, browser compatibility and regression tests.
  • Coordinate with offshore/onshore team to share knowledge and work effectively in a daily basis.
  • Participate in System Integration Testing and User Acceptance Testing.
  • Work closely with the development team on a day-to-day basis
  • Work closely on all the defects and track their status on a day-to-day basis for the defect calls and prioritize the defects
  • Actively involved in creating the test matrices for the reporting purpose.

Environment: Visual Studio, TFS, SSRS, SSIS, My-SQL, API- REST and SOAPUI, JSON, .NET, XML, Groovy Script, Selenium, Java, Python, CI/CD, AWS, MS-PowerPoint, MS Office, Groovy, Jenkins, Power BI, QlikView

Confidential, Dallas TX

Senior QA Analyst

Responsibilities:

  • Work for the Airline Reservation, Ticketing and Check-In System for the Reservation and Airport Application.
  • Work under Agile methodology attending daily Scrum calls with 4 to 2 weeks’ sprint timeline which were tracked with Version One.
  • Participate in Backlog, Sprint Planning Meetings and Sprint retrospective calls.
  • Write the test plan and test cases based on the user stories from the Functional Specification documents.
  • Demo team about each sprint release Confidential end of each sprint testing and proactively sharing the knowledge across the team for new processes and emerging technologies.
  • Proactively sharing the knowledge across the team for new processes
  • Explore emerging tools and technologies to implement test automation
  • Use JIRA and ACSP for creating and tracking the status of defects.
  • Use SOAP-UI to validate the request and response for all the transactions for the payment systems in XML.
  • Involved in testing (Manual/Automation) the full functionality ofPOS(Point Of Sale system) from end to end.
  • Created and ran functional tests on web services prior to implementation.
  • Created MOCKS for web services testing.
  • Performed Data Driven Testing and validated response using assertions in SOAPUI for validations
  • Work on ETL using SAP Data Services to perform all the data transactions coming from Amadeus system.
  • Conduct the testing for Data Integration which finally carries the fulfillment process for the Siebel system and verified the generated files with the incoming and outgoing file format.
  • Identified automation candidates, designed and developed custom framework using SoapUI
  • Write Test scripts for web applications with Selenium WebDriver using Java and perform the code reviews with the team.
  • Involved in performing Functional, Application, Integration, System, Regression and End to End testing.
  • Wrote UNIX scripts for regression testing and configured Jenkins Jobs to execute them and consolidated result using post build Jenkins scripts.
  • Test server configuration and administration for continuous integration using Jenkins
  • Perform sanity, smoke, usability, functionality, GUI, browser compatibility and regression tests.
  • Coordinate with offshore/onshore team to share knowledge and work effectively in a daily basis.
  • Participate in System Integration Testing and User Acceptance Testing.
  • Work closely with the development team on a day-to-day basis
  • Work closely on all the defects and track their status on a day-to-day basis for the defect calls and prioritize the defects
  • Acting as the Lead for the offshore team and coordinated the tasks assigned on daily standup calls.
  • Actively involved in planning and coordinating the test activities, defect status with the onsite and offshore team.
  • Presenting the report to the team taken from ALM in Excel on a weekly basis.

Environment: HP ALM/VSO, MS-Excel, POS, MS-PowerPoint, ACSP/JIRA, Project Central, MS Office, SQL, Agile, Rally, ETL-SAP Data Services, Selenium Webdriver, Groovy, Jenkins, Java, Junit, XML, SoapUI, SOA

Confidential, Lewisville TX

Sr. QA Analyst

Responsibilities:

  • Worked as a backend tester and wrote extensive SQL queries.
  • Created test data payload as per the XML schema provided in the XSD and WSDL.
  • Validated web services using SOAP UI
  • Validated the API responded as per the provided XML schema
  • Executed XML Validation, added parameterizations and assertions in the script using SOAPUI.
  • Checked the broken links in the application and conducted cross browser testing.
  • Worked as an API and backend tester under Agile methodology attending daily Scrum calls with 4-week sprint timeline which were tracked with Rally/TFS
  • Worked on ETL and SAP data services.
  • Wrote extensive SQL queries to verify the result coming from the 3rd party.
  • Worked on Extracting, transporting and loading the data as per the business need.
  • Executed the 3rd party testing for Verizon. Worked on Verizon Wireless (VzW), Bed Bath and Beyond, Miller Coors and Anheusher Baush fulfillment process.
  • Conducted the testing for Data Integration which finally carries the fulfillment process and verified the generated files with the incoming and outgoing file format.
  • Performed compatibility testing with various mobile handsets to ensure that functionality working as expected. Verified the application is working on the mobile emulators also.
  • Tested embedded application software on various mobile devices, including smart phones and tablets
  • Identifying and preparing test data for Manual and Mobile Testing.
  • Very good exposure of testing applications on wide range of Mobile handset of different vendors which includes Nokia, Samsung, Google G1, Sony Ericson, Motorola, Windows Mobile, HTC, LG, I phone and many more.
  • Created the test cases and test planning documents for the team.
  • Executed all the backend testing process for Verizon Wireless which involves a third-party validation and heavily dealt with matching and merging of data coming from Verizon and third party and worked on survivorship.
  • Executed the front-end application and verified the result with Soap UI.
  • Verified the logs in putty.
  • Logged and tracked the defects using JIRA and Rally.

Environment: HP ALM, MS-Excel, MS-PowerPoint, JIRA, MS Visio, ACS Database, MS Office, SQL, Agile-ATDD and BDD, TFS, ETL, SAP Data Services, Java, Mobile Emulators, Mobile devices, XML, SoapUI, SOA, UNIX

Confidential, Southlake, TX

QA Analyst

Responsibilities:

  • Worked for the Airline Reservation, Ticketing and Check-In System for the Reservation and Airport Application
  • Created the PNR, worked on all the flight related features like checking, creating boarding pass, looking for Special services, connecting flights, upgrades and methods of payments
  • Worked under Agile methodology attending daily Scrum calls with 4-week sprint timeline which were tracked with Rally/Version One.
  • Participated in Sprint Planning Meetings.
  • Executed the End-to-End test cases for all the POS application.
  • Used JIRA for creating and tracking the status of defects.
  • Created the documents for the training purpose and uploaded in the SharePoint
  • Worked as manual tester to create test scenarios, test plan, test cases of system design documents.
  • Identifying and preparing test data for Manual and Mobile Testing.
  • Tested Web app, Native app using SeeTest for automating the mobile testing and run the scripts for multiple devices with VBScript using QTP/Test Complete, and also perform manual testing according to the requirements.
  • Validated Test case data in XML data files.
  • Performed the testing in various mobile devices.
  • Developed and automated Web Services API testing using SoapUI frameworks.
  • Created test cases using Element Locators and Selenium web driver
  • Involved in regression testing using Selenium.
  • Involved in tracking quality assurance metrics like defects, defect counts, and test results using JIRA.
  • Involved in generating Test cases for AS- IS to TO-BE scenarios for various business cases.
  • Involved in performing Functional, Application, Integration, System, Regression and End to End testing.
  • Prepared Defect Metrics and Productivity Metrics for the team.
  • Interacted with Subject Matter Experts (SMEs) and development teams to identify and refine test requirements.
  • Responsible for conducting the weekly quality assurance review meetings with the development team manager, SMEs and the other testers to review the results.
  • Responsible for reporting and tracking the bugs using Application Lifecycle Management (ALM).
  • Responsible for Test Planning and Estimation of interfaces
  • Performed smoke, usability, functionality, GUI, browser compatibility and regression tests.
  • Tested FrontendPOSapplication, which is developed in Java and Defects were identified, provided results to the development team for debugging.
  • Worked in Client/Server, Web, and SOA/Web Services technologies.
  • Validated Web Services using SOAPUI. Used WSDL and SOAP request to check web services data.
  • Coordinated with offshore/onshore team to share knowledge and work effectively in a daily basis.
  • Validated the data from various tables to test database using SQL for prompted data in UI.
  • Participated in System Integration Testing and User Acceptance Testing.
  • Worked closely with the development team on a day-to-day basis
  • Conducted defect triage meeting, internal and external reviews as well as formal walkthroughs and participated in status meetings.

Environment: HP ALM, JIRA, MS Visio, POS, MS Office, SQL, Agile, Rally, Version One, Selenium, Java, Qik, XML, SoapUI, SOA

Confidential, Richardson TX

QA Analyst

Responsibilities:

  • Worked as a Quality Engineer
  • Created test cases in Quality Center (QC)/ ALM.
  • Comprehensive knowledge of business processes and functions of Business support systems and Operations support layers in fulfillment, assurance & operations
  • Analyzed the problem statement, business case and all project related documents to prepare the test cases
  • Work under Agile methodology attending daily Scrum calls with 4-week sprint timeline which were tracked with Rally.
  • Participated in gathering Business Requirement and creating the corresponding documents followed by the RTM
  • Worked as manual tester to create test scenarios, test plan, test cases of system design documents.
  • Developed Automation Testing Framework for QTP/UFT.
  • Developed and executed automated test scripts using VB Script, Java Script and Shell Script for System and Regression testing using Quick Test Professional V10.0/V11.00.
  • Involved in tracking quality assurance metrics like defects, defect counts, test results and test
  • Involved in generating Test cases for AS- IS to TO-BE scenarios for various business cases.
  • Understanding the Swim lanes business diagrams created in MS VISIO to get the more detailed picture of the requirement
  • Involved in performing Functional, Application, Integration, System, Regression and Performance tests.
  • Prepared Defect Metrics and Productivity Metrics for the team.
  • Responsible for conducting the weekly quality assurance review meetings with the development team manager, SMEs and the other testers to review the results.
  • Responsible for reporting and tracking the bugs using Quality Center.
  • Performed smoke, usability, functionality, GUI, browser compatibility and regression tests.
  • Followed the BPMN notations for process flow diagrams in MS Visio.
  • Participated in Sprint Planning Meetings
  • Worked in Client/Server, Web, and SOA/Web Services technologies.
  • Develop and automate Web Services API testing using SoapUI frameworks
  • Validated Test case data in XML data files
  • Coordinated with offshore/onshore team to share knowledge and work effectively in a daily basis.
  • Created Requirement Traceability Matrix (RTM) to trace the requirements throughout the whole development process.
  • Created the test data for mobile UI.
  • Worked with multiple stakeholders for coordination and tracking of test deliverable
  • Validate the data from various tables to test database using SQL for prompted data in UI.
  • Participated in System Integration Testing and User Acceptance Testing
  • Conducting defect triage meeting, internal and external reviews as well as formal walkthroughs and participated in status meetings.
  • Create database queries (SQL, PL/SQL etc.) with Oracle 11g and other databases.

Environment: BPMN Notations, MS Visio, MS Office, SQL, MDM, Load runner, HP Quality Center/ALM, Agile-Rally, Active VOS, VB Script, Java, XML, SOUP UI, QTP / UFT and HP SOA.

Confidential, Alabaster, AL

QA Tester

Responsibilities:

  • Responsible for analysis of the requirements, functional specification, and use case Specifications of reporting and data warehouse development and converting them in the Test Cases development.
  • Worked with the data architect team to finalize the test cases relating to communication mechanism - ETL, FTP.
  • Verified and tested data sourcing requirements for the data warehouse, business objects, and reference data project as per agile guidelines.
  • Exported the test run data to external spreadsheet from Quality Center and performed detailed analysis.
  • Performed regression testing for every modification in the application and new builds manually as well as with automation tools.
  • Used Quality Center for defect tracking and maintained defect repository and followed defect life cycle until it was closed.
  • Prepared Test Metrics and Results for Business to Review the Test Coverage and Application Quality
  • ExtensivelyusedUNIX/Linux commandstofirstverifythedataatfilelevel.
  • Drive meetings with Offshore and make sure team understanding the requirements and get the status on daily basis.

Environment: QUALITY CENTER / ALM, Rally, SQL server, Agile-Version One, MS Visio, VB Script, Java, HTML, XML, WinSCP’s Win Merge.

We'd love your feedback!