Engineer Data

Mizanur R Bhuiyan ***.********@*****.***

Chantilly, Virginia 202-***-****

An experienced software testing professional with strong research and analytical skills. Enthusiastic and dedicated IT Professional with 8 years of diversified experience in Application Testing, Backend Database testing, UAT testing as a QA Engineer/QA Analyst. Working experience in Waterfall and Agile Scrum methodology and involved in all different phases of SDLC and STLC process.

Summary of Tools and Process used:

Tools: HP ALM/QC, JIRA, Confluence, Soap API, SoapUI, HP UFT, Vision.

Programming Language: Java, JavaScript, C, C++, C#, VBScript, .NET, HTML, XML, SQL, PL/SQL

Databases: MS Access, MS SQL Server, ETL, PL SQL, Oracle, MYSQL, DB2,

Operating Systems: Windows, LINUX, UNIX

Bug Reporting Tools: ALM, JIRA

Document System: LAN, SharePoint, JIRA Confluence, MS Office Suite- Word, Excel, Notepad, MS Visio

Document Management Platforms: SharePoint, ClearCase and OneDrive

Network: - TELNET, HTTP, TCP/IP, VPN, LAN

Team Communication tool: -Cisco-Jabber, WebEx

Technical Skill Summary:

Experienced in Business Documents Analysis, Quality Assurance and Software Testing in various types of domains.

Experienced in Test plans, Test cases, Test Design, Test Execution for Application, Metrics Reporting and Traceability Matrix.

Proficient in the complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle (BLC) and Business Analysis.

Strong knowledge in Smoke Testing, Black Box Testing, Functional Testing, Integration Testing, Regression Testing, System Testing, UAT and Section 508 compliance testing.

Highly experienced in database concept such as create table, views and ETL process, manage, extract, manipulate data for various types of data sources.

Have strong ability to create SQL scripts for backend database testing.

Efficient in handling Change Requests and documentation.

Experienced with HTML, XML data validation (XPath Assertions) and SOAP Payload validation using SOAPUI and XML Formatter utilities.

Experienced in defect management, defect analysis and defect reporting using HP ALM/Quality Center and JIRA.

Highly experienced in creating test plans, test cases for ACSS and POS applications for the retail business and telecommunication business, to develop and support the CMS and DMS System.

Good Knowledge in developing Manual Test case using JIRA and HP ALM /Quality Center.

Experienced in uploading test cases and defect reports in JIRA and update the work status of the project.

Highly experienced in SQL for data verification and suggestions given to the respective teams for tuning the application.

Skilled in Automation Testing of web-based application and client server using UFT.

Good knowledge in Automation Test scripts for downloading Forms and Disclosure documents by using QTP/UFT.

Strong knowledge in conducting functional and regression testing by using UFT to integrate application client-server software work products.

Efficient in conducting Final inspection, Contract reviews, sign off reporting and approval of project metrics used in teams.

Excellent communication and presentation skills, self-starter, quick learner, team player.

Excellent analytical and problem-solving skills.

Professional Experiences:

Company: Marriot HQ, Bethesda June 2019 –Current

Position Title: QA Analyst.

Working as a QA Analyst to develop and test for integration and implementation of Marriot Bonvoy Application. Adaptation of a result driven approach in quality Optimization for dynamic support such robust capabilities to ensure that the Marriot Bonvoy credit card member service remains with full potential.

Attending daily scrum, Core hours, Sprint Planning, Sprint review, Retrospective and test case review meeting with the business client.

Developing and executing the plan for functional, Integration, regression and End2End testing.

Performing Manual Testing for the EDI transactions.

Testing and validating Bonvoy members Billing, Claim Processing and Member module.

Reviewing the functional requirements, requirement analysis and convert it to detail test case and test scripts.

Working with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements mapping transformations.

Creating Test Plans and test scripts, executing test scripts, and writing Test Report with test evidence in JIRA.

Plan, documentation and testing extensive data integration process (PL/SQL) in support of financial security reference data.

Implemented effective data quality testing standards, verification procedures and tools

Defect Reporting, Analyzing, Tracking and Report Generation using JIRA and Confluence project management tools.

Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)

Developed inline view queries and complex SQL queries and improved the query performance for the backend data validation test.

Work Environment: JIRA, Confluence, SharePoint, SQL database, DB2, SQL Script, PL-SQL, Java and HTML, XML, Microsoft Office Suite, Notepad, Windows, AWS Console, Skype Business.

Company: Freddie Mac, Virginia Aug 2018 –May 2019

Position Title: Quality Assurance Analyst

Worked as a Quality Assurance Analyst in Agile Scrum methodology to develop a new System SLA (Service Loan Application) under IRCI (Investors Request Change Initiatives) project for Freddie Mac Mortgage Company to enhance the communication and tracking the Freddie Mac owned loan status reported by the Servicers. The application mainly provides convenient access to Freddie Mac System tools and data for the investors and default reporting needs.

Key Responsibilities:

Working to develop the new application modules for IRCI Project.

Analyzing the system requirements and developing the detailed Test Plan.

Creating test plans, test scenarios and test cases following the requirements from IBM Rational Doors.

Involved in test plan and test case review meeting with the clients.

Created test plan and test scripts to validate the functionalities of loan calculation for Single Loan and Bulk loan submission.

Designed test cases for different modules of SLA application, reviewed and executed the test cases.

Attending daily status meeting and weekly space holder meeting with the team manager.

Performing Manual Testing to check and validate the functionalities of different modules in SLA application.

Execute the test cases and creating test evidences by collecting the test scenario screen shots and upload the evidences to LAN and Sharepoint.

Developed Test Script for Functionality, Security, Regression and UAT testing.

Validating the test result in backend data table by using SQL quarries. Also checking and validating data, reports availability in DB and NAS.

Performing Defect Resolution and Maintenance using HP ALM and sharePoint.

Created test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing

Identified the Test requirements based on user requirements and design specifications using HP ALM.

Performed regression testing for every modification in the application and new builds.

Working to automate the test using Selenium Java WebDriver tool.

Environment: Agile, Scrum, AWS, ALM, IBM Doors, SharePoint, LAN, SQL Server, Oracle SQL Developer, HTML, MS Office, Note Pad, Sysco Jabber, WebEx.

Company: Verizon, New Jersey Nov 2017 – Jul 2018

Position Title: - QA Engineer

Responsibilities:

Worked as a QA engineer in developing CMS (Customer Management System) and DMS (Decision Management system) System to support the implementation and integration of existing POS and ACSS applications for the newly developed PEGA System.

Created Test Plan, Test cases and effort estimation by analyzing the Business requirement documents and use cases.

Analyzed functional requirements and provided a structured approach to all phases of testing cycle.

Performed Functional, Integration, System, UAT, Back end and End to End testing to cover all types of business scenarios.

Executed functional Test scripts and logged defects in Quality Center and JIRA.

Reported and managed software defects using ALM, JIRA and interacted with the developers to resolve technical issues.

Involved in extensive DATA transaction, availability, Security and data validation check using SQL queries.

Performed data flow, availability and validity check through using VISION data tool.

Executed XML data validation through retrieving XML and SOAP validation using SoapUI and XML Formatter utilities and API Web Service testing.

Created scripts to develop the automation Frame Work in UFT.

Used UFT for defect reporting and tracking and prioritizing defects and enhancement requests.

Worked closely with the BA for detail analyzation and understanding of BRD and development team to ensure the application performance and stability to ensure the application completes the whole end-to-end process.

Participate in Sprint planning meeting, daily Scrum (stand up) meeting, Sprint review meeting, weekly status meeting with Development and Management Teams.

Excellent team leading capabilities and communication skills to interact with the customer teams as well as internal teams.

Environment: Agile, JIRA, Confluence, ALM, Web Service, SoapUI, VISION Data Tool, SQL Server, Oracle SQL Developer, JavaScript, HTML, MS Office, Sisco Jabber.

Company: CareFirst, Washington, D.C. Jan 2015 – Oct 2017

Position Title: Quality Assurance Analyst

Worked as a QA Analyst for premier and diversified health benefits and Information system that provides innovative products, services, and technologies to improve the availability, quality, and cost of health care. The application used Facets for managing and processing healthcare claims. As a, QA Analyst have been involved in various kinds of testing of the Facets application modules like- Enrollment, Membership and Claims.

Key Responsibilities:

Analyzed system requirements and developed detailed Test Plan.

Performed Manual Testing for the EDI transactions.

Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.

Work on coordination of benefits (COB) in a claim processing.

Developed Test Script for Functionality, Security, Regression and UAT testing.

Performed Back-End Testing to check database integrity by writing SQL queries.

Set claim processing data for different Facets Modules.

Tested HIPAA regulations in Facets HIPAA privacy module.

Identified the Test requirements based on user requirements and design specifications using HP ALM.

Performed Defect Resolution and Maintenance using HP ALM.

Used the Descriptive Programming approach for developing Test Scripts using UFT.

Worked with various functional and regression test using UFT.

Enhanced automation scripts to maximize test coverage and improved test efficiency in Data Driven Testing using UFT.

Performed regression testing for every modification in the application and new builds using UFT.

Created test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing purposes.

Worked in ETL tool for data extraction, migration and analysis of business OLTP data for Data Warehouse.

Prepared and maintained the Test Matrix, Requirements Traceability Matrix.

Participated in release and Retrospective session.

Extensively worked on any requirement upgrade and/or change request in the UAT environment.

Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end-to-end process.

Have knowledge and experience working on section 508 testing.

Participated in weekly status meeting with Development and Management Teams.

Work Environment: Agile SCRUM, HP ALM, MS Office Tools, HP Quick Test Pro, HP UFT, Windows XP, Facets, MS SQL, SSIS, ETL.

Company: Best Buy, Richmond, VA Oct 2011 – Dec 2014

Position Title: QA Engineer

Worked as a QA Engineer to develop and test for initial integration and implementation of POS System. Adaptation of a result driven approach in quality Optimization for retail sales support such robust capabilities to ensure that the POS deployments attain with full potential.

Key Responsibilities:

Job operated within a very agile environment, employing 2-week sprints, daily scrum meetings, burn-down charts, task weighting, pair programming, refactoring, presentations and review.

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Developed and executed functional, integration, system, UAT enhancement changes to the POS System.

Actively participated in enhancement meetings focused at making the application more reliable.

Worked in Agile SCRUM methodology with frequent releases.

Created SQL Queries to extract data from various data tables for testing purpose.

Extensively used SQL statements to query the SQL Database for Data Validation and Data Integrity.

Export and Import to and from OLTP data for Data Warehouse.

Documented the Bugs and generated status reports and Bug reports and presented that in weekly status meetings using HP ALM.

Leading and managing User stories and providing guidance and assistance to the QA team to carry out the test cases management for the Sprint efforts.

Performed all aspects of verification, including functional, regression, smoke, sanity and system testing.

Used VB Script & Descriptive programming to develop Data Driven Framework in UFT.

Involved in Regression and System testing of the application using UFT.

Reviewed the UFT Scripts developed by the team members.

Performed Bulk import job in regular basis.

Follow up with UAT Users of any defect / requirement related issues, identify, classify and add more information to better track defect.

Performed negative and positive testing for the application manually and automation.

Prepared QA sign off documents in close proximity with the Project Manager, Developers and QA team.

Work Environment: HP ALM, JIRA, E-Commerce, POS, SQL database, SQL Script, Soap UI, Java and HTML, XML, Microsoft Office Suite, Notepad, Windows.

Education and Certifications:

Bachelors and Masters in Geography from University of Dhaka

Diploma in CIS (Computer Information System), Strayer University, Washington DC

GIS Certification, George Mason University, Virginia

Security Clearance: Clearable

Location Preference: Northern Virginia, DC, Southern Maryland.

References Available upon request

Contact this candidate