Post Job Free

Resume

Sign in

Quality Assurance Sql Server

Location:
Aldie, VA
Posted:
December 18, 2023

Contact this candidate

Resume:

Azhar Iqbal

US citizen

Active secret clearance

Active MBI clearance

ad119j@r.postjobfree.com

703-***-****

Summary:

Over 15 years of experience in the field of Quality Assurance Engineering/QA Tester/QA Advisory/QA Analyst on Web, Client/Server, Mainframe and media based technologies.

Experience in creating test cases and test plans and, implementing them using manual and automated testing skill.

Thorough knowledge of Testing life cycle, Black box and White box testing.

Very good knowledge of databases like Oracle and SQL server. And also proficient in database testing on UNIX and Windows environment by writing complicated PL/SQL queries.

Developed software test plans and executed test cases various platforms and technologies.

Very good knowledge on Win Runner, Load Runner, Quickest Pro,

In depth experience in Functional, Regression, System, Load/Performance and UAT testing. Test Director.

Excellent knowledge experience in database administration, implementation and production support, performance monitoring, data and user security, Software Testing Tools and development tools.

Expertise with Rational Tools/PARASOFT SOA/Load Test Tool for functional and performance Testing.

Possess outstanding communication skills, resulting in excellent rapport with employees, peers and executive management

Technical Skills:

Operating Systems

MS-DOS, Windows technologies, UNIX, Solaris and AIX.

QA Tools

Win Runner 8.0, Load Runner 8.1, Quick test Pro 9.2, Quality Center 9.0, Rational Test manager, Clear quest, RFT

Languages

PL/SQL, Java, HTML, DHTML, XML, TSL, Java script and VB script.

Tools

Visual Basic 6.0, ASP 3.0, .Net, Developer 2000.

Database

MS SQL Server 2000, Oracle 8i/9i/10g, MS Access 2.0/3.0 and DB2

Web servers

Apache, BEA Web logic 8.1, Web sphere 6.0

Multi media

Macro media Flash

MS Office

MS Word, MS Excel, Power Point, Microsoft Access

Domain

Finance, Insurance, Multimedia

Education

Edith Cowan University - Perth, Australia 2001

Master of Science in Information Technology

BSC Engineering. 1998

Salesforce Admin certification

Professional Experience:

Client: DOD-VA Feb ’23-Current

Senior QA Engineer

IPPS A systems works on soldiers data validation from upstream and downstream systems. Transfers of soldiers and their duty positions.

Regression testing using selenium

Execution of test cases

Scripting of test cases

Building framework

Running ETL for loading data

Reusable of automated test cases

Parameterizing of test cases

Environment : Selenium, UNIX, ALM, Confluence, JIRA

Client: IRS-MD Dec ’21-Feb’23

Senior QA Engineer

1099 forms testing using web services. Using XML and sql to validate forms for year 2022.

Back end testing using ETL

Validations on source to target files

Writing sqls

Writing and running test cases

Running ETL for loading data

Stored and updated data in the database and data masking

Developed and modified data mapping, data flow and data stage.

Environment : SQL Developer, UNIX, ALM

Client: Census bureau -MD Nov’16-Nov'21

Senior QA Engineer

Worked on IVR, CRM testing both front end and backend. Ran ETL jobs and verified data at the backend. Tested External interface for testing.

Back end testing to warehouse using shell scripting

Web services using SOAP and REST services

Documenting defects in RTC, 508 testing for UI for handicap customers.

Tested Amazon EC2Virtual Servers in the Cloud. UAT testing with end users

Validated Amazon Elastic Container Service Run and Manage Docker Containers. Amazon S3Scalable Storage in the Cloud.

Amazon Aurora High Performance Managed Relational Database.

AWS Application Discovery Service Discover On-Premises Applications to Streamline Migration. Running ETL for loading data from source to target tables. Ran jobs in UNIX for data transfer

EI testing for flat files validated data through data mapping. Troubleshooter ETL issues

Wrote SQL for target table validations and did data mapping. Validated data from source tables.

Backend data validation for agents and calls data through writing SQL queries.

Environment: DOORS, RQM, RTC, Salesforce Admin, SAS, JAWS, SIP call generator, SQL developer, UNIX

Client: IRS -MD Aug ’12-Dec’16

Senior QA Engineer

2012- 2014 ACA project which deals with eligibility of low income families. Lot of ETL process was involved in order to get data from backend. I Worked on ETL, API and Databases. Lot of web services testing was involved which included performance testing too.

2014- Current Worked on RRP for processing withholding agents copy and comparing with IRS copy. Running ETL for comparing matching data and flag records for suspicious activities. Testing rejection codes when comparing both copies. Loads live data through ETL from IPM.

Back end testing to warehouse using shell scripting

Documenting defects in KISAM . UATtesting and validations.

Mainframe testing using TSO CICS

Running ETL for loading data from IPM

Stored and updated data in the database, automation and data masking

Developed and modified data mapping, data flow and data stage according to system requirements. Worked on ETL for data transform logic in output table

Performance testing using LOADRUNNER with other teams

Worked with DOORS Quality center for requirements documents and writing test cases. Mapping of test cases with the requirement documents

Analysis of performance testing results and giving inputs

XML transactions and tested groovy scripts. Used RFT for automation of backend data comparison.

Performance testing for analysis of reports and putting load on servers to catch break points

508 testing using JAWS for finding issues on UI which are not compatible for handicap customers. All labels, images names, tables should be in UI.

Experience with ETL INFORMATICA tool to extract data from production and load into data warehouse. Checking log files from INFORMATICA.

Conducted day to day meeting in order to improve the process of testing

Wrote test plans and test scripts according to the requirement

XML transactions. Used JIRA for defecting tracking and agile process.

Worked on Z/Linus on mainframe systems

Conducted day to day meeting in order to improve the process of testing

Environment: DOORS, TSO, REQ pro, JIRA, Clear case, CLEARQUEST, ORACLE 11i,, JCL, UNIX, XML, PL/SQL, J2EE, JSP, Web services,DB2, SOA, FICO blaze, SAS, Client/Server, SQL, LOADRUNNER, Agile, INFORMATICA, Selenium, GREENPLUM, CICS, Control M, RFT, Clearquest, Test manager,

Client: Sallie Mae, Reston -VA Aug ’11-August ‘12

Senior QA Engineer

Project was based on student portal where student can pay bills, view online bills and can schedule bills. There were batching processing of bills and refunds to school sites. Student enrolled for different academic years and can pay tuition fee online.

Responsibilities:

Back end testing to warehouse using shell scripting

Documenting defects in Quality center

Stored and updated data in the database

ETL testing for data warehouse and UAT testing. Used PL/SQL for inner and outer joins

Developed and modified data mapping, data flow and data stage according to system requirements. Worked on ETL for data transform logic in output table

WCAG testing to make it compliance for handicap users

Testing of student Web portal where student can enroll for bills and can schedule bills

Involved in Testing Web services using SOA automatic Test tool (Parasoft).

Involved in Load testing using SOA test tool

Automation using QTP. Ran scripts using QTP, modified and made reusable. Call actions using global sheet

Used parameterization and checkpoints for automation using QTP.

Worked with DOORS Quality center for requirements documents and writing test cases. Mapping of test cases with the requirement documents

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro. Tested student federal aid system

Parameterized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Web Services testing using SOA tool and make sure all web services are up and running and communicating with other machines.

Tested web services for HTML protocol

Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests using QTP.

Synchronized Tests to handle the anticipated timing problems using Load Runner.

Created VB Script library files containing VB Script functions, subroutines, classes, modules to associate the files with the test

Scale testing using SOAP

Worked with Object Repository to parameterized the dynamic link and work with the ever changing screen names using Regular Expressions.

Synchronized Tests to handle the anticipated timing problems using Load Runner

Wrote and enhanced VB Scripts to validate the application by inserting checkpoints, conditional statements, and functions.

Synch software and made test plans and test cases for wireless connection of mobiles

Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.

Worked on LINUX

Functional, Regression, unit testing. Testing API for web services

Attended Risk review meetings

Used Quality center service test for defect tracking and execution of test cases

Used SQL for sending queries to database at the back end

Performed UAT testing for data ware house with business objects

Validated different stages of claim processing

Performed Data Driven testing to test different sets of positive and Negative Data

Manual testing for different interfaces

XML transactions

Worked on Share Point

Conducted day to day meeting in order to improve the process of testing

Wrote test plans and test scripts according to the requirement.

Ran automated scripts for regression testing

Wrote test plan, test strategy document and scripts according to requirement

Experience with ETL INFORMATICA tool to extract data from production and load into data warehouse.

Mainframe testing using batch files running overnight process

Mainframe testing for cash disbursed department

Mainframe testing for account activation and checking balances.

Performed UAT testing

Validated IMS transactions taking place from one tier to another tier.

Environment: DOORS, Clear case, ORACLE 11i,, JCL, UNIX, XML, PL/SQL, J2EE, JSP, Web services,DB2, SOA, Client/Server, SQL, INFORMATICA, Quality center, Agile, Quick Test pro, AUTOSYS, TFS

Client: USDA, VA Jan ’11-Aug’11

Senior QA Engineer

Project is about forest service maintenance application. Granting proposals and agreements. Taking care of billing transactions and track records. Maintenance of roads and trails in the forest. Working on grants and agreements applications.

UAT testing done for end users. Created defects and got fixed before it goes to production

Heavy SQL testing using joins and functions

Getting data from few tables by using inner join and outer join

Used wild cards, order by, group by functions using SQL for back end testing

Worked with Quality center for requirements documents and writing test cases. Mapping of test cases with the requirement documents

Validation from back end using SQL for ETL process

Tested different ER

Tested oracle forms and jasper forms

Tested NRM application for account balances and for different triggers coming from FFATA tab and monitoring tab

Tested excel reports

Environment: Quality Center, ORACLE 10,, JAVA, Client/Server, SQL, Agile, XML, Quick Test pro, TOAD, RFT, Autosys, TIBCO

Client: Fannie Mae, VA June ’10- Dec’10

Senior QA Engineer

Project is about loan processing from different stages. Verification of documents from lender to routing to different locations for processing. Tibco BW is used with SOA services at the back end. Stand alone and client server application are involved in the entire process of loan and mortgage processing.

QTP used for automation.

Automation using QTP. Ran scripts using QTP, modified and made reusable. Call actions using global sheet

Used parametrization and checkpoints for automation using QTP.

Created test cases for UAT testing and performed UAT testing after functional testing

Heavy SQL testing using joins and functions for ETL process

Developed and modified data mapping, data flow and data stage according to system requirements

Functional,regression, integration, unit and smoke testing

Getting data from few tables by using inner join and outer join

Used wild cards, order by, group by functions using SQL for back end testing

Worked with Quality center for requirements documents and writing test cases. Mapping of test cases with the requirement documents

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

RTM is used to map test cases with requirements

Environment: Quality Center, DOORS,ORACLE 10,, JAVA, Client/Server, DATA Model, SQL, Agile, XML, Quick Test pro, TOAD, Autosys, TIBCO, TFS

Client: MASTERCARD, MO June ’08-June ‘10

Senior QA Engineer

Project was based on credit card transactions, dispute of charges, fraud claim and billing system. Transactions comes from different networks like MDS, Elan etc. Mainframe system is used for event tracker and accounts activities. Transactions history is maintained in Payment manager and portfolio viewer is used to see user accounts and dispute processing. Exception processing is used for dispute management. Worked on COTS application which been modified for different financial institutions.

Responsibilities:

QTP used for automation with Mainframe systems.

Automation using QTP. Ran scripts using QTP, modified and made reusable. Call actions using global sheet. Created API functions.

Used parametrization and checkpoints for automation using QTP.

Heavy SQL testing using joins and functions

Testing of Web portal for different clients using API functions

Getting data from few tables by using inner join and outer join

Used wild cards, order by, group by functions using SQL for back end testing

Worked with Quality center for requirements documents and writing test cases. Mapping of test cases with the requirement documents

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Web Services testing using SOA tool and make sure all web services are up and running and communicating with other machines.

Tested web services for HTML protocol

Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests using QTP.

Synchronized Tests to handle the anticipated timing problems using Load Runner.

Created VB Script library files containing VB Script functions, subroutines, classes, modules to associate the files with the test

Documenting defects in Quality center

Stored and updated data in the database

Mainframe testing using TSO and CICS

Exception processing for dispute handling

Portfolio viewer is used to create disputes and view transactions.

Developed and modified data mapping, data flow and data stage according to system requirements

Functional, regression, integration, unit and smoke testing

System Testing, Integration Testing, SOA Para soft, UAT, White box and Black box testing.

Created test plan, test cases and test strategy document

Validation in Payment Manager for transactions

Validation in mainframe using TSOC and CAMS screens

Test plan walk through

Estimation of test cases

Test results walk through with business team

Testing of DEBIT credit, ATM and prepaid card transactions

Used Test Director extensively for Requirements, Test planning, and Defect tracking. TSO, File Aid, Access used for application testing

Communicated with Developers regarding technical issues

Testing of billing and reports

Worked on web services integration

Environment: Quality Center, Hummingbird, TSO, CICS, ORACLE 11i,, JAVA, MVS Mainframe, Clear quest, UNIX, PL/SQL, J2EE, JSP, Client/Server, DATA Model, VISIO, SQL, Agile, XML, COTS, SOA, Quick Test pro, TIBCO

Client: Chicago Public Schools, IL August’07- June ‘08

QA Analyst

The application includes functional testing of CPS, which was web-based application. SQL Server was used as back end database. This application was used for all schools in Chicago. Website contains Student demographic information, School attendance, and registration, Enrollment, Schedules, and Reports Etc. Automated more than 75% of application within one year time frame.

Responsibilities:

Back end testing using SQL and Business objects

Plan how to do Regression, functional and smoke testing

Automated application using QTP also used selenium for automation using web methods and web drivers using Junit

SOAP testing

Web Services testing using SOA tool and make sure all web services are up and running and communicating with other machines.

Tested web services for HTML protocol

XML testing for front end

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests using QTP.

Synchronized Tests to handle the anticipated timing problems using Load Runner.

Involved in Testing Web services using SOA automatic Test tool (Parasoft).

Tested the SOA/SOAP requests and SOA/SOAP responses using Parasoft SOA Test

Using SOA Test tool executed 55 Business services including WSDL Validations, Functional, Security and Load testing.

Worked with Object Repository to parametrized the dynamic link and work with the ever changing screen names using Regular Expressions.

Synchronized Tests to handle the anticipated timing problems using Load Runner

Wrote and enhanced VB Scripts to validate the application by inserting checkpoints, conditional statements, and functions.

Synch software and made test plans and test cases for wireless connection of mobiles

Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.

Used UNIX for back end testing

Worked with MW in order to get requirements for test cases

Black box testing

Web based testing of Schools

Back end testing using ETL tool Data stage

Load testing

Testing if web services using SOAP with UI

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Wrote test plans and test scripts according to the requirement.

Ran automated scripts for regression testing

Mainframe testing for different accounts

Conducted Security testing, Functionality, Interface, User Accepting Testing Integration testing and Gray Box testing during the various phases of the project.

Implemented the whole life cycle of QA Methodology starting from Planning, Capturing, Creating, Executing, Reporting and Tracking the defects

Environment: SQL Query Analyzer, Clear case, SOA, DOORS,UNIX,RUP, Quality center9.2, Quick Test Pro, and Load runner, ORACLE, HTML, SOAP, XML, MVS Mainframe, Clear quest, Crystal reports, Client/Server, Web services, DATA Model, JSP, SDLC, DB2, TSO, CICS, K shell, Data Stage, JCL

Client: Direct TV, LA Sep’06-August’07

QA Software Engineer/Analyst

Performed Manual and automation testing using mercury tools. Interacting with team and reporting defects. Attended meeting with developers and business team for walk through sessions. It was web based application which contains programming and hardware selections.

Responsibilities:

Created and implementing Test plans and Test Cases as per the business requirements using web environments and Green Screen.

Web Services testing using SOA tool and make sure all web services are up and running and communicating with other machines.

Tested web services for HTML protocol

Automation testing using QTP

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests using QTP.

Synchronized Tests to handle the anticipated timing problems using Load Runner.

Created VB Script library files containing VB Script functions, subroutines, classes, modules to associate the files with the test

Scale testing using SOAP

Worked with Object Repository to parametrized the dynamic link and work with the ever changing screen names using Regular Expressions.

Synchronized Tests to handle the anticipated timing problems using Load Runner

Wrote and enhanced VB Scripts to validate the application by inserting checkpoints, conditional statements, and functions.

Synch software and made test plans and test cases for wireless connection of mobiles

Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.

Developed Test plan and test strategy document

Conducted the Functional, System, Integration, Regression, Usability, and Performance testing of the application using Rational Robot.

Analyzed user requirements, attended change request meetings to document changes and implemented procedures to test changes.

Scripting with VU Gen

Black box testing

Web services testing using SOAP with UI

Worked with MW for implementation

Mainframe testing for log in validations

Mainframe testing using JCL

Back end testing using SQL and UNIX SOLARIS

Conducted Security testing, Functionality, Interface, User Accepting Testing Integration testing and Gray Box testing during the various phases of the project.

Tested the application manually and by using Rational Robot.

Extensively involved in scripting and enhancing of SQA Basic scripts related to this project.

SOAP testing for production

Punch In using XML for different requirements

Inserted different types of Verification points to capture and store information about the objects.

Used Quick test Pro for Functional and Regression testing.

Created a program for Data Loading Process to interact with different pages in AQUA in a Sequence and report any errors if occurred using black box testing.

Applied logic to capture the error messages for Data Loading process and the steps to recover when a particular error occurred. Also worked on Mainframes.

Used Parasoft SOA tool for testing of web application services tested in different web services in order to make sure the services are up and running also involved in installation of SOA tool.

Wrote functions to export the output value, error messages, the status of a particular script with date and time to Excel file for reporting purpose and for further reference.

Performed extensive data driven test for large data.

Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro

Parametrized Steps, Checkpoints and Variables in the script to run the test on multiple sets of data.

Web application testing

Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests using QTP.

Synchronized Tests to handle the anticipated timing problems using Load Runner.

Created VB Script library files containing VB Script functions, subroutines, classes, modules to associate the files with the test

Scale testing using SOAP

Worked with Object Repository to parametrized the dynamic link and work with the ever changing screen names using Regular Expressions.

Synchronized Tests to handle the anticipated timing problems using Load Runner

Wrote and enhanced VB Scripts to validate the application by inserting checkpoints, conditional statements, and functions.

Synch software and made test plans and test cases for wireless connection of mobiles

Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.

Wrote scripts to perform basic Sanity Testing.

Used Test Director extensively for Requirements, Test planning, and Defect tracking. TSO, File Aid, Access used for application testing

Environment: ASP.NET, VB.NET, HTML, XML Crystal Reports, STL, J2EE, XML, SQL Server 2000, Windows XP, IIS, Quick Test Pro 8.0, Quality Center 9.2,UNIX, Load Runner 8.1, RFT and MS Visio, SOAP, K shell, Web services, CICS, TSO, SDLC, Data Stage, DB2, Client/Server, SPUFI/platinum, MVS Mainframe,DB2



Contact this candidate