Data Analyst Resume
Northbrook, IL
SUMMARY
- Over 6.5 years of diversified experience in the area of Quality Assurance and Quality Control of Software products with Manual and Automated Testing on Web based and Client - Server applications.
- A good blend of Management and Functional skills has contributed in successful execution of projects in Insurance, Ecommerce, Entertainment, STB, POS and Service-oriented applications.
- Extensive experience in all phases of Software Development Life Cycle (SDLC) including Analysis, Design, Development, Implementation, Testing, Software Quality Standards, Configuration Management, Change Management, Quality procedures, QA practices and procedures.
- Experienced in various software development methodologies like SDLC/ STLC, Waterfall, Agile-SCRUM, SAFE-Agile and Feature Driven Development.
- Extensive QA experience in reviewing and analyzing FRS/SRS documents and Preparation of Test Strategy, Test Plan, Requirement Analysis, Effort Estimation, Designing Test Scenarios and Test Case and Reviewing Test Cases.
- Experienced in Developing Test Framework.
- Experience in Client Relationship Management and End User Training, User Acceptance Testing with Business teams or Pilot Users and Support.
- Experience in e-commerce Platform, Credit Card Processing with POS, Kiosk & Mobile Apps.
- Expertise in Point of Sale (POS) for Tests for Store open, End of the day, validation of sales reports and receipts/invoices etc.
- Experience in testing web services API’s using Soap UI, Postman.
- Experienced in GIT, in continuous integration tools like Jenkins.
- Experienced in creating and updating tables, views, working with triggers and stored procedures.
- Proven experience in coordinating testing effort, handling responsibility for test deliverables, status reporting to management, issue escalations and generating reports.
- Experienced in Cross browser and Cross platform testing.
- Good knowledge in Selenium automation using Selenium WebDriver, Selenium IDE, Selenium Grid, Java, TestNG, XML.
- Knowledge in creating new TestNG test cases, modifying the Selenium scripts and Writing test suites using TestNG.
- Experienced in database testing and validating the applications against the database tables by executing SQL queries on SQL server, DB2.
- Proficient in writing Selenium Web Driver automation scripts in Java using Maven, Cucumber, and TestNG Automation Testing for Web Applications.
- Good knowledge on Automation Frameworks POM, BDD, Hybrid, Keyword driven.
- Good experience in testing both SOAP and REST services using SOAP UI, Postman tested both XML and JSON formats.
- Execution of Manual and Automation Business Components, Test Scripts through Test Management Mercury tool like Quality Center (QC/ALM).
- Experience in developing web pages using HTML, JavaScript and CSS.
- Experience in importing and exporting Test Scripts to Quality Center/ALM, TFS from Microsoft Excel using Apache POI.
- Possess strong analytical and problem-solving skills with the ability to adapt to a new environment and meet stringent deadlines. Possess a flexible & detail-oriented attitude. A team player with excellent technical, communication, and leadership skills. Ability to quickly learn and adapt to the rapidly emerging Technologies.
- Good documenting skills while ensuring the completion of project within specified deadline.
TECHNICAL SKILLS
Development methodologies: Agile/Scrum, V Model, Waterfall, Automation
Artifacts: Test Plan, Test Case, RTM, Test Summary Report, Bug report
Tools: worked: POS, STB
Automation Tools: Selenium IDE, Selenium Web Driver, Selenium RC, Selenium Grid, Cucumber, TestNG
Framework: Keyword Driven, Data Driven, Hybrid Testing Framework, Page object Model, BDD.
Bug or Test Management Tools: Quality Center, ALM,TFS, MTM, JIRA, Test Manager, Visual Studio
Programming Languages: Java Script, XPath, CSS, Appium, Gherkin
Database/Database tools: SQL Server, Oracle SQL, MySQL
Web, Application Servers: IIS, Web Logic, Soap UI, Postman
Operating Systems: Windows, XP.
PROFESSIONAL EXPERIENCE
Confidential, Northbrook, IL
Data Analyst
Responsibilities:
- Coordinate with Experience Owner, Product Owner and other Business stakeholders to understand the problem/ideas for more insight.
- Review Epic, Features and Stories to provide solutions/enhancements. Good Experience in Agile methodology with SCRUM Process for the product development.
- Involved in determining the QA Strategic and Operational approach to align with company’s Business goal.
- Establish QA release entrance and exit criteria.
- Review the functional test plan (test scenarios, conditions and data) and provide input.
- Identify needs for implementing new processes and analyze project trends to improve and optimize existing processes.
- Assist in designing physical data structures to support application requirements by collaborating with DBA.
- Responsible for project planning in all the testing phases along with the quality delivery by adhering to Quality standards, Process Management and Project Timeline.
- Tested extensive backend testing using SQL Queries to retrieve the data from the database and checked data integrity.
- Configured SQL queries to fetch data from the Oracle database.
- Validated the response of the API using Soap UI/ Postman.
- Working with data management team for managing the test data creation from various sources and escalating any issues to Management.
- Conducting Bug Triage, assess bug priorities with the help of Product owner and assign to respective developers.
- Assigning testing responsibilities to team members and follow up till test completion and reporting the status to Project Manager.
- Responsible for updating the weekly reports.
Confidential, Manhattan Beach, CA
QA Engineer
Responsibilities:
- Analyzed business requirements, coordinated with the stakeholders/PO/PA and involved in Test Planning Activities like Test case design, execution, reporting and defects were tracked, reviewed, analyzed and compared by using JIRA Tool.
- Translate system requirements into test scripts and test cases.
- Prepared excel spreadsheets to document the defects and coordinated well with the development team explaining the defects. Executed Manual Test Cases by using positive and negative data inputs.
- Tested on POS Server and Registers after every re-imaging & installation of printer drivers and software.
- Validate the invotary DB & Back office to know the stock updates.
- Validate on desktop POS application, manage sales by scanning the item/enter the item # and take the different methods of payments.
- Experience in e-commerce Platform, Credit Card Processing with POS, Kiosk & Mobile Apps.
- Testing on various transactions processed using Credit Cards, Gift Certificate vouchers, Gift cards and Check logs & errors on SQL server.
- Responsible for providing Risk Assessments, test Plans, test cases executing and creating Test Results within an AGILE software development SCRUM environment.
- Validation of sales reports and receipts/invoice.
- Validated on Sales Audit and Quantum for all the sales/transaction processed as part of daily activities.
- Validate on Aptos Store-6 for POS system, Store-1 for Mobile, IOS and Android validations.
- Validated on different Peripheral Devices which are connected to the POS system, like barcode scanners, printers, pinpads etc.
- Mobile manual testing for Native, Web & Hybrid apps, catching mobile logs using Cat log & Appium. Send the logs to dev for debugging & fixing the issues.
- Performed End-to-End testing on web-services using SOAP-UI/Postman collection.
- Validated the information of the best users of the product and what items are sold more and what items are commonly returned etc.
Environment: & Tools: POS, IOS, Android, QTP/UFT, JIRA, Web Services, Microsoft Office Excel, Agile, SharePoint, Soap UI, SQL, ALM.
Confidential, El Segundo, CA
QA Specialist
Responsibilities:
- Analyzed business requirements and work closely with Stakeholders & developers to deliver high quality software.
- Coordinated with the stakeholders/PO/PA and involved in Test Planning Activities like Test case Design, Execution, Reporting and defects were tracked, reviewed, analyzed and compared by using JIRA Tool.
- Translate system requirements into test scripts and test cases.
- Involved in the analysis of business requirements, and wrote test plans, test cases for the smoke, GUI, functional, security, database and integration testing.
- Executed SQL queries, Joins and Performed Backendtestingand ensured the retrieval of the data from the database. Also worked on internally built CMS database for quick validation of data.
- Identified areas for business improvement specifically inthe Entertainment domain.
- Worked in Agile, Scrum process with micromanagement for delivering the outputs on time.
- Involved in validating functional, Integration and Regression test suites using Selenium and the request and response of the API’s/ Web Services through Postman/ Soap UI.
- Reported the bugs, e-mail notifications to the developers using the JIRA.
- Documented all issues in the issue tracking system JIRA.
- Maintaining and executing test scripts for the production website and the QA environment on EG Confluence page.
- Engaged in testing applications across a range of technologies including Web, mobile, web services, messaging and reporting.
- Validated the Charles proxy logs for Mobile application validations and PDS logs for STB (Set top box) validation.
- Good Confidential bug-reporting and bug-tracking using Test Management tools like JIRA.
Environment: Agile (Scrum), Java, JIRA, Automation, Selenium Web driver/Grid, TestNG, JUnit, Maven, Jenkins, Git/GitHub, Eclipse IDE, Agile, HTML, XPath, Postman, SOAP UI, Firebug, Oracle SQL.
Confidential, Northbrook, IL
Software QA Analyst
Responsibilities:
- Involved in preparing the functional test cases using test design techniques data validation concepts Equivalence partitioning, boundary value analysis.
- Prepared test data document and Involved in generation of bug and test case execution reports.
- Strong understanding of software Test Methodologies and knowledge of modern software development processes, including Issue/Bug Tacking, Release management, Requirements etc.
- Prepared manual & function test cases on web based application as per requirements.
- Good Experience in Agile methodology with SCRUM Process for the product development.
- Responsible for evaluating all identified and entered defects encountered during testing in Pivotal tracker.
- Performed manual procedures for functional testing of Web services Involved in Manual Testing to check the basic functionality of the modules under test.
- Participated in creating Test Plan, test cases, log/tracked defects based on business requirement utilizing Pivotal tracker and JIRA.
- Assist in designing physical data structures to support application requirements by collaborating with DBA.
- Incorporated a data driven framework for the test script to access and store data from/to excel spreadsheet using Apache POI.
- Tested extensive backend testing using SQL Queries to retrieve the data from the database and checked data integrity.
- Configured SQL queries to fetch data from the Oracle database.
- Developed Selenium scripts in TestNG for parameterization using Data Provider annotation. Used web-debugging tools like XPath, Firebug and Firepath to locate elements.
- Involved in Maven configuration for running servers and scripts after the build.
- Validated the response of the API with PL/SQL queries on the database.
- Developed automation script for Mobile Native applications (IOS, Android) using Appium, Java.
- Performed web services testing with SOAP UI/ Postman by validating request and response for XML, JSON files.
- Created Test Completion Reports Confidential the end of final testing status including defect information to be presented to the business line for approval.
Environment: & Tools: JIRA, Pivotal tracker, Microsoft Office Excel, Agile, Testing, SharePoint, Selenium, Java, Cucumber, SQL, Soap UI, Postman, Appium, Microsoft Word, Microsoft Power point.
Confidential, Orlando, FL
Software QA Tester
Responsibilities:
- Analyzing FRS Document and understanding the Applications.
- I have also participated in validating the Requirements, Test plan document, Test scenarios sent detailed test reports.
- In TFS created, modified and executed test cases based on the requirements.
- Actively participated in sprints while following Agile process.
- Validated the sales data using the POS tool.
- Validated on Business to Business (B2B) & Business to Customer (B2C) integrations.
- Validation on E- Commerce, Catalog and Retail/Commercial Customer etc.
- Involved in Preparing detailed test plans explaining the test scope, testing environment, test system hierarchy or file system, test naming conventions, testability issues, and test system data, procedural steps describing test procedure and expected results.
- Validated the invotary DB updates & Back office to know the stock updates.
- Responsible for providing Risk Assessments, test Plans, test cases executing and creating Test Results within an AGILE software development SCRUM environment.
- Worked on End to end test, regression, functional and integration testing on all the environment.
- Participated in creating Test Plan, test cases, log/tracked defects based on business requirement utilizing MTM, TFS.
- Validated on different Peripheral Devices which are connected to the POS system, like barcode scanners, printers, pinpads etc.
- Prepare Reusable Test scripts, functions, which improve the robustness, re-usability, and maintainability of their test scripts using Selenium.
- Worked with open source tools such as Selenium (Selenium IDE, Selenium RC, Selenium Web Driver and Selenium Grid), Cucumber, Jenkins, Maven, SoapUI, JUnit and Eclipse.
- Validated the response of the API with PL/SQL queries on the database.
- Experienced in writing joins when more than one table involved while fetching the data.
- Successfully Completed User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.
- Performed web services testing with SOAP UI by validating request and response for XML,
- JSON files.
- Involved in testing of services using SOAP/REST services using SOAP UI
- Executed tests on multiple browsers - IE, Chrome, and Firefox & Safari.
- Collaborated with the business and technical teams and took the responsibility to document the functional and technical specifications in the business requirements analysis phase.
- Created Test Completion Reports Confidential the end of final testing status including defect information to be presented to the business line for approval.
Environment: & Tools: POS, SQL, test object SQL, TFS, MTM, ALM, SIT, SOAP/REST, Visual studio, B2B, B2C, Certification Testing.
Confidential
QA Tester
Responsibilities:
- Performed Smoke, integration, Functional, Regression, System, Acceptance and Usability testing during different stages of the application development.
- Performed manual testing of the entire GUI of the application and identified the candidates for regression testing.
- Prepared excel spreadsheets to document the defects and coordinated well with the development team explaining the defects. Executed Manual Test Cases by using positive and negative data inputs.
- Extensively used Data Stage for extraction, transformation and loading process. Worked with ETL group for understating Data Stage. Followed Agile for testing the application.
- Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse as per Business Rules.
- Participated in creating Test Plan, test cases, log/tracked defects based on business requirement utilizing ALM.
- Strong understanding of software Test Methodologies and knowledge of modern software development processes, including Issue/Bug Tacking, Release management, Requirements etc.
- Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool, monitored their progress and verified their fix.
- Executed test scripts manually and then recorded the same in Screen certify. All the issues that came up during this process were logged in Test Director as defects.
Environment: and Tools: MS SQL, Query Analyzer, Microsoft Word, Microsoft Power point, UNIX Enterprise Manager Windows XP, IE, XML, ALM, Windows2003, Rational Clear Quest.
