Quality Assurance Sql Server
Resume:
Azhar Iqbal
US citizen
Active secret clearance
Active MBI clearance
****************@*****.***
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