Sr. QA

TARIQ FIDA

*****@*****.***

***** ******** ****, **********, ** 20874

Tel: 571-***-****

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).

EDUCATION & TRAINING

1995 Bachelor of Science in Electrical Engineering

(Computer Engineering Minor) California State University - Fullerton, CA

1998 Object Oriented Programming Seneca College – Toronto, ON

1998 Computer Operating System (Unix) Seneca College – Toronto, ON

2000 Diploma in Database Development

(SQL, PL/SQL, Forms, Reports) University of Toronto – Toronto, ON

2000 Oracle Database Certified Professional (OCP) - Toronto, ON

TECHNICAL SUMMARY

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/Utilities: 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

S and C Electric, Rockville, MD (August 2016 to Present)

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

Edaptive Systems, Columbia, MD (Feb 2016 to May 2016)

Sr. Data Quality Analyst

Evolent Health, Arlington, VA July 2015 to Feb 2016

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

Acentia/MAXIMUS, Columbia, MD Jan 2015 to July 2015

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

Kenna/AQUENT Oct 2014 to Dec 2014

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

TEK Systems/converted to FTE at Burgess Group June 2012 to Sep 2014

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

Nurun Oct 2011 to March 2012

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

From June 1995 to June 2011 (QA / Business Analyst)

Worked for the following Companies in (USA, Canada, Pakistan)

Jabs Solutions / SanMar (Retail)

Cambridge Docs (Online Gaming)

Netsol Technologies (Equipment Financing)

Matrix Resources / Bell South (Telecom)

Global Computer Associates / Delta Dental (HealthCare)

CTV / Randstad (Media)

Celestica Inc. (Electronics Manufacturing)

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

Contact this candidate