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 AnalystConfidential
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