Data Engineer

Ahmed Zubair

404-***-**** adkc07@r.postjobfree.com

Resident Status: Permanent Resident

Objective: My goal is to work as an IT professional, applying my six years’ experience in software testing and IT services. I desire a permanent consulting position that will permit me to utilize my diverse technical knowledge, business acumen and professional experience in gathering and analyzing requirements, writing system test cases and test scenarios, preparing test data, executing test cases, developing requirement traceability matrices, documenting software defects and analyzing test results.

TECHNICAL SKILLS

Testing Tools: JIRA, Quality Center, ALM, ClearQuest

RDBMS & Tools: Oracle, SQL Server, MS Access, SQL Developer, TOAD

Languages: SQL, PL SQL, Core Java

ETL Testing: Informetica

Automation: Selenium, TestNG, Cucumber, Maven, Git, Jenkins

Web Service: REST API, Postman

Performance Testing: Jmeter

Operating Sys: Windows NT/2000/XP, AIX, BSD-UNIX, Linux, MS-DOS

Version Control: Visual Source Safe, Dimensions, SVN

Other Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, FTTP tools

SUMMARY OF QUALIFICATIONS

Over six years of experience working as a software Quality Assurance (QA) specialist.

Experience managing a technical team on large and complex projects.

Experience developing the strategy for performing QA, setting up a QA environment and infrastructure and then directing the QA activities of my junior staff.

Proficiency in applying the full Software Development Life Cycle (SDLC).

Experience verifying ETL loaded data from a flat file to Oracle database.

Extensive work with both Waterfall and Agile methodologies.

Experience in database testing using SQL statements in Oracle Databases and Microsoft SQL Servers.

Expertise performing day-to-day operations such as applying software updates and fixes, as well as analyzing production support issues.

Proven skills for developing test strategies, test plans, test cases, test scripts, test procedures and testing standards.

Extensive experience performing various types of testing, including functional, integration, system, smoke, end-to-end, black-box and mobile testing.

Experience applying an understanding of business goals and processes then using this knowledge to develop appropriate testing requirements and a testing matrix.

Experience in manual and automated testing of web-based and client/server applications using Java, Selenium, TestNG, Cucumber etc.

Knowledge of web technologies including basic knowledge of html, css, DOM,

Experience in RESTFULL web service Testing using Rest Assured framework java. Validated JSON formatted data, different http status code like 200, 201, 400, 415, 500etc.

Verified Postman call response in Json formatted data, worked with added test cases and Assertion Using Postman

A strong dedication to business efficiency and product quality.

Ability to handle multiple tasks, work under pressure and handle unforeseen challenges.

Exceptional reliability with strong communication skills.

Extensive work experience with large databases in both development and production environments.

Proven success as a team leader and team member with the ability to effectively motivate staff to achieve high efficiency and product quality.

Experience working with offshore vendors and establishing offshore teams and processes.

PROFESSIONAL EXPERIENCE

NORDSTROM INC.

COLUMBIA MARYLAND

IT Analyst

January 2020 – Present

Lead and support IT System, application, POS systems and database systems. Reporting and analytics were performed using standard Business Intelligence reporting tools, Informatica and OBIEE, which pulled data from EDP oracle transactional and CRM systems.

Analyzed requirements and created test case.

Managing the software tool used to track and report on data and system bugs/issues.

Performed data validation with multiple scenarios.

Performed system analysis and identified solutions to technical problem.

validate nightly loaded data.

Performing weekly data validation using OBIEE and SQL Server.

Performing testing of the new system’s graphical user interface (GUI).

Verifying and retesting the defects after they have been addressed by the development team.

Actively participating in weekly team meetings, database reports meetings, daily checkpoint meetings as well as frequent knowledge transfer sessions.

ECORYS (UK) LTD. LONDON, UNITED KINGDOM

CLIENT: NATIONAL BOARD OF REVENUE BANGLADESH, DHAKA, BANGLADESH

Senior QA Analyst

March 2016 - November 2019

CLIENT: BANGLADESH TAX, Dhaka, Bangladesh

Project: Taxation Modernization - VAT

This project was initiated in response to Bangladesh’s new Value Added Tax (VAT) and Supplementary Duty Act of 2015. The project entailed developing and deploying new automated systems that permit individuals to apply for new registrations and to submit VAT tax returns online quarterly. The new, complex system includes online services, real-time status inquiries, tax reporting and tax status inquiries. I had a very major role in this project, including:

Updating the test set path in Metrics and master regression suites using ALM/JIRA.

Analyzing test results using reports and graphs generated using ALM/JIRA.

Working with Business Analysts and Testers for business rules test case development.

Creating/modifying/maintaining test cases and test scenarios using the appropriate business rules.

Writing basic SQL queries to support the testing effort and verifying anticipated results using MS excel.

Writing complex SQL queries to extract data from the primary database and comparing source and target system data by executing SQL scripts using TOAD.

Performing system test release manual execution for SIR 4.0 Release.

Work with automation team to design and develop automated test suites for the website using Java, Selenium and/or other relevant tools

Develop and maintain an automation framework and scripts to drive quality and efficiency

Used Postman & SOAPUI for rest service testing.

Analyzing the test results and reported defects using JIRA

Analyzing the Business Requirements Specifications (BRS), System Requirement Specifications (SRS), system design, and test methodologies.

Performing progression, regression and back-end testing.

Validating several Database modifications (DBMODs) as required by the developers.

Actively participating in weekly team meetings, database reports meetings, daily checkpoint meetings as well as frequent knowledge transfer sessions.

Environment: Windows 2000, IBM AIX, JIRA, SharePoint, Oracle 11g, OBIEE 11, Informatica 9, Eclipse, Postman, SOAPUI, Internet Explorer, Mozilla Firefox, Chrome.

TRIPPLE C CONSULTING

QA Analyst

June 2014 - February 2016

CLIENT: DHL EXPRESS, Dhaka, Bangladesh

Project: Bid Activity DATA MART

This project entailed designing and creating an Oracle data warehouse system to track DHL’s bids for new business and to track revenue generation from existing customers. Building the data warehouse required that data be extracted from multiple sources and loaded into the Oracle data warehouse in a format suitable for report generation using the Oracle Business Intelligence Enterprise Edition (OBIEE) . My role in this project included:

Ongoing interaction with DHL employees and project teams.

Creating and executing test scripts to ensure that the system fully met the client’s requirements.

Managing the software tool used to track and report on data and system bugs/issues.

Performing integration testing using the most appropriate method for the software module being examined.

Creating test data as needed for executing test cases.

Work with developers to capture development test objects and use in automation testing

Work with automation team to design and develop automated test suites for the website using Java, Selenium and/or other relevant tools

Develop and maintain an automation framework and scripts to drive quality and efficiency

Active participation in the continuous improvement of the automation strategy and framework

Performing project management tasks using the Quality Center tool.

Performing Unit and Integration testing of Informatica Sessions, workflows and target data.

Creating, updating and maintaining DWH testing documentation.

Performing source data analysis and validating target data.

Investigating and resolving data issues.

Performing weekly data validation using OBIEE and SQL Server.

Performing testing of the new system’s graphical user interface (GUI).

Providing consulting and support for CENTER users.

Providing training to district user on the use of various new reports and applications.

Creating training materials for Business Intelligence (BI) reports.

Writing complex SQL queries to validate data with business rules.

Environment: Windows server, ALM, Oracle 11g, Informatica 9, Internet Explorer, Eclipse, Postman, Mozilla Firefox, Chrome, Selenium.

E.GEN LTD. Dhaka, Bangladesh

Software Test Engineer

September 2013 - May 2014

Project: Cigna Healthcare Inc.

This project focused on developing the Electronic Business Center (EBC), which is Cigna's secure web portal. This portal’s function is to provide a 24-hour link for communications between Chicago and various dispersed agencies. In addition to providing a connection for ongoing account specific information, the EBC offers many online services, including quotes, real-time billing inquiries, policy services, claim reporting, and claim status inquiries. My role in this project included:

Working in an Agile QA team to document standard testing procedures.

Executing both individual test cases and the entire test suite, then analyzing the test results against the expected results for each sub-system.

Work with developers to capture development test objects and use in automation testing

Create and maintain automation frameworks

Create/execute/maintain automation scripts

Work with automation team to design and develop automated test suites for the website using Java, Selenium and/or other relevant tools

Working with the QA team to perform sophisticated functional testing, and integration testing.

Generating system tests for numerous test scenarios covering all aspects of the project’s functionality.

Working with the QA team to develop the instructions for the User Acceptance Testing (UAT) as required for non-technical employees.

Working with the QA team to perform regression testing as required to ensure the stability of the application.

Creating and executing SQL queries to ensure that the data are formatted in the database as designed and that all fields are populated correctly.

Performing detailed results analyses after each test execution cycle and maintaining a directory of the test results.

Using ALM to execute the test cases and report all the defects.

Verifying and retesting the defects after they have been addressed by the development team.

Environment: ALM, Windows, HTML, XML, Selenium, SoapUI, Oracle, and TOAD

EDUCATION AND TRAINING

Post Graduate Diploma in Management, Stratford College, London, UK

Master’s in Accounting, National University, Dhaka, Bangladesh

Bachelor of Commerce, National University, Dhaka, Bangladesh

Professional Certificate in Software Testing, IBCS Primax, Dhaka, Bangladesh

Contact this candidate