We provide IT Staff Augmentation Services!

Datawarehouse/automation Test Engineer Resume

Hartford, CT

SUMMARY:

  • Experience of working in Agile Methodology using JIRA and Version One (Scrum model)
  • Experience in Selenium automation using Java & Python in Confidential (Medicare) domain
  • Automated highly transactional e - commerce web application using Selenium WebDriver.
  • Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, JUnit
  • 5 years of recent experience in leading/managing software QA or development teams; test estimation and reporting test metrics
  • Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/Datawarehouse applications.
  • Datawarehouse testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Hands on experience in Automation, Datawarehouse System Migration testing, Functional, System/Regression testing and unit testing with JUnit
  • Experience in testing MicroStrategy reports along with the data validation for the reports
  • Strong experience on database query tools such as TOAD, Aginity Netezza and SQL Plus.
  • Analyzing bugs, interacting with QA/Dev teams in fixing errors
  • Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
  • Effective collaboration with Developers, AGILE Team, Project Management to achieve Selenium automation, high quality, release deadlines and QA processes improvements
  • Developed VB Macros and other utilities to save time in performing daily smoke testing, sanity, production and UAT testing which resulted in better ROI for the project

TECHNICAL SKILLS:

RDBMS: Teradata V14.x, Oracle 9i SQL, MS Access 2003, MSSQL Server & Netezza

ETL Tools: Informatica 9.5, Aginity Netezza Workbench, SSIS

Operating Systems: LINUX, Windows OS 7/XP and Windows Server 2008 R2/2012 R2

Change Management: HP Quality Center, JIRA, Version One

SDLC Methodologies: Waterfall, Agile

Scripting Languages: VB Script, Python

Automation Testing Tools: Selenium WebDriver/RC/Grid, Cucumber, Maven, HP UFT 11.0, LoadRunner

Bug Tracking Tools: JIRA, BugZilla, HP Quality Center 11.0, Version One

Programming Languages: Java, C, C++ & SQL

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Datawarehouse/Automation Test Engineer

Responsibilities:

  • Identified areas in need of improvement through work shop development and documented recommendations.
  • Analyzed Project Manager reports to update and administer program plans.
  • Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
  • Review manual and automation team work (UFT and Selenium tools) and suggest best practices and process improvements along with resource mentoring
  • Actively participate in walk-through, inspection, review and user group meetings for quality assurance
  • Involved in test case design and test scenario identification for functional, integration, system, regression, security, end to end and UAT testing.
  • Automated ad-hoc requests and executed scripts of AssureNet for 1 lakh minutes in unattended mode.
  • Automated report validations like web-excel, web-pdf and database to excel.
  • Automated realtime scenarios like Salesforce password reset and account creation scripts.
  • Automated pdf validations to verify and test the invoice produce from application reports
  • Automated the 60% of Manual Cases as per the feasibility.
  • Schedule and drive Defect review meetings, validate submitted bugs, assign bugs to different teams involved in resolution, notify relevant business units, research and log root cause analysis for the reported bugs and follow through with a resolution and final testing
  • Define strategy for collecting reporting results and develop virtualizations,
  • Understand and perform risk mitigation to meet deadlines. Create automation test plan, estimations and test schedule, write and execute scripts and report and fix defects in automation suites
  • Create daily/Weekly status reports for stakeholder and identify risks & issues and provide mitigation plans

Environment: /Tools: HP UFT 12.5 & ALM, VB Script, .NET, VS.Net & Selenium

Confidential, Charlotte, NC

Datawarehouse/Automation Test Engineer

Responsibilities:

  • Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
  • Identified areas in need of improvement through work shop development and documented recommendations.
  • Analyzed Project Manager reports to update and administer program plans.
  • Consolidated project reporting materials for monthly review by Project Manager
  • Worked in an Agile Environment with stringent timelines, Offshore Lead responsibilities varying from Requirement gathering to test sign-off for the complete Flow of the Module.
  • Actively participate in walk-through, inspection, review and user group meetings for quality assurance
  • Plan, document, evaluate and track testing results with Traceability Matrix to ensure system applications are free from defects
  • Participated in project planning, release, Defect Meetings & daily stand up meetings. Developed QA methodologies, test design & strategy, test data
  • Managed/coordinated/supported offshore resources and transferring knowledge to/ monitoring of QA team members.
  • Experience testing customer facing and Ad hoc MSTR reports.
  • Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
  • Involved in maintaining the test environments, like requesting data loads, data base backups, requesting the deployments, troubleshooting issues for QA team.
  • Coordinating with source system owners, day-to-day Datawarehouse progress monitoring and maintenance of daily batch schedule run on a nightly basis.
  • Participated in weekly Test Status meetings to discuss Test Deliverables, Milestones, and Project-Level Issues & Risks
  • Involved in getting final signoffs from client & business Managers
  • Developed VB macros and utilities to automation manual testing spent on DB testing, reports testing spent on the application.

Environment: /Tools: IBM Aginity Netezza Workbench 4.1, MS Excel for VB macros, Microstrategy, HP Quality Center 10.0, QTP, JIRA, Version One

Confidential

Sr. QA Analyst

Responsibilities:

  • Performed compatibility testing and cross-browser testing for the stb testing efforts and reported the analysis with the snapshots.
  • Involved in testing migration of Coffee (Ordering System Tool) module from desktop application to web applications, mobile versions on the tablets facilitating Data, Video, Fios TV, FDV, HSI and Voice ordering services
  • Involved in testing the mobile and set top box testing with Appium.
  • Validate existing order Due date and propose recommendations on the future billing plans and cheaper bundle plans to retain customer base.
  • Performed STB testing on various iOS and Android on different CDMA, GSM devices and tablets.
  • Validation against PSTN and FIOS bundles against the customer address and location criteria.
  • Validating backend validation for pending completed and cancelled orders from legacy desktop to web-based application through MS SQL Server database.
  • Developing Integration Test strategy and Test Plans for the Voice Video TV bundle ordering system with respect to BQT (Bundle Qualification Test) which is a legacy wizard.
  • Reviewing manual guide for all the orders and write or execute test plan for the GUI, functional, Performance and Integration testing
  • Involved in testing specific recommendations of integrating exquisite orders of Voice, Video, Wi-Fi and several channels products which are recommended to the product user to ensure adequate product coverage, plan compare and validation process
  • Ensure proper order has been placed as per requirement with the respective snapshot for the selected customer options.
  • Participated in the bug triage meetings with developers and set priorities for the upcoming releases.
  • Handled and managed test reporting and tracking defects using Jira, Version One and/or QC.
  • Scheduling daily Testing Status meetings to discuss issues found during testing and prepare MOM
  • Prepared various types of Metrics, Prepared business continuity and risk mitigation plans. Being core member, prepared checklists and traceability metrics; handled all the management activities, successfully handled the offshore team for 12 releases
  • Conducted Black Box (Functionality Testing), User Acceptance, and Regression testing.
  • Provided clear concise feedback to Development team on recurring errors both on an individual and team basis with aim of long-term reduction of defects found in final releases

Environment: /Tools: .NET, VS.Net, QTP, MS - SQL, QC 10.0 and VB.Net, SharePoint, Appium

Confidential, Hartford, CT

Sr. QA Analyst

Responsibilities:

  • Manually tested the application for a few modules for the functionality of the application
  • Prepared detailed project plans (in the form of Scope Document)
  • Involved in Mainframe application backend testing; review of Test cases and Manual execution of the System and Integration Test Cases
  • Involved in Mainframe application backend testing. Defect tracking in Quality Centre Tool. Involved in database Testing.
  • Worked on Mainframe emulator QWS3270 PLUS
  • Coordinating with the Onsite team and the development teams and conducted knowledge Transition sessions to the team members

Environment: /Tools: IBM DB-2, QWS3270 PLUS, MS Office, QC 10.0

Confidential

Sr. Test Engineer

Responsibilities:

  • Reviewing and understanding Test Requirements and application
  • Preparation and review of manual test cases, query log and issue log
  • Testing reports by executing
  • Writing Test scripts, preparation of test data, test execution and logging bugs
  • Responsible for project deliverables to the client
  • Responsible for updating the daily and weekly status to the client

Environment: /Tools: ASP.NET 2.0, VB.NET, DHTML, Ajax, JavaScript, Web services, Telerik controls, Reports and SQL server 2005

Hire Now