We provide IT Staff Augmentation Services!

Sr. Qa Engineer Resume

Rockville, MD

SUMMARY:

  • 10+ years of Quality Assurance, Business Analysis, Data Analysis.
  • Test Planning, Test Cases design, Test Environment setup, Test Data creation. Execute/Verify.
  • Test Management using Target Process, Quality Center/ ALM, Vault, Jira, and Bugzilla.
  • Test Types (Smoke, Component, Integration, Systems, Regression, Load, Performance, Browser - Compatibility, Comparison, XML Schema, 508 compliance).
  • Extensive experience in QA (Black-Box, White-Box). Back-End and Front-End Testing.
  • Experience in Test Automation using Java/Selenium/TestNG. Can work with QTP.
  • Experience in Java using Eclipse.
  • Object-Oriented skills in C++ and Java (Classes, Objects, inheritance, encapsulation, polymorphism, interfaces, and threads etc).
  • Test-Deliverables manual installations, Automated Deployments using Octopus/Tentacle.
  • Experience in Data Quality Checks using Informatica Developer, designing Mappings / Transformations / PDO.
  • Experience in ETL Testing. Data Migration / Verification / Reconciliation / Merging from OLTP to common-format to OLAP.
  • Experience in SQL scripting, stored procs, functions etc.
  • Database normalization up to 3rd Normal Form.
  • Data Warehousing / Data Mart, Denormalization STAR / SnowFlake Schemas (Fact/ Dimensions).
  • ER diagrams, Functions, Stored Procedures, Views, Joins, Backup, Restore, Shrink etc.
  • Hypervisor/virtual machine management. Services and Process management in dot NET.
  • Requirement Engineering (Development, Change Management).
  • SOA Middleware transactions, Message Queues (MSMQ Workflow Management/Service Broker) between BSS and OSS.
  • Experience in Agile Scrum (Normal/Regulatory Sprints), Water Fall, and V Model.
  • Protocols such as HTTP, TCP/IP, SSL, SNMP, SMTP, and UDP.
  • Test Metrics, Test Plans, User Stories, Tasks, Test Cases, Test Summary Reports.
  • Problem Solving, written and verbal communication, Mentor/ Training junior staff.
  • Familiar with configuration/build management (Client Server SVN, Distributed GIT).

TECHNICAL SKILLS:

Operating Systems: Windows 7/95/98/2000, XP, NT, Linux, UNIX (Solaris)

Languages: PL/SQL, Java, C#, C++, Visual Basic 5.0/6.0, CSS, XML, HTML

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008/2012, MS Excel, MS-Access

Tools: TOAD, Informatica, SQL Developer, SQL*Plus, Oracle Data-Pump, Oracle Forms/Reports, Selenium/TestNG/, Bugzilla, Jira, QC/ALM, Test Director, QTP, Rational FT, Target Process, Eclipse, SQL Loader, Confluence, HipChat, SOAP UI

WORK EXPERIENCE:

Sr. QA Engineer

Confidential, Rockville, MD

Responsibilities:

  • Perform testing on electric fusing-solution devices software.
  • Update firmware(sofware packages) on simulated electric devices.
  • Utilize Atlassian Jira for defect management.
  • Utilize Atlassian Confluence for Requirement Management / Documentation.
  • Create test-procedures and test-cases based upon Epics, User Stories, Dev Tasks/subTasks
  • Utilize qTest for test case creation/management and execution.
  • Perform Component, integration and regression testing.
  • Utilize SQL DML for database transaction management (dBeaver/Casandra).
  • Utilize Kafka message-queuing system for transaction processing (updating firmware on electric devices).

Sr. QA Engineer

Confidential, Columbia, MD

Responsibilities:

  • Utilized Informatica Developer to perform Data Quality Checks.
  • Designed extensive Informatica Mapping, by creating several Transformations.
  • Incorporated reusability by creating Informatica Physical Data Objects either flat files or relational database.
  • Utilized MicroStategy Reports to verify Data files received from heterogeneous sources (daily, weekly, monthly).
  • Utilized Orion Job-Scheduler to upload Data from several different Client source files into staging environment, and migrate the data to Common Format, Pre-Load and Data-Warehouse.
  • Performed ETL Automation Tests.
  • Performed data reconciliation in Fact and Dimension tables.
  • Investigate data inconsistency through Fact and Dimension tables.
  • Create Test Data for QA purposes in SQL Server Environment.
  • Resolve Client data issues through SalesForce tickets.

Sr. QA Engineer

Confidential, Columbia, MD

Responsibilities:

  • Utilize Requirement docs, functional specs and flow diagrams to design test cases for Physicians and Hospital quality data verifications.
  • Updated Requirement docs by incorporating Requirement Change Requests (RCRs) from end client.
  • Generate SAS BI reports, using SQL, for physician quality data submission and validations.
  • Designed Test Cases for data verification between OLTP and OLAP.
  • Work closely with Project Manager / BA and perform detailed analysis of existing requirements, RCRs and provide input on inconsistencies/discrepancies, duplications and redundancies.
  • Conduct Peer Review meetings and Provide gap analysis to Dev/BA and QA teams.
  • Performed QA Automation using Selenium / Java / Eclipse.
  • Performed 508 compliance testing.
  • Upload test cases from excel sheets to ALM, Map requirements to test cases, generate Requirement Traceability Matrix. Utilized informatica for Data Quality Checks.
  • Execute tests in ALM, identify, log and manage defects.
  • Communicate with internal teams on functional requirements of GUI, screen, interface design, access and EWR etc.

Sr. QA Engineer

Confidential

Responsibilities:

  • Utilized Selenium Web-driver to automate QA practices.
  • Utilized Selenium for data-driven testing, taking parameters from excel database and plugging in web elements of browsers, updating Oracle database.
  • Designed Automation FrameWork using Selenium (KeyWord-Driven + Data-Driven).
  • Created Test Plans, Test Case for web-based / mobile advertising applications.
  • Ensured the results compatibility on multiple browsers/mobile-devices and MAC.
  • Clarified client requirements, business needs and project objectives in team meetings.
  • Wrote SQL queries to verify data/results.
  • Coordinated with BA/PM in order to ensure the deadlines are met and defect-free products are delivered.

Lead QA Engineer

Confidential

Responsibilities:

  • Re-engineered database design in order to automate HealthCare Claim Processing.
  • Designed SQL queries and sub-queries to isolate healthcare provider categories and create batches.
  • Sent Claim records in batches to web server for processing, through API tickets, and created stored procedures and database views to collect the results.
  • Verified data with inner and outer table joins and performed base-line comparisons.
  • Linked Excel sheets with the relational databases and perform conditional formatting to extract and present data in a user-friendly Report format for analysis.
  • Ensured that HealthCare Claim Reimbursement Applications performed according to the CMS standards and guidelines, in a distributed environment with diverse databases such as Oracle, SQL-Server, Access and Excel.
  • Utilized Data-Pump/TOAD/SQL-Loader/bulk-copy to make structures/data of SQL-Server database compatible with Oracle database.
  • Performed installations, backups and restoration of relational databases.
  • Manually installed Web Applications / Databases and Utilized Octopus/ Tentacle for Automated web-server deployments.
  • Utilized and maintain virtual machines in a hypervisor environment.
  • Installed IIS Web Server/ Web Service/ Web site, Web Client.
  • Installed SQL-Server (create static and dynamic databases and logins), Message Queuing Service (MSMQ Server install and uninstall), Pricing Engine (Back-End Processes installation and creating connection strings with the databases).
  • Created Test Procedures and placed them in appropriate directories to assist team members.
  • Clarified client requirements, business needs and project objectives in team meetings.
  • Utilized user-stories, code, and logic flow diagrams for black box and white box testing.
  • Designed and executed QA procedures for HealthCare web applications
  • Provided Process Improvement and Automating testing practices.
  • Verified Workflows through MSMQ message ID’s and Correlation ID’s.
  • Utilize VAULT and Target Process for user-stories, tasks, bug reporting, and test management.
  • Extensive Test Case Design and execution based upon user-stories.
  • Created customized-models to suppress the default behavior of the enterprise application.
  • Identified and reported flaws/improvement areas and made recommendations.
  • Trained, assisted and mentored junior staff.

Technical Environment: Selenium/Eclipse, Agile Scrum, MS Excel, SQL, Oracle, SQL-Server, Target Process, TOAD, SQL Loader, Bulk Copy, VMWare

Senior QA Analyst

Confidential

Responsibilities:

  • Provided services to clients such Home Depot and Holt Renfrew Ecommerce Retail Web Application, in Agile Scrum framework.
  • Technical areas involved Custom websites, Catalog Browsers, Flyers and posters for retail clients.
  • Transformed business requirements into functional requirements.
  • Assisted PM in creating project plan and weekly report template, demonstrating work progress, with achieved milestones and timelines.
  • Incorporated Accessibility requirements and testing in the application.
  • Performed mobile and cross browser compatibility testing using 6 different browsers.
  • Performed functional and non-functional testing.
  • Extensive Test Case Design and execution based upon wireframes and requirement documents.
  • Performed integration, system, interface, regression and production testing.
  • Utilized SOAP UI for web services X-PATH verifications.
  • Utilized Selenium web-driver with Eclipse for browser automation.
  • Utilized Selenium for data-driven testing / Eclipse (Java) to automate testing practice.
  • Incorporated IE driver and Chrome Driver for multiple browser automation testing.
  • Wrote Java classes that picked up parameters from excel sheets to automate web applications.
  • Incorporated Selenium (external Jar files) along with JDK jar files to utilize classes and functions for automation.
  • Incorporated Apache POI jar files to manipulate excel rows and columns for data driven testing using Selenium.
  • Communicated with internal and external teams on functional requirements of GUI, screen and interface design.
  • Performed research on J2EE based B2B e-commerce enterprise retail applications.
  • Clarified client requirements, business needs and project objectives in team meetings.
  • Identified and reported flaws/improvement areas and made recommendations while comparison with competitors.
  • Created Test Cases and Use Cases based upon wireframes and requirement documents.
  • Incorporated alternate flows in use cases.
  • Performed systems testing, wrote regression testing scripts using Rational FT, QTP.
  • Utilized VMware for additional IE browser testing.
  • Utilized Bugzilla/JIRA for test management, and MS Visio for workflow diagrams.
  • Compiled business requirements while collaborating with marketing department and utilizing wireframes.
  • Trained, assisted and mentored junior staff.

Technical Environment: Selenium, Apache, Eclipse, Agile Scrum, QTP, MS Excel, SQL, JIRA, Java, JQuery, Ajax, VMWare

Senior QA Analyst

Confidential

Responsibilities:

  • Gathered requirements and created functional requirements based upon Business Requirements.
  • Developed test cases and test data based upon customer requirements and implementation specifications.
  • Developed Test Plan (scope, test-deliverables, item pass/fail criteria, techniques and specifications) for telecom middleware (BSS/OSS), three-tier J2EE application.
  • Established and documented all possible business scenarios, and negative testing.
  • Incorporated messaging rules for client programs and middleware services.
  • Wrote Unix K-shell scripts for regression and load Testing.
  • Wrote Unix K-shell scripts by Placing land line and cable provisioning transactions in a loop to see at what point the system breaks.
  • Wrote Unix K-shell scripts for regression testing by placing transactions in a logical manner to see the provisioning takes place for inserts updates and deletes.
  • Set-up test environment by installing the tar files on Unix Sun Solaris platform.
  • Ran Unix scripts to create Oracle database schemas, tables and to populate the tables.
  • Utilized SQL DML for database clean up procedures.
  • Configured Unix environment to access the desired Oracle database instance.
  • Performed Black-Box component, integration and systems testing using test drivers/stubs.
  • Wrote Korn shell scripts for Regression and Load testing.
  • Generated test summary reports, using MS Access, expressing expected test results Vs actual results, unresolved and closed issues.
  • Identified and documented any unresolved issues in the defect tracking system.
  • Notified developers of necessary changes or bugs.
  • Utilized Test Director for test cases design, execution and defect management.
  • Modified existing test cases as per End-User-Requirements.
  • Escalated and resolved defects by assigning and interacting with development and configuration teams.
  • Methodically documented all details while reporting or interacting with SME’s.
  • Performed Smoke and Regression testing for all new bug fixes, enhancements and release-cycles.
  • Performed Security and Performance Testing on all new application versions and test environments.
  • Participated in upgrading of Test Director to HP Quality Center.
  • Participated in risk analysis of Integrated Broadcasting Management application.
  • Participated in preparing Test Summary Reports, after each regression and smoke test cycle
  • Executed change requests.

Technical Environment: C++, Java, Oracle, Unix, MS Excel, SQL, Test Director 8.0, HP QC9, Citrix

Hire Now