SUMMARY:

• Over 7+ of experience as a Test Analyst (QA ) in Retail Domain and Company Internal Applications
• Extensive Knowledge in Personal and Commercial line of Business
• Experience in test planning, test designing for both Guide wire Claim Center and Policy Center applications
• Experience in Test Estimations based on requirement analysis.
• Experience in Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in using HP Quality Centre for test management, Bug Tracking and Defect Reporting
• Experience in Automation testing using Quick Test Professional (Parameterizing the script, executing the test scripts, analyzing the test result, modifying the scripts and logging defects)
• Experience in SQL scripting.
• Experience in coordinating defect triage meetings with test engineers, development team and Business analysts
• Experience in conducting daily status checkpoints, solving queries with onsite & offshore team
• Extensive knowledge in SQA activities like reviews and process adherence.
• Good Communication and interpersonal skills with quest and zeal to learn new technologies and undertake multiple challenging tasks
• Experience on AWS cloud using docker image.
• Well experienced in White box testing, Black box testing, Grey box testing, Application testing, and Regression testing for Data Integration and Data Migration to different environments.
• Good experience and understanding of Data warehouse concepts and technologies like ETL, OLTP, OLAP, Normalization/Denormalization, Data Models, Schemas, Datamarts, Dashboards and Reporting.
• Good experience working in different industry domains such as Insurance, Healthcare, and Banking.
• Good understanding of all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience working in AGILE/Scrum and Waterfall environments for different projects.
• Good experience with web application testing and highly detail - oriented and analytical in providing recommendations and changes to process improvements as needed.
• Experience in writing Test Plans, defining Test Scenarios and Test Cases, developing and maintaining test scripts, analyzing bugs, interacting with team members and track the bugs till closure.
• Worked with SoapUI tool (Web services) to test request and response also validated XML files. Performed Data driven testing and generated Report to view Result Matrix.
• Experience in software Quality Assurance, Systems Engineer, Manual, Automated Software Testing, writing Test plans, Test cases and Test scripts.
• Worked exhaustively on Defect Management tools such as HP ALM and Bugzilla
• Excellent interpersonal, facilitation and communication skills at all levels (verbal and written)
• Effective negotiator with superior analytical/problem solving and decision making skills
• Good Team Player committed to customer satisfaction and quality.

TECHNICAL SKILLS:

Operating systems: Windows and UNIX, Linux

Languages: Java, C, C++, JavaScript, HTML

Web Technologies: HTML, XML

Tools: HP Quality Center, Quick Test Professional, Win Runner, Test Director

Scripting Language: C, C++, SQL, MS Office Suite

Data Bases: MS SQL Server, Oracle, Microsoft Access/Excel, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Sr. QA Tester

Responsibilities:

• Performed research and analysis of Business and Functional Requirements and developed testing activities.
• Involved in the black-box testing of the application developed using JAVA and identified the different test cases for regression testing. Created SQL queries for back-end testing to check information is stored correctly in the database.
• Performed all test cases through test framework as JUnit against AWS test environment
• Designed and implemented the backend of a system used at company level (Java, AWS)
• Involved in fixing of invalid Mappings, Performance tuning, testing of Stored Procedures and Functions, and testing of data ware house Sessions, Batches and the Target Data.
• Developed, tested and implement efficient ETL (Extraction, Transform and Load) code to populate data integration layers (data warehouses, ODS and data marts) to support business requirements using Informatica Power center.
• Involved in testing readiness deliverables, test script execution and defect validations are completed in a timely and efficient manner in UAT / SIT environments.
• Conducted System Testing and User Acceptance Testing for every client and Conducted Backend testing writing extensive SQL queries.
• Involved in documentation as to how to maintain and run scripts for future enhancements.
• Responsible for testing the application against different environments in QA, staging and production.
• Used SQL queries to perform data integrity testing and validated database with SIT.
• Involved in the data, workflow, and productivity requirements for a new SIT to combine music, video, and books content. Managed the migration of data from the old system.
• Validated the back end data in Sterling Order Management System by placing orders in front end web interface and validated the accuracy of price calculations, inventory updates, promotions (If any) applied to the order.
• Created Requirement traceability matrix, Test strategies, Test Plan document and test execution plan as per understanding from the business, functional and system specifications.
• Involved in all phases of SDFC
• Responsible for design, development and implementation of automation framework for front end interface using QTP and SOAPUI for checking any web service issue faced.
• Performed data quality analysis using advanced SQL skills in the database Manager.
• Involved in writing advanced SQL queries to extract information to identify the tables, columns from which data is extracted and verifying.
• Achieved customer satisfaction and high quality by effective Automation testing, AGILE Processes.
• Implemented automation using Selenium Web Driver, JAVA, and Selenium Grid.
• Created Test Plan document and present to client to get the approvals for the testing effort estimated; further analyzing the Data Specification document and preparing the Test cases in HP ALM.

Environment: Java, Soap UI, SQL, Informatica, Agile, QC/ALM, Excel, SDFC, Agile, ETL,UAT,AWS,DATA INTEGRATION,SIT,, EPAT (Enterprise Process and Technology),Web application, JIRA, SIT

Confidential, Seattle, WA

QA Tester

Responsibilities:

• Designed, developed, debugged and tested the mobile based application using the framework
• Wrote various test cases and scenarios for functional testing the enhanced chase web based application.
• Extensively worked on Test Data Management using HP ALM. (Test Case, Execution, Defect Mgmt., Traceability Matrix).
• Involved in weekly walkthroughs, inspections and verification meetings with various stakeholders in the project to understand the business process of fixed income and equities sector of investment market.
• Analyzed the system requirements and developed detailed test plans and test cases provided the documentation according to Agile Scrum methodology.
• Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Quick Test Professional.
• Performed Regression testing, functional testing of Retail and ecommerce applications.
• Performed browser compatibility testing on Ecommerce application
• Used QC ALM for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Participated with the ecommerce team and upgraded the database and data structure.
• Testing and verifying the product micro sites through the SIT.
• Managed project and changed Initiatives (SDLC) from ideation to realization.
• Designed and developed new APIs and endpoints using micro services (distributed applications deployable on AWS) that rely on ETL and Hadoop data.
• Used SoapUI over Http and Soap UI over JMS for communication between components.
• Maintain record of total accounts billed, on hold and rejected daily Ensure data and codes are not changed on claims
• Collaborated with all the teams which integrate SDFC designed a plan for Integration Testing.
• Scheduled Full and Differential backups to disks, tapes using batch scripts, SQL and Maintenance Plan Wizard and configuring appropriate Recovery Model for the databases.
• Performed data quality analysis using advanced SQL skills in the database Manager.
• Involved in writing advanced SQL queries to extract information to identify the tables, columns from which data is extracted and verifying.
• Created the required source definitions of Sales force data in source analyzer by connecting to salesforce.com for the objects like customers, vendors, sales orders, purchase orders etc.
• Worked on Integrating Salesforce systems using SOAP and REST API's.
• Prepared the validation report queries and executed after every ETL runs and shared the resultant values with Business users in different phases of the project.
• Responsible for implementation and creation of Change Control Requests. Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements
• Prepared Requirement Traceability metrics (RTM) to verify and track the Business requirement for the analysis Report and dashboard build in sales force.
• Achieved customer satisfaction and high quality by effective Automation testing, AGILE Processes.
• Implemented automation using Selenium Web Driver, JAVA, and Selenium Grid.

Environment: HP QC/ALM,DATA WARE HOUSING,ETL, Informatica, Sales Force, Java, Hadoop, Etl, Soap UI, Rest Api, Agile scrum Methodology, SDFC

Confidential, Dallas, TX

QA Tester

Responsibilities:

• Developed stored procedures and triggers using PL/SQL in order to calculate and update the tables to implement business logic.
• Designed and developed JUnit test cases for EJB component.
• Used Spring framework in web tire to handle user request
• Tested CMS application for document publication, publishers and readers required correct authorization and security
• Managed application development, including performance and growth of direct and indirect reports.
• Reviewed and Analyzed Requirement Document and created detailed test cases to validate the application functionality.
• Involved in creating Test Cases in Test rail for Acquisition and Retention modules for both legacy and demand ware sites.
• Responsible for daily regression testing for in Test and Stage environment using different browsers and reported and tracked the defects in Jira/Red mine.
• Participated in automation test scripts using QTP and Eclipse and scripts maintenance
• Participated in User Interface design related queries/needs.
• Interacted closely with development teams to provide the best overall technical solution to meet product requirements.
• Provided analytic support to measure performance of efforts in Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learning’s.
• Participated in weekly staff and Analyst/Dev Meetings. Reviewed and analyzed variety of forms, documents (RT or Approach Framework) reports, data output, and record-keeping requirement to identify any questions or requirements.
• Worked with system testers, developer leads and managers to conduct UAT. Reviewed requirements of the project, status of testing and unsolved issues
• Created and tracked milestones to manage design, technical implementation, and customer service management, QA testing and e-marketing.
• Responsible for managing project teams through the entire systems development life-cycle managing project risks, issues and dependencies, and developing appropriate mitigation strategies and plans; managing project financials including sizing, forecasts, actual costs and budget deviations.
• Analyzed business and system requirements and estimated testing efforts Developed Test Plans, Test scripts, and Requirements Traceability Matrix documents

Environment: Spring, WSAD, Struts, Tiles, Agile, SDLC, AWS, Data Ware Housing, Jira, ETL,PL/SQL,UAT,QC/ALM.

Confidential, Bentonville, AR

QA Tester

Responsibilities:

• Involved in use-case analysis, design reviews and software component estimation.
• Used Scrum (Agile) as Development methodology.
• Involved in writing Spring configuration XML file that contains declarations and other dependent object declaration
• Developed SQL to pull out various combination closing fee details.
• Used SOAP web services to send and receive order related data from other sub systems.
• Participated in design meetings and prepared prototypes based on Restful and SOAP for invoking third party Web Services.
• Coordinated with offshore development team and clarified their day-today questions. Reviewed offshore delivery before check-in the code.
• Participated in Test Frameworks in Selenium for UI Regression Test Automation and when necessary, and potentially execute Unit Test Automation (Java).
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
• Worked extensively with JIRA for tracking issues and configuration management.
• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve
• Automated the functionality and interface testing of application using Selenium Web Driver.
• Used Quality Center for bug-reporting, tracking and to create and execute various scenarios, generate graphs, overlaid graphs for comparison, and analyzed the results.
• Updated Requirement Traceability Matrix for additional requirements that were brought to scope for each iteration.
• Conducted demonstration for the client for UAT testing to walk through the application using WebEx.

Environment: XML Web service, XML, CSS, JavaScript, Agile, Clear Case, Oracle, REST, SOAP, JIRA, UNIX, Sprint, UAT, JIRA, API.

Confidential, San Jose, CA

QA Tester

Responsibilities:

• Mapping of the Servlet in Deployment Descriptor (XML).
• Involved in coding for JUnit test cases, ANT for building the application.
• Created pricing architecture and assign appropriate retails based on IMU goals, perceived value and competitor marketplace research.
• Provided product knowledge and samples to cross-functional teams, such as marketing, ecommerce and store operations.
• Analyzed sales to report successes, misses and opportunities.
• Assisted Buying team with product knowledge seminars to train the retail staff on new product, including development of materials.
• Managed long-term E-Commerce project researching visual display differences online and with competition.
• Tracked and manage samples during market week.
• Created snapshot reports for same store daily sale comparison.

Environment: Java, J2EE, Sales Force, Ant, J Unit, REST, SOAP, JIRA, UNIX, Sprint, UAT, JIRA, API.